PQP Tables (30)
PQP - Public Sector Payroll — documented tables from Oracle EBS ETRM 12.2.2. Click any name for its documentation, columns and AI summary.
| Table | Columns | Description |
|---|---|---|
PQP_ALIEN_STATE_TREATIES_F |
12 | Table to store the State Alien treaty details. |
PQP_ALIEN_TRANSACTION_DATA |
57 | This table stores the Alien treaty analysis data transactions received from Third party vendors. |
PQP_ANALYZED_ALIEN_DATA |
26 | Table to store the analyzed alien data. |
PQP_ANALYZED_ALIEN_DETAILS |
31 | Table to store the analyzed alien details. |
PQP_ASSIGNMENT_ATTRIBUTES_F |
87 | PQP_ASSIGNMENT_ATTRIBUTES_F is the DateTracked table which holds a variety of information required by the public sector payroll product at a |
PQP_CONFIGURATION_MODULES |
13 | Table used to keep track of modules that has configuration values setup. |
PQP_CONFIGURATION_TYPES |
19 | Entity used to store the information types (configuration types) for each module stored in pqp_configuration_modules. Each row identifies on |
PQP_CONFIGURATION_VALUES |
53 | Table used for all generic configuration details, both seeded and user defined. |
PQP_EXCEPTION_REPORTS |
20 | Table to store the exception report definitions. This table contains both seeded and user defined exception reports based on a balance and d |
PQP_EXCEPTION_REPORTS_TL |
9 | Translation table to store the exception report definitions. |
PQP_EXCEPTION_REPORT_GROUPS |
14 | This table is used to group the exception report definitions so that multiple exception definitions can be run at once. |
PQP_EXCEPTION_REPORT_SUFFIX |
11 | Table to store the balance dimension database suffix and its equivalent reporting period. |
PQP_EXTRACT_ATTRIBUTES |
12 | Table to hold extra attributes of system extracts required for the Public Sector Payroll application. |
PQP_EXT_CROSS_PERSON_RECORDS |
17 | Table to hold cross person and cross busines group reporting related records used and maintained by Teachers Pension Extract Process. |
PQP_FLXDU_COLUMNS |
19 | This table is used to maintain all the fields for a HR entity types available in a spreadsheet. |
PQP_FLXDU_FUNC_ATTRIBUTES |
13 | This table is used to identify the functions that are created using the RIW setup. |
PQP_FLXDU_XML_TAGS |
10 | Table used to maintain all user defined XML tags for spreadsheet-supported fields |
PQP_GAP_ABSENCE_PLANS |
11 | This table is used to store the generic Absence Plans |
PQP_GAP_DAILY_ABSENCES |
16 | This table is used to store daily absence details like absence date, work pattern and the level of entitlement for an absence plan. |
PQP_GAP_DURATION_SUMMARY |
15 | |
PQP_PENSION_TYPES_F |
99 | This table is used to store the pension types. |
PQP_SERVICE_HISTORY_PERIODS |
62 | Table to hold information regarding relevant perids of previous employment. |
PQP_VEHICLE_ALLOCATIONS_F |
69 | Table used to keep track of the association of a vehicle to an assignment. |
PQP_VEHICLE_DETAILS |
67 | Table to store the vehicle details including private and company vehicles. This table has been superseded by PQP_VEHICLE_REPOSITORY_F which |
PQP_VEHICLE_DETAILS_EFC |
7 | Table used for the EFC conversion of the PQP_VEHICLE_DETAILS. |
PQP_VEHICLE_REPOSITORY_F |
87 | This table is used to store the vehicle details. |
PQP_VEH_ALLOC_EXTRA_INFO |
65 | This entity is used to store any extra information regarding a Vehicle Allocation. This is an intersection table between PQP_VEHICLE_ALLOCAT |
PQP_VEH_ALLOC_INFO_TYPES |
12 | Entity used to store the information types for vehicle allocation extra information. |
PQP_VEH_REPOS_EXTRA_INFO |
65 | This entity is used to store any extra information regarding a Vehicle. This is an intersection table between PQP_VEHICLE_REPOSITORY_F and P |
PQP_VEH_REPOS_INFO_TYPES |
12 | Entity used to store the information types for Vehicle Repository Extra information. |