[Home] [Help] [Dependency Information]
Object Name: | BEN_PL_F |
---|---|
Object Type: | TABLE |
Owner: | BEN |
FND Design Data: | BEN.BEN_PL_F |
Subobject Name: | |
Status: | VALID |
BEN_PL_F identifies a discrete and formally defined compensation offering which is categorized by only one plan type, has one or more activity base rates, shares a known set of eligibility criteria and when applicable, has a fixed set of provided option. For health and welfare benefits, a plan is provided by a third-party administrator or carrier.
Plan has a number of columns which are prefixed with "NIP," indicating not in program, such columns are used only when the plan is not incorporated into a program,all the remaining attributes apply to the characteristics of the plan either independent of any program affinity or in the context of the program.
Examples are Acme Be Well HMO,Acme Stock Purchase Plan, Acme HQ Employee Savings Plan.
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
BEN_PL_F_PK | NORMAL | UNIQUE | APPS_TS_TX_IDX |
PL_ID
EFFECTIVE_START_DATE EFFECTIVE_END_DATE |
BEN_PL_F_FK3 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | BUSINESS_GROUP_ID |
BEN_PL_F_FK4 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | GROUP_PL_ID |
BEN_PL_F_N10 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | PRORT_PRTL_YR_CVG_RSTRN_RL |
BEN_PL_F_N11 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | DFLT_TO_ASN_PNDG_CTFN_RL |
BEN_PL_F_N12 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | MX_WTG_DT_TO_USE_RL |
BEN_PL_F_N15 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | BNFT_PRVDR_POOL_ID |
BEN_PL_F_N16 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | CR_DSTR_BNFT_PRVDR_POOL_ID |
BEN_PL_F_N17 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | ACTL_PREM_ID |
BEN_PL_F_N18 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | PL_TYP_ID |
BEN_PL_F_N19 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX |
MAPPING_TABLE_PK_ID
MAPPING_TABLE_NAME |
BEN_PL_F_N2 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | AUTO_ENRT_MTHD_RL |
BEN_PL_F_N20 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | NAME |
BEN_PL_F_N3 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | MN_CVG_RL |
BEN_PL_F_N4 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | MX_CVG_RL |
BEN_PL_F_N5 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | NIP_DFLT_ENRT_DET_RL |
BEN_PL_F_N6 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | DPNT_CVG_END_DT_RL |
BEN_PL_F_N7 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | DPNT_CVG_STRT_DT_RL |
BEN_PL_F_N8 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | ENRT_CVG_END_DT_RL |
BEN_PL_F_N9 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | ENRT_CVG_STRT_DT_RL |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
PL_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. | |
NAME | VARCHAR2 | (240) | Yes | Name of the plan. |
DRVBL_DPNT_ELIG_FLAG | VARCHAR2 | (30) | Yes | Derivable dependant eligiblility flag Y or N. |
DRVBL_FCTR_PRTN_ELIG_FLAG | VARCHAR2 | (30) | Yes | Derivable factors for participation eligibility Y or N. |
DPNT_NO_CTFN_RQD_FLAG | VARCHAR2 | (30) | Yes | Dependent no certification required Y or N. |
MAY_ENRL_PL_N_OIPL_FLAG | VARCHAR2 | (30) | Yes | May Enroll Plan And Option in Plan Y or N. |
DPNT_CVD_BY_OTHR_APLS_FLAG | VARCHAR2 | (30) | Yes | Dependent covered by other plan Y or N. |
DPNT_ADRS_RQD_FLAG | VARCHAR2 | (30) | Yes | Dependent address required Y or N. |
DPNT_LEG_ID_RQD_FLAG | VARCHAR2 | (30) | Yes | Dependent Legislative Identifier required Y or N. |
DPNT_DOB_RQD_FLAG | VARCHAR2 | (30) | Yes | Dependent date of birth required Y or N. |
DRVBL_FCTR_APLS_RTS_FLAG | VARCHAR2 | (30) | Yes | Derivable factors apply to rates Y or N. |
ELIG_APLS_FLAG | VARCHAR2 | (30) | Yes | Eligibility applies Y or N. |
NO_MX_OPTS_NUM_APLS_FLAG | VARCHAR2 | (30) | Yes | No Maximum Options Number Applies Y or N. |
ALWS_QDRO_FLAG | VARCHAR2 | (30) | Yes | Allows QDRO Y or N. |
ALWS_QMCSO_FLAG | VARCHAR2 | (30) | Yes | Allows QMSCO Y or N. |
HGHLY_CMPD_RL_APLS_FLAG | VARCHAR2 | (30) | Yes | Highly Compensated Rule Applies Y or N. |
ENRT_PL_OPT_FLAG | VARCHAR2 | (30) | Yes | Enrollment Plan Option Y or N. |
FRFS_APLY_FLAG | VARCHAR2 | (30) | Yes | Forfeitures Apply Y or N. |
SVGS_PL_FLAG | VARCHAR2 | (30) | Yes | Savings Plan Y or N. |
TRK_INELIG_PER_FLAG | VARCHAR2 | (30) | Yes | Track Ineligible Person Y or N. |
USE_ALL_ASNTS_ELIG_FLAG | VARCHAR2 | (30) | Yes | Use All Assignments Eligible Y or N. |
USE_ALL_ASNTS_FOR_RT_FLAG | VARCHAR2 | (30) | Yes | Use All Assignments For Rate Y or N. |
VSTG_APLS_FLAG | VARCHAR2 | (30) | Yes | Vesting Applies Y or N. |
PRTN_ELIG_OVRID_ALWD_FLAG | VARCHAR2 | (30) | Yes | Participation Eligible Override Allowed Y or N. |
HC_PL_SUBJ_HCFA_APRVL_FLAG | VARCHAR2 | (30) | Yes | Health care plan subject to health care finance administration approval Y or N. |
WVBL_FLAG | VARCHAR2 | (30) | Yes | Waivable Y or N. |
INVK_FLX_CR_PL_FLAG | VARCHAR2 | (30) | Yes | Invoke Flexible Credit Plan Y or N. |
INVK_DCLN_PRTN_PL_FLAG | VARCHAR2 | (30) | Yes | Invoke Decline Participation Plan Y or N. |
ALWS_REIMBMTS_FLAG | VARCHAR2 | (30) | Yes | Allows reimbursements Y or N. |
ALWS_UNRSTRCTD_ENRT_FLAG | VARCHAR2 | (30) | Yes | Allows Unrestricted Enrollment Y or N. |
BNF_ADDL_INSTN_TXT_ALWD_FLAG | VARCHAR2 | (30) | Yes | Beneficiary additional instruction text allowed Y or N. |
BNF_ADRS_RQD_FLAG | VARCHAR2 | (30) | Yes | Benficiary Address Required Y or N. |
BNF_CTFN_RQD_FLAG | VARCHAR2 | (30) | Yes | Beneficiary certification required Y or N. |
BNF_CNTNGT_BNFS_ALWD_FLAG | VARCHAR2 | (30) | Yes | Beneficiary continuing benefits Allowed Y or N. |
BNF_LEGV_ID_RQD_FLAG | VARCHAR2 | (30) | Yes | Beneficiary legislative identifier required Y or N. |
BNF_MAY_DSGT_ORG_FLAG | VARCHAR2 | (30) | Yes | Beneficiary may designate organization Y or N. |
BNF_QDRO_RL_APLS_FLAG | VARCHAR2 | (30) | Yes | Benficiary QDRO rule applies Y or N. |
BNF_DSGE_MNR_TTEE_RQD_FLAG | VARCHAR2 | (30) | Yes | Beneficiary designee minor,trustee required Y or N. |
NO_MN_CVG_AMT_APLS_FLAG | VARCHAR2 | (30) | Yes | No Minimum Coverage Amount Applies Y or N. |
NO_MX_CVG_AMT_APLS_FLAG | VARCHAR2 | (30) | Yes | No Maximum Coverage Amount Applies Y or N. |
NO_MN_CVG_INCR_APLS_FLAG | VARCHAR2 | (30) | Yes | No Minimum Coverage Increase Applies Y or N. |
NO_MX_CVG_INCR_APLS_FLAG | VARCHAR2 | (30) | Yes | No Maximum Coverage Increase Applies Y or N. |
NO_MN_OPTS_NUM_APLS_FLAG | VARCHAR2 | (30) | Yes | No Minimum Options Number Applies Y or N. |
BNF_DOB_RQD_FLAG | VARCHAR2 | (30) | Yes | Beneficiary date of birth required Y or N. |
PL_CD | VARCHAR2 | (30) | Yes | Plan usage. |
PL_TYP_ID | NUMBER | (15) | Yes | Foreign key to BEN_PL_TYP_F. |
BUSINESS_GROUP_ID | NUMBER | (15) | Foreign Key to HR_ORGANIZATION_UNITS | |
ORDR_NUM | NUMBER | (15) | Order number. | |
CVG_INCR_R_DECR_ONLY_CD | VARCHAR2 | (30) | Coverage increment or decrement only. | |
MX_CVG_WCFN_AMT | NUMBER | Maximum coverage with certification amount. | ||
MX_CVG_WCFN_MLT_NUM | NUMBER | (15) | Maximum coverage with certification multiple number. | |
MN_CVG_ALWD_AMT | NUMBER | Minimum coverage allowed amount. | ||
PRORT_PRTL_YR_CVG_RSTRN_RL | NUMBER | (15) | Foreign key to FF_FORMULAS_F. | |
MN_OPTS_RQD_NUM | NUMBER | (15) | Minimum number of required options. | |
MX_OPTS_ALWD_NUM | NUMBER | (15) | Maximum number of options allowed. | |
MX_WTG_PERD_PRTE_VAL | NUMBER | (15) | Maximum waiting period to participate value. | |
MX_CVG_INCR_ALWD_AMT | NUMBER | Maximum coverage increase allowed amount. | ||
MX_CVG_MLT_INCR_NUM | NUMBER | (15) | Maximum coverage multiple increase number. | |
DFLT_TO_ASN_PNDG_CTFN_RL | NUMBER | (15) | Foreign key to FF_FORMULAS_F. | |
MX_CVG_INCR_WCF_ALWD_AMT | NUMBER | Maximum coverage increase with certification allowed amount. | ||
MX_CVG_MLT_INCR_WCF_NUM | NUMBER | (15) | Maximum coverage multiple increase with certification number. | |
MX_CVG_ALWD_AMT | NUMBER | Maximum coverage allowed amount. | ||
MN_CVG_RQD_AMT | NUMBER | Minimum required coverage amount. | ||
ENRT_RL | NUMBER | (15) | Foreign key to FF_FORMULAS_F. | |
MX_WTG_DT_TO_USE_RL | NUMBER | (15) | Foreign key to FF_FORMULAS_F. | |
RQD_PERD_ENRT_NENRT_UOM | VARCHAR2 | (30) | Required period of enrollment unit of measure. | |
RQD_PERD_ENRT_NENRT_VAL | NUMBER | Required period of enrollment value. | ||
RQD_PERD_ENRT_NENRT_RL | NUMBER | (15) | Foreign key to FF_FORMULAS_F. | |
SUBJ_TO_IMPTD_INCM_CD | VARCHAR2 | (30) | No longer used. | |
SUBJ_TO_IMPTD_INCM_TYP_CD | VARCHAR2 | (30) | Subject to imputed income type. | |
URL_REF_NAME | VARCHAR2 | (240) | URL reference name. | |
UNSSPND_ENRT_CD | VARCHAR2 | (30) | Unsuspended enrollment code. | |
INCPTN_DT | DATE | Inception date. | ||
IMPTD_INCM_CALC_CD | VARCHAR2 | (30) | No longer used. | |
BNF_INCRMT_AMT | NUMBER | Beneficiary increment amount. | ||
BNF_MN_DSGNTBL_AMT | NUMBER | Beneficiary minimum designatable amount. | ||
BNF_MN_DSGNTBL_PCT_VAL | NUMBER | (15) | Beneficiary minimum designatable percentage. | |
BNF_PCT_INCRMT_VAL | NUMBER | (15) | Beneficiary increment percent. | |
IVR_IDENT | VARCHAR2 | (90) | Interactive Voice Response identifier. | |
RT_END_DT_CD | VARCHAR2 | (30) | Rate end date code. | |
RT_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. | |
POSTELCN_EDIT_RL | NUMBER | (15) | Foreign key to FF_FORMULAS_F. | |
PER_CVRD_CD | VARCHAR2 | (30) | Person covered code. | |
BNFT_OR_OPTION_RSTRCTN_CD | VARCHAR2 | (30) | Benefit or option restriction. | |
PLN_MN_CVG_ALWD_AMT | NUMBER | (15) | Plan minimum coverage allowed amount. | |
PCP_CD | VARCHAR2 | (30) | No longer used. | |
AUTO_ENRT_MTHD_RL | NUMBER | (15) | Foreign key to FF_FORMULAS_F. | |
MX_WTG_PERD_RL | NUMBER | (15) | Foreign key to FF_FORMULAS_F. | |
MN_CVG_RL | NUMBER | (15) | Foreign key to FF_FORMULAS_F. | |
MX_CVG_RL | NUMBER | (15) | Foreign key to FF_FORMULAS_F. | |
MX_WTG_PERD_PRTE_UOM | VARCHAR2 | (30) | Maximum waiting period to participate unit of measure. | |
MX_WTG_DT_TO_USE_CD | VARCHAR2 | (30) | Maximum waiting period date to use code. | |
NIP_PL_UOM | VARCHAR2 | (30) | Not in program plan unit of measure. | |
BNF_DFLT_BNF_CD | VARCHAR2 | (30) | Default beneficiary. | |
BNF_PCT_AMT_ALWD_CD | VARCHAR2 | (30) | Beneficiary percentage amount allowed. | |
CMPR_CLMS_TO_CVG_OR_BAL_CD | VARCHAR2 | (30) | Compare claims to coverage or balance. | |
COBRA_PYMT_DUE_DY_NUM | NUMBER | (15) | Cobra payment due day. | |
DPNT_CVG_END_DT_CD | VARCHAR2 | (30) | Dependent coverage end date code. | |
DPNT_CVG_STRT_DT_CD | VARCHAR2 | (30) | Dependent coverage start date code. | |
NIP_DFLT_ENRT_DET_RL | NUMBER | (15) | Foreign key to FF_FORMULAS_F. | |
DPNT_DSGN_CD | VARCHAR2 | (30) | Dependent designation code. | |
NIP_DFLT_ENRT_CD | VARCHAR2 | (30) | Not in program default enrollment code. | |
BNF_DSGN_CD | VARCHAR2 | (30) | Beneficiary designation. | |
PRMRY_FNDG_MTHD_CD | VARCHAR2 | (30) | Primary funding method. | |
DFLT_TO_ASN_PNDG_CTFN_CD | VARCHAR2 | (30) | Default to assign pending notification code. | |
ENRT_MTHD_CD | VARCHAR2 | (30) | Enrollment method. | |
HC_SVC_TYP_CD | VARCHAR2 | (30) | Healthcare service type. | |
DPNT_CVG_END_DT_RL | NUMBER | (15) | Foreign key to FF_FORMULAS_F. | |
NIP_ACTY_REF_PERD_CD | VARCHAR2 | (30) | Not in program activity reference period. | |
ENRT_CD | VARCHAR2 | (30) | Enrollment code. | |
PRORT_PRTL_YR_CVG_RSTRN_CD | VARCHAR2 | (30) | Prorate partial year coverage restriction code. | |
PL_STAT_CD | VARCHAR2 | (30) | Plan status. | |
ENRT_CVG_STRT_DT_CD | VARCHAR2 | (30) | Enrollment coverage start date code. | |
ENRT_CVG_END_DT_CD | VARCHAR2 | (30) | Enrollment coverage end date code. | |
NIP_ENRT_INFO_RT_FREQ_CD | VARCHAR2 | (30) | Not in program enrollment information rate frequency. | |
DPNT_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. | |
ENRT_CVG_STRT_DT_RL | NUMBER | (15) | Foreign key to FF_FORMULAS_F. | |
ACTL_PREM_ID | NUMBER | (15) | Foreign Key to BEN_ACTL_PREM_F. | |
BNFT_PRVDR_POOL_ID | NUMBER | (15) | Foreign key to BEN_BNFT_PRVDR_POOL_F. | |
CR_DSTR_BNFT_PRVDR_POOL_ID | NUMBER | (15) | Foreign key to BEN_CR_DSTR_BNFT_PRVDR_POOL_F. | |
PLN_ATTRIBUTE_CATEGORY | VARCHAR2 | (30) | Descriptive Flexfield structure defining column. | |
PLN_ATTRIBUTE1 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
PLN_ATTRIBUTE2 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
PLN_ATTRIBUTE3 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
PLN_ATTRIBUTE4 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
PLN_ATTRIBUTE5 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
PLN_ATTRIBUTE6 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
PLN_ATTRIBUTE7 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
PLN_ATTRIBUTE8 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
PLN_ATTRIBUTE9 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
PLN_ATTRIBUTE10 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
PLN_ATTRIBUTE11 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
PLN_ATTRIBUTE12 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
PLN_ATTRIBUTE13 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
PLN_ATTRIBUTE14 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
PLN_ATTRIBUTE15 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
PLN_ATTRIBUTE16 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
PLN_ATTRIBUTE17 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
PLN_ATTRIBUTE18 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
PLN_ATTRIBUTE19 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
PLN_ATTRIBUTE20 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
PLN_ATTRIBUTE21 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
PLN_ATTRIBUTE22 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
PLN_ATTRIBUTE23 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
PLN_ATTRIBUTE24 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
PLN_ATTRIBUTE25 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
PLN_ATTRIBUTE26 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
PLN_ATTRIBUTE27 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
PLN_ATTRIBUTE28 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
PLN_ATTRIBUTE29 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
PLN_ATTRIBUTE30 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
OBJECT_VERSION_NUMBER | NUMBER | (9) | System-generated primary key. Increments by one each update. | |
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. | ||
VRFY_FMLY_MMBR_CD | VARCHAR2 | (30) | Verify family member code | |
VRFY_FMLY_MMBR_RL | NUMBER | (15) | Foreign key to FF_FORMULAS_F. | |
ALWS_TMPRY_ID_CRD_FLAG | VARCHAR2 | (30) | Yes | Allows Temporary ID Card Y or N. |
NIP_DFLT_FLAG | VARCHAR2 | (30) | Yes | Not in Plan Default Flag Y or N. |
FRFS_DISTR_MTHD_CD | VARCHAR2 | (30) | Forfeiture distribution method code | |
FRFS_DISTR_MTHD_RL | NUMBER | (15) | Foreign key to FF_FORMULAS_F. | |
FRFS_CNTR_DET_CD | VARCHAR2 | (30) | Forfeitures contribution determination code. | |
FRFS_DISTR_DET_CD | VARCHAR2 | (30) | Forfeitures distribution determination code. | |
COST_ALLOC_KEYFLEX_1_ID | NUMBER | (15) | Foreign Key to PAY_COST_ALLOCATION_KEYFLEX. | |
COST_ALLOC_KEYFLEX_2_ID | NUMBER | (15) | Foreign Key to PAY_COST_ALLOCATION_KEYFLEX. | |
POST_TO_GL_FLAG | VARCHAR2 | (30) | Yes | Post to General Ledger Flag. |
FRFS_VAL_DET_CD | VARCHAR2 | (30) | Forfeiure value detemination code. | |
FRFS_MX_CRYFWD_VAL | NUMBER | Maximum forfeiture carry-forward value. | ||
FRFS_PORTION_DET_CD | VARCHAR2 | (30) | Forfeiture portion deteermination code. | |
BNDRY_PERD_CD | VARCHAR2 | (30) | Boundary period code. | |
SHORT_CODE | VARCHAR2 | (30) | Short Code | |
SHORT_NAME | VARCHAR2 | (30) | short Name | |
FUNCTION_CODE | VARCHAR2 | (30) | Function Code | |
MAPPING_TABLE_NAME | VARCHAR2 | (60) | Mapping table Name | |
MAPPING_TABLE_PK_ID | NUMBER | Mapping table primary key id | ||
PL_YR_NOT_APPLCBL_FLAG | VARCHAR2 | (30) | Yes | Plan year periods not applicable flag |
LEGISLATION_CODE | VARCHAR2 | (30) | Foreign key to FND_TERRITORIES. | |
LEGISLATION_SUBGROUP | VARCHAR2 | (30) | Further identifies the legislation of startup data. | |
GROUP_PL_ID | NUMBER | (15) | Group plan id. | |
USE_CSD_RSD_PRCCNG_CD | VARCHAR2 | (30) | User Coverage and/or Rate Start Date for Processing | |
SUSP_IF_CTFN_NOT_PRVD_FLAG | VARCHAR2 | (30) | Yes | Suspend Enrollment if Certification not provided |
CTFN_DETERMINE_CD | VARCHAR2 | (30) | Certification Determination code | |
SUSP_IF_DPNT_SSN_NT_PRV_CD | VARCHAR2 | (30) | Suspend if Dependent SSN Not Provided | |
SUSP_IF_DPNT_DOB_NT_PRV_CD | VARCHAR2 | (30) | Suspend if Dependent Date of Birth Not Provided | |
SUSP_IF_DPNT_ADR_NT_PRV_CD | VARCHAR2 | (30) | Suspend if Dependent Address Not Provided | |
SUSP_IF_CTFN_NOT_DPNT_FLAG | VARCHAR2 | (30) | Yes | Suspend Enrollment if Certification for Dependent |
SUSP_IF_BNF_SSN_NT_PRV_CD | VARCHAR2 | (30) | Suspend if Beneficiary SSN Not Provided | |
SUSP_IF_BNF_DOB_NT_PRV_CD | VARCHAR2 | (30) | Suspend if Beneficiary Date of Birth Not Provided | |
SUSP_IF_BNF_ADR_NT_PRV_CD | VARCHAR2 | (30) | Suspend if Beneficiary Address Not Provided | |
SUSP_IF_CTFN_NOT_BNF_FLAG | VARCHAR2 | (30) | Yes | Suspend Enrollment if Certification for Dependent |
DPNT_CTFN_DETERMINE_CD | VARCHAR2 | (30) | Dependent Certification Determination code | |
BNF_CTFN_DETERMINE_CD | VARCHAR2 | (30) | Dependent Certification Determination code |
Cut, paste (and edit) the following text to query this object:
SELECT PL_ID
, EFFECTIVE_START_DATE
, EFFECTIVE_END_DATE
, NAME
, DRVBL_DPNT_ELIG_FLAG
, DRVBL_FCTR_PRTN_ELIG_FLAG
, DPNT_NO_CTFN_RQD_FLAG
, MAY_ENRL_PL_N_OIPL_FLAG
, DPNT_CVD_BY_OTHR_APLS_FLAG
, DPNT_ADRS_RQD_FLAG
, DPNT_LEG_ID_RQD_FLAG
, DPNT_DOB_RQD_FLAG
, DRVBL_FCTR_APLS_RTS_FLAG
, ELIG_APLS_FLAG
, NO_MX_OPTS_NUM_APLS_FLAG
, ALWS_QDRO_FLAG
, ALWS_QMCSO_FLAG
, HGHLY_CMPD_RL_APLS_FLAG
, ENRT_PL_OPT_FLAG
, FRFS_APLY_FLAG
, SVGS_PL_FLAG
, TRK_INELIG_PER_FLAG
, USE_ALL_ASNTS_ELIG_FLAG
, USE_ALL_ASNTS_FOR_RT_FLAG
, VSTG_APLS_FLAG
, PRTN_ELIG_OVRID_ALWD_FLAG
, HC_PL_SUBJ_HCFA_APRVL_FLAG
, WVBL_FLAG
, INVK_FLX_CR_PL_FLAG
, INVK_DCLN_PRTN_PL_FLAG
, ALWS_REIMBMTS_FLAG
, ALWS_UNRSTRCTD_ENRT_FLAG
, BNF_ADDL_INSTN_TXT_ALWD_FLAG
, BNF_ADRS_RQD_FLAG
, BNF_CTFN_RQD_FLAG
, BNF_CNTNGT_BNFS_ALWD_FLAG
, BNF_LEGV_ID_RQD_FLAG
, BNF_MAY_DSGT_ORG_FLAG
, BNF_QDRO_RL_APLS_FLAG
, BNF_DSGE_MNR_TTEE_RQD_FLAG
, NO_MN_CVG_AMT_APLS_FLAG
, NO_MX_CVG_AMT_APLS_FLAG
, NO_MN_CVG_INCR_APLS_FLAG
, NO_MX_CVG_INCR_APLS_FLAG
, NO_MN_OPTS_NUM_APLS_FLAG
, BNF_DOB_RQD_FLAG
, PL_CD
, PL_TYP_ID
, BUSINESS_GROUP_ID
, ORDR_NUM
, CVG_INCR_R_DECR_ONLY_CD
, MX_CVG_WCFN_AMT
, MX_CVG_WCFN_MLT_NUM
, MN_CVG_ALWD_AMT
, PRORT_PRTL_YR_CVG_RSTRN_RL
, MN_OPTS_RQD_NUM
, MX_OPTS_ALWD_NUM
, MX_WTG_PERD_PRTE_VAL
, MX_CVG_INCR_ALWD_AMT
, MX_CVG_MLT_INCR_NUM
, DFLT_TO_ASN_PNDG_CTFN_RL
, MX_CVG_INCR_WCF_ALWD_AMT
, MX_CVG_MLT_INCR_WCF_NUM
, MX_CVG_ALWD_AMT
, MN_CVG_RQD_AMT
, ENRT_RL
, MX_WTG_DT_TO_USE_RL
, RQD_PERD_ENRT_NENRT_UOM
, RQD_PERD_ENRT_NENRT_VAL
, RQD_PERD_ENRT_NENRT_RL
, SUBJ_TO_IMPTD_INCM_CD
, SUBJ_TO_IMPTD_INCM_TYP_CD
, URL_REF_NAME
, UNSSPND_ENRT_CD
, INCPTN_DT
, IMPTD_INCM_CALC_CD
, BNF_INCRMT_AMT
, BNF_MN_DSGNTBL_AMT
, BNF_MN_DSGNTBL_PCT_VAL
, BNF_PCT_INCRMT_VAL
, IVR_IDENT
, RT_END_DT_CD
, RT_END_DT_RL
, RT_STRT_DT_CD
, RT_STRT_DT_RL
, POSTELCN_EDIT_RL
, PER_CVRD_CD
, BNFT_OR_OPTION_RSTRCTN_CD
, PLN_MN_CVG_ALWD_AMT
, PCP_CD
, AUTO_ENRT_MTHD_RL
, MX_WTG_PERD_RL
, MN_CVG_RL
, MX_CVG_RL
, MX_WTG_PERD_PRTE_UOM
, MX_WTG_DT_TO_USE_CD
, NIP_PL_UOM
, BNF_DFLT_BNF_CD
, BNF_PCT_AMT_ALWD_CD
, CMPR_CLMS_TO_CVG_OR_BAL_CD
, COBRA_PYMT_DUE_DY_NUM
, DPNT_CVG_END_DT_CD
, DPNT_CVG_STRT_DT_CD
, NIP_DFLT_ENRT_DET_RL
, DPNT_DSGN_CD
, NIP_DFLT_ENRT_CD
, BNF_DSGN_CD
, PRMRY_FNDG_MTHD_CD
, DFLT_TO_ASN_PNDG_CTFN_CD
, ENRT_MTHD_CD
, HC_SVC_TYP_CD
, DPNT_CVG_END_DT_RL
, NIP_ACTY_REF_PERD_CD
, ENRT_CD
, PRORT_PRTL_YR_CVG_RSTRN_CD
, PL_STAT_CD
, ENRT_CVG_STRT_DT_CD
, ENRT_CVG_END_DT_CD
, NIP_ENRT_INFO_RT_FREQ_CD
, DPNT_CVG_STRT_DT_RL
, ENRT_CVG_END_DT_RL
, ENRT_CVG_STRT_DT_RL
, ACTL_PREM_ID
, BNFT_PRVDR_POOL_ID
, CR_DSTR_BNFT_PRVDR_POOL_ID
, PLN_ATTRIBUTE_CATEGORY
, PLN_ATTRIBUTE1
, PLN_ATTRIBUTE2
, PLN_ATTRIBUTE3
, PLN_ATTRIBUTE4
, PLN_ATTRIBUTE5
, PLN_ATTRIBUTE6
, PLN_ATTRIBUTE7
, PLN_ATTRIBUTE8
, PLN_ATTRIBUTE9
, PLN_ATTRIBUTE10
, PLN_ATTRIBUTE11
, PLN_ATTRIBUTE12
, PLN_ATTRIBUTE13
, PLN_ATTRIBUTE14
, PLN_ATTRIBUTE15
, PLN_ATTRIBUTE16
, PLN_ATTRIBUTE17
, PLN_ATTRIBUTE18
, PLN_ATTRIBUTE19
, PLN_ATTRIBUTE20
, PLN_ATTRIBUTE21
, PLN_ATTRIBUTE22
, PLN_ATTRIBUTE23
, PLN_ATTRIBUTE24
, PLN_ATTRIBUTE25
, PLN_ATTRIBUTE26
, PLN_ATTRIBUTE27
, PLN_ATTRIBUTE28
, PLN_ATTRIBUTE29
, PLN_ATTRIBUTE30
, OBJECT_VERSION_NUMBER
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_LOGIN
, CREATED_BY
, CREATION_DATE
, VRFY_FMLY_MMBR_CD
, VRFY_FMLY_MMBR_RL
, ALWS_TMPRY_ID_CRD_FLAG
, NIP_DFLT_FLAG
, FRFS_DISTR_MTHD_CD
, FRFS_DISTR_MTHD_RL
, FRFS_CNTR_DET_CD
, FRFS_DISTR_DET_CD
, COST_ALLOC_KEYFLEX_1_ID
, COST_ALLOC_KEYFLEX_2_ID
, POST_TO_GL_FLAG
, FRFS_VAL_DET_CD
, FRFS_MX_CRYFWD_VAL
, FRFS_PORTION_DET_CD
, BNDRY_PERD_CD
, SHORT_CODE
, SHORT_NAME
, FUNCTION_CODE
, MAPPING_TABLE_NAME
, MAPPING_TABLE_PK_ID
, PL_YR_NOT_APPLCBL_FLAG
, LEGISLATION_CODE
, LEGISLATION_SUBGROUP
, GROUP_PL_ID
, USE_CSD_RSD_PRCCNG_CD
, SUSP_IF_CTFN_NOT_PRVD_FLAG
, CTFN_DETERMINE_CD
, SUSP_IF_DPNT_SSN_NT_PRV_CD
, SUSP_IF_DPNT_DOB_NT_PRV_CD
, SUSP_IF_DPNT_ADR_NT_PRV_CD
, SUSP_IF_CTFN_NOT_DPNT_FLAG
, SUSP_IF_BNF_SSN_NT_PRV_CD
, SUSP_IF_BNF_DOB_NT_PRV_CD
, SUSP_IF_BNF_ADR_NT_PRV_CD
, SUSP_IF_CTFN_NOT_BNF_FLAG
, DPNT_CTFN_DETERMINE_CD
, BNF_CTFN_DETERMINE_CD
FROM BEN.BEN_PL_F;
BEN.BEN_PL_F does not reference any database object
BEN.BEN_PL_F is referenced by following:
|
|
|