BEN_DIAG_FF_ATCHMNT_G5

Details

Schema: FUSION
Object owner: BEN
Object type: VIEW

Columns

Name
Object Name Object Type Table Name Column Name Formula Name Formula Id Formula Type Name Formula Type Id Effective Start Date Effective End Date Enterprise ID

Name

Object Name

Object Type

Table Name

Column Name

Formula Name

Formula Id

Formula Type Name

Formula Type Id

Effective Start Date

Effective End Date

Enterprise ID

Query

SQL_Statement
SELECT NAME "Object Name", 'Rate' "Object Type", 'BEN_ACTY_BASE_RT_F' "Table Name", 'LWR_LMT_CALC_RL' "Column Name", FFL.FORMULA_NAME "Formula Name", FFL.FORMULA_ID "Formula Id", FFT.FORMULA_TYPE_NAME "Formula Type Name", FFT.FORMULA_TYPE_ID "Formula Type Id", ART.EFFECTIVE_START_DATE "Effective Start Date", ART.EFFECTIVE_END_DATE "Effective End Date", FFL.ENTERPRISE_ID "Enterprise ID" FROM BEN_ACTY_BASE_RT_F ART, FF_FORMULAS_F FFL, FF_FORMULA_TYPES FFT WHERE ART.LWR_LMT_CALC_RL=FFL.FORMULA_ID AND FFL.FORMULA_TYPE_ID=FFT.FORMULA_TYPE_ID UNION ALL SELECT NAME "Object Name", 'Rate' "Object Type", 'BEN_ACTY_BASE_RT_F' "Table Name", 'UPR_LMT_CALC_RL' "Column Name", FFL.FORMULA_NAME "Formula Name", FFL.FORMULA_ID "Formula Id", FFT.FORMULA_TYPE_NAME "Formula Type Name", FFT.FORMULA_TYPE_ID "Formula Type Id", ART.EFFECTIVE_START_DATE "Effective Start Date", ART.EFFECTIVE_END_DATE "Effective End Date", FFL.ENTERPRISE_ID "Enterprise ID" FROM BEN_ACTY_BASE_RT_F ART, FF_FORMULAS_F FFL, FF_FORMULA_TYPES FFT WHERE ART.UPR_LMT_CALC_RL=FFL.FORMULA_ID AND FFL.FORMULA_TYPE_ID=FFT.FORMULA_TYPE_ID UNION ALL SELECT NAME "Object Name", 'Rate' "Object Type", 'BEN_ACTY_BASE_RT_F' "Table Name", 'VAL_CALC_RL' "Column Name", FFL.FORMULA_NAME "Formula Name", FFL.FORMULA_ID "Formula Id", FFT.FORMULA_TYPE_NAME "Formula Type Name", FFT.FORMULA_TYPE_ID "Formula Type Id", ART.EFFECTIVE_START_DATE "Effective Start Date", ART.EFFECTIVE_END_DATE "Effective End Date", FFL.ENTERPRISE_ID "Enterprise ID" FROM BEN_ACTY_BASE_RT_F ART, FF_FORMULAS_F FFL, FF_FORMULA_TYPES FFT WHERE ART.VAL_CALC_RL=FFL.FORMULA_ID AND FFL.FORMULA_TYPE_ID=FFT.FORMULA_TYPE_ID UNION ALL SELECT NAME "Object Name", 'Coverage' "Object Type", 'BEN_CVG_AMT_CALC_MTHD_F' "Table Name", 'LWR_LMT_CALC_RL' "Column Name", FFL.FORMULA_NAME "Formula Name", FFL.FORMULA_ID "Formula Id", FFT.FORMULA_TYPE_NAME "Formula Type Name", FFT.FORMULA_TYPE_ID "Formula Type Id", CACM.EFFECTIVE_START_DATE "Effective Start Date", CACM.EFFECTIVE_END_DATE "Effective End Date", FFL.ENTERPRISE_ID "Enterprise ID" FROM BEN_CVG_AMT_CALC_MTHD_F CACM, FF_FORMULAS_F FFL, FF_FORMULA_TYPES FFT WHERE CACM.LWR_LMT_CALC_RL=FFL.FORMULA_ID AND FFL.FORMULA_TYPE_ID=FFT.FORMULA_TYPE_ID UNION ALL SELECT NAME "Object Name", 'Coverage' "Object Type", 'BEN_CVG_AMT_CALC_MTHD_F' "Table Name", 'UPR_LMT_CALC_RL' "Column Name", FFL.FORMULA_NAME "Formula Name", FFL.FORMULA_ID "Formula Id", FFT.FORMULA_TYPE_NAME "Formula Type Name", FFT.FORMULA_TYPE_ID "Formula Type Id", CACM.EFFECTIVE_START_DATE "Effective Start Date", CACM.EFFECTIVE_END_DATE "Effective End Date", FFL.ENTERPRISE_ID "Enterprise ID" FROM BEN_CVG_AMT_CALC_MTHD_F CACM, FF_FORMULAS_F FFL, FF_FORMULA_TYPES FFT WHERE CACM.UPR_LMT_CALC_RL=FFL.FORMULA_ID AND FFL.FORMULA_TYPE_ID=FFT.FORMULA_TYPE_ID UNION ALL SELECT NAME "Object Name", 'Coverage' "Object Type", 'BEN_CVG_AMT_CALC_MTHD_F' "Table Name", 'VAL_CALC_RL' "Column Name", FFL.FORMULA_NAME "Formula Name", FFL.FORMULA_ID "Formula Id", FFT.FORMULA_TYPE_NAME "Formula Type Name", FFT.FORMULA_TYPE_ID "Formula Type Id", CACM.EFFECTIVE_START_DATE "Effective Start Date", CACM.EFFECTIVE_END_DATE "Effective End Date", FFL.ENTERPRISE_ID "Enterprise ID" FROM BEN_CVG_AMT_CALC_MTHD_F CACM, FF_FORMULAS_F FFL, FF_FORMULA_TYPES FFT WHERE CACM.VAL_CALC_RL=FFL.FORMULA_ID AND FFL.FORMULA_TYPE_ID=FFT.FORMULA_TYPE_ID UNION ALL SELECT NAME "Object Name", 'Plan' "Object Type", 'BEN_LER_BNFT_RSTRN_F' "Table Name", 'CVG_AMT_LMT_RL' "Column Name", FFL.FORMULA_NAME "Formula Name", FFL.FORMULA_ID "Formula Id", FFT.FORMULA_TYPE_NAME "Formula Type Name", FFT.FORMULA_TYPE_ID "Formula Type Id", LBC.EFFECTIVE_START_DATE "Effective Start Date", LBC.EFFECTIVE_END_DATE "Effective End Date", FFL.ENTERPRISE_ID "Enterprise ID" FROM BEN_PL_F PLN,BEN_LER_BNFT_RSTRN_F LBC,FF_FORMULAS_F FFL, FF_FORMULA_TYPES FFT WHERE PLN.PL_ID=LBC.PL_ID AND LBC.CVG_AMT_LMT_RL=FFL.FORMULA_ID AND FFL.FORMULA_TYPE_ID=FFT.FORMULA_TYPE_ID UNION ALL SELECT NAME "Object Name", 'Plan' "Object Type", 'BEN_LER_BNFT_RSTRN_F' "Table Name", 'CVG_MLT_LMT_RL' "Column Name", FFL.FORMULA_NAME "Formula Name", FFL.FORMULA_ID "Formula Id", FFT.FORMULA_TYPE_NAME "Formula Type Name", FFT.FORMULA_TYPE_ID "Formula Type Id", LBC.EFFECTIVE_START_DATE "Effective Start Date", LBC.EFFECTIVE_END_DATE "Effective End Date" , FFL.ENTERPRISE_ID "Enterprise ID" FROM BEN_PL_F PLN,BEN_LER_BNFT_RSTRN_F LBC,FF_FORMULAS_F FFL, FF_FORMULA_TYPES FFT WHERE PLN.PL_ID=LBC.PL_ID AND LBC.CVG_MLT_LMT_RL=FFL.FORMULA_ID AND FFL.FORMULA_TYPE_ID=FFT.FORMULA_TYPE_ID UNION ALL SELECT SUBSTR(PGM.NAME,1,40)\|\|' :: '\|\|SUBSTR(PLN.NAME,1,40) "Object Name", 'Program :: Plan' "Object Type", 'BEN_PLIP_F' "Table Name", 'MN_CVG_RL' "Column Name", FFL.FORMULA_NAME "Formula Name", FFL.FORMULA_ID "Formula Id", FFT.FORMULA_TYPE_NAME "Formula Type Name", FFT.FORMULA_TYPE_ID "Formula Type Id", PLIP.EFFECTIVE_START_DATE "Effective Start Date", PLIP.EFFECTIVE_END_DATE "Effective End Date" , FFL.ENTERPRISE_ID "Enterprise ID" FROM BEN_PGM_F PGM , BEN_PL_F PLN , BEN_PLIP_F PLIP , FF_FORMULAS_F FFL , FF_FORMULA_TYPES FFT Where PGM.PGM_ID=PLIP.PGM_ID AND PLN.PL_ID=PLIP.PL_ID AND PLIP.MN_CVG_RL=FFL.FORMULA_ID AND FFL.FORMULA_TYPE_ID=FFT.FORMULA_TYPE_ID UNION ALL SELECT SUBSTR(PGM.NAME,1,40)\|\|' :: '\|\|SUBSTR(PLN.NAME,1,40) "Object Name", 'Program :: Plan' "Object Type", 'BEN_PLIP_F' "Table Name", 'MX_CVG_RL' "Column Name", FFL.FORMULA_NAME "Formula Name", FFL.FORMULA_ID "Formula Id", FFT.FORMULA_TYPE_NAME "Formula Type Name", FFT.FORMULA_TYPE_ID "Formula Type Id", PLIP.EFFECTIVE_START_DATE "Effective Start Date", PLIP.EFFECTIVE_END_DATE "Effective End Date" , FFL.ENTERPRISE_ID "Enterprise ID" FROM BEN_PGM_F PGM , BEN_PL_F PLN , BEN_PLIP_F PLIP , FF_FORMULAS_F FFL , FF_FORMULA_TYPES FFT Where PGM.PGM_ID=PLIP.PGM_ID AND PLN.PL_ID=PLIP.PL_ID AND PLIP.MX_CVG_RL=FFL.FORMULA_ID AND FFL.FORMULA_TYPE_ID=FFT.FORMULA_TYPE_ID UNION ALL SELECT PLN.NAME "Object Name", 'Plan' "Object Type", 'BEN_PL_F' "Table Name", 'CVG_AMT_LMT_RL' "Column Name", FFL.FORMULA_NAME "Formula Name", FFL.FORMULA_ID "Formula Id", FFT.FORMULA_TYPE_NAME "Formula Type Name", FFT.FORMULA_TYPE_ID "Formula Type Id", PLN.EFFECTIVE_START_DATE "Effective Start Date", PLN.EFFECTIVE_END_DATE "Effective End Date" , FFL.ENTERPRISE_ID "Enterprise ID" FROM BEN_PL_F PLN , FF_FORMULAS_F FFL , FF_FORMULA_TYPES FFT WHERE PLN.CVG_AMT_LMT_RL=FFL.FORMULA_ID AND FFL.FORMULA_TYPE_ID=FFT.FORMULA_TYPE_ID UNION ALL SELECT PLN.NAME "Object Name", 'Plan' "Object Type", 'BEN_PL_F' "Table Name", 'CVG_MLT_LMT_RL' "Column Name", FFL.FORMULA_NAME "Formula Name", FFL.FORMULA_ID "Formula Id", FFT.FORMULA_TYPE_NAME "Formula Type Name", FFT.FORMULA_TYPE_ID "Formula Type Id", PLN.EFFECTIVE_START_DATE "Effective Start Date", PLN.EFFECTIVE_END_DATE "Effective End Date" , FFL.ENTERPRISE_ID "Enterprise ID" FROM BEN_PL_F PLN , FF_FORMULAS_F FFL , FF_FORMULA_TYPES FFT WHERE PLN.CVG_MLT_LMT_RL=FFL.FORMULA_ID AND FFL.FORMULA_TYPE_ID=FFT.FORMULA_TYPE_ID UNION ALL SELECT NAME "Object Name", 'Variable Profile' "Object Type", 'BEN_VRBL_MTCHG_RT_F' "Table Name", 'MTCHG_RT_CALC_RL' "Column Name", FFL.FORMULA_NAME "Formula Name", FFL.FORMULA_ID "Formula Id", FFT.FORMULA_TYPE_NAME "Formula Type Name", FFT.FORMULA_TYPE_ID "Formula Type Id", VRMR.EFFECTIVE_START_DATE "Effective Start Date", VRMR.EFFECTIVE_END_DATE "Effective End Date" , FFL.ENTERPRISE_ID "Enterprise ID" FROM BEN_VRBL_RT_PRFL_F VRP , BEN_VRBL_MTCHG_RT_F VRMR , FF_FORMULAS_F FFL , FF_FORMULA_TYPES FFT Where VRP.VRBL_RT_PRFL_ID=VRMR.VRBL_RT_PRFL_ID AND VRMR.MTCHG_RT_CALC_RL=FFL.FORMULA_ID AND FFL.FORMULA_TYPE_ID=FFT.FORMULA_TYPE_ID UNION ALL SELECT NAME "Object Name", 'Variable Profile' "Object Type", 'BEN_VRBL_RT_PRFL_F' "Table Name", 'LWR_LMT_CALC_RL' "Column Name", FFL.FORMULA_NAME "Formula Name", FFL.FORMULA_ID "Formula Id", FFT.FORMULA_TYPE_NAME "Formula Type Name", FFT.FORMULA_TYPE_ID "Formula Type Id", VRP.EFFECTIVE_START_DATE "Effective Start Date", VRP.EFFECTIVE_END_DATE "Effective End Date" , FFL.ENTERPRISE_ID "Enterprise ID" FROM BEN_VRBL_RT_PRFL_F VRP , FF_FORMULAS_F FFL , FF_FORMULA_TYPES FFT WHERE VRP.LWR_LMT_CALC_RL=FFL.FORMULA_ID AND FFL.FORMULA_TYPE_ID=FFT.FORMULA_TYPE_ID UNION ALL SELECT NAME "Object Name", 'Variable Profile' "Object Type", 'BEN_VRBL_RT_PRFL_F' "Table Name", 'ULTMT_LWR_LMT_CALC_RL' "Column Name", FFL.FORMULA_NAME "Formula Name", FFL.FORMULA_ID "Formula Id", FFT.FORMULA_TYPE_NAME "Formula Type Name", FFT.FORMULA_TYPE_ID "Formula Type Id", VRP.EFFECTIVE_START_DATE "Effective Start Date", VRP.EFFECTIVE_END_DATE "Effective End Date" , FFL.ENTERPRISE_ID "Enterprise ID" FROM BEN_VRBL_RT_PRFL_F VRP , FF_FORMULAS_F FFL , FF_FORMULA_TYPES FFT WHERE VRP.ULTMT_LWR_LMT_CALC_RL=FFL.FORMULA_ID AND FFL.FORMULA_TYPE_ID=FFT.FORMULA_TYPE_ID UNION ALL SELECT NAME "Object Name", 'Variable Profile' "Object Type", 'BEN_VRBL_RT_PRFL_F' "Table Name", 'ULTMT_UPR_LMT_CALC_RL' "Column Name", FFL.FORMULA_NAME "Formula Name", FFL.FORMULA_ID "Formula Id", FFT.FORMULA_TYPE_NAME "Formula Type Name", FFT.FORMULA_TYPE_ID "Formula Type Id", VRP.EFFECTIVE_START_DATE "Effective Start Date", VRP.EFFECTIVE_END_DATE "Effective End Date" , FFL.ENTERPRISE_ID "Enterprise ID" FROM BEN_VRBL_RT_PRFL_F VRP , FF_FORMULAS_F FFL , FF_FORMULA_TYPES FFT WHERE VRP.ULTMT_UPR_LMT_CALC_RL=FFL.FORMULA_ID AND FFL.FORMULA_TYPE_ID=FFT.FORMULA_TYPE_ID UNION ALL SELECT NAME "Object Name", 'Variable Profile' "Object Type", 'BEN_VRBL_RT_PRFL_F' "Table Name", 'UPR_LMT_CALC_RL' "Column Name", FFL.FORMULA_NAME "Formula Name", FFL.FORMULA_ID "Formula Id", FFT.FORMULA_TYPE_NAME "Formula Type Name", FFT.FORMULA_TYPE_ID "Formula Type Id", VRP.EFFECTIVE_START_DATE "Effective Start Date", VRP.EFFECTIVE_END_DATE "Effective End Date" , FFL.ENTERPRISE_ID "Enterprise ID" FROM BEN_VRBL_RT_PRFL_F VRP , FF_FORMULAS_F FFL , FF_FORMULA_TYPES FFT WHERE VRP.UPR_LMT_CALC_RL=FFL.FORMULA_ID AND FFL.FORMULA_TYPE_ID=FFT.FORMULA_TYPE_ID UNION ALL SELECT NAME "Object Name", 'Variable Profile' "Object Type", 'BEN_VRBL_RT_PRFL_F' "Table Name", 'VAL_CALC_RL' "Column Name", FFL.FORMULA_NAME "Formula Name", FFL.FORMULA_ID "Formula Id", FFT.FORMULA_TYPE_NAME "Formula Type Name", FFT.FORMULA_TYPE_ID "Formula Type Id", VRP.EFFECTIVE_START_DATE "Effective Start Date", VRP.EFFECTIVE_END_DATE "Effective End Date" , FFL.ENTERPRISE_ID "Enterprise ID" FROM BEN_VRBL_RT_PRFL_F VRP , FF_FORMULAS_F FFL , FF_FORMULA_TYPES FFT WHERE VRP.VAL_CALC_RL=FFL.FORMULA_ID AND FFL.FORMULA_TYPE_ID=FFT.FORMULA_TYPE_ID

