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