[Home] [Help] [Dependency Information]
Object Name: | BEN_PL_EXTRACT_IDENTIFIER_F |
---|---|
Object Type: | TABLE |
Owner: | BEN |
FND Design Data: | BEN.BEN_PL_EXTRACT_IDENTIFIER_F |
Subobject Name: | |
Status: | VALID |
The ANSI 834 extract delivered by Oracle allows customers to send their enrollment changes to their Plan providers. Some plan providers allocate different plan identifiers for the same plans and options depending on the indicative data of the employee who is enrolled. This table identifies multiple identifiers for the same plan or option in plan, based on the Indicative data stored on their employee assignment and address.
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
BEN_PL_EXTRACT_IDENTIFIER_F_PK | NORMAL | UNIQUE | APPS_TS_TX_IDX |
PL_EXTRACT_IDENTIFIER_ID
EFFECTIVE_START_DATE EFFECTIVE_END_DATE |
BEN_PL_EXTRACT_IDENTIFIER_F_F1 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | BUSINESS_GROUP_ID |
BEN_PL_EXTRACT_IDENTIFIER_F_F2 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | PL_ID |
BEN_PL_EXTRACT_IDENTIFIER_F_F3 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | PLIP_ID |
BEN_PL_EXTRACT_IDENTIFIER_F_F4 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | OIPL_ID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
PL_EXTRACT_IDENTIFIER_ID | NUMBER | (15) | Yes | System generated primary key column. |
PL_ID | NUMBER | (15) | Foreign key to BEN_PL_F. | |
PLIP_ID | NUMBER | (15) | Foreign key to BEN_PLIP_F | |
OIPL_ID | NUMBER | (15) | Foreign key to BEN_OIPL_F | |
THIRD_PARTY_IDENTIFIER | VARCHAR2 | (10) | Plan Third Party Identifier | |
ORGANIZATION_ID | NUMBER | (15) | Foreign key to HR_ORGANIZATION_UNITS | |
JOB_ID | NUMBER | (15) | Foreign key to PER_JOBS | |
POSITION_ID | NUMBER | (15) | Foreign key to PER_ALL_POSITIONS. | |
PEOPLE_GROUP_ID | NUMBER | (15) | Foreign key to PAY_PEOPLE_GROUPS. | |
GRADE_ID | NUMBER | (15) | Foreign key to PER_GRADES | |
PAYROLL_ID | NUMBER | (15) | Foreign key to PAY_PAYROLLS. | |
HOME_STATE | VARCHAR2 | (30) | Home State | |
HOME_ZIP | VARCHAR2 | (30) | Zip Range | |
EFFECTIVE_START_DATE | DATE | Yes | Effective start date. | |
EFFECTIVE_END_DATE | DATE | Yes | Effective end date. | |
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. | ||
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). | |
OBJECT_VERSION_NUMBER | NUMBER | (9) | System-generated primary key. Increments by one each update. | |
BUSINESS_GROUP_ID | NUMBER | (15) | Foreign Key to HR_ORGANIZATION_UNITS |
Cut, paste (and edit) the following text to query this object:
SELECT PL_EXTRACT_IDENTIFIER_ID
, PL_ID
, PLIP_ID
, OIPL_ID
, THIRD_PARTY_IDENTIFIER
, ORGANIZATION_ID
, JOB_ID
, POSITION_ID
, PEOPLE_GROUP_ID
, GRADE_ID
, PAYROLL_ID
, HOME_STATE
, HOME_ZIP
, EFFECTIVE_START_DATE
, EFFECTIVE_END_DATE
, CREATED_BY
, CREATION_DATE
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_LOGIN
, OBJECT_VERSION_NUMBER
, BUSINESS_GROUP_ID
FROM BEN.BEN_PL_EXTRACT_IDENTIFIER_F;
BEN.BEN_PL_EXTRACT_IDENTIFIER_F does not reference any database object
BEN.BEN_PL_EXTRACT_IDENTIFIER_F is referenced by following:
|
|
|