Slide 1

Slide 1 text

some neutral picture, just a grey background? QIPUPIUUQTXXXqJDLSDPNQIPUPTKBZCMVF 4PMWFDPNQMFYQSPCMFNT "SUVSBT4NPSHVO %%%-POEPO.FFUVQ 'FCSVBSZ XJUI%%%

Slide 2

Slide 2 text


 PGEFWFMPQFST DPEFBTIPCCZ IUUQTJOTJHIUTTUBDLPWFSqPXDPNTVSWFZEFWFMPQFSQSPpMF@DPEJOHBTBIPCCZ

Slide 3

Slide 3 text

5FDI <㾎>#%% 
 


Slide 4

Slide 4 text

5FDI <㾎>#%% <㾎>5%% 


Slide 5

Slide 5 text

5FDI <㾎>#%% <㾎>5%% <㾎>$*

Slide 6

Slide 6 text

5FDI <㾎>#%% <㾎>5%% <㾎>$* <㾎>$%

Slide 7

Slide 7 text


 PWFSBMMTPGUXBSFQSPKFDU TVDDFTTSBUF IUUQTXXXTUBOEJTIHSPVQDPNTBNQMF@SFTFBSDI@pMFT$)"043FQPSU'JOBMQEG

Slide 8

Slide 8 text


 NFEJVNTPGUXBSFQSPKFDU
 TVDDFTTSBUF IUUQTXXXTUBOEJTIHSPVQDPNTBNQMF@SFTFBSDI@pMFT$)"043FQPSU'JOBMQEG

Slide 9

Slide 9 text


 MBSHFTPGUXBSFQSPKFDU
 TVDDFTTSBUF IUUQTXXXTUBOEJTIHSPVQDPNTBNQMF@SFTFBSDI@pMFT$)"043FQPSU'JOBMQEG

Slide 10

Slide 10 text


 HSBOETPGUXBSFQSPKFDU
 TVDDFTTSBUF IUUQTXXXTUBOEJTIHSPVQDPNTBNQMF@SFTFBSDI@pMFT$)"043FQPSU'JOBMQEG

Slide 11

Slide 11 text

