HXT Tables (36)
HXT - Time and Labor — documented tables from Oracle EBS ETRM 12.2.2. Click any name for its documentation, columns and AI summary.
| Table | Columns | Description |
|---|---|---|
HXC_TEMP_TCD |
28 | |
HXT_ADD_ASSIGN_INFO_F |
45 | Details of time information associated with person's assignments. |
HXT_ADD_ELEM_INFO_F |
49 | Details of time information which are associated with elements. |
HXT_BATCH_STATES |
3 | Details of the batch status of timecards. |
HXT_DET_HOURS_WORKED_F |
50 | Describes a specific block of time worked for a specific date. |
HXT_EARNING_POLICIES |
20 | Details of earning policies |
HXT_EARNING_RULES |
15 | Description of earning rules |
HXT_EARN_GROUPS |
7 | Details of earn groups defined. |
HXT_EARN_GROUP_TYPES |
11 | Details of earning Group Types defined. |
HXT_ERRORS_F |
18 | Details of errors produced. |
HXT_HOLIDAY_CALENDARS |
12 | Details of holiday calendar defined. |
HXT_HOLIDAY_DAYS |
10 | Details of user defined holiday days. |
HXT_HOLIDAY_DAYS_TL |
9 | Contains the translated user defined holiday days. |
HXT_HOUR_DEDUCTION_RULES |
11 | Details of user defined hours dedurules. |
HXT_HOUR_DEDUCT_POLICIES |
11 | Details of user defined hour deduction policies. |
HXT_PREM_ELIGBLTY_POLICIES |
10 | Details of eligible premiums which may be paid on each base earning. |
HXT_PREM_ELIGBLTY_POL_RULES |
9 | Determines the premiums which a group of people are eligible to. |
HXT_PREM_ELIGBLTY_RULES |
10 | Details of the user defined Premium Eligibility Rules. |
HXT_PREM_INTERACT_POLICIES |
10 | Details of the premiums which are used to obtain a premium rate. |
HXT_PREM_INTERACT_POL_RULES |
9 | Details of the user defined rules for Premium Interaction Policies. |
HXT_PREM_INTERACT_RULES |
11 | Details of the rules which govern the premium interactions. |
HXT_PREV_WAGE_BASE |
13 | Details of prevailing ge rate base. |
HXT_PROJECTS |
12 | Details of user defined projects. |
HXT_ROTATION_PLANS |
10 | A Rotation plan composed of many work plans starting at specified dates. |
HXT_ROTATION_SCHEDULES |
8 | Details of rotating work plan schedules. |
HXT_SHIFTS |
16 | Defines company shifts based on a twenty-four clock. |
HXT_SHIFT_DIFF_POLICIES |
10 | A location to put company shift differential policies. |
HXT_SHIFT_DIFF_RULES |
14 | Details of the time range which includes separate pay rules for a specific shift. |
HXT_SUM_HOURS_WORKED_F |
74 | A summary of the number hours and type of premium related to each hour worked by a person. |
HXT_TASKS |
14 | A divided project assigned to an employee. |
HXT_TIMECARDS_F |
49 | Details of the hours which an employee works in a payroll period. |
HXT_TIMECLOCK_ERRORS |
61 | HXT_TIMECLOCK_ERRORS contains error messages displayed during the HXT API upload |
HXT_UPGRADE_BG_MESSAGES |
2 | |
HXT_VARIANCES |
19 | A location to put earning variance thresholds (highs and lows). |
HXT_WEEKLY_WORK_SCHEDULES |
12 | A location to put a company's various employee work plans. |
HXT_WORK_SHIFTS |
13 | A location to put an employee's work shifts on which all earnings are based. |