SQL_Statement

SELECT NAME "Object Name",

'Rate' "Object Type",

'BEN_ACTY_BASE_RT_F' "Table Name",

'LWR_LMT_CALC_RL' "Column Name",

FFL.FORMULA_NAME "Formula Name",

FFL.FORMULA_ID "Formula Id",

FFT.FORMULA_TYPE_NAME "Formula Type Name",

FFT.FORMULA_TYPE_ID "Formula Type Id",

ART.EFFECTIVE_START_DATE "Effective Start Date",

ART.EFFECTIVE_END_DATE "Effective End Date",

FFL.ENTERPRISE_ID "Enterprise ID"

FROM BEN_ACTY_BASE_RT_F ART, FF_FORMULAS_F FFL, FF_FORMULA_TYPES FFT

WHERE ART.LWR_LMT_CALC_RL=FFL.FORMULA_ID

AND FFL.FORMULA_TYPE_ID=FFT.FORMULA_TYPE_ID

UNION ALL

SELECT NAME "Object Name",

'Rate' "Object Type",

'BEN_ACTY_BASE_RT_F' "Table Name",

'UPR_LMT_CALC_RL' "Column Name",

FFL.FORMULA_NAME "Formula Name",

FFL.FORMULA_ID "Formula Id",

FFT.FORMULA_TYPE_NAME "Formula Type Name",

FFT.FORMULA_TYPE_ID "Formula Type Id",

ART.EFFECTIVE_START_DATE "Effective Start Date",

ART.EFFECTIVE_END_DATE "Effective End Date",

FFL.ENTERPRISE_ID "Enterprise ID"

FROM BEN_ACTY_BASE_RT_F ART, FF_FORMULAS_F FFL, FF_FORMULA_TYPES FFT

WHERE ART.UPR_LMT_CALC_RL=FFL.FORMULA_ID

AND FFL.FORMULA_TYPE_ID=FFT.FORMULA_TYPE_ID

UNION ALL

SELECT NAME "Object Name",

'Rate' "Object Type",

'BEN_ACTY_BASE_RT_F' "Table Name",

'VAL_CALC_RL' "Column Name",

FFL.FORMULA_NAME "Formula Name",

FFL.FORMULA_ID "Formula Id",

FFT.FORMULA_TYPE_NAME "Formula Type Name",

FFT.FORMULA_TYPE_ID "Formula Type Id",

ART.EFFECTIVE_START_DATE "Effective Start Date",

ART.EFFECTIVE_END_DATE "Effective End Date",

FFL.ENTERPRISE_ID "Enterprise ID"

FROM BEN_ACTY_BASE_RT_F ART, FF_FORMULAS_F FFL, FF_FORMULA_TYPES FFT

WHERE ART.VAL_CALC_RL=FFL.FORMULA_ID

AND FFL.FORMULA_TYPE_ID=FFT.FORMULA_TYPE_ID

UNION ALL

SELECT NAME "Object Name",

'Coverage' "Object Type",

'BEN_CVG_AMT_CALC_MTHD_F' "Table Name",

'LWR_LMT_CALC_RL' "Column Name",

FFL.FORMULA_NAME "Formula Name",

FFL.FORMULA_ID "Formula Id",

FFT.FORMULA_TYPE_NAME "Formula Type Name",

FFT.FORMULA_TYPE_ID "Formula Type Id",

CACM.EFFECTIVE_START_DATE "Effective Start Date",

CACM.EFFECTIVE_END_DATE "Effective End Date",

FFL.ENTERPRISE_ID "Enterprise ID"

FROM BEN_CVG_AMT_CALC_MTHD_F CACM, FF_FORMULAS_F FFL, FF_FORMULA_TYPES FFT

WHERE CACM.LWR_LMT_CALC_RL=FFL.FORMULA_ID

AND FFL.FORMULA_TYPE_ID=FFT.FORMULA_TYPE_ID

UNION ALL

SELECT NAME "Object Name",

'Coverage' "Object Type",

'BEN_CVG_AMT_CALC_MTHD_F' "Table Name",

'UPR_LMT_CALC_RL' "Column Name",

FFL.FORMULA_NAME "Formula Name",

FFL.FORMULA_ID "Formula Id",

FFT.FORMULA_TYPE_NAME "Formula Type Name",

FFT.FORMULA_TYPE_ID "Formula Type Id",

CACM.EFFECTIVE_START_DATE "Effective Start Date",

CACM.EFFECTIVE_END_DATE "Effective End Date",

FFL.ENTERPRISE_ID "Enterprise ID"

FROM BEN_CVG_AMT_CALC_MTHD_F CACM, FF_FORMULAS_F FFL, FF_FORMULA_TYPES FFT

WHERE CACM.UPR_LMT_CALC_RL=FFL.FORMULA_ID

AND FFL.FORMULA_TYPE_ID=FFT.FORMULA_TYPE_ID

UNION ALL

SELECT NAME "Object Name",

'Coverage' "Object Type",

'BEN_CVG_AMT_CALC_MTHD_F' "Table Name",

'VAL_CALC_RL' "Column Name",

FFL.FORMULA_NAME "Formula Name",

FFL.FORMULA_ID "Formula Id",

FFT.FORMULA_TYPE_NAME "Formula Type Name",

FFT.FORMULA_TYPE_ID "Formula Type Id",

CACM.EFFECTIVE_START_DATE "Effective Start Date",

CACM.EFFECTIVE_END_DATE "Effective End Date",

FFL.ENTERPRISE_ID "Enterprise ID"

FROM BEN_CVG_AMT_CALC_MTHD_F CACM, FF_FORMULAS_F FFL, FF_FORMULA_TYPES FFT

WHERE CACM.VAL_CALC_RL=FFL.FORMULA_ID

AND FFL.FORMULA_TYPE_ID=FFT.FORMULA_TYPE_ID

UNION ALL

SELECT NAME "Object Name",

'Plan' "Object Type",

'BEN_LER_BNFT_RSTRN_F' "Table Name",

'CVG_AMT_LMT_RL' "Column Name",

FFL.FORMULA_NAME "Formula Name",

FFL.FORMULA_ID "Formula Id",

FFT.FORMULA_TYPE_NAME "Formula Type Name",

FFT.FORMULA_TYPE_ID "Formula Type Id",

LBC.EFFECTIVE_START_DATE "Effective Start Date",

LBC.EFFECTIVE_END_DATE "Effective End Date",

FFL.ENTERPRISE_ID "Enterprise ID"

FROM BEN_PL_F PLN,BEN_LER_BNFT_RSTRN_F LBC,FF_FORMULAS_F FFL, FF_FORMULA_TYPES FFT

WHERE PLN.PL_ID=LBC.PL_ID

AND LBC.CVG_AMT_LMT_RL=FFL.FORMULA_ID

AND FFL.FORMULA_TYPE_ID=FFT.FORMULA_TYPE_ID

UNION ALL

SELECT NAME "Object Name",

'Plan' "Object Type",

'BEN_LER_BNFT_RSTRN_F' "Table Name",

'CVG_MLT_LMT_RL' "Column Name",

FFL.FORMULA_NAME "Formula Name",

FFL.FORMULA_ID "Formula Id",

FFT.FORMULA_TYPE_NAME "Formula Type Name",

FFT.FORMULA_TYPE_ID "Formula Type Id",

LBC.EFFECTIVE_START_DATE "Effective Start Date",

LBC.EFFECTIVE_END_DATE "Effective End Date" ,

FFL.ENTERPRISE_ID "Enterprise ID"

FROM BEN_PL_F PLN,BEN_LER_BNFT_RSTRN_F LBC,FF_FORMULAS_F FFL, FF_FORMULA_TYPES FFT

WHERE PLN.PL_ID=LBC.PL_ID

AND LBC.CVG_MLT_LMT_RL=FFL.FORMULA_ID

AND FFL.FORMULA_TYPE_ID=FFT.FORMULA_TYPE_ID

UNION ALL

SELECT SUBSTR(PGM.NAME,1,40)||' :: '||SUBSTR(PLN.NAME,1,40) "Object Name",

'Program :: Plan' "Object Type",

'BEN_PLIP_F' "Table Name",

'MN_CVG_RL' "Column Name",

FFL.FORMULA_NAME "Formula Name",

FFL.FORMULA_ID "Formula Id",

FFT.FORMULA_TYPE_NAME "Formula Type Name",

FFT.FORMULA_TYPE_ID "Formula Type Id",

PLIP.EFFECTIVE_START_DATE "Effective Start Date",

PLIP.EFFECTIVE_END_DATE "Effective End Date" ,

FFL.ENTERPRISE_ID "Enterprise ID"

FROM BEN_PGM_F PGM , BEN_PL_F PLN , BEN_PLIP_F PLIP , FF_FORMULAS_F FFL , FF_FORMULA_TYPES FFT

Where PGM.PGM_ID=PLIP.PGM_ID

AND PLN.PL_ID=PLIP.PL_ID

AND PLIP.MN_CVG_RL=FFL.FORMULA_ID

AND FFL.FORMULA_TYPE_ID=FFT.FORMULA_TYPE_ID

UNION ALL

SELECT SUBSTR(PGM.NAME,1,40)||' :: '||SUBSTR(PLN.NAME,1,40) "Object Name",

'Program :: Plan' "Object Type",

'BEN_PLIP_F' "Table Name",

'MX_CVG_RL' "Column Name",

FFL.FORMULA_NAME "Formula Name",

FFL.FORMULA_ID "Formula Id",

FFT.FORMULA_TYPE_NAME "Formula Type Name",

FFT.FORMULA_TYPE_ID "Formula Type Id",

PLIP.EFFECTIVE_START_DATE "Effective Start Date",

PLIP.EFFECTIVE_END_DATE "Effective End Date" ,

FFL.ENTERPRISE_ID "Enterprise ID"

FROM BEN_PGM_F PGM , BEN_PL_F PLN , BEN_PLIP_F PLIP , FF_FORMULAS_F FFL , FF_FORMULA_TYPES FFT

Where PGM.PGM_ID=PLIP.PGM_ID

AND PLN.PL_ID=PLIP.PL_ID

AND PLIP.MX_CVG_RL=FFL.FORMULA_ID

AND FFL.FORMULA_TYPE_ID=FFT.FORMULA_TYPE_ID

UNION ALL

SELECT PLN.NAME "Object Name",

'Plan' "Object Type",

'BEN_PL_F' "Table Name",

'CVG_AMT_LMT_RL' "Column Name",

FFL.FORMULA_NAME "Formula Name",

FFL.FORMULA_ID "Formula Id",

FFT.FORMULA_TYPE_NAME "Formula Type Name",

FFT.FORMULA_TYPE_ID "Formula Type Id",

PLN.EFFECTIVE_START_DATE "Effective Start Date",

PLN.EFFECTIVE_END_DATE "Effective End Date" ,

FFL.ENTERPRISE_ID "Enterprise ID"

FROM BEN_PL_F PLN , FF_FORMULAS_F FFL , FF_FORMULA_TYPES FFT

WHERE PLN.CVG_AMT_LMT_RL=FFL.FORMULA_ID

AND FFL.FORMULA_TYPE_ID=FFT.FORMULA_TYPE_ID

UNION ALL

SELECT PLN.NAME "Object Name",

'Plan' "Object Type",

'BEN_PL_F' "Table Name",

'CVG_MLT_LMT_RL' "Column Name",

FFL.FORMULA_NAME "Formula Name",

FFL.FORMULA_ID "Formula Id",

FFT.FORMULA_TYPE_NAME "Formula Type Name",

FFT.FORMULA_TYPE_ID "Formula Type Id",

PLN.EFFECTIVE_START_DATE "Effective Start Date",

PLN.EFFECTIVE_END_DATE "Effective End Date" ,

FFL.ENTERPRISE_ID "Enterprise ID"

FROM BEN_PL_F PLN , FF_FORMULAS_F FFL , FF_FORMULA_TYPES FFT

WHERE PLN.CVG_MLT_LMT_RL=FFL.FORMULA_ID

AND FFL.FORMULA_TYPE_ID=FFT.FORMULA_TYPE_ID

UNION ALL

SELECT NAME "Object Name",

'Variable Profile' "Object Type",

'BEN_VRBL_MTCHG_RT_F' "Table Name",

'MTCHG_RT_CALC_RL' "Column Name",

FFL.FORMULA_NAME "Formula Name",

FFL.FORMULA_ID "Formula Id",

FFT.FORMULA_TYPE_NAME "Formula Type Name",

FFT.FORMULA_TYPE_ID "Formula Type Id",

VRMR.EFFECTIVE_START_DATE "Effective Start Date",

VRMR.EFFECTIVE_END_DATE "Effective End Date" ,

FFL.ENTERPRISE_ID "Enterprise ID"

FROM BEN_VRBL_RT_PRFL_F VRP , BEN_VRBL_MTCHG_RT_F VRMR , FF_FORMULAS_F FFL , FF_FORMULA_TYPES FFT

Where VRP.VRBL_RT_PRFL_ID=VRMR.VRBL_RT_PRFL_ID

AND VRMR.MTCHG_RT_CALC_RL=FFL.FORMULA_ID

AND FFL.FORMULA_TYPE_ID=FFT.FORMULA_TYPE_ID

UNION ALL

SELECT NAME "Object Name",

'Variable Profile' "Object Type",

'BEN_VRBL_RT_PRFL_F' "Table Name",

'LWR_LMT_CALC_RL' "Column Name",

FFL.FORMULA_NAME "Formula Name",

FFL.FORMULA_ID "Formula Id",

FFT.FORMULA_TYPE_NAME "Formula Type Name",

FFT.FORMULA_TYPE_ID "Formula Type Id",

VRP.EFFECTIVE_START_DATE "Effective Start Date",

VRP.EFFECTIVE_END_DATE "Effective End Date" ,

FFL.ENTERPRISE_ID "Enterprise ID"

FROM BEN_VRBL_RT_PRFL_F VRP , FF_FORMULAS_F FFL , FF_FORMULA_TYPES FFT

WHERE VRP.LWR_LMT_CALC_RL=FFL.FORMULA_ID

AND FFL.FORMULA_TYPE_ID=FFT.FORMULA_TYPE_ID

UNION ALL

SELECT NAME "Object Name",

'Variable Profile' "Object Type",

'BEN_VRBL_RT_PRFL_F' "Table Name",

'ULTMT_LWR_LMT_CALC_RL' "Column Name",

FFL.FORMULA_NAME "Formula Name",

FFL.FORMULA_ID "Formula Id",

FFT.FORMULA_TYPE_NAME "Formula Type Name",

FFT.FORMULA_TYPE_ID "Formula Type Id",

VRP.EFFECTIVE_START_DATE "Effective Start Date",

VRP.EFFECTIVE_END_DATE "Effective End Date" ,

FFL.ENTERPRISE_ID "Enterprise ID"

FROM BEN_VRBL_RT_PRFL_F VRP , FF_FORMULAS_F FFL , FF_FORMULA_TYPES FFT

WHERE VRP.ULTMT_LWR_LMT_CALC_RL=FFL.FORMULA_ID

AND FFL.FORMULA_TYPE_ID=FFT.FORMULA_TYPE_ID

UNION ALL

SELECT NAME "Object Name",

'Variable Profile' "Object Type",

'BEN_VRBL_RT_PRFL_F' "Table Name",

'ULTMT_UPR_LMT_CALC_RL' "Column Name",

FFL.FORMULA_NAME "Formula Name",

FFL.FORMULA_ID "Formula Id",

FFT.FORMULA_TYPE_NAME "Formula Type Name",

FFT.FORMULA_TYPE_ID "Formula Type Id",

VRP.EFFECTIVE_START_DATE "Effective Start Date",

VRP.EFFECTIVE_END_DATE "Effective End Date" ,

FFL.ENTERPRISE_ID "Enterprise ID"

FROM BEN_VRBL_RT_PRFL_F VRP , FF_FORMULAS_F FFL , FF_FORMULA_TYPES FFT

WHERE VRP.ULTMT_UPR_LMT_CALC_RL=FFL.FORMULA_ID

AND FFL.FORMULA_TYPE_ID=FFT.FORMULA_TYPE_ID

UNION ALL

SELECT NAME "Object Name",

'Variable Profile' "Object Type",

'BEN_VRBL_RT_PRFL_F' "Table Name",

'UPR_LMT_CALC_RL' "Column Name",

FFL.FORMULA_NAME "Formula Name",

FFL.FORMULA_ID "Formula Id",

FFT.FORMULA_TYPE_NAME "Formula Type Name",

FFT.FORMULA_TYPE_ID "Formula Type Id",

VRP.EFFECTIVE_START_DATE "Effective Start Date",

VRP.EFFECTIVE_END_DATE "Effective End Date" ,

FFL.ENTERPRISE_ID "Enterprise ID"

FROM BEN_VRBL_RT_PRFL_F VRP , FF_FORMULAS_F FFL , FF_FORMULA_TYPES FFT

WHERE VRP.UPR_LMT_CALC_RL=FFL.FORMULA_ID

AND FFL.FORMULA_TYPE_ID=FFT.FORMULA_TYPE_ID

UNION ALL

SELECT NAME "Object Name",

'Variable Profile' "Object Type",

'BEN_VRBL_RT_PRFL_F' "Table Name",

'VAL_CALC_RL' "Column Name",

FFL.FORMULA_NAME "Formula Name",

FFL.FORMULA_ID "Formula Id",

FFT.FORMULA_TYPE_NAME "Formula Type Name",

FFT.FORMULA_TYPE_ID "Formula Type Id",

VRP.EFFECTIVE_START_DATE "Effective Start Date",

VRP.EFFECTIVE_END_DATE "Effective End Date" ,

FFL.ENTERPRISE_ID "Enterprise ID"

FROM BEN_VRBL_RT_PRFL_F VRP , FF_FORMULAS_F FFL , FF_FORMULA_TYPES FFT

WHERE VRP.VAL_CALC_RL=FFL.FORMULA_ID

AND FFL.FORMULA_TYPE_ID=FFT.FORMULA_TYPE_ID