HXT — Time and Labor
36 documented tables · 72 views — Oracle EBS ETRM 12.2.2
Most-referenced tables
| Table | Description | Data Vault class* |
|---|---|---|
HXT_HOLIDAY_CALENDARS |
Details of holiday calendar defined. | hub-leaning |
HXT_EARN_GROUP_TYPES |
Details of earning Group Types defined. | hub-leaning |
HXT_PREM_INTERACT_POLICIES |
Details of the premiums which are used to obtain a premium rate. | hub-leaning |
HXT_PREM_ELIGBLTY_POLICIES |
Details of eligible premiums which may be paid on each base earning. | hub-leaning |
HXT_SHIFT_DIFF_POLICIES |
A location to put company shift differential policies. | hub-leaning |
HXT_HOUR_DEDUCT_POLICIES |
Details of user defined hour deduction policies. | hub-leaning |
HXT_EARNING_POLICIES |
Details of earning policies | satellite-leaning |
HXT_PROJECTS |
Details of user defined projects. | hub-leaning |
HXT_WEEKLY_WORK_SCHEDULES |
A location to put a company's various employee work plans. | hub-leaning |
HXT_ROTATION_PLANS |
A Rotation plan composed of many work plans starting at specified dates. | hub-leaning |
HXT_SHIFTS |
Defines company shifts based on a twenty-four clock. | hub-leaning |
HXT_ROTATION_SCHEDULES |
Details of rotating work plan schedules. | link |
HXT_HOLIDAY_DAYS_TL |
Contains the translated user defined holiday days. | standalone |
HXT_TASKS_EFC |
standalone | |
HXT_PREM_ELIGBLTY_RULES |
Details of the user defined Premium Eligibility Rules. | satellite-leaning |
*Heuristic classification mined from FK structure — a modeling suggestion, not Oracle's.
Key public APIs
| Package | Class | Procedures | Used by |
|---|---|---|---|
HXT_TIMECARD_API |
API | 3 | 0 packages |