| Mapping | Impact | Tested? | Comments |
|---|---|---|---|
| m_LOAD_ksams_kbm_staging_1 | None | ||
| m_LOAD_KBM_KSAMS_ROLES | Moderate | Traverses only to level 10 on KFS_D_ACCOUNT | |
| m_LOAD_KBM_KSAMS_ORG_ROLES | Moderate | Traverses only to level 10 on KFS_D_ORG | |
| m_ods_kbm_override_OverrideStaffingbyAcctorOrg_T | None | ||
| m_ods_kbm_override_UCI_LD_CSFTRCKR_OVRD_T | None | ||
| m_ods_kbm_override_UCI_LD_CSFTRCKR_OVRD_V02_T | None | ||
| m_ods_kbm_override_UCI_LD_CSFTRCKR_OVRD_V02_T_Working | None | ||
| m_ods_kbm_override_UCI_LD_INTENDED_INCUMBENT_T | None | ||
| m_ods_kbm_override_UCI_LD_POSITION_DATA_T | None | ||
| m_ods_kbm_postInfo_Load_Current_FTE | None | ||
| m_ods_kbm_postInfo_Load_Current_FTE_2 | None | ||
| m_ods_kbm_postInfo_Load_Final_Bal_FTE | None | ||
| m_ods_kbm_postInfo_Load_LDGR_ONLY_T | None | ||
| m_ods_kbm_postInfo_Load_LD_Ldgr_Bal _V02_T | None | ||
| m_ods_kbm_postInfo_Load_LD_Ldgr_Bal_V02_T_Working | None | ||
| m_ods_kbm_postInfo_Load_LD_Ldgr_Bal_Working | None | ||
| m_ods_kbm_postInfo_Load_StaffingbyAcctorOrg_T | None | ||
| m_ods_kbm_postInfo_Load_StaffingbyAcctorOrg_T_New | None | ||
| m_ods_kbm_postInfo_Load_UCI_LD_CSF_Tracker_Snapshot_V02_T | None | ||
| m_ods_kbm_postInfo_Load_UCI_LD_CSF_Tracker_Snapshot_V02_T_Working | None | ||
| m_ods_kbm_postInfo_Load_UNIV_FISCAL_PRD_CODES | None | ||
| m_ods_kbm_postInfo_Load_v02 | None | ||
| m_ods_kbm_postInfo_Load_YTD_FTE | None |
...
| m_ods_LD_CSF_TRACKER_SNAPSHOT | None | ||
| m_J_Dim_KBM_D_POSITION_DATA | None | ||
| m_J_Dim_KFS_D_POSITION_FISCAL_PERIOD | None | ||
| Code Block | ||||||
|---|---|---|---|---|---|---|
| ||||||
SELECT DISTINCT a.CHART_CD,
a.ACCOUNT_NBR,
b.ucinetId,
b.roleName
FROM $$DSS_Owner.KFS_D_ACCOUNT a,
$$STAGE_Schema..ksams_kbm_staging_1 b
WHERE a.CHART_CD = b.chartCode
AND ( a.ORG_ROLLUP_LEVEL01_CD = b.orgCode
OR a.ORG_ROLLUP_LEVEL02_CD = b.orgCode
OR a.ORG_ROLLUP_LEVEL03_CD = b.orgCode
OR a.ORG_ROLLUP_LEVEL04_CD = b.orgCode
OR a.ORG_ROLLUP_LEVEL05_CD = b.orgCode
OR a.ORG_ROLLUP_LEVEL06_CD = b.orgCode
OR a.ORG_ROLLUP_LEVEL07_CD = b.orgCode
OR a.ORG_ROLLUP_LEVEL08_CD = b.orgCode
OR a.ORG_ROLLUP_LEVEL09_CD = b.orgCode
OR a.ORG_ROLLUP_LEVEL10_CD = b.orgCode )
AND a.ACCOUNT_CLOSED_FLG <> 'Y'
UNION ALL
SELECT DISTINCT a.CHART_CD,
a.ACCOUNT_NBR,
b.ucinetId,
b.roleName
FROM $$DSS_Owner.KFS_D_ACCOUNT a,
$$STAGE_Schema..ksams_kbm_staging_1 b
WHERE b.chartCode = '*' |
| Code Block | ||||||
|---|---|---|---|---|---|---|
| ||||||
SELECT DISTINCT a.CHART_CD, a.ORG_CD, b.ucinetId, b.roleName FROM $$DSS_Owner.KFS_D_ORG a, $$STAGE_Schema..ksams_kbm_staging_1 b WHERE a.CHART_CD = b.chartCode AND ( a.ORG_ROLLUP_LEVEL01_CD = b.orgCode OR a.ORG_ROLLUP_LEVEL02_CD = b.orgCode OR a.ORG_ROLLUP_LEVEL03_CD = b.orgCode OR a.ORG_ROLLUP_LEVEL04_CD = b.orgCode OR a.ORG_ROLLUP_LEVEL05_CD = b.orgCode OR a.ORG_ROLLUP_LEVEL06_CD = b.orgCode OR a.ORG_ROLLUP_LEVEL07_CD = b.orgCode OR a.ORG_ROLLUP_LEVEL08_CD = b.orgCode OR a.ORG_ROLLUP_LEVEL09_CD = b.orgCode OR a.ORG_ROLLUP_LEVEL10_CD = b.orgCode ) AND a.ORG_ACTIVE_FLG = 'Y' UNION ALL SELECT DISTINCT a.CHART_CD, a.ORG_CD, b.ucinetId, b.roleName FROM $$DSS_Owner.KFS_D_ORG a, $$STAGE_Schema..ksams_kbm_staging_1 b WHERE b.chartCode = '*' |