[Home] [Help] [Dependency Information]
Object Name: | PQP_EXTRACT_ATTRIBUTES |
---|---|
Object Type: | TABLE |
Owner: | HR |
FND Design Data: | PQP.PQP_EXTRACT_ATTRIBUTES |
Subobject Name: | |
Status: | VALID |
PQP_EXTRACT_ATTRIBUTES is the table which holds a variety of information about a system extract definition required by the public sector payroll product . This information includes the extract type and the user defined table associated with the extract.
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
PQP_EXTRACT_ATTRIBUTES_PK | NORMAL | UNIQUE | APPS_TS_TX_IDX | EXTRACT_ATTRIBUTE_ID |
PQP_EXTRACT_ATTRIBUTES_UK1 | NORMAL | UNIQUE | APPS_TS_TX_IDX | EXT_DFN_ID |
PQP_EXTRACT_ATTRIBUTES_N1 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | EXT_DFN_NAME |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
EXTRACT_ATTRIBUTE_ID | NUMBER | (15) | Yes | System generated primary key column |
EXT_DFN_ID | NUMBER | (15) | Yes | Foreign key to BEN_EXT_DFN |
EXT_DFN_NAME | VARCHAR2 | (600) | Denormalized BEN_EXT_DFN.NAME, used to allow seeding of extract defnitions. | |
EXT_DFN_TYPE | VARCHAR2 | (30) | Yes | Qualfies the type of extract definition. |
EXT_USER_TABLE_ID | NUMBER | (15) | Foreign key to PAY_USER_TABLES | |
EXT_USER_TABLE_NAME | VARCHAR2 | (240) | Denormalized BEN_EXT_DFN.NAME, used to allow seeding of extract defnitions. | |
CREATED_BY | NUMBER | (15) | Yes | Standard WHO column |
CREATION_DATE | DATE | Yes | Standard WHO column | |
LAST_UPDATED_BY | NUMBER | (15) | Standard WHO column | |
LAST_UPDATE_DATE | DATE | Standard WHO column | ||
LAST_UPDATE_LOGIN | NUMBER | Standard WHO column | ||
OBJECT_VERSION_NUMBER | NUMBER | Yes | System generated version of row. Increments by one with each update. |
Cut, paste (and edit) the following text to query this object:
SELECT EXTRACT_ATTRIBUTE_ID
, EXT_DFN_ID
, EXT_DFN_NAME
, EXT_DFN_TYPE
, EXT_USER_TABLE_ID
, EXT_USER_TABLE_NAME
, CREATED_BY
, CREATION_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN
, OBJECT_VERSION_NUMBER
FROM HR.PQP_EXTRACT_ATTRIBUTES;
HR.PQP_EXTRACT_ATTRIBUTES does not reference any database object
HR.PQP_EXTRACT_ATTRIBUTES is referenced by following:
|
|
|