[Home] [Help] [Dependency Information]
Object Name: | BEN_ENRT_MISC_LOV_INFO_LE_V |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | BEN.BEN_ENRT_MISC_LOV_INFO_LE_V |
Subobject Name: | |
Status: | VALID |
A supplementary view used to simplify forms coding.
Warning: Oracle does not recommend you query or alter datausing this view. It may change dramatically in subsequent minor or major
releases.
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
PL_TYP_ID | NUMBER | (15) | Plan Type Id | |
PL_TYP_ID_NAME | VARCHAR2 | (240) | Yes | Plan Type Name |
PL_ID | NUMBER | (15) | Plan Id | |
PL_ID_NAME | VARCHAR2 | (240) | Yes | Plan Name |
OPT_ID | NUMBER | (15) | Option Id | |
OPT_NAME | VARCHAR2 | (240) | Option Name | |
OIPL_ID | NUMBER | (15) | Oipl Id | |
BNFT_VAL | NUMBER | Benefit Amount | ||
BNFT_NNMNTRY_UOM | VARCHAR2 | (30) | Unit of Measure | |
INCRMT_VAL | NUMBER | Increment Value | ||
BNFT_TYP_CD | VARCHAR2 | (30) | Benefit Type Code | |
CVG_MLT_CD | VARCHAR2 | (30) | Coverage Multiplier Code | |
ENTR_VAL_AT_ENRT_FLAG | VARCHAR2 | (30) | Enter Benefit Amount at Enrollment | |
ENRT_CVG_STRT_DT_CD | VARCHAR2 | (30) | Coverage Start Code | |
CRNTLY_ENRD_FLAG | VARCHAR2 | (30) | Yes | Currently enrolled Flag |
BUSINESS_GROUP_ID | NUMBER | (15) | Yes | Business Group Id |
MNDTRY_FLAG | VARCHAR2 | (30) | Yes | Mandatory Flag |
DFLT_FLAG | VARCHAR2 | (30) | Yes | Default Flag |
ELIG_PER_ELCTBL_CHC_ID | NUMBER | (15) | Yes | Foreign key to ben_elig_per_elctbl_chc |
PER_IN_LER_ID | NUMBER | (15) | Yes | Foriegn key to ben_per_in_ler |
LF_EVT_OCRD_DT | DATE | Yes | Life Event Occured Date | |
CHOICE_OVN | NUMBER | (9) | EPE Object version number | |
PRTT_ENRT_RSLT_ID | NUMBER | (15) | EPE Result Id | |
ENRT_BNFT_ID | NUMBER | (15) | Benefit Id | |
ENRT_CVG_STRT_DT | DATE | EPE Coverage Start Date | ||
ERLST_DEENRT_DT | DATE | Earliest Deenrollement Date | ||
PERSON_ID | NUMBER | (15) | Yes | Person Id |
CTFN_RQD_FLAG | VARCHAR2 | (30) | Cerification Required Flag | |
UOM | VARCHAR2 | (30) | Unit Of Measure | |
ACTY_REF_PERD_CD | VARCHAR2 | (30) | Activity Reference Period | |
CLS_ENRT_DT_TO_USE_CD | VARCHAR2 | (30) | Close Enrollment Date To Use Code | |
PL_ORDR_NUM | NUMBER | (15) | Sequence Number of the Plan | |
PLIP_ORDR_NUM | NUMBER | (15) | Sequence Number of the Plan in Program | |
PTIP_ORDR_NUM | NUMBER | (15) | Sequence Number of the Plan Type in Program | |
OIPL_ORDR_NUM | NUMBER | (15) | Sequence Number of the Option in Plan | |
PEN_PRTT_ENRT_RSLT_ID | NUMBER | (15) | PEN Result Id | |
PEN_ENRT_CVG_STRT_DT | DATE | PEN Coverage Start Date | ||
PEN_ENRT_CVG_THRU_DT | DATE | PEN Coverage End Date | ||
PEN_ENRT_SSPNDD_FLAG | VARCHAR2 | (30) | Suspended Flag | |
PEN_RPLCS_SSPNDD_RSLT_ID | NUMBER | (15) | Suspended Result Id | |
MN_VAL | NUMBER | Min Benefit Amount | ||
MX_VAL | NUMBER | Max Benefit Amount | ||
MX_WOUT_CTFN_VAL | NUMBER | Max Amount without Certification | ||
IN_PNDG_WKFLOW_FLAG_MEANING | VARCHAR2 | (1) | Workflow usage | |
IN_PNDG_WKFLOW_FLAG | VARCHAR2 | (30) | Workflow usage |
Cut, paste (and edit) the following text to query this object:
SELECT PL_TYP_ID
, PL_TYP_ID_NAME
, PL_ID
, PL_ID_NAME
, OPT_ID
, OPT_NAME
, OIPL_ID
, BNFT_VAL
, BNFT_NNMNTRY_UOM
, INCRMT_VAL
, BNFT_TYP_CD
, CVG_MLT_CD
, ENTR_VAL_AT_ENRT_FLAG
, ENRT_CVG_STRT_DT_CD
, CRNTLY_ENRD_FLAG
, BUSINESS_GROUP_ID
, MNDTRY_FLAG
, DFLT_FLAG
, ELIG_PER_ELCTBL_CHC_ID
, PER_IN_LER_ID
, LF_EVT_OCRD_DT
, CHOICE_OVN
, PRTT_ENRT_RSLT_ID
, ENRT_BNFT_ID
, ENRT_CVG_STRT_DT
, ERLST_DEENRT_DT
, PERSON_ID
, CTFN_RQD_FLAG
, UOM
, ACTY_REF_PERD_CD
, CLS_ENRT_DT_TO_USE_CD
, PL_ORDR_NUM
, PLIP_ORDR_NUM
, PTIP_ORDR_NUM
, OIPL_ORDR_NUM
, PEN_PRTT_ENRT_RSLT_ID
, PEN_ENRT_CVG_STRT_DT
, PEN_ENRT_CVG_THRU_DT
, PEN_ENRT_SSPNDD_FLAG
, PEN_RPLCS_SSPNDD_RSLT_ID
, MN_VAL
, MX_VAL
, MX_WOUT_CTFN_VAL
, IN_PNDG_WKFLOW_FLAG_MEANING
, IN_PNDG_WKFLOW_FLAG
FROM APPS.BEN_ENRT_MISC_LOV_INFO_LE_V;
|
|
|