[Home] [Help] [Dependency Information]
Object Name: | HXT_EARNING_POLICIES |
---|---|
Object Type: | TABLE |
Owner: | HXT |
FND Design Data: | HXT.HXT_EARNING_POLICIES |
Subobject Name: | |
Status: | VALID |
An Earning Policy may be composed of more than one overtime rule, a
premium policy, and a premium processing policy. For each assignment,
an employee is defined with one of an unlimited number of earning
policies. Earning policies provide the means for performing detailed
overtime calculations using the methods defined by the user in the
overtime rules.
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
HXT_EARNING_POLICIES_PK | NORMAL | UNIQUE | APPS_TS_TX_IDX | ID |
HXT_EARNING_POLICIES_EGT_FK | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | EGT_ID |
HXT_EARNING_POLICIES_FK2 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | FCL_EARN_TYPE |
HXT_EARNING_POLICIES_FK4 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | PEP_ID |
HXT_EARNING_POLICIES_FK5 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | PIP_ID |
HXT_EARNING_POLICIES_HCL_FK | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | HCL_ID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
ID | NUMBER | (15) | Yes | System generated primary key for overtime policy |
HCL_ID | NUMBER | (15) | Yes | Holiday Calendars foreign key |
FCL_EARN_TYPE | VARCHAR2 | (30) | Yes | Type of Earnings Policy |
NAME | VARCHAR2 | (80) | Yes | Earning policy name |
EFFECTIVE_START_DATE | DATE | Yes | First effective date | |
PIP_ID | NUMBER | (15) | System generated unique ID | |
PEP_ID | NUMBER | (15) | System generated unique ID | |
EGT_ID | NUMBER | (15) | A system generated primary key for earning group type. | |
DESCRIPTION | VARCHAR2 | (255) | Earning policy description | |
EFFECTIVE_END_DATE | DATE | Yes | Last effective date | |
CREATED_BY | NUMBER | (15) | Standard Who column | |
CREATION_DATE | DATE | Standard Who column | ||
LAST_UPDATED_BY | NUMBER | (15) | Standard who column | |
LAST_UPDATE_DATE | DATE | Standard Who column | ||
LAST_UPDATE_LOGIN | NUMBER | (15) | Standard who column | |
ORGANIZATION_ID | NUMBER | (15) | Business Group ID | |
ROUND_UP | NUMBER | (2) | Yes | (0 - minutes minimum timecard interval) |
MIN_TCARD_INTVL | NUMBER | (2) | Yes | 0 - 59 minimum timecard interval |
BUSINESS_GROUP_ID | NUMBER | (15) | Foreign key to HR_ORGANIZATION_UNITS. | |
USE_POINTS_ASSIGNED | VARCHAR2 | (3) | Earnings Policy using Points to determine overtime calculation. |
Cut, paste (and edit) the following text to query this object:
SELECT ID
, HCL_ID
, FCL_EARN_TYPE
, NAME
, EFFECTIVE_START_DATE
, PIP_ID
, PEP_ID
, EGT_ID
, DESCRIPTION
, EFFECTIVE_END_DATE
, CREATED_BY
, CREATION_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN
, ORGANIZATION_ID
, ROUND_UP
, MIN_TCARD_INTVL
, BUSINESS_GROUP_ID
, USE_POINTS_ASSIGNED
FROM HXT.HXT_EARNING_POLICIES;
HXT.HXT_EARNING_POLICIES does not reference any database object
HXT.HXT_EARNING_POLICIES is referenced by following:
|
|
|