Solve Complex Problems with DDD

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

  PGEFWFMPQFST DPEFBTIPCCZ IUUQTJOTJHIUTTUBDLPWFSqPXDPNTVSWFZEFWFMPQFSQSPpMF@DPEJOHBTBIPCCZ

5FDI <㾎>#%%    

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

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

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

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

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

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

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

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

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

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[

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

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

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

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

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.ﬂickr.com/photos/-jvl-/ proto: https://www.ﬂickr.com/photos/daryl_mitchell/ #SFBLUIF#"%#"%NPOPMJUI QJDUVSFIUUQTXXXqJDLSDPNQIPUPTKVIBOTPOJO DB

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

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

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

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

Sandwich #PCCZ Likes

Kitchen #PCCZ Dad

a generic monitoring solution brand name

Kitchen #PCCZ Dad

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

.0%&-4

few months

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

maximise that at work

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

few years

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

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

example from usual developer interaction

few weeks

from 1 to 30

from 30 to 300?

from 300 to 3M?

few decades

BOBBYS 2000 branches!

BOBBYS

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

BOBBYS

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

BOBBYS

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

BOBBYS

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

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

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

%%%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

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

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

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

some picture related to constraint - maybe picture of tiny
lift

learn in your team, with your team

get a “tool bag”

run big picture event storming for your project QIPUPIUUQTXXXqJDLSDPNQIPUPTHMPCBMY

XBMM QBQFS     

XBMM QBQFS  UPQFPQMF     

XBMM QBQFS  UPQFPQMF  NBSLFSTBOETUJDLJFT   

XBMM QBQFS  UPQFPQMF  NBSLFSTBOETUJDLJFT  GBDJMJUBUPS 

XBMM QBQFS  UPQFPQMF  NBSLFSTBOETUJDLJFT  GBDJMJUBUPS  CSBJOTUPSNEPNBJO 

XBMM QBQFS  UPQFPQMF  NBSLFSTBOETUJDLJFT  GBDJMJUBUPS  CSBJOTUPSNEPNBJO  FWFOUTJOQBTUUFOTF

DPMMFDUJWFMFBSOJOHJTBHPBM               

DPMMFDUJWFMFBSOJOHJTBHPBM   NPEFMJTNPTUMZVTFMFTT FYDFQU  TUBSUJOHQPJOUGPSVCJRVJUPVT MBOHVBHF  GPSJOJUJBMFEVDBUFEHVFTTFT POTFSWJDFTBOEEFTJHO  UPWFSJGZUIFBMJHONFOUPG
QSPDFTTXJUIFYJTUJOHTPMVUJPO

DSFBUFNBJOUBJOHMPTTBSZ PGVCJRVJUPVTMBOHVBHF

BMJHODPODFQUTJODPEF XJUIVCJRVJUPVTMBOHVBHF JOEPNBJO

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

next meetup

books!

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

next conference!

1FPQMFEPOPUXBOUUPCVZB RVBSUFSJODIESJMM UIFZXBOUB RVBSUFSJODIIPMF    5IFPEPSF-FWJUU  FDPOPNJTU QSPGFTTPS

1FPQMFEPOPUXBOUUPCVZB RVBSUFSJODIESJMM UIFZXBOUB RVBSUFSJODIIPMF    5IFPEPSF-FWJUU       UIBOLZPV 

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

Solve Complex Problems with DDD

Solve Complex Problems with DDD

More Decks by Arturas Smorgun

Other Decks in Business

Featured

Transcript