[Home] [Help] [Dependency Information]
Object Name: | BEN_ELIGY_PRFL_F |
---|---|
Object Type: | TABLE |
Owner: | BEN |
FND Design Data: | BEN.BEN_ELIGY_PRFL_F |
Subobject Name: | |
Status: | VALID |
BEN_ELIGY_PRFL_F identifies one or more fixed eligibility factors or rules which collectively define a profile of eligibility which must be satisfied in order for a person to be found eligible for a compensation object. Profiles are provided so that those compensation objects
which have the same eligibility requirements may share one definition, as opposed to requiring the user to maintain redundant definitions.
Eligibility profile criteria are compared to the criteria for a person to
determine whether the person is eligible to participate in a compensation object.
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
BEN_ELIGY_PRFL_F_PK | NORMAL | UNIQUE | APPS_TS_TX_IDX |
ELIGY_PRFL_ID
EFFECTIVE_START_DATE EFFECTIVE_END_DATE |
BEN_ELIGY_PRFL_F_FK1 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | BUSINESS_GROUP_ID |
BEN_ELIGY_PRFL_F_N1 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | NAME |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
ELIGY_PRFL_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 eligibility profile. |
STAT_CD | VARCHAR2 | (30) | Yes | Eligibility profile status. |
BUSINESS_GROUP_ID | NUMBER | (15) | Yes | Foreign Key to HR_ORGANIZATION_UNITS |
ELIG_ENRLD_PLIP_FLAG | VARCHAR2 | (30) | Yes | Eligible Enrolled Plan in Program Y or N. |
ELIG_CBR_QUALD_BNF_FLAG | VARCHAR2 | (30) | Yes | Eligible COBRA Qualified Beneficiary Y or N. |
ELIG_ENRLD_PTIP_FLAG | VARCHAR2 | (30) | Yes | Eligible Enrolled Plan Type in Program Y or N. |
ELIG_DPNT_CVRD_PLIP_FLAG | VARCHAR2 | (30) | Yes | Eligible Dependent Covered Plan in Program Y or N. |
ELIG_DPNT_CVRD_PTIP_FLAG | VARCHAR2 | (30) | Yes | Eligible Dependent Covered Plan Type in Program Y or N. |
ELIG_DPNT_CVRD_PGM_FLAG | VARCHAR2 | (30) | Yes | Eligible Dependent Covered Program Y or N. |
ELIG_JOB_FLAG | VARCHAR2 | (30) | Yes | Eligible Job Y or N. |
ELIG_HRLY_SLRD_FLAG | VARCHAR2 | (30) | Yes | Eligible Hourly Salaried Y or N. |
ELIG_PSTL_CD_FLAG | VARCHAR2 | (30) | Yes | Eligible Postal Code Y or N. |
ELIG_LBR_MMBR_FLAG | VARCHAR2 | (30) | Yes | Eligible Labor Member Y or N. |
ELIG_LGL_ENTY_FLAG | VARCHAR2 | (30) | Yes | Eligible Legal Entity Y or N. |
ELIG_BENFTS_GRP_FLAG | VARCHAR2 | (30) | Yes | Eligible Benefits Group Y or N. |
ELIG_WK_LOC_FLAG | VARCHAR2 | (30) | Yes | Eligible Work Location Y or N. |
ELIG_BRGNG_UNIT_FLAG | VARCHAR2 | (30) | Yes | Eligible Bargaining Unit Y or N. |
ELIG_AGE_FLAG | VARCHAR2 | (30) | Yes | Eligible Age Y or N. |
ELIG_LOS_FLAG | VARCHAR2 | (30) | Yes | Eligible Length of Service Y or N. |
ELIG_PER_TYP_FLAG | VARCHAR2 | (30) | Yes | Eligible Person Type Y or N. |
ELIG_FL_TM_PT_TM_FLAG | VARCHAR2 | (30) | Yes | Eligible Full Time Plan Type Time Y or N. |
ELIG_EE_STAT_FLAG | VARCHAR2 | (30) | Yes | Eligible Employee Status Y or N. |
ELIG_GRD_FLAG | VARCHAR2 | (30) | Yes | Eligible Grade Y or N. |
ELIG_PCT_FL_TM_FLAG | VARCHAR2 | (30) | Yes | Eligible Percent Full Time Y or N. |
ELIG_ASNT_SET_FLAG | VARCHAR2 | (30) | Yes | Eligible Assignment Set Y or N. |
ELIG_HRS_WKD_FLAG | VARCHAR2 | (30) | Yes | Eligible Hours Worked Y or N. |
ELIG_COMP_LVL_FLAG | VARCHAR2 | (30) | Yes | Eligible Compensation Level Y or N. |
ELIG_ORG_UNIT_FLAG | VARCHAR2 | (30) | Yes | Eligible Organization Unit Y or N. |
ELIG_LOA_RSN_FLAG | VARCHAR2 | (30) | Yes | Eligible Leave of Absence Reason Y or N. |
ELIG_PYRL_FLAG | VARCHAR2 | (30) | Yes | Eligible Payroll Y or N. |
ELIG_SCHEDD_HRS_FLAG | VARCHAR2 | (30) | Yes | Eligible Scheduled Hours Y or N. |
ELIG_PY_BSS_FLAG | VARCHAR2 | (30) | Yes | Eligible Pay Basis Y or N. |
ELIGY_PRFL_RL_FLAG | VARCHAR2 | (30) | Yes | Eligibility Profile Rule Y or N. |
ELIG_CMBN_AGE_LOS_FLAG | VARCHAR2 | (30) | Yes | Eligible Combination Age Length of Service Y or N. |
CNTNG_PRTN_ELIG_PRFL_FLAG | VARCHAR2 | (30) | Yes | Continuing participation Eligibility Y or N. |
ELIG_PRTT_PL_FLAG | VARCHAR2 | (30) | Yes | Eligible Participant Plan Y or N. |
ELIG_PPL_GRP_FLAG | VARCHAR2 | (30) | Yes | Eligible People Group Y or N. |
ELIG_SVC_AREA_FLAG | VARCHAR2 | (30) | Yes | Eligible Service Area Y or N. |
ELIG_PTIP_PRTE_FLAG | VARCHAR2 | (30) | Yes | Eligible Plan Type in Program Participate Y or N. |
ELIG_NO_OTHR_CVG_FLAG | VARCHAR2 | (30) | Yes | Eligible No Other Coverage Y or N. |
ELIG_ENRLD_PL_FLAG | VARCHAR2 | (30) | Yes | Eligible Enrolled Plan Y or N. |
ELIG_ENRLD_OIPL_FLAG | VARCHAR2 | (30) | Yes | Eligible Enrolled Option in Plan Y or N. |
ELIG_ENRLD_PGM_FLAG | VARCHAR2 | (30) | Yes | Eligible Enrolled Program Y or N. |
ELIG_DPNT_CVRD_PL_FLAG | VARCHAR2 | (30) | Yes | Eligible Dependent Covered Plan Y or N. |
ELIG_LVG_RSN_FLAG | VARCHAR2 | (30) | Yes | Eligible Leaving Reason Y or N. |
ELIG_OPTD_MDCR_FLAG | VARCHAR2 | (30) | Yes | Eligible Opted Medicare Y or N. |
ELIG_TBCO_USE_FLAG | VARCHAR2 | (30) | Yes | Eligible Tobacco Use Y or N. |
ELP_ATTRIBUTE_CATEGORY | VARCHAR2 | (30) | Descriptive Flexfield structure defining column. | |
ELP_ATTRIBUTE1 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
ELP_ATTRIBUTE2 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
ELP_ATTRIBUTE3 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
ELP_ATTRIBUTE4 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
ELP_ATTRIBUTE5 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
ELP_ATTRIBUTE6 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
ELP_ATTRIBUTE7 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
ELP_ATTRIBUTE8 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
ELP_ATTRIBUTE9 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
ELP_ATTRIBUTE10 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
ELP_ATTRIBUTE11 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
ELP_ATTRIBUTE12 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
ELP_ATTRIBUTE13 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
ELP_ATTRIBUTE14 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
ELP_ATTRIBUTE15 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
ELP_ATTRIBUTE16 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
ELP_ATTRIBUTE17 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
ELP_ATTRIBUTE18 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
ELP_ATTRIBUTE19 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
ELP_ATTRIBUTE20 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
ELP_ATTRIBUTE21 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
ELP_ATTRIBUTE22 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
ELP_ATTRIBUTE23 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
ELP_ATTRIBUTE24 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
ELP_ATTRIBUTE25 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
ELP_ATTRIBUTE26 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
ELP_ATTRIBUTE27 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
ELP_ATTRIBUTE28 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
ELP_ATTRIBUTE29 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
ELP_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. | |
DESCRIPTION | VARCHAR2 | (2000) | Description. | |
ASG_TYP_CD | VARCHAR2 | (30) | Assignment type. | |
ASMT_TO_USE_CD | VARCHAR2 | (30) | Assignment to use. | |
ELIG_DPNT_OTHR_PTIP_FLAG | VARCHAR2 | (30) | Yes | Eligible Dependent Other Plan Type in Program Y or N. |
ELIG_GNDR_FLAG | VARCHAR2 | (30) | Yes | Eligible gender Y or N. |
ELIG_DSBLTY_CTG_FLAG | VARCHAR2 | (30) | Yes | Eligible disability Y or N. |
ELIG_DSBLTY_DGR_FLAG | VARCHAR2 | (30) | Yes | Eligible disability degree Y or N. |
ELIG_DSBLTY_RSN_FLAG | VARCHAR2 | (30) | Yes | Eligible disability reason Y or N. |
ELIG_MRTL_STS_FLAG | VARCHAR2 | (30) | Yes | Eligible marital status Y or N. |
ELIG_PRBTN_PERD_FLAG | VARCHAR2 | (30) | Yes | Eligible probation period Y or N. |
ELIG_SP_CLNG_PRG_PT_FLAG | VARCHAR2 | (30) | Yes | Eligible spinal point progression Y or N. |
ELIG_SUPPL_ROLE_FLAG | VARCHAR2 | (30) | Yes | Eligible supplemental role Y or N. |
ELIG_QUAL_TITL_FLAG | VARCHAR2 | (30) | Yes | Eligible qualified title Y or N. |
ELIG_PSTN_FLAG | VARCHAR2 | (30) | Yes | Elible position Y or N. |
BNFT_CAGR_PRTN_CD | VARCHAR2 | (30) | Yes | Collective agreement participation. |
ELIG_DSBLD_FLAG | VARCHAR2 | (30) | Yes | Eligible disability Y or N. |
ELIG_TTL_CVG_VOL_FLAG | VARCHAR2 | (30) | Yes | Eligible total coverage Y or N. |
ELIG_TTL_PRTT_FLAG | VARCHAR2 | (30) | Yes | Eligible total particiation Y or N. |
ELIG_COMPTNCY_FLAG | VARCHAR2 | (30) | Yes | Eligible competency Y or N. |
ELIG_HLTH_CVG_FLAG | VARCHAR2 | (30) | Yes | Eligible health coverage Y or N. |
ELIG_ANTHR_PL_FLAG | VARCHAR2 | (30) | Yes | Eligible another plan Y or N. |
ELIG_PERF_RTNG_FLAG | VARCHAR2 | (30) | Yes | Eligible performance rating Y or N. |
ELIG_QUA_IN_GR_FLAG | VARCHAR2 | (30) | Yes | Eligible quartile in grade Y or N. |
ELIG_CRIT_VALUES_FLAG | VARCHAR2 | (30) | Yes | Eligible User Defined Criteria Y or N |
Cut, paste (and edit) the following text to query this object:
SELECT ELIGY_PRFL_ID
, EFFECTIVE_START_DATE
, EFFECTIVE_END_DATE
, NAME
, STAT_CD
, BUSINESS_GROUP_ID
, ELIG_ENRLD_PLIP_FLAG
, ELIG_CBR_QUALD_BNF_FLAG
, ELIG_ENRLD_PTIP_FLAG
, ELIG_DPNT_CVRD_PLIP_FLAG
, ELIG_DPNT_CVRD_PTIP_FLAG
, ELIG_DPNT_CVRD_PGM_FLAG
, ELIG_JOB_FLAG
, ELIG_HRLY_SLRD_FLAG
, ELIG_PSTL_CD_FLAG
, ELIG_LBR_MMBR_FLAG
, ELIG_LGL_ENTY_FLAG
, ELIG_BENFTS_GRP_FLAG
, ELIG_WK_LOC_FLAG
, ELIG_BRGNG_UNIT_FLAG
, ELIG_AGE_FLAG
, ELIG_LOS_FLAG
, ELIG_PER_TYP_FLAG
, ELIG_FL_TM_PT_TM_FLAG
, ELIG_EE_STAT_FLAG
, ELIG_GRD_FLAG
, ELIG_PCT_FL_TM_FLAG
, ELIG_ASNT_SET_FLAG
, ELIG_HRS_WKD_FLAG
, ELIG_COMP_LVL_FLAG
, ELIG_ORG_UNIT_FLAG
, ELIG_LOA_RSN_FLAG
, ELIG_PYRL_FLAG
, ELIG_SCHEDD_HRS_FLAG
, ELIG_PY_BSS_FLAG
, ELIGY_PRFL_RL_FLAG
, ELIG_CMBN_AGE_LOS_FLAG
, CNTNG_PRTN_ELIG_PRFL_FLAG
, ELIG_PRTT_PL_FLAG
, ELIG_PPL_GRP_FLAG
, ELIG_SVC_AREA_FLAG
, ELIG_PTIP_PRTE_FLAG
, ELIG_NO_OTHR_CVG_FLAG
, ELIG_ENRLD_PL_FLAG
, ELIG_ENRLD_OIPL_FLAG
, ELIG_ENRLD_PGM_FLAG
, ELIG_DPNT_CVRD_PL_FLAG
, ELIG_LVG_RSN_FLAG
, ELIG_OPTD_MDCR_FLAG
, ELIG_TBCO_USE_FLAG
, ELP_ATTRIBUTE_CATEGORY
, ELP_ATTRIBUTE1
, ELP_ATTRIBUTE2
, ELP_ATTRIBUTE3
, ELP_ATTRIBUTE4
, ELP_ATTRIBUTE5
, ELP_ATTRIBUTE6
, ELP_ATTRIBUTE7
, ELP_ATTRIBUTE8
, ELP_ATTRIBUTE9
, ELP_ATTRIBUTE10
, ELP_ATTRIBUTE11
, ELP_ATTRIBUTE12
, ELP_ATTRIBUTE13
, ELP_ATTRIBUTE14
, ELP_ATTRIBUTE15
, ELP_ATTRIBUTE16
, ELP_ATTRIBUTE17
, ELP_ATTRIBUTE18
, ELP_ATTRIBUTE19
, ELP_ATTRIBUTE20
, ELP_ATTRIBUTE21
, ELP_ATTRIBUTE22
, ELP_ATTRIBUTE23
, ELP_ATTRIBUTE24
, ELP_ATTRIBUTE25
, ELP_ATTRIBUTE26
, ELP_ATTRIBUTE27
, ELP_ATTRIBUTE28
, ELP_ATTRIBUTE29
, ELP_ATTRIBUTE30
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_LOGIN
, CREATED_BY
, CREATION_DATE
, OBJECT_VERSION_NUMBER
, DESCRIPTION
, ASG_TYP_CD
, ASMT_TO_USE_CD
, ELIG_DPNT_OTHR_PTIP_FLAG
, ELIG_GNDR_FLAG
, ELIG_DSBLTY_CTG_FLAG
, ELIG_DSBLTY_DGR_FLAG
, ELIG_DSBLTY_RSN_FLAG
, ELIG_MRTL_STS_FLAG
, ELIG_PRBTN_PERD_FLAG
, ELIG_SP_CLNG_PRG_PT_FLAG
, ELIG_SUPPL_ROLE_FLAG
, ELIG_QUAL_TITL_FLAG
, ELIG_PSTN_FLAG
, BNFT_CAGR_PRTN_CD
, ELIG_DSBLD_FLAG
, ELIG_TTL_CVG_VOL_FLAG
, ELIG_TTL_PRTT_FLAG
, ELIG_COMPTNCY_FLAG
, ELIG_HLTH_CVG_FLAG
, ELIG_ANTHR_PL_FLAG
, ELIG_PERF_RTNG_FLAG
, ELIG_QUA_IN_GR_FLAG
, ELIG_CRIT_VALUES_FLAG
FROM BEN.BEN_ELIGY_PRFL_F;
BEN.BEN_ELIGY_PRFL_F does not reference any database object
BEN.BEN_ELIGY_PRFL_F is referenced by following:
|
|
|