DBA Data[Home] [Help] [Dependency Information]

VIEW: APPS.BENBV_PGM_V

Object Details
Object Name: BENBV_PGM_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewBEN.BENBV_PGM_V
Subobject Name:
Status: VALID

***** Warning: Oracle Internal Use Only *****

Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.

View Type

Internal

[View Source]

Columns
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.
Query Text

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;

Dependencies

[top of page]

APPS.BENBV_PGM_V references the following:

SchemaAPPS
SynonymBEN_PGM_F
PL/SQL PackageHR_BIS - show dependent code

APPS.BENBV_PGM_V is not referenced by any database object