SELECT /*+ NOPARALLEL bypass_recursive_check */ SP_ALIAS_190, ((CASE SP_ALIAS_191 WHEN 1 THEN 'PROVIDER :: WHEN 0 THEN 'PROVIDER ::PROV ::' ELSE NULL END) || SP_ALIAS_190) ALIAS_3553, SP_ALIAS_194, SP_ALIAS_191, S SP_ALIAS_193, SP_ALIAS_205, D4_AGE_GROUP_ET, ((CASE D4_AGE_GROUP_GID WHEN 1 THEN 'AGE_GROUP ::ALL_AGE_GRP 'AGE_GROUP ::AGE_GRP ::' ELSE NULL END) || D4_AGE_GROUP_ET) ALIAS_3554, D4_AGE_GROUP_HierarchyNumber, D4_AG D4_AGE_GROUP_ALL_AGE_GRP, D4_AGE_GROUP_AGE_GRP, T218.C2 D12_PROCEDURE_ET, ((CASE T218.C3 WHEN 3 THEN 'PR WHEN 1 THEN 'PROCEDURE ::PROC_GRP ::' WHEN 0 THEN 'PROCEDURE ::PROC ::' ELSE NULL END) || T218.C2) ALIAS_3555, T218.C7 D12_PROCEDURE_HierarchyNumber, T218.C3 D12_PROCEDURE_GID, T218.C4 D12_PROCEDURE_ALL_PROC, T218.C T218.C6 D12_PROCEDURE_PROC, T217.C2 D20_DIAGNOSIS_ET, ((CASE T217.C3 WHEN 3 THEN 'D2GROUP ::ALL_D2GRP ::' W 'D2GROUP ::D2GRP ::' WHEN 0 THEN 'D2GROUP ::ICD9 ::' ELSE NULL END) || T217.C2) ALIAS_3556, T217.C12 D20_DIAGN T217.C3 D20_DIAGNOSIS_GID, T217.C4 D20_DIAGNOSIS_ALL_D2GRP, T217.C5 D20_DIAGNOSIS_D2GRP, T217.C6 D20_DIA T217.C7 D20_DIAGNOSIS_ALL_ACC, T217.C8 D20_DIAGNOSIS_ACC, T217.C9 D20_DIAGNOSIS_CC, T217.C10 D20_DIAGNOS T217.C11 D20_ALIAS5, D28_POS_ET, ((CASE D28_POS_GID WHEN 1 THEN 'POS ::ALL_POS ::' WHEN 0 THEN 'POS ::POS ::' || D28_POS_ET) ALIAS_3557, D28_POS_HierarchyNumber, D28_POS_GID, D28_POS_ALL_POS, D28_POS_POS, T216.C2 ((CASE T216.C3 WHEN 1 THEN 'SPECIALTY ::ALL_SPEC ::' WHEN 0 THEN 'SPECIALTY ::SPEC ::' ELSE NULL END) || T216.C T216.C6 D36_SPECIALTY_HierarchyNumber, T216.C3 D36_SPECIALTY_GID, T216.C4 D36_SPECIALTY_ALL_SPEC, T216.C D44_INCR_PAID_ET, ((CASE D44_INCR_PAID_GID WHEN 0 THEN 'INCR_PAID ::INCR_PAID ::' ELSE NULL END) || D44_INCR D44_INCR_PAID_HierarchyNumber, D44_INCR_PAID_GID, D44_INCR_PAID_INCR_PAID, D52_BUSINESS_L_ET, ((CASE D5 WHEN 15 THEN 'BUSINESS_LEVEL ::ALL_BL ::' WHEN 7 THEN 'BUSINESS_LEVEL ::LVL1 ::' WHEN 3 THEN 'BUSINESS_LEVEL ::L THEN 'BUSINESS_LEVEL ::LVL3 ::' WHEN 0 THEN 'BUSINESS_LEVEL ::LVL4 ::' ELSE NULL END) || D52_BUSINESS_L_ET) ALI ALIAS_R68, D52_BUSINESS_L_GID, D52_BUSINESS_L_ALL_BL, D52_BUSINESS_L_LVL1, D52_BUSINESS_L_LVL2, D52_BU D52_BUSINESS_L_LVL4, COUNT(*) OVER () ALIAS_3561 FROM ( SELECT SP_D61_DIAGNOSIS_ET, SP_D61_DIAGNOSIS_G SP_D63_PROCEDURE_GID, SP_D65_PROVIDER_ET, SP_D67_BUSINESS_L_ET, SP_D67_BUSINESS_L_GID, SP_D69_SPECIALTY SP_D73_POS_ET, SP_D73_POS_GID, SP_D75_AGE_GROUP_ET, SP_D75_AGE_GROUP_GID, SP_D77_INCR_PAID_ET, SP_D77_ SP_ALIAS_190, SP_ALIAS_194, SP_ALIAS_191, SP_ALIAS_192, SP_ALIAS_193, SP_ALIAS_262, SP_ALIAS_256, SP SP_ALIAS_205 FROM ( SELECT CAST (NULL AS NUMBER) ALIAS_256, CAST (NULL AS NUMBER) ALIAS_257, ALIAS_169 ALIAS_191, ALIAS_192, ALIAS_193, ALIAS_194, ALIAS_205, C59_M_TIME_AWMEDICA_MED_PAIDA, D61_DIAGNOSIS_E D61_DIAGNOSIS_GID, D63_PROCEDURE_ET, D63_PROCEDURE_HierarchyNumber, D63_PROCEDURE_GID, D65_PROVIDER_ET, D67_BUSINESS_L_ET, ALIAS_R81, D67_BUSINESS_L_GID, D69_SPECIALTY_ET, D69_SPECIALTY_HierarchyNumber, D69 D71_TIME_ET, D71_TIME_HierarchyNumber, D71_TIME_GID, D73_POS_ET, D73_POS_HierarchyNumber, D73_POS_GID, D75_AGE_GROUP_HierarchyNumber, D75_AGE_GROUP_GID, D77_INCR_PAID_ET, D77_INCR_PAID_HierarchyNumber, D77_ ALIAS_262 FROM ( SELECT T139.C2 ALIAS_169, T139.C3 ALIAS_190, T139.C4 ALIAS_191, T139.C5 ALIAS_192, T139.C7 ALIAS_194, T139.C8 ALIAS_205, ALIAS_3589 C59_M_TIME_AWMEDICA_MED_PAIDA, D61_DIAGNOSIS_ET D61_DIA ALIAS_3588 D61_DIAGNOSIS_HierarchyNumber, D61_DIAGNOSIS_GID D61_DIAGNOSIS_GID, D63_PROCEDURE_ET D63_PROCE ALIAS_3588 D63_PROCEDURE_HierarchyNumber, D63_PROCEDURE_GID D63_PROCEDURE_GID, D65_PROVIDER_ET D65_PROVID D65_PROVIDER_GID, D67_BUSINESS_L_ET D67_BUSINESS_L_ET, ALIAS_3588 ALIAS_R81, D67_BUSINESS_L_GID D67_BUSI D69_SPECIALTY_ET D69_SPECIALTY_ET, ALIAS_3588 D69_SPECIALTY_HierarchyNumber, D69_SPECIALTY_GID D69_SPECIA D71_TIME_ET D71_TIME_ET, ALIAS_3588 D71_TIME_HierarchyNumber, D71_TIME_GID D71_TIME_GID, D73_POS_ET D73_ ALIAS_3588 D73_POS_HierarchyNumber, D73_POS_GID D73_POS_GID, D75_AGE_GROUP_ET D75_AGE_GROUP_ET, ALIAS_35 D75_AGE_GROUP_GID D75_AGE_GROUP_GID, D77_INCR_PAID_ET D77_INCR_PAID_ET, ALIAS_3588 D77_INCR_PAID_Hierarch D77_INCR_PAID_GID D77_INCR_PAID_GID, ROW_NUMBER() OVER ( PARTITION BY D61_DIAGNOSIS_ET, D61_DIAGNOSIS_GI FYQFDUBUJPO QIPUPIUUQTXXXqJDLSDPNQIPUPTKTIK

Slide 12

Slide 12 text

SELECT /*+ NOPARALLEL bypass_recursive_check */ SP_ALIAS_190, ((CASE SP_ALIAS_191 WHEN 1 THEN 'PROVIDER :: WHEN 0 THEN 'PROVIDER ::PROV ::' ELSE NULL END) || SP_ALIAS_190) ALIAS_3553, SP_ALIAS_194, SP_ALIAS_191, S SP_ALIAS_193, SP_ALIAS_205, D4_AGE_GROUP_ET, ((CASE D4_AGE_GROUP_GID WHEN 1 THEN 'AGE_GROUP ::ALL_AGE_GRP 'AGE_GROUP ::AGE_GRP ::' ELSE NULL END) || D4_AGE_GROUP_ET) ALIAS_3554, D4_AGE_GROUP_HierarchyNumber, D4_AG D4_AGE_GROUP_ALL_AGE_GRP, D4_AGE_GROUP_AGE_GRP, T218.C2 D12_PROCEDURE_ET, ((CASE T218.C3 WHEN 3 THEN 'PR WHEN 1 THEN 'PROCEDURE ::PROC_GRP ::' WHEN 0 THEN 'PROCEDURE ::PROC ::' ELSE NULL END) || T218.C2) ALIAS_3555, T218.C7 D12_PROCEDURE_HierarchyNumber, T218.C3 D12_PROCEDURE_GID, T218.C4 D12_PROCEDURE_ALL_PROC, T218.C T218.C6 D12_PROCEDURE_PROC, T217.C2 D20_DIAGNOSIS_ET, ((CASE T217.C3 WHEN 3 THEN 'D2GROUP ::ALL_D2GRP ::' W 'D2GROUP ::D2GRP ::' WHEN 0 THEN 'D2GROUP ::ICD9 ::' ELSE NULL END) || T217.C2) ALIAS_3556, T217.C12 D20_DIAGN T217.C3 D20_DIAGNOSIS_GID, T217.C4 D20_DIAGNOSIS_ALL_D2GRP, T217.C5 D20_DIAGNOSIS_D2GRP, T217.C6 D20_DIA T217.C7 D20_DIAGNOSIS_ALL_ACC, T217.C8 D20_DIAGNOSIS_ACC, T217.C9 D20_DIAGNOSIS_CC, T217.C10 D20_DIAGNOS T217.C11 D20_ALIAS5, D28_POS_ET, ((CASE D28_POS_GID WHEN 1 THEN 'POS ::ALL_POS ::' WHEN 0 THEN 'POS ::POS ::' || D28_POS_ET) ALIAS_3557, D28_POS_HierarchyNumber, D28_POS_GID, D28_POS_ALL_POS, D28_POS_POS, T216.C2 ((CASE T216.C3 WHEN 1 THEN 'SPECIALTY ::ALL_SPEC ::' WHEN 0 THEN 'SPECIALTY ::SPEC ::' ELSE NULL END) || T216.C T216.C6 D36_SPECIALTY_HierarchyNumber, T216.C3 D36_SPECIALTY_GID, T216.C4 D36_SPECIALTY_ALL_SPEC, T216.C D44_INCR_PAID_ET, ((CASE D44_INCR_PAID_GID WHEN 0 THEN 'INCR_PAID ::INCR_PAID ::' ELSE NULL END) || D44_INCR D44_INCR_PAID_HierarchyNumber, D44_INCR_PAID_GID, D44_INCR_PAID_INCR_PAID, D52_BUSINESS_L_ET, ((CASE D5 WHEN 15 THEN 'BUSINESS_LEVEL ::ALL_BL ::' WHEN 7 THEN 'BUSINESS_LEVEL ::LVL1 ::' WHEN 3 THEN 'BUSINESS_LEVEL ::L THEN 'BUSINESS_LEVEL ::LVL3 ::' WHEN 0 THEN 'BUSINESS_LEVEL ::LVL4 ::' ELSE NULL END) || D52_BUSINESS_L_ET) ALI ALIAS_R68, D52_BUSINESS_L_GID, D52_BUSINESS_L_ALL_BL, D52_BUSINESS_L_LVL1, D52_BUSINESS_L_LVL2, D52_BU D52_BUSINESS_L_LVL4, COUNT(*) OVER () ALIAS_3561 FROM ( SELECT SP_D61_DIAGNOSIS_ET, SP_D61_DIAGNOSIS_G SP_D63_PROCEDURE_GID, SP_D65_PROVIDER_ET, SP_D67_BUSINESS_L_ET, SP_D67_BUSINESS_L_GID, SP_D69_SPECIALTY SP_D73_POS_ET, SP_D73_POS_GID, SP_D75_AGE_GROUP_ET, SP_D75_AGE_GROUP_GID, SP_D77_INCR_PAID_ET, SP_D77_ SP_ALIAS_190, SP_ALIAS_194, SP_ALIAS_191, SP_ALIAS_192, SP_ALIAS_193, SP_ALIAS_262, SP_ALIAS_256, SP SP_ALIAS_205 FROM ( SELECT CAST (NULL AS NUMBER) ALIAS_256, CAST (NULL AS NUMBER) ALIAS_257, ALIAS_169 ALIAS_191, ALIAS_192, ALIAS_193, ALIAS_194, ALIAS_205, C59_M_TIME_AWMEDICA_MED_PAIDA, D61_DIAGNOSIS_E D61_DIAGNOSIS_GID, D63_PROCEDURE_ET, D63_PROCEDURE_HierarchyNumber, D63_PROCEDURE_GID, D65_PROVIDER_ET, D67_BUSINESS_L_ET, ALIAS_R81, D67_BUSINESS_L_GID, D69_SPECIALTY_ET, D69_SPECIALTY_HierarchyNumber, D69 D71_TIME_ET, D71_TIME_HierarchyNumber, D71_TIME_GID, D73_POS_ET, D73_POS_HierarchyNumber, D73_POS_GID, D75_AGE_GROUP_HierarchyNumber, D75_AGE_GROUP_GID, D77_INCR_PAID_ET, D77_INCR_PAID_HierarchyNumber, D77_ ALIAS_262 FROM ( SELECT T139.C2 ALIAS_169, T139.C3 ALIAS_190, T139.C4 ALIAS_191, T139.C5 ALIAS_192, T139.C7 ALIAS_194, T139.C8 ALIAS_205, ALIAS_3589 C59_M_TIME_AWMEDICA_MED_PAIDA, D61_DIAGNOSIS_ET D61_DIA ALIAS_3588 D61_DIAGNOSIS_HierarchyNumber, D61_DIAGNOSIS_GID D61_DIAGNOSIS_GID, D63_PROCEDURE_ET D63_PROCE ALIAS_3588 D63_PROCEDURE_HierarchyNumber, D63_PROCEDURE_GID D63_PROCEDURE_GID, D65_PROVIDER_ET D65_PROVID D65_PROVIDER_GID, D67_BUSINESS_L_ET D67_BUSINESS_L_ET, ALIAS_3588 ALIAS_R81, D67_BUSINESS_L_GID D67_BUSI D69_SPECIALTY_ET D69_SPECIALTY_ET, ALIAS_3588 D69_SPECIALTY_HierarchyNumber, D69_SPECIALTY_GID D69_SPECIA D71_TIME_ET D71_TIME_ET, ALIAS_3588 D71_TIME_HierarchyNumber, D71_TIME_GID D71_TIME_GID, D73_POS_ET D73_ ALIAS_3588 D73_POS_HierarchyNumber, D73_POS_GID D73_POS_GID, D75_AGE_GROUP_ET D75_AGE_GROUP_ET, ALIAS_35 D75_AGE_GROUP_GID D75_AGE_GROUP_GID, D77_INCR_PAID_ET D77_INCR_PAID_ET, ALIAS_3588 D77_INCR_PAID_Hierarch D77_INCR_PAID_GID D77_INCR_PAID_GID, ROW_NUMBER() OVER ( PARTITION BY D61_DIAGNOSIS_ET, D61_DIAGNOSIS_GI BXLXBSEEFMJWFSBCMFT QIPUPIUUQTXXXqJDLSDPNQIPUPTKTIK

Slide 13

Slide 13 text

SELECT /*+ NOPARALLEL bypass_recursive_check */ SP_ALIAS_190, ((CASE SP_ALIAS_191 WHEN 1 THEN 'PROVIDER :: WHEN 0 THEN 'PROVIDER ::PROV ::' ELSE NULL END) || SP_ALIAS_190) ALIAS_3553, SP_ALIAS_194, SP_ALIAS_191, S SP_ALIAS_193, SP_ALIAS_205, D4_AGE_GROUP_ET, ((CASE D4_AGE_GROUP_GID WHEN 1 THEN 'AGE_GROUP ::ALL_AGE_GRP 'AGE_GROUP ::AGE_GRP ::' ELSE NULL END) || D4_AGE_GROUP_ET) ALIAS_3554, D4_AGE_GROUP_HierarchyNumber, D4_AG D4_AGE_GROUP_ALL_AGE_GRP, D4_AGE_GROUP_AGE_GRP, T218.C2 D12_PROCEDURE_ET, ((CASE T218.C3 WHEN 3 THEN 'PR WHEN 1 THEN 'PROCEDURE ::PROC_GRP ::' WHEN 0 THEN 'PROCEDURE ::PROC ::' ELSE NULL END) || T218.C2) ALIAS_3555, T218.C7 D12_PROCEDURE_HierarchyNumber, T218.C3 D12_PROCEDURE_GID, T218.C4 D12_PROCEDURE_ALL_PROC, T218.C T218.C6 D12_PROCEDURE_PROC, T217.C2 D20_DIAGNOSIS_ET, ((CASE T217.C3 WHEN 3 THEN 'D2GROUP ::ALL_D2GRP ::' W 'D2GROUP ::D2GRP ::' WHEN 0 THEN 'D2GROUP ::ICD9 ::' ELSE NULL END) || T217.C2) ALIAS_3556, T217.C12 D20_DIAGN T217.C3 D20_DIAGNOSIS_GID, T217.C4 D20_DIAGNOSIS_ALL_D2GRP, T217.C5 D20_DIAGNOSIS_D2GRP, T217.C6 D20_DIA T217.C7 D20_DIAGNOSIS_ALL_ACC, T217.C8 D20_DIAGNOSIS_ACC, T217.C9 D20_DIAGNOSIS_CC, T217.C10 D20_DIAGNOS T217.C11 D20_ALIAS5, D28_POS_ET, ((CASE D28_POS_GID WHEN 1 THEN 'POS ::ALL_POS ::' WHEN 0 THEN 'POS ::POS ::' || D28_POS_ET) ALIAS_3557, D28_POS_HierarchyNumber, D28_POS_GID, D28_POS_ALL_POS, D28_POS_POS, T216.C2 ((CASE T216.C3 WHEN 1 THEN 'SPECIALTY ::ALL_SPEC ::' WHEN 0 THEN 'SPECIALTY ::SPEC ::' ELSE NULL END) || T216.C T216.C6 D36_SPECIALTY_HierarchyNumber, T216.C3 D36_SPECIALTY_GID, T216.C4 D36_SPECIALTY_ALL_SPEC, T216.C D44_INCR_PAID_ET, ((CASE D44_INCR_PAID_GID WHEN 0 THEN 'INCR_PAID ::INCR_PAID ::' ELSE NULL END) || D44_INCR D44_INCR_PAID_HierarchyNumber, D44_INCR_PAID_GID, D44_INCR_PAID_INCR_PAID, D52_BUSINESS_L_ET, ((CASE D5 WHEN 15 THEN 'BUSINESS_LEVEL ::ALL_BL ::' WHEN 7 THEN 'BUSINESS_LEVEL ::LVL1 ::' WHEN 3 THEN 'BUSINESS_LEVEL ::L THEN 'BUSINESS_LEVEL ::LVL3 ::' WHEN 0 THEN 'BUSINESS_LEVEL ::LVL4 ::' ELSE NULL END) || D52_BUSINESS_L_ET) ALI ALIAS_R68, D52_BUSINESS_L_GID, D52_BUSINESS_L_ALL_BL, D52_BUSINESS_L_LVL1, D52_BUSINESS_L_LVL2, D52_BU D52_BUSINESS_L_LVL4, COUNT(*) OVER () ALIAS_3561 FROM ( SELECT SP_D61_DIAGNOSIS_ET, SP_D61_DIAGNOSIS_G SP_D63_PROCEDURE_GID, SP_D65_PROVIDER_ET, SP_D67_BUSINESS_L_ET, SP_D67_BUSINESS_L_GID, SP_D69_SPECIALTY SP_D73_POS_ET, SP_D73_POS_GID, SP_D75_AGE_GROUP_ET, SP_D75_AGE_GROUP_GID, SP_D77_INCR_PAID_ET, SP_D77_ SP_ALIAS_190, SP_ALIAS_194, SP_ALIAS_191, SP_ALIAS_192, SP_ALIAS_193, SP_ALIAS_262, SP_ALIAS_256, SP SP_ALIAS_205 FROM ( SELECT CAST (NULL AS NUMBER) ALIAS_256, CAST (NULL AS NUMBER) ALIAS_257, ALIAS_169 ALIAS_191, ALIAS_192, ALIAS_193, ALIAS_194, ALIAS_205, C59_M_TIME_AWMEDICA_MED_PAIDA, D61_DIAGNOSIS_E D61_DIAGNOSIS_GID, D63_PROCEDURE_ET, D63_PROCEDURE_HierarchyNumber, D63_PROCEDURE_GID, D65_PROVIDER_ET, D67_BUSINESS_L_ET, ALIAS_R81, D67_BUSINESS_L_GID, D69_SPECIALTY_ET, D69_SPECIALTY_HierarchyNumber, D69 D71_TIME_ET, D71_TIME_HierarchyNumber, D71_TIME_GID, D73_POS_ET, D73_POS_HierarchyNumber, D73_POS_GID, D75_AGE_GROUP_HierarchyNumber, D75_AGE_GROUP_GID, D77_INCR_PAID_ET, D77_INCR_PAID_HierarchyNumber, D77_ ALIAS_262 FROM ( SELECT T139.C2 ALIAS_169, T139.C3 ALIAS_190, T139.C4 ALIAS_191, T139.C5 ALIAS_192, T139.C7 ALIAS_194, T139.C8 ALIAS_205, ALIAS_3589 C59_M_TIME_AWMEDICA_MED_PAIDA, D61_DIAGNOSIS_ET D61_DIA ALIAS_3588 D61_DIAGNOSIS_HierarchyNumber, D61_DIAGNOSIS_GID D61_DIAGNOSIS_GID, D63_PROCEDURE_ET D63_PROCE ALIAS_3588 D63_PROCEDURE_HierarchyNumber, D63_PROCEDURE_GID D63_PROCEDURE_GID, D65_PROVIDER_ET D65_PROVID D65_PROVIDER_GID, D67_BUSINESS_L_ET D67_BUSINESS_L_ET, ALIAS_3588 ALIAS_R81, D67_BUSINESS_L_GID D67_BUSI D69_SPECIALTY_ET D69_SPECIALTY_ET, ALIAS_3588 D69_SPECIALTY_HierarchyNumber, D69_SPECIALTY_GID D69_SPECIA D71_TIME_ET D71_TIME_ET, ALIAS_3588 D71_TIME_HierarchyNumber, D71_TIME_GID D71_TIME_GID, D73_POS_ET D73_ ALIAS_3588 D73_POS_HierarchyNumber, D73_POS_GID D73_POS_GID, D75_AGE_GROUP_ET D75_AGE_GROUP_ET, ALIAS_35 D75_AGE_GROUP_GID D75_AGE_GROUP_GID, D77_INCR_PAID_ET D77_INCR_PAID_ET, ALIAS_3588 D77_INCR_PAID_Hierarch D77_INCR_PAID_GID D77_INCR_PAID_GID, ROW_NUMBER() OVER ( PARTITION BY D61_DIAGNOSIS_ET, D61_DIAGNOSIS_GI GSFRVFOUJODJEFOUT QIPUPIUUQTXXXqJDLSDPNQIPUPTMJRVJECPOF[

Slide 14

Slide 14 text

SELECT /*+ NOPARALLEL bypass_recursive_check */ SP_ALIAS_190, ((CASE SP_ALIAS_191 WHEN 1 THEN 'PROVIDER :: WHEN 0 THEN 'PROVIDER ::PROV ::' ELSE NULL END) || SP_ALIAS_190) ALIAS_3553, SP_ALIAS_194, SP_ALIAS_191, S SP_ALIAS_193, SP_ALIAS_205, D4_AGE_GROUP_ET, ((CASE D4_AGE_GROUP_GID WHEN 1 THEN 'AGE_GROUP ::ALL_AGE_GRP 'AGE_GROUP ::AGE_GRP ::' ELSE NULL END) || D4_AGE_GROUP_ET) ALIAS_3554, D4_AGE_GROUP_HierarchyNumber, D4_AG D4_AGE_GROUP_ALL_AGE_GRP, D4_AGE_GROUP_AGE_GRP, T218.C2 D12_PROCEDURE_ET, ((CASE T218.C3 WHEN 3 THEN 'PR WHEN 1 THEN 'PROCEDURE ::PROC_GRP ::' WHEN 0 THEN 'PROCEDURE ::PROC ::' ELSE NULL END) || T218.C2) ALIAS_3555, T218.C7 D12_PROCEDURE_HierarchyNumber, T218.C3 D12_PROCEDURE_GID, T218.C4 D12_PROCEDURE_ALL_PROC, T218.C T218.C6 D12_PROCEDURE_PROC, T217.C2 D20_DIAGNOSIS_ET, ((CASE T217.C3 WHEN 3 THEN 'D2GROUP ::ALL_D2GRP ::' W 'D2GROUP ::D2GRP ::' WHEN 0 THEN 'D2GROUP ::ICD9 ::' ELSE NULL END) || T217.C2) ALIAS_3556, T217.C12 D20_DIAGN T217.C3 D20_DIAGNOSIS_GID, T217.C4 D20_DIAGNOSIS_ALL_D2GRP, T217.C5 D20_DIAGNOSIS_D2GRP, T217.C6 D20_DIA T217.C7 D20_DIAGNOSIS_ALL_ACC, T217.C8 D20_DIAGNOSIS_ACC, T217.C9 D20_DIAGNOSIS_CC, T217.C10 D20_DIAGNOS T217.C11 D20_ALIAS5, D28_POS_ET, ((CASE D28_POS_GID WHEN 1 THEN 'POS ::ALL_POS ::' WHEN 0 THEN 'POS ::POS ::' || D28_POS_ET) ALIAS_3557, D28_POS_HierarchyNumber, D28_POS_GID, D28_POS_ALL_POS, D28_POS_POS, T216.C2 ((CASE T216.C3 WHEN 1 THEN 'SPECIALTY ::ALL_SPEC ::' WHEN 0 THEN 'SPECIALTY ::SPEC ::' ELSE NULL END) || T216.C T216.C6 D36_SPECIALTY_HierarchyNumber, T216.C3 D36_SPECIALTY_GID, T216.C4 D36_SPECIALTY_ALL_SPEC, T216.C D44_INCR_PAID_ET, ((CASE D44_INCR_PAID_GID WHEN 0 THEN 'INCR_PAID ::INCR_PAID ::' ELSE NULL END) || D44_INCR D44_INCR_PAID_HierarchyNumber, D44_INCR_PAID_GID, D44_INCR_PAID_INCR_PAID, D52_BUSINESS_L_ET, ((CASE D5 WHEN 15 THEN 'BUSINESS_LEVEL ::ALL_BL ::' WHEN 7 THEN 'BUSINESS_LEVEL ::LVL1 ::' WHEN 3 THEN 'BUSINESS_LEVEL ::L THEN 'BUSINESS_LEVEL ::LVL3 ::' WHEN 0 THEN 'BUSINESS_LEVEL ::LVL4 ::' ELSE NULL END) || D52_BUSINESS_L_ET) ALI ALIAS_R68, D52_BUSINESS_L_GID, D52_BUSINESS_L_ALL_BL, D52_BUSINESS_L_LVL1, D52_BUSINESS_L_LVL2, D52_BU D52_BUSINESS_L_LVL4, COUNT(*) OVER () ALIAS_3561 FROM ( SELECT SP_D61_DIAGNOSIS_ET, SP_D61_DIAGNOSIS_G SP_D63_PROCEDURE_GID, SP_D65_PROVIDER_ET, SP_D67_BUSINESS_L_ET, SP_D67_BUSINESS_L_GID, SP_D69_SPECIALTY SP_D73_POS_ET, SP_D73_POS_GID, SP_D75_AGE_GROUP_ET, SP_D75_AGE_GROUP_GID, SP_D77_INCR_PAID_ET, SP_D77_ SP_ALIAS_190, SP_ALIAS_194, SP_ALIAS_191, SP_ALIAS_192, SP_ALIAS_193, SP_ALIAS_262, SP_ALIAS_256, SP SP_ALIAS_205 FROM ( SELECT CAST (NULL AS NUMBER) ALIAS_256, CAST (NULL AS NUMBER) ALIAS_257, ALIAS_169 ALIAS_191, ALIAS_192, ALIAS_193, ALIAS_194, ALIAS_205, C59_M_TIME_AWMEDICA_MED_PAIDA, D61_DIAGNOSIS_E D61_DIAGNOSIS_GID, D63_PROCEDURE_ET, D63_PROCEDURE_HierarchyNumber, D63_PROCEDURE_GID, D65_PROVIDER_ET, D67_BUSINESS_L_ET, ALIAS_R81, D67_BUSINESS_L_GID, D69_SPECIALTY_ET, D69_SPECIALTY_HierarchyNumber, D69 D71_TIME_ET, D71_TIME_HierarchyNumber, D71_TIME_GID, D73_POS_ET, D73_POS_HierarchyNumber, D73_POS_GID, D75_AGE_GROUP_HierarchyNumber, D75_AGE_GROUP_GID, D77_INCR_PAID_ET, D77_INCR_PAID_HierarchyNumber, D77_ ALIAS_262 FROM ( SELECT T139.C2 ALIAS_169, T139.C3 ALIAS_190, T139.C4 ALIAS_191, T139.C5 ALIAS_192, T139.C7 ALIAS_194, T139.C8 ALIAS_205, ALIAS_3589 C59_M_TIME_AWMEDICA_MED_PAIDA, D61_DIAGNOSIS_ET D61_DIA ALIAS_3588 D61_DIAGNOSIS_HierarchyNumber, D61_DIAGNOSIS_GID D61_DIAGNOSIS_GID, D63_PROCEDURE_ET D63_PROCE ALIAS_3588 D63_PROCEDURE_HierarchyNumber, D63_PROCEDURE_GID D63_PROCEDURE_GID, D65_PROVIDER_ET D65_PROVID D65_PROVIDER_GID, D67_BUSINESS_L_ET D67_BUSINESS_L_ET, ALIAS_3588 ALIAS_R81, D67_BUSINESS_L_GID D67_BUSI D69_SPECIALTY_ET D69_SPECIALTY_ET, ALIAS_3588 D69_SPECIALTY_HierarchyNumber, D69_SPECIALTY_GID D69_SPECIA D71_TIME_ET D71_TIME_ET, ALIAS_3588 D71_TIME_HierarchyNumber, D71_TIME_GID D71_TIME_GID, D73_POS_ET D73_ ALIAS_3588 D73_POS_HierarchyNumber, D73_POS_GID D73_POS_GID, D75_AGE_GROUP_ET D75_AGE_GROUP_ET, ALIAS_35 D75_AGE_GROUP_GID D75_AGE_GROUP_GID, D77_INCR_PAID_ET D77_INCR_PAID_ET, ALIAS_3588 D77_INCR_PAID_Hierarch D77_INCR_PAID_GID D77_INCR_PAID_GID, ROW_NUMBER() OVER ( PARTITION BY D61_DIAGNOSIS_ET, D61_DIAGNOSIS_GI NJTTFEEFBEMJOFT QIPUPIUUQTXXXqJDLSDPNQIPUPTQPXFSMJOF

Slide 15

Slide 15 text

SELECT /*+ NOPARALLEL bypass_recursive_check */ SP_ALIAS_190, ((CASE SP_ALIAS_191 WHEN 1 THEN 'PROVIDER :: WHEN 0 THEN 'PROVIDER ::PROV ::' ELSE NULL END) || SP_ALIAS_190) ALIAS_3553, SP_ALIAS_194, SP_ALIAS_191, S SP_ALIAS_193, SP_ALIAS_205, D4_AGE_GROUP_ET, ((CASE D4_AGE_GROUP_GID WHEN 1 THEN 'AGE_GROUP ::ALL_AGE_GRP 'AGE_GROUP ::AGE_GRP ::' ELSE NULL END) || D4_AGE_GROUP_ET) ALIAS_3554, D4_AGE_GROUP_HierarchyNumber, D4_AG D4_AGE_GROUP_ALL_AGE_GRP, D4_AGE_GROUP_AGE_GRP, T218.C2 D12_PROCEDURE_ET, ((CASE T218.C3 WHEN 3 THEN 'PR WHEN 1 THEN 'PROCEDURE ::PROC_GRP ::' WHEN 0 THEN 'PROCEDURE ::PROC ::' ELSE NULL END) || T218.C2) ALIAS_3555, T218.C7 D12_PROCEDURE_HierarchyNumber, T218.C3 D12_PROCEDURE_GID, T218.C4 D12_PROCEDURE_ALL_PROC, T218.C T218.C6 D12_PROCEDURE_PROC, T217.C2 D20_DIAGNOSIS_ET, ((CASE T217.C3 WHEN 3 THEN 'D2GROUP ::ALL_D2GRP ::' W 'D2GROUP ::D2GRP ::' WHEN 0 THEN 'D2GROUP ::ICD9 ::' ELSE NULL END) || T217.C2) ALIAS_3556, T217.C12 D20_DIAGN T217.C3 D20_DIAGNOSIS_GID, T217.C4 D20_DIAGNOSIS_ALL_D2GRP, T217.C5 D20_DIAGNOSIS_D2GRP, T217.C6 D20_DIA T217.C7 D20_DIAGNOSIS_ALL_ACC, T217.C8 D20_DIAGNOSIS_ACC, T217.C9 D20_DIAGNOSIS_CC, T217.C10 D20_DIAGNOS T217.C11 D20_ALIAS5, D28_POS_ET, ((CASE D28_POS_GID WHEN 1 THEN 'POS ::ALL_POS ::' WHEN 0 THEN 'POS ::POS ::' || D28_POS_ET) ALIAS_3557, D28_POS_HierarchyNumber, D28_POS_GID, D28_POS_ALL_POS, D28_POS_POS, T216.C2 ((CASE T216.C3 WHEN 1 THEN 'SPECIALTY ::ALL_SPEC ::' WHEN 0 THEN 'SPECIALTY ::SPEC ::' ELSE NULL END) || T216.C T216.C6 D36_SPECIALTY_HierarchyNumber, T216.C3 D36_SPECIALTY_GID, T216.C4 D36_SPECIALTY_ALL_SPEC, T216.C D44_INCR_PAID_ET, ((CASE D44_INCR_PAID_GID WHEN 0 THEN 'INCR_PAID ::INCR_PAID ::' ELSE NULL END) || D44_INCR D44_INCR_PAID_HierarchyNumber, D44_INCR_PAID_GID, D44_INCR_PAID_INCR_PAID, D52_BUSINESS_L_ET, ((CASE D5 WHEN 15 THEN 'BUSINESS_LEVEL ::ALL_BL ::' WHEN 7 THEN 'BUSINESS_LEVEL ::LVL1 ::' WHEN 3 THEN 'BUSINESS_LEVEL ::L THEN 'BUSINESS_LEVEL ::LVL3 ::' WHEN 0 THEN 'BUSINESS_LEVEL ::LVL4 ::' ELSE NULL END) || D52_BUSINESS_L_ET) ALI ALIAS_R68, D52_BUSINESS_L_GID, D52_BUSINESS_L_ALL_BL, D52_BUSINESS_L_LVL1, D52_BUSINESS_L_LVL2, D52_BU D52_BUSINESS_L_LVL4, COUNT(*) OVER () ALIAS_3561 FROM ( SELECT SP_D61_DIAGNOSIS_ET, SP_D61_DIAGNOSIS_G SP_D63_PROCEDURE_GID, SP_D65_PROVIDER_ET, SP_D67_BUSINESS_L_ET, SP_D67_BUSINESS_L_GID, SP_D69_SPECIALTY SP_D73_POS_ET, SP_D73_POS_GID, SP_D75_AGE_GROUP_ET, SP_D75_AGE_GROUP_GID, SP_D77_INCR_PAID_ET, SP_D77_ SP_ALIAS_190, SP_ALIAS_194, SP_ALIAS_191, SP_ALIAS_192, SP_ALIAS_193, SP_ALIAS_262, SP_ALIAS_256, SP SP_ALIAS_205 FROM ( SELECT CAST (NULL AS NUMBER) ALIAS_256, CAST (NULL AS NUMBER) ALIAS_257, ALIAS_169 ALIAS_191, ALIAS_192, ALIAS_193, ALIAS_194, ALIAS_205, C59_M_TIME_AWMEDICA_MED_PAIDA, D61_DIAGNOSIS_E D61_DIAGNOSIS_GID, D63_PROCEDURE_ET, D63_PROCEDURE_HierarchyNumber, D63_PROCEDURE_GID, D65_PROVIDER_ET, D67_BUSINESS_L_ET, ALIAS_R81, D67_BUSINESS_L_GID, D69_SPECIALTY_ET, D69_SPECIALTY_HierarchyNumber, D69 D71_TIME_ET, D71_TIME_HierarchyNumber, D71_TIME_GID, D73_POS_ET, D73_POS_HierarchyNumber, D73_POS_GID, D75_AGE_GROUP_HierarchyNumber, D75_AGE_GROUP_GID, D77_INCR_PAID_ET, D77_INCR_PAID_HierarchyNumber, D77_ ALIAS_262 FROM ( SELECT T139.C2 ALIAS_169, T139.C3 ALIAS_190, T139.C4 ALIAS_191, T139.C5 ALIAS_192, T139.C7 ALIAS_194, T139.C8 ALIAS_205, ALIAS_3589 C59_M_TIME_AWMEDICA_MED_PAIDA, D61_DIAGNOSIS_ET D61_DIA ALIAS_3588 D61_DIAGNOSIS_HierarchyNumber, D61_DIAGNOSIS_GID D61_DIAGNOSIS_GID, D63_PROCEDURE_ET D63_PROCE ALIAS_3588 D63_PROCEDURE_HierarchyNumber, D63_PROCEDURE_GID D63_PROCEDURE_GID, D65_PROVIDER_ET D65_PROVID D65_PROVIDER_GID, D67_BUSINESS_L_ET D67_BUSINESS_L_ET, ALIAS_3588 ALIAS_R81, D67_BUSINESS_L_GID D67_BUSI D69_SPECIALTY_ET D69_SPECIALTY_ET, ALIAS_3588 D69_SPECIALTY_HierarchyNumber, D69_SPECIALTY_GID D69_SPECIA D71_TIME_ET D71_TIME_ET, ALIAS_3588 D71_TIME_HierarchyNumber, D71_TIME_GID D71_TIME_GID, D73_POS_ET D73_ ALIAS_3588 D73_POS_HierarchyNumber, D73_POS_GID D73_POS_GID, D75_AGE_GROUP_ET D75_AGE_GROUP_ET, ALIAS_35 D75_AGE_GROUP_GID D75_AGE_GROUP_GID, D77_INCR_PAID_ET D77_INCR_PAID_ET, ALIAS_3588 D77_INCR_PAID_Hierarch D77_INCR_PAID_GID D77_INCR_PAID_GID, ROW_NUMBER() OVER ( PARTITION BY D61_DIAGNOSIS_ET, D61_DIAGNOSIS_GI FYIBVTUFEUFBN QIPUPIUUQTXXXqJDLSDPNQIPUPTGSVNCFSU -FHJUEBUBCBTFRVFSZ MJOFTBOEPWFS XPSET
 TPVSDFIUUQXXXECBPSBDMFDPNPSBDMF@OFXT@@@XPSMET@MPOHFTU@TRM@RVFSZIUN

Slide 16

Slide 16 text

5FDI <㾎>#%% <㾎>5%% <㾎>$* <㾎>$%

Slide 17

Slide 17 text

lEFTJHOJTJOFWJUBCMF
 5IFBMUFSOBUJWFUPHPPE EFTJHOJTCBEEFTJHO 
 OPUOPEFTJHOBUBMMz Š%PVHMBT.BSUJO l#PPL%FTJHO"1SBDUJDBM*OUSPEVDUJPOz

Slide 18

Slide 18 text

SELECT /*+ NOPARALLEL bypass_recursive_check */ SP_ALIAS_190, ((CASE SP_ALIAS_191 WHEN 1 THEN 'PROVIDER :: WHEN 0 THEN 'PROVIDER ::PROV ::' ELSE NULL END) || SP_ALIAS_190) ALIAS_3553, SP_ALIAS_194, SP_ALIAS_191, S SP_ALIAS_193, SP_ALIAS_205, D4_AGE_GROUP_ET, ((CASE D4_AGE_GROUP_GID WHEN 1 THEN 'AGE_GROUP ::ALL_AGE_GRP 'AGE_GROUP ::AGE_GRP ::' ELSE NULL END) || D4_AGE_GROUP_ET) ALIAS_3554, D4_AGE_GROUP_HierarchyNumber, D4_AG D4_AGE_GROUP_ALL_AGE_GRP, D4_AGE_GROUP_AGE_GRP, T218.C2 D12_PROCEDURE_ET, ((CASE T218.C3 WHEN 3 THEN 'PR WHEN 1 THEN 'PROCEDURE ::PROC_GRP ::' WHEN 0 THEN 'PROCEDURE ::PROC ::' ELSE NULL END) || T218.C2) ALIAS_3555, T218.C7 D12_PROCEDURE_HierarchyNumber, T218.C3 D12_PROCEDURE_GID, T218.C4 D12_PROCEDURE_ALL_PROC, T218.C T218.C6 D12_PROCEDURE_PROC, T217.C2 D20_DIAGNOSIS_ET, ((CASE T217.C3 WHEN 3 THEN 'D2GROUP ::ALL_D2GRP ::' W 'D2GROUP ::D2GRP ::' WHEN 0 THEN 'D2GROUP ::ICD9 ::' ELSE NULL END) || T217.C2) ALIAS_3556, T217.C12 D20_DIAGN T217.C3 D20_DIAGNOSIS_GID, T217.C4 D20_DIAGNOSIS_ALL_D2GRP, T217.C5 D20_DIAGNOSIS_D2GRP, T217.C6 D20_DIA T217.C7 D20_DIAGNOSIS_ALL_ACC, T217.C8 D20_DIAGNOSIS_ACC, T217.C9 D20_DIAGNOSIS_CC, T217.C10 D20_DIAGNOS T217.C11 D20_ALIAS5, D28_POS_ET, ((CASE D28_POS_GID WHEN 1 THEN 'POS ::ALL_POS ::' WHEN 0 THEN 'POS ::POS ::' || D28_POS_ET) ALIAS_3557, D28_POS_HierarchyNumber, D28_POS_GID, D28_POS_ALL_POS, D28_POS_POS, T216.C2 ((CASE T216.C3 WHEN 1 THEN 'SPECIALTY ::ALL_SPEC ::' WHEN 0 THEN 'SPECIALTY ::SPEC ::' ELSE NULL END) || T216.C T216.C6 D36_SPECIALTY_HierarchyNumber, T216.C3 D36_SPECIALTY_GID, T216.C4 D36_SPECIALTY_ALL_SPEC, T216.C D44_INCR_PAID_ET, ((CASE D44_INCR_PAID_GID WHEN 0 THEN 'INCR_PAID ::INCR_PAID ::' ELSE NULL END) || D44_INCR D44_INCR_PAID_HierarchyNumber, D44_INCR_PAID_GID, D44_INCR_PAID_INCR_PAID, D52_BUSINESS_L_ET, ((CASE D5 WHEN 15 THEN 'BUSINESS_LEVEL ::ALL_BL ::' WHEN 7 THEN 'BUSINESS_LEVEL ::LVL1 ::' WHEN 3 THEN 'BUSINESS_LEVEL ::L THEN 'BUSINESS_LEVEL ::LVL3 ::' WHEN 0 THEN 'BUSINESS_LEVEL ::LVL4 ::' ELSE NULL END) || D52_BUSINESS_L_ET) ALI ALIAS_R68, D52_BUSINESS_L_GID, D52_BUSINESS_L_ALL_BL, D52_BUSINESS_L_LVL1, D52_BUSINESS_L_LVL2, D52_BU D52_BUSINESS_L_LVL4, COUNT(*) OVER () ALIAS_3561 FROM ( SELECT SP_D61_DIAGNOSIS_ET, SP_D61_DIAGNOSIS_G SP_D63_PROCEDURE_GID, SP_D65_PROVIDER_ET, SP_D67_BUSINESS_L_ET, SP_D67_BUSINESS_L_GID, SP_D69_SPECIALTY SP_D73_POS_ET, SP_D73_POS_GID, SP_D75_AGE_GROUP_ET, SP_D75_AGE_GROUP_GID, SP_D77_INCR_PAID_ET, SP_D77_ SP_ALIAS_190, SP_ALIAS_194, SP_ALIAS_191, SP_ALIAS_192, SP_ALIAS_193, SP_ALIAS_262, SP_ALIAS_256, SP SP_ALIAS_205 FROM ( SELECT CAST (NULL AS NUMBER) ALIAS_256, CAST (NULL AS NUMBER) ALIAS_257, ALIAS_169 ALIAS_191, ALIAS_192, ALIAS_193, ALIAS_194, ALIAS_205, C59_M_TIME_AWMEDICA_MED_PAIDA, D61_DIAGNOSIS_E D61_DIAGNOSIS_GID, D63_PROCEDURE_ET, D63_PROCEDURE_HierarchyNumber, D63_PROCEDURE_GID, D65_PROVIDER_ET, D67_BUSINESS_L_ET, ALIAS_R81, D67_BUSINESS_L_GID, D69_SPECIALTY_ET, D69_SPECIALTY_HierarchyNumber, D69 D71_TIME_ET, D71_TIME_HierarchyNumber, D71_TIME_GID, D73_POS_ET, D73_POS_HierarchyNumber, D73_POS_GID, D75_AGE_GROUP_HierarchyNumber, D75_AGE_GROUP_GID, D77_INCR_PAID_ET, D77_INCR_PAID_HierarchyNumber, D77_ ALIAS_262 FROM ( SELECT T139.C2 ALIAS_169, T139.C3 ALIAS_190, T139.C4 ALIAS_191, T139.C5 ALIAS_192, T139.C7 ALIAS_194, T139.C8 ALIAS_205, ALIAS_3589 C59_M_TIME_AWMEDICA_MED_PAIDA, D61_DIAGNOSIS_ET D61_DIA ALIAS_3588 D61_DIAGNOSIS_HierarchyNumber, D61_DIAGNOSIS_GID D61_DIAGNOSIS_GID, D63_PROCEDURE_ET D63_PROCE ALIAS_3588 D63_PROCEDURE_HierarchyNumber, D63_PROCEDURE_GID D63_PROCEDURE_GID, D65_PROVIDER_ET D65_PROVID D65_PROVIDER_GID, D67_BUSINESS_L_ET D67_BUSINESS_L_ET, ALIAS_3588 ALIAS_R81, D67_BUSINESS_L_GID D67_BUSI D69_SPECIALTY_ET D69_SPECIALTY_ET, ALIAS_3588 D69_SPECIALTY_HierarchyNumber, D69_SPECIALTY_GID D69_SPECIA D71_TIME_ET D71_TIME_ET, ALIAS_3588 D71_TIME_HierarchyNumber, D71_TIME_GID D71_TIME_GID, D73_POS_ET D73_ ALIAS_3588 D73_POS_HierarchyNumber, D73_POS_GID D73_POS_GID, D75_AGE_GROUP_ET D75_AGE_GROUP_ET, ALIAS_35 D75_AGE_GROUP_GID D75_AGE_GROUP_GID, D77_INCR_PAID_ET D77_INCR_PAID_ET, ALIAS_3588 D77_INCR_PAID_Hierarch D77_INCR_PAID_GID D77_INCR_PAID_GID, ROW_NUMBER() OVER ( PARTITION BY D61_DIAGNOSIS_ET, D61_DIAGNOSIS_GI photo: https://www.flickr.com/photos/-jvl-/ proto: https://www.flickr.com/photos/daryl_mitchell/ #SFBLUIF#"%#"%NPOPMJUI QJDUVSFIUUQTXXXqJDLSDPNQIPUPTKVIBOTPOJO DB

Slide 19

Slide 19 text

photo: https://www.flickr.com/photos/-jvl-/ proto: https://www.flickr.com/photos/daryl_mitchell/ %POPUDSFBUFUIF#"%?EJTUSJCVUFENPOPMJUI QJDUVSFIUUQTXXXqJDLSDPNQIPUPTKVIBOTPOJO DB? DB? DB? DB? DB? DB? DB? DB? DB?

Slide 20

Slide 20 text

QIPUPIUUQTXXXqJDLSDPNQIPUPTEFOO %PNBJO %SJWFO %FTJHO ʜ TIPXT IPX EFTJHO BOE EFWFMPQNFOU DBO XPSL UPHFUIFS UP DSFBUF B CFUUFS TPMVUJPO (PPE EFTJHO XJMM BDDFMFSBUF UIF EFWFMPQNFOU XIJMFGFFECBDLDPNJOHGSPNUIFEFWFMPQNFOUQSPDFTT XJMMFOIBODFUIFEFTJHO l%PNBJO%SJWFO%FTJHO2VJDLMZz#PPL "CFM"WSBN

Slide 21

Slide 21 text

%0."*/ 
 %3*7&/ %&4*(/ QIPUPIUUQTXXXqJDLSDPNQIPUPTEFOO

Slide 22

Slide 22 text

4"/%8*$) 
 %3*7&/ %&4*(/ QIPUPIUUQTXXXqJDLSDPNQIPUPTEFOO

Slide 23

Slide 23 text

#PCCZ

Slide 24

Slide 24 text

Sandwich #PCCZ Likes

Slide 25

Slide 25 text

Dad

Slide 26

Slide 26 text

Kitchen #PCCZ Dad

Slide 27

Slide 27 text

a generic monitoring solution brand name

Slide 28

Slide 28 text

Kitchen #PCCZ Dad

Slide 29

Slide 29 text

QIPUPIUUQTXXXqJDLSDPNQIPUPTEFOO " NPEFM JT OPU B DPQZ PG UIF SFBM XPSME CVU B IVNBO DPOTUSVDU UIBU IFMQT VT UP NBLF TFOTF PG SFBMXPSME TZTUFNT l8IBU*T%PNBJO%SJWFO%FTJHO z3FQPSU 0DU 7MBEJL,OPOPOPW

Slide 30

Slide 30 text

.0%&-4

Slide 31

Slide 31 text

few months

Slide 32

Slide 32 text

+

Slide 33

Slide 33 text

No content

Slide 34

Slide 34 text

QIPUPIUUQTXXXqJDLSDPNQIPUPTEFOO 5BDUJDBMEFTJHOJTMJLFVTJOHBUIJOCSVTIUPQBJOUUIFpOF EFUBJMTPGZPVSEPNBJONPEFM l*NQMFNFOUJOH%PNBJO%SJWFO%FTJHOz#PPL 7BVHI7FSOPO

Slide 35

Slide 35 text

maximise that at work

Slide 36

Slide 36 text

QIPUPIUUQTXXXqJDLSDPNQIPUPTEFOO <4USBUFHJDEFTJHO>EJTUJMUIFQSPCMFNEPNBJOBOETIBQF UIFBSDIJUFDUVSFPGBOBQQMJDBUJPO l*NQMFNFOUJOH%PNBJO%SJWFO%FTJHOz#PPL /JDL5VOF4DPUU.JMMFUU

Slide 37

Slide 37 text

few years

Slide 38

Slide 38 text

No content

Slide 39

Slide 39 text

No content

Slide 40

Slide 40 text

No content

Slide 41

Slide 41 text

No content

Slide 42

Slide 42 text

No content

Slide 43

Slide 43 text

No content

Slide 44

Slide 44 text

No content

Slide 45

Slide 45 text

QIPUPIUUQTXXXqJDLSDPNQIPUPTEFOO %PNBJO FYQFSUT BSF LOPXMFEHF BVUIPSJUJFT JO UIF TPGUXBSF`T CVTJOFTT EPNBJO 5IF EPNBJO FYQFSUT BSF OFJUIFS UIF BOBMZTUT UIBU HBUIFS SFRVJSFNFOUT OPS UIF FOHJOFFST EFTJHOJOH UIF TZTUFN %PNBJO FYQFSUT SFQSFTFOUUIFCVTJOFTT l8IBU*T%PNBJO%SJWFO%FTJHO z3FQPSU 0DU 7MBEJL,OPOPOPW

Slide 46

Slide 46 text

No content

Slide 47

Slide 47 text

QIPUPIUUQTXXXqJDLSDPNQIPUPTEFOO <6CJRVJUPVT MBOHVBHF > B TFDSFU MBOHVBHF FOBCMFT DPNQMFY UPQJDT UP CF DPWFSFE JO DPODJTF BOE NFBOJOHGVM EJBMPHVF XJUIPVU UIF OFFE GPS DPOGVTJOH CBCCMF*U`TWJUBMGPSBEFWFMPQNFOUUFBNUPVOEFSTUBOE BOEDPMMBCPSBUFPOUIJTMBOHVBHF l1BUUFSOT 1SJODJQMFTBOE1SBDUJDFTPG%PNBJO%SJWFO%FTJHOz#PPL "QSJM /JDL5VOF4DPUU.JMMFUU

Slide 48

Slide 48 text

example from usual developer interaction

Slide 49

Slide 49 text

few weeks

Slide 50

Slide 50 text

from 1 to 30

Slide 51

Slide 51 text

No content

Slide 52

Slide 52 text

No content

Slide 53

Slide 53 text

No content

Slide 54

Slide 54 text

from 30 to 300?

Slide 55

Slide 55 text

from 300 to 3M?

Slide 56

Slide 56 text

few decades

Slide 57

Slide 57 text

BOBBYS 2000 branches!

Slide 58

Slide 58 text

No content

Slide 59

Slide 59 text

BOBBYS

Slide 60

Slide 60 text

BOBBYS

Slide 61

Slide 61 text

BOBBYS

Slide 62

Slide 62 text

BOBBYS

Slide 63

Slide 63 text

BOBBYS

Slide 64

Slide 64 text

BOBBYS

Slide 65

Slide 65 text

BOBBYS

Slide 66

Slide 66 text

BOBBYS

Slide 67

Slide 67 text

BOBBYS

Slide 68

Slide 68 text

BOBBYS

Slide 69

Slide 69 text

QIPUPIUUQTXXXqJDLSDPNQIPUPTEFOO "DPSFTVCEPNBJOJTXIBUBDPNQBOZEPFTEJ⒎FSFOUMZ GSPN JUT DPNQFUJUPST 5IJT NBZ JOWPMWF JOWFOUJOH OFX QSPEVDUT PS TFSWJDFT PS PQUJNJ[JOH FYJTUJOH QSPDFTTFT BOEUIFSFCZSFEVDJOHDPTUT 7MBEJL,IPOPOPW l8IBU*T%PNBJO%SJWFO%FTJHO z3FQPSU 0DU

Slide 70

Slide 70 text

BOBBYS

Slide 71

Slide 71 text

BOBBYS

Slide 72

Slide 72 text

QIPUPIUUQTXXXqJDLSDPNQIPUPTEFOO <4VQQPSUJOH TVCEPNBJO> JT TUJMM BO JNQPSUBOU TPGUXBSF NPEFM CFDBVTF ZPVS $PSF %PNBJO DBOOPU CF TVDDFTTGVMXJUIPVUJU l*NQMFNFOUJOH%PNBJO%SJWFO%FTJHOz#PPL 7BVHI7FSOPO

Slide 73

Slide 73 text

BOBBYS

Slide 74

Slide 74 text

BOBBYS

Slide 75

Slide 75 text

QIPUPIUUQTXXXqJDLSDPNQIPUPTEFOO (FOFSJD TVCEPNBJOT EP OPU QSPWJEF BOZ DPNQFUJUJWF FEHF GPS UIF DPNQBOZ ʜ CVTJOFTT BDUJWJUJFT UIBU BMM DPNQBOJFTBSFQFSGPSNJOHJOUIFTBNFXBZ l8IBU*T%PNBJO%SJWFO%FTJHO z3FQPSU 0DU 7MBEJL,OPOPOPW

Slide 76

Slide 76 text

BOBBYS

Slide 77

Slide 77 text

BOBBYS

Slide 78

Slide 78 text

BOBBYS

Slide 79

Slide 79 text

QIPUPIUUQTXXXqJDLSDPNQIPUPTEFOO <#PVOEFE DPOUFYU JT> B TNBMM TUSPOHMZ TFNBOUJDBMMZ DPOTJTUFOUNPEFMʜBQPSUJPOPGUIFNPEFMXIJDIXF NVTULFFQBNCJHVJUZGSFF l*OUSPEVDJOH&WFOU4UPSNJOH"OBDUPG%FMJCFSBUF$PMMFDUJWF-FBSOJOHz3FQPSU "VH "MCFSUP#SBOEPMJOJ

Slide 80

Slide 80 text

4"/%8*$) 
 %3*7&/ %&4*(/ QIPUPIUUQTXXXqJDLSDPNQIPUPTEFOO

Slide 81

Slide 81 text

%0."*/ 
 %3*7&/ %&4*(/ QIPUPIUUQTXXXqJDLSDPNQIPUPTEFOO

Slide 82

Slide 82 text

%%%JTBTFUPGQBUUFSOTBOENFUIPETIFMQJOHUPNBLFTFOTF PGQSPCMFNTCZDPNCJOJOHpOFSHPPEEFWFMPQNFOUQSBDUJDFT JO UBDUJDBM EFTJHO BOE DPBSTFS HPPE EFTJHO QSBDUJDFT JO TUSBUFHJD EFTJHO JU GBDJMJUBUFT DPMMBCPSBUJPO CFUXFFO B UFBN BOEEPNBJOFYQFSUTBOEQSPNPUFTBEPQUJPOBOEXJEFVTFPG VCJRVJUPVT MBOHVBHF JO QSPCMFN EFTDSJQUJPO BT XFMM BT TPMVUJPO JNQMFNFOUBUJPO *O TUSBUFHJD EFTJHO XF CVJME WBSJPVT NPEFMT UP DPSSFDUMZ BOE VTFGVMMZ EFTDSJCF UIF CVTJOFTT EPNBJOBOEpOEUIFNPTUJNQPSUBOUDPSFEPNBJOPOXIJDI UP TQFOE NPTU PG PVS MJNJUFE SFTPVSDFT MFTT JNQPSUBOU TVQQPSUJOH TVCEPNBJOT XJUIPVU XIJDI PVS DPSF JT NVDI MFTT MJLFMZ UP TVDDFFE BOE MFTT JNQPSUBOU TVQQPSUJOH TVCEPNBJO XIJDI DBO CF TBGFMZ PVUTPVSDFE 8F GPDVT PO DPSFBOEBOENBOBHFJU`TDPNQMFYJUZCZEFTJHOJOHCPVOEFE DPOUFYUTUPDPOUBJOUIFTNBMMFSDPOTJTUFOUNPEFMT XIJDIBSF FBTJFSUPNBOBHFBOEUIJOHPG

Slide 83

Slide 83 text

%%%JTBTFUPGQBUUFSOTBOENFUIPETIFMQJOHUPNBLFTFOTF PGQSPCMFNTCZDPNCJOJOHpOFSHPPEEFWFMPQNFOUQSBDUJDFT JO UBDUJDBM EFTJHO BOE DPBSTFS HPPE EFTJHO QSBDUJDFT JO TUSBUFHJD EFTJHO JU GBDJMJUBUFT DPMMBCPSBUJPO CFUXFFO B UFBN BOEEPNBJOFYQFSUTBOEQSPNPUFTBEPQUJPOBOEXJEFVTFPG VCJRVJUPVT MBOHVBHF JO QSPCMFN EFTDSJQUJPO BT XFMM BT TPMVUJPO JNQMFNFOUBUJPO *O TUSBUFHJD EFTJHO XF CVJME WBSJPVT NPEFMT UP DPSSFDUMZ BOE VTFGVMMZ EFTDSJCF UIF CVTJOFTT EPNBJOBOEpOEUIFNPTUJNQPSUBOUDPSFEPNBJOPOXIJDI UP TQFOE NPTU PG PVS MJNJUFE SFTPVSDFT MFTT JNQPSUBOU TVQQPSUJOH TVCEPNBJOT XJUIPVU XIJDI PVS DPSF JT NVDI MFTT MJLFMZ UP TVDDFFE BOE MFTT JNQPSUBOU TVQQPSUJOH TVCEPNBJO XIJDI DBO CF TBGFMZ PVUTPVSDFE 8F GPDVT PO DPSFBOEBOENBOBHFJU`TDPNQMFYJUZCZEFTJHOJOHCPVOEFE DPOUFYUTUPDPOUBJOUIFTNBMMFSDPOTJTUFOUNPEFMT XIJDIBSF FBTJFSUPNBOBHFBOEUIJOHPG

Slide 84

Slide 84 text

%%%JTBTFUPGQBUUFSOTBOENFUIPETIFMQJOHUPNBLFTFOTF PGQSPCMFNTCZDPNCJOJOHpOFSHPPEEFWFMPQNFOUQSBDUJDFT JO UBDUJDBM EFTJHO BOE DPBSTFS HPPE EFTJHO QSBDUJDFT JO TUSBUFHJD EFTJHO JU GBDJMJUBUFT DPMMBCPSBUJPO CFUXFFO B UFBN BOEEPNBJOFYQFSUTBOEQSPNPUFTBEPQUJPOBOEXJEFVTFPG VCJRVJUPVT MBOHVBHF JO QSPCMFN EFTDSJQUJPO BT XFMM BT TPMVUJPO JNQMFNFOUBUJPO *O TUSBUFHJD EFTJHO XF CVJME WBSJPVT NPEFMT UP DPSSFDUMZ BOE VTFGVMMZ EFTDSJCF UIF CVTJOFTT EPNBJOBOEpOEUIFNPTUJNQPSUBOUDPSFEPNBJOPOXIJDI UP TQFOE NPTU PG PVS MJNJUFE SFTPVSDFT MFTT JNQPSUBOU TVQQPSUJOH TVCEPNBJOT XJUIPVU XIJDI PVS DPSF JT NVDI MFTT MJLFMZ UP TVDDFFE BOE MFTT JNQPSUBOU TVQQPSUJOH TVCEPNBJO XIJDI DBO CF TBGFMZ PVUTPVSDFE 8F GPDVT PO DPSFBOEBOENBOBHFJU`TDPNQMFYJUZCZEFTJHOJOHCPVOEFE DPOUFYUTUPDPOUBJOUIFTNBMMFSDPOTJTUFOUNPEFMT XIJDIBSF FBTJFSUPNBOBHFBOEUIJOHPG

Slide 85

Slide 85 text

%%%JTBTFUPGQBUUFSOTBOENFUIPETIFMQJOHUPNBLFTFOTF PGQSPCMFNTCZDPNCJOJOHpOFSHPPEEFWFMPQNFOUQSBDUJDFT JO UBDUJDBM EFTJHO BOE DPBSTFS HPPE EFTJHO QSBDUJDFT JO TUSBUFHJD EFTJHO JU GBDJMJUBUFT DPMMBCPSBUJPO CFUXFFO B UFBN BOEEPNBJOFYQFSUTBOEQSPNPUFTBEPQUJPOBOEXJEFVTFPG VCJRVJUPVT MBOHVBHF JO QSPCMFN EFTDSJQUJPO BT XFMM BT TPMVUJPO JNQMFNFOUBUJPO *O TUSBUFHJD EFTJHO XF CVJME WBSJPVT NPEFMT UP DPSSFDUMZ BOE VTFGVMMZ EFTDSJCF UIF CVTJOFTT EPNBJOBOEpOEUIFNPTUJNQPSUBOUDPSFEPNBJOPOXIJDI UP TQFOE NPTU PG PVS MJNJUFE SFTPVSDFT MFTT JNQPSUBOU TVQQPSUJOH TVCEPNBJOT XJUIPVU XIJDI PVS DPSF JT NVDI MFTT MJLFMZ UP TVDDFFE BOE MFTT JNQPSUBOU TVQQPSUJOH TVCEPNBJO XIJDI DBO CF TBGFMZ PVUTPVSDFE 8F GPDVT PO DPSFBOEBOENBOBHFJU`TDPNQMFYJUZCZEFTJHOJOHCPVOEFE DPOUFYUTUPDPOUBJOUIFTNBMMFSDPOTJTUFOUNPEFMT XIJDIBSF FBTJFSUPNBOBHFBOEUIJOHPG

Slide 86

Slide 86 text

%%%JTBTFUPGQBUUFSOTBOENFUIPETIFMQJOHUPNBLFTFOTF PGQSPCMFNTCZDPNCJOJOHpOFSHPPEEFWFMPQNFOUQSBDUJDFT JO UBDUJDBM EFTJHO BOE DPBSTFS HPPE EFTJHO QSBDUJDFT JO TUSBUFHJD EFTJHO JU GBDJMJUBUFT DPMMBCPSBUJPO CFUXFFO B UFBN BOEEPNBJOFYQFSUTBOEQSPNPUFTBEPQUJPOBOEXJEFVTFPG VCJRVJUPVT MBOHVBHF JO QSPCMFN EFTDSJQUJPO BT XFMM BT TPMVUJPO JNQMFNFOUBUJPO *O TUSBUFHJD EFTJHO XF CVJME WBSJPVT NPEFMT UP DPSSFDUMZ BOE VTFGVMMZ EFTDSJCF UIF CVTJOFTT EPNBJOBOEpOEUIFNPTUJNQPSUBOUDPSFEPNBJOPOXIJDI UP TQFOE NPTU PG PVS MJNJUFE SFTPVSDFT MFTT JNQPSUBOU TVQQPSUJOH TVCEPNBJOT XJUIPVU XIJDI PVS DPSF JT NVDI MFTT MJLFMZ UP TVDDFFE BOE MFTT JNQPSUBOU TVQQPSUJOH TVCEPNBJO XIJDI DBO CF TBGFMZ PVUTPVSDFE 8F GPDVT PO DPSFBOEBOENBOBHFJU`TDPNQMFYJUZCZEFTJHOJOHCPVOEFE DPOUFYUTUPDPOUBJOUIFTNBMMFSDPOTJTUFOUNPEFMT XIJDIBSF FBTJFSUPNBOBHFBOEUIJOHPG

Slide 87

Slide 87 text

%%%JTBTFUPGQBUUFSOTBOENFUIPETIFMQJOHUPNBLFTFOTF PGQSPCMFNTCZDPNCJOJOHpOFSHPPEEFWFMPQNFOUQSBDUJDFT JO UBDUJDBM EFTJHO BOE DPBSTFS HPPE EFTJHO QSBDUJDFT JO TUSBUFHJD EFTJHO JU GBDJMJUBUFT DPMMBCPSBUJPO CFUXFFO B UFBN BOEEPNBJOFYQFSUTBOEQSPNPUFTBEPQUJPOBOEXJEFVTFPG VCJRVJUPVT MBOHVBHF JO QSPCMFN EFTDSJQUJPO BT XFMM BT TPMVUJPO JNQMFNFOUBUJPO *O TUSBUFHJD EFTJHO XF CVJME WBSJPVT NPEFMT UP DPSSFDUMZ BOE VTFGVMMZ EFTDSJCF UIF CVTJOFTT EPNBJOBOEpOEUIFNPTUJNQPSUBOUDPSFEPNBJOPOXIJDI UP TQFOE NPTU PG PVS MJNJUFE SFTPVSDFT MFTT JNQPSUBOU TVQQPSUJOH TVCEPNBJOT XJUIPVU XIJDI PVS DPSF JT NVDI MFTT MJLFMZ UP TVDDFFE BOE MFTT JNQPSUBOU TVQQPSUJOH TVCEPNBJO XIJDI DBO CF TBGFMZ PVUTPVSDFE 8F GPDVT PO DPSFBOEBOENBOBHFJU`TDPNQMFYJUZCZEFTJHOJOHCPVOEFE DPOUFYUTUPDPOUBJOUIFTNBMMFSDPOTJTUFOUNPEFMT XIJDIBSF FBTJFSUPNBOBHFBOEUIJOHPG

Slide 88

Slide 88 text

%%%JTBTFUPGQBUUFSOTBOENFUIPETIFMQJOHUPNBLFTFOTF PGQSPCMFNTCZDPNCJOJOHpOFSHPPEEFWFMPQNFOUQSBDUJDFT JO UBDUJDBM EFTJHO BOE DPBSTFS HPPE EFTJHO QSBDUJDFT JO TUSBUFHJD EFTJHO JU GBDJMJUBUFT DPMMBCPSBUJPO CFUXFFO B UFBN BOEEPNBJOFYQFSUTBOEQSPNPUFTBEPQUJPOBOEXJEFVTFPG VCJRVJUPVT MBOHVBHF JO QSPCMFN EFTDSJQUJPO BT XFMM BT TPMVUJPO JNQMFNFOUBUJPO *O TUSBUFHJD EFTJHO XF CVJME WBSJPVT NPEFMT UP DPSSFDUMZ BOE VTFGVMMZ EFTDSJCF UIF CVTJOFTT EPNBJOBOEpOEUIFNPTUJNQPSUBOUDPSFEPNBJOPOXIJDI UP TQFOE NPTU PG PVS MJNJUFE SFTPVSDFT MFTT JNQPSUBOU TVQQPSUJOH TVCEPNBJOT XJUIPVU XIJDI PVS DPSF JT NVDI MFTT MJLFMZ UP TVDDFFE BOE MFTT JNQPSUBOU TVQQPSUJOH TVCEPNBJO XIJDI DBO CF TBGFMZ PVUTPVSDFE 8F GPDVT PO DPSFBOEBOENBOBHFJU`TDPNQMFYJUZCZEFTJHOJOHCPVOEFE DPOUFYUTUPDPOUBJOUIFTNBMMFSDPOTJTUFOUNPEFMT XIJDIBSF FBTJFSUPNBOBHFBOEUIJOHPG

Slide 89

Slide 89 text

%%%JTBTFUPGQBUUFSOTBOENFUIPETIFMQJOHUPNBLFTFOTF PGQSPCMFNTCZDPNCJOJOHpOFSHPPEEFWFMPQNFOUQSBDUJDFT JO UBDUJDBM EFTJHO BOE DPBSTFS HPPE EFTJHO QSBDUJDFT JO TUSBUFHJD EFTJHO JU GBDJMJUBUFT DPMMBCPSBUJPO CFUXFFO B UFBN BOEEPNBJOFYQFSUTBOEQSPNPUFTBEPQUJPOBOEXJEFVTFPG VCJRVJUPVT MBOHVBHF JO QSPCMFN EFTDSJQUJPO BT XFMM BT TPMVUJPO JNQMFNFOUBUJPO *O TUSBUFHJD EFTJHO XF CVJME WBSJPVT NPEFMT UP DPSSFDUMZ BOE VTFGVMMZ EFTDSJCF UIF CVTJOFTT EPNBJOBOEpOEUIFNPTUJNQPSUBOUDPSFEPNBJOPOXIJDI UP TQFOE NPTU PG PVS MJNJUFE SFTPVSDFT MFTT JNQPSUBOU TVQQPSUJOH TVCEPNBJOT XJUIPVU XIJDI PVS DPSF JT NVDI MFTT MJLFMZ UP TVDDFFE BOE MFTT JNQPSUBOU TVQQPSUJOH TVCEPNBJO XIJDI DBO CF TBGFMZ PVUTPVSDFE 8F GPDVT PO DPSFBOEBOENBOBHFJU`TDPNQMFYJUZCZEFTJHOJOHCPVOEFE DPOUFYUTUPDPOUBJOUIFTNBMMFSDPOTJTUFOUNPEFMT XIJDIBSF FBTJFSUPNBOBHFBOEUIJOHPG

Slide 90

Slide 90 text

%%%JTBTFUPGQBUUFSOTBOENFUIPETIFMQJOHUPNBLFTFOTF PGQSPCMFNTCZDPNCJOJOHpOFSHPPEEFWFMPQNFOUQSBDUJDFT JO UBDUJDBM EFTJHO BOE DPBSTFS HPPE EFTJHO QSBDUJDFT JO TUSBUFHJD EFTJHO JU GBDJMJUBUFT DPMMBCPSBUJPO CFUXFFO B UFBN BOEEPNBJOFYQFSUTBOEQSPNPUFTBEPQUJPOBOEXJEFVTFPG VCJRVJUPVT MBOHVBHF JO QSPCMFN EFTDSJQUJPO BT XFMM BT TPMVUJPO JNQMFNFOUBUJPO *O TUSBUFHJD EFTJHO XF CVJME WBSJPVT NPEFMT UP DPSSFDUMZ BOE VTFGVMMZ EFTDSJCF UIF CVTJOFTT EPNBJOBOEpOEUIFNPTUJNQPSUBOUDPSFEPNBJOPOXIJDI UP TQFOE NPTU PG PVS MJNJUFE SFTPVSDFT MFTT JNQPSUBOU TVQQPSUJOH TVCEPNBJOT XJUIPVU XIJDI PVS DPSF JT NVDI MFTT MJLFMZ UP TVDDFFE BOE MFBTU JNQPSUBOU TVQQPSUJOH TVCEPNBJO XIJDI DBO CF TBGFMZ PVUTPVSDFE 8F GPDVT PO DPSFBOEBOENBOBHFJU`TDPNQMFYJUZCZEFTJHOJOHCPVOEFE DPOUFYUTUPDPOUBJOUIFTNBMMFSDPOTJTUFOUNPEFMT XIJDIBSF FBTJFSUPNBOBHFBOEUIJOHPG

Slide 91

Slide 91 text

%%%JTBTFUPGQBUUFSOTBOENFUIPETIFMQJOHUPNBLFTFOTF PGQSPCMFNTCZDPNCJOJOHpOFSHPPEEFWFMPQNFOUQSBDUJDFT JO UBDUJDBM EFTJHO BOE DPBSTFS HPPE EFTJHO QSBDUJDFT JO TUSBUFHJD EFTJHO JU GBDJMJUBUFT DPMMBCPSBUJPO CFUXFFO B UFBN BOEEPNBJOFYQFSUTBOEQSPNPUFTBEPQUJPOBOEXJEFVTFPG VCJRVJUPVT MBOHVBHF JO QSPCMFN EFTDSJQUJPO BT XFMM BT TPMVUJPO JNQMFNFOUBUJPO *O TUSBUFHJD EFTJHO XF CVJME WBSJPVT NPEFMT UP DPSSFDUMZ BOE VTFGVMMZ EFTDSJCF UIF CVTJOFTT EPNBJOBOEpOEUIFNPTUJNQPSUBOUDPSFEPNBJOPOXIJDI UP TQFOE NPTU PG PVS MJNJUFE SFTPVSDFT MFTT JNQPSUBOU TVQQPSUJOH TVCEPNBJOT XJUIPVU XIJDI PVS DPSF JT NVDI MFTT MJLFMZ UP TVDDFFE BOE MFBTU JNQPSUBOU TVQQPSUJOH TVCEPNBJO XIJDI DBO CF TBGFMZ PVUTPVSDFE 8F GPDVT PO DPSFBOEBOENBOBHFJU`TDPNQMFYJUZCZEFTJHOJOHCPVOEFE DPOUFYUTUPDPOUBJOUIFTNBMMFSDPOTJTUFOUNPEFMT XIJDIBSF FBTJFSUPNBOBHFBOEUIJOHPG

Slide 92

Slide 92 text

%%%JTBTFUPGQBUUFSOTBOENFUIPETIFMQJOHUPNBLFTFOTF PGQSPCMFNTCZDPNCJOJOHpOFSHPPEEFWFMPQNFOUQSBDUJDFT JO UBDUJDBM EFTJHO BOE DPBSTFS HPPE EFTJHO QSBDUJDFT JO TUSBUFHJD EFTJHO JU GBDJMJUBUFT DPMMBCPSBUJPO CFUXFFO B UFBN BOEEPNBJOFYQFSUTBOEQSPNPUFTBEPQUJPOBOEXJEFVTFPG VCJRVJUPVT MBOHVBHF JO QSPCMFN EFTDSJQUJPO BT XFMM BT TPMVUJPO JNQMFNFOUBUJPO *O TUSBUFHJD EFTJHO XF CVJME WBSJPVT NPEFMT UP DPSSFDUMZ BOE VTFGVMMZ EFTDSJCF UIF CVTJOFTT EPNBJOBOEpOEUIFNPTUJNQPSUBOUDPSFEPNBJOPOXIJDI UP TQFOE NPTU PG PVS MJNJUFE SFTPVSDFT MFTT JNQPSUBOU TVQQPSUJOH TVCEPNBJOT XJUIPVU XIJDI PVS DPSF JT NVDI MFTT MJLFMZ UP TVDDFFE BOE MFBTU JNQPSUBOU TVQQPSUJOH TVCEPNBJO XIJDI DBO CF TBGFMZ PVUTPVSDFE 8F GPDVT PO DPSF BOE BOE NBOBHF JUT DPNQMFYJUZ CZ EFTJHOJOH CPVOEFE DPOUFYUTUPDPOUBJOUIFTNBMMFSDPOTJTUFOUNPEFMT XIJDIBSF FBTJFSUPNBOBHFBOEUIJOLPG

Slide 93

Slide 93 text

obviously cheesy stock picture of collaboration and handshake use at work in coming weeks

Slide 94

Slide 94 text

some picture related to constraint - maybe picture of tiny lift

Slide 95

Slide 95 text

learn in your team, with your team

Slide 96

Slide 96 text

get a “tool bag”

Slide 97

Slide 97 text

run big picture event storming for your project QIPUPIUUQTXXXqJDLSDPNQIPUPTHMPCBMY

Slide 98

Slide 98 text

XBMM QBQFS
 
 


Slide 99

Slide 99 text

XBMM QBQFS
 UPQFPQMF
 
 


Slide 100

Slide 100 text

XBMM QBQFS
 UPQFPQMF
 NBSLFSTBOETUJDLJFT
 


Slide 101

Slide 101 text

XBMM QBQFS
 UPQFPQMF
 NBSLFSTBOETUJDLJFT
 GBDJMJUBUPS


Slide 102

Slide 102 text

XBMM QBQFS
 UPQFPQMF
 NBSLFSTBOETUJDLJFT
 GBDJMJUBUPS
 CSBJOTUPSNEPNBJO


Slide 103

Slide 103 text

XBMM QBQFS
 UPQFPQMF
 NBSLFSTBOETUJDLJFT
 GBDJMJUBUPS
 CSBJOTUPSNEPNBJO
 FWFOUTJOQBTUUFOTF

Slide 104

Slide 104 text

No content

Slide 105

Slide 105 text

DPMMFDUJWFMFBSOJOHJTBHPBM
 
 
 
 
 
 
 


Slide 106

Slide 106 text

DPMMFDUJWFMFBSOJOHJTBHPBM 
 NPEFMJTNPTUMZVTFMFTT FYDFQU
 TUBSUJOHQPJOUGPSVCJRVJUPVT MBOHVBHF
 GPSJOJUJBMFEVDBUFEHVFTTFT POTFSWJDFTBOEEFTJHO
 UPWFSJGZUIFBMJHONFOUPG QSPDFTTXJUIFYJTUJOHTPMVUJPO

Slide 107

Slide 107 text

DPMMFDUJWFMFBSOJOHJTBHPBM 
 NPEFMJTNPTUMZVTFMFTT FYDFQU
 TUBSUJOHQPJOUGPSVCJRVJUPVT MBOHVBHF
 GPSJOJUJBMFEVDBUFEHVFTTFT POTFSWJDFTBOEEFTJHO
 UPWFSJGZUIFBMJHONFOUPG QSPDFTTXJUIFYJTUJOHTPMVUJPO

Slide 108

Slide 108 text

DPMMFDUJWFMFBSOJOHJTBHPBM 
 NPEFMJTNPTUMZVTFMFTT FYDFQU
 TUBSUJOHQPJOUGPSVCJRVJUPVT MBOHVBHF
 GPSJOJUJBMFEVDBUFEHVFTTFT POTFSWJDFTBOEEFTJHO
 UPWFSJGZUIFBMJHONFOUPG QSPDFTTXJUIFYJTUJOHTPMVUJPO

Slide 109

Slide 109 text

DPMMFDUJWFMFBSOJOHJTBHPBM 
 NPEFMJTNPTUMZVTFMFTT FYDFQU
 TUBSUJOHQPJOUGPSVCJRVJUPVT MBOHVBHF
 GPSJOJUJBMFEVDBUFEHVFTTFT POTFSWJDFTBOEEFTJHO
 UPWFSJGZUIFBMJHONFOUPG QSPDFTTXJUIFYJTUJOHTPMVUJPO

Slide 110

Slide 110 text

DSFBUFNBJOUBJOHMPTTBSZ PGVCJRVJUPVTMBOHVBHF

Slide 111

Slide 111 text

BMJHODPODFQUTJODPEF XJUIVCJRVJUPVTMBOHVBHF JOEPNBJO

Slide 112

Slide 112 text

5IFSFJTOPDPNQSFTTJPO BMHPSJUINGPSFYQFSJFODF "OEZ+BTTZ $&0"84

Slide 113

Slide 113 text

next meetup

Slide 114

Slide 114 text

books!

Slide 115

Slide 115 text

IUUQTXXXZPVUVCFDPNDIBOOFM 6$1(OI2ECU3JRY;,9#(R2 online video! IUUQTXXXZPVUVCFDPNDIBOOFM 6$+$QOTM1EC@%M%,PL9$)" IUUQTXXXZPVUVCFDPNDIBOOFM 6$DQ,(U.7W[E*49-M.(NBH

Slide 116

Slide 116 text

next conference!

Slide 117

Slide 117 text

1FPQMFEPOPUXBOUUPCVZB RVBSUFSJODIESJMM UIFZXBOUB RVBSUFSJODIIPMF
 
 5IFPEPSF-FWJUU
 FDPOPNJTU QSPGFTTPS

Slide 118

Slide 118 text

1FPQMFEPOPUXBOUUPCVZB RVBSUFSJODIESJMM UIFZXBOUB RVBSUFSJODIIPMF
 
 5IFPEPSF-FWJUU 
 
 
 UIBOLZPV


Slide 119

Slide 119 text

1FPQMFEPOPUXBOUUPCVZB RVBSUFSJODIESJMM UIFZXBOUB RVBSUFSJODIIPMF
 
 5IFPEPSF-FWJUU 
 
 
 UIBOLZPV
 MFU`TEJTDVTT