HXC Tables (131)
HXC - Time and Labor Engine — documented tables from Oracle EBS ETRM 12.2.2. Click any name for its documentation, columns and AI summary.
| Table | Columns | Description |
|---|---|---|
HXC_ABSENCE_SUMMARY_TEMP |
5 | HXC_ABSENCE_SUMMARY_TEMP |
HXC_ABSENCE_TYPE_ELEMENTS |
5 | HXC_ABSENCE_TYPE_ELEMENTS |
HXC_ABSENCE_TYPE_ELEMENTS_TEMP |
8 | HXC_ABSENCE_TYPE_ELEMENTS_TEMP |
HXC_ABS_CO_DETAILS |
19 | HXC_ABS_CO_DETAILS |
HXC_ABS_RET_TEMP |
15 | |
HXC_ALIAS_DEFINITIONS |
15 | Alternate Name Definitions |
HXC_ALIAS_DEFINITIONS_TL |
12 | Translated Alternate Name Definitions |
HXC_ALIAS_TYPES |
10 | HXC_ALIAS_TYPES holds the alternate name types. These types could be based on a DDF context defintion or a value set. |
HXC_ALIAS_TYPE_COMPONENTS |
12 | HXC_ALIAS_TYPE_COMPONENTS holds the alternate name type component. These component are link to an alternate name type but also to a mapping |
HXC_ALIAS_VALUES |
44 | Alternate name components |
HXC_ALIAS_VALUES_TL |
10 | Translated Alternate name components |
HXC_APPROVAL_COMPS |
21 | Approval Components |
HXC_APPROVAL_PERIOD_COMPS |
11 | Approval Period Components |
HXC_APPROVAL_PERIOD_SETS |
9 | Approval Period Sets |
HXC_APPROVAL_STYLES |
15 | Approval Styles |
HXC_APP_COMP_NOTIFICATIONS |
12 | HXC_APP_COMP_NOTIFICATIONS |
HXC_APP_COMP_NOTIF_USAGES |
5 | Application Component Notification Usage Table |
HXC_APP_PERIOD_SUMMARY |
18 | Application period summary table |
HXC_APP_PERIOD_SUMMARY_AR |
18 | Application period summary archive table |
HXC_AP_DETAIL_LINKS |
3 | Application period detail links |
HXC_AP_DETAIL_LINKS_AR |
3 | Application period detail links archive table |
HXC_ARCHIVE_TEMP |
4 | |
HXC_AR_DETAIL_LOG |
5 | For Multi-threaded A&R |
HXC_AR_TC_IDS_TEMP |
25 | For Multi-threaded A&R |
HXC_AR_TRANS_TEMP |
4 | For Multi-threaded A&R |
HXC_BEE_PREF_ADJ_LINES |
18 | Temp table for Xfer time from OTL to BEE |
HXC_BLD_BLK_INFO_TYPES |
42 | Build Block Information Types |
HXC_BLD_BLK_INFO_TYPE_USAGES |
9 | Build Block Information Type Usages |
HXC_DATA_APP_RULE_USAGES |
11 | Data Approval Rule Usages |
HXC_DATA_SETS |
13 | HXC_DATA_SETS |
HXC_DATA_SET_DETAILS |
9 | HXC_DATA_SET_DETAILS |
HXC_DEBUG |
2 | Debug |
HXC_DEBUG_TEXT |
3 | Debug Text |
HXC_DEPOSIT_PROCESSES |
11 | Deposit Processes |
HXC_DEP_TRANSACTIONS |
14 | Transactions |
HXC_DEP_TRANSACTIONS_AR |
14 | Deposit Transactions Archive |
HXC_DEP_TRANSACTION_DETAILS |
13 | Deposit Transaction Details |
HXC_DEP_TXN_DETAILS_AR |
13 | Deposit Transaction Details Archive |
HXC_ENTITY_GROUPS |
13 | Entity Groups |
HXC_ENTITY_GROUP_COMPS |
42 | Entity Group Components |
HXC_ERRORS |
19 | hxc_errors |
HXC_LATEST_DETAILS |
12 | Summary table containing the latest version of a DETAIL scope building block |
HXC_LAYOUTS |
14 | Layouts |
HXC_LAYOUTS_TL |
10 | Translated Layouts |
HXC_LAYOUT_COMPONENTS |
26 | Layout Components |
HXC_LAYOUT_COMP_DEFINITIONS |
11 | Layout Component Definitions |
HXC_LAYOUT_COMP_PROMPTS |
15 | Layout Component Prompts |
HXC_LAYOUT_COMP_QUALIFIERS |
41 | Layout Component Qualifiers |
HXC_LAYOUT_COMP_QUAL_RULES |
12 | Layout Component Qualifier Rules |
HXC_LOCKER_TYPES |
9 | HXC_LOCKER_TYPES holds the locker type components. |
HXC_LOCKING_RULES |
9 | HXC_LOCKING_RULES holds the locking rules components. |
HXC_LOCKS |
40 | HXC_LOCKS holds the locks components. |
HXC_MAPPINGS |
9 | Mappings |
HXC_MAPPING_COMPONENTS |
12 | Mapping Components |
HXC_MAPPING_COMP_USAGES |
10 | Mapping Component Usages |
HXC_PAY_LATEST_DETAILS |
22 | Holds payroll apps specific details |
HXC_PA_LATEST_DETAILS |
22 | Holds Projects apps specific details |
HXC_PREF_DEFINITIONS |
9 | Preference Definitions |
HXC_PREF_HIERARCHIES |
51 | Preference Hierarchies |
HXC_RDB_LOGINS |
5 | Manages concurrent logins |
HXC_RDB_PENDING_PROCESSES |
5 | Used for Retrieval Dashboard Post Tab |
HXC_RDB_POST_ATTRIBUTES |
9 | Used for Retrieval Dashboard Post Tab |
HXC_RDB_POST_BATCHES |
5 | Used for Retrieval Dashboard Post Tab |
HXC_RDB_POST_DETAILS |
23 | Used for Retrieval Dashboard Post Tab |
HXC_RDB_POST_DIST_TIMECARDS |
5 | Used for Retrieval Dashboard Post Tab |
HXC_RDB_POST_HRS_PM |
6 | Used for Retrieval Dashboard Post Tab |
HXC_RDB_POST_ORG_JOB |
5 | Used for Retrieval Dashboard Post Tab |
HXC_RDB_POST_PARTIAL_TIMECARDS |
5 | Used for Retrieval Dashboard Post Tab |
HXC_RDB_POST_PAYROLL_EXP_TYPE |
5 | Used for Retrieval Dashboard Post Tab |
HXC_RDB_POST_TC_DETAILS |
18 | Used in Retrieval Dashboard Processing |
HXC_RDB_POST_TIMECARDS |
15 | Used for Retrieval Dashboard Post Tab |
HXC_RDB_PRE_ATTRIBUTES |
8 | Used for Retrieval Dashboard Pre Retrieval |
HXC_RDB_PRE_DETAILS |
13 | Used for Retrieval Dashboard Pre Retrieval |
HXC_RDB_PRE_HRS_PM |
6 | Used for Retrieval Dashboard Pre Retrieval |
HXC_RDB_PRE_SKIPPED |
8 | Used for Retrieval Dashboard Pre Retrieval |
HXC_RDB_PRE_STATUS |
3 | Used for Retrieval Dashboard Pre Retrieval |
HXC_RDB_PRE_TC_DETAILS |
12 | Used for Retrieval Dashboard Pre Retrieval |
HXC_RDB_PRE_TIMECARDS |
13 | Used for Retrieval Dashboard Pre Retrieval |
HXC_RDB_PRE_UPDATED |
6 | Used for Retrieval Dashboard Pre Retrieval |
HXC_RDB_PROCESSES |
8 | Used for Retrieval Dashboard Processing |
HXC_RDB_PROCESS_DETAILS |
10 | Used for Retrieval Dashboard Processing |
HXC_RDB_PROCESS_TIMECARDS |
10 | Used for Retrieval Dashboard Processing |
HXC_RECURRING_PERIODS |
13 | Recurring Periods |
HXC_RESOURCE_RULES |
18 | Resource Rules |
HXC_RETRIEVAL_PROCESSES |
11 | Retrieval Processes |
HXC_RETRIEVAL_RANGES |
14 | Retrieval Ranges |
HXC_RETRIEVAL_RANGE_RESOURCES |
2 | Contains resources for each HXC_RETRIEVAL_RANGE. |
HXC_RETRIEVAL_RULES |
10 | Retrieval Rules |
HXC_RETRIEVAL_RULE_COMPS |
11 | Retrieval Rule Components |
HXC_RET_PAY_LATEST_DETAILS |
36 | Used for Retrieval Dashboard Post Tab |
HXC_RET_PA_LATEST_DETAILS |
26 | Used for Retrieval Dashboard Post Tab |
HXC_RPT_LAYOUT_COMP_QUERIES |
5 | Layout components and the queries associated for translation |
HXC_RPT_TC_AUDIT |
21 | Temp table for Timecard Audit Trail report |
HXC_RPT_TC_DETAILS_ALL |
62 | Detail table for all detail information, for reporting |
HXC_RPT_TC_HIST_LOG |
5 | Log of all timecard snapshots created |
HXC_RPT_TC_RESOURCE_TEMP |
10 | HXC_RPT_TC_RESOURCE_TEMP |
HXC_RPT_VO_ALL |
5 | Master list of all seeded VOs and queries associated |
HXC_SEEDDATA_BY_LEVEL |
10 | Seed Data Level |
HXC_TCD_TMP_RPT |
23 | Reference table for Timecard Dashboard |
HXC_TC_AP_LINKS |
2 | Timecard Application Period Links |
HXC_TC_AP_LINKS_AR |
2 | Timecard Application Period Links Archive table |
HXC_TEMPLATE_SUMMARY |
13 | Template Summary Table |
HXC_TEMP_TIMECARDS |
5 | Temporary Timecards for Summary Migration |
HXC_TEMP_TIMECARD_CHUNKS |
8 | Temporary Storage for Archiving and Restoring Timecards |
HXC_TIMECARD_SUMMARY |
50 | Timecard summary |
HXC_TIME_ATTRIBUTES |
36 | Time Attributes - attributes for a building block |
HXC_TIME_ATTRIBUTES_AR |
36 | Time Attributes Archive |
HXC_TIME_ATTRIBUTES_BK |
38 | Backup of HXC_TIME_ATTRIBUTES during consolidation |
HXC_TIME_ATTRIBUTES_EFC |
33 | EFC Shadow Table for hxc_time_attributes |
HXC_TIME_ATTRIBUTE_USAGES |
11 | Time Attribute Usages |
HXC_TIME_ATTRIBUTE_USAGES_AR |
11 | Time Attribute Usages Archive |
HXC_TIME_ATTRIBUTE_USAGES_BK |
13 | Time Attribute Usages |
HXC_TIME_BUILDING_BLOCKS |
25 | Time Building Blocks |
HXC_TIME_BUILDING_BLOCKS_AR |
25 | Time Building Blocks Archive |
HXC_TIME_CATEGORIES |
13 | Time Categories |
HXC_TIME_CATEGORY_COMPS |
18 | Time Category Components |
HXC_TIME_CATEGORY_COMP_SQL |
3 | Time Category Component SQLs Table |
HXC_TIME_ENTRY_RULES |
48 | Time Entry Rules |
HXC_TIME_RECIPIENTS |
17 | Time Recipients |
HXC_TIME_SOURCES |
9 | Time Sources |
HXC_TK_DETAIL_TEMP |
84 | |
HXC_TK_GROUPS |
10 | Timekeeper Groups |
HXC_TK_GROUP_QUERIES |
11 | Timekeeper Group Queries |
HXC_TK_GROUP_QUERY_CRITERIA |
10 | Timekeeper Group Query Criteria |
HXC_TK_TIMEKEEPER_SUBMITS |
2 | TimeKeeper Submits Table |
HXC_TRANSACTIONS |
14 | Retrieval Transactions |
HXC_TRANSACTIONS_AR |
14 | Retrieval Transactions Archive |
HXC_TRANSACTION_DETAILS |
13 | Retrieval Transaction Details |
HXC_TRANSACTION_DETAILS_AR |
13 | Retrieval Transaction Details Archive |
HXC_UPGRADE_DEFINITIONS |
4 | Used in Generic Upgrade |
HXC_UPGRADE_STATUS |
3 | Used in Generic Upgrade |