2018 KFS Org Hierarchy Changes - KBM Analysis

Mapping	Impact	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

SQL Override on m_LOAD_KBM_KSAMS_ROLES

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 = '*'

SQL Override on m_LOAD_KBM_KSAMS_ORG_ROLES

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 = '*'