[Home] [Help] [Dependency Information]
Object Name: | BENBV_PGM_V |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | BEN.BENBV_PGM_V |
Subobject Name: | |
Status: | VALID |
Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.
Internal
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
EFFECTIVE_START_DATE | DATE | Yes | Effective start date. | |
EFFECTIVE_END_DATE | DATE | Yes | Effective end date. | |
NAME | VARCHAR2 | (240) | Yes | Program name. |
COORD_CVG_FOR_ALL_PLS_FLG | VARCHAR2 | (30) | Yes | Coordinate coverage for all plans (Lookup code based on lookup type YES_NO). |
COORD_CVG_FOR_ALL_PLS_FLG_M | VARCHAR2 | (4000) | Coordinate coverage for all plans (Lookup meaning based on lookup type YES_NO). | |
ENRT_CVG_END_DT_RL | NUMBER | (15) | Foreign Key to FF_FORMULAS_F | |
IVR_IDENT | VARCHAR2 | (90) | Program interactive voice response identifier. | |
ENRT_CVG_STRT_DT_RL | NUMBER | (15) | Foreign Key to FF_FORMULAS_F | |
DPNT_CVG_STRT_DT_RL | NUMBER | (15) | Foreign Key to FF_FORMULAS_F | |
URL_REF_NAME | VARCHAR2 | (240) | Url reference name. | |
PGM_DESC | VARCHAR2 | (2000) | Program description. | |
MX_DPNT_PCT_PRTT_LF_AMT | NUMBER | (15) | Maximum dependent percent of participant life insurance coverage amount. | |
MX_SPS_PCT_PRTT_LF_AMT | NUMBER | (15) | Maximum spouse percent of the participant life insurance coverage amount. | |
DPNT_CVG_END_DT_RL | NUMBER | (15) | Foreign Key to FF_FORMULAS_F | |
RT_STRT_DT_RL | NUMBER | (15) | Foreign Key to FF_FORMULAS_F | |
RT_END_DT_RL | NUMBER | (15) | Foreign Key to FF_FORMULAS_F | |
PGM_UOM | VARCHAR2 | (30) | Program uom. | |
AUTO_ENRT_MTHD_RL | NUMBER | (15) | Foreign Key to FF_FORMULAS_F | |
ENRT_RL | NUMBER | (15) | Foreign Key to FF_FORMULAS_F | |
VRFY_FMLY_MMBR_RL | NUMBER | (15) | Foreign Key to FF_FORMULAS_F | |
SHORT_CODE | VARCHAR2 | (30) | Program short code. | |
SHORT_NAME | VARCHAR2 | (30) | Program short name. | |
DFLT_STEP_RL | NUMBER | (15) | Foreign Key to FF_FORMULAS_F | |
SCORES_CALC_RL | NUMBER | (15) | Foreign Key to FF_FORMULAS_F | |
SALARY_CALC_MTHD_RL | NUMBER | (15) | Foreign Key to FF_FORMULAS_F | |
LEGISLATION_CODE | VARCHAR2 | (30) | Foreign key to FND_TERRITORIES. | |
LEGISLATION_SUBGROUP | VARCHAR2 | (30) | Further identifies the legislation of startup data. | |
_DF:PGM | CHAR | (21) | ||
DPNT_DSGN_LVL_CD | VARCHAR2 | (30) | Program dependent designation level (Lookup code based on lookup type BEN_DPNT_DSGN_LVL). | |
DPNT_DSGN_LVL_CD_M | VARCHAR2 | (4000) | Program dependent designation level (Lookup meaning based on lookup type BEN_DPNT_DSGN_LVL). | |
PGM_STAT_CD | VARCHAR2 | (30) | Program status (Lookup code based on lookup type BEN_STAT). | |
PGM_STAT_CD_M | VARCHAR2 | (4000) | Program status (Lookup meaning based on lookup type BEN_STAT). | |
PGM_TYP_CD | VARCHAR2 | (30) | Program type (Lookup code based on lookup type BEN_PGM_TYP). | |
PGM_TYP_CD_M | VARCHAR2 | (4000) | Program type (Lookup meaning based on lookup type BEN_PGM_TYP). | |
DPNT_DSGN_CD | VARCHAR2 | (30) | Program dependent designation (Lookup code based on lookup type BEN_DPNT_DSGN). | |
DPNT_DSGN_CD_M | VARCHAR2 | (4000) | Program dependent designation (Lookup meaning based on lookup type BEN_DPNT_DSGN). | |
ACTY_REF_PERD_CD | VARCHAR2 | (30) | Program activity reference period (Lookup code based on lookup type BEN_ACTY_REF_PERD). | |
ACTY_REF_PERD_CD_M | VARCHAR2 | (4000) | Program activity reference period (Lookup meaning based on lookup type BEN_ACTY_REF_PERD). | |
ENRT_CVG_END_DT_CD | VARCHAR2 | (30) | Program enrollment coverage end date (Lookup code based on lookup type BEN_ENRT_CVG_END). | |
ENRT_CVG_END_DT_CD_M | VARCHAR2 | (4000) | Program enrollment coverage end date (Lookup meaning based on lookup type BEN_ENRT_CVG_END). | |
DPNT_CVG_END_DT_CD | VARCHAR2 | (30) | Program dependent coverage end date (Lookup code based on lookup type BEN_DPNT_CVG_END). | |
DPNT_CVG_END_DT_CD_M | VARCHAR2 | (4000) | Program dependent coverage end date (Lookup meaning based on lookup type BEN_DPNT_CVG_END). | |
DPNT_CVG_STRT_DT_CD | VARCHAR2 | (30) | Program dependent coverage start date (Lookup code based on lookup type BEN_DPNT_CVG_STRT). | |
DPNT_CVG_STRT_DT_CD_M | VARCHAR2 | (4000) | Program dependent coverage start date (Lookup meaning based on lookup type BEN_DPNT_CVG_STRT). | |
ENRT_CVG_STRT_DT_CD | VARCHAR2 | (30) | Program enrollment coverage start date (Lookup code based on lookup type BEN_ENRT_CVG_STRT). | |
ENRT_CVG_STRT_DT_CD_M | VARCHAR2 | (4000) | Program enrollment coverage start date (Lookup meaning based on lookup type BEN_ENRT_CVG_STRT). | |
ENRT_INFO_RT_FREQ_CD | VARCHAR2 | (30) | Program enrollment rate / frequency (Lookup code based on lookup type BEN_ENRT_INFO_RT_FREQ). | |
ENRT_INFO_RT_FREQ_CD_M | VARCHAR2 | (4000) | Program enrollment rate / frequency (Lookup meaning based on lookup type BEN_ENRT_INFO_RT_FREQ). | |
RT_STRT_DT_CD | VARCHAR2 | (30) | Program rate start date (Lookup code based on lookup type BEN_RT_STRT). | |
RT_STRT_DT_CD_M | VARCHAR2 | (4000) | Program rate start date (Lookup meaning based on lookup type BEN_RT_STRT). | |
RT_END_DT_CD | VARCHAR2 | (30) | Program rate end date (Lookup code based on lookup type BEN_RT_END). | |
RT_END_DT_CD_M | VARCHAR2 | (4000) | Program rate end date (Lookup meaning based on lookup type BEN_RT_END). | |
PGM_GRP_CD | VARCHAR2 | (30) | Program group (Lookup code based on lookup type BEN_PGM_GRP). | |
PGM_GRP_CD_M | VARCHAR2 | (4000) | Program group (Lookup meaning based on lookup type BEN_PGM_GRP). | |
ENRT_CD | VARCHAR2 | (30) | Program enrollment code (Lookup code based on lookup type BEN_ENRT). | |
ENRT_CD_M | VARCHAR2 | (4000) | Program enrollment code (Lookup meaning based on lookup type BEN_ENRT). | |
ENRT_MTHD_CD | VARCHAR2 | (30) | Program enrollment method (Lookup code based on lookup type BEN_ENRT_MTHD). | |
ENRT_MTHD_CD_M | VARCHAR2 | (4000) | Program enrollment method (Lookup meaning based on lookup type BEN_ENRT_MTHD). | |
POE_LVL_CD | VARCHAR2 | (30) | General determine enrollment period level (Lookup code based on lookup type BEN_POE_LVL). | |
POE_LVL_CD_M | VARCHAR2 | (4000) | General determine enrollment period level (Lookup meaning based on lookup type BEN_POE_LVL). | |
VRFY_FMLY_MMBR_CD | VARCHAR2 | (30) | General family member code (Lookup code based on lookup type BEN_FMLY_MMBR). | |
VRFY_FMLY_MMBR_CD_M | VARCHAR2 | (4000) | General family member code (Lookup meaning based on lookup type BEN_FMLY_MMBR). | |
PER_CVRD_CD | VARCHAR2 | (30) | Person covered code (Lookup code based on lookup type BEN_PER_CVRD). | |
PER_CVRD_CD_M | VARCHAR2 | (4000) | Person covered code (Lookup meaning based on lookup type BEN_PER_CVRD). | |
DFLT_STEP_CD | VARCHAR2 | (30) | Default step code (Lookup code based on lookup type BEN_DFLT_STEP). | |
DFLT_STEP_CD_M | VARCHAR2 | (4000) | Default step code (Lookup meaning based on lookup type BEN_DFLT_STEP). | |
UPDATE_SALARY_CD | VARCHAR2 | (30) | Update salary code (Lookup code based on lookup type BEN_UPDATE_SALARY). | |
UPDATE_SALARY_CD_M | VARCHAR2 | (4000) | Update salary code (Lookup meaning based on lookup type BEN_UPDATE_SALARY). | |
USE_SCORES_CD | VARCHAR2 | (30) | Use scores code (Lookup code based on lookup type BEN_USE_SCORES). | |
USE_SCORES_CD_M | VARCHAR2 | (4000) | Use scores code (Lookup meaning based on lookup type BEN_USE_SCORES). | |
SCORES_CALC_MTHD_CD | VARCHAR2 | (30) | Scores calculation method (Lookup code based on lookup type BEN_SCORES_CALC_MTHD). | |
SCORES_CALC_MTHD_CD_M | VARCHAR2 | (4000) | Scores calculation method (Lookup meaning based on lookup type BEN_SCORES_CALC_MTHD). | |
SALARY_CALC_MTHD_CD | VARCHAR2 | (30) | Salary Calculation Method Code (Lookup Code of Lookup Type PQH_GSP_SAL_CALC_METH) | |
SALARY_CALC_MTHD_CD_M | VARCHAR2 | (4000) | Salary Calculation Method (Lookup Meaning of Lookup Type PQH_GSP_SAL_CALC_METH) | |
DPNT_ADRS_RQD_FLAG | VARCHAR2 | (30) | Yes | Program dependent address required (Lookup code based on lookup type YES_NO). |
DPNT_ADRS_RQD_FLAG_M | VARCHAR2 | (4000) | Program dependent address required (Lookup meaning based on lookup type YES_NO). | |
PGM_PRVDS_NO_AUTO_ENRT_FLAG | VARCHAR2 | (30) | Yes | Program no automatic enrollment applies (Lookup code based on lookup type YES_NO). |
PGM_PRVDS_NO_AUTO_ENRT_FLAG_M | VARCHAR2 | (4000) | Program no automatic enrollment applies (Lookup meaning based on lookup type YES_NO). | |
DPNT_DOB_RQD_FLAG | VARCHAR2 | (30) | Yes | Dependent date of birth required (Lookup code based on lookup type YES_NO). |
DPNT_DOB_RQD_FLAG_M | VARCHAR2 | (4000) | Dependent date of birth required (Lookup meaning based on lookup type YES_NO). | |
PGM_PRVDS_NO_DFLT_ENRT_FLAG | VARCHAR2 | (30) | Yes | Program no default enrollment applies (Lookup code based on lookup type YES_NO). |
PGM_PRVDS_NO_DFLT_ENRT_FLAG_M | VARCHAR2 | (4000) | Program no default enrollment applies (Lookup meaning based on lookup type YES_NO). | |
DPNT_LEGV_ID_RQD_FLAG | VARCHAR2 | (30) | Yes | Dependent ssn / legislative id required (Lookup code based on lookup type YES_NO). |
DPNT_LEGV_ID_RQD_FLAG_M | VARCHAR2 | (4000) | Dependent ssn / legislative id required (Lookup meaning based on lookup type YES_NO). | |
ELIG_APLS_FLAG | VARCHAR2 | (30) | Yes | Eligibility applies (Lookup code based on lookup type YES_NO). |
ELIG_APLS_FLAG_M | VARCHAR2 | (4000) | Eligibility applies (Lookup meaning based on lookup type YES_NO). | |
USES_ALL_ASMTS_FOR_RTS_FLAG | VARCHAR2 | (30) | Yes | Program use all assignments for rates (Lookup code based on lookup type YES_NO). |
USES_ALL_ASMTS_FOR_RTS_FLAG_M | VARCHAR2 | (4000) | Program use all assignments for rates (Lookup meaning based on lookup type YES_NO). | |
PRTN_ELIG_OVRID_ALWD_FLAG | VARCHAR2 | (30) | Yes | Program participation eligibility override allowed (Lookup code based on lookup type YES_NO). |
PRTN_ELIG_OVRID_ALWD_FLAG_M | VARCHAR2 | (4000) | Program participation eligibility override allowed (Lookup meaning based on lookup type YES_NO). | |
PGM_USE_ALL_ASNTS_ELIG_FLAG | VARCHAR2 | (30) | Yes | Program use all assignments for eligibility (Lookup code based on lookup type YES_NO). |
PGM_USE_ALL_ASNTS_ELIG_FLAG_M | VARCHAR2 | (4000) | Program use all assignments for eligibility (Lookup meaning based on lookup type YES_NO). | |
DPNT_DSGN_NO_CTFN_RQD_FLAG | VARCHAR2 | (30) | Yes | Program dependent coverage no certification required (Lookup code based on lookup type YES_NO). |
DPNT_DSGN_NO_CTFN_RQD_FLAG_M | VARCHAR2 | (4000) | Program dependent coverage no certification required (Lookup meaning based on lookup type YES_NO). | |
DRVBL_FCTR_DPNT_ELIG_FLAG | VARCHAR2 | (30) | Yes | Program dependent coverage derivable factors apply (Lookup code based on lookup type YES_NO). |
DRVBL_FCTR_DPNT_ELIG_FLAG_M | VARCHAR2 | (4000) | Program dependent coverage derivable factors apply (Lookup meaning based on lookup type YES_NO). | |
DRVBL_FCTR_PRTN_ELIG_FLAG | VARCHAR2 | (30) | Yes | Derivable factors participation eligibility (Lookup code based on lookup type YES_NO). |
DRVBL_FCTR_PRTN_ELIG_FLAG_M | VARCHAR2 | (4000) | Derivable factors participation eligibility (Lookup meaning based on lookup type YES_NO). | |
DRVBL_FCTR_APLS_RTS_FLAG | VARCHAR2 | (30) | Yes | Derived factors applies to rates (Lookup code based on lookup type YES_NO). |
DRVBL_FCTR_APLS_RTS_FLAG_M | VARCHAR2 | (4000) | Derived factors applies to rates (Lookup meaning based on lookup type YES_NO). | |
TRK_INELIG_PER_FLAG | VARCHAR2 | (30) | Yes | Program track ineligible person (Lookup code based on lookup type YES_NO). |
TRK_INELIG_PER_FLAG_M | VARCHAR2 | (4000) | Program track ineligible person (Lookup meaning based on lookup type YES_NO). | |
ALWS_UNRSTRCTD_ENRT_FLAG | VARCHAR2 | (30) | Yes | Program allows unrestricted enrollment (Lookup code based on lookup type YES_NO). |
ALWS_UNRSTRCTD_ENRT_FLAG_M | VARCHAR2 | (4000) | Program allows unrestricted enrollment (Lookup meaning based on lookup type YES_NO). | |
DFLT_PGM_FLAG | VARCHAR2 | (30) | Yes | Default program flag (Lookup code based on lookup type YES_NO). |
DFLT_PGM_FLAG_M | VARCHAR2 | (4000) | Default program flag (Lookup meaning based on lookup type YES_NO). | |
USE_PROG_POINTS_FLAG | VARCHAR2 | (30) | Yes | Use program points (Lookup code based on lookup type YES_NO). |
USE_PROG_POINTS_FLAG_M | VARCHAR2 | (4000) | Use program points (Lookup meaning based on lookup type YES_NO). | |
USE_MULTI_PAY_RATES_FLAG | VARCHAR2 | (30) | Yes | Use multi pay rates (Lookup code based on lookup type YES_NO). |
USE_MULTI_PAY_RATES_FLAG_M | VARCHAR2 | (4000) | Use multi pay rates (Lookup meaning based on lookup type YES_NO). | |
USE_VARIABLE_RATES_FLAG | VARCHAR2 | (30) | Yes | Use Variable Rates Flag (Lookup Code of Lookup Type YES_NO) |
USE_VARIABLE_RATES_FLAG_M | VARCHAR2 | (4000) | Use Variable Rates Flag (Lookup Meaning of Lookup Type YES_NO) | |
GSP_ALLOW_OVERRIDE_FLAG | VARCHAR2 | (30) | Yes | GSP Allow Override Flag (Lookup Code of Lookup Type YES_NO) |
GSP_ALLOW_OVERRIDE_FLAG_M | VARCHAR2 | (4000) | GSP Allow Override Flag (Lookup Meaning of Lookup Type YES_NO) | |
PGM_ID | NUMBER | (15) | Yes | System generated primary key column. |
BUSINESS_GROUP_ID | NUMBER | (15) | Foreign Key to HR_ORGANIZATION_UNITS. | |
DFLT_ELEMENT_TYPE_ID | NUMBER | (15) | Foreign key to PAY_ELEMENT_TYPES_F | |
DFLT_INPUT_VALUE_ID | NUMBER | (15) | Foreign key to PAY_INPUT_VALUES_F | |
LAST_UPDATE_DATE | DATE | Standard Who column - date when a user last updated this row. | ||
LAST_UPDATED_BY | NUMBER | (15) | Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID). | |
CREATED_BY | NUMBER | (15) | Standard who column - user who created this row (foreign key to FND_USER.USER_ID). | |
CREATION_DATE | DATE | Standard who column - date when this row was created. |
Cut, paste (and edit) the following text to query this object:
SELECT EFFECTIVE_START_DATE
, EFFECTIVE_END_DATE
, NAME
, COORD_CVG_FOR_ALL_PLS_FLG
, COORD_CVG_FOR_ALL_PLS_FLG_M
, ENRT_CVG_END_DT_RL
, IVR_IDENT
, ENRT_CVG_STRT_DT_RL
, DPNT_CVG_STRT_DT_RL
, URL_REF_NAME
, PGM_DESC
, MX_DPNT_PCT_PRTT_LF_AMT
, MX_SPS_PCT_PRTT_LF_AMT
, DPNT_CVG_END_DT_RL
, RT_STRT_DT_RL
, RT_END_DT_RL
, PGM_UOM
, AUTO_ENRT_MTHD_RL
, ENRT_RL
, VRFY_FMLY_MMBR_RL
, SHORT_CODE
, SHORT_NAME
, DFLT_STEP_RL
, SCORES_CALC_RL
, SALARY_CALC_MTHD_RL
, LEGISLATION_CODE
, LEGISLATION_SUBGROUP
, _DF:PGM
, DPNT_DSGN_LVL_CD
, DPNT_DSGN_LVL_CD_M
, PGM_STAT_CD
, PGM_STAT_CD_M
, PGM_TYP_CD
, PGM_TYP_CD_M
, DPNT_DSGN_CD
, DPNT_DSGN_CD_M
, ACTY_REF_PERD_CD
, ACTY_REF_PERD_CD_M
, ENRT_CVG_END_DT_CD
, ENRT_CVG_END_DT_CD_M
, DPNT_CVG_END_DT_CD
, DPNT_CVG_END_DT_CD_M
, DPNT_CVG_STRT_DT_CD
, DPNT_CVG_STRT_DT_CD_M
, ENRT_CVG_STRT_DT_CD
, ENRT_CVG_STRT_DT_CD_M
, ENRT_INFO_RT_FREQ_CD
, ENRT_INFO_RT_FREQ_CD_M
, RT_STRT_DT_CD
, RT_STRT_DT_CD_M
, RT_END_DT_CD
, RT_END_DT_CD_M
, PGM_GRP_CD
, PGM_GRP_CD_M
, ENRT_CD
, ENRT_CD_M
, ENRT_MTHD_CD
, ENRT_MTHD_CD_M
, POE_LVL_CD
, POE_LVL_CD_M
, VRFY_FMLY_MMBR_CD
, VRFY_FMLY_MMBR_CD_M
, PER_CVRD_CD
, PER_CVRD_CD_M
, DFLT_STEP_CD
, DFLT_STEP_CD_M
, UPDATE_SALARY_CD
, UPDATE_SALARY_CD_M
, USE_SCORES_CD
, USE_SCORES_CD_M
, SCORES_CALC_MTHD_CD
, SCORES_CALC_MTHD_CD_M
, SALARY_CALC_MTHD_CD
, SALARY_CALC_MTHD_CD_M
, DPNT_ADRS_RQD_FLAG
, DPNT_ADRS_RQD_FLAG_M
, PGM_PRVDS_NO_AUTO_ENRT_FLAG
, PGM_PRVDS_NO_AUTO_ENRT_FLAG_M
, DPNT_DOB_RQD_FLAG
, DPNT_DOB_RQD_FLAG_M
, PGM_PRVDS_NO_DFLT_ENRT_FLAG
, PGM_PRVDS_NO_DFLT_ENRT_FLAG_M
, DPNT_LEGV_ID_RQD_FLAG
, DPNT_LEGV_ID_RQD_FLAG_M
, ELIG_APLS_FLAG
, ELIG_APLS_FLAG_M
, USES_ALL_ASMTS_FOR_RTS_FLAG
, USES_ALL_ASMTS_FOR_RTS_FLAG_M
, PRTN_ELIG_OVRID_ALWD_FLAG
, PRTN_ELIG_OVRID_ALWD_FLAG_M
, PGM_USE_ALL_ASNTS_ELIG_FLAG
, PGM_USE_ALL_ASNTS_ELIG_FLAG_M
, DPNT_DSGN_NO_CTFN_RQD_FLAG
, DPNT_DSGN_NO_CTFN_RQD_FLAG_M
, DRVBL_FCTR_DPNT_ELIG_FLAG
, DRVBL_FCTR_DPNT_ELIG_FLAG_M
, DRVBL_FCTR_PRTN_ELIG_FLAG
, DRVBL_FCTR_PRTN_ELIG_FLAG_M
, DRVBL_FCTR_APLS_RTS_FLAG
, DRVBL_FCTR_APLS_RTS_FLAG_M
, TRK_INELIG_PER_FLAG
, TRK_INELIG_PER_FLAG_M
, ALWS_UNRSTRCTD_ENRT_FLAG
, ALWS_UNRSTRCTD_ENRT_FLAG_M
, DFLT_PGM_FLAG
, DFLT_PGM_FLAG_M
, USE_PROG_POINTS_FLAG
, USE_PROG_POINTS_FLAG_M
, USE_MULTI_PAY_RATES_FLAG
, USE_MULTI_PAY_RATES_FLAG_M
, USE_VARIABLE_RATES_FLAG
, USE_VARIABLE_RATES_FLAG_M
, GSP_ALLOW_OVERRIDE_FLAG
, GSP_ALLOW_OVERRIDE_FLAG_M
, PGM_ID
, BUSINESS_GROUP_ID
, DFLT_ELEMENT_TYPE_ID
, DFLT_INPUT_VALUE_ID
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, CREATED_BY
, CREATION_DATE
FROM APPS.BENBV_PGM_V;
|
|
|