[Home] [Help] [Dependency Information]
Object Name: | BEN_ELIG_PER_ELCTBL_CHC |
---|---|
Object Type: | TABLE |
Owner: | BEN |
FND Design Data: | BEN.BEN_ELIG_PER_ELCTBL_CHC |
Subobject Name: | |
Status: | VALID |
BEN_ELIG_PER_ELCTBL_CHC identifies the plans or options in plans a person make elect as the result of a life event with consideration given to any current elections that must remain in force. It also identifies any possible flexible credit values may be available and any automatic enrollments that were assigned as a result of the life event.
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
BEN_ELIG_PER_ELCTBL_CHC_PK | NORMAL | UNIQUE | APPS_TS_TX_IDX | ELIG_PER_ELCTBL_CHC_ID |
BEN_ELIG_PER_ELCTBL_CHC_CK2 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX |
PL_TYP_ID
PL_ID OIPL_ID |
BEN_ELIG_PER_ELCTBL_CHC_CK4 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX |
PGM_ID
PER_IN_LER_ID |
BEN_ELIG_PER_ELCTBL_CHC_CK5 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX |
PER_IN_LER_ID
PL_ID PGM_ID OIPL_ID |
BEN_ELIG_PER_ELCTBL_CHC_FK15 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | YR_PERD_ID |
BEN_ELIG_PER_ELCTBL_CHC_FK16 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | BUSINESS_GROUP_ID |
BEN_ELIG_PER_ELCTBL_CHC_FK17 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | PIL_ELCTBL_CHC_POPL_ID |
BEN_ELIG_PER_ELCTBL_CHC_FK18 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | INTERIM_ELIG_PER_ELCTBL_CHC_ID |
BEN_ELIG_PER_ELCTBL_CHC_FK19 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | WS_MGR_ID |
BEN_ELIG_PER_ELCTBL_CHC_N11 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | MUST_ENRL_ANTHR_PL_ID |
BEN_ELIG_PER_ELCTBL_CHC_N12 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | SPCL_RT_PL_ID |
BEN_ELIG_PER_ELCTBL_CHC_N13 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | SPCL_RT_OIPL_ID |
BEN_ELIG_PER_ELCTBL_CHC_N14 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | BNFT_PRVDR_POOL_ID |
BEN_ELIG_PER_ELCTBL_CHC_N15 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | CMBN_PTIP_ID |
BEN_ELIG_PER_ELCTBL_CHC_N16 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | CMBN_PTIP_OPT_ID |
BEN_ELIG_PER_ELCTBL_CHC_N17 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | CMBN_PLIP_ID |
BEN_ELIG_PER_ELCTBL_CHC_N18 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | ASSIGNMENT_ID |
BEN_ELIG_PER_ELCTBL_CHC_N2 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | OIPL_ID |
BEN_ELIG_PER_ELCTBL_CHC_N4 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | PL_ID |
BEN_ELIG_PER_ELCTBL_CHC_N5 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | PRTT_ENRT_RSLT_ID |
BEN_ELIG_PER_ELCTBL_CHC_N8 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | PLIP_ID |
BEN_ELIG_PER_ELCTBL_CHC_N9 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | PTIP_ID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
ELIG_PER_ELCTBL_CHC_ID | NUMBER | (15) | Yes | System generated primary key column. |
BUSINESS_GROUP_ID | NUMBER | (15) | Yes | Foreign Key to HR_ORGANIZATION_UNITS |
ROLL_CRS_FLAG | VARCHAR2 | (30) | Yes | Roll Credits Y or N. |
CRNTLY_ENRD_FLAG | VARCHAR2 | (30) | Yes | Currently enrolled Y or N. |
DFLT_FLAG | VARCHAR2 | (30) | Yes | Default Y or N. |
ELCTBL_FLAG | VARCHAR2 | (30) | Yes | Electable Y or N. |
MNDTRY_FLAG | VARCHAR2 | (30) | Yes | Mandatory Y or N. |
ALWS_DPNT_DSGN_FLAG | VARCHAR2 | (30) | Yes | Allows dependent designation Y or N. |
COMP_LVL_CD | VARCHAR2 | (30) | Yes | Compensation level. |
AUTO_ENRT_FLAG | VARCHAR2 | (30) | Yes | Automatically Enroll Y or N. |
CTFN_RQD_FLAG | VARCHAR2 | (30) | Yes | Certification required Y or N. |
PER_IN_LER_ID | NUMBER | (15) | Yes | Foreign Key to BEN_PER_IN_LER. |
YR_PERD_ID | NUMBER | (15) | Foreing key to BEN_YR_PERD. | |
INTERIM_ELIG_PER_ELCTBL_CHC_ID | NUMBER | (15) | Foreing key to BEN_ELIG_PER_ELCTBL_CHC. | |
PIL_ELCTBL_CHC_POPL_ID | NUMBER | (15) | Foreign key to BEN_PIL_ELCTBL_CHC_POPL_F. | |
OIPLIP_ID | NUMBER | (15) | Foreign Key to BEN_OIPLIP_F. | |
PL_ORDR_NUM | NUMBER | (15) | Plan order number. | |
PLIP_ORDR_NUM | NUMBER | (15) | Plan in program order number. | |
PTIP_ORDR_NUM | NUMBER | (15) | Plan type in program order number. | |
OIPL_ORDR_NUM | NUMBER | (15) | Option in plan order number. | |
EPE_ATTRIBUTE_CATEGORY | VARCHAR2 | (30) | Descriptive Flexfield structure defining column. | |
EPE_ATTRIBUTE1 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
EPE_ATTRIBUTE2 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
EPE_ATTRIBUTE3 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
EPE_ATTRIBUTE4 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
EPE_ATTRIBUTE5 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
EPE_ATTRIBUTE6 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
EPE_ATTRIBUTE7 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
EPE_ATTRIBUTE8 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
EPE_ATTRIBUTE9 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
EPE_ATTRIBUTE10 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
EPE_ATTRIBUTE11 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
EPE_ATTRIBUTE12 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
EPE_ATTRIBUTE13 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
EPE_ATTRIBUTE14 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
EPE_ATTRIBUTE15 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
EPE_ATTRIBUTE16 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
EPE_ATTRIBUTE17 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
EPE_ATTRIBUTE18 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
EPE_ATTRIBUTE19 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
EPE_ATTRIBUTE20 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
EPE_ATTRIBUTE21 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
EPE_ATTRIBUTE22 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
EPE_ATTRIBUTE23 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
EPE_ATTRIBUTE24 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
EPE_ATTRIBUTE25 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
EPE_ATTRIBUTE26 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
EPE_ATTRIBUTE27 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
EPE_ATTRIBUTE28 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
EPE_ATTRIBUTE29 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
EPE_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. | ||
REQUEST_ID | NUMBER | (15) | Concurrent Program who column - concurrent request id of the program that last updated this row (foreign key to FND_CONCURRENT_REQUESTS.REQUEST_ID). | |
PROGRAM_APPLICATION_ID | NUMBER | (15) | Concurrent Program who column - application id of the program that last updated this row (foreign key to FND_APPLICATION.APPLICATION_ID). | |
PROGRAM_ID | NUMBER | (15) | Concurrent Program who column - program id of the program that last updated this row (foreign key to FND_CONCURRENT_PROGRAM.CONCURRENT_PROGRAM_ID). | |
PROGRAM_UPDATE_DATE | DATE | Concurrent Program who column - date when a program last updated this row). | ||
OBJECT_VERSION_NUMBER | NUMBER | (9) | System-generated primary key. Increments by one each update. | |
MUST_ENRL_ANTHR_PL_ID | NUMBER | (15) | Foreign key to BEN_PL_F. | |
SPCL_RT_PL_ID | NUMBER | (15) | Foreing key to BEN_PL_F. | |
SPCL_RT_OIPL_ID | NUMBER | (15) | Foreign key to BEN_OIPL_F. | |
BNFT_PRVDR_POOL_ID | NUMBER | (15) | Foreign key to BEN_BNFT_PRVDR_POOL_F. | |
CMBN_PTIP_ID | NUMBER | (15) | Foreign key to BEN_CMBN_PTIP_F. | |
CMBN_PTIP_OPT_ID | NUMBER | (15) | Foreign key to BEN_CMBN_PTIP_OPT_F. | |
CMBN_PLIP_ID | NUMBER | (15) | Foreign key to BEN_CMBN_PLIP_F. | |
OIPL_ID | NUMBER | (15) | Foreign Key to BEN_OIPL_F. | |
PGM_ID | NUMBER | (15) | Foreign key to BEN_PGM_F. | |
PL_ID | NUMBER | (15) | Foreign Key to BEN_PL_F. | |
PL_TYP_ID | NUMBER | (15) | Foreign key to BEN_PL_TYP_F. | |
PLIP_ID | NUMBER | (15) | Foreign key to BEN_PLIP_F. | |
PTIP_ID | NUMBER | (15) | Foreign Key to BEN_PTIP_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. | |
PRTT_ENRT_RSLT_ID | NUMBER | (15) | Foreign key to BEN_PRTT_ENRT_RSLT_F. | |
DPNT_CVG_STRT_DT_CD | VARCHAR2 | (30) | Dependent coverage start date code. | |
DPNT_CVG_STRT_DT_RL | NUMBER | (15) | Foreign key to FF_FORMULAS_F. | |
ENRT_CVG_STRT_DT | DATE | Enrollment coverage start date. | ||
DPNT_DSGN_CD | VARCHAR2 | (30) | Dependent designation code. | |
LER_CHG_DPNT_CVG_CD | VARCHAR2 | (30) | Life event reason change dependent coverage code. | |
ERLST_DEENRT_DT | DATE | Earliest de-enrollment date. | ||
PROCG_END_DT | DATE | Processing end date. | ||
CRYFWD_ELIG_DPNT_CD | VARCHAR2 | (30) | Carry forward eligible dependents. | |
IN_PNDG_WKFLOW_FLAG | VARCHAR2 | (30) | Pending work flow Y or N. | |
COMMENTS | VARCHAR2 | (2000) | COMMENTS | |
ELIG_FLAG | VARCHAR2 | (30) | Yes | ELIG FLAG |
ELIG_OVRID_DT | DATE | ELIG OVRID DT | ||
ELIG_OVRID_PERSON_ID | NUMBER | (15) | ELIG OVRID PERSON ID | |
INELIG_RSN_CD | VARCHAR2 | (30) | INELIG_RSN_CD | |
MGR_OVRID_DT | DATE | MGR_OVRID_DT | ||
MGR_OVRID_PERSON_ID | NUMBER | (15) | MGR_OVRID_PERSON_DT | |
WS_MGR_ID | NUMBER | (15) | WS_MGR_ID | |
ASSIGNMENT_ID | NUMBER | (15) | Foreign key to per_all_Assignments_f | |
APPROVAL_STATUS_CD | VARCHAR2 | (30) | Approval Status Code. | |
FONM_CVG_STRT_DT | DATE | Processing Date for Coverage and Rates |
Cut, paste (and edit) the following text to query this object:
SELECT ELIG_PER_ELCTBL_CHC_ID
, BUSINESS_GROUP_ID
, ROLL_CRS_FLAG
, CRNTLY_ENRD_FLAG
, DFLT_FLAG
, ELCTBL_FLAG
, MNDTRY_FLAG
, ALWS_DPNT_DSGN_FLAG
, COMP_LVL_CD
, AUTO_ENRT_FLAG
, CTFN_RQD_FLAG
, PER_IN_LER_ID
, YR_PERD_ID
, INTERIM_ELIG_PER_ELCTBL_CHC_ID
, PIL_ELCTBL_CHC_POPL_ID
, OIPLIP_ID
, PL_ORDR_NUM
, PLIP_ORDR_NUM
, PTIP_ORDR_NUM
, OIPL_ORDR_NUM
, EPE_ATTRIBUTE_CATEGORY
, EPE_ATTRIBUTE1
, EPE_ATTRIBUTE2
, EPE_ATTRIBUTE3
, EPE_ATTRIBUTE4
, EPE_ATTRIBUTE5
, EPE_ATTRIBUTE6
, EPE_ATTRIBUTE7
, EPE_ATTRIBUTE8
, EPE_ATTRIBUTE9
, EPE_ATTRIBUTE10
, EPE_ATTRIBUTE11
, EPE_ATTRIBUTE12
, EPE_ATTRIBUTE13
, EPE_ATTRIBUTE14
, EPE_ATTRIBUTE15
, EPE_ATTRIBUTE16
, EPE_ATTRIBUTE17
, EPE_ATTRIBUTE18
, EPE_ATTRIBUTE19
, EPE_ATTRIBUTE20
, EPE_ATTRIBUTE21
, EPE_ATTRIBUTE22
, EPE_ATTRIBUTE23
, EPE_ATTRIBUTE24
, EPE_ATTRIBUTE25
, EPE_ATTRIBUTE26
, EPE_ATTRIBUTE27
, EPE_ATTRIBUTE28
, EPE_ATTRIBUTE29
, EPE_ATTRIBUTE30
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_LOGIN
, CREATED_BY
, CREATION_DATE
, REQUEST_ID
, PROGRAM_APPLICATION_ID
, PROGRAM_ID
, PROGRAM_UPDATE_DATE
, OBJECT_VERSION_NUMBER
, MUST_ENRL_ANTHR_PL_ID
, SPCL_RT_PL_ID
, SPCL_RT_OIPL_ID
, BNFT_PRVDR_POOL_ID
, CMBN_PTIP_ID
, CMBN_PTIP_OPT_ID
, CMBN_PLIP_ID
, OIPL_ID
, PGM_ID
, PL_ID
, PL_TYP_ID
, PLIP_ID
, PTIP_ID
, ENRT_CVG_STRT_DT_CD
, ENRT_CVG_STRT_DT_RL
, PRTT_ENRT_RSLT_ID
, DPNT_CVG_STRT_DT_CD
, DPNT_CVG_STRT_DT_RL
, ENRT_CVG_STRT_DT
, DPNT_DSGN_CD
, LER_CHG_DPNT_CVG_CD
, ERLST_DEENRT_DT
, PROCG_END_DT
, CRYFWD_ELIG_DPNT_CD
, IN_PNDG_WKFLOW_FLAG
, COMMENTS
, ELIG_FLAG
, ELIG_OVRID_DT
, ELIG_OVRID_PERSON_ID
, INELIG_RSN_CD
, MGR_OVRID_DT
, MGR_OVRID_PERSON_ID
, WS_MGR_ID
, ASSIGNMENT_ID
, APPROVAL_STATUS_CD
, FONM_CVG_STRT_DT
FROM BEN.BEN_ELIG_PER_ELCTBL_CHC;
BEN.BEN_ELIG_PER_ELCTBL_CHC does not reference any database object
BEN.BEN_ELIG_PER_ELCTBL_CHC is referenced by following:
|
|
|