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

TABLE: BEN.BEN_PLIP_F

Object Details
Object Name: BEN_PLIP_F
Object Type: TABLE
Owner: BEN
FND Design Data: TableBEN.BEN_PLIP_F
Subobject Name:
Status: VALID


BEN_PLIP_F identifies and specifies processing characteristics of a plan assigned to a program.


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Primary Key: BEN_PLIP_F_PK
  1. ColumnPLIP_ID
  2. ColumnEFFECTIVE_START_DATE
  3. ColumnEFFECTIVE_END_DATE
Indexes
Index Type Uniqueness Tablespace Column
BEN_PLIP_F_PK NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnPLIP_ID
ColumnEFFECTIVE_START_DATE
ColumnEFFECTIVE_END_DATE
BEN_PLIP_F_FK1 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnBUSINESS_GROUP_ID
BEN_PLIP_F_N1 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnPGM_ID
BEN_PLIP_F_N2 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnPL_ID
BEN_PLIP_F_N3 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnDFLT_ENRT_DET_RL
BEN_PLIP_F_N4 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnCMBN_PLIP_ID
Columns
Name Datatype Length Mandatory Comments
PLIP_ID NUMBER (15) Yes System generated primary key column.
EFFECTIVE_START_DATE DATE
Yes Effective start date.
EFFECTIVE_END_DATE DATE
Yes Effective end date.
DFLT_FLAG VARCHAR2 (30) Yes Default Y or N.
PLIP_STAT_CD VARCHAR2 (30) Yes Plan in program status.
ALWS_UNRSTRCTD_ENRT_FLAG VARCHAR2 (30) Yes Allows Unrestricted Enrollment Y or N.
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
DRVBL_FCTR_APLS_RTS_FLAG VARCHAR2 (30) Yes Derivable factors apply to rates Y or N.
DRVBL_FCTR_PRTN_ELIG_FLAG VARCHAR2 (30) Yes Derivable factors for participation eligibility Y or N.
ELIG_APLS_FLAG VARCHAR2 (30) Yes Eligibility applies Y or N.
PRTN_ELIG_OVRID_ALWD_FLAG VARCHAR2 (30) Yes Participation Eligible Override Allowed Y or N.
TRK_INELIG_PER_FLAG VARCHAR2 (30) Yes Track Ineligible Person Y or N.
POSTELCN_EDIT_RL NUMBER (15)
Foreign key to FF_FORMULAS_F.
CPP_ATTRIBUTE_CATEGORY VARCHAR2 (30)
Descriptive Flexfield structure defining column.
CPP_ATTRIBUTE1 VARCHAR2 (150)
Descriptive Flexfield segment column.
CPP_ATTRIBUTE2 VARCHAR2 (150)
Descriptive Flexfield segment column.
CPP_ATTRIBUTE3 VARCHAR2 (150)
Descriptive Flexfield segment column.
CPP_ATTRIBUTE4 VARCHAR2 (150)
Descriptive Flexfield segment column.
CPP_ATTRIBUTE5 VARCHAR2 (150)
Descriptive Flexfield segment column.
CPP_ATTRIBUTE6 VARCHAR2 (150)
Descriptive Flexfield segment column.
CPP_ATTRIBUTE7 VARCHAR2 (150)
Descriptive Flexfield segment column.
CPP_ATTRIBUTE8 VARCHAR2 (150)
Descriptive Flexfield segment column.
CPP_ATTRIBUTE9 VARCHAR2 (150)
Descriptive Flexfield segment column.
CPP_ATTRIBUTE10 VARCHAR2 (150)
Descriptive Flexfield segment column.
CPP_ATTRIBUTE11 VARCHAR2 (150)
Descriptive Flexfield segment column.
CPP_ATTRIBUTE12 VARCHAR2 (150)
Descriptive Flexfield segment column.
CPP_ATTRIBUTE13 VARCHAR2 (150)
Descriptive Flexfield segment column.
CPP_ATTRIBUTE14 VARCHAR2 (150)
Descriptive Flexfield segment column.
CPP_ATTRIBUTE15 VARCHAR2 (150)
Descriptive Flexfield segment column.
CPP_ATTRIBUTE16 VARCHAR2 (150)
Descriptive Flexfield segment column.
CPP_ATTRIBUTE17 VARCHAR2 (150)
Descriptive Flexfield segment column.
CPP_ATTRIBUTE18 VARCHAR2 (150)
Descriptive Flexfield segment column.
CPP_ATTRIBUTE19 VARCHAR2 (150)
Descriptive Flexfield segment column.
CPP_ATTRIBUTE20 VARCHAR2 (150)
Descriptive Flexfield segment column.
CPP_ATTRIBUTE21 VARCHAR2 (150)
Descriptive Flexfield segment column.
CPP_ATTRIBUTE22 VARCHAR2 (150)
Descriptive Flexfield segment column.
CPP_ATTRIBUTE23 VARCHAR2 (150)
Descriptive Flexfield segment column.
CPP_ATTRIBUTE24 VARCHAR2 (150)
Descriptive Flexfield segment column.
CPP_ATTRIBUTE25 VARCHAR2 (150)
Descriptive Flexfield segment column.
CPP_ATTRIBUTE26 VARCHAR2 (150)
Descriptive Flexfield segment column.
CPP_ATTRIBUTE27 VARCHAR2 (150)
Descriptive Flexfield segment column.
CPP_ATTRIBUTE28 VARCHAR2 (150)
Descriptive Flexfield segment column.
CPP_ATTRIBUTE29 VARCHAR2 (150)
Descriptive Flexfield segment column.
CPP_ATTRIBUTE30 VARCHAR2 (150)
Descriptive Flexfield segment column.
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).
LAST_UPDATE_LOGIN NUMBER (15)
Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_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.
OBJECT_VERSION_NUMBER NUMBER (9)
System-generated primary key. Increments by one each update.
DFLT_ENRT_CD VARCHAR2 (30)
Default enrollment code.
ORDR_NUM NUMBER (15)
Order number.
IVR_IDENT VARCHAR2 (90)
Interactive Voice Response identifier.
ENRT_CD VARCHAR2 (30)
Enrollment code.
ENRT_MTHD_CD VARCHAR2 (30)
Enrollment method.
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_CD VARCHAR2 (30)
Enrollment coverage start date code.
ENRT_CVG_STRT_DT_RL NUMBER (15)
Foreign key to FF_FORMULAS_F.
ENRT_CVG_END_DT_CD VARCHAR2 (30)
Enrollment coverage end date code.
ENRT_CVG_END_DT_RL NUMBER (15)
Foreign key to FF_FORMULAS_F.
RT_STRT_DT_CD VARCHAR2 (30)
Rate start date code.
RT_STRT_DT_RL NUMBER (15)
Foreign key to FF_FORMULAS_F.
RT_END_DT_CD VARCHAR2 (30)
Rate end date code.
RT_END_DT_RL NUMBER (15)
Foreign key to FF_FORMULAS_F.
URL_REF_NAME VARCHAR2 (240)
URL reference name.
CVG_INCR_R_DECR_ONLY_CD VARCHAR2 (30)
Coverage increment or decrement only.
DFLT_TO_ASN_PNDG_CTFN_CD VARCHAR2 (30)
Default to assign pending notification code.
DFLT_TO_ASN_PNDG_CTFN_RL NUMBER (15)
Foreign key to FF_FORMULAS_F.
MN_CVG_AMT NUMBER

