BEN_DIAG_FF_ATCHMNT_G3_V

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

Query

SQL_Statement

SELECT NAME "Object Name", 'Plan' "Object Type", 'BEN_ELIG_TO_PRTE_RSN_F' "Table Name", 'PRTN_EFF_END_DT_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", EPR.EFFECTIVE_START_DATE "Effective Start Date", EPR.EFFECTIVE_END_DATE "Effective End Date" , FFL.ENTERPRISE_ID "Enterprise ID" FROM BEN_PL_F PLN,BEN_ELIG_TO_PRTE_RSN_F EPR, FF_FORMULAS_F FFL, FF_FORMULA_TYPES FFT WHERE PLN.PL_ID=EPR.PL_ID AND EPR.PRTN_EFF_END_DT_RL=FFL.FORMULA_ID AND FFL.FORMULA_TYPE_ID=FFT.FORMULA_TYPE_ID UNION ALL SELECT PLTY.NAME "Object Name", 'PlanType' "Object Type", 'BEN_ELIG_TO_PRTE_RSN_F' "Table Name", 'PRTN_EFF_END_DT_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", EPR.EFFECTIVE_START_DATE "Effective Start Date", EPR.EFFECTIVE_END_DATE "Effective End Date" , FFL.ENTERPRISE_ID "Enterprise ID" FROM BEN_PL_TYP_F PLTY,BEN_PTIP_F PTIP,BEN_ELIG_TO_PRTE_RSN_F EPR, FF_FORMULAS_F FFL, FF_FORMULA_TYPES FFT WHERE PLTY.PL_TYP_ID=PTIP.PL_TYP_ID AND PTIP.PL_TYP_ID=EPR.PTIP_ID AND EPR.PRTN_EFF_END_DT_RL=FFL.FORMULA_ID AND FFL.FORMULA_TYPE_ID=FFT.FORMULA_TYPE_ID UNION ALL SELECT NAME "Object Name", 'Program' "Object Type", 'BEN_ELIG_TO_PRTE_RSN_F' "Table Name", 'PRTN_EFF_END_DT_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", EPR.EFFECTIVE_START_DATE "Effective Start Date", EPR.EFFECTIVE_END_DATE "Effective End Date" , FFL.ENTERPRISE_ID "Enterprise ID" FROM BEN_PGM_F PGM,BEN_ELIG_TO_PRTE_RSN_F EPR, FF_FORMULAS_F FFL, FF_FORMULA_TYPES FFT WHERE PGM.PGM_ID=EPR.PGM_ID AND EPR.PRTN_EFF_END_DT_RL=FFL.FORMULA_ID AND FFL.FORMULA_TYPE_ID=FFT.FORMULA_TYPE_ID UNION ALL SELECT NAME "Object Name", 'Plan' "Object Type", 'BEN_ELIG_TO_PRTE_RSN_F' "Table Name", 'PRTN_EFF_STRT_DT_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", EPR.EFFECTIVE_START_DATE "Effective Start Date", EPR.EFFECTIVE_END_DATE "Effective End Date" , FFL.ENTERPRISE_ID "Enterprise ID" FROM BEN_PL_F PLN,BEN_ELIG_TO_PRTE_RSN_F EPR, FF_FORMULAS_F FFL, FF_FORMULA_TYPES FFT WHERE PLN.PL_ID=EPR.PL_ID AND EPR.PRTN_EFF_STRT_DT_RL=FFL.FORMULA_ID AND FFL.FORMULA_TYPE_ID=FFT.FORMULA_TYPE_ID UNION ALL SELECT PLTY.NAME "Object Name", 'PlanType' "Object Type", 'BEN_ELIG_TO_PRTE_RSN_F' "Table Name", 'PRTN_EFF_STRT_DT_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", EPR.EFFECTIVE_START_DATE "Effective Start Date", EPR.EFFECTIVE_END_DATE "Effective End Date" , FFL.ENTERPRISE_ID "Enterprise ID" FROM BEN_PL_TYP_F PLTY,BEN_PTIP_F PTIP,BEN_ELIG_TO_PRTE_RSN_F EPR, FF_FORMULAS_F FFL, FF_FORMULA_TYPES FFT WHERE PLTY.PL_TYP_ID=PTIP.PL_TYP_ID AND PTIP.PL_TYP_ID=EPR.PTIP_ID AND EPR.PRTN_EFF_STRT_DT_RL=FFL.FORMULA_ID AND FFL.FORMULA_TYPE_ID=FFT.FORMULA_TYPE_ID UNION ALL SELECT NAME "Object Name", 'Program' "Object Type", 'BEN_ELIG_TO_PRTE_RSN_F' "Table Name", 'PRTN_EFF_STRT_DT_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", EPR.EFFECTIVE_START_DATE "Effective Start Date", EPR.EFFECTIVE_END_DATE "Effective End Date" , FFL.ENTERPRISE_ID "Enterprise ID" FROM BEN_PGM_F PGM,BEN_ELIG_TO_PRTE_RSN_F EPR, FF_FORMULAS_F FFL, FF_FORMULA_TYPES FFT WHERE PGM.PGM_ID=EPR.PGM_ID AND EPR.PRTN_EFF_STRT_DT_RL=FFL.FORMULA_ID AND FFL.FORMULA_TYPE_ID=FFT.FORMULA_TYPE_ID UNION ALL SELECT NAME "Object Name", 'Plan' "Object Type", 'BEN_ELIG_TO_PRTE_RSN_F' "Table Name", 'WAIT_PERD_DT_TO_USE_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", EPR.EFFECTIVE_START_DATE "Effective Start Date", EPR.EFFECTIVE_END_DATE "Effective End Date" , FFL.ENTERPRISE_ID "Enterprise ID" FROM BEN_PL_F PLN,BEN_ELIG_TO_PRTE_RSN_F EPR, FF_FORMULAS_F FFL, FF_FORMULA_TYPES FFT WHERE PLN.PL_ID=EPR.PL_ID AND EPR.WAIT_PERD_DT_TO_USE_RL =FFL.FORMULA_ID AND FFL.FORMULA_TYPE_ID=FFT.FORMULA_TYPE_ID UNION ALL SELECT PLTY.NAME "Object Name", 'PlanType' "Object Type", 'BEN_ELIG_TO_PRTE_RSN_F' "Table Name", 'WAIT_PERD_DT_TO_USE_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", EPR.EFFECTIVE_START_DATE "Effective Start Date", EPR.EFFECTIVE_END_DATE "Effective End Date" , FFL.ENTERPRISE_ID "Enterprise ID" FROM BEN_PL_TYP_F PLTY,BEN_PTIP_F PTIP,BEN_ELIG_TO_PRTE_RSN_F EPR, FF_FORMULAS_F FFL, FF_FORMULA_TYPES FFT WHERE PLTY.PL_TYP_ID=PTIP.PL_TYP_ID AND PTIP.PL_TYP_ID=EPR.PTIP_ID AND EPR.WAIT_PERD_DT_TO_USE_RL=FFL.FORMULA_ID AND FFL.FORMULA_TYPE_ID=FFT.FORMULA_TYPE_ID UNION ALL SELECT NAME "Object Name", 'Program' "Object Type", 'BEN_ELIG_TO_PRTE_RSN_F' "Table Name", 'WAIT_PERD_DT_TO_USE_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", EPR.EFFECTIVE_START_DATE "Effective Start Date", EPR.EFFECTIVE_END_DATE "Effective End Date" , FFL.ENTERPRISE_ID "Enterprise ID" FROM BEN_PGM_F PGM,BEN_ELIG_TO_PRTE_RSN_F EPR, FF_FORMULAS_F FFL, FF_FORMULA_TYPES FFT WHERE PGM.PGM_ID=EPR.PGM_ID AND EPR.WAIT_PERD_DT_TO_USE_RL=FFL.FORMULA_ID AND FFL.FORMULA_TYPE_ID=FFT.FORMULA_TYPE_ID UNION ALL SELECT NAME "Object Name", 'Plan' "Object Type", 'BEN_ELIG_TO_PRTE_RSN_F' "Table Name", 'WAIT_PERD_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", EPR.EFFECTIVE_START_DATE "Effective Start Date", EPR.EFFECTIVE_END_DATE "Effective End Date" , FFL.ENTERPRISE_ID "Enterprise ID" FROM BEN_PL_F PLN,BEN_ELIG_TO_PRTE_RSN_F EPR, FF_FORMULAS_F FFL, FF_FORMULA_TYPES FFT WHERE PLN.PL_ID=EPR.PL_ID AND EPR.WAIT_PERD_RL =FFL.FORMULA_ID AND FFL.FORMULA_TYPE_ID=FFT.FORMULA_TYPE_ID UNION ALL SELECT PLTY.NAME "Object Name", 'PlanType' "Object Type", 'BEN_ELIG_TO_PRTE_RSN_F' "Table Name", 'WAIT_PERD_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", EPR.EFFECTIVE_START_DATE "Effective Start Date", EPR.EFFECTIVE_END_DATE "Effective End Date" , FFL.ENTERPRISE_ID "Enterprise ID" FROM BEN_PL_TYP_F PLTY,BEN_PTIP_F PTIP,BEN_ELIG_TO_PRTE_RSN_F EPR, FF_FORMULAS_F FFL, FF_FORMULA_TYPES FFT WHERE PLTY.PL_TYP_ID=PTIP.PL_TYP_ID AND PTIP.PL_TYP_ID=EPR.PTIP_ID AND EPR.WAIT_PERD_RL=FFL.FORMULA_ID AND FFL.FORMULA_TYPE_ID=FFT.FORMULA_TYPE_ID UNION ALL SELECT NAME "Object Name", 'Program' "Object Type", 'BEN_ELIG_TO_PRTE_RSN_F' "Table Name", 'WAIT_PERD_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", EPR.EFFECTIVE_START_DATE "Effective Start Date", EPR.EFFECTIVE_END_DATE "Effective End Date" , FFL.ENTERPRISE_ID "Enterprise ID" FROM BEN_PGM_F PGM,BEN_ELIG_TO_PRTE_RSN_F EPR, FF_FORMULAS_F FFL, FF_FORMULA_TYPES FFT WHERE PGM.PGM_ID=EPR.PGM_ID AND EPR.WAIT_PERD_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", 'MX_WTG_DT_TO_USE_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.MX_WTG_DT_TO_USE_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", 'MX_WTG_PERD_PRTE_DET_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.MX_WTG_PERD_PRTE_DET_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", 'MX_WTG_PERD_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.MX_WTG_PERD_RL=FFL.FORMULA_ID AND FFL.FORMULA_TYPE_ID=FFT.FORMULA_TYPE_ID UNION ALL SELECT NAME "Object Name", 'Plan' "Object Type", 'BEN_PRTN_ELIG_F' "Table Name", 'PRTN_EFF_END_DT_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", EPR.EFFECTIVE_START_DATE "Effective Start Date", EPR.EFFECTIVE_END_DATE "Effective End Date" , FFL.ENTERPRISE_ID "Enterprise ID" FROM BEN_PL_F PLN,BEN_PRTN_ELIG_F EPR, FF_FORMULAS_F FFL, FF_FORMULA_TYPES FFT WHERE PLN.PL_ID=EPR.PL_ID AND EPR.PRTN_EFF_END_DT_RL=FFL.FORMULA_ID AND FFL.FORMULA_TYPE_ID=FFT.FORMULA_TYPE_ID UNION ALL SELECT PLTY.NAME "Object Name", 'PlanType' "Object Type", 'BEN_PRTN_ELIG_F' "Table Name", 'PRTN_EFF_END_DT_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", EPR.EFFECTIVE_START_DATE "Effective Start Date", EPR.EFFECTIVE_END_DATE "Effective End Date" , FFL.ENTERPRISE_ID "Enterprise ID" FROM BEN_PL_TYP_F PLTY,BEN_PTIP_F PTIP,BEN_PRTN_ELIG_F EPR, FF_FORMULAS_F FFL, FF_FORMULA_TYPES FFT WHERE PLTY.PL_TYP_ID=PTIP.PL_TYP_ID AND PTIP.PL_TYP_ID=EPR.PTIP_ID AND EPR.PRTN_EFF_END_DT_RL=FFL.FORMULA_ID AND FFL.FORMULA_TYPE_ID=FFT.FORMULA_TYPE_ID UNION ALL SELECT NAME "Object Name", 'Program' "Object Type", 'BEN_PRTN_ELIG_F' "Table Name", 'PRTN_EFF_END_DT_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", EPR.EFFECTIVE_START_DATE "Effective Start Date", EPR.EFFECTIVE_END_DATE "Effective End Date" , FFL.ENTERPRISE_ID "Enterprise ID" FROM BEN_PGM_F PGM,BEN_PRTN_ELIG_F EPR, FF_FORMULAS_F FFL, FF_FORMULA_TYPES FFT WHERE PGM.PGM_ID=EPR.PGM_ID AND EPR.PRTN_EFF_END_DT_RL=FFL.FORMULA_ID AND FFL.FORMULA_TYPE_ID=FFT.FORMULA_TYPE_ID UNION ALL SELECT NAME "Object Name", 'Plan' "Object Type", 'BEN_PRTN_ELIG_F' "Table Name", 'PRTN_EFF_STRT_DT_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", EPR.EFFECTIVE_START_DATE "Effective Start Date", EPR.EFFECTIVE_END_DATE "Effective End Date" , FFL.ENTERPRISE_ID "Enterprise ID" FROM BEN_PL_F PLN,BEN_PRTN_ELIG_F EPR, FF_FORMULAS_F FFL, FF_FORMULA_TYPES FFT WHERE PLN.PL_ID=EPR.PL_ID AND EPR.PRTN_EFF_STRT_DT_RL=FFL.FORMULA_ID AND FFL.FORMULA_TYPE_ID=FFT.FORMULA_TYPE_ID UNION ALL SELECT PLTY.NAME "Object Name", 'PlanType' "Object Type", 'BEN_PRTN_ELIG_F' "Table Name", 'PRTN_EFF_STRT_DT_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", EPR.EFFECTIVE_START_DATE "Effective Start Date", EPR.EFFECTIVE_END_DATE "Effective End Date" , FFL.ENTERPRISE_ID "Enterprise ID" FROM BEN_PL_TYP_F PLTY,BEN_PTIP_F PTIP,BEN_PRTN_ELIG_F EPR, FF_FORMULAS_F FFL, FF_FORMULA_TYPES FFT WHERE PLTY.PL_TYP_ID=PTIP.PL_TYP_ID AND PTIP.PL_TYP_ID=EPR.PTIP_ID AND EPR.PRTN_EFF_STRT_DT_RL=FFL.FORMULA_ID AND FFL.FORMULA_TYPE_ID=FFT.FORMULA_TYPE_ID UNION ALL SELECT NAME "Object Name", 'Program' "Object Type", 'BEN_PRTN_ELIG_F' "Table Name", 'PRTN_EFF_STRT_DT_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", EPR.EFFECTIVE_START_DATE "Effective Start Date", EPR.EFFECTIVE_END_DATE "Effective End Date" , FFL.ENTERPRISE_ID "Enterprise ID" FROM BEN_PGM_F PGM,BEN_PRTN_ELIG_F EPR, FF_FORMULAS_F FFL, FF_FORMULA_TYPES FFT WHERE PGM.PGM_ID=EPR.PGM_ID AND EPR.PRTN_EFF_STRT_DT_RL=FFL.FORMULA_ID AND FFL.FORMULA_TYPE_ID=FFT.FORMULA_TYPE_ID UNION ALL SELECT NAME "Object Name", 'Plan' "Object Type", 'BEN_PRTN_ELIG_F' "Table Name", 'WAIT_PERD_DT_TO_USE_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", EPR.EFFECTIVE_START_DATE "Effective Start Date", EPR.EFFECTIVE_END_DATE "Effective End Date" , FFL.ENTERPRISE_ID "Enterprise ID" FROM BEN_PL_F PLN,BEN_PRTN_ELIG_F EPR, FF_FORMULAS_F FFL, FF_FORMULA_TYPES FFT WHERE PLN.PL_ID=EPR.PL_ID AND EPR.WAIT_PERD_DT_TO_USE_RL =FFL.FORMULA_ID AND FFL.FORMULA_TYPE_ID=FFT.FORMULA_TYPE_ID UNION ALL SELECT PLTY.NAME "Object Name", 'PlanType' "Object Type", 'BEN_PRTN_ELIG_F' "Table Name", 'WAIT_PERD_DT_TO_USE_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", EPR.EFFECTIVE_START_DATE "Effective Start Date", EPR.EFFECTIVE_END_DATE "Effective End Date" , FFL.ENTERPRISE_ID "Enterprise ID" FROM BEN_PL_TYP_F PLTY,BEN_PTIP_F PTIP,BEN_PRTN_ELIG_F EPR, FF_FORMULAS_F FFL, FF_FORMULA_TYPES FFT WHERE PLTY.PL_TYP_ID=PTIP.PL_TYP_ID AND PTIP.PL_TYP_ID=EPR.PTIP_ID AND EPR.WAIT_PERD_DT_TO_USE_RL=FFL.FORMULA_ID AND FFL.FORMULA_TYPE_ID=FFT.FORMULA_TYPE_ID UNION ALL SELECT NAME "Object Name", 'Program' "Object Type", 'BEN_PRTN_ELIG_F' "Table Name", 'WAIT_PERD_DT_TO_USE_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", EPR.EFFECTIVE_START_DATE "Effective Start Date", EPR.EFFECTIVE_END_DATE "Effective End Date" , FFL.ENTERPRISE_ID "Enterprise ID" FROM BEN_PGM_F PGM,BEN_PRTN_ELIG_F EPR, FF_FORMULAS_F FFL, FF_FORMULA_TYPES FFT WHERE PGM.PGM_ID=EPR.PGM_ID AND EPR.WAIT_PERD_DT_TO_USE_RL=FFL.FORMULA_ID AND FFL.FORMULA_TYPE_ID=FFT.FORMULA_TYPE_ID UNION ALL SELECT NAME "Object Name", 'Plan' "Object Type", 'BEN_PRTN_ELIG_F' "Table Name", 'WAIT_PERD_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", EPR.EFFECTIVE_START_DATE "Effective Start Date", EPR.EFFECTIVE_END_DATE "Effective End Date" , FFL.ENTERPRISE_ID "Enterprise ID" FROM BEN_PL_F PLN,BEN_PRTN_ELIG_F EPR, FF_FORMULAS_F FFL, FF_FORMULA_TYPES FFT WHERE PLN.PL_ID=EPR.PL_ID AND EPR.WAIT_PERD_RL =FFL.FORMULA_ID AND FFL.FORMULA_TYPE_ID=FFT.FORMULA_TYPE_ID UNION ALL SELECT PLTY.NAME "Object Name", 'PlanType' "Object Type", 'BEN_PRTN_ELIG_F' "Table Name", 'WAIT_PERD_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", EPR.EFFECTIVE_START_DATE "Effective Start Date", EPR.EFFECTIVE_END_DATE "Effective End Date" , FFL.ENTERPRISE_ID "Enterprise ID" FROM BEN_PL_TYP_F PLTY,BEN_PTIP_F PTIP,BEN_PRTN_ELIG_F EPR, FF_FORMULAS_F FFL, FF_FORMULA_TYPES FFT WHERE PLTY.PL_TYP_ID=PTIP.PL_TYP_ID AND PTIP.PL_TYP_ID=EPR.PTIP_ID AND EPR.WAIT_PERD_RL=FFL.FORMULA_ID AND FFL.FORMULA_TYPE_ID=FFT.FORMULA_TYPE_ID UNION ALL SELECT NAME "Object Name", 'Program' "Object Type", 'BEN_PRTN_ELIG_F' "Table Name", 'WAIT_PERD_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", EPR.EFFECTIVE_START_DATE "Effective Start Date", EPR.EFFECTIVE_END_DATE "Effective End Date" , FFL.ENTERPRISE_ID "Enterprise ID" FROM BEN_PGM_F PGM,BEN_PRTN_ELIG_F EPR, FF_FORMULAS_F FFL, FF_FORMULA_TYPES FFT WHERE PGM.PGM_ID=EPR.PGM_ID AND EPR.WAIT_PERD_RL=FFL.FORMULA_ID AND FFL.FORMULA_TYPE_ID=FFT.FORMULA_TYPE_ID