PAY — Payroll
323 documented tables · 1009 views — Oracle EBS ETRM 12.2.2
Most-referenced tables
| Table | Description | Data Vault class* |
|---|---|---|
PAY_COST_ALLOCATION_KEYFLEX |
Cost Allocation key flexfield combinations table. | hub-leaning |
PAY_ASSIGNMENT_ACTIONS |
Action or process results, showing which assignments have been processed by a specific payroll action, or proc | hub-leaning |
PAY_ELEMENT_CLASSIFICATIONS |
Element classifications for legislation and information needs. | hub |
PAY_PRE_PAYMENTS |
Pre-Payment details for an assignment, including the currency, the amount and the specific payment method. | hub-leaning |
PAY_ELEMENT_TEMPLATES |
Element Templates | hub |
PAY_EXTERNAL_ACCOUNTS |
Bank account details that enable payments to be made. | hub-leaning |
PAY_TEMPLATE_EXCLUSION_RULES |
Controls the exclusion of an object from an Element Template | hub |
PAY_US_STATES |
US states and their VERTEX geocodes, used to validate US addresses. | hub |
PAY_STAT_TRANS_AUDIT |
This table is used to store the history of a transaction to meet the statutory requirement. e.g. For US Locali | satellite-leaning |
PAY_US_COUNTIES |
US counties and their VERTEX geocodes, used to validate US addresses. | hub-leaning |
PAY_BALANCE_TYPES |
Balance information. | hub-leaning |
PAY_DEFINED_BALANCES |
Intersection between PAY_BALANCE_TYPES and PAY_BALANCE_DIMENSIONS. | hub |
PAY_TRIGGER_EVENTS |
Definitions of triggers that are dynamically generated | hub |
PAY_BALANCE_BATCH_HEADERS |
Batch header information for balance upload batch. | hub-leaning |
PAY_BALANCE_DIMENSIONS |
Information allowing the summation of a balance. | hub-leaning |
*Heuristic classification mined from FK structure — a modeling suggestion, not Oracle's.
Key public APIs
| Package | Class | Procedures | Used by |
|---|---|---|---|
PAY_ACTION_INFORMATION_API |
API | 3 | 140 packages |
PAY_ELEMENT_ENTRY_API |
API | 3 | 34 packages |
PAY_ELEMENT_TEMPLATE_API |
API | 5 | 26 packages |
PAY_SHADOW_ELEMENT_API |
API | 1 | 23 packages |
PAY_ELEMENT_EXTRA_INFO_API |
API | 3 | 21 packages |
PAY_BATCH_ELEMENT_ENTRY_API |
API | 9 | 21 packages |
PAY_STATE_TAX_RULE_API |
API | 3 | 9 packages |
PAY_USER_ROW_API |
API | 4 | 7 packages |
PAY_PPE_API |
API | 3 | 7 packages |
PAY_ELEMENT_TYPES_API |
API | 3 | 7 packages |