Minimum coverage amount.
MN_CVG_RL NUMBER (15)
Foreign key to FF_FORMULAS_F.
MX_CVG_ALWD_AMT NUMBER

Maximum coverage allowed 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.
NO_MN_CVG_AMT_APLS_FLAG VARCHAR2 (30)
No Minimum Coverage Amount Applies Y or N.
NO_MN_CVG_INCR_APLS_FLAG VARCHAR2 (30)
No Minimum Coverage Increase Applies Y or N.
NO_MX_CVG_AMT_APLS_FLAG VARCHAR2 (30)
No Maximum Coverage Amount Applies Y or N.
NO_MX_CVG_INCR_APLS_FLAG VARCHAR2 (30)
No Maximum Coverage Increase Applies Y or N.
UNSSPND_ENRT_CD VARCHAR2 (30)
Unsuspended enrollment code.
PRORT_PRTL_YR_CVG_RSTRN_CD VARCHAR2 (30)
Prorate partial year coverage restriction code.
PRORT_PRTL_YR_CVG_RSTRN_RL NUMBER (15)
Foreign key to FF_FORMULAS_F.
CMBN_PLIP_ID NUMBER (15)
Foreign key to BEN_CMBN_PLIP_F.
BNFT_OR_OPTION_RSTRCTN_CD VARCHAR2 (30)
Benefit or option restriction.
VRFY_FMLY_MMBR_CD VARCHAR2 (30)
Verify family member code
VRFY_FMLY_MMBR_RL NUMBER (15)
Foreign key to FF_FORMULAS_F.
PER_CVRD_CD VARCHAR2 (30)
Person covered code.
SHORT_CODE VARCHAR2 (30)
Short Code
SHORT_NAME VARCHAR2 (30)
short Name
LEGISLATION_CODE VARCHAR2 (30)
Foreign key to FND_TERRITORIES.
LEGISLATION_SUBGROUP VARCHAR2 (30)
Further Identifies the legislation startup data
USE_CSD_RSD_PRCCNG_CD VARCHAR2 (30)
User Coverage and/or Rate Start Date for Processing
Query Text

