[Home] [Help] [Dependency Information]
Object Name: | PAY_ELEMENT_SPAN_USAGES |
---|---|
Object Type: | TABLE |
Owner: | HR |
FND Design Data: | PAY.PAY_ELEMENT_SPAN_USAGES |
Subobject Name: | |
Status: | VALID |
PAY_ELEMENT_SPAN_USAGES is used by the RetroPay by Element process
to determine which RetroPay element should be used depending on the age
of the retropaid change. This is required for countries where the processing
may vary if the entry crossing time boundaries. For example, if a correction is
processed from the previous tax year there may be legislative rules concerning
different taxation that needs to be applied.
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
PAY_ELEMENT_SPAN_USAGES_PK | NORMAL | UNIQUE | APPS_TS_TX_IDX | ELEMENT_SPAN_USAGE_ID |
PAY_ELEMENT_SPAN_USAGES_UK1 | NORMAL | UNIQUE | APPS_TS_TX_IDX |
RETRO_COMPONENT_USAGE_ID
TIME_SPAN_ID ADJUSTMENT_TYPE BUSINESS_GROUP_ID LEGISLATION_CODE |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
ELEMENT_SPAN_USAGE_ID | NUMBER | (9) | Yes | System-generated primary key column. |
BUSINESS_GROUP_ID | NUMBER | (15) | Foreign key to HR_ORGANIZATION_UNITS. | |
LEGISLATION_CODE | VARCHAR2 | (30) | Foreign Key to FND_TERRITORIES | |
TIME_SPAN_ID | NUMBER | (9) | Yes | Foreign key to PAY_TIME_SPANS |
RETRO_COMPONENT_USAGE_ID | NUMBER | (9) | Yes | Foreign key to PAY_RETRO_COMPONENT_USAGES |
ADJUSTMENT_TYPE | VARCHAR2 | (30) | Type of adjustment (Credit, Debit) | |
RETRO_ELEMENT_TYPE_ID | NUMBER | (9) | Yes | Foreign key to PAY_ELEMENT_TYPES_F |
CREATION_DATE | DATE | Yes | Standard who column - date when this row was created. | |
CREATED_BY | NUMBER | (15) | Yes | Standard who column - user who created this row (foreign key to FND_USER.USER_ID). |
LAST_UPDATE_DATE | DATE | Yes | Standard Who column - date when a user last updated this row. | |
LAST_UPDATED_BY | NUMBER | (15) | Yes | Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID). |
LAST_UPDATE_LOGIN | NUMBER | (15) | Yes | Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID). |
OBJECT_VERSION_NUMBER | NUMBER | (15) | System-generated version of row. Increments by one with each update. |
Cut, paste (and edit) the following text to query this object:
SELECT ELEMENT_SPAN_USAGE_ID
, BUSINESS_GROUP_ID
, LEGISLATION_CODE
, TIME_SPAN_ID
, RETRO_COMPONENT_USAGE_ID
, ADJUSTMENT_TYPE
, RETRO_ELEMENT_TYPE_ID
, CREATION_DATE
, CREATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_LOGIN
, OBJECT_VERSION_NUMBER
FROM HR.PAY_ELEMENT_SPAN_USAGES;
HR.PAY_ELEMENT_SPAN_USAGES does not reference any database object
HR.PAY_ELEMENT_SPAN_USAGES is referenced by following:
|
|
|