[Home] [Help] [Dependency Information]
Object Name: | BEN_ELIG_PER_F |
---|---|
Object Type: | TABLE |
Owner: | BEN |
FND Design Data: | BEN.BEN_ELIG_PER_F |
Subobject Name: | |
Status: | VALID |
BEN_ELIG_PER_F captures information about persons found eligible, and in some cases ineligible, for a program or plan. Typically, being eligible to participate means that the person can make an election or be enrolled, however, there are some circumstances where enrollment is not appropriate for a plan and being eligible does not mean that the participant can enroll at the same time as when they are eligible. The broadest definition of participation eligibility is that the person satisfies the plan defined criteria for receiving benefits from the plan at some time.
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
BEN_ELIG_PER_F_PK | NORMAL | UNIQUE | APPS_TS_TX_IDX |
ELIG_PER_ID
EFFECTIVE_START_DATE EFFECTIVE_END_DATE |
BEN_ELIG_PER_F_FK1 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | BUSINESS_GROUP_ID |
BEN_ELIG_PER_F_FK6 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | PER_IN_LER_ID |
BEN_ELIG_PER_F_N1 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | PL_ID |
BEN_ELIG_PER_F_N2 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | PLIP_ID |
BEN_ELIG_PER_F_N3A | NORMAL | NONUNIQUE | APPS_TS_TX_IDX |
PERSON_ID
EFFECTIVE_START_DATE EFFECTIVE_END_DATE PL_ID |
BEN_ELIG_PER_F_N4 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | PGM_ID |
BEN_ELIG_PER_F_N5 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | PTIP_ID |
BEN_ELIG_PER_F_N6 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | LER_ID |
BEN_ELIG_PER_F_N7 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | MUST_ENRL_ANTHR_PL_ID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
ELIG_PER_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. | |
DSTR_RSTCN_FLAG | VARCHAR2 | (30) | Yes | Distribution restriction Y or N. |
DPNT_OTHR_PL_CVRD_RL_FLAG | VARCHAR2 | (30) | Yes | Dependent covered in other plan rule Y or N. |
PL_HGHLY_COMPD_FLAG | VARCHAR2 | (30) | Yes | Plan Highly Compensated Y or N. |
PL_KEY_EE_FLAG | VARCHAR2 | (30) | Yes | Plan Key Employee Y or N. |
ELIG_FLAG | VARCHAR2 | (30) | Yes | Eligible Y or N. |
PL_WVD_FLAG | VARCHAR2 | (30) | Yes | Plan Waived Y or N. |
PRTN_OVRIDN_FLAG | VARCHAR2 | (30) | Yes | Participation Overriden Y or N. |
NO_MX_PRTN_OVRID_THRU_FLAG | VARCHAR2 | (30) | Yes | No Maximum Participation Override Through Y or N. |
FRZ_LOS_FLAG | VARCHAR2 | (30) | Yes | Freeze Length of Service Y or N. |
FRZ_AGE_FLAG | VARCHAR2 | (30) | Yes | Freeze Age Y or N. |
FRZ_CMP_LVL_FLAG | VARCHAR2 | (30) | Yes | Freeze Compensation Level Y or N. |
FRZ_PCT_FL_TM_FLAG | VARCHAR2 | (30) | Yes | Freeze Percent Full Time Y or N. |
FRZ_HRS_WKD_FLAG | VARCHAR2 | (30) | Yes | Freeze Hours Worked Y or N. |
FRZ_COMB_AGE_AND_LOS_FLAG | VARCHAR2 | (30) | Yes | Freeze Combination Age And Length of Service Y or N. |
RT_FRZ_LOS_FLAG | VARCHAR2 | (30) | Yes | Rate Freeze Length of Service Y or N. |
RT_FRZ_AGE_FLAG | VARCHAR2 | (30) | Yes | Rate Freeze Age Y or N. |
RT_FRZ_CMP_LVL_FLAG | VARCHAR2 | (30) | Yes | Rate Freeze Compensation Level Y or N. |
RT_FRZ_PCT_FL_TM_FLAG | VARCHAR2 | (30) | Yes | Rate Freeze Percent Full Time Y or N. |
RT_FRZ_HRS_WKD_FLAG | VARCHAR2 | (30) | Yes | Rate Freeze Hours Worked Y or N. |
RT_FRZ_COMB_AGE_AND_LOS_FLAG | VARCHAR2 | (30) | Yes | Rate Freeze Combination Age And Length of Service Y or N. |
PERSON_ID | NUMBER | (15) | Yes | Foreign Key to PER_PEOPLE_F. |
BUSINESS_GROUP_ID | NUMBER | (15) | Yes | Foreign Key to HR_ORGANIZATION_UNITS |
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. | |
PEP_ATTRIBUTE_CATEGORY | VARCHAR2 | (30) | Descriptive Flexfield structure defining column. | |
PEP_ATTRIBUTE1 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
PEP_ATTRIBUTE2 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
PEP_ATTRIBUTE3 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
PEP_ATTRIBUTE4 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
PEP_ATTRIBUTE5 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
PEP_ATTRIBUTE6 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
PEP_ATTRIBUTE7 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
PEP_ATTRIBUTE8 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
PEP_ATTRIBUTE9 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
PEP_ATTRIBUTE10 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
PEP_ATTRIBUTE11 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
PEP_ATTRIBUTE12 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
PEP_ATTRIBUTE13 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
PEP_ATTRIBUTE14 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
PEP_ATTRIBUTE15 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
PEP_ATTRIBUTE16 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
PEP_ATTRIBUTE17 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
PEP_ATTRIBUTE18 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
PEP_ATTRIBUTE19 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
PEP_ATTRIBUTE20 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
PEP_ATTRIBUTE21 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
PEP_ATTRIBUTE22 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
PEP_ATTRIBUTE23 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
PEP_ATTRIBUTE24 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
PEP_ATTRIBUTE25 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
PEP_ATTRIBUTE26 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
PEP_ATTRIBUTE27 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
PEP_ATTRIBUTE28 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
PEP_ATTRIBUTE29 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
PEP_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. | |
CMBN_AGE_N_LOS_VAL | NUMBER | Eligible combined age and length of service value. | ||
OVRID_SVC_DT | DATE | Override service date. | ||
COMP_REF_AMT | NUMBER | Eligible compensation reference amount. | ||
AGE_VAL | NUMBER | Eligible age value. | ||
LOS_VAL | NUMBER | Eligible length of service value. | ||
PRTN_END_DT | DATE | Participation end date. | ||
HRS_WKD_VAL | NUMBER | Eligible hours worked. | ||
PRTN_OVRIDN_THRU_DT | DATE | Participation overriden through date. | ||
PCT_FL_TM_VAL | NUMBER | Eligible percent full time value. | ||
PRTN_STRT_DT | DATE | Participation start date. | ||
HRS_WKD_BNDRY_PERD_CD | VARCHAR2 | (30) | Eligible hours worked boundary period. | |
WV_PRTN_RSN_CD | VARCHAR2 | (30) | Waive participation reason. | |
PRTN_OVRIDN_RSN_CD | VARCHAR2 | (30) | Participation override reason. | |
AGE_UOM | VARCHAR2 | (30) | Eligible age unit of measure. | |
LOS_UOM | VARCHAR2 | (30) | Eligible length of service unit of measure. | |
WV_CTFN_TYP_CD | VARCHAR2 | (30) | Waive certification type. | |
COMP_REF_UOM | VARCHAR2 | (30) | Eligible compensation reference unit of measure. | |
RT_COMP_REF_AMT | NUMBER | Rate compensation reference amount. | ||
RT_CMBN_AGE_N_LOS_VAL | NUMBER | Rate combination age and length of service value. | ||
RT_COMP_REF_UOM | VARCHAR2 | (30) | Rate compensation reference unit of measure. | |
RT_AGE_VAL | NUMBER | Rate age value. | ||
RT_LOS_VAL | NUMBER | Rate length of service value. | ||
RT_HRS_WKD_VAL | NUMBER | Rate hours worked value. | ||
RT_HRS_WKD_BNDRY_PERD_CD | VARCHAR2 | (30) | Rate hours worked boundary period. | |
RT_AGE_UOM | VARCHAR2 | (30) | Rate age unit of measure. | |
RT_LOS_UOM | VARCHAR2 | (30) | Rate length of service unit of measure. | |
RT_PCT_FL_TM_VAL | NUMBER | Rate percent full time value. | ||
INELG_RSN_CD | VARCHAR2 | (30) | Ineligible reason. | |
ONCE_R_CNTUG_CD | VARCHAR2 | (30) | Once or continuing. | |
WAIT_PERD_CMPLTN_DT | DATE | Waiting period completion date. | ||
PER_IN_LER_ID | NUMBER | (15) | Foreign Key to BEN_PER_IN_LER. | |
PL_ID | NUMBER | (15) | Foreign Key to BEN_PL_F. | |
PLIP_ID | NUMBER | (15) | Foreign key to BEN_PLIP_F. | |
PGM_ID | NUMBER | (15) | Foreign key to BEN_PGM_F. | |
PTIP_ID | NUMBER | (15) | Foreign Key to BEN_PTIP_F. | |
LER_ID | NUMBER | (15) | Foreign Key to BEN_LER_F. | |
MUST_ENRL_ANTHR_PL_ID | NUMBER | (15) | Foreign key to BEN_PL_F. | |
WAIT_PERD_STRT_DT | DATE | Waiting Period Start Date |
Cut, paste (and edit) the following text to query this object:
SELECT ELIG_PER_ID
, EFFECTIVE_START_DATE
, EFFECTIVE_END_DATE
, DSTR_RSTCN_FLAG
, DPNT_OTHR_PL_CVRD_RL_FLAG
, PL_HGHLY_COMPD_FLAG
, PL_KEY_EE_FLAG
, ELIG_FLAG
, PL_WVD_FLAG
, PRTN_OVRIDN_FLAG
, NO_MX_PRTN_OVRID_THRU_FLAG
, FRZ_LOS_FLAG
, FRZ_AGE_FLAG
, FRZ_CMP_LVL_FLAG
, FRZ_PCT_FL_TM_FLAG
, FRZ_HRS_WKD_FLAG
, FRZ_COMB_AGE_AND_LOS_FLAG
, RT_FRZ_LOS_FLAG
, RT_FRZ_AGE_FLAG
, RT_FRZ_CMP_LVL_FLAG
, RT_FRZ_PCT_FL_TM_FLAG
, RT_FRZ_HRS_WKD_FLAG
, RT_FRZ_COMB_AGE_AND_LOS_FLAG
, PERSON_ID
, BUSINESS_GROUP_ID
, PL_ORDR_NUM
, PLIP_ORDR_NUM
, PTIP_ORDR_NUM
, PEP_ATTRIBUTE_CATEGORY
, PEP_ATTRIBUTE1
, PEP_ATTRIBUTE2
, PEP_ATTRIBUTE3
, PEP_ATTRIBUTE4
, PEP_ATTRIBUTE5
, PEP_ATTRIBUTE6
, PEP_ATTRIBUTE7
, PEP_ATTRIBUTE8
, PEP_ATTRIBUTE9
, PEP_ATTRIBUTE10
, PEP_ATTRIBUTE11
, PEP_ATTRIBUTE12
, PEP_ATTRIBUTE13
, PEP_ATTRIBUTE14
, PEP_ATTRIBUTE15
, PEP_ATTRIBUTE16
, PEP_ATTRIBUTE17
, PEP_ATTRIBUTE18
, PEP_ATTRIBUTE19
, PEP_ATTRIBUTE20
, PEP_ATTRIBUTE21
, PEP_ATTRIBUTE22
, PEP_ATTRIBUTE23
, PEP_ATTRIBUTE24
, PEP_ATTRIBUTE25
, PEP_ATTRIBUTE26
, PEP_ATTRIBUTE27
, PEP_ATTRIBUTE28
, PEP_ATTRIBUTE29
, PEP_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
, CMBN_AGE_N_LOS_VAL
, OVRID_SVC_DT
, COMP_REF_AMT
, AGE_VAL
, LOS_VAL
, PRTN_END_DT
, HRS_WKD_VAL
, PRTN_OVRIDN_THRU_DT
, PCT_FL_TM_VAL
, PRTN_STRT_DT
, HRS_WKD_BNDRY_PERD_CD
, WV_PRTN_RSN_CD
, PRTN_OVRIDN_RSN_CD
, AGE_UOM
, LOS_UOM
, WV_CTFN_TYP_CD
, COMP_REF_UOM
, RT_COMP_REF_AMT
, RT_CMBN_AGE_N_LOS_VAL
, RT_COMP_REF_UOM
, RT_AGE_VAL
, RT_LOS_VAL
, RT_HRS_WKD_VAL
, RT_HRS_WKD_BNDRY_PERD_CD
, RT_AGE_UOM
, RT_LOS_UOM
, RT_PCT_FL_TM_VAL
, INELG_RSN_CD
, ONCE_R_CNTUG_CD
, WAIT_PERD_CMPLTN_DT
, PER_IN_LER_ID
, PL_ID
, PLIP_ID
, PGM_ID
, PTIP_ID
, LER_ID
, MUST_ENRL_ANTHR_PL_ID
, WAIT_PERD_STRT_DT
FROM BEN.BEN_ELIG_PER_F;
BEN.BEN_ELIG_PER_F does not reference any database object
BEN.BEN_ELIG_PER_F is referenced by following:
|
|
|