PSP — Labor Distribution
86 documented tables · 179 views — Oracle EBS ETRM 12.2.2
Most-referenced tables
| Table | Description | Data Vault class* |
|---|---|---|
PSP_EFFORT_REPORT_TEMPLATES |
Contains effort report criteria and template information | satellite-leaning |
PSP_ENC_CONTROLS |
Stores one record for each time period batch | hub-leaning |
PSP_EFFORT_REPORTS |
Contains effort reports for employees for a specified time period | hub-leaning |
PSP_ENC_SUMMARY_LINES |
Stores summary of all summarized encumbrance lines | hub-leaning |
PSP_ENC_PAYROLLS |
Stores encumbrance related payrolls | hub-leaning |
PSP_AUTO_ACCTS |
Stores one record for every auto-population expenditure type and General Ledger account segment having defined | satellite-leaning |
PSP_PAYROLL_SUB_LINES |
Contains information where payroll amount in a payroll line is split into more than one subline | satellite-leaning |
PSP_ELEMENT_TYPES |
Stores element types imported from Oracle HRMS | hub-leaning |
PSP_REPORT_TEMPLATES |
Stores details of Effort report template | hub-leaning |
PSP_REPORT_PERIOD_FREQUENCY_B |
Stores user defined or seeded period frequencies used in effort report templates. | hub-leaning |
PSP_REPORT_TEMPLATES_H |
Stores history details of Effort report template | hub-leaning |
PSP_PAYROLL_CONTROLS |
Contains information for all imported payroll transactions | hub-leaning |
PSP_PAYROLL_LINES |
Contains information on each payroll line imported from Oracle Payroll and non-Oracle payroll sources | satellite-leaning |
PSP_EFFORT_REPORT_PERIODS |
Contains predefined standard period names | hub-leaning |
PSP_SUMMARY_LINES |
Stores summarized distribution lines | satellite-leaning |
*Heuristic classification mined from FK structure — a modeling suggestion, not Oracle's.
Key public APIs
| Package | Class | Procedures | Used by |
|---|---|---|---|
PSP_EXTERNAL_EFFORT_LINES_API |
API | 3 | 3 packages |
PSP_EFF_REPORT_DETAILS_API |
API | 1 | 2 packages |
PSP_REPORT_TEMPLATE_API |
API | 3 | 1 packages |
PSP_TEMPLATE_DETAILS_API |
API | 3 | 1 packages |
PSP_SALARY_CAP_OVERRIDES_API |
API | 3 | 1 packages |
PSP_ORGANIZATION_ACCOUNTS_API |
API | 3 | 1 packages |
PSP_EFF_REPORT_APPROVALS_API |
API | 3 | 1 packages |
PSP_SALARY_CAPS_API |
API | 4 | 1 packages |
PSP_PERIOD_FREQUENCY_API |
API | 3 | 1 packages |