Solve Complex Problems with DDD

There are many ways to solve a problem at hand. The possibilities are endless, the risks are plentiful too: does the solution fit the problem? is it over engineered? is it naïvely oversimplified? do we need the software for this? does anyone care? - are just few of the questions popping up. Many practices and patterns help, but the choice is so wide it can be paralysing. Where do we start?

In this intro talk Arturas will step back to the fundamentals and explore the values of strategic design from a high 10 000 feet overview. By the end of it attendees will be equipped with the useful analogies of every day things with concepts used in DDD community, will have a reference on how it helps with problem solving and a solution design as well as get some useful hints on starting up.

The material is designed with new community members in mind, people who are starting to navigate DDD. It could be useful for experienced practitioners as a review and a discussion points for later as well.

About the speaker: Arturas Smorgun has been developing software for over 15 years, he gradually moved from hobby projects, through complex e-commerce monoliths to large data processing systems. In his career he learned to appreciate the domain complexity and employ his innate curiosity to help solve business problems. Currently he works for Worldpay from FIS, payment solutions provider.

Originally presented at DDD London, event page: https://www.meetup.com/dddlondon/events/266078247/

Transcript

1. some neutral picture, just a grey background? QIPUP
   IUUQTXXXqJDLSDPNQIPUPTKBZCMVF 4PMWF
   DPNQMFY
   QSPCMFNT "SUVSBT
   4NPSHVO
   %%%
   -POEPO
   .FFUVQ
   'FCSVBSZ
   
   XJUI
   %%%
2.  
 PG
   EFWFMPQFST
   DPEF
   BT
   IPCCZ
   IUUQTJOTJHIUTTUBDLPWFSqPXDPNTVSWFZEFWFMPQFSQSPpMF@DPEJOHBTBIPCCZ
3. 5FDI
    <㾎>
   #%%
   
 

4. 5FDI
    <㾎>
   #%%
    <㾎>
   5%%
   

5. 5FDI
    <㾎>
   #%%
    <㾎>
   5%%
    <㾎>
   $*
   
6. 5FDI
    <㾎>
   #%%
    <㾎>
   5%%
    <㾎>
   $*
    <㾎>
   $%
7.  
 PWFSBMM
   TPGUXBSF
   QSPKFDU
   TVDDFTT
   SBUF
   IUUQTXXXTUBOEJTIHSPVQDPNTBNQMF@SFTFBSDI@pMFT$)"043FQPSU'JOBMQEG
8.  
 NFEJVN
   TPGUXBSF
   QSPKFDU
 TVDDFTT
   SBUF
   IUUQTXXXTUBOEJTIHSPVQDPNTBNQMF@SFTFBSDI@pMFT$)"043FQPSU'JOBMQEG
9.  
 MBSHF
   TPGUXBSF
   QSPKFDU
 TVDDFTT
   SBUF
   IUUQTXXXTUBOEJTIHSPVQDPNTBNQMF@SFTFBSDI@pMFT$)"043FQPSU'JOBMQEG
10.  
 HSBOE
    TPGUXBSF
    QSPKFDU
 TVDDFTT
    SBUF
    IUUQTXXXTUBOEJTIHSPVQDPNTBNQMF@SFTFBSDI@pMFT$)"043FQPSU'JOBMQEG
11. 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 QIPUP
    IUUQTXXXqJDLSDPNQIPUPTKTIK
12. 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 BXLXBSE
    EFMJWFSBCMFT QIPUP
    IUUQTXXXqJDLSDPNQIPUPTKTIK
13. 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 GSFRVFOU
    JODJEFOUT QIPUP
    IUUQTXXXqJDLSDPNQIPUPTMJRVJECPOF[
14. 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 NJTTFE
    EFBEMJOFT QIPUP
    IUUQTXXXqJDLSDPNQIPUPTQPXFSMJOF
15. 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 FYIBVTUFE
    UFBN QIPUP
    IUUQTXXXqJDLSDPNQIPUPTGSVNCFSU -FHJU
    EBUBCBTF
    RVFSZ
     
    MJOFT
    BOE
    PWFS
     
    XPSET
 TPVSDF
    IUUQXXXECBPSBDMFDPNPSBDMF@OFXT@@@XPSMET@MPOHFTU@TRM@RVFSZIUN
16. 5FDI
     <㾎>
    #%%
     <㾎>
    5%%
     <㾎>
    $*
     <㾎>
    $%
17. lEFTJHO
    JT
    JOFWJUBCMF
 5IF
    BMUFSOBUJWF
    UP
    HPPE
    EFTJHO
    JT
    CBE
    EFTJHO 
 OPU
    OP
    EFTJHO
    BU
    BMMz
    Š
    %PVHMBT
    .BSUJO
    l#PPL
    %FTJHO
    "
    1SBDUJDBM
    *OUSPEVDUJPOz
    
18. 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/ #SFBL
    UIF
    #"%
    #"%
    NPOPMJUI QJDUVSF
    IUUQTXXXqJDLSDPNQIPUPTKVIBOTPOJO DB
19. photo: https://www.flickr.com/photos/-jvl-/ proto: https://www.flickr.com/photos/daryl_mitchell/ %P
    OPU
    DSFBUF
    UIF
    #"%?
    EJTUSJCVUFE
    NPOPMJUI QJDUVSF
    IUUQTXXXqJDLSDPNQIPUPTKVIBOTPOJO DB? DB? DB? DB? DB? DB? DB? DB? DB?
20. QIPUP
    IUUQTXXXqJDLSDPNQIPUPTEFOO %PNBJO
    %SJWFO
    %FTJHO
    ʜ
    TIPXT
    IPX
    EFTJHO
    BOE
    EFWFMPQNFOU
    DBO
    XPSL
    UPHFUIFS
    UP
    DSFBUF
    B
    CFUUFS
    TPMVUJPO
    (PPE
    EFTJHO
    XJMM
    BDDFMFSBUF
    UIF
    EFWFMPQNFOU
    XIJMF
    GFFECBDL
    DPNJOH
    GSPN
    UIF
    EFWFMPQNFOU
    QSPDFTT
    XJMM
    FOIBODF
    UIF
    EFTJHO
    
    l%PNBJO%SJWFO
    %FTJHO
    2VJDLMZz
    #PPL
     "CFM
    "WSBN
21. %0."*/ 
 %3*7&/
    %&4*(/
    QIPUP
    IUUQTXXXqJDLSDPNQIPUPTEFOO
22. 4"/%8*$) 
 %3*7&/
    %&4*(/
    QIPUP
    IUUQTXXXqJDLSDPNQIPUPTEFOO
23. #PCCZ
24. Sandwich #PCCZ Likes
25. Dad
26. Kitchen #PCCZ Dad
27. a generic monitoring solution brand name
28. Kitchen #PCCZ Dad
29. QIPUP
    IUUQTXXXqJDLSDPNQIPUPTEFOO "
    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 z
    3FQPSU
    0DU
     7MBEJL
    ,OPOPOPW
30. .0%&-4
31. few months
32. +
34. QIPUP
    IUUQTXXXqJDLSDPNQIPUPTEFOO 5BDUJDBM
    EFTJHO
    JT
    MJLF
    VTJOH
    B
    UIJO
    CSVTI
    UP
    QBJOU
    UIF
    pOF
    EFUBJMT
    PG
    ZPVS
    EPNBJO
    NPEFM l*NQMFNFOUJOH
    %PNBJO%SJWFO
    %FTJHOz
    #PPL
     7BVHI
    7FSOPO
35. maximise that at work
36. QIPUP
    IUUQTXXXqJDLSDPNQIPUPTEFOO <4USBUFHJD
    EFTJHO>
    EJTUJM
    UIF
    QSPCMFN
    EPNBJO
    BOE
    TIBQF
    UIF
    BSDIJUFDUVSF
    PG
    BO
    BQQMJDBUJPO l*NQMFNFOUJOH
    %PNBJO%SJWFO
    %FTJHOz
    #PPL
     /JDL
    5VOF
    
    4DPUU
    .JMMFUU
37. few years
45. QIPUP
    IUUQTXXXqJDLSDPNQIPUPTEFOO %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
    SFQSFTFOU
    UIF
    CVTJOFTT l8IBU
    *T
    %PNBJO%SJWFO
    %FTJHO z
    3FQPSU
    0DU
     7MBEJL
    ,OPOPOPW
47. QIPUP
    IUUQTXXXqJDLSDPNQIPUPTEFOO <6CJRVJUPVT
    MBOHVBHF >
    B
    TFDSFU
    MBOHVBHF
    FOBCMFT
    DPNQMFY
    UPQJDT
    UP
    CF
    DPWFSFE
    JO
    DPODJTF
    BOE
    NFBOJOHGVM
    EJBMPHVF
    XJUIPVU
    UIF
    OFFE
    GPS
    DPOGVTJOH
    CBCCMF
    *U`T
    WJUBM
    GPS
    B
    EFWFMPQNFOU
    UFBN
    UP
    VOEFSTUBOE
    BOE
    DPMMBCPSBUF
    PO
    UIJT
    MBOHVBHF l1BUUFSOT
    1SJODJQMFT
    BOE
    1SBDUJDFT
    PG
    %PNBJO%SJWFO
    %FTJHOz
    #PPL
    "QSJM
     /JDL
    5VOF
    
    4DPUU
    .JMMFUU
48. example from usual developer interaction
49. few weeks
50. from 1 to 30
54. from 30 to 300?
55. from 300 to 3M?
56. few decades
57. BOBBYS 2000 branches!
59. BOBBYS
60. BOBBYS
61. BOBBYS
62. BOBBYS
63. BOBBYS
64. BOBBYS
65. BOBBYS
66. BOBBYS
67. BOBBYS
68. BOBBYS
69. QIPUP
    IUUQTXXXqJDLSDPNQIPUPTEFOO "
    DPSF
    TVCEPNBJO
    JT
    XIBU
    B
    DPNQBOZ
    EPFT
    EJ⒎FSFOUMZ
    GSPN
    JUT
    DPNQFUJUPST
    5IJT
    NBZ
    JOWPMWF
    JOWFOUJOH
    OFX
    QSPEVDUT
    PS
    TFSWJDFT
    PS
    PQUJNJ[JOH
    FYJTUJOH
    QSPDFTTFT
    BOE
    UIFSFCZ
    SFEVDJOH
    DPTUT 7MBEJL
    ,IPOPOPW l8IBU
    *T
    %PNBJO%SJWFO
    %FTJHO z
    3FQPSU
    0DU
    
70. BOBBYS
71. BOBBYS
72. QIPUP
    IUUQTXXXqJDLSDPNQIPUPTEFOO <4VQQPSUJOH
    TVCEPNBJO>
    JT
    TUJMM
    BO
    JNQPSUBOU
    TPGUXBSF
    NPEFM
    CFDBVTF
    ZPVS
    $PSF
    %PNBJO
    DBOOPU
    CF
    TVDDFTTGVM
    XJUIPVU
    JU l*NQMFNFOUJOH
    %PNBJO%SJWFO
    %FTJHOz
    #PPL
     7BVHI
    7FSOPO
73. BOBBYS
74. BOBBYS
75. QIPUP
    IUUQTXXXqJDLSDPNQIPUPTEFOO (FOFSJD
    TVCEPNBJOT
    EP
    OPU
    QSPWJEF
    BOZ
    DPNQFUJUJWF
    FEHF
    GPS
    UIF
    DPNQBOZ
    ʜ
    CVTJOFTT
    BDUJWJUJFT
    UIBU
    BMM
    DPNQBOJFT
    BSF
    QFSGPSNJOH
    JO
    UIF
    TBNF
    XBZ
    
    l8IBU
    *T
    %PNBJO%SJWFO
    %FTJHO z
    3FQPSU
    0DU
     7MBEJL
    ,OPOPOPW
76. BOBBYS
77. BOBBYS
78. BOBBYS
79. QIPUP
    IUUQTXXXqJDLSDPNQIPUPTEFOO <#PVOEFE
    DPOUFYU
    JT>
    B
    TNBMM
    TUSPOHMZ
    TFNBOUJDBMMZ
    DPOTJTUFOU
    NPEFM
    ʜ
    B
    QPSUJPO
    PG
    UIF
    NPEFM
    XIJDI
    XF
    NVTU
    LFFQ
    BNCJHVJUZ
    GSFF l*OUSPEVDJOH
    &WFOU4UPSNJOH
    "O
    BDU
    PG
    %FMJCFSBUF
    $PMMFDUJWF
    -FBSOJOHz
    3FQPSU
    "VH
     "MCFSUP
    #SBOEPMJOJ
80. 4"/%8*$) 
 %3*7&/
    %&4*(/
    QIPUP
    IUUQTXXXqJDLSDPNQIPUPTEFOO
81. %0."*/ 
 %3*7&/
    %&4*(/
    QIPUP
    IUUQTXXXqJDLSDPNQIPUPTEFOO
82. %%%
    JT
    B
    TFU
    PG
    QBUUFSOT
    BOE
    NFUIPET
    IFMQJOH
    UP
    NBLF
    TFOTF
    PG
    QSPCMFNT
    CZ
    DPNCJOJOH
    pOFS
    HPPE
    EFWFMPQNFOU
    QSBDUJDFT
    JO
    UBDUJDBM
    EFTJHO
    BOE
    DPBSTFS
    HPPE
    EFTJHO
    QSBDUJDFT
    JO
    TUSBUFHJD
    EFTJHO
    JU
    GBDJMJUBUFT
    DPMMBCPSBUJPO
    CFUXFFO
    B
    UFBN
    BOE
    EPNBJO
    FYQFSUT
    BOE
    QSPNPUFT
    BEPQUJPO
    BOE
    XJEF
    VTF
    PG
    VCJRVJUPVT
    MBOHVBHF
    JO
    QSPCMFN
    EFTDSJQUJPO
    BT
    XFMM
    BT
    TPMVUJPO
    JNQMFNFOUBUJPO
    *O
    TUSBUFHJD
    EFTJHO
    XF
    CVJME
    WBSJPVT
    NPEFMT
    UP
    DPSSFDUMZ
    BOE
    VTFGVMMZ
    EFTDSJCF
    UIF
    CVTJOFTT
    EPNBJO
    BOE
    pOE
    UIF
    NPTU
    JNQPSUBOU
    DPSF
    EPNBJO
    PO
    XIJDI
    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
    DPSF
    BOE
    BOE
    NBOBHF
    JU`T
    DPNQMFYJUZ
    CZ
    EFTJHOJOH
    CPVOEFE
    DPOUFYUT
    UP
    DPOUBJO
    UIF
    TNBMMFS
    DPOTJTUFOU
    NPEFMT
    XIJDI
    BSF
    FBTJFS
    UP
    NBOBHF
    BOE
    UIJOH
    PG
83. %%%
    JT
    B
    TFU
    PG
    QBUUFSOT
    BOE
    NFUIPET
    IFMQJOH
    UP
    NBLF
    TFOTF
    PG
    QSPCMFNT
    CZ
    DPNCJOJOH
    pOFS
    HPPE
    EFWFMPQNFOU
    QSBDUJDFT
    JO
    UBDUJDBM
    EFTJHO
    BOE
    DPBSTFS
    HPPE
    EFTJHO
    QSBDUJDFT
    JO
    TUSBUFHJD
    EFTJHO
    JU
    GBDJMJUBUFT
    DPMMBCPSBUJPO
    CFUXFFO
    B
    UFBN
    BOE
    EPNBJO
    FYQFSUT
    BOE
    QSPNPUFT
    BEPQUJPO
    BOE
    XJEF
    VTF
    PG
    VCJRVJUPVT
    MBOHVBHF
    JO
    QSPCMFN
    EFTDSJQUJPO
    BT
    XFMM
    BT
    TPMVUJPO
    JNQMFNFOUBUJPO
    *O
    TUSBUFHJD
    EFTJHO
    XF
    CVJME
    WBSJPVT
    NPEFMT
    UP
    DPSSFDUMZ
    BOE
    VTFGVMMZ
    EFTDSJCF
    UIF
    CVTJOFTT
    EPNBJO
    BOE
    pOE
    UIF
    NPTU
    JNQPSUBOU
    DPSF
    EPNBJO
    PO
    XIJDI
    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
    DPSF
    BOE
    BOE
    NBOBHF
    JU`T
    DPNQMFYJUZ
    CZ
    EFTJHOJOH
    CPVOEFE
    DPOUFYUT
    UP
    DPOUBJO
    UIF
    TNBMMFS
    DPOTJTUFOU
    NPEFMT
    XIJDI
    BSF
    FBTJFS
    UP
    NBOBHF
    BOE
    UIJOH
    PG
84. %%%
    JT
    B
    TFU
    PG
    QBUUFSOT
    BOE
    NFUIPET
    IFMQJOH
    UP
    NBLF
    TFOTF
    PG
    QSPCMFNT
    CZ
    DPNCJOJOH
    pOFS
    HPPE
    EFWFMPQNFOU
    QSBDUJDFT
    JO
    UBDUJDBM
    EFTJHO
    BOE
    DPBSTFS
    HPPE
    EFTJHO
    QSBDUJDFT
    JO
    TUSBUFHJD
    EFTJHO
    JU
    GBDJMJUBUFT
    DPMMBCPSBUJPO
    CFUXFFO
    B
    UFBN
    BOE
    EPNBJO
    FYQFSUT
    BOE
    QSPNPUFT
    BEPQUJPO
    BOE
    XJEF
    VTF
    PG
    VCJRVJUPVT
    MBOHVBHF
    JO
    QSPCMFN
    EFTDSJQUJPO
    BT
    XFMM
    BT
    TPMVUJPO
    JNQMFNFOUBUJPO
    *O
    TUSBUFHJD
    EFTJHO
    XF
    CVJME
    WBSJPVT
    NPEFMT
    UP
    DPSSFDUMZ
    BOE
    VTFGVMMZ
    EFTDSJCF
    UIF
    CVTJOFTT
    EPNBJO
    BOE
    pOE
    UIF
    NPTU
    JNQPSUBOU
    DPSF
    EPNBJO
    PO
    XIJDI
    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
    DPSF
    BOE
    BOE
    NBOBHF
    JU`T
    DPNQMFYJUZ
    CZ
    EFTJHOJOH
    CPVOEFE
    DPOUFYUT
    UP
    DPOUBJO
    UIF
    TNBMMFS
    DPOTJTUFOU
    NPEFMT
    XIJDI
    BSF
    FBTJFS
    UP
    NBOBHF
    BOE
    UIJOH
    PG
85. %%%
    JT
    B
    TFU
    PG
    QBUUFSOT
    BOE
    NFUIPET
    IFMQJOH
    UP
    NBLF
    TFOTF
    PG
    QSPCMFNT
    CZ
    DPNCJOJOH
    pOFS
    HPPE
    EFWFMPQNFOU
    QSBDUJDFT
    JO
    UBDUJDBM
    EFTJHO
    BOE
    DPBSTFS
    HPPE
    EFTJHO
    QSBDUJDFT
    JO
    TUSBUFHJD
    EFTJHO
    JU
    GBDJMJUBUFT
    DPMMBCPSBUJPO
    CFUXFFO
    B
    UFBN
    BOE
    EPNBJO
    FYQFSUT
    BOE
    QSPNPUFT
    BEPQUJPO
    BOE
    XJEF
    VTF
    PG
    VCJRVJUPVT
    MBOHVBHF
    JO
    QSPCMFN
    EFTDSJQUJPO
    BT
    XFMM
    BT
    TPMVUJPO
    JNQMFNFOUBUJPO
    *O
    TUSBUFHJD
    EFTJHO
    XF
    CVJME
    WBSJPVT
    NPEFMT
    UP
    DPSSFDUMZ
    BOE
    VTFGVMMZ
    EFTDSJCF
    UIF
    CVTJOFTT
    EPNBJO
    BOE
    pOE
    UIF
    NPTU
    JNQPSUBOU
    DPSF
    EPNBJO
    PO
    XIJDI
    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
    DPSF
    BOE
    BOE
    NBOBHF
    JU`T
    DPNQMFYJUZ
    CZ
    EFTJHOJOH
    CPVOEFE
    DPOUFYUT
    UP
    DPOUBJO
    UIF
    TNBMMFS
    DPOTJTUFOU
    NPEFMT
    XIJDI
    BSF
    FBTJFS
    UP
    NBOBHF
    BOE
    UIJOH
    PG
86. %%%
    JT
    B
    TFU
    PG
    QBUUFSOT
    BOE
    NFUIPET
    IFMQJOH
    UP
    NBLF
    TFOTF
    PG
    QSPCMFNT
    CZ
    DPNCJOJOH
    pOFS
    HPPE
    EFWFMPQNFOU
    QSBDUJDFT
    JO
    UBDUJDBM
    EFTJHO
    BOE
    DPBSTFS
    HPPE
    EFTJHO
    QSBDUJDFT
    JO
    TUSBUFHJD
    EFTJHO
    JU
    GBDJMJUBUFT
    DPMMBCPSBUJPO
    CFUXFFO
    B
    UFBN
    BOE
    EPNBJO
    FYQFSUT
    BOE
    QSPNPUFT
    BEPQUJPO
    BOE
    XJEF
    VTF
    PG
    VCJRVJUPVT
    MBOHVBHF
    JO
    QSPCMFN
    EFTDSJQUJPO
    BT
    XFMM
    BT
    TPMVUJPO
    JNQMFNFOUBUJPO
    *O
    TUSBUFHJD
    EFTJHO
    XF
    CVJME
    WBSJPVT
    NPEFMT
    UP
    DPSSFDUMZ
    BOE
    VTFGVMMZ
    EFTDSJCF
    UIF
    CVTJOFTT
    EPNBJO
    BOE
    pOE
    UIF
    NPTU
    JNQPSUBOU
    DPSF
    EPNBJO
    PO
    XIJDI
    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
    DPSF
    BOE
    BOE
    NBOBHF
    JU`T
    DPNQMFYJUZ
    CZ
    EFTJHOJOH
    CPVOEFE
    DPOUFYUT
    UP
    DPOUBJO
    UIF
    TNBMMFS
    DPOTJTUFOU
    NPEFMT
    XIJDI
    BSF
    FBTJFS
    UP
    NBOBHF
    BOE
    UIJOH
    PG
87. %%%
    JT
    B
    TFU
    PG
    QBUUFSOT
    BOE
    NFUIPET
    IFMQJOH
    UP
    NBLF
    TFOTF
    PG
    QSPCMFNT
    CZ
    DPNCJOJOH
    pOFS
    HPPE
    EFWFMPQNFOU
    QSBDUJDFT
    JO
    UBDUJDBM
    EFTJHO
    BOE
    DPBSTFS
    HPPE
    EFTJHO
    QSBDUJDFT
    JO
    TUSBUFHJD
    EFTJHO
    JU
    GBDJMJUBUFT
    DPMMBCPSBUJPO
    CFUXFFO
    B
    UFBN
    BOE
    EPNBJO
    FYQFSUT
    BOE
    QSPNPUFT
    BEPQUJPO
    BOE
    XJEF
    VTF
    PG
    VCJRVJUPVT
    MBOHVBHF
    JO
    QSPCMFN
    EFTDSJQUJPO
    BT
    XFMM
    BT
    TPMVUJPO
    JNQMFNFOUBUJPO
    *O
    TUSBUFHJD
    EFTJHO
    XF
    CVJME
    WBSJPVT
    NPEFMT
    UP
    DPSSFDUMZ
    BOE
    VTFGVMMZ
    EFTDSJCF
    UIF
    CVTJOFTT
    EPNBJO
    BOE
    pOE
    UIF
    NPTU
    JNQPSUBOU
    DPSF
    EPNBJO
    PO
    XIJDI
    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
    DPSF
    BOE
    BOE
    NBOBHF
    JU`T
    DPNQMFYJUZ
    CZ
    EFTJHOJOH
    CPVOEFE
    DPOUFYUT
    UP
    DPOUBJO
    UIF
    TNBMMFS
    DPOTJTUFOU
    NPEFMT
    XIJDI
    BSF
    FBTJFS
    UP
    NBOBHF
    BOE
    UIJOH
    PG
88. %%%
    JT
    B
    TFU
    PG
    QBUUFSOT
    BOE
    NFUIPET
    IFMQJOH
    UP
    NBLF
    TFOTF
    PG
    QSPCMFNT
    CZ
    DPNCJOJOH
    pOFS
    HPPE
    EFWFMPQNFOU
    QSBDUJDFT
    JO
    UBDUJDBM
    EFTJHO
    BOE
    DPBSTFS
    HPPE
    EFTJHO
    QSBDUJDFT
    JO
    TUSBUFHJD
    EFTJHO
    JU
    GBDJMJUBUFT
    DPMMBCPSBUJPO
    CFUXFFO
    B
    UFBN
    BOE
    EPNBJO
    FYQFSUT
    BOE
    QSPNPUFT
    BEPQUJPO
    BOE
    XJEF
    VTF
    PG
    VCJRVJUPVT
    MBOHVBHF
    JO
    QSPCMFN
    EFTDSJQUJPO
    BT
    XFMM
    BT
    TPMVUJPO
    JNQMFNFOUBUJPO
    *O
    TUSBUFHJD
    EFTJHO
    XF
    CVJME
    WBSJPVT
    NPEFMT
    UP
    DPSSFDUMZ
    BOE
    VTFGVMMZ
    EFTDSJCF
    UIF
    CVTJOFTT
    EPNBJO
    BOE
    pOE
    UIF
    NPTU
    JNQPSUBOU
    DPSF
    EPNBJO
    PO
    XIJDI
    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
    DPSF
    BOE
    BOE
    NBOBHF
    JU`T
    DPNQMFYJUZ
    CZ
    EFTJHOJOH
    CPVOEFE
    DPOUFYUT
    UP
    DPOUBJO
    UIF
    TNBMMFS
    DPOTJTUFOU
    NPEFMT
    XIJDI
    BSF
    FBTJFS
    UP
    NBOBHF
    BOE
    UIJOH
    PG
89. %%%
    JT
    B
    TFU
    PG
    QBUUFSOT
    BOE
    NFUIPET
    IFMQJOH
    UP
    NBLF
    TFOTF
    PG
    QSPCMFNT
    CZ
    DPNCJOJOH
    pOFS
    HPPE
    EFWFMPQNFOU
    QSBDUJDFT
    JO
    UBDUJDBM
    EFTJHO
    BOE
    DPBSTFS
    HPPE
    EFTJHO
    QSBDUJDFT
    JO
    TUSBUFHJD
    EFTJHO
    JU
    GBDJMJUBUFT
    DPMMBCPSBUJPO
    CFUXFFO
    B
    UFBN
    BOE
    EPNBJO
    FYQFSUT
    BOE
    QSPNPUFT
    BEPQUJPO
    BOE
    XJEF
    VTF
    PG
    VCJRVJUPVT
    MBOHVBHF
    JO
    QSPCMFN
    EFTDSJQUJPO
    BT
    XFMM
    BT
    TPMVUJPO
    JNQMFNFOUBUJPO
    *O
    TUSBUFHJD
    EFTJHO
    XF
    CVJME
    WBSJPVT
    NPEFMT
    UP
    DPSSFDUMZ
    BOE
    VTFGVMMZ
    EFTDSJCF
    UIF
    CVTJOFTT
    EPNBJO
    BOE
    pOE
    UIF
    NPTU
    JNQPSUBOU
    DPSF
    EPNBJO
    PO
    XIJDI
    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
    DPSF
    BOE
    BOE
    NBOBHF
    JU`T
    DPNQMFYJUZ
    CZ
    EFTJHOJOH
    CPVOEFE
    DPOUFYUT
    UP
    DPOUBJO
    UIF
    TNBMMFS
    DPOTJTUFOU
    NPEFMT
    XIJDI
    BSF
    FBTJFS
    UP
    NBOBHF
    BOE
    UIJOH
    PG
90. %%%
    JT
    B
    TFU
    PG
    QBUUFSOT
    BOE
    NFUIPET
    IFMQJOH
    UP
    NBLF
    TFOTF
    PG
    QSPCMFNT
    CZ
    DPNCJOJOH
    pOFS
    HPPE
    EFWFMPQNFOU
    QSBDUJDFT
    JO
    UBDUJDBM
    EFTJHO
    BOE
    DPBSTFS
    HPPE
    EFTJHO
    QSBDUJDFT
    JO
    TUSBUFHJD
    EFTJHO
    JU
    GBDJMJUBUFT
    DPMMBCPSBUJPO
    CFUXFFO
    B
    UFBN
    BOE
    EPNBJO
    FYQFSUT
    BOE
    QSPNPUFT
    BEPQUJPO
    BOE
    XJEF
    VTF
    PG
    VCJRVJUPVT
    MBOHVBHF
    JO
    QSPCMFN
    EFTDSJQUJPO
    BT
    XFMM
    BT
    TPMVUJPO
    JNQMFNFOUBUJPO
    *O
    TUSBUFHJD
    EFTJHO
    XF
    CVJME
    WBSJPVT
    NPEFMT
    UP
    DPSSFDUMZ
    BOE
    VTFGVMMZ
    EFTDSJCF
    UIF
    CVTJOFTT
    EPNBJO
    BOE
    pOE
    UIF
    NPTU
    JNQPSUBOU
    DPSF
    EPNBJO
    PO
    XIJDI
    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
    JU`T
    DPNQMFYJUZ
    CZ
    EFTJHOJOH
    CPVOEFE
    DPOUFYUT
    UP
    DPOUBJO
    UIF
    TNBMMFS
    DPOTJTUFOU
    NPEFMT
    XIJDI
    BSF
    FBTJFS
    UP
    NBOBHF
    BOE
    UIJOH
    PG
91. %%%
    JT
    B
    TFU
    PG
    QBUUFSOT
    BOE
    NFUIPET
    IFMQJOH
    UP
    NBLF
    TFOTF
    PG
    QSPCMFNT
    CZ
    DPNCJOJOH
    pOFS
    HPPE
    EFWFMPQNFOU
    QSBDUJDFT
    JO
    UBDUJDBM
    EFTJHO
    BOE
    DPBSTFS
    HPPE
    EFTJHO
    QSBDUJDFT
    JO
    TUSBUFHJD
    EFTJHO
    JU
    GBDJMJUBUFT
    DPMMBCPSBUJPO
    CFUXFFO
    B
    UFBN
    BOE
    EPNBJO
    FYQFSUT
    BOE
    QSPNPUFT
    BEPQUJPO
    BOE
    XJEF
    VTF
    PG
    VCJRVJUPVT
    MBOHVBHF
    JO
    QSPCMFN
    EFTDSJQUJPO
    BT
    XFMM
    BT
    TPMVUJPO
    JNQMFNFOUBUJPO
    *O
    TUSBUFHJD
    EFTJHO
    XF
    CVJME
    WBSJPVT
    NPEFMT
    UP
    DPSSFDUMZ
    BOE
    VTFGVMMZ
    EFTDSJCF
    UIF
    CVTJOFTT
    EPNBJO
    BOE
    pOE
    UIF
    NPTU
    JNQPSUBOU
    DPSF
    EPNBJO
    PO
    XIJDI
    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
    JU`T
    DPNQMFYJUZ
    CZ
    EFTJHOJOH
    CPVOEFE
    DPOUFYUT
    UP
    DPOUBJO
    UIF
    TNBMMFS
    DPOTJTUFOU
    NPEFMT
    XIJDI
    BSF
    FBTJFS
    UP
    NBOBHF
    BOE
    UIJOH
    PG
92. %%%
    JT
    B
    TFU
    PG
    QBUUFSOT
    BOE
    NFUIPET
    IFMQJOH
    UP
    NBLF
    TFOTF
    PG
    QSPCMFNT
    CZ
    DPNCJOJOH
    pOFS
    HPPE
    EFWFMPQNFOU
    QSBDUJDFT
    JO
    UBDUJDBM
    EFTJHO
    BOE
    DPBSTFS
    HPPE
    EFTJHO
    QSBDUJDFT
    JO
    TUSBUFHJD
    EFTJHO
    JU
    GBDJMJUBUFT
    DPMMBCPSBUJPO
    CFUXFFO
    B
    UFBN
    BOE
    EPNBJO
    FYQFSUT
    BOE
    QSPNPUFT
    BEPQUJPO
    BOE
    XJEF
    VTF
    PG
    VCJRVJUPVT
    MBOHVBHF
    JO
    QSPCMFN
    EFTDSJQUJPO
    BT
    XFMM
    BT
    TPMVUJPO
    JNQMFNFOUBUJPO
    *O
    TUSBUFHJD
    EFTJHO
    XF
    CVJME
    WBSJPVT
    NPEFMT
    UP
    DPSSFDUMZ
    BOE
    VTFGVMMZ
    EFTDSJCF
    UIF
    CVTJOFTT
    EPNBJO
    BOE
    pOE
    UIF
    NPTU
    JNQPSUBOU
    DPSF
    EPNBJO
    PO
    XIJDI
    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
    DPOUFYUT
    UP
    DPOUBJO
    UIF
    TNBMMFS
    DPOTJTUFOU
    NPEFMT
    XIJDI
    BSF
    FBTJFS
    UP
    NBOBHF
    BOE
    UIJOL
    PG
93. obviously cheesy stock picture of collaboration and handshake use at work in coming weeks
94. some picture related to constraint - maybe picture of tiny lift
95. learn in your team, with your team
96. get a “tool bag”
97. run big picture event storming for your project QIPUP
    IUUQTXXXqJDLSDPNQIPUPTHMPCBMY
98. 
    XBMM
    QBQFS
 
 

99. 
    XBMM
    QBQFS
 
    
    UP
    
    QFPQMF
 
 

100. 
     XBMM
     QBQFS
 
     
     UP
     
     QFPQMF
 
     NBSLFST
     BOE
     TUJDLJFT
 

101. 
     XBMM
     QBQFS
 
     
     UP
     
     QFPQMF
 
     NBSLFST
     BOE
     TUJDLJFT
 
     GBDJMJUBUPS

102. 
     XBMM
     QBQFS
 
     
     UP
     
     QFPQMF
 
     NBSLFST
     BOE
     TUJDLJFT
 
     GBDJMJUBUPS
 
     CSBJOTUPSN
     EPNBJO

103. 
     XBMM
     QBQFS
 
     
     UP
     
     QFPQMF
 
     NBSLFST
     BOE
     TUJDLJFT
 
     GBDJMJUBUPS
 
     CSBJOTUPSN
     EPNBJO
 
     FWFOUT
     JO
     QBTU
     UFOTF
105. DPMMFDUJWF
     MFBSOJOH
     JT
     B
     HPBM
     
 
 
 
 
 
 
 

106. DPMMFDUJWF
     MFBSOJOH
     JT
     B
     HPBM 
 NPEFM
     JT
     NPTUMZ
     VTFMFTT
     FYDFQU
 
     TUBSUJOH
     QPJOU
     GPS
     VCJRVJUPVT
     MBOHVBHF
 
     GPS
     JOJUJBM
     FEVDBUFE
     HVFTTFT
     PO
     TFSWJDFT
     BOE
     EFTJHO
 
     UP
     WFSJGZ
     UIF
     BMJHONFOU
     PG
     QSPDFTT
     XJUI
     FYJTUJOH
     TPMVUJPO
107. DPMMFDUJWF
     MFBSOJOH
     JT
     B
     HPBM 
 NPEFM
     JT
     NPTUMZ
     VTFMFTT
     FYDFQU
 
     TUBSUJOH
     QPJOU
     GPS
     VCJRVJUPVT
     MBOHVBHF
 
     GPS
     JOJUJBM
     FEVDBUFE
     HVFTTFT
     PO
     TFSWJDFT
     BOE
     EFTJHO
 
     UP
     WFSJGZ
     UIF
     BMJHONFOU
     PG
     QSPDFTT
     XJUI
     FYJTUJOH
     TPMVUJPO
108. DPMMFDUJWF
     MFBSOJOH
     JT
     B
     HPBM 
 NPEFM
     JT
     NPTUMZ
     VTFMFTT
     FYDFQU
 
     TUBSUJOH
     QPJOU
     GPS
     VCJRVJUPVT
     MBOHVBHF
 
     GPS
     JOJUJBM
     FEVDBUFE
     HVFTTFT
     PO
     TFSWJDFT
     BOE
     EFTJHO
 
     UP
     WFSJGZ
     UIF
     BMJHONFOU
     PG
     QSPDFTT
     XJUI
     FYJTUJOH
     TPMVUJPO
109. DPMMFDUJWF
     MFBSOJOH
     JT
     B
     HPBM 
 NPEFM
     JT
     NPTUMZ
     VTFMFTT
     FYDFQU
 
     TUBSUJOH
     QPJOU
     GPS
     VCJRVJUPVT
     MBOHVBHF
 
     GPS
     JOJUJBM
     FEVDBUFE
     HVFTTFT
     PO
     TFSWJDFT
     BOE
     EFTJHO
 
     UP
     WFSJGZ
     UIF
     BMJHONFOU
     PG
     QSPDFTT
     XJUI
     FYJTUJOH
     TPMVUJPO
110. DSFBUF
     
     NBJOUBJO
     HMPTTBSZ
     PG
     VCJRVJUPVT
     MBOHVBHF
111. BMJHO
     DPODFQUT
     JO
     DPEF
     XJUI
     VCJRVJUPVT
     MBOHVBHF
     JO
     EPNBJO
112. 5IFSF
     JT
     OP
     DPNQSFTTJPO
     BMHPSJUIN
     GPS
     FYQFSJFODF
     
     
     "OEZ
     +BTTZ
     $&0
     "84
113. next meetup
114. books!
115. IUUQTXXXZPVUVCFDPNDIBOOFM 6$1(OI2ECU3JRY;,9#(R2 online video! IUUQTXXXZPVUVCFDPNDIBOOFM 6$+$QOTM1EC@%M%,PL9$)" IUUQTXXXZPVUVCFDPNDIBOOFM 6$DQ,(U.7W[E*49-M.(NBH
116. next conference!
117. 1FPQMF
     EP
     OPU
     XBOU
     UP
     CVZ
     B
     RVBSUFSJODI
     ESJMM
     UIFZ
     XBOU
     B
     RVBSUFSJODI
     IPMF
 
 
     5IFPEPSF
     -FWJUU
 FDPOPNJTU
     QSPGFTTPS
     
118. 1FPQMF
     EP
     OPU
     XBOU
     UP
     CVZ
     B
     RVBSUFSJODI
     ESJMM
     UIFZ
     XBOU
     B
     RVBSUFSJODI
     IPMF
 
 
     5IFPEPSF
     -FWJUU
     
 
 
 UIBOL
     ZPV

119. 1FPQMF
     EP
     OPU
     XBOU
     UP
     CVZ
     B
     RVBSUFSJODI
     ESJMM
     UIFZ
     XBOU
     B
     RVBSUFSJODI
     IPMF
 
 
     5IFPEPSF
     -FWJUU
     
 
 
 UIBOL
     ZPV
 MFU`T
     EJTDVTT