Cut, paste (and edit) the following text to query this object:


SELECT PLIP_ID
,      EFFECTIVE_START_DATE
,      EFFECTIVE_END_DATE
,      DFLT_FLAG
,      PLIP_STAT_CD
,      ALWS_UNRSTRCTD_ENRT_FLAG
,      PGM_ID
,      PL_ID
,      BUSINESS_GROUP_ID
,      DRVBL_FCTR_APLS_RTS_FLAG
,      DRVBL_FCTR_PRTN_ELIG_FLAG
,      ELIG_APLS_FLAG
,      PRTN_ELIG_OVRID_ALWD_FLAG
,      TRK_INELIG_PER_FLAG
,      POSTELCN_EDIT_RL
,      CPP_ATTRIBUTE_CATEGORY
,      CPP_ATTRIBUTE1
,      CPP_ATTRIBUTE2
,      CPP_ATTRIBUTE3
,      CPP_ATTRIBUTE4
,      CPP_ATTRIBUTE5
,      CPP_ATTRIBUTE6
,      CPP_ATTRIBUTE7
,      CPP_ATTRIBUTE8
,      CPP_ATTRIBUTE9
,      CPP_ATTRIBUTE10
,      CPP_ATTRIBUTE11
,      CPP_ATTRIBUTE12
,      CPP_ATTRIBUTE13
,      CPP_ATTRIBUTE14
,      CPP_ATTRIBUTE15
,      CPP_ATTRIBUTE16
,      CPP_ATTRIBUTE17
,      CPP_ATTRIBUTE18
,      CPP_ATTRIBUTE19
,      CPP_ATTRIBUTE20
,      CPP_ATTRIBUTE21
,      CPP_ATTRIBUTE22
,      CPP_ATTRIBUTE23
,      CPP_ATTRIBUTE24
,      CPP_ATTRIBUTE25
,      CPP_ATTRIBUTE26
,      CPP_ATTRIBUTE27
,      CPP_ATTRIBUTE28
,      CPP_ATTRIBUTE29
,      CPP_ATTRIBUTE30
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      CREATED_BY
,      CREATION_DATE
,      OBJECT_VERSION_NUMBER
,      DFLT_ENRT_CD
,      ORDR_NUM
,      IVR_IDENT
,      ENRT_CD
,      ENRT_MTHD_CD
,      DFLT_ENRT_DET_RL
,      AUTO_ENRT_MTHD_RL
,      ENRT_RL
,      ENRT_CVG_STRT_DT_CD
,      ENRT_CVG_STRT_DT_RL
,      ENRT_CVG_END_DT_CD
,      ENRT_CVG_END_DT_RL
,      RT_STRT_DT_CD
,      RT_STRT_DT_RL
,      RT_END_DT_CD
,      RT_END_DT_RL
,      URL_REF_NAME
,      CVG_INCR_R_DECR_ONLY_CD
,      DFLT_TO_ASN_PNDG_CTFN_CD
,      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
,      NO_MN_CVG_AMT_APLS_FLAG
,      NO_MN_CVG_INCR_APLS_FLAG
,      NO_MX_CVG_AMT_APLS_FLAG
,      NO_MX_CVG_INCR_APLS_FLAG
,      UNSSPND_ENRT_CD
,      PRORT_PRTL_YR_CVG_RSTRN_CD
,      PRORT_PRTL_YR_CVG_RSTRN_RL
,      CMBN_PLIP_ID
,      BNFT_OR_OPTION_RSTRCTN_CD
,      VRFY_FMLY_MMBR_CD
,      VRFY_FMLY_MMBR_RL
,      PER_CVRD_CD
,      SHORT_CODE
,      SHORT_NAME
,      LEGISLATION_CODE
,      LEGISLATION_SUBGROUP
,      USE_CSD_RSD_PRCCNG_CD
FROM BEN.BEN_PLIP_F;

Dependencies

[top of page]

BEN.BEN_PLIP_F does not reference any database object

BEN.BEN_PLIP_F is referenced by following:

SchemaAPPS
SynonymBEN_PLIP_F
TriggerBEN_PLIP_F_WHO