[Home] [Help] [Dependency Information]
Object Name: | BEN_ELIG_HRLY_SLRD_PRTE_F |
---|---|
Object Type: | TABLE |
Owner: | BEN |
FND Design Data: | BEN.BEN_ELIG_HRLY_SLRD_PRTE_F |
Subobject Name: | |
Status: | VALID |
BEN_ELIG_HRLY_SLRD_PRTE_F specifies that either hourly or salaried persons are eligible to participate in aplan or program for this eligibility profile. The determination of
whether hourly or salaried is valid is based on the person's primary assignment.
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
BEN_ELIG_HRLY_SLRD_PRTE_F_PK | NORMAL | UNIQUE | APPS_TS_TX_IDX |
ELIG_HRLY_SLRD_PRTE_ID
EFFECTIVE_START_DATE EFFECTIVE_END_DATE |
BEN_ELIG_HRLY_SLRD_PRTE_F_FK2 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | BUSINESS_GROUP_ID |
BEN_ELIG_HRLY_SLRD_PRTE_F_N1 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | ELIGY_PRFL_ID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
ELIG_HRLY_SLRD_PRTE_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. | |
ELIGY_PRFL_ID | NUMBER | (15) | Yes | Foreign key to BEN_ELIGY_PRFL_F. |
BUSINESS_GROUP_ID | NUMBER | (15) | Yes | Foreign Key to HR_ORGANIZATION_UNITS |
HRLY_SLRD_CD | VARCHAR2 | (30) | Yes | Hourly or salaried. |
EXCLD_FLAG | VARCHAR2 | (30) | Yes | Exclude Y or N. |
EHS_ATTRIBUTE_CATEGORY | VARCHAR2 | (30) | Descriptive Flexfield structure defining column. | |
EHS_ATTRIBUTE1 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
EHS_ATTRIBUTE2 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
EHS_ATTRIBUTE3 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
EHS_ATTRIBUTE4 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
EHS_ATTRIBUTE5 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
EHS_ATTRIBUTE6 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
EHS_ATTRIBUTE7 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
EHS_ATTRIBUTE8 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
EHS_ATTRIBUTE9 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
EHS_ATTRIBUTE10 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
EHS_ATTRIBUTE11 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
EHS_ATTRIBUTE12 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
EHS_ATTRIBUTE13 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
EHS_ATTRIBUTE14 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
EHS_ATTRIBUTE15 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
EHS_ATTRIBUTE16 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
EHS_ATTRIBUTE17 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
EHS_ATTRIBUTE18 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
EHS_ATTRIBUTE19 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
EHS_ATTRIBUTE20 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
EHS_ATTRIBUTE21 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
EHS_ATTRIBUTE22 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
EHS_ATTRIBUTE23 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
EHS_ATTRIBUTE24 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
EHS_ATTRIBUTE25 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
EHS_ATTRIBUTE26 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
EHS_ATTRIBUTE27 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
EHS_ATTRIBUTE28 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
EHS_ATTRIBUTE29 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
EHS_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. | |
ORDR_NUM | NUMBER | (15) | Order number. | |
CRITERIA_SCORE | NUMBER | Criteria Score | ||
CRITERIA_WEIGHT | NUMBER | Criteria Weight |
Cut, paste (and edit) the following text to query this object:
SELECT ELIG_HRLY_SLRD_PRTE_ID
, EFFECTIVE_START_DATE
, EFFECTIVE_END_DATE
, ELIGY_PRFL_ID
, BUSINESS_GROUP_ID
, HRLY_SLRD_CD
, EXCLD_FLAG
, EHS_ATTRIBUTE_CATEGORY
, EHS_ATTRIBUTE1
, EHS_ATTRIBUTE2
, EHS_ATTRIBUTE3
, EHS_ATTRIBUTE4
, EHS_ATTRIBUTE5
, EHS_ATTRIBUTE6
, EHS_ATTRIBUTE7
, EHS_ATTRIBUTE8
, EHS_ATTRIBUTE9
, EHS_ATTRIBUTE10
, EHS_ATTRIBUTE11
, EHS_ATTRIBUTE12
, EHS_ATTRIBUTE13
, EHS_ATTRIBUTE14
, EHS_ATTRIBUTE15
, EHS_ATTRIBUTE16
, EHS_ATTRIBUTE17
, EHS_ATTRIBUTE18
, EHS_ATTRIBUTE19
, EHS_ATTRIBUTE20
, EHS_ATTRIBUTE21
, EHS_ATTRIBUTE22
, EHS_ATTRIBUTE23
, EHS_ATTRIBUTE24
, EHS_ATTRIBUTE25
, EHS_ATTRIBUTE26
, EHS_ATTRIBUTE27
, EHS_ATTRIBUTE28
, EHS_ATTRIBUTE29
, EHS_ATTRIBUTE30
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_LOGIN
, CREATED_BY
, CREATION_DATE
, OBJECT_VERSION_NUMBER
, ORDR_NUM
, CRITERIA_SCORE
, CRITERIA_WEIGHT
FROM BEN.BEN_ELIG_HRLY_SLRD_PRTE_F;
BEN.BEN_ELIG_HRLY_SLRD_PRTE_F does not reference any database object
BEN.BEN_ELIG_HRLY_SLRD_PRTE_F is referenced by following:
|
|
|