PQP — Public Sector Payroll
30 documented tables · 10 views — Oracle EBS ETRM 12.2.2
Most-referenced tables
| Table | Description | Data Vault class* |
|---|---|---|
PQP_GAP_ABSENCE_PLANS |
This table is used to store the generic Absence Plans | hub-leaning |
PQP_ANALYZED_ALIEN_DATA |
Table to store the analyzed alien data. | hub-leaning |
PQP_VEHICLE_REPOSITORY_F |
This table is used to store the vehicle details. | standalone |
PQP_EXTRACT_ATTRIBUTES |
Table to hold extra attributes of system extracts required for the Public Sector Payroll application. | standalone |
PQP_PENSION_TYPES_F |
This table is used to store the pension types. | standalone |
PQP_VEH_REPOS_EXTRA_INFO |
This entity is used to store any extra information regarding a Vehicle. This is an intersection table between | standalone |
PQP_GAP_DAILY_ABSENCES |
This table is used to store daily absence details like absence date, work pattern and the level of entitlement | satellite-leaning |
PQP_ALIEN_STATE_TREATIES_F |
Table to store the State Alien treaty details. | standalone |
PQP_GAP_DURATION_SUMMARY |
standalone | |
PQP_VEH_REPOS_INFO_TYPES |
Entity used to store the information types for Vehicle Repository Extra information. | standalone |
PQP_VEHICLE_ALLOCATIONS_F |
Table used to keep track of the association of a vehicle to an assignment. | standalone |
PQP_ALIEN_TRANSACTION_DATA |
This table stores the Alien treaty analysis data transactions received from Third party vendors. | standalone |
PQP_VEHICLE_DETAILS_EFC |
Table used for the EFC conversion of the PQP_VEHICLE_DETAILS. | standalone |
PQP_FLXDU_XML_TAGS |
Table used to maintain all user defined XML tags for spreadsheet-supported fields | standalone |
PQP_FLXDU_FUNC_ATTRIBUTES |
This table is used to identify the functions that are created using the RIW setup. | standalone |
*Heuristic classification mined from FK structure — a modeling suggestion, not Oracle's.
Key public APIs
| Package | Class | Procedures | Used by |
|---|---|---|---|
PQP_VEHICLE_REPOSITORY_API |
API | 3 | 6 packages |
PQP_VEHICLE_ALLOCATIONS_API |
API | 3 | 3 packages |
PQP_VEH_REPOS_EXTRA_INFO_API |
API | 3 | 3 packages |
PQP_VEH_ALLOC_EXTRA_INFO_API |
API | 3 | 3 packages |
PQP_AAT_API |
API | 3 | 3 packages |
PQP_EXR_API |
API | 3 | 2 packages |
PQP_ERG_API |
API | 4 | 1 packages |
PQP_ANALYZED_ALIEN_DATA_API |
API | 4 | 1 packages |
PQP_ALIEN_TRANS_DATA_API |
API | 4 | 1 packages |
PQP_PCV_API |
API | 3 | 1 packages |