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

VIEW: APPS.BENBV_PLIP_V

Object Details
Object Name: BENBV_PLIP_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewBEN.BENBV_PLIP_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.
POSTELCN_EDIT_RL NUMBER (15)
Foreign Key to FF_FORMULAS_F
ORDR_NUM NUMBER (15)
Plans in program sequence.
IVR_IDENT VARCHAR2 (90)
Plan in program integrated voice response.
DFLT_ENRT_DET_RL NUMBER (15)
Foreign Key to FF_FORMULAS_F
AUTO_ENRT_MTHD_RL NUMBER (15)
Foreign Key to FF_FORMULAS_F
ENRT_RL NUMBER (15)
Foreign Key to FF_FORMULAS_F
ENRT_CVG_STRT_DT_RL NUMBER (15)
Foreign Key to FF_FORMULAS_F
ENRT_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
URL_REF_NAME VARCHAR2 (240)
Plan in program web address.
DFLT_TO_ASN_PNDG_CTFN_RL NUMBER (15)
Foreign Key to FF_FORMULAS_F
MN_CVG_AMT NUMBER

Plans in program min coverage amount.
MN_CVG_RL NUMBER (15)
Foreign Key to FF_FORMULAS_F
MX_CVG_ALWD_AMT NUMBER

Plans in program max coverage amount.
MX_CVG_INCR_ALWD_AMT NUMBER

Maximum coverage increase allowed amount.
MX_CVG_INCR_WCF_ALWD_AMT NUMBER

Maximum coverage increase with certification allowed amount.
MX_CVG_MLT_INCR_NUM NUMBER (15)
Maximum coverage multiple increase number.
MX_CVG_MLT_INCR_WCF_NUM NUMBER (15)
Maximum coverage multiple increase with certification number.
MX_CVG_RL NUMBER (15)
Foreign Key to FF_FORMULAS_F
MX_CVG_WCFN_AMT NUMBER

Maximum coverage with certification amount.
MX_CVG_WCFN_MLT_NUM NUMBER (15)
Maximum coverage with certification multiple number.
PRORT_PRTL_YR_CVG_RSTRN_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)
Plan in program short code.
SHORT_NAME VARCHAR2 (30)
Plan in program short name.
LEGISLATION_CODE VARCHAR2 (30)
Foreign key to FND_TERRITORIES.
LEGISLATION_SUBGROUP VARCHAR2 (30)
Further identifies the legislation of startup data.
_DF:CPP CHAR (22)
PLIP_STAT_CD VARCHAR2 (30) Yes Plan in program status (Lookup code based on lookup type BEN_STAT).
PLIP_STAT_CD_M VARCHAR2 (4000)
Plan in program status (Lookup meaning based on lookup type BEN_STAT).
DFLT_ENRT_CD VARCHAR2 (30)
Plan in program default enrollment code (Lookup code based on lookup type BEN_DFLT_ENRT).
DFLT_ENRT_CD_M VARCHAR2 (4000)
Plan in program default enrollment code (Lookup meaning based on lookup type BEN_DFLT_ENRT).
ENRT_CD VARCHAR2 (30)
Plan in program enrollment code (Lookup code based on lookup type BEN_ENRT).
ENRT_CD_M VARCHAR2 (4000)
Plan in program enrollment code (Lookup meaning based on lookup type BEN_ENRT).
ENRT_MTHD_CD VARCHAR2 (30)
Plan enrollment method (Lookup code based on lookup type BEN_ENRT_MTHD).
ENRT_MTHD_CD_M VARCHAR2 (4000)
Plan enrollment method (Lookup meaning based on lookup type BEN_ENRT_MTHD).
ENRT_CVG_STRT_DT_CD VARCHAR2 (30)
Plan enrollment coverage start date code (Lookup code based on lookup type BEN_ENRT_CVG_STRT).
ENRT_CVG_STRT_DT_CD_M VARCHAR2 (4000)
Plan enrollment coverage start date code (Lookup meaning based on lookup type BEN_ENRT_CVG_STRT).
ENRT_CVG_END_DT_CD VARCHAR2 (30)
Plan enrollment coverage end date code (Lookup code based on lookup type BEN_ENRT_CVG_END).
ENRT_CVG_END_DT_CD_M VARCHAR2 (4000)
Plan enrollment coverage end date code (Lookup meaning based on lookup type BEN_ENRT_CVG_END).
RT_STRT_DT_CD VARCHAR2 (30)
Plan rate start date code (Lookup code based on lookup type BEN_RT_STRT).
RT_STRT_DT_CD_M VARCHAR2 (4000)
Plan rate start date code (Lookup meaning based on lookup type BEN_RT_STRT).
RT_END_DT_CD VARCHAR2 (30)
Plan rate end date code (Lookup code based on lookup type BEN_RT_END).
RT_END_DT_CD_M VARCHAR2 (4000)
Plan rate end date code (Lookup meaning based on lookup type BEN_RT_END).
CVG_INCR_R_DECR_ONLY_CD VARCHAR2 (30)
Coverage increment or decrement only (Lookup code based on lookup type BEN_CVG_INCR_R_DECR_ONLY).
CVG_INCR_R_DECR_ONLY_CD_M VARCHAR2 (4000)
Coverage increment or decrement only (Lookup meaning based on lookup type BEN_CVG_INCR_R_DECR_ONLY).
DFLT_TO_ASN_PNDG_CTFN_CD VARCHAR2 (30)
Default to assign pending notification code (Lookup code based on lookup type BEN_DFLT_TO_ASN_PNDG_CTFN).
DFLT_TO_ASN_PNDG_CTFN_CD_M VARCHAR2 (4000)
Default to assign pending notification code (Lookup meaning based on lookup type BEN_DFLT_TO_ASN_PNDG_CTFN).
UNSSPND_ENRT_CD VARCHAR2 (30)
Unsuspended enrollment code (Lookup code based on lookup type BEN_UNSSPND_ENRT).
UNSSPND_ENRT_CD_M VARCHAR2 (4000)
Unsuspended enrollment code (Lookup meaning based on lookup type BEN_UNSSPND_ENRT).
PRORT_PRTL_YR_CVG_RSTRN_CD VARCHAR2 (30)
Prorate partial year coverage restriction (Lookup code based on lookup type BEN_PRORT_PRTL_YR_CVG_RSTRN).
PRORT_PRTL_YR_CVG_RSTRN_CD_M VARCHAR2 (4000)
Prorate partial year coverage restriction (Lookup meaning based on lookup type BEN_PRORT_PRTL_YR_CVG_RSTRN).
BNFT_OR_OPTION_RSTRCTN_CD VARCHAR2 (30)
Benefit or option restriction (Lookup code based on lookup type BEN_BNFT_R_OPT_RSTRN).
BNFT_OR_OPTION_RSTRCTN_CD_M VARCHAR2 (4000)
Benefit or option restriction (Lookup meaning based on lookup type BEN_BNFT_R_OPT_RSTRN).
VRFY_FMLY_MMBR_CD VARCHAR2 (30)
Plan in program family member code (Lookup code based on lookup type BEN_FMLY_MMBR).
VRFY_FMLY_MMBR_CD_M VARCHAR2 (4000)
Plan in program 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).
USE_CSD_RSD_PRCCNG_CD VARCHAR2 (30)
User Coverage and/or Rate Start Date for Processing Code (Lookup Code of Lookup Type BEN_USE_CSD_RSD_PRCCNG)
USE_CSD_RSD_PRCCNG_CD_M VARCHAR2 (4000)
User Coverage and/or Rate Start Date for Processing Code (Lookup Meaning of Lookup Type BEN_USE_CSD_RSD_PRCCNG)
DFLT_FLAG VARCHAR2 (30) Yes Plan in program assign on default flag (Lookup code based on lookup type YES_NO).
DFLT_FLAG_M VARCHAR2 (4000)
Plan in program assign on default flag (Lookup meaning based on lookup type YES_NO).
ALWS_UNRSTRCTD_ENRT_FLAG VARCHAR2 (30) Yes Plan in program allows unrestricted enrollment (Lookup code based on lookup type YES_NO).
ALWS_UNRSTRCTD_ENRT_FLAG_M VARCHAR2 (4000)
Plan in program allows unrestricted enrollment (Lookup meaning based on lookup type YES_NO).
DRVBL_FCTR_APLS_RTS_FLAG VARCHAR2 (30) Yes Derivable factors apply to rates (Lookup code based on lookup type YES_NO).
DRVBL_FCTR_APLS_RTS_FLAG_M VARCHAR2 (4000)
Derivable factors apply to rates (Lookup meaning based on lookup type YES_NO).
DRVBL_FCTR_PRTN_ELIG_FLAG VARCHAR2 (30) Yes Derivable factors for participation eligibility (Lookup code based on lookup type YES_NO).
DRVBL_FCTR_PRTN_ELIG_FLAG_M VARCHAR2 (4000)
Derivable factors for participation eligibility (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).
PRTN_ELIG_OVRID_ALWD_FLAG VARCHAR2 (30) Yes Plan in program participation eligibility override allowed (Lookup code based on lookup type YES_NO).
PRTN_ELIG_OVRID_ALWD_FLAG_M VARCHAR2 (4000)
Plan in program participation eligibility override allowed (Lookup meaning based on lookup type YES_NO).
TRK_INELIG_PER_FLAG VARCHAR2 (30) Yes Plan in program track ineligible person (Lookup code based on lookup type YES_NO).
TRK_INELIG_PER_FLAG_M VARCHAR2 (4000)
Plan in program track ineligible person (Lookup meaning based on lookup type YES_NO).
NO_MN_CVG_AMT_APLS_FLAG VARCHAR2 (30)
No minimum coverage amount applies (Lookup code based on lookup type YES_NO).
NO_MN_CVG_AMT_APLS_FLAG_M VARCHAR2 (4000)
No minimum coverage amount applies (Lookup meaning based on lookup type YES_NO).
NO_MN_CVG_INCR_APLS_FLAG VARCHAR2 (30)
No minimum coverage increase applies (Lookup code based on lookup type YES_NO).
NO_MN_CVG_INCR_APLS_FLAG_M VARCHAR2 (4000)
No minimum coverage increase applies (Lookup meaning based on lookup type YES_NO).
NO_MX_CVG_AMT_APLS_FLAG VARCHAR2 (30)
No maximum coverage amount applies (Lookup code based on lookup type YES_NO).
NO_MX_CVG_AMT_APLS_FLAG_M VARCHAR2 (4000)
No maximum coverage amount applies (Lookup meaning based on lookup type YES_NO).
NO_MX_CVG_INCR_APLS_FLAG VARCHAR2 (30)
No maximum coverage increase applies (Lookup code based on lookup type YES_NO).
NO_MX_CVG_INCR_APLS_FLAG_M VARCHAR2 (4000)
No maximum coverage increase applies (Lookup meaning based on lookup type YES_NO).
PLIP_ID NUMBER (15) Yes System generated primary key column.
PGM_ID NUMBER (15) Yes Foreign key to BEN_PGM_F.
PL_ID NUMBER (15) Yes Foreign key to BEN_PL_F.
BUSINESS_GROUP_ID NUMBER (15)
Foreign Key to HR_ORGANIZATION_UNITS.
CMBN_PLIP_ID NUMBER (15)
Foreign key to BEN_CMBN_PLIP_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
,      POSTELCN_EDIT_RL
,      ORDR_NUM
,      IVR_IDENT
,      DFLT_ENRT_DET_RL
,      AUTO_ENRT_MTHD_RL
,      ENRT_RL
,      ENRT_CVG_STRT_DT_RL
,      ENRT_CVG_END_DT_RL
,      RT_STRT_DT_RL
,      RT_END_DT_RL
,      URL_REF_NAME
,      DFLT_TO_ASN_PNDG_CTFN_RL
,      MN_CVG_AMT
,      MN_CVG_RL
,      MX_CVG_ALWD_AMT
,      MX_CVG_INCR_ALWD_AMT
,      MX_CVG_INCR_WCF_ALWD_AMT
,      MX_CVG_MLT_INCR_NUM
,      MX_CVG_MLT_INCR_WCF_NUM
,      MX_CVG_RL
,      MX_CVG_WCFN_AMT
,      MX_CVG_WCFN_MLT_NUM
,      PRORT_PRTL_YR_CVG_RSTRN_RL
,      VRFY_FMLY_MMBR_RL
,      SHORT_CODE
,      SHORT_NAME
,      LEGISLATION_CODE
,      LEGISLATION_SUBGROUP
,      _DF:CPP
,      PLIP_STAT_CD
,      PLIP_STAT_CD_M
,      DFLT_ENRT_CD
,      DFLT_ENRT_CD_M
,      ENRT_CD
,      ENRT_CD_M
,      ENRT_MTHD_CD
,      ENRT_MTHD_CD_M
,      ENRT_CVG_STRT_DT_CD
,      ENRT_CVG_STRT_DT_CD_M
,      ENRT_CVG_END_DT_CD
,      ENRT_CVG_END_DT_CD_M
,      RT_STRT_DT_CD
,      RT_STRT_DT_CD_M
,      RT_END_DT_CD
,      RT_END_DT_CD_M
,      CVG_INCR_R_DECR_ONLY_CD
,      CVG_INCR_R_DECR_ONLY_CD_M
,      DFLT_TO_ASN_PNDG_CTFN_CD
,      DFLT_TO_ASN_PNDG_CTFN_CD_M
,      UNSSPND_ENRT_CD
,      UNSSPND_ENRT_CD_M
,      PRORT_PRTL_YR_CVG_RSTRN_CD
,      PRORT_PRTL_YR_CVG_RSTRN_CD_M
,      BNFT_OR_OPTION_RSTRCTN_CD
,      BNFT_OR_OPTION_RSTRCTN_CD_M
,      VRFY_FMLY_MMBR_CD
,      VRFY_FMLY_MMBR_CD_M
,      PER_CVRD_CD
,      PER_CVRD_CD_M
,      USE_CSD_RSD_PRCCNG_CD
,      USE_CSD_RSD_PRCCNG_CD_M
,      DFLT_FLAG
,      DFLT_FLAG_M
,      ALWS_UNRSTRCTD_ENRT_FLAG
,      ALWS_UNRSTRCTD_ENRT_FLAG_M
,      DRVBL_FCTR_APLS_RTS_FLAG
,      DRVBL_FCTR_APLS_RTS_FLAG_M
,      DRVBL_FCTR_PRTN_ELIG_FLAG
,      DRVBL_FCTR_PRTN_ELIG_FLAG_M
,      ELIG_APLS_FLAG
,      ELIG_APLS_FLAG_M
,      PRTN_ELIG_OVRID_ALWD_FLAG
,      PRTN_ELIG_OVRID_ALWD_FLAG_M
,      TRK_INELIG_PER_FLAG
,      TRK_INELIG_PER_FLAG_M
,      NO_MN_CVG_AMT_APLS_FLAG
,      NO_MN_CVG_AMT_APLS_FLAG_M
,      NO_MN_CVG_INCR_APLS_FLAG
,      NO_MN_CVG_INCR_APLS_FLAG_M
,      NO_MX_CVG_AMT_APLS_FLAG
,      NO_MX_CVG_AMT_APLS_FLAG_M
,      NO_MX_CVG_INCR_APLS_FLAG
,      NO_MX_CVG_INCR_APLS_FLAG_M
,      PLIP_ID
,      PGM_ID
,      PL_ID
,      BUSINESS_GROUP_ID
,      CMBN_PLIP_ID
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATED_BY
,      CREATION_DATE
FROM APPS.BENBV_PLIP_V;

Dependencies

[top of page]

APPS.BENBV_PLIP_V references the following:

SchemaAPPS
SynonymBEN_PLIP_F
PL/SQL PackageHR_BIS - show dependent code

APPS.BENBV_PLIP_V is not referenced by any database object