Skip to end of metadata
Go to start of metadata

You are viewing an old version of this page. View the current version.

Compare with Current View Page History

Version 1 Current »

MappingImpactTested?Comments
m_LOAD_ksams_kbm_staging_1None  
m_LOAD_KBM_KSAMS_ROLESModerate Traverses only to level 10
m_LOAD_KBM_KSAMS_ORG_ROLES   

 

 

SQL Override on m_LOAD_KBM_KSAMS_ROLES:

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 = '*'
  • No labels