Upgrade to Pro — share decks privately, control downloads, hide ads and more …

Solve Complex Problems with DDD

Arturas Smorgun
February 18, 2020

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/

Arturas Smorgun

February 18, 2020
Tweet

More Decks by Arturas Smorgun

Other Decks in Business

Transcript

  1. 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
  2. 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
  3. 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[
  4. 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
  5. 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
  6. 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
  7. 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
  8. Dad

  9. 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
  10. +

  11. 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
  12. 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
  13. 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
  14. QIPUPIUUQTXXXqJDLSDPNQIPUPTEFOO <4VQQPSUJOH TVCEPNBJO> JT TUJMM BO JNQPSUBOU TPGUXBSF NPEFM 

    CFDBVTF ZPVS $PSF %PNBJO DBOOPU CF TVDDFTTGVMXJUIPVUJU l*NQMFNFOUJOH%PNBJO%SJWFO%FTJHOz#PPL  7BVHI7FSOPO
  15. 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
  16. QIPUPIUUQTXXXqJDLSDPNQIPUPTEFOO <#PVOEFE DPOUFYU JT> B TNBMM  TUSPOHMZ TFNBOUJDBMMZ DPOTJTUFOUNPEFMʜBQPSUJPOPGUIFNPEFMXIJDIXF

    NVTULFFQBNCJHVJUZGSFF l*OUSPEVDJOH&WFOU4UPSNJOH"OBDUPG%FMJCFSBUF$PMMFDUJWF-FBSOJOHz3FQPSU "VH "MCFSUP#SBOEPMJOJ
  17. %%%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
  18. %%%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
  19. %%%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
  20. %%%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
  21. %%%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
  22. %%%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
  23. %%%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
  24. %%%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
  25. %%%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
  26. %%%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
  27. %%%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