Oracle eBusiness Suite Technical Reference

Release 11i - Copyright (c) 2001 - 2005 Oracle

This Technical Reference Manual (TRM) in any form, software or printed matter, contains proprietary information of Oracle ; it is provided under an Oracle agreement containing restrictions on use and disclosure and is also protected by copyright, patent, and other intellectual property law. Restrictions applicable to this TRM include, but are not limited to: (a) exercising either the same degree of care to safeguard the confidentiality of this TRM as you exercise to safeguard the confidentiality of your own most important Confidential Information or a reasonable degree of care, whichever is greater; (b) maintaining agreements with your employees and agents that protect the Confidential Information of third parties such as Oracle and instructing such employees and agents of these requirements for this TRM; (c) restricting disclosure of this TRM to those of your employees who have a 'need to know' consistent with the purposes for which this TRM was disclosed to you; (d) maintaining this TRM at all times on your premises; (e) not removing or destroying any proprietary or confidential legends or markings placed upon this TRM in whatever form, software or printed matter; and (f) not reproducing or transmitting this TRM in any form or by any means, electronic or mechanical, for any purpose, without the express written permission of Oracle. You should not use this TRM in any form, software or printed matter, to create software that performs the same or similar functions as any Oracle products.

The information in this TRM is subject to change without notice. If you find any problems in the TRM in any form, software or printed matter, please report them to us in writing. Oracle does not warrant that this TRM is error free. This TRM is provided to customer 'as is' with no warranty of any kind. This TRM does not constitute Documentation as that term is defined in Oracle's agreements. Reverse engineering of the Programs (software and documentation) associated with this TRM are prohibited. The Programs associated with this TRM are not intended for use in any nuclear, aviation, mass transit, medical, or other inherently dangerous applications. It shall be licensee's responsibility to take all appropriate fail safe, backup, redundancy and other measures to ensure the safe use of such applications if the Programs are used for such purposes, and Oracle disclaims liability for any damages caused by such use of the Programs. Program Documentation is licensed for use solely to support the deployment of the Programs and not for any other any other purpose. Restricted Rights Legend

This TRM and the Programs associated with this TRM delivered subject to the DOD FAR Supplement are 'commercial computer software' and use, duplication and disclosure of the TRM and the Programs associated with this TRM shall be subject to the licensing restrictions set forth in the applicable Oracle license agreement. Otherwise, this TRM and the Programs associated with this TRM delivered subject to the Federal Acquisition Regulations are 'restricted computer software' and use, duplication and disclosure of the TRM and the Programs associated with this TRM shall be subject to the restrictions in FAR 52.227-14, Rights in Data General, including Alternate III (June 1987). Oracle, 500 Oracle Parkway, Redwood City, CA 94065.

Oracle is a registered trademark. AIM Advantage™, Big Business. Small Business. All Business.™, CDM Advantage™, .comference™, ConText®, Des40®, Easy*Query™, Easy*SQL®, Education Objects™, EMM Advantage™, Enabling the Information Age®, ExpertDetectSM, Express®, FastForwardSM, GEMMS®, Gist™, Hyper*SQL™, instantOracle™, "Internet Business Intelligence - Insight for Everyone"™, iSQL*Plus™, JInitiator™, NLS*Workbench®, Object Marketplace™, ODP Pulse™, ODP Techwire™, OLA™, On Oracle™, Oracle®, Oracle Book®, Oracle Bookbatch®, Oracle BookBuilder®, OracleBRONZE®, Oracle Business OnLine®, OracleDevConnectSM, Oracle® Discoverer™, Oracle® Expert™, Oracle Financials®, OracleGOLDSM, OracleIncidentSM, OracleJSP™, OracleLifeCycleSM, Oracle Media Objects®, OracleMERCURYSM, OracleMetaLinkSM, OraclemetalsSM, OracleMobile™, Oracle Names®, Oracle NetSolutions®, Oracle® One™, Oracle Open Gateways®, Oracle OpenWorld®, OraclePLATINUMSM, Oracle Power Objects®, Oracle Press®, Oracle Procedural Gateway®, Oracle Quality®, Oracle Secure Network Services®, OracleSILVERSM, Oracle® SQL/Services™, Oracle® SQL*TutorSM, OracleSTERLINGSM, Oracle Store®, Oracle Transparent Gateway®, OracleWare®, Oracle8i™, Oracle9i™, PC Express®, Personal Express®, PJM Advantage™, PL/SQL™, Pro*Ada®, Pro*C™, Pro*C/C++™, Pro*COBOL®, Pro*FORTRAN®, Pro*Pascal®, Pro*PL/1®, Pro*REXX®, Profit™, ProREXX™, Report Card™, Secure Access 2.0™, Secure Network Services®, Security Without Compromise™, SellingPoint®, SQL*Plus®, Tutor™ are trademarks or registered trademarks of Oracle. Other names may be trademarks of their respective owners. The absence of a product or service name, slogan, or logo from this list does not constitute a waiver of Oracle's trademark or other intellectual property rights concerning that name, slogan, or logo.

eTRM - PQP Tables and Views

TABLE - HR.PQP_ALIEN_STATE_TREATIES_F
TABLE - HR.PQP_ALIEN_TRANSACTION_DATA
TABLE - HR.PQP_ANALYZED_ALIEN_DATA
TABLE - HR.PQP_ANALYZED_ALIEN_DETAILS
TABLE - HR.PQP_ASSIGNMENT_ATTRIBUTES_F
TABLE - HR.PQP_CONFIGURATION_MODULES
TABLE - HR.PQP_CONFIGURATION_TYPES
TABLE - HR.PQP_CONFIGURATION_VALUES
TABLE - HR.PQP_EXCEPTION_REPORTS
TABLE - HR.PQP_EXCEPTION_REPORTS_TL
TABLE - HR.PQP_EXCEPTION_REPORT_GROUPS
TABLE - HR.PQP_EXCEPTION_REPORT_SUFFIX
TABLE - HR.PQP_EXTRACT_ATTRIBUTES
TABLE - HR.PQP_EXT_CROSS_PERSON_RECORDS
TABLE - HR.PQP_FLXDU_COLUMNS
TABLE - HR.PQP_FLXDU_FUNC_ATTRIBUTES
TABLE - HR.PQP_FLXDU_XML_TAGS
TABLE - HR.PQP_GAP_ABSENCE_PLANS
TABLE - HR.PQP_GAP_DAILY_ABSENCES
TABLE - HR.PQP_GAP_DURATION_SUMMARY
TABLE - HR.PQP_PENSION_TYPES_F
TABLE - HR.PQP_SERVICE_HISTORY_PERIODS
TABLE - HR.PQP_VEHICLE_ALLOCATIONS_F
TABLE - HR.PQP_VEHICLE_DETAILS
TABLE - HR.PQP_VEHICLE_DETAILS_EFC
TABLE - HR.PQP_VEHICLE_REPOSITORY_F
TABLE - HR.PQP_VEH_ALLOC_EXTRA_INFO
TABLE - HR.PQP_VEH_ALLOC_INFO_TYPES
TABLE - HR.PQP_VEH_REPOS_EXTRA_INFO
TABLE - HR.PQP_VEH_REPOS_INFO_TYPES
VIEW - APPS.PQP_ASSIGNMENT_ATTRIBUTES_D
VIEW - APPS.PQP_ASSIGNMENT_ATTRIBUTES_V
VIEW - APPS.PQP_GB_PENSION_SCHEMES_V
VIEW - APPS.PQP_GB_PENSION_TEMPLATE_V
VIEW - APPS.PQP_GB_STAKEHOLDER_TEMPLATE_V
VIEW - APPS.PQP_OMP_TEMPLATE_V
VIEW - APPS.PQP_OSP_TEMPLATE_V
VIEW - APPS.PQP_PROFESSIONAL_BODY_TEMP_V
VIEW - APPS.PQP_UNION_TEMPLATE_V
VIEW - APPS.PQP_VEHICLE_TEMPLATE_V

Table: PQP_ALIEN_STATE_TREATIES_F

Description: Table to store the State Alien treaty details.
Primary Key: PQP_ALIEN_STATE_TREATIES_FK
  1. STATE_CODE
  2. EFFECTIVE_START_DATE
  3. EFFECTIVE_END_DATE
Primary Key: PQP_ALIEN_STATE_TREATIES_PK
  1. ALIEN_STATE_TREATY_INFO_ID
  2. EFFECTIVE_START_DATE
  3. EFFECTIVE_END_DATE
Comments

All the individual states are listed with the information whether they honor the Alien treaty.

Indexes
Index Type Tablespace Column
PQP_ALIEN_STATE_TREATIES_UK UNIQUE APPS_TS_SEED STATE_CODE
EFFECTIVE_START_DATE
EFFECTIVE_END_DATE
Columns
Name Datatype Length Mandatory Comments
ALIEN_STATE_TREATY_INFO_ID NUMBER (15) Y System generated primary key column
EFFECTIVE_START_DATE DATE
Y Effective start date
EFFECTIVE_END_DATE DATE
Y Effective end date.
STATE_CODE VARCHAR2 (30) Y Two letter state code.
TREATY_HONORED_FLAG VARCHAR2 (30) Y Y/N flag to denote whether the treaty is honored.
LAST_UPDATED_BY NUMBER (15)
Standard WHO column
LAST_UPDATE_DATE DATE

Standard WHO column
LAST_UPDATE_LOGIN NUMBER (15)
Standard WHO column
CREATED_BY NUMBER (15) Y Standard WHO column
CREATION_DATE DATE
Y Standard WHO column
OBJECT_VERSION_NUMBER NUMBER (15) Y System generated version of row. Increments by one with each update.

[top of page]

HR.PQP_ALIEN_STATE_TREATIES_F does not reference any database object

HR.PQP_ALIEN_STATE_TREATIES_F is referenced by following:

APPS
SYNONYM - PQP_ALIEN_STATE_TREATIES_F
TRIGGER - PQP_ALIEN_STATE_TREATIES_F_WHO
PUBLIC
SYNONYM - PQP_ALIEN_STATE_TREATIES_F

[top of page]

Table: PQP_ALIEN_TRANSACTION_DATA

Description: This table stores the Alien treaty analysis data transactions received from Third party vendors.
Primary Key: PQP_ALIEN_TRANSACTION_DATA_PK
  1. ALIEN_TRANSACTION_ID
Comments

This table stores the Alien treaty analysis data transactions received from Third party vendors.

Primary Key: PQP_ALIEN_TRANSACTION_DATA_PK
  1. ALIEN_TRANSACTION_ID
Indexes
Index Type Tablespace Column
PQP_ALIEN_TRANSACTION_DATA_PK UNIQUE APPS_TS_TX_IDX ALIEN_TRANSACTION_ID
Columns
Name Datatype Length Mandatory Comments
ALIEN_TRANSACTION_ID NUMBER (15) Y System generated primary key column
DATA_SOURCE_TYPE VARCHAR2 (30) Y Name of the third pary that is giving the analyzed data for Alien employees.
TAX_YEAR NUMBER (5)
The tax year for which the data is applicable.
INCOME_CODE VARCHAR2 (30) Y The income code for which the treaty details belong to.
WITHHOLDING_RATE NUMBER (11)
The FIT withholding rate for the Alien earning.
INCOME_CODE_SUB_TYPE VARCHAR2 (30)
The sub type for the income, if applicable
EXEMPTION_CODE VARCHAR2 (30)
Excemption code for the alien income.
MAXIMUM_BENEFIT_AMOUNT NUMBER (11)
Maximum benefit amount for which the tax is not taken.
RETRO_LOSE_BEN_AMT_FLAG VARCHAR2 (30)
Identifies whether the employee loses treaty benefits retroactively if they earn more than the maximum benefit amount.
DATE_BENEFIT_ENDS DATE

The date on which the benefit ends.
RETRO_LOSE_BEN_DATE_FLAG VARCHAR2 (30)
Identifies whether the employee loses treaty benefits retroactively if they continue to stay beyond the date benefit ends date.
CURRENT_RESIDENCY_STATUS VARCHAR2 (30)
Identifies the current status as resident or non resident.
NRA_TO_RA_DATE DATE

The date on which the employee becomes a resident from a non-resident.
TARGET_DEPARTURE_DATE DATE

The date on which the employee is scheduled to leave the country.
TAX_RESIDENCE_COUNTRY_CODE VARCHAR2 (30)
The two letter tax residence code.
TREATY_INFO_UPDATE_DATE DATE

The date on which the Alien treaty was updated.
NRA_EXEMPT_FROM_FICA VARCHAR2 (30)
Y/N value indicating whether the non resident alien is exempt from FICA
STUDENT_EXEMPT_FROM_FICA VARCHAR2 (30)
Y/N value indicating whether the alien student is exempt from FICA.
ADDL_WITHHOLDING_FLAG VARCHAR2 (30)
Identifies whether there is any additional withholding.
ADDL_WITHHOLDING_AMT NUMBER (11)
Additional withholding amount, considered only if the additional withholding flag is set to Y.
ADDL_WTHLDNG_AMT_PERIOD_TYPE VARCHAR2 (30)
The period type for which the additional withholding amount is applicable.
PERSONAL_EXEMPTION NUMBER (6)
The number of personal excemptions.
ADDL_EXEMPTION_ALLOWED NUMBER (6)
Indicates whether the additional exemptions are allowed.
NUMBER_OF_DAYS_IN_USA NUMBER (6)
Number of days the employee is in the US.
WTHLDG_ALLOW_ELIGIBLE_FLAG VARCHAR2 (30)
Identiies whether the employee is eligible for withholding.
TREATY_BEN_ALLOWED_FLAG VARCHAR2 (30)
Indicates whether the treaty benefits are allowed for the employee.
TREATY_BENEFITS_START_DATE DATE

The date from which the treaty benefits begin
RA_EFFECTIVE_DATE DATE

The date on which the employee has become a resident.
STATE_CODE VARCHAR2 (30)
The two letter state code for which the state tax is applied.
STATE_HONORS_TREATY_FLAG VARCHAR2 (30)
Identifies whether the state honors the alien treaty.
YTD_PAYMENTS NUMBER (11)
The total YTD payments for this income type.
YTD_W2_PAYMENTS NUMBER (11)
The total W2 income for this income type.
YTD_W2_WITHHOLDING NUMBER (11)
Total W2 withholdings.
YTD_WITHHOLDING_ALLOWANCE NUMBER (11)
YTD withholding allowances.
YTD_TREATY_PAYMENTS NUMBER (11)
YTD 1042s payments.
YTD_TREATY_WITHHELD_AMT NUMBER (11)
YTD 1042s taxes withheld.
RECORD_SOURCE VARCHAR2 (30)
Identifier for the third party Alien treaty analysis software.
VISA_TYPE VARCHAR2 (30)
Type of visa, refers to the lookup type PER_US_VISA_TYPE.
J_SUB_TYPE VARCHAR2 (30)
Sub type of visa, valid for a visa type of 'J'
PRIMARY_ACTIVITY VARCHAR2 (30)
Refers to the lookup type PQP_US_PRIMARY_ACTIVITY.
NON_US_COUNTRY_CODE VARCHAR2 (30)
The non US country code to which the empoyee belongs.
CITIZENSHIP_COUNTRY_CODE VARCHAR2 (30)
The country in which the employee is a citizen of.
CONSTANT_ADDL_TAX NUMBER (11)
Constant additional tax if any
PERSON_ID NUMBER (10)
The person id from the PER_ALL_PEOPLE_F table
DATE_8233_SIGNED DATE

Date on which the form 8233 was signed.
DATE_W4_SIGNED DATE

Date on which the form W-4 was signed.
ERROR_INDICATOR VARCHAR2 (30)
Indicates error in the transferred data.
PREV_ER_TREATY_BENEFIT_AMT NUMBER (11)
The benefit amount with the previous employer for a given year.
ERROR_TEXT VARCHAR2 (4000)
The error text.
LAST_UPDATED_BY NUMBER (15)
Standard WHO column
LAST_UPDATE_DATE DATE

Standard WHO column
LAST_UPDATE_LOGIN NUMBER (15)
Standard WHO column
CREATED_BY NUMBER (15) Y Standard WHO column
CREATION_DATE DATE
Y Standard WHO column
OBJECT_VERSION_NUMBER NUMBER (15) Y System generated version of row. Increments by one with each update.
FORECAST_INCOME_CODE VARCHAR2 (30)
The forecast income code is the original income code that was sent for analysis.
CURRENT_ANALYSIS VARCHAR2 (30)
Flag to indicate whether the income code is valid after analysis.

[top of page]

HR.PQP_ALIEN_TRANSACTION_DATA does not reference any database object

HR.PQP_ALIEN_TRANSACTION_DATA is referenced by following:

APPS
SYNONYM - PQP_ALIEN_TRANSACTION_DATA
TRIGGER - PQP_ALIEN_TRANSACTION_DATA_WHO
PUBLIC
SYNONYM - PQP_ALIEN_TRANSACTION_DATA

[top of page]

Table: PQP_ANALYZED_ALIEN_DATA

Description: Table to store the analyzed alien data.
Primary Key: PQP_ANALYZED_ALIEN_DATA_PK
  1. ANALYZED_DATA_ID
Foreign Keys to this table:
Foreign Key Column Foreign Table
PQP_ANALYZED_ALIEN_DETAILS.ANALYZED_DATA_ID PQP_ANALYZED_ALIEN_DATA
Comments

Table stores the alien employees analyzed data that is returned from a third pary.

Primary Key: PQP_ANALYZED_ALIEN_DATA_PK
  1. ANALYZED_DATA_ID
Indexes
Index Type Tablespace Column
PQP_ANALYZED_ALIEN_DATA_PK UNIQUE APPS_TS_TX_IDX ANALYZED_DATA_ID
PQP_ANALYZED_ALIEN_DATA_N1 NONUNIQUE APPS_TS_TX_IDX ASSIGNMENT_ID
TAX_YEAR
Columns
Name Datatype Length Mandatory Comments
ANALYZED_DATA_ID NUMBER (15) Y System generated primary key.
ASSIGNMENT_ID NUMBER (15) Y Foreign key to PER_ALL_ASSIGNMENTS_F
DATA_SOURCE VARCHAR2 (30) Y Name of the third pary that is giving the analyzed data for Alien employees.
TAX_YEAR NUMBER (5) Y The tax year for which the data is applicable.
CURRENT_RESIDENCY_STATUS VARCHAR2 (30)
Identifies the current status as resident or non resident.
NRA_TO_RA_DATE DATE

The date on which the employee becomes a resident from a non-resident.
TARGET_DEPARTURE_DATE DATE

The date on which the employee is scheduled to leave the country.
TAX_RESIDENCE_COUNTRY_CODE VARCHAR2 (30)
The two letter tax residence code.
TREATY_INFO_UPDATE_DATE DATE

The date on which the Alien treaty was updated.
NUMBER_OF_DAYS_IN_USA NUMBER (6)
Number of days the employee is in the US.
WITHLDG_ALLOW_ELIGIBLE_FLAG VARCHAR2 (30)
Identiies whether the employee is eligible for withholding.
RA_EFFECTIVE_DATE DATE

The date on which the employee has become a resident.
RECORD_SOURCE VARCHAR2 (30)
Identifier for the third party Alien treaty analysis software.
VISA_TYPE VARCHAR2 (30)
Identifies the type of visa
J_SUB_TYPE VARCHAR2 (30)
Sub type of visa, valid for a visa type of 'J'
PRIMARY_ACTIVITY VARCHAR2 (30)
Thr primary activity in the US.
NON_US_COUNTRY_CODE VARCHAR2 (30)
The non US country code to which the empoyee belongs.
CITIZENSHIP_COUNTRY_CODE VARCHAR2 (30)
The country in which the employee is a citizen of.
DATE_8233_SIGNED DATE

Date on which the form 8233 was signed.
DATE_W4_SIGNED DATE

Date on which the form W-4 was signed.
LAST_UPDATED_BY NUMBER (15)
Standard WHO column
LAST_UPDATE_DATE DATE

Standard WHO column
LAST_UPDATE_LOGIN NUMBER (15)
Standard WHO column
CREATED_BY NUMBER (15) Y Standard WHO column
CREATION_DATE DATE
Y Standard WHO column
OBJECT_VERSION_NUMBER NUMBER (15) Y System generated version of row. Increments by one with each update.

[top of page]

HR.PQP_ANALYZED_ALIEN_DATA does not reference any database object

HR.PQP_ANALYZED_ALIEN_DATA is referenced by following:

APPS
SYNONYM - PQP_ANALYZED_ALIEN_DATA
TRIGGER - PQP_ANALYZED_ALIEN_DATA_WHO
PUBLIC
SYNONYM - PQP_ANALYZED_ALIEN_DATA

[top of page]

Table: PQP_ANALYZED_ALIEN_DETAILS

Description: Table to store the analyzed alien details.
Primary Key: PQP_ANALYZED_ALIEN_DETAILS_PK
  1. ANALYZED_DATA_DETAILS_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
PQP_ANALYZED_ALIEN_DETAILS.ANALYZED_DATA_ID PQP_ANALYZED_ALIEN_DATA
Comments

The individual income type alien treaty benefits is stored in this table.

Primary Key: PQP_ANALYZED_ALIEN_DETAILS_PK
  1. ANALYZED_DATA_DETAILS_ID
Indexes
Index Type Tablespace Column
PQP_ANALYZED_ALIEN_DETAILS_PK UNIQUE APPS_TS_TX_IDX ANALYZED_DATA_DETAILS_ID
PQP_ANALYZED_ALIEN_DETAILS_N1 NONUNIQUE APPS_TS_TX_IDX ANALYZED_DATA_ID
INCOME_CODE
Columns
Name Datatype Length Mandatory Comments
ANALYZED_DATA_DETAILS_ID NUMBER (15) Y System generated primary key
ANALYZED_DATA_ID NUMBER (15) Y Foreign key to PQP_ANALYZED_ALIEN_DATA
INCOME_CODE VARCHAR2 (30)
The income code for which the treaty details belong to
WITHHOLDING_RATE NUMBER (11)
The FIT withholding rate for the Alien earning.
INCOME_CODE_SUB_TYPE VARCHAR2 (30)
The sub type for the income, if applicable
EXEMPTION_CODE VARCHAR2 (30)
Excemption code for the alien income.
MAXIMUM_BENEFIT_AMOUNT NUMBER (11)
Maximum benefit amount for which the tax is not taken.
RETRO_LOSE_BEN_AMT_FLAG VARCHAR2 (30)
Identifies whether the employee loses treaty benefits retroactively if they earn more than the maximum benefit amount.
DATE_BENEFIT_ENDS DATE

The date on which the benefit ends.
RETRO_LOSE_BEN_DATE_FLAG VARCHAR2 (30)
Identifies whether the employee loses treaty benefits retroactively if they continue to stay beyond the date benefit ends date.
NRA_EXEMPT_FROM_SS VARCHAR2 (30)
Y/N value indicating the non resident alien is exempt from SS
NRA_EXEMPT_FROM_MEDICARE VARCHAR2 (30)
Y/N value indicating the non resident alien is exempt from medicare.
STUDENT_EXEMPT_FROM_SS VARCHAR2 (30)
Y/N value indicating the alien student is exempt from SS
STUDENT_EXEMPT_FROM_MEDICARE VARCHAR2 (30)
Y/N value indicating the alien student is exempt from medicare.
ADDL_WITHHOLDING_FLAG VARCHAR2 (30)
Identifies whether there is any additional withholding.
CONSTANT_ADDL_TAX NUMBER (11)
Constant additional tax if any
ADDL_WITHHOLDING_AMT NUMBER (11)
Additional withholding amount, considered only if the additional withholding flag is set to Y.
ADDL_WTHLDNG_AMT_PERIOD_TYPE VARCHAR2 (30)
The period type for which the additional withholding amount is applicable.
PERSONAL_EXEMPTION NUMBER (6)
The number of personal excemptions.
ADDL_EXEMPTION_ALLOWED NUMBER (6)
Indicates whether the additional exemptions are allowed.
TREATY_BEN_ALLOWED_FLAG VARCHAR2 (30)
Indicates whether the treaty benefits are allowed for the employee.
TREATY_BENEFITS_START_DATE DATE

The date from which the treaty benefits begin
LAST_UPDATED_BY NUMBER (15)
Standard WHO column
LAST_UPDATE_DATE DATE

Standard WHO column
LAST_UPDATE_LOGIN NUMBER (15)
Standard WHO column
CREATED_BY NUMBER (15) Y Standard WHO column
CREATION_DATE DATE
Y Standard WHO column
OBJECT_VERSION_NUMBER NUMBER (15) Y System generated version of row. Increments by one with each update.
RETRO_LOSS_NOTIFICATION_SENT VARCHAR2 (30)
Indicates whether a retro loss notification has been sent to the employee
FORECAST_INCOME_CODE VARCHAR2 (30)
The forecast income code is the original income code that was sent for analysis.
CURRENT_ANALYSIS VARCHAR2 (30)
Flag to indicate whether the income code is valid after analysis.

[top of page]

HR.PQP_ANALYZED_ALIEN_DETAILS does not reference any database object

HR.PQP_ANALYZED_ALIEN_DETAILS is referenced by following:

APPS
SYNONYM - PQP_ANALYZED_ALIEN_DETAILS
TRIGGER - PQP_ANALYZED_ALIEN_DETAILS_WHO
PUBLIC
SYNONYM - PQP_ANALYZED_ALIEN_DETAILS

[top of page]

Table: PQP_ASSIGNMENT_ATTRIBUTES_F

Description: PQP_ASSIGNMENT_ATTRIBUTES_F is the DateTracked table which holds a variety of information required by the public sector payroll product at assignment level. This information includes the contract type and details of work patterns. Even thou
Primary Key: PQP_ASSIGNMENT_ATTRIBUTES_F_PK
  1. ASSIGNMENT_ATTRIBUTE_ID
  2. EFFECTIVE_START_DATE
  3. EFFECTIVE_END_DATE
Primary Key: PQP_ASSIGNMENT_ATTRIBUTES_PK
  1. ASSIGNMENT_ATTRIBUTE_ID
  2. EFFECTIVE_START_DATE
  3. EFFECTIVE_END_DATE
Comments

PQP_ASSIGNMENT_ATTRIBUTES_F is the DateTracked table which holds a variety of information required by the public sector payroll product at assignment level. This information includes the contract type and details of work patterns. Even though there are columns for both private and company vehicles, these are not used anymore as the new tables PQP_VEHICLE_REPOSITORY_F AND PQP_VEHICLE_ALLOCATIONS_F are used for vehicle repository and allocations.

Indexes
Index Type Tablespace Column
PQP_ASSIGNMENT_ATTRIBUTES_F_PK UNIQUE APPS_TS_TX_IDX ASSIGNMENT_ATTRIBUTE_ID
EFFECTIVE_START_DATE
EFFECTIVE_END_DATE
PQP_ASSIGNMENT_ATTRIBUTES_F_N1 NONUNIQUE APPS_TS_TX_IDX ASSIGNMENT_ID
EFFECTIVE_START_DATE
EFFECTIVE_END_DATE
Columns
Name Datatype Length Mandatory Comments
ASSIGNMENT_ATTRIBUTE_ID NUMBER (15) Y System generated primary key column
EFFECTIVE_START_DATE DATE
Y Effective start date
EFFECTIVE_END_DATE DATE
Y Effective End Date
BUSINESS_GROUP_ID NUMBER (15) Y Foreign Key to HR_ORGANIZATION_UNITS
ASSIGNMENT_ID NUMBER (15) Y Foreign key to PER_ALL_ASSIGNMENTS_F
CONTRACT_TYPE VARCHAR2 (80)
Name of contract type
WORK_PATTERN VARCHAR2 (80)
Name of work pattern
START_DAY VARCHAR2 (30)
Day in work pattern that the assignment began on.
PRIMARY_COMPANY_CAR NUMBER (15)
Foreign key to PQP_VEHICLE_DETAILS
PRIMARY_CAR_FUEL_BENEFIT VARCHAR2 (30)
Indicates whether the primary company car is provided with fuel benefit
PRIMARY_CLASS_1A VARCHAR2 (30)
Indicates whether class 1A details are available
PRIMARY_CAPITAL_CONTRIBUTION NUMBER (15)
Amount of capital contribution to primary company car
PRIMARY_PRIVATE_CONTRIBUTION NUMBER (15)
Amount of private contribution to primary company car
SECONDARY_COMPANY_CAR NUMBER (15)
Foriegn key to PQP_VEHICLE_DETAILS
SECONDARY_CAR_FUEL_BENEFIT VARCHAR2 (30)
Indicates whether the secondary company car is provided with fuel benefit
SECONDARY_CLASS_1A VARCHAR2 (30)
Indicates whether class 1A details are available
SECONDARY_CAPITAL_CONTRIBUTION NUMBER (15)
Amount of capital contribution to secondary company car
SECONDARY_PRIVATE_CONTRIBUTION NUMBER (15)
Amount of private contribution to secondary company car
COMPANY_CAR_CALC_METHOD VARCHAR2 (30)
Calculation method for company cars
COMPANY_CAR_RATES_TABLE_ID NUMBER (9)
Foreign key to PAY_USER_TABLES
COMPANY_CAR_SECONDARY_TABLE_ID NUMBER (9)
Foreign key to PAY_USER_TABLES
PRIVATE_CAR NUMBER (15)
Foreign key to PQP_VEHICLE_DETAILS
PRIVATE_CAR_CALC_METHOD VARCHAR2 (30)
Calculation method for private cars
PRIVATE_CAR_RATES_TABLE_ID NUMBER (9)
Foreign key to PAY_USER_TABLES
PRIVATE_CAR_ESSENTIAL_TABLE_ID NUMBER (9)
Foreign key to PAY_USER_TABLES
LAST_UPDATE_DATE DATE

Standard Who column
LAST_UPDATED_BY NUMBER (15)
Standard Who column
LAST_UPDATE_LOGIN NUMBER (15)
Standard Who column
CREATED_BY NUMBER (15)
Standard Who column
CREATION_DATE DATE

Standard Who column
OBJECT_VERSION_NUMBER NUMBER (15) Y System generated version of row. Increments by one with each update.
TP_IS_TEACHER VARCHAR2 (30)
Indicates whether the person is a Teacher
TP_SAFEGUARDED_GRADE VARCHAR2 (150)
Indicates the safeguarded grade of a teacher
TP_ELECTED_PENSION VARCHAR2 (30)
Indicates whether the person has Elected a Pension Scheme
AAT_ATTRIBUTE_CATEGORY VARCHAR2 (30)
Descriptive flexfield column
AAT_ATTRIBUTE1 VARCHAR2 (150)
Descriptive flexfield column
AAT_ATTRIBUTE2 VARCHAR2 (150)
Descriptive flexfield column
AAT_ATTRIBUTE3 VARCHAR2 (150)
Descriptive flexfield column
AAT_ATTRIBUTE4 VARCHAR2 (150)
Descriptive flexfield column
AAT_ATTRIBUTE5 VARCHAR2 (150)
Descriptive flexfield column
AAT_ATTRIBUTE6 VARCHAR2 (150)
Descriptive flexfield column
AAT_ATTRIBUTE7 VARCHAR2 (150)
Descriptive flexfield column
AAT_ATTRIBUTE8 VARCHAR2 (150)
Descriptive flexfield column
AAT_ATTRIBUTE9 VARCHAR2 (150)
Descriptive flexfield column
AAT_ATTRIBUTE10 VARCHAR2 (150)
Descriptive flexfield column
AAT_ATTRIBUTE11 VARCHAR2 (150)
Descriptive flexfield column
AAT_ATTRIBUTE12 VARCHAR2 (150)
Descriptive flexfield column
AAT_ATTRIBUTE13 VARCHAR2 (150)
Descriptive flexfield column
AAT_ATTRIBUTE14 VARCHAR2 (150)
Descriptive flexfield column
AAT_ATTRIBUTE15 VARCHAR2 (150)
Descriptive flexfield column
AAT_ATTRIBUTE16 VARCHAR2 (150)
Descriptive flexfield column
AAT_ATTRIBUTE17 VARCHAR2 (150)
Descriptive flexfield column
AAT_ATTRIBUTE18 VARCHAR2 (150)
Descriptive flexfield column
AAT_ATTRIBUTE19 VARCHAR2 (150)
Descriptive flexfield column
AAT_ATTRIBUTE20 VARCHAR2 (150)
Descriptive flexfield column
AAT_INFORMATION_CATEGORY VARCHAR2 (30)
Developer descriptive flexfield column
AAT_INFORMATION1 VARCHAR2 (150)
Developer descriptive flexfield column
AAT_INFORMATION2 VARCHAR2 (150)
Developer descriptive flexfield column
AAT_INFORMATION3 VARCHAR2 (150)
Developer descriptive flexfield column
AAT_INFORMATION4 VARCHAR2 (150)
Developer descriptive flexfield column
AAT_INFORMATION5 VARCHAR2 (150)
Developer descriptive flexfield column
AAT_INFORMATION6 VARCHAR2 (150)
Developer descriptive flexfield column
AAT_INFORMATION7 VARCHAR2 (150)
Developer descriptive flexfield column
AAT_INFORMATION8 VARCHAR2 (150)
Developer descriptive flexfield column
AAT_INFORMATION9 VARCHAR2 (150)
Developer descriptive flexfield column
AAT_INFORMATION10 VARCHAR2 (150)
Developer descriptive flexfield column
AAT_INFORMATION11 VARCHAR2 (150)
Developer descriptive flexfield column
AAT_INFORMATION12 VARCHAR2 (150)
Developer descriptive flexfield column
AAT_INFORMATION13 VARCHAR2 (150)
Developer descriptive flexfield column
AAT_INFORMATION14 VARCHAR2 (150)
Developer descriptive flexfield column
AAT_INFORMATION15 VARCHAR2 (150)
Developer descriptive flexfield column
AAT_INFORMATION16 VARCHAR2 (150)
Developer descriptive flexfield column
AAT_INFORMATION17 VARCHAR2 (150)
Developer descriptive flexfield column
AAT_INFORMATION18 VARCHAR2 (150)
Developer descriptive flexfield column
AAT_INFORMATION19 VARCHAR2 (150)
Developer descriptive flexfield column
AAT_INFORMATION20 VARCHAR2 (150)
Developer descriptive flexfield column
TP_SAFEGUARDED_RATE_TYPE VARCHAR2 (30)
Indicates whether the safeguarded rate is a grade rate or scale rate
TP_SAFEGUARDED_RATE_ID NUMBER (15)
Indicates the safeguarded grade rate or scale rate of a teacher
TP_SAFEGUARDED_SPINAL_POINT_ID NUMBER (15)
Indicates the safeguarded spinal point of a teacher
TP_FAST_TRACK VARCHAR2 (30)
Indicates whether the teacher is on a Fast Track career path
TP_SAFEGUARDED_GRADE_ID NUMBER (15)
The safeguarded grade id of a teacher
TP_HEADTEACHER_GRP_CODE NUMBER (15)
Indicates the protected location group code of a head teacher
LGPS_PROCESS_FLAG VARCHAR2 (30)
Indicates the status of the assignment for LGPS
LGPS_EXCLUSION_TYPE VARCHAR2 (80)
Indicates the reason for exclusion from LGPS
LGPS_PENSIONABLE_PAY VARCHAR2 (60)
Holds the pensionable pay
LGPS_TRANS_ARRANG_FLAG VARCHAR2 (30)
Indiactes if the assignment is in transitional arrangement or not
LGPS_MEMBERSHIP_NUMBER VARCHAR2 (60)
Holds the LGPS membership number

[top of page]

HR.PQP_ASSIGNMENT_ATTRIBUTES_F does not reference any database object

HR.PQP_ASSIGNMENT_ATTRIBUTES_F is referenced by following:

APPS
TRIGGER - PQPASSIGNMENTATTRIBUTE_77I_DYT
TRIGGER - PQPASSIGNMENTATTRIBU_2133D_DYT
SYNONYM - PQP_ASSIGNMENT_ATTRIBUTES_F
TRIGGER - PQP_ASSIGNMENT_ATTRIBUTES_WHO
PUBLIC
SYNONYM - PQP_ASSIGNMENT_ATTRIBUTES_F

[top of page]

Table: PQP_CONFIGURATION_MODULES

Description: Table used to keep track of modules that has configuration values setup.
Primary Key: PQP_CONFIGURATION_MODULES_PK
  1. MODULE_ID
Comments

Table used to keep track of modules that has configuration values setup. This is used in the UI to identify only configurations that are relevant for that legislation or product.

Indexes
Index Type Tablespace Column
PQP_CONFIGURATION_MODULES_PK UNIQUE APPS_TS_TX_IDX MODULE_ID
PQP_CONFIGURATION_MODULES_N1 NONUNIQUE APPS_TS_TX_IDX MODULE_NAME
Columns
Name Datatype Length Mandatory Comments
MODULE_ID NUMBER (15) Y Generated primary key.
MODULE_NAME VARCHAR2 (150) Y The module name for which configuration types and values will be created.
BUSINESS_GROUP_ID NUMBER (10)
Foreign key to HR_ORGANIZATION_UNITS.
LEGISLATION_CODE VARCHAR2 (30)
The legislation to which this module belongs.
DESCRIPTION VARCHAR2 (240)
Description of the module for which configuration values will be created.
APPLICATION_ID NUMBER (15) Y Identifies the application of the configuration module. Foreign key to FND_APPLICATION table.
OBJECT_VERSION_NUMBER NUMBER (15) Y Standard WHO column.
LAST_UPDATE_DATE DATE

Standard WHO column.
LAST_UPDATED_BY NUMBER (15)
Standard WHO column.
LAST_UPDATE_LOGIN NUMBER (15)
Standard WHO column.
CREATED_BY NUMBER (15)
Standard WHO column.
CREATION_DATE DATE

Standard WHO column.

[top of page]

HR.PQP_CONFIGURATION_MODULES does not reference any database object

HR.PQP_CONFIGURATION_MODULES is referenced by following:

APPS
SYNONYM - PQP_CONFIGURATION_MODULES
TRIGGER - PQP_CONFIGURATION_MODULES_WHO
PUBLIC
SYNONYM - PQP_CONFIGURATION_MODULES

[top of page]

Table: PQP_CONFIGURATION_TYPES

Description: Entity used to store the information types (configuration types) for each module stored in pqp_configuration_modules. Each row identifies one configuration type and the values for this type is stored in pqp_configuration_values table.
Primary Key: PQP_CONFIGURATION_TYPES_U1
  1. MODULE_ID
  2. LEGISLATION_CODE
  3. CONFIGURATION_TYPE
Comments

Entity used to store the information types (configuration types) for each module stored in pqp_configuration_modules. Each row identifies one configuration type and the values for this type is stored in pqp_configuration_values table.

Indexes
Index Type Tablespace Column
PQP_CONFIGURATION_TYPES_N1 NONUNIQUE APPS_TS_TX_IDX CONFIGURATION_TYPE
MODULE_ID
LEGISLATION_CODE
Columns
Name Datatype Length Mandatory Comments
CONFIGURATION_TYPE VARCHAR2 (40) Y The name of the configuration type for a particular module.
MODULE_ID NUMBER (15) Y Identifies the module for the configuration type. Foreign key to pqp_configuration_modules table.
ACTIVE_INACTIVE_FLAG VARCHAR2 (30) Y Identifies whether the configuration type is active. The valid values are 'A' and 'I'.
DESCRIPTION VARCHAR2 (240)
Description of the configuration type.
MULTIPLE_OCCURENCES_FLAG VARCHAR2 (30) Y Identifies whether multiple rows are allowed for this configuration type.
LEGISLATION_CODE VARCHAR2 (30)
Legislation code of the configuration type.
TOTAL_UNIQUE_COLUMNS NUMBER (9)
Identifies the number of PCV_INFORMATION columns starting from 1 that are unique for this configuration. This is used to validate the data, as the uniqueness is different for each configuration type.
PROTECTED_FLAG VARCHAR2 (30)
Identifies whether the seeded data in the Confuguration Values table is protected from user updates. If the value is 'N', the users are allowed to update the seeded values. If the value is 'Y', users will be able to create a new row for the business group.
PROGRAM_APPLICATION_ID NUMBER (15)
Concurrent program application id.
PROGRAM_ID NUMBER (15)
Concurrent program id.
REQUEST_ID NUMBER (15)
Concurrent program request id.
PROGRAM_UPDATE_DATE DATE

Concurrent program update date.
OBJECT_VERSION_NUMBER NUMBER (9) Y Standard WHO column.
LAST_UPDATE_DATE DATE

Standard WHO column.
LAST_UPDATED_BY NUMBER (15)
Standard WHO column.
LAST_UPDATE_LOGIN NUMBER (15)
Standard WHO column.
CREATED_BY NUMBER (15)
Standard WHO column.
CREATION_DATE DATE

Standard WHO column.

[top of page]

HR.PQP_CONFIGURATION_TYPES does not reference any database object

HR.PQP_CONFIGURATION_TYPES is referenced by following:

APPS
SYNONYM - PQP_CONFIGURATION_TYPES
TRIGGER - PQP_CONFIGURATION_TYPES_WHO
PUBLIC
SYNONYM - PQP_CONFIGURATION_TYPES

[top of page]

Table: PQP_CONFIGURATION_VALUES

Description: Table used for all generic configuration details, both seeded and user defined.
Primary Key: PQP_CONFIGURATION_VALUES_PK
  1. CONFIGURATION_VALUE_ID
Comments

This table is used to store all configuration information. The table can have seeded as well as user perference data. The data is identified by the key word that is stored in PC_INFORMATION_CATEGORY.

Indexes
Index Type Tablespace Column
PQP_CONFIGURATION_VALUES_N1 NONUNIQUE APPS_TS_TX_IDX PCV_INFORMATION_CATEGORY
LEGISLATION_CODE
BUSINESS_GROUP_ID
Columns
Name Datatype Length Mandatory Comments
CONFIGURATION_VALUE_ID NUMBER (10) Y Primary key generated by a sequence.
BUSINESS_GROUP_ID NUMBER (15)
Business group id.
LEGISLATION_CODE VARCHAR2 (30)
Legislation code for seeded data.
PCV_ATTRIBUTE_CATEGORY VARCHAR2 (30)
Category for the Descriptive flexfield.
PCV_ATTRIBUTE1 VARCHAR2 (150)
Descriptive flexfield column
PCV_ATTRIBUTE2 VARCHAR2 (150)
Descriptive flexfield column
PCV_ATTRIBUTE3 VARCHAR2 (150)
Descriptive flexfield column
PCV_ATTRIBUTE4 VARCHAR2 (150)
Descriptive flexfield column
PCV_ATTRIBUTE5 VARCHAR2 (150)
Descriptive flexfield column
PCV_ATTRIBUTE6 VARCHAR2 (150)
Descriptive flexfield column
PCV_ATTRIBUTE7 VARCHAR2 (150)
Descriptive flexfield column
PCV_ATTRIBUTE8 VARCHAR2 (150)
Descriptive flexfield column
PCV_ATTRIBUTE9 VARCHAR2 (150)
Descriptive flexfield column
PCV_ATTRIBUTE10 VARCHAR2 (150)
Descriptive flexfield column
PCV_ATTRIBUTE11 VARCHAR2 (150)
Descriptive flexfield column
PCV_ATTRIBUTE12 VARCHAR2 (150)
Descriptive flexfield column
PCV_ATTRIBUTE13 VARCHAR2 (150)
Descriptive flexfield column
PCV_ATTRIBUTE14 VARCHAR2 (150)
Descriptive flexfield column
PCV_ATTRIBUTE15 VARCHAR2 (150)
Descriptive flexfield column
PCV_ATTRIBUTE16 VARCHAR2 (150)
Descriptive flexfield column
PCV_ATTRIBUTE17 VARCHAR2 (150)
Descriptive flexfield column
PCV_ATTRIBUTE18 VARCHAR2 (150)
Descriptive flexfield column
PCV_ATTRIBUTE19 VARCHAR2 (150)
Descriptive flexfield column
PCV_ATTRIBUTE20 VARCHAR2 (150)
Descriptive flexfield column
PCV_INFORMATION_CATEGORY VARCHAR2 (30)
Developer descriptive flexfield column
PCV_INFORMATION1 VARCHAR2 (150)
Developer descriptive flexfield column
PCV_INFORMATION2 VARCHAR2 (150)
Developer descriptive flexfield column
PCV_INFORMATION3 VARCHAR2 (150)
Developer descriptive flexfield column
PCV_INFORMATION4 VARCHAR2 (150)
Developer descriptive flexfield column
PCV_INFORMATION5 VARCHAR2 (150)
Developer descriptive flexfield column
PCV_INFORMATION6 VARCHAR2 (150)
Developer descriptive flexfield column
PCV_INFORMATION7 VARCHAR2 (150)
Developer descriptive flexfield column
PCV_INFORMATION8 VARCHAR2 (150)
Developer descriptive flexfield column
PCV_INFORMATION9 VARCHAR2 (150)
Developer descriptive flexfield column
PCV_INFORMATION10 VARCHAR2 (150)
Developer descriptive flexfield column
PCV_INFORMATION11 VARCHAR2 (150)
Developer descriptive flexfield column
PCV_INFORMATION12 VARCHAR2 (150)
Developer descriptive flexfield column
PCV_INFORMATION13 VARCHAR2 (150)
Developer descriptive flexfield column
PCV_INFORMATION14 VARCHAR2 (150)
Developer descriptive flexfield column
PCV_INFORMATION15 VARCHAR2 (150)
Developer descriptive flexfield column
PCV_INFORMATION16 VARCHAR2 (150)
Developer descriptive flexfield column
PCV_INFORMATION17 VARCHAR2 (150)
Developer descriptive flexfield column
PCV_INFORMATION18 VARCHAR2 (150)
Developer descriptive flexfield column
PCV_INFORMATION19 VARCHAR2 (150)
Developer descriptive flexfield column
PCV_INFORMATION20 VARCHAR2 (150)
Developer descriptive flexfield column
CREATED_BY NUMBER (15) Y Standard who column
CREATION_DATE DATE
Y Standard who column
LAST_UPDATE_DATE DATE
Y Standard who column
LAST_UPDATED_BY NUMBER (15) Y Standard who column
LAST_UPDATE_LOGIN NUMBER (15)
Standard who column
OBJECT_VERSION_NUMBER NUMBER (9) Y Object version number
CONFIGURATION_NAME VARCHAR2 (80)
A name to identify the unique row for the configuration values. This is used to identify the row when the configuration category can have more than one row.

[top of page]

HR.PQP_CONFIGURATION_VALUES does not reference any database object

HR.PQP_CONFIGURATION_VALUES is referenced by following:

APPS
SYNONYM - PQP_CONFIGURATION_VALUES
TRIGGER - PQP_CONFIGURATION_VALUES_WHO
PUBLIC
SYNONYM - PQP_CONFIGURATION_VALUES

[top of page]

Table: PQP_EXCEPTION_REPORTS

Description: Table to store the exception report definitions. This table contains both seeded and user defined exception reports based on a balance and dimension.
Primary Key: PET_PK
  1. EXCEPTION_REPORT_ID
Primary Key: PQP_EXCEPTION_REPORTS_PK
  1. EXCEPTION_REPORT_ID
Comments

Table to store the exception report definitions. This table contains both seeded and user defined exception reports based on a balance and dimension.

Primary Key: PQP_EXCEPTION_REPORTS_PK
  1. EXCEPTION_REPORT_ID
Indexes
Index Type Tablespace Column
PQP_EXCEPTION_REPORTS_PK UNIQUE APPS_TS_TX_IDX EXCEPTION_REPORT_ID
PQP_EXCEPTION_REPORTS_N1 NONUNIQUE APPS_TS_TX_IDX EXCEPTION_REPORT_NAME
BUSINESS_GROUP_ID
LEGISLATION_CODE
Columns
Name Datatype Length Mandatory Comments
EXCEPTION_REPORT_ID NUMBER (9) Y System generated primary key column
EXCEPTION_REPORT_NAME VARCHAR2 (80) Y The name for the exception report.
LEGISLATION_CODE VARCHAR2 (30)
The Legislation code for which the data in the table is associated with.
BUSINESS_GROUP_ID NUMBER (15)
The Business group for which the table row is associated with.
CURRENCY_CODE VARCHAR2 (15)
The currency code of the Business group.
BALANCE_TYPE_ID NUMBER (9)
Foreign key to the PAY_BALANCE_TYPES table.
BALANCE_DIMENSION_ID NUMBER (9)
Foreign key to the PAY_BALANCE_DIMENSIONS table.
VARIANCE_TYPE VARCHAR2 (30)
The variance type for the exception report. The values can be 'P' for Percentage and 'A' for Amount.
VARIANCE_VALUE NUMBER (11)
The variance value defined for the exception report.
COMPARISON_TYPE VARCHAR2 (30)
The type of comparison that needs to be done for the defined balance.
COMPARISON_VALUE NUMBER (9)
The comparison value applicable only if the comparison type is based on average.
LAST_UPDATED_BY NUMBER (15)
Standard WHO column
LAST_UPDATE_DATE DATE

Standard WHO column
LAST_UPDATE_LOGIN NUMBER (15)
Standard WHO column
CREATED_BY NUMBER (15) Y Standard WHO column
CREATION_DATE DATE
Y Standard WHO column
OBJECT_VERSION_NUMBER NUMBER (15) Y System generated version of row. Increments by one with each update.
VARIANCE_OPERATOR VARCHAR2 (30)
Variance operator is the relationship between variance type and value. Examples are >=, >, < etc.
OUTPUT_FORMAT VARCHAR2 (30)
The type of report required. A regular text report or a spreadsheet enabled comma delimited file.

[top of page]

HR.PQP_EXCEPTION_REPORTS does not reference any database object

HR.PQP_EXCEPTION_REPORTS is referenced by following:

APPS
SYNONYM - PQP_EXCEPTION_REPORTS
TRIGGER - PQP_EXCEPTION_REPORTS_WHO
PUBLIC
SYNONYM - PQP_EXCEPTION_REPORTS

[top of page]

Table: PQP_EXCEPTION_REPORTS_TL

Description: Translation table to store the exception report definitions.
Primary Key: PEL_PK
  1. EXCEPTION_REPORT_ID
  2. LANGUAGE
Primary Key: PQP_EXCEPTION_REPORTS_TL_PK
  1. EXCEPTION_REPORT_ID
  2. LANGUAGE
Comments

Translation table to store the exception report definitions.

Primary Key: PQP_EXCEPTION_REPORTS_TL_PK
  1. EXCEPTION_REPORT_ID
  2. LANGUAGE
Indexes
Index Type Tablespace Column
PQP_EXCEPTION_REPORTS_TL_PK UNIQUE APPS_TS_TX_IDX EXCEPTION_REPORT_ID
LANGUAGE
Columns
Name Datatype Length Mandatory Comments
EXCEPTION_REPORT_ID NUMBER (9) Y The Primary key for the table PQP_EXCEPTION_REPORTS
EXCEPTION_REPORT_NAME VARCHAR2 (80) Y The translated exception report name.
LANGUAGE VARCHAR2 (4) Y The language in which the report name is translated.
SOURCE_LANG VARCHAR2 (4)
The source language from which the report name was translated.
LAST_UPDATED_BY NUMBER (15)
Standard WHO column
LAST_UPDATE_DATE DATE

Standard WHO column
LAST_UPDATE_LOGIN NUMBER (15)
Standard WHO column
CREATED_BY NUMBER (15) Y Standard WHO column
CREATION_DATE DATE
Y Standard WHO column

[top of page]

HR.PQP_EXCEPTION_REPORTS_TL does not reference any database object

HR.PQP_EXCEPTION_REPORTS_TL is referenced by following:

APPS
TRIGGER - PQP_EXCEPTION_REPORT041339_WHO
SYNONYM - PQP_EXCEPTION_REPORTS_TL
PUBLIC
SYNONYM - PQP_EXCEPTION_REPORTS_TL

[top of page]

Table: PQP_EXCEPTION_REPORT_GROUPS

Description: This table is used to group the exception report definitions so that multiple exception definitions can be run at once.
Primary Key: PEP_PK
  1. EXCEPTION_GROUP_ID
Primary Key: PQP_EXCEPTION_REPORT_GROUPS_PK
  1. EXCEPTION_GROUP_ID
Comments

This table is used to group the exception report definitions so that multiple exception definitions can be run at once.

Primary Key: PQP_EXCEPTION_REPORT_GROUPS_PK
  1. EXCEPTION_GROUP_ID
Indexes
Index Type Tablespace Column
PQP_EXCEPTION_REPORT_GROUPS_PK UNIQUE APPS_TS_TX_IDX EXCEPTION_GROUP_ID
PQP_EXCEPTION_REPORT_GROUPS_N1 NONUNIQUE APPS_TS_TX_IDX EXCEPTION_GROUP_NAME
BUSINESS_GROUP_ID
LEGISLATION_CODE
PQP_EXCEPTION_REPORT_GROUPS_N2 NONUNIQUE APPS_TS_TX_IDX EXCEPTION_REPORT_ID
Columns
Name Datatype Length Mandatory Comments
EXCEPTION_GROUP_ID NUMBER (9) Y System generated primary key column
EXCEPTION_GROUP_NAME VARCHAR2 (80) Y The name of the exception report group
EXCEPTION_REPORT_ID NUMBER (9) Y The exception report id from PQP_EXCEPTION_REPORTS table
LEGISLATION_CODE VARCHAR2 (30)
The Legislation code for which the data in the table is associated with.
BUSINESS_GROUP_ID NUMBER (15)
The Business group for which the table row is associated with.
CONSOLIDATION_SET_ID NUMBER (9)
The consolidation set for which the exception group reports will be run.
PAYROLL_ID NUMBER (9)
The payroll for which the exception group reports will be run.
LAST_UPDATED_BY NUMBER (15)
Standard WHO column
LAST_UPDATE_DATE DATE

Standard WHO column
LAST_UPDATE_LOGIN NUMBER (15)
Standard WHO column
CREATED_BY NUMBER (15) Y Standard WHO column
CREATION_DATE DATE
Y Standard WHO column
OBJECT_VERSION_NUMBER NUMBER (15) Y System generated version of row. Increments by one with each update.
OUTPUT_FORMAT VARCHAR2 (30)
The type of output required. ie. Text or Spreadsheet enabled

[top of page]

HR.PQP_EXCEPTION_REPORT_GROUPS does not reference any database object

HR.PQP_EXCEPTION_REPORT_GROUPS is referenced by following:

APPS
SYNONYM - PQP_EXCEPTION_REPORT_GROUPS
TRIGGER - PQP_EXCEPTION_REPORT_GROUP_WHO
PUBLIC
SYNONYM - PQP_EXCEPTION_REPORT_GROUPS

[top of page]

Table: PQP_EXCEPTION_REPORT_SUFFIX

Description: Table to store the balance dimension database suffix and its equivalent reporting period.
Primary Key: PQP_EXCEPTION_REPORT_SUFFIX_PK
  1. DATABASE_ITEM_SUFFIX
  2. LEGISLATION_CODE
Comments

Table to store the balance dimension database suffix and its equivalent reporting period.

Indexes
Index Type Tablespace Column
PQP_EXCEPTION_REPORT_SUFFIX_PK NONUNIQUE APPS_TS_SEED DATABASE_ITEM_SUFFIX
LEGISLATION_CODE
Columns
Name Datatype Length Mandatory Comments
DATABASE_ITEM_SUFFIX VARCHAR2 (80) Y The database item suffix of the balance dimension.
LEGISLATION_CODE VARCHAR2 (30) Y Legislation code
EXCEPTION_REPORT_PERIOD VARCHAR2 (80)
Exception reporting period is the logical equivalent time period for the database item suffix
LAST_UPDATED_BY NUMBER (15)
Standard WHO column
LAST_UPDATE_DATE DATE

Standard WHO column
LAST_UPDATE_LOGIN NUMBER (15)
Standard WHO column
CREATED_BY NUMBER (15)
Standard WHO column
CREATION_DATE DATE

Standard WHO column
OBJECT_VERSION_NUMBER NUMBER (15)
System generated version of row. Increments by one with each update.
YEAR_BEGIN_DATE DATE

The day and month of this column identifes the start date of the year. For example, if the dimension is YTD and the begining of the year is '05-Apr', then this column will have '05-APR-2000'. Note that the year component of the date is ignored.

[top of page]

HR.PQP_EXCEPTION_REPORT_SUFFIX does not reference any database object

HR.PQP_EXCEPTION_REPORT_SUFFIX is referenced by following:

APPS
SYNONYM - PQP_EXCEPTION_REPORT_SUFFIX
TRIGGER - PQP_EXCEPTION_REPORT_SUFFI_WHO
PUBLIC
SYNONYM - PQP_EXCEPTION_REPORT_SUFFIX

[top of page]

Table: PQP_EXTRACT_ATTRIBUTES

Description: Table to hold extra attributes of system extracts required for the Public Sector Payroll application.
Primary Key: PQP_EXTRACK_ATTRIBUTES_UK1
  1. EXT_DFN_ID
Primary Key: PQP_EXTRACT_ATTRIBUTES_PK
  1. EXTRACT_ATTRIBUTE_ID
Primary Key: PQP_EXTRACT_ATTRIBUTES_UK1
  1. EXT_DFN_ID
Comments

PQP_EXTRACT_ATTRIBUTES is the table which holds a variety of information about a system extract definition required by the public sector payroll product . This information includes the extract type and the user defined table associated with the extract.

Primary Key: PQP_EXTRACT_ATTRIBUTES_PK
  1. EXTRACT_ATTRIBUTE_ID
Unique Key: PQP_EXTRACT_ATTRIBUTES_UK1
  1. EXT_DFN_ID
Indexes
Index Type Tablespace Column
PQP_EXTRACT_ATTRIBUTES_PK UNIQUE APPS_TS_TX_IDX EXTRACT_ATTRIBUTE_ID
PQP_EXTRACT_ATTRIBUTES_UK1 UNIQUE APPS_TS_TX_IDX EXT_DFN_ID
PQP_EXTRACT_ATTRIBUTES_N1 NONUNIQUE APPS_TS_TX_IDX EXT_DFN_NAME
Columns
Name Datatype Length Mandatory Comments
EXTRACT_ATTRIBUTE_ID NUMBER (15) Y System generated primary key column
EXT_DFN_ID NUMBER (15) Y Foreign key to BEN_EXT_DFN
EXT_DFN_NAME VARCHAR2 (600)
Denormalized BEN_EXT_DFN.NAME, used to allow seeding of extract defnitions.
EXT_DFN_TYPE VARCHAR2 (30) Y Qualfies the type of extract definition.
EXT_USER_TABLE_ID NUMBER (15)
Foreign key to PAY_USER_TABLES
EXT_USER_TABLE_NAME VARCHAR2 (240)
Denormalized BEN_EXT_DFN.NAME, used to allow seeding of extract defnitions.
CREATED_BY NUMBER (15) Y Standard WHO column
CREATION_DATE DATE
Y Standard WHO column
LAST_UPDATED_BY NUMBER (15)
Standard WHO column
LAST_UPDATE_DATE DATE

Standard WHO column
LAST_UPDATE_LOGIN NUMBER

Standard WHO column
OBJECT_VERSION_NUMBER NUMBER
Y System generated version of row. Increments by one with each update.

[top of page]

HR.PQP_EXTRACT_ATTRIBUTES does not reference any database object

HR.PQP_EXTRACT_ATTRIBUTES is referenced by following:

APPS
SYNONYM - PQP_EXTRACT_ATTRIBUTES
TRIGGER - PQP_EXTRACT_ATTRIBUTES_WHO
PUBLIC
SYNONYM - PQP_EXTRACT_ATTRIBUTES

[top of page]

Table: PQP_EXT_CROSS_PERSON_RECORDS

Description: Table to hold cross person and cross busines group reporting related records used and maintained by Teachers Pension Extract Process.
Comments

This table holds information such as national identifier and processing status of person records used by Teachers Pension Extract Process.

Indexes
Index Type Tablespace Column
PQP_EXT_CROSS_PERSON_RECS_N1 NONUNIQUE APPS_TS_INTERFACE RECORD_TYPE
NATIONAL_IDENTIFIER
Columns
Name Datatype Length Mandatory Comments
RECORD_TYPE VARCHAR2 (1) Y Identifies the type of record, M for master and X for others.
BUSINESS_GROUP_ID NUMBER (15)
Business group id.
PERSON_ID NUMBER (15)
Person id
NATIONAL_IDENTIFIER VARCHAR2 (30)
National Identifier
ASSIGNMENT_ID NUMBER (15)
Assignment ID
EFFECTIVE_START_DATE DATE

Effective Start Date
EFFECTIVE_END_DATE DATE

Effective End Date
PROCESSING_STATUS VARCHAR2 (1)
The processing status of the record, C for completed, U for updated.
REQUEST_ID NUMBER (15)
The concurrent requests ID
CREATED_BY NUMBER (15) Y Standard WHO column
CREATION_DATE DATE
Y Standard WHO column
LAST_UPDATED_BY NUMBER (15)
Standard WHO column
LAST_UPDATE_DATE DATE

Standard WHO column
LAST_UPDATE_LOGIN NUMBER

Standard WHO column
OBJECT_VERSION_NUMBER NUMBER
Y System generated version of row. Increments by one with each update.
EXT_DFN_ID NUMBER (15)
Extract Definition Id
LEA_NUMBER VARCHAR2 (3)
LEA Number

[top of page]

HR.PQP_EXT_CROSS_PERSON_RECORDS does not reference any database object

HR.PQP_EXT_CROSS_PERSON_RECORDS is referenced by following:

APPS
SYNONYM - PQP_EXT_CROSS_PERSON_RECORDS
TRIGGER - PQP_EXT_CROSS_PERSON_RECOR_WHO
PUBLIC
SYNONYM - PQP_EXT_CROSS_PERSON_RECORDS

[top of page]

Table: PQP_FLXDU_COLUMNS

Description: This table is used to maintain all the fields for a HR entity types available in a spreadsheet.
Primary Key: PQP_FLXDU_COLUMNS_PK
  1. FLXDU_COLUMN_ID
Comments

This table is used to maintain all the fields for a HR entity types available in a spreadsheet.

Indexes
Index Type Tablespace Column
PQP_FLXDU_COLUMNS_PK UNIQUE APPS_TS_TX_IDX FLXDU_COLUMN_ID
PQP_FLXDU_COLUMNS_N1 NONUNIQUE APPS_TS_TX_IDX FLXDU_COLUMN_NAME
Columns
Name Datatype Length Mandatory Comments
FLXDU_COLUMN_ID NUMBER (22) Y Generated primary key.
FLXDU_COLUMN_NAME VARCHAR2 (150) Y Field Name which RIW supports in spreadsheet
FLXDU_COLUMN_XML_TAG VARCHAR2 (150) Y Field XML Tag name
FLXDU_COLUMN_DATA_TYPE VARCHAR2 (30) Y Field Data Type
FLXDU_COLUMN_DATA_LENGTH VARCHAR2 (30)
Field Data Length
FLXDU_COLUMN_XML_DATA VARCHAR2 (150)
Sample XML data.
FLXDU_SEQ_NUM NUMBER (15) Y The sequence number where this column appears in order.
FLXDU_GROUP_NAME VARCHAR2 (30)
The group name to which this column belongs to.
ENTITY_TYPE VARCHAR2 (30) Y Entity which this field belongs
REQUIRED_FLAG VARCHAR2 (1)
Whether field is required or not at the API level for the business logic
DISPLAY_FLAG VARCHAR2 (1)
Whether the field is visible or not.
DESCRIPTION VARCHAR2 (240)
Description of the column.
OBJECT_VERSION_NUMBER NUMBER
Y System generated version of row. Increments by one with each update.
CREATED_BY NUMBER (15) Y Standard WHO column
CREATION_DATE DATE
Y Standard WHO column
LAST_UPDATED_BY NUMBER (15)
Standard WHO column
LAST_UPDATE_DATE DATE

Standard WHO column
LAST_UPDATE_LOGIN NUMBER

Standard WHO column

[top of page]

HR.PQP_FLXDU_COLUMNS does not reference any database object

HR.PQP_FLXDU_COLUMNS is referenced by following:

APPS
SYNONYM - PQP_FLXDU_COLUMNS
TRIGGER - PQP_FLXDU_COLUMNS_WHO
PUBLIC
SYNONYM - PQP_FLXDU_COLUMNS

[top of page]

Table: PQP_FLXDU_FUNC_ATTRIBUTES

Description: This table is used to identify the functions that are created using the RIW setup.
Primary Key: PQP_FLXDU_FUNC_ATTRIBUTES_PK
  1. FLXDU_FUNC_ATTRIBUTE_ID
Comments

This table is used to identify the functions that are created using the RIW setup.

Indexes
Index Type Tablespace Column
SYS_IL0000409889C00005$$ UNIQUE APPS_TS_TX_DATA
PQP_FLXDU_FUNC_ATTRIBUTES_N1 NONUNIQUE APPS_TS_TX_IDX FLXDU_FUNC_NAME
PQP_FLXDU_FUNC_ATTRIBUTES_PK NONUNIQUE APPS_TS_TX_IDX FLXDU_FUNC_ATTRIBUTE_ID
Columns
Name Datatype Length Mandatory Comments
FLXDU_FUNC_ATTRIBUTE_ID NUMBER (15) Y Generated primary key.
FLXDU_FUNC_NAME VARCHAR2 (30) Y The Function Name for which RIW will be created and Foreign key to fnd_form_functions.
FLXDU_FUNC_SOURCE_TYPE VARCHAR2 (30) Y RIW Function source Type
FLXDU_FUNC_INTEGRATOR_CODE VARCHAR2 (30) Y BNE Integrator Code
FLXDU_FUNC_XML_DATA CLOB (4000)
Field that stores the XML sample file.
LEGISLATION_CODE VARCHAR2 (30)
The legislation to which this function belongs.
DESCRIPTION VARCHAR2 (240)
Description of the function for which entity this function will be created.
OBJECT_VERSION_NUMBER NUMBER
Y System generated version of row. Increments by one with each update.
CREATED_BY NUMBER (15) Y Standard WHO column
CREATION_DATE DATE
Y Standard WHO column
LAST_UPDATED_BY NUMBER (15)
Standard WHO column
LAST_UPDATE_DATE DATE

Standard WHO column
LAST_UPDATE_LOGIN NUMBER

Standard WHO column

[top of page]

HR.PQP_FLXDU_FUNC_ATTRIBUTES does not reference any database object

HR.PQP_FLXDU_FUNC_ATTRIBUTES is referenced by following:

APPS
SYNONYM - PQP_FLXDU_FUNC_ATTRIBUTES
TRIGGER - PQP_FLXDU_FUNC_ATTRIBUTES_WHO
PUBLIC
SYNONYM - PQP_FLXDU_FUNC_ATTRIBUTES

[top of page]

Table: PQP_FLXDU_XML_TAGS

Description: Table used to maintain all user defined XML tags for spreadsheet-supported fields
Primary Key: PQP_FLXDU_XML_TAGS_PK
  1. FLXDU_XML_TAG_ID
Comments

Table used to maintain all user defined XML tags for spreadsheet-supported fields

Indexes
Index Type Tablespace Column
PQP_FLXDU_XML_TAGS_N1 NONUNIQUE APPS_TS_TX_IDX FLXDU_XML_TAG_NAME
PQP_FLXDU_XML_TAGS_PK NONUNIQUE APPS_TS_TX_IDX FLXDU_XML_TAG_ID
Columns
Name Datatype Length Mandatory Comments
FLXDU_XML_TAG_ID NUMBER (22) Y Generated primary key.
FLXDU_COLUMN_ID NUMBER (22) Y Column Id.Foreign Key to PQP_FLXDU_COLUMNS.FLXDU_COLUMN_ID
FLXDU_XML_TAG_NAME VARCHAR2 (150) Y User defined XML Tag name
BUSINESS_GROUP_ID NUMBER (15) Y Business Group Id
OBJECT_VERSION_NUMBER NUMBER
Y System generated version of row. Increments by one with each update.
CREATED_BY NUMBER (15) Y Standard WHO column
CREATION_DATE DATE
Y Standard WHO column
LAST_UPDATED_BY NUMBER (15)
Standard WHO column
LAST_UPDATE_DATE DATE

Standard WHO column
LAST_UPDATE_LOGIN NUMBER

Standard WHO column

[top of page]

HR.PQP_FLXDU_XML_TAGS does not reference any database object

HR.PQP_FLXDU_XML_TAGS is referenced by following:

APPS
SYNONYM - PQP_FLXDU_XML_TAGS
TRIGGER - PQP_FLXDU_XML_TAGS_WHO
PUBLIC
SYNONYM - PQP_FLXDU_XML_TAGS

[top of page]

Table: PQP_GAP_ABSENCE_PLANS

Description: This table is used to store the generic Absence Plans
Primary Key: PQP_GAP_ABSENCE_PLANS_PK
  1. GAP_ABSENCE_PLAN_ID
Primary Key: PQP_GAP_ABSENCE_PLANS_UK1
  1. ABSENCE_ATTENDANCE_ID
  2. PL_ID
Foreign Keys to this table:
Foreign Key Column Foreign Table
PQP_GAP_DAILY_ABSENCES.GAP_ABSENCE_PLAN_ID PQP_GAP_ABSENCE_PLANS
Comments

This table is used to store the generic Absence Plans

Indexes
Index Type Tablespace Column
PQP_GAP_ABSENCE_PLANS_UK1 UNIQUE APPS_TS_TX_IDX ABSENCE_ATTENDANCE_ID
PL_ID
PQP_GAP_ABSENCE_PLANS_N1 NONUNIQUE APPS_TS_TX_IDX ASSIGNMENT_ID
PQP_GAP_ABSENCE_PLANS_PK NONUNIQUE APPS_TS_TX_IDX GAP_ABSENCE_PLAN_ID
Columns
Name Datatype Length Mandatory Comments
GAP_ABSENCE_PLAN_ID NUMBER (15) Y Absence plan Id
ASSIGNMENT_ID NUMBER (10) Y Assignment Id
ABSENCE_ATTENDANCE_ID NUMBER (10) Y Absence attendance id
PL_ID NUMBER (10) Y Plan ID is a foreign key to BEN_PL_F table
LAST_GAP_DAILY_ABSENCE_DATE DATE

Last day of absence
LAST_UPDATED_BY NUMBER (15)
Standard who column
LAST_UPDATE_DATE DATE

Standard who column
CREATED_BY NUMBER (15)
Standard who column
CREATION_DATE DATE

Standard who column
OBJECT_VERSION_NUMBER NUMBER (15)
Standard who column
LAST_UPDATE_LOGIN NUMBER (15)
Standard who column

[top of page]

HR.PQP_GAP_ABSENCE_PLANS does not reference any database object

HR.PQP_GAP_ABSENCE_PLANS is referenced by following:

APPS
SYNONYM - PQP_GAP_ABSENCE_PLANS
TRIGGER - PQP_GAP_ABSENCE_PLANS_WHO
PUBLIC
SYNONYM - PQP_GAP_ABSENCE_PLANS

[top of page]

Table: PQP_GAP_DAILY_ABSENCES

Description: This table is used to store daily absence details like absence date, work pattern and the level of entitlement for an absence plan.
Primary Key: PQP_GAP_DAILY_ABSENCES_PK
  1. GAP_DAILY_ABSENCE_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
PQP_GAP_DAILY_ABSENCES.GAP_ABSENCE_PLAN_ID PQP_GAP_ABSENCE_PLANS
Comments

This table is used to store daily absence details like absence date, work pattern and the level of entitlement for an absence plan.

Indexes
Index Type Tablespace Column
PQP_GAP_DAILY_ABSENCES_N1 NONUNIQUE APPS_TS_TX_IDX GAP_ABSENCE_PLAN_ID
ABSENCE_DATE
Columns
Name Datatype Length Mandatory Comments
GAP_DAILY_ABSENCE_ID NUMBER (15) Y Primary key
GAP_ABSENCE_PLAN_ID NUMBER (15) Y Foreign key to PQP_GAP_ABSENCE_PLANS table.
ABSENCE_DATE DATE
Y The date of a day or fraction of a day of an absence.
WORK_PATTERN_DAY_TYPE VARCHAR2 (30) Y Work Pattern Day Type WORKON or OFFWORK
LEVEL_OF_ENTITLEMENT VARCHAR2 (30) Y Level of entitlement is the entitlement band info
LEVEL_OF_PAY VARCHAR2 (30) Y Band info for paid days
DURATION NUMBER (11) Y Duration for this day or a fraction of the day.
LAST_UPDATED_BY NUMBER (15)
Standard who column
LAST_UPDATE_DATE DATE

Standard who column
CREATED_BY NUMBER (15)
Standard who column
CREATION_DATE DATE

Standard who column
OBJECT_VERSION_NUMBER NUMBER (15)
Standard who column
DURATION_IN_HOURS NUMBER (11)
Duration for this day or fraction of the day expressed in hours.
LAST_UPDATE_LOGIN NUMBER (15)
Standard who column
WORKING_DAYS_PER_WEEK NUMBER (6)
Average number of days per week that a person worked on this day of absence.
FTE NUMBER (25)
Full Time Equivalent of the assignment as of the absence date.

[top of page]

HR.PQP_GAP_DAILY_ABSENCES does not reference any database object

HR.PQP_GAP_DAILY_ABSENCES is referenced by following:

APPS
SYNONYM - PQP_GAP_DAILY_ABSENCES
TRIGGER - PQP_GAP_DAILY_ABSENCES_WHO
PUBLIC
SYNONYM - PQP_GAP_DAILY_ABSENCES

[top of page]

Table: PQP_GAP_DURATION_SUMMARY

Description:
Primary Key: PQP_GAP_DURATION_SUMMARY_PK
  1. GAP_DURATION_SUMMARY_ID
Comments

This table is used to store absence details like Absence star date , Absence end date, No. of days in each band level of absence.
This table will be populated with the above data when the person enrolls into the absence with the configuration for log duration summary set to Yes

Indexes
Index Type Tablespace Column
PQP_GAP_DURATION_SUMMARY_N3 NONUNIQUE APPS_TS_TX_IDX ASSIGNMENT_ID
SUMMARY_TYPE
DATE_START
Columns
Name Datatype Length Mandatory Comments
GAP_DURATION_SUMMARY_ID NUMBER (15) Y Primary Key
ASSIGNMENT_ID NUMBER (10) Y Holds the assignment id
GAP_ABSENCE_PLAN_ID NUMBER (15) Y GAP absence plan id
SUMMARY_TYPE VARCHAR2 (30) Y Indicates the summary type
GAP_LEVEL VARCHAR2 (30) Y Indicates the GAP level
DURATION_IN_DAYS NUMBER (15) Y Duration in days
DURATION_IN_HOURS NUMBER (15) Y Duration in hours
DATE_START DATE
Y Start date of the absence duration
DATE_END DATE
Y End date of the absence duration
OBJECT_VERSION_NUMBER NUMBER (15) Y Standard WHO column
CREATED_BY NUMBER (15) Y Standard WHO column
CREATION_DATE DATE
Y Standard WHO column
LAST_UPDATED_BY NUMBER (15) Y Standard WHO column
LAST_UPDATE_DATE DATE
Y Standard WHO column
LAST_UPDATE_LOGIN NUMBER (15)
Standard WHO column

[top of page]

HR.PQP_GAP_DURATION_SUMMARY does not reference any database object

HR.PQP_GAP_DURATION_SUMMARY is referenced by following:

APPS
SYNONYM - PQP_GAP_DURATION_SUMMARY
TRIGGER - PQP_GAP_DURATION_SUMMARY_WHO
PUBLIC
SYNONYM - PQP_GAP_DURATION_SUMMARY

[top of page]

Table: PQP_PENSION_TYPES_F

Description: This table is used to store the pension types.
Primary Key: PQP_PENSION_TYPES_F_PK
  1. PENSION_TYPE_ID
  2. EFFECTIVE_START_DATE
  3. EFFECTIVE_END_DATE
Primary Key: PQP_PENSION_TYPES_PK
  1. PENSION_TYPE_ID
  2. EFFECTIVE_START_DATE
  3. EFFECTIVE_END_DATE
Comments

This table is used to store the details of a pension type. Information from this table is used for calculation of pension deductions.

Indexes
Index Type Tablespace Column
PQP_PENSION_TYPES_F_PK NONUNIQUE APPS_TS_TX_IDX PENSION_TYPE_ID
EFFECTIVE_START_DATE
EFFECTIVE_END_DATE
Columns
Name Datatype Length Mandatory Comments
PENSION_TYPE_ID NUMBER (10) Y Unique identifier for the pension type. Generated by the sequence PQP_PENSION_TYPES_S.
EFFECTIVE_START_DATE DATE
Y Effective Start Date for the pension type.
EFFECTIVE_END_DATE DATE
Y Effective End Date for the pension type.
PENSION_TYPE_NAME VARCHAR2 (240) Y Name of the Pension Type
PENSION_CATEGORY VARCHAR2 (30) Y Category of the Pension Type. Valid values are defined by PQP_PENSION_CATEGORY lookup type.
PENSION_PROVIDER_TYPE VARCHAR2 (30)
Pension Provider Type. Valid values are defined by PQP_NL_PENSION_PROVIDER_TYPE lookup type.
SALARY_CALCULATION_METHOD VARCHAR2 (30)
Calculation method for pension salary. Valid values are defined by PQP_NL_SALARY_CALC_METHOD lookup type.
THRESHOLD_CONVERSION_RULE VARCHAR2 (30)
Calculation method for conversion of annual thresholds. Valid values are defined by PQP_NL_CONVERSION_RULE lookup type.
CONTRIBUTION_CONVERSION_RULE VARCHAR2 (30)
Conversion rule for annual contributions. Valid values are defined by PQP_NL_CONVERSION_RULE lookup type.
ER_ANNUAL_LIMIT NUMBER (14)
Annual limit for employer contributions.
EE_ANNUAL_LIMIT NUMBER (14)
Annual limit for employee contributions.
EE_ANNUAL_SALARY_THRESHOLD NUMBER (14)
Annual threshold for the employee's pensionable salary used in the calculation of the employee pension contribution.
ER_ANNUAL_SALARY_THRESHOLD NUMBER (14)
Annual threshold for the employee's pensionable salary used in the calculation of the employer pension contribution.
CREATED_BY NUMBER (15) Y Standard Who Column
LAST_UPDATE_DATE DATE
Y Standard Who Column
CREATION_DATE DATE
Y Standard Who Column
LAST_UPDATED_BY NUMBER (15) Y Standard Who Column
OBJECT_VERSION_NUMBER NUMBER (9) Y System generated version of row. Increments by one with each update.
LAST_UPDATE_LOGIN NUMBER (15)
Standard Who Column
BUSINESS_GROUP_ID NUMBER (15)
Business Group Identifier
LEGISLATION_CODE VARCHAR2 (30)
Legislation Code
DESCRIPTION VARCHAR2 (240)
Description of the pension type.
MINIMUM_AGE NUMBER (3)
Minimum Age of the employee to contribute towards pensions.
EE_CONTRIBUTION_PERCENT NUMBER (7)
Employee Contribution Percentage
MAXIMUM_AGE NUMBER (3)
Maximum Age of the employee to contribute towards pensions.
ER_CONTRIBUTION_PERCENT NUMBER (7)
Employer Contribution Percent
EE_ANNUAL_CONTRIBUTION NUMBER (14)
Employee contribution annual limit.
ER_ANNUAL_CONTRIBUTION NUMBER (14)
Employer contribution annual limit.
ANNUAL_PREMIUM_AMOUNT NUMBER (14)
Fixed premium amount provided by the pension provider for employee and employer pension contributions.
EE_CONTRIBUTION_BAL_TYPE_ID NUMBER (9)
Employee Contribution Balance Type Identifier
ER_CONTRIBUTION_BAL_TYPE_ID NUMBER (9)
Employer Contribution Balance Type Identifier
BALANCE_INIT_ELEMENT_TYPE_ID NUMBER (9)
Balance Intialization Element Type Identifier
PTY_ATTRIBUTE_CATEGORY VARCHAR2 (30)
Descriptive Flexfield Column
PTY_ATTRIBUTE1 VARCHAR2 (150)
Descriptive Flexfield Column
PTY_ATTRIBUTE2 VARCHAR2 (150)
Descriptive Flexfield Column
PTY_ATTRIBUTE3 VARCHAR2 (150)
Descriptive Flexfield Column
PTY_ATTRIBUTE4 VARCHAR2 (150)
Descriptive Flexfield Column
PTY_ATTRIBUTE5 VARCHAR2 (150)
Descriptive Flexfield Column
PTY_ATTRIBUTE6 VARCHAR2 (150)
Descriptive Flexfield Column
PTY_ATTRIBUTE7 VARCHAR2 (150)
Descriptive Flexfield Column
PTY_ATTRIBUTE8 VARCHAR2 (150)
Descriptive Flexfield Column
PTY_ATTRIBUTE9 VARCHAR2 (150)
Descriptive Flexfield Column
PTY_ATTRIBUTE10 VARCHAR2 (150)
Descriptive Flexfield Column
PTY_ATTRIBUTE11 VARCHAR2 (150)
Descriptive Flexfield Column
PTY_ATTRIBUTE12 VARCHAR2 (150)
Descriptive Flexfield Column
PTY_ATTRIBUTE13 VARCHAR2 (150)
Descriptive Flexfield Column
PTY_ATTRIBUTE14 VARCHAR2 (150)
Descriptive Flexfield Column
PTY_ATTRIBUTE15 VARCHAR2 (150)
Descriptive Flexfield Column
PTY_ATTRIBUTE16 VARCHAR2 (150)
Descriptive Flexfield Column
PTY_ATTRIBUTE17 VARCHAR2 (150)
Descriptive Flexfield Column
PTY_ATTRIBUTE18 VARCHAR2 (150)
Descriptive Flexfield Column
PTY_ATTRIBUTE19 VARCHAR2 (150)
Descriptive Flexfield Column
PTY_ATTRIBUTE20 VARCHAR2 (150)
Descriptive Flexfield Column
PTY_INFORMATION_CATEGORY VARCHAR2 (30)
Developer Descriptive Flexfield Column
PTY_INFORMATION1 VARCHAR2 (150)
Developer Descriptive Flexfield Column
PTY_INFORMATION2 VARCHAR2 (150)
Developer Descriptive Flexfield Column
PTY_INFORMATION3 VARCHAR2 (150)
Developer Descriptive Flexfield Column
PTY_INFORMATION4 VARCHAR2 (150)
Developer Descriptive Flexfield Column
PTY_INFORMATION5 VARCHAR2 (150)
Developer Descriptive Flexfield Column
PTY_INFORMATION6 VARCHAR2 (150)
Developer Descriptive Flexfield Column
PTY_INFORMATION7 VARCHAR2 (150)
Developer Descriptive Flexfield Column
PTY_INFORMATION8 VARCHAR2 (150)
Developer Descriptive Flexfield Column
PTY_INFORMATION9 VARCHAR2 (150)
Developer Descriptive Flexfield Column
PTY_INFORMATION10 VARCHAR2 (150)
Developer Descriptive Flexfield Column
PTY_INFORMATION11 VARCHAR2 (150)
Developer Descriptive Flexfield Column
PTY_INFORMATION12 VARCHAR2 (150)
Developer Descriptive Flexfield Column
PTY_INFORMATION13 VARCHAR2 (150)
Developer Descriptive Flexfield Column
PTY_INFORMATION14 VARCHAR2 (150)
Developer Descriptive Flexfield Column
PTY_INFORMATION15 VARCHAR2 (150)
Developer Descriptive Flexfield Column
PTY_INFORMATION16 VARCHAR2 (150)
Developer Descriptive Flexfield Column
PTY_INFORMATION17 VARCHAR2 (150)
Developer Descriptive Flexfield Column
PTY_INFORMATION18 VARCHAR2 (150)
Developer Descriptive Flexfield Column
PTY_INFORMATION19 VARCHAR2 (150)
Developer Descriptive Flexfield Column
PTY_INFORMATION20 VARCHAR2 (150)
Developer Descriptive Flexfield Column
EE_CONTRIBUTION_FIXED_RATE NUMBER (8)
Fixed rate for Employee Contribution
ER_CONTRIBUTION_FIXED_RATE NUMBER (8)
Fixed rate for Employer Contribution
SPECIAL_PENSION_TYPE_CODE VARCHAR2 (30)
Holds pension type code for special pensions (ABP/PGGM)
PENSION_SUB_CATEGORY VARCHAR2 (30)
Sub Category of the pension type. Valid values are defined by PQP_PENSION_SUB_CATEGORY lookup type.
PENSION_BASIS_CALC_METHOD VARCHAR2 (30)
Pension basis calculation method. Valid values are defined by PQP_PENSION_BASIS_CALC_MTHD lookup type.
PENSION_SALARY_BALANCE NUMBER (9)
Pension salary balance identifier for the pension type
RECURRING_BONUS_PERCENT NUMBER (7)
Recurring bonus percentage for the pension type
NON_RECURRING_BONUS_PERCENT NUMBER (7)
Non recurring bonus percentage for the pension type
RECURRING_BONUS_BALANCE NUMBER (9)
Recurring bonus balance identifier.
NON_RECURRING_BONUS_BALANCE NUMBER (9)
Non Recurring bonus balance identifier.
STD_TAX_REDUCTION VARCHAR2 (30)
Reduction order for Standard Tax balance.This column is specific to the Netherlands localization.
SPL_TAX_REDUCTION VARCHAR2 (30)
Reduction order for Special Tax balance. This column is specific to the Netherlands localization.
SIG_SAL_SPL_TAX_REDUCTION VARCHAR2 (30)
Reduction order for SI Gross Salary Special Tax balance.This column is specific to the Netherlands localization.
SIG_SAL_NON_TAX_REDUCTION VARCHAR2 (30)
Reduction order for SI Gross Salary Non Tax balance.This column is specific to the Netherlands localization.
SIG_SAL_STD_TAX_REDUCTION VARCHAR2 (30)
Reduction order for SI Gross Salary Standard Tax balance.This column is specific to the Netherlands localization.
SII_STD_TAX_REDUCTION VARCHAR2 (30)
Reduction order for SI Income Standard Tax balance.This column is specific to the Netherlands localization.
SII_SPL_TAX_REDUCTION VARCHAR2 (30)
Reduction order for SI Income Special Tax balance.This column is specific to the Netherlands localization.
SII_NON_TAX_REDUCTION VARCHAR2 (30)
Reduction order for SI Income Non Tax balance.This column is specific to the Netherlands localization.
PREVIOUS_YEAR_BONUS_INCLUDED VARCHAR2 (30)
Indicator for including previous year bonus
RECURRING_BONUS_PERIOD VARCHAR2 (30)
The period for recurring bonus
NON_RECURRING_BONUS_PERIOD VARCHAR2 (30)
The period for non recurring bonus
EE_AGE_THRESHOLD VARCHAR2 (30)
This column holds information regarding the age dependent employee thresholds of a pension type and is specific to the Netherlands localization.
ER_AGE_THRESHOLD VARCHAR2 (30)
This column holds information regarding the age dependent employer thresholds of a pension type and is specific to the Netherlands localization.
EE_AGE_CONTRIBUTION VARCHAR2 (30)
Indicates if the pension type has age dependent employee contributions. This column is specific to the Netherlands localization.
ER_AGE_CONTRIBUTION VARCHAR2 (30)
Indicates if the pension type has age dependent employer contributions. This column is specifit to the Netherlands localization.

[top of page]

HR.PQP_PENSION_TYPES_F does not reference any database object

HR.PQP_PENSION_TYPES_F is referenced by following:

APPS
SYNONYM - PQP_PENSION_TYPES_F
TRIGGER - PQP_PENSION_TYPES_F_WHO
PUBLIC
SYNONYM - PQP_PENSION_TYPES_F

[top of page]

Table: PQP_SERVICE_HISTORY_PERIODS

Description: Table to hold information regarding relevant perids of previous employment.
Primary Key: PQP_SERVICE_HISTORY_PERIODS_PK
  1. SERVICE_HISTORY_PERIOD_ID
Comments

PQP_SERVICE_HISTORY_PERIODS is the table that holds information relating to any relevant periods of previous employment that a person may have had. Information held includes details on the employer, when the period of employment began and ended, and whether or not it was continuous.

Primary Key: PQP_SERVICE_HISTORY_PERIODS_PK
  1. SERVICE_HISTORY_PERIOD_ID
Indexes
Index Type Tablespace Column
PQP_SERVICE_HISTORY_PERIODS_PK UNIQUE APPS_TS_TX_IDX SERVICE_HISTORY_PERIOD_ID
Columns
Name Datatype Length Mandatory Comments
SERVICE_HISTORY_PERIOD_ID NUMBER (15) Y System generated primary key
BUSINESS_GROUP_ID NUMBER (15) Y Foreign key to HR_ORGANIZATION_UNITS
ASSIGNMENT_ID NUMBER (15) Y Foreign key to PER_ASSIGNMENTS_F
START_DATE DATE

Start Date of period of employment history
END_DATE DATE

End date of period of employment history
EMPLOYER_NAME VARCHAR2 (80)
Name of employer
EMPLOYER_ADDRESS VARCHAR2 (240)
Address of employer
EMPLOYER_TYPE VARCHAR2 (80)
Type of employer
EMPLOYER_SUBTYPE VARCHAR2 (80)
Subtype of employer
PERIOD_YEARS NUMBER (15)
Total number of years employed
PERIOD_DAYS NUMBER (15)
Total number of days employed after years have been subtracted
DESCRIPTION VARCHAR2 (240)
Optional description
CONTINUOUS_SERVICE VARCHAR2 (240)
Indicates whether row should be considered as continuous service
ALL_ASSIGNMENTS VARCHAR2 (30)
Indicates whether row applies to all assignments
LAST_UPDATE_DATE DATE

Standard Who Column
LAST_UPDATED_BY NUMBER (15)
Standard Who Column
LAST_UPDATE_LOGIN NUMBER (15)
Standard Who Column
CREATED_BY NUMBER (15)
Standard Who Column
CREATION_DATE DATE

Standard Who Column
OBJECT_VERSION_NUMBER NUMBER (15) Y System generated version of row. Increments by one with each update
SHP_ATTRIBUTE_CATEGORY VARCHAR2 (30)
Descriptive flexfield column
SHP_ATTRIBUTE1 VARCHAR2 (150)
Descriptive flexfield column
SHP_ATTRIBUTE2 VARCHAR2 (150)
Descriptive flexfield column
SHP_ATTRIBUTE3 VARCHAR2 (150)
Descriptive flexfield column
SHP_ATTRIBUTE4 VARCHAR2 (150)
Descriptive flexfield column
SHP_ATTRIBUTE5 VARCHAR2 (150)
Descriptive flexfield column
SHP_ATTRIBUTE6 VARCHAR2 (150)
Descriptive flexfield column
SHP_ATTRIBUTE7 VARCHAR2 (150)
Descriptive flexfield column
SHP_ATTRIBUTE8 VARCHAR2 (150)
Descriptive flexfield column
SHP_ATTRIBUTE9 VARCHAR2 (150)
Descriptive flexfield column
SHP_ATTRIBUTE10 VARCHAR2 (150)
Descriptive flexfield column
SHP_ATTRIBUTE11 VARCHAR2 (150)
Descriptive flexfield column
SHP_ATTRIBUTE12 VARCHAR2 (150)
Descriptive flexfield column
SHP_ATTRIBUTE13 VARCHAR2 (150)
Descriptive flexfield column
SHP_ATTRIBUTE14 VARCHAR2 (150)
Descriptive flexfield column
SHP_ATTRIBUTE15 VARCHAR2 (150)
Descriptive flexfield column
SHP_ATTRIBUTE16 VARCHAR2 (150)
Descriptive flexfield column
SHP_ATTRIBUTE17 VARCHAR2 (150)
Descriptive flexfield column
SHP_ATTRIBUTE18 VARCHAR2 (150)
Descriptive flexfield column
SHP_ATTRIBUTE19 VARCHAR2 (150)
Descriptive flexfield column
SHP_ATTRIBUTE20 VARCHAR2 (150)
Descriptive flexfield column
SHP_INFORMATION_CATEGORY VARCHAR2 (30)
Developer descriptive flexfield column
SHP_INFORMATION1 VARCHAR2 (150)
Developer descriptive flexfield column
SHP_INFORMATION2 VARCHAR2 (150)
Developer descriptive flexfield column
SHP_INFORMATION3 VARCHAR2 (150)
Developer descriptive flexfield column
SHP_INFORMATION4 VARCHAR2 (150)
Developer descriptive flexfield column
SHP_INFORMATION5 VARCHAR2 (150)
Developer descriptive flexfield column
SHP_INFORMATION6 VARCHAR2 (150)
Developer descriptive flexfield column
SHP_INFORMATION7 VARCHAR2 (150)
Developer descriptive flexfield column
SHP_INFORMATION8 VARCHAR2 (150)
Developer descriptive flexfield column
SHP_INFORMATION9 VARCHAR2 (150)
Developer descriptive flexfield column
SHP_INFORMATION10 VARCHAR2 (150)
Developer descriptive flexfield column
SHP_INFORMATION11 VARCHAR2 (150)
Developer descriptive flexfield column
SHP_INFORMATION12 VARCHAR2 (150)
Developer descriptive flexfield column
SHP_INFORMATION13 VARCHAR2 (150)
Developer descriptive flexfield column
SHP_INFORMATION14 VARCHAR2 (150)
Developer descriptive flexfield column
SHP_INFORMATION15 VARCHAR2 (150)
Developer descriptive flexfield column
SHP_INFORMATION16 VARCHAR2 (150)
Developer descriptive flexfield column
SHP_INFORMATION17 VARCHAR2 (150)
Developer descriptive flexfield column
SHP_INFORMATION18 VARCHAR2 (150)
Developer descriptive flexfield column
SHP_INFORMATION19 VARCHAR2 (150)
Developer descriptive flexfield column
SHP_INFORMATION20 VARCHAR2 (150)
Developer descriptive flexfield column

[top of page]

HR.PQP_SERVICE_HISTORY_PERIODS does not reference any database object

HR.PQP_SERVICE_HISTORY_PERIODS is referenced by following:

APPS
SYNONYM - PQP_SERVICE_HISTORY_PERIODS
TRIGGER - PQP_SERVICE_HISTORY_PERIOD_WHO
PUBLIC
SYNONYM - PQP_SERVICE_HISTORY_PERIODS

[top of page]

Table: PQP_VEHICLE_ALLOCATIONS_F

Description: Table used to keep track of the association of a vehicle to an assignment.
Primary Key: PQP_VEHICLE_ALLOCATIONS_F_PK
  1. VEHICLE_ALLOCATION_ID
  2. EFFECTIVE_START_DATE
  3. EFFECTIVE_END_DATE
Primary Key: PQP_VEHICLE_ALLOCATIONS_PK
  1. VEHICLE_ALLOCATION_ID
  2. EFFECTIVE_START_DATE
  3. EFFECTIVE_END_DATE
Comments

This datetracked table is used to store the vehicle allocation details for an assignment. Along with the vehicle repository id, it also holds details like vehicle usage type, rate table and element information for payroll.

Indexes
Index Type Tablespace Column
PQP_VEHICLE_ALLOCATIONS_F_N1 NONUNIQUE APPS_TS_TX_IDX ASSIGNMENT_ID
VEHICLE_REPOSITORY_ID
BUSINESS_GROUP_ID
PQP_VEHICLE_ALLOCATIONS_F_PK NONUNIQUE APPS_TS_TX_IDX VEHICLE_ALLOCATION_ID
EFFECTIVE_START_DATE
EFFECTIVE_END_DATE
Columns
Name Datatype Length Mandatory Comments
VEHICLE_ALLOCATION_ID NUMBER (10) Y System generated primary key column from the sequence PQP_VEHICLE_ALLOCATIONS_F_S.
EFFECTIVE_START_DATE DATE
Y Effective Start Date for this record.
EFFECTIVE_END_DATE DATE
Y Effective end date for this record.
ASSIGNMENT_ID NUMBER (10) Y The Assignment Id of the person having this vehicle allocation.
BUSINESS_GROUP_ID NUMBER (15) Y Business Group Identifier
ACROSS_ASSIGNMENTS VARCHAR2 (30)
Identifies whether the vehicle allocation is across assignments if there are multiple assignments for this employee.
VEHICLE_REPOSITORY_ID NUMBER (10)
The vehicle which is being allocated to this assignment. The id is from PQP_VEHICLE_REPOSITORY_F table.
USAGE_TYPE VARCHAR2 (30)
The usage type for this allocation. This value depends on the type of vehicle being allocated and is from the lookups PQP_COMPANY_VEHICLE_USER or PQP_PRIVATE_VEHICLE_USER.
CAPITAL_CONTRIBUTION NUMBER (11)
The Capital Contribution from the employee towards this vehicle.
PRIVATE_CONTRIBUTION NUMBER (11)
The private contribution from the em.ployee towards this vehicle.
DEFAULT_VEHICLE VARCHAR2 (1)
Identifies whether this vehicle should be treated as the default vehicle for mileage claims when more than one vehicle is allocated.
FUEL_CARD VARCHAR2 (30)
Identifies whether a fuel card has been given for this allocation.
FUEL_CARD_NUMBER VARCHAR2 (30)
The Fuel card number if fuel card has been given
FUEL_BENEFIT VARCHAR2 (30)
Identifies whether there is any additional fuel benefit for this allocation.
CALCULATION_METHOD VARCHAR2 (80)
The calculation method used for mileage calculation. The value is from the lookup PQP_VEHICLE_CALC_METHOD.
RATES_TABLE_ID NUMBER (10)
The rates table Identifier if the mileage rates should be based on a particular user defined table.
ELEMENT_TYPE_ID NUMBER (10)
The Element Type Id if a particular element should be used for mileage calculations.
VAL_ATTRIBUTE_CATEGORY VARCHAR2 (30)
Descriptive Flexfield Column
VAL_ATTRIBUTE1 VARCHAR2 (150)
Descriptive Flexfield Column
VAL_ATTRIBUTE2 VARCHAR2 (150)
Descriptive Flexfield Column
VAL_ATTRIBUTE3 VARCHAR2 (150)
Descriptive Flexfield Column
VAL_ATTRIBUTE4 VARCHAR2 (150)
Descriptive Flexfield Column
VAL_ATTRIBUTE5 VARCHAR2 (150)
Descriptive Flexfield Column
VAL_ATTRIBUTE6 VARCHAR2 (150)
Descriptive Flexfield Column
VAL_ATTRIBUTE7 VARCHAR2 (150)
Descriptive Flexfield Column
VAL_ATTRIBUTE8 VARCHAR2 (150)
Descriptive Flexfield Column
VAL_ATTRIBUTE9 VARCHAR2 (150)
Descriptive Flexfield Column
VAL_ATTRIBUTE10 VARCHAR2 (150)
Descriptive Flexfield Column
VAL_ATTRIBUTE11 VARCHAR2 (150)
Descriptive Flexfield Column
VAL_ATTRIBUTE12 VARCHAR2 (150)
Descriptive Flexfield Column
VAL_ATTRIBUTE13 VARCHAR2 (150)
Descriptive Flexfield Column
VAL_ATTRIBUTE14 VARCHAR2 (150)
Descriptive Flexfield Column
VAL_ATTRIBUTE15 VARCHAR2 (150)
Descriptive Flexfield Column
VAL_ATTRIBUTE16 VARCHAR2 (150)
Descriptive Flexfield Column
VAL_ATTRIBUTE17 VARCHAR2 (150)
Descriptive Flexfield Column
VAL_ATTRIBUTE18 VARCHAR2 (150)
Descriptive Flexfield Column
VAL_ATTRIBUTE19 VARCHAR2 (150)
Descriptive Flexfield Column
VAL_ATTRIBUTE20 VARCHAR2 (150)
Descriptive Flexfield Column
VAL_INFORMATION_CATEGORY VARCHAR2 (30)
Developer Descriptive Flexfield Column
VAL_INFORMATION1 VARCHAR2 (150)
Developer Descriptive Flexfield Column
VAL_INFORMATION2 VARCHAR2 (150)
Developer Descriptive Flexfield Column
VAL_INFORMATION3 VARCHAR2 (150)
Developer Descriptive Flexfield Column
VAL_INFORMATION4 VARCHAR2 (150)
Developer Descriptive Flexfield Column
VAL_INFORMATION5 VARCHAR2 (150)
Developer Descriptive Flexfield Column
VAL_INFORMATION6 VARCHAR2 (150)
Developer Descriptive Flexfield Column
VAL_INFORMATION7 VARCHAR2 (150)
Developer Descriptive Flexfield Column
VAL_INFORMATION8 VARCHAR2 (150)
Developer Descriptive Flexfield Column
VAL_INFORMATION9 VARCHAR2 (150)
Developer Descriptive Flexfield Column
VAL_INFORMATION10 VARCHAR2 (150)
Developer Descriptive Flexfield Column
VAL_INFORMATION11 VARCHAR2 (150)
Developer Descriptive Flexfield Column
VAL_INFORMATION12 VARCHAR2 (150)
Developer Descriptive Flexfield Column
VAL_INFORMATION13 VARCHAR2 (150)
Developer Descriptive Flexfield Column
VAL_INFORMATION14 VARCHAR2 (150)
Developer Descriptive Flexfield Column
VAL_INFORMATION15 VARCHAR2 (150)
Developer Descriptive Flexfield Column
VAL_INFORMATION16 VARCHAR2 (150)
Developer Descriptive Flexfield Column
VAL_INFORMATION17 VARCHAR2 (150)
Developer Descriptive Flexfield Column
VAL_INFORMATION18 VARCHAR2 (150)
Developer Descriptive Flexfield Column
VAL_INFORMATION19 VARCHAR2 (150)
Developer Descriptive Flexfield Column
VAL_INFORMATION20 VARCHAR2 (150)
Developer Descriptive Flexfield Column
CREATED_BY NUMBER (15) Y Standard Who Column
CREATION_DATE DATE
Y Standard Who Column
LAST_UPDATE_DATE DATE
Y Standard Who Column
LAST_UPDATED_BY NUMBER (15) Y Standard Who Column
LAST_UPDATE_LOGIN NUMBER (15)
Standard Who Column
OBJECT_VERSION_NUMBER NUMBER (9) Y System generated version of row. Increments by one with each update.
INSURANCE_NUMBER VARCHAR2 (80)
The insurance details for the vehicle.
INSURANCE_EXPIRY_DATE DATE

Insurance expiration date.
PRIVATE_USE_FLAG VARCHAR2 (30)
Indicates whether the company vehicle user can use this vehicle for private purposes.
SLIDING_RATES_INFO VARCHAR2 (150)
The Sliding rates table information using the lookup PQP_SLIDING_RATES.

[top of page]

HR.PQP_VEHICLE_ALLOCATIONS_F does not reference any database object

HR.PQP_VEHICLE_ALLOCATIONS_F is referenced by following:

APPS
SYNONYM - PQP_VEHICLE_ALLOCATIONS_F
TRIGGER - PQP_VEHICLE_ALLOCATIONS_F_WHO

[top of page]

Table: PQP_VEHICLE_DETAILS

Description: Table to store the vehicle details including private and company vehicles. This table has been superseded by PQP_VEHICLE_REPOSITORY_F which is a datetracked table.
Primary Key: PQP_VEHICLE_DETAILS_PK
  1. VEHICLE_DETAILS_ID
Comments

Table to store details about vehicles used by employees. This table is no longer in use and has been superseded by the datetracked table PQP_VEHICLE_REPOSITORY_F.

Primary Key: PQP_VEHICLE_DETAILS_PK
  1. VEHICLE_DETAILS_ID
Indexes
Index Type Tablespace Column
PQP_VEHICLE_DETAILS_PK UNIQUE APPS_TS_TX_IDX VEHICLE_DETAILS_ID
Columns
Name Datatype Length Mandatory Comments
VEHICLE_DETAILS_ID NUMBER (10) Y System generated primary key column
VEHICLE_TYPE VARCHAR2 (30) Y Identifies the vehicle type
BUSINESS_GROUP_ID NUMBER (15)
Foreign Key to HR_ORGANIZATION_UNITS
REGISTRATION_NUMBER VARCHAR2 (30) Y The registraction number of the vehicle.
MAKE VARCHAR2 (30) Y The make of the vehicle
MODEL VARCHAR2 (30) Y Idetifies the vehicle model
VEHICLE_IDENTIFICATION_NUMBER VARCHAR2 (50)
The unique identification number for the vehicle.
DATE_FIRST_REGISTERED DATE
Y Date the vehicle was registered for the first time.
ENGINE_CAPACITY_IN_CC NUMBER
Y Vehicle's engine size in cubic capacity.
FUEL_TYPE VARCHAR2 (30) Y Vehicle's fuel type
FUEL_CARD VARCHAR2 (30) Y Fuel card for the vehicle.
CURRENCY_CODE VARCHAR2 (30) Y Identifies the currency code for all the monetary columns in this table.
LIST_PRICE NUMBER
Y The list price of the vehicle.
ACCESSORY_VALUE_AT_STARTDATE NUMBER

Price of optional accessories fitted when the vehicle was first made available to the employee.
ACCESSORY_VALUE_ADDED_LATER NUMBER

Price of optional accessories fitted after the vehicle was first made available to the employee.
MARKET_VALUE_CLASSIC_CAR NUMBER

The market value for the classic car.
CO2_EMISSIONS NUMBER

CO2 emissions in grams per kilometer.
VEHICLE_PROVIDER VARCHAR2 (60)
The name of the vehicle provider.
VEHICLE_OWNERSHIP VARCHAR2 (30)
The ownerships of the vehicle.
CREATED_BY NUMBER (15) Y Standard WHO column
CREATION_DATE DATE
Y Standard WHO column
LAST_UPDATE_DATE DATE

Standard WHO column
LAST_UPDATED_BY NUMBER (15)
Standard WHO column
LAST_UPDATE_LOGIN NUMBER (15)
Standard WHO column
OBJECT_VERSION_NUMBER NUMBER (9) Y System generated version of row. Increments by one with each update.
VHD_ATTRIBUTE_CATEGORY VARCHAR2 (30)
Developer descriptive flexfield column
VHD_ATTRIBUTE1 VARCHAR2 (150)
Descriptive flexfield column
VHD_ATTRIBUTE2 VARCHAR2 (150)
Descriptive flexfield column
VHD_ATTRIBUTE3 VARCHAR2 (150)
Descriptive flexfield column
VHD_ATTRIBUTE4 VARCHAR2 (150)
Descriptive flexfield column
VHD_ATTRIBUTE5 VARCHAR2 (150)
Descriptive flexfield column
VHD_ATTRIBUTE6 VARCHAR2 (150)
Descriptive flexfield column
VHD_ATTRIBUTE7 VARCHAR2 (150)
Descriptive flexfield column
VHD_ATTRIBUTE8 VARCHAR2 (150)
Descriptive flexfield column
VHD_ATTRIBUTE9 VARCHAR2 (150)
Descriptive flexfield column
VHD_ATTRIBUTE10 VARCHAR2 (150)
Descriptive flexfield column
VHD_ATTRIBUTE11 VARCHAR2 (150)
Descriptive flexfield column
VHD_ATTRIBUTE12 VARCHAR2 (150)
Descriptive flexfield column
VHD_ATTRIBUTE13 VARCHAR2 (150)
Descriptive flexfield column
VHD_ATTRIBUTE14 VARCHAR2 (150)
Descriptive flexfield column
VHD_ATTRIBUTE15 VARCHAR2 (150)
Descriptive flexfield column
VHD_ATTRIBUTE16 VARCHAR2 (150)
Descriptive flexfield column
VHD_ATTRIBUTE17 VARCHAR2 (150)
Descriptive flexfield column
VHD_ATTRIBUTE18 VARCHAR2 (150)
Descriptive flexfield column
VHD_ATTRIBUTE19 VARCHAR2 (150)
Descriptive flexfield column
VHD_ATTRIBUTE20 VARCHAR2 (150)
Descriptive flexfield column
VHD_INFORMATION_CATEGORY VARCHAR2 (30)
Developer descriptive flexfield column
VHD_INFORMATION1 VARCHAR2 (150)
Developer descriptive flexfield column
VHD_INFORMATION2 VARCHAR2 (150)
Developer descriptive flexfield column
VHD_INFORMATION3 VARCHAR2 (150)
Developer descriptive flexfield column
VHD_INFORMATION4 VARCHAR2 (150)
Developer descriptive flexfield column
VHD_INFORMATION5 VARCHAR2 (150)
Developer descriptive flexfield column
VHD_INFORMATION6 VARCHAR2 (150)
Developer descriptive flexfield column
VHD_INFORMATION7 VARCHAR2 (150)
Developer descriptive flexfield column
VHD_INFORMATION8 VARCHAR2 (150)
Developer descriptive flexfield column
VHD_INFORMATION9 VARCHAR2 (150)
Developer descriptive flexfield column
VHD_INFORMATION10 VARCHAR2 (150)
Developer descriptive flexfield column
VHD_INFORMATION11 VARCHAR2 (150)
Developer descriptive flexfield column
VHD_INFORMATION12 VARCHAR2 (150)
Developer descriptive flexfield column
VHD_INFORMATION13 VARCHAR2 (150)
Developer descriptive flexfield column
VHD_INFORMATION14 VARCHAR2 (150)
Developer descriptive flexfield column
VHD_INFORMATION15 VARCHAR2 (150)
Developer descriptive flexfield column
VHD_INFORMATION16 VARCHAR2 (150)
Developer descriptive flexfield column
VHD_INFORMATION17 VARCHAR2 (150)
Developer descriptive flexfield column
VHD_INFORMATION18 VARCHAR2 (150)
Developer descriptive flexfield column
VHD_INFORMATION19 VARCHAR2 (150)
Developer descriptive flexfield column
VHD_INFORMATION20 VARCHAR2 (150)
Developer descriptive flexfield column

[top of page]

HR.PQP_VEHICLE_DETAILS does not reference any database object

HR.PQP_VEHICLE_DETAILS is referenced by following:

APPS
SYNONYM - PQP_VEHICLE_DETAILS
TRIGGER - PQP_VEHICLE_DETAILS_WHO
PUBLIC
SYNONYM - PQP_VEHICLE_DETAILS

[top of page]

Table: PQP_VEHICLE_DETAILS_EFC

Description: Table used for the EFC conversion of the PQP_VEHICLE_DETAILS.
Primary Key: PQP_VEHICLE_DETAILS_PK1
  1. VEHICLE_DETAILS_ID
Comments

Table used for the EFC conversion of the PQP_VEHICLE_DETAILS.

Indexes
Index Type Tablespace Column
PQP_VEHICLE_DETAILS_EFC_PK NONUNIQUE APPS_TS_TX_IDX VEHICLE_DETAILS_ID
EFC_ACTION_ID
Columns
Name Datatype Length Mandatory Comments
VEHICLE_DETAILS_ID NUMBER (10) Y Foreign key colum for the table PQP_VEHICLE_DETAILS (vehicle_details_id).
CURRENCY_CODE VARCHAR2 (30) Y Currency code to identify the conversion.
LIST_PRICE NUMBER
Y The list price of the vehicle.
ACCESSORY_VALUE_AT_STARTDATE NUMBER

Price of optional accessories fitted when the vehicle was first made available to the employee.
ACCESSORY_VALUE_ADDED_LATER NUMBER

Price of optional accessories fitted after the vehicle was first made available to the employee.
MARKET_VALUE_CLASSIC_CAR NUMBER

Market value of the classic car.
EFC_ACTION_ID NUMBER
Y System generated primary key column

[top of page]

HR.PQP_VEHICLE_DETAILS_EFC does not reference any database object

HR.PQP_VEHICLE_DETAILS_EFC is referenced by following:

APPS
SYNONYM - PQP_VEHICLE_DETAILS_EFC
PUBLIC
SYNONYM - PQP_VEHICLE_DETAILS_EFC

[top of page]

Table: PQP_VEHICLE_REPOSITORY_F

Description: This table is used to store the vehicle details.
Primary Key: PQP_VEHICLE_REPOSITORY_F_PK
  1. VEHICLE_REPOSITORY_ID
  2. EFFECTIVE_START_DATE
  3. EFFECTIVE_END_DATE
Primary Key: PQP_VEHICLE_REPOSITORY_PK
  1. VEHICLE_REPOSITORY_ID
  2. EFFECTIVE_START_DATE
  3. EFFECTIVE_END_DATE
Comments

This is a date tracked table used to store the details for all private and company vehicles.

Indexes
Index Type Tablespace Column
PQP_VEHICLE_REPOSITORY_F_PK UNIQUE APPS_TS_TX_IDX VEHICLE_REPOSITORY_ID
EFFECTIVE_START_DATE
EFFECTIVE_END_DATE
PQP_VEHICLE_REPOSITORY_N1 NONUNIQUE APPS_TS_TX_IDX REGISTRATION_NUMBER
Columns
Name Datatype Length Mandatory Comments
VEHICLE_REPOSITORY_ID NUMBER (10) Y System generated primary key column using the sequence PQP_VEHICLE_REPOSITORY_F_S.
EFFECTIVE_START_DATE DATE
Y Effective Start Date for this record.
EFFECTIVE_END_DATE DATE
Y Effective End Date for this record.
REGISTRATION_NUMBER VARCHAR2 (30)
Registration Number for this vehicle.
VEHICLE_TYPE VARCHAR2 (30) Y Identifies whether the vehicle is a car, motorcycle etc. The codes are from the lookup type PQP_VEHICLE_TYPE.
VEHICLE_ID_NUMBER VARCHAR2 (50)
The unique Vehicle identification number, commonly referred to as VIN or Chasis number.
BUSINESS_GROUP_ID NUMBER (15) Y The Business Group Identifier to which the vehicle belongs to.
MAKE VARCHAR2 (30) Y The Make (manufacturer) of the vehicle.
MODEL VARCHAR2 (30)
The model name of the Vehicle. For example, if the make was 'Honda', then model can be 'Accord'.
INITIAL_REGISTRATION DATE

The date the vehicle was registred for the first time.
LAST_REGISTRATION_RENEW_DATE DATE

The most recent date on which the vehicle registration was renewed.
ENGINE_CAPACITY_IN_CC NUMBER

The Vehicle's engine size in cubic capacity.
FUEL_TYPE VARCHAR2 (30)
The type of fuel used in the vehicle. The codes are from the lookup type PQP_FUEL_TYPE.
CURRENCY_CODE VARCHAR2 (30) Y The currency code for all the monetary columns used in this record. The value should be the same as the Business groups currency code and is from the table FND_CURRENCIES.
LIST_PRICE NUMBER (11)
The basic list price of the Vehicle.
ACCESSORY_VALUE_AT_STARTDATE NUMBER (11)
The value of the accessories in the vehicle at Start Date.
ACCESSORY_VALUE_ADDED_LATER NUMBER (11)
The value of the accessories added later to the vehicle.
MARKET_VALUE_CLASSIC_CAR NUMBER (11)
The market value of the vehicle if it is a Classic vehicle.
FISCAL_RATINGS NUMBER

The Fiscal Ratings of the vehicle.
FISCAL_RATINGS_UOM VARCHAR2 (30)
The Fiscal Ratings Unit of Measure for the vehicle.
VEHICLE_PROVIDER VARCHAR2 (60)
The name of the vehicle provider.
VEHICLE_OWNERSHIP VARCHAR2 (30)
Identifies whether it is a company or private vehicle.
SHARED_VEHICLE VARCHAR2 (30)
Flag to indicate whether the vehicle can be shared (allocated) to multiple employees.
VEHICLE_STATUS VARCHAR2 (30) Y The status of the vehicle, whether it is active or inactive. The values are from the lookup PQP_VEHICLE_STATUS.
VEHICLE_INACTIVITY_REASON VARCHAR2 (30)
The reason for vehicle inactivity. Only used if the status is Inactive (I). The value is from the lookup PQP_VEHICLE_INACTIVE_REASONS.
ASSET_NUMBER VARCHAR2 (80)
The asset number, if any for the vehicle.
LEASE_CONTRACT_NUMBER VARCHAR2 (80)
Lease contract number for the leased company vehicle.
LEASE_CONTRACT_EXPIRY_DATE DATE

The date when the lease expires for the company vehicle.
TAXATION_METHOD VARCHAR2 (80)
Taxation Method used for this vehicle. This value is from the lookup PQP_VEHICLE_TAXATION_METHOD.
FLEET_INFO VARCHAR2 (120)
Additional information for fleet vehicles.
FLEET_TRANSFER_DATE DATE

The date the vehicle was transferred, for the fleet vehicle.
CREATED_BY NUMBER (15) Y Standard Who Column
CREATION_DATE DATE
Y Standard Who Column
LAST_UPDATED_BY NUMBER (15) Y Standard Who Column
LAST_UPDATE_DATE DATE
Y Standard Who Column
LAST_UPDATE_LOGIN NUMBER (15)
Standard Who Column
OBJECT_VERSION_NUMBER NUMBER (9) Y System generated version of row. Increments by one with each update.
VRE_ATTRIBUTE_CATEGORY VARCHAR2 (30)
Descriptive Flexfield Column
VRE_ATTRIBUTE1 VARCHAR2 (150)
Descriptive Flexfield Column
VRE_ATTRIBUTE2 VARCHAR2 (150)
Descriptive Flexfield Column
VRE_ATTRIBUTE3 VARCHAR2 (150)
Descriptive Flexfield Column
VRE_ATTRIBUTE4 VARCHAR2 (150)
Descriptive Flexfield Column
VRE_ATTRIBUTE5 VARCHAR2 (150)
Descriptive Flexfield Column
VRE_ATTRIBUTE6 VARCHAR2 (150)
Descriptive Flexfield Column
VRE_ATTRIBUTE7 VARCHAR2 (150)
Descriptive Flexfield Column
VRE_ATTRIBUTE8 VARCHAR2 (150)
Descriptive Flexfield Column
VRE_ATTRIBUTE9 VARCHAR2 (150)
Descriptive Flexfield Column
VRE_ATTRIBUTE10 VARCHAR2 (150)
Descriptive Flexfield Column
VRE_ATTRIBUTE11 VARCHAR2 (150)
Descriptive Flexfield Column
VRE_ATTRIBUTE12 VARCHAR2 (150)
Descriptive Flexfield Column
VRE_ATTRIBUTE13 VARCHAR2 (150)
Descriptive Flexfield Column
VRE_ATTRIBUTE14 VARCHAR2 (150)
Descriptive Flexfield Column
VRE_ATTRIBUTE15 VARCHAR2 (150)
Descriptive Flexfield Column
VRE_ATTRIBUTE16 VARCHAR2 (150)
Descriptive Flexfield Column
VRE_ATTRIBUTE17 VARCHAR2 (150)
Descriptive Flexfield Column
VRE_ATTRIBUTE18 VARCHAR2 (150)
Descriptive Flexfield Column
VRE_ATTRIBUTE19 VARCHAR2 (150)
Descriptive Flexfield Column
VRE_ATTRIBUTE20 VARCHAR2 (150)
Descriptive Flexfield Column
VRE_INFORMATION_CATEGORY VARCHAR2 (30)
Developer Descriptive Flexfield Column
VRE_INFORMATION1 VARCHAR2 (150)
Developer Descriptive Flexfield Column
VRE_INFORMATION2 VARCHAR2 (150)
Developer Descriptive Flexfield Column
VRE_INFORMATION3 VARCHAR2 (150)
Developer Descriptive Flexfield Column
VRE_INFORMATION4 VARCHAR2 (150)
Developer Descriptive Flexfield Column
VRE_INFORMATION5 VARCHAR2 (150)
Developer Descriptive Flexfield Column
VRE_INFORMATION6 VARCHAR2 (150)
Developer Descriptive Flexfield Column
VRE_INFORMATION7 VARCHAR2 (150)
Developer Descriptive Flexfield Column
VRE_INFORMATION8 VARCHAR2 (150)
Developer Descriptive Flexfield Column
VRE_INFORMATION9 VARCHAR2 (150)
Developer Descriptive Flexfield Column
VRE_INFORMATION10 VARCHAR2 (150)
Developer Descriptive Flexfield Column
VRE_INFORMATION11 VARCHAR2 (150)
Developer Descriptive Flexfield Column
VRE_INFORMATION12 VARCHAR2 (150)
Developer Descriptive Flexfield Column
VRE_INFORMATION13 VARCHAR2 (150)
Developer Descriptive Flexfield Column
VRE_INFORMATION14 VARCHAR2 (150)
Developer Descriptive Flexfield Column
VRE_INFORMATION15 VARCHAR2 (150)
Developer Descriptive Flexfield Column
VRE_INFORMATION16 VARCHAR2 (150)
Developer Descriptive Flexfield Column
VRE_INFORMATION17 VARCHAR2 (150)
Developer Descriptive Flexfield Column
VRE_INFORMATION18 VARCHAR2 (150)
Developer Descriptive Flexfield Column
VRE_INFORMATION19 VARCHAR2 (150)
Developer Descriptive Flexfield Column
VRE_INFORMATION20 VARCHAR2 (150)
Developer Descriptive Flexfield Column
COLOR VARCHAR2 (30)
The color of the vehicle. The value is from the lookkup PQP_VEHICLE_COLOR.
SEATING_CAPACITY NUMBER (15)
The passenger seating capacity for the vehicle.
WEIGHT NUMBER (15)
The weight of the vehicle, the unit of measure is stored in weight_uom column.
WEIGHT_UOM VARCHAR2 (30)
The unit of measure for the weight column. The value is from the lookup PQP_WEIGHT_UOM.
MODEL_YEAR NUMBER (9)
The model year for the vehicle.
INSURANCE_NUMBER VARCHAR2 (80)
The insurance details for the vehicle.
INSURANCE_EXPIRY_DATE DATE

Insurance expiration date for the vehicle.
COMMENTS VARCHAR2 (150)
Free text to store any comments.

[top of page]

HR.PQP_VEHICLE_REPOSITORY_F does not reference any database object

HR.PQP_VEHICLE_REPOSITORY_F is referenced by following:

APPS
SYNONYM - PQP_VEHICLE_REPOSITORY_F
TRIGGER - PQP_VEHICLE_REPOSITORY_F_WHO
PUBLIC
SYNONYM - PQP_VEHICLE_REPOSITORY_F

[top of page]

Table: PQP_VEH_ALLOC_EXTRA_INFO

Description: This entity is used to store any extra information regarding a Vehicle Allocation. This is an intersection table between PQP_VEHICLE_ALLOCATION_F and PQP_VEH_ALLOC_INFO_TYPES.
Primary Key: PQP_VEH_ALLOC_EXTRA_INFO_PK
  1. VEH_ALLOC_EXTRA_INFO_ID
Comments

This entity is used to store any extra information regarding a Vehicle Allocation. This is an intersection table between PQP_VEHICLE_ALLOCATION_F and PQP_VEH_ALLOC_INFO_TYPES.

Indexes
Index Type Tablespace Column
PQP_VEH_ALLOC_EXTRA_INFO_PK UNIQUE APPS_TS_TX_IDX VEH_ALLOC_EXTRA_INFO_ID
PQP_VEH_ALLOC_EXTRA_INFO_N1 NONUNIQUE APPS_TS_TX_IDX VEHICLE_ALLOCATION_ID
INFORMATION_TYPE
Columns
Name Datatype Length Mandatory Comments
VEH_ALLOC_EXTRA_INFO_ID NUMBER (15) Y System generated primary key column using the sequence PQP_VEH_ALLOC_EXTRA_INFO_S.
VEHICLE_ALLOCATION_ID NUMBER (15) Y The vehicle allocation id for which this extra information is created. Its a foreign key to PQP_VEHICLE_ALLOCATION_F.
INFORMATION_TYPE VARCHAR2 (40) Y Foreign key to PQP_VEH_ALLOC_INFO_TYPES to identify the type of information.
VAEI_ATTRIBUTE_CATEGORY VARCHAR2 (150)
Descriptive flexfield column.
VAEI_ATTRIBUTE1 VARCHAR2 (150)
Descriptive flexfield column.
VAEI_ATTRIBUTE2 VARCHAR2 (150)
Descriptive flexfield column.
VAEI_ATTRIBUTE3 VARCHAR2 (150)
Descriptive flexfield column.
VAEI_ATTRIBUTE4 VARCHAR2 (150)
Descriptive flexfield column.
VAEI_ATTRIBUTE5 VARCHAR2 (150)
Descriptive flexfield column.
VAEI_ATTRIBUTE6 VARCHAR2 (150)
Descriptive flexfield column.
VAEI_ATTRIBUTE7 VARCHAR2 (150)
Descriptive flexfield column.
VAEI_ATTRIBUTE8 VARCHAR2 (150)
Descriptive flexfield column.
VAEI_ATTRIBUTE9 VARCHAR2 (150)
Descriptive flexfield column.
VAEI_ATTRIBUTE10 VARCHAR2 (150)
Descriptive flexfield column.
VAEI_ATTRIBUTE11 VARCHAR2 (150)
Descriptive flexfield column.
VAEI_ATTRIBUTE12 VARCHAR2 (150)
Descriptive flexfield column.
VAEI_ATTRIBUTE13 VARCHAR2 (150)
Descriptive flexfield column.
VAEI_ATTRIBUTE14 VARCHAR2 (150)
Descriptive flexfield column.
VAEI_ATTRIBUTE15 VARCHAR2 (150)
Descriptive flexfield column.
VAEI_ATTRIBUTE16 VARCHAR2 (150)
Descriptive flexfield column.
VAEI_ATTRIBUTE17 VARCHAR2 (150)
Descriptive flexfield column.
VAEI_ATTRIBUTE18 VARCHAR2 (150)
Descriptive flexfield column.
VAEI_ATTRIBUTE19 VARCHAR2 (150)
Descriptive flexfield column.
VAEI_ATTRIBUTE20 VARCHAR2 (150)
Descriptive flexfield column.
VAEI_INFORMATION_CATEGORY VARCHAR2 (150)
Developer descriptive flexfield column.
VAEI_INFORMATION1 VARCHAR2 (150)
Developer descriptive flexfield column.
VAEI_INFORMATION2 VARCHAR2 (150)
Developer descriptive flexfield column.
VAEI_INFORMATION3 VARCHAR2 (150)
Developer descriptive flexfield column.
VAEI_INFORMATION4 VARCHAR2 (150)
Developer descriptive flexfield column.
VAEI_INFORMATION5 VARCHAR2 (150)
Developer descriptive flexfield column.
VAEI_INFORMATION6 VARCHAR2 (150)
Developer descriptive flexfield column.
VAEI_INFORMATION7 VARCHAR2 (150)
Developer descriptive flexfield column.
VAEI_INFORMATION8 VARCHAR2 (150)
Developer descriptive flexfield column.
VAEI_INFORMATION9 VARCHAR2 (150)
Developer descriptive flexfield column.
VAEI_INFORMATION10 VARCHAR2 (150)
Developer descriptive flexfield column.
VAEI_INFORMATION11 VARCHAR2 (150)
Developer descriptive flexfield column.
VAEI_INFORMATION12 VARCHAR2 (150)
Developer descriptive flexfield column.
VAEI_INFORMATION13 VARCHAR2 (150)
Developer descriptive flexfield column.
VAEI_INFORMATION14 VARCHAR2 (150)
Developer descriptive flexfield column.
VAEI_INFORMATION15 VARCHAR2 (150)
Developer descriptive flexfield column.
VAEI_INFORMATION16 VARCHAR2 (150)
Developer descriptive flexfield column.
VAEI_INFORMATION17 VARCHAR2 (150)
Developer descriptive flexfield column.
VAEI_INFORMATION18 VARCHAR2 (150)
Developer descriptive flexfield column.
VAEI_INFORMATION19 VARCHAR2 (150)
Developer descriptive flexfield column.
VAEI_INFORMATION20 VARCHAR2 (150)
Developer descriptive flexfield column.
VAEI_INFORMATION21 VARCHAR2 (150)
Developer descriptive flexfield column.
VAEI_INFORMATION22 VARCHAR2 (150)
Developer descriptive flexfield column.
VAEI_INFORMATION23 VARCHAR2 (150)
Developer descriptive flexfield column.
VAEI_INFORMATION24 VARCHAR2 (150)
Developer descriptive flexfield column.
VAEI_INFORMATION25 VARCHAR2 (150)
Developer descriptive flexfield column.
VAEI_INFORMATION26 VARCHAR2 (150)
Developer descriptive flexfield column.
VAEI_INFORMATION27 VARCHAR2 (150)
Developer descriptive flexfield column.
VAEI_INFORMATION28 VARCHAR2 (150)
Developer descriptive flexfield column.
VAEI_INFORMATION29 VARCHAR2 (150)
Developer descriptive flexfield column.
VAEI_INFORMATION30 VARCHAR2 (150)
Developer descriptive flexfield column.
OBJECT_VERSION_NUMBER NUMBER (9) Y System-generated version of row. Increments by one with each update.
LAST_UPDATE_DATE DATE

Standard Who column - date when a user last updated this row.
LAST_UPDATED_BY NUMBER (15)
Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
LAST_UPDATE_LOGIN NUMBER (15)
Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID).
CREATED_BY NUMBER (15)
Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
CREATION_DATE DATE

Standard who column - date when this row was created.
REQUEST_ID NUMBER (15)
Concurrent Program who column - concurrent request id of the program that last updated this row (foreign key to FND_CONCURRENT_REQUESTS.REQUEST_ID).
PROGRAM_APPLICATION_ID NUMBER (15)
Concurrent Program who column - application id of the program that last updated this row (foreign key to FND_APPLICATION.APPLICATION_ID).
PROGRAM_ID NUMBER (15)
Concurrent Program who column - program id of the program that last updated this row (foreign key to FND_CONCURRENT_PROGRAM.CONCURRENT_PROGRAM_ID).
PROGRAM_UPDATE_DATE DATE

Concurrent Program who column - date when a program last updated this row).

[top of page]

HR.PQP_VEH_ALLOC_EXTRA_INFO does not reference any database object

HR.PQP_VEH_ALLOC_EXTRA_INFO is referenced by following:

APPS
SYNONYM - PQP_VEH_ALLOC_EXTRA_INFO
TRIGGER - PQP_VEH_ALLOC_EXTRA_INFO_WHO

[top of page]

Table: PQP_VEH_ALLOC_INFO_TYPES

Description: Entity used to store the information types for vehicle allocation extra information.
Primary Key: PQP_VEH_ALLOC_INFO_TYPES_PK
  1. INFORMATION_TYPE
Comments

Entity used to store the information types for vehicle allocation extra information.

Indexes
Index Type Tablespace Column
PQP_VEH_ALLOC_INFO_TYPES_PK UNIQUE APPS_TS_TX_IDX INFORMATION_TYPE
Columns
Name Datatype Length Mandatory Comments
INFORMATION_TYPE VARCHAR2 (40) Y The name or code of the information type, which is also the primary key.
ACTIVE_INACTIVE_FLAG VARCHAR2 (30) Y Indicates whether the information type is active or inactive.
MULTIPLE_OCCURENCES_FLAG VARCHAR2 (30) Y Indicates whether a Vehicle Allocation may have multiple occurrences of this type.
DESCRIPTION VARCHAR2 (240)
Description of the information type.
LEGISLATION_CODE VARCHAR2 (30)
The legislation to which the information type applies.
OBJECT_VERSION_NUMBER NUMBER (9) Y System-generated version of row. Increments by one with each update.
LAST_UPDATE_DATE DATE

Standard Who column - date when a user last updated this row.
LAST_UPDATED_BY NUMBER (15)
Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
LAST_UPDATE_LOGIN NUMBER (15)
Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID).
CREATED_BY NUMBER (15)
Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
CREATION_DATE DATE

Standard who column - date when this row was created.

[top of page]

HR.PQP_VEH_ALLOC_INFO_TYPES does not reference any database object

HR.PQP_VEH_ALLOC_INFO_TYPES is referenced by following:

APPS
SYNONYM - PQP_VEH_ALLOC_INFO_TYPES
TRIGGER - PQP_VEH_ALLOC_INFO_TYPES_WHO

[top of page]

Table: PQP_VEH_REPOS_EXTRA_INFO

Description: This entity is used to store any extra information regarding a Vehicle. This is an intersection table between PQP_VEHICLE_REPOSITORY_F and PQP_VEH_REPOS_INFO_TYPES.
Primary Key: PQP_VEH_REPOS_EXTRA_INFO_PK
  1. VEH_REPOS_EXTRA_INFO_ID
Comments

This entity is used to store any extra information regarding a Vehicle. This is an intersection table between PQP_VEHICLE_REPOSITORY_F and PQP_VEH_REPOS_INFO_TYPES.

Indexes
Index Type Tablespace Column
PQP_VEH_REPOS_EXTRA_INFO_PK UNIQUE APPS_TS_TX_IDX VEH_REPOS_EXTRA_INFO_ID
PQP_VEH_REPOS_EXTRA_INFO_N1 NONUNIQUE APPS_TS_TX_IDX INFORMATION_TYPE
VEHICLE_REPOSITORY_ID
Columns
Name Datatype Length Mandatory Comments
VEH_REPOS_EXTRA_INFO_ID NUMBER (15) Y System generated primary key column using the sequence PQP_VEH_REPOS_EXTRA_INFO_S.
VEHICLE_REPOSITORY_ID NUMBER (15) Y The vehicle for which the extra information is created. It is a foreign key to PQP_VEHICLE_REPOSITORY_F.
INFORMATION_TYPE VARCHAR2 (40) Y Foreign key to PQP_VEH_REPOS_INFO_TYPES to identify the type of information.
VREI_ATTRIBUTE_CATEGORY VARCHAR2 (150)
Descriptive flexfield column.
VREI_ATTRIBUTE1 VARCHAR2 (150)
Descriptive flexfield column.
VREI_ATTRIBUTE2 VARCHAR2 (150)
Descriptive flexfield column.
VREI_ATTRIBUTE3 VARCHAR2 (150)
Descriptive flexfield column.
VREI_ATTRIBUTE4 VARCHAR2 (150)
Descriptive flexfield column.
VREI_ATTRIBUTE5 VARCHAR2 (150)
Descriptive flexfield column.
VREI_ATTRIBUTE6 VARCHAR2 (150)
Descriptive flexfield column.
VREI_ATTRIBUTE7 VARCHAR2 (150)
Descriptive flexfield column.
VREI_ATTRIBUTE8 VARCHAR2 (150)
Descriptive flexfield column.
VREI_ATTRIBUTE9 VARCHAR2 (150)
Descriptive flexfield column.
VREI_ATTRIBUTE10 VARCHAR2 (150)
Descriptive flexfield column.
VREI_ATTRIBUTE11 VARCHAR2 (150)
Descriptive flexfield column.
VREI_ATTRIBUTE12 VARCHAR2 (150)
Descriptive flexfield column.
VREI_ATTRIBUTE13 VARCHAR2 (150)
Descriptive flexfield column.
VREI_ATTRIBUTE14 VARCHAR2 (150)
Descriptive flexfield column.
VREI_ATTRIBUTE15 VARCHAR2 (150)
Descriptive flexfield column.
VREI_ATTRIBUTE16 VARCHAR2 (150)
Descriptive flexfield column.
VREI_ATTRIBUTE17 VARCHAR2 (150)
Descriptive flexfield column.
VREI_ATTRIBUTE18 VARCHAR2 (150)
Descriptive flexfield column.
VREI_ATTRIBUTE19 VARCHAR2 (150)
Descriptive flexfield column.
VREI_ATTRIBUTE20 VARCHAR2 (150)
Descriptive flexfield column.
VREI_INFORMATION_CATEGORY VARCHAR2 (150)
Developer descriptive flexfield column.
VREI_INFORMATION1 VARCHAR2 (150)
Developer descriptive flexfield column.
VREI_INFORMATION2 VARCHAR2 (150)
Developer descriptive flexfield column.
VREI_INFORMATION3 VARCHAR2 (150)
Developer descriptive flexfield column.
VREI_INFORMATION4 VARCHAR2 (150)
Developer descriptive flexfield column.
VREI_INFORMATION5 VARCHAR2 (150)
Developer descriptive flexfield column.
VREI_INFORMATION6 VARCHAR2 (150)
Developer descriptive flexfield column.
VREI_INFORMATION7 VARCHAR2 (150)
Developer descriptive flexfield column.
VREI_INFORMATION8 VARCHAR2 (150)
Developer descriptive flexfield column.
VREI_INFORMATION9 VARCHAR2 (150)
Developer descriptive flexfield column.
VREI_INFORMATION10 VARCHAR2 (150)
Developer descriptive flexfield column.
VREI_INFORMATION11 VARCHAR2 (150)
Developer descriptive flexfield column.
VREI_INFORMATION12 VARCHAR2 (150)
Developer descriptive flexfield column.
VREI_INFORMATION13 VARCHAR2 (150)
Developer descriptive flexfield column.
VREI_INFORMATION14 VARCHAR2 (150)
Developer descriptive flexfield column.
VREI_INFORMATION15 VARCHAR2 (150)
Developer descriptive flexfield column.
VREI_INFORMATION16 VARCHAR2 (150)
Developer descriptive flexfield column.
VREI_INFORMATION17 VARCHAR2 (150)
Developer descriptive flexfield column.
VREI_INFORMATION18 VARCHAR2 (150)
Developer descriptive flexfield column.
VREI_INFORMATION19 VARCHAR2 (150)
Developer descriptive flexfield column.
VREI_INFORMATION20 VARCHAR2 (150)
Developer descriptive flexfield column.
VREI_INFORMATION21 VARCHAR2 (150)
Developer descriptive flexfield column.
VREI_INFORMATION22 VARCHAR2 (150)
Developer descriptive flexfield column.
VREI_INFORMATION23 VARCHAR2 (150)
Developer descriptive flexfield column.
VREI_INFORMATION24 VARCHAR2 (150)
Developer descriptive flexfield column.
VREI_INFORMATION25 VARCHAR2 (150)
Developer descriptive flexfield column.
VREI_INFORMATION26 VARCHAR2 (150)
Developer descriptive flexfield column.
VREI_INFORMATION27 VARCHAR2 (150)
Developer descriptive flexfield column.
VREI_INFORMATION28 VARCHAR2 (150)
Developer descriptive flexfield column.
VREI_INFORMATION29 VARCHAR2 (150)
Developer descriptive flexfield column.
VREI_INFORMATION30 VARCHAR2 (150)
Developer descriptive flexfield column.
OBJECT_VERSION_NUMBER NUMBER (9) Y System-generated version of row. Increments by one with each update.
LAST_UPDATE_DATE DATE

Standard Who column - date when a user last updated this row.
LAST_UPDATED_BY NUMBER (15)
Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
LAST_UPDATE_LOGIN NUMBER (15)
Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID).
CREATED_BY NUMBER (15)
Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
CREATION_DATE DATE

Standard who column - date when this row was created.
REQUEST_ID NUMBER (15)
Concurrent Program who column - concurrent request id of the program that last updated this row (foreign key to FND_CONCURRENT_REQUESTS.REQUEST_ID).
PROGRAM_APPLICATION_ID NUMBER (15)
Concurrent Program who column - application id of the program that last updated this row (foreign key to FND_APPLICATION.APPLICATION_ID).
PROGRAM_ID NUMBER (15)
Concurrent Program who column - program id of the program that last updated this row (foreign key to FND_CONCURRENT_PROGRAM.CONCURRENT_PROGRAM_ID).
PROGRAM_UPDATE_DATE DATE

Concurrent Program who column - date when a program last updated this row).

[top of page]

HR.PQP_VEH_REPOS_EXTRA_INFO does not reference any database object

HR.PQP_VEH_REPOS_EXTRA_INFO is referenced by following:

APPS
SYNONYM - PQP_VEH_REPOS_EXTRA_INFO
TRIGGER - PQP_VEH_REPOS_EXTRA_INFO_WHO
PUBLIC
SYNONYM - PQP_VEH_REPOS_EXTRA_INFO

[top of page]

Table: PQP_VEH_REPOS_INFO_TYPES

Description: Entity used to store the information types for Vehicle Repository Extra information.
Primary Key: PQP_VEH_REPOS_INFO_TYPES_PK
  1. INFORMATION_TYPE
Comments

Entity used to store the information types for Vehicle Repository Extra information.

Indexes
Index Type Tablespace Column
PQP_VEH_REPOS_INFO_TYPES_PK UNIQUE APPS_TS_TX_IDX INFORMATION_TYPE
Columns
Name Datatype Length Mandatory Comments
INFORMATION_TYPE VARCHAR2 (40) Y The name or code of the information type, which is also the primary key.
ACTIVE_INACTIVE_FLAG VARCHAR2 (30) Y Indicates whether the information type is active or inactive.
MULTIPLE_OCCURENCES_FLAG VARCHAR2 (30) Y Indicates whether a Vehicle Repository may have multiple occurrences of this type.
DESCRIPTION VARCHAR2 (240)
Description of the information type.
LEGISLATION_CODE VARCHAR2 (30)
The legislation to which the information type applies.
OBJECT_VERSION_NUMBER NUMBER (9) Y System-generated version of row. Increments by one with each update.
LAST_UPDATE_DATE DATE

Standard Who column - date when a user last updated this row.
LAST_UPDATED_BY NUMBER (15)
Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
LAST_UPDATE_LOGIN NUMBER (15)
Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID).
CREATED_BY NUMBER (15)
Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
CREATION_DATE DATE

Standard who column - date when this row was created.

[top of page]

HR.PQP_VEH_REPOS_INFO_TYPES does not reference any database object

HR.PQP_VEH_REPOS_INFO_TYPES is referenced by following:

APPS
SYNONYM - PQP_VEH_REPOS_INFO_TYPES
TRIGGER - PQP_VEH_REPOS_INFO_TYPES_WHO
PUBLIC
SYNONYM - PQP_VEH_REPOS_INFO_TYPES

[top of page]

View: PQP_ASSIGNMENT_ATTRIBUTES_D

Comments
View Type

A public view which may be useful for custom reporting or other data requirements.

View for DateTrack history of the table PQP_ASSIGNMENT_ATTRIBUTES_F

Columns
Name Datatype Length Mandatory Comments
ASSIGNMENT_ATTRIBUTE_ID NUMBER (15) Y System generated primary key
EFFECTIVE_START_DATE DATE
Y Effective Start Date
EFFECTIVE_END_DATE DATE
Y Effective end date
CONTRACT_TYPE VARCHAR2 (80)
Name of contract type
WORK_PATTERN VARCHAR2 (80)
Name of work pattern
START_DAY VARCHAR2 (30)
Start day in work pattern
TP_JOB_STATUS VARCHAR2 (80)
Indicates whether a person is a Teacher
TP_SAFEGUARDED_GRADE VARCHAR2 (150)
Indictates the safeguarded grade of a teacher
TP_SAFEGUARDED_RATE_TYPE VARCHAR2 (30)
Indictates whether the safeguarded rate of the teacher is a grade rate or scale rate
TP_SAFEGUARDED_RATE_NAME VARCHAR2 (80)
Indictates the safeguarded grade or scale rate name of a teacher
TP_SAFEGUARDED_SPINAL_POINT VARCHAR2 (30)
Indictates the safeguarded spinal point of a teacher
TP_ELECTED_PENSION VARCHAR2 (30)
Indictates whether the person has Elected a Pension Scheme
TP_FAST_TRACK VARCHAR2 (30)
Indictates whether the teacher is on a Fast Track career path
TP_HEADTEACHER_GRP_CODE NUMBER (15)
Indicates the protected location group code of a head teacher
LAST_UPDATE_DATE DATE

Standard Who column
LAST_UPDATED_BY VARCHAR2 (100)
Standard Who column
LGPS_PROCESS_FLAG VARCHAR2 (30)
Indicates the status of the assignment for LGPS
LGPS_EXCLUSION_TYPE VARCHAR2 (80)
Indicates the reason for Exclusion from LGPS
LGPS_PENSIONABLE_PAY VARCHAR2 (60)
This will have the Contractual pensionable pay for the assignment
LGPS_TRANS_ARRANG_FLAG VARCHAR2 (30)
Indicates if the assignment is in transitional arrangement or not.
LGPS_MEMBERSHIP_NUMBER VARCHAR2 (60)
LGPS Pension Membership number can be entered here.

[top of page]

APPS.PQP_ASSIGNMENT_ATTRIBUTES_D references the following:

APPS
PACKAGE - FND_GLOBAL
VIEW - FND_USER_VIEW
PACKAGE - HR_API
VIEW - HR_LOOKUPS
SYNONYM - PAY_RATES
SYNONYM - PAY_USER_TABLES
SYNONYM - PER_SPINAL_POINTS
SYNONYM - PQP_ASSIGNMENT_ATTRIBUTES_F
SYNONYM - PQP_VEHICLE_DETAILS
APPS.PQP_ASSIGNMENT_ATTRIBUTES_D is referenced by following:

PUBLIC
SYNONYM - PQP_ASSIGNMENT_ATTRIBUTES_D

[top of page]

View: PQP_ASSIGNMENT_ATTRIBUTES_V

Comments
View Type

A public view which may be useful for custom reporting or other data requirements.

View of table PQP_ASSIGNMENT_ATTRIBUTES_F.

Columns
Name Datatype Length Mandatory Comments
ROW_ID ROWID (10)
Row id
ASSIGNMENT_ATTRIBUTE_ID NUMBER (15) Y System generated primary key
EFFECTIVE_START_DATE DATE
Y Effective Start Date
EFFECTIVE_END_DATE DATE
Y Effective End Date
BUSINESS_GROUP_ID NUMBER (15) Y Foreign key to HR_ORGANIZATION_UNITS
ASSIGNMENT_ID NUMBER (15) Y Foreign key to PER_ASSIGNMENTS_F
CONTRACT_TYPE VARCHAR2 (80)
Name of contract type
WORK_PATTERN VARCHAR2 (80)
Name of work pattern
START_DAY VARCHAR2 (30)
Start day of work pattern
LAST_UPDATE_DATE DATE

Standard Who Column
LAST_UPDATED_BY NUMBER (15)
Standard Who column
LAST_UPDATE_LOGIN NUMBER (15)
Standard Who column
CREATED_BY NUMBER (15)
Standard Who column
CREATION_DATE DATE

Standard Who column
OBJECT_VERSION_NUMBER NUMBER (15) Y System generated version of row. Increments by one with every update
PRIMARY_COMPANY_CAR NUMBER (15)
Foreign key to PQP_VEHICLE_DETAILS
PRIMARY_REGISTRATION_NUMBER VARCHAR2 (30)
Registration number of primary car
PRIMARY_MAKE VARCHAR2 (30)
Make of primary car
PRIMARY_MODEL VARCHAR2 (30)
Model of primary car
PRIMARY_CAR_FUEL_BENEFIT VARCHAR2 (30)
Indicates whether fuel benfit is paid with primary car
PRIMARY_CAPITAL_CONTRIBUTION NUMBER (15)
Amount of capital contribution to primary car
PRIMARY_PRIVATE_CONTRIBUTION NUMBER (15)
Amount of private contribution to primary car
PRIMARY_CLASS_1A VARCHAR2 (30)
Indicates whether class 1a is payable on primary car
SECONDARY_COMPANY_CAR NUMBER (15)
Foreign key to PQP_VEHICLE_DETAILS
SECONDARY_REGISTRATION_NUMBER VARCHAR2 (30)
Secondary car registration number
SECONDARY_MAKE VARCHAR2 (30)
Make of secondary car
SECONDARY_MODEL VARCHAR2 (30)
Model of secondary car
SECONDARY_CAR_FUEL_BENEFIT VARCHAR2 (30)
Indicates whether fuel benefit is paid with secondary car
SECONDARY_CAPITAL_CONTRIBUTION NUMBER (15)
Amount of capital contribution to secondary car
SECONDARY_PRIVATE_CONTRIBUTION NUMBER (15)
Amount of private contribution to secondary car.
SECONDARY_CLASS_1A VARCHAR2 (30)
Indicates whether class 1a is payable on secondary car
COMPANY_CAR_CALC_METHOD VARCHAR2 (30)
Lookup code for calculation method used for company car mileage claims
COMPANY_CAR_CALC_METHOD_NAME VARCHAR2 (80)
Lookup meaning for calculation method used for company car mileage claims
COMPANY_CAR_RATES_TABLE_ID NUMBER (9)
Foreign key to PAY_USER_TABLES
COMPANY_CAR_RATES_TABLE_NAME VARCHAR2 (80)
Name of user table used in primary car mileage claims
COMPANY_CAR_SECONDARY_TABLE_ID NUMBER (9)
Foreign key to PAY_USER_TABLES
COMPANY_CAR_SECONDARY_TABLE VARCHAR2 (80)
Name of user table used in secondary car mileage claims
PRIVATE_CAR NUMBER (15)
Foreign key to PQP_VEHICLE_DETAILS
PRIVATE_REGISTRATION_NUMBER VARCHAR2 (30)
Registration number of private car
PRIVATE_MAKE VARCHAR2 (30)
Make of private car
PRIVATE_MODEL VARCHAR2 (30)
Model of private car
PRIVATE_ENGINE_CC NUMBER

Engine capacity of private car
PRIVATE_FUEL_TYPE VARCHAR2 (30)
Lookup code for private car fuel type
PRIVATE_FUEL_TYPE_NAME VARCHAR2 (80)
Lookup meaning for private car fuel type
PRIVATE_CAR_CALC_METHOD VARCHAR2 (30)
Lookup code for private car calculation method
PRIVATE_CAR_CALC_METHOD_NAME VARCHAR2 (80)
Lookup meaning for private car calculation method
PRIVATE_CAR_RATES_TABLE_ID NUMBER (9)
Foreign key to PAY_USER_TABLES
PRIVATE_CAR_RATES_TABLE_NAME VARCHAR2 (80)
Name of user table used in casual private car mileage claims
PRIVATE_CAR_ESSENTIAL_TABLE_ID NUMBER (9)
Foreign key to PAY_USER_TABLES
PRIVATE_CAR_ESSENTIAL_TABLE VARCHAR2 (80)
Name of user table used in essential private car mileage claims.
TP_IS_TEACHER VARCHAR2 (30)
Indicates whether a person is a Teacher
TP_SAFEGUARDED_GRADE VARCHAR2 (150)
Indictates the safeguarded grade of a teacher
TP_SAFEGUARDED_GRADE_ID NUMBER (15)
Teachers Safeguarded Grade Id
TP_SAFEGUARDED_RATE_TYPE VARCHAR2 (30)
Indictates the safeguarded rate type of a teacher
TP_SAFEGUARDED_RATE_ID NUMBER (15)
Indictates the safeguarded grade or scale rate id of a teacher
TP_SAFEGUARDED_RATE_NAME VARCHAR2 (80)
Indictates the safeguarded grade or scale rate name of a teacher
TP_SAFEGUARDED_SPINAL_POINT_ID NUMBER (15)
Indictates the safeguarded spinal point id of a teacher
TP_SAFEGUARDED_SPINAL_POINT VARCHAR2 (30)
Indictates the safeguarded spinal point of a teacher
TP_ELECTED_PENSION VARCHAR2 (30)
Indictates whether the person has Elected a Pension Scheme
TP_FAST_TRACK VARCHAR2 (30)
Indictates whether the teacher is on a Fast Track career path
TP_HEADTEACHER_GRP_CODE NUMBER (15)
Indicates the protected location group code of a head teacher
AAT_ATTRIBUTE_CATEGORY VARCHAR2 (30)
Descriptive flexfield column
AAT_ATTRIBUTE1 VARCHAR2 (150)
Descriptive flexfield column
AAT_ATTRIBUTE2 VARCHAR2 (150)
Descriptive flexfield column
AAT_ATTRIBUTE3 VARCHAR2 (150)
Descriptive flexfield column
AAT_ATTRIBUTE4 VARCHAR2 (150)
Descriptive flexfield column
AAT_ATTRIBUTE5 VARCHAR2 (150)
Descriptive flexfield column
AAT_ATTRIBUTE6 VARCHAR2 (150)
Descriptive flexfield column
AAT_ATTRIBUTE7 VARCHAR2 (150)
Descriptive flexfield column
AAT_ATTRIBUTE8 VARCHAR2 (150)
Descriptive flexfield column
AAT_ATTRIBUTE9 VARCHAR2 (150)
Descriptive flexfield column
AAT_ATTRIBUTE10 VARCHAR2 (150)
Descriptive flexfield column
AAT_ATTRIBUTE11 VARCHAR2 (150)
Descriptive flexfield column
AAT_ATTRIBUTE12 VARCHAR2 (150)
Descriptive flexfield column
AAT_ATTRIBUTE13 VARCHAR2 (150)
Descriptive flexfield column
AAT_ATTRIBUTE14 VARCHAR2 (150)
Descriptive flexfield column
AAT_ATTRIBUTE15 VARCHAR2 (150)
Descriptive flexfield column
AAT_ATTRIBUTE16 VARCHAR2 (150)
Descriptive flexfield column
AAT_ATTRIBUTE17 VARCHAR2 (150)
Descriptive flexfield column
AAT_ATTRIBUTE18 VARCHAR2 (150)
Descriptive flexfield column
AAT_ATTRIBUTE19 VARCHAR2 (150)
Descriptive flexfield column
AAT_ATTRIBUTE20 VARCHAR2 (150)
Descriptive flexfield column
AAT_INFORMATION_CATEGORY VARCHAR2 (30)
Developer descriptive flexfield column
AAT_INFORMATION1 VARCHAR2 (150)
Developer descriptive flexfield column
AAT_INFORMATION2 VARCHAR2 (150)
Developer descriptive flexfield column
AAT_INFORMATION3 VARCHAR2 (150)
Developer descriptive flexfield column
AAT_INFORMATION4 VARCHAR2 (150)
Developer descriptive flexfield column
AAT_INFORMATION5 VARCHAR2 (150)
Developer descriptive flexfield column
AAT_INFORMATION6 VARCHAR2 (150)
Developer descriptive flexfield column
AAT_INFORMATION7 VARCHAR2 (150)
Developer descriptive flexfield column
AAT_INFORMATION8 VARCHAR2 (150)
Developer descriptive flexfield column
AAT_INFORMATION9 VARCHAR2 (150)
Developer descriptive flexfield column
AAT_INFORMATION10 VARCHAR2 (150)
Developer descriptive flexfield column
AAT_INFORMATION11 VARCHAR2 (150)
Developer descriptive flexfield column
AAT_INFORMATION12 VARCHAR2 (150)
Developer descriptive flexfield column
AAT_INFORMATION13 VARCHAR2 (150)
Developer descriptive flexfield column
AAT_INFORMATION14 VARCHAR2 (150)
Developer descriptive flexfield column
AAT_INFORMATION15 VARCHAR2 (150)
Developer descriptive flexfield column
AAT_INFORMATION16 VARCHAR2 (150)
Developer descriptive flexfield column
AAT_INFORMATION17 VARCHAR2 (150)
Developer descriptive flexfield column
AAT_INFORMATION18 VARCHAR2 (150)
Developer descriptive flexfield column
AAT_INFORMATION19 VARCHAR2 (150)
Developer descriptive flexfield column
AAT_INFORMATION20 VARCHAR2 (150)
Developer descriptive flexfield column
LGPS_PROCESS_FLAG VARCHAR2 (30)
Indicates the status of the Assignment for LGPS
LGPS_EXCLUSION_TYPE VARCHAR2 (80)
Indicates the reason for exclusion from lgps
LGPS_PENSIONABLE_PAY VARCHAR2 (60)
This will have the Contractual pensionable pay for the assignment
LGPS_TRANS_ARRANG_FLAG VARCHAR2 (30)
Indicator to say whether the assignment is in transitional arrangement or not.
LGPS_MEMBERSHIP_NUMBER VARCHAR2 (60)
LGPS Pension Membership number can be entered here.

[top of page]

APPS.PQP_ASSIGNMENT_ATTRIBUTES_V references the following:

APPS
PACKAGE - FND_GLOBAL
PACKAGE - HR_API
VIEW - HR_LOOKUPS
SYNONYM - PAY_RATES
SYNONYM - PAY_USER_TABLES
SYNONYM - PER_SPINAL_POINTS
SYNONYM - PQP_ASSIGNMENT_ATTRIBUTES_F
SYNONYM - PQP_VEHICLE_DETAILS
APPS.PQP_ASSIGNMENT_ATTRIBUTES_V is referenced by following:

PUBLIC
SYNONYM - PQP_ASSIGNMENT_ATTRIBUTES_V

[top of page]

View: PQP_GB_PENSION_SCHEMES_V

Comments
View Type

A supplementary view used to simplify forms coding.

Warning: Oracle does not recommend you query or alter datausing this view. It may change dramatically in subsequent minor or major releases.

Columns
Name Datatype Length Mandatory Comments
PENSION_SCHEME_NAME VARCHAR2 (150)
Name of the Pension Scheme
PENSION_CATEGORY VARCHAR2 (150)
Pension Category
PENSION_YEAR_START_DT DATE

Start Date of the Pension Year
PENSION_PROVIDER_ID NUMBER (15) Y Foreign key to HR_ALL_ORGANIZATION_UNITS
PENSION_PROVIDER_NAME VARCHAR2 (240) Y Name of the Pension Provider
PENSION_TYPE_ID NUMBER (10) Y Foreign key to pqp_pension_types_f
PENSION_TYPE_NAME VARCHAR2 (240) Y Name of the Pension Type
EMPLOYEE_DEDUCTION_METHOD VARCHAR2 (150)
Method used for Employee Deductions
SCON VARCHAR2 (150)
S.C.O.N.
ECON VARCHAR2 (150)
E.C.O.N.
SCHEME_REFERENCE_NUMBER VARCHAR2 (150)
Scheme Reference Number
EMPLOYER_REFERENCE_NUMBER VARCHAR2 (150)
Employer Reference Number
ASSOCIATED_OCP_ELE_TYPE_ID NUMBER

Associated Occupational Pension Scheme Id
ASSOCIATED_OCP_SCHEME VARCHAR2 (150)
Associated Occupational Pension Scheme Name
ADDITIONAL_CONTRIBUTION VARCHAR2 (150)
Additional Contirbution
ADDED_YEARS VARCHAR2 (150)
Added Years
FAMILY_WIDOWER VARCHAR2 (150)
Family and Widower
EMPLOYER_COMPONENT VARCHAR2 (1)
Employer Component
EMPLOYER_DEDUCTION_METHOD VARCHAR2 (150)
Employer Deduction Method
SCHEME_PREFIX VARCHAR2 (150)
Scheme Prefix
PENSION_SCHEME_TYPE VARCHAR2 (150)
Pension Scheme Type
PENSIONABLE_SALARY_BALANCE_ID NUMBER (9) Y Foreign key to pay_balance_types
PENSIONABLE_SALARY_BALANCE VARCHAR2 (80)
Name of the Pensionable Salary Balance
ELEMENT_TYPE_ID NUMBER (9) Y Primary key of base element
EFFECTIVE_START_DATE DATE
Y Effective Start Date
EFFECTIVE_END_DATE DATE
Y Effective End Date
ELEMENT_NAME VARCHAR2 (80) Y Name of the Base Element
BUSINESS_GROUP_ID NUMBER (15)
Foreign key to HR_ALL_ORGANIZATION_UNITS
LEGISLATION_CODE VARCHAR2 (30)
Legislation code
REPORTING_NAME VARCHAR2 (80)
Reporting name of base element
DESCRIPTION VARCHAR2 (240)
Description of base element
CLASSIFICATION_ID NUMBER (9) Y Foreign key to HR_ORG_CLASSIFICATIONS
CLASSIFICATION_NAME VARCHAR2 (80)
Classification of base element
THIRD_PARTY_PAYMENT VARCHAR2 (1)
Flag to denote if this is a Third Party Payment
ITERATIVE_PROCESSING VARCHAR2 (30)
Iterative Processing Flag
POST_TERMINATION_RULE VARCHAR2 (30) Y Post Termination Rule
STANDARD_LINK VARCHAR2 (30) Y Standard Link Flag
ARREARAGE VARCHAR2 (150)
Arrearage Flag
PARTIAL_DEDUCTION VARCHAR2 (150)
Partial Deductions Flag
FWC_ADDED_YEARS VARCHAR2 (150)
Added Years Family Widower Benefit
CREATED_BY NUMBER (15)
Created By
CREATION_DATE DATE

Creation Date
LAST_UPDATE_DATE DATE

Last Update Date
LAST_UPDATED_BY NUMBER (15)
Last Updated By
LAST_UPDATE_LOGIN NUMBER (15)
Last Update Login

[top of page]

APPS.PQP_GB_PENSION_SCHEMES_V references the following:

APPS
PACKAGE - FND_DATE
PACKAGE - FND_NUMBER
SYNONYM - HR_ALL_ORGANIZATION_UNITS
SYNONYM - PAY_BALANCE_TYPES
SYNONYM - PAY_ELEMENT_CLASSIFICATIONS
SYNONYM - PAY_ELEMENT_TYPES_F
SYNONYM - PAY_ELEMENT_TYPE_EXTRA_INFO
SYNONYM - PQP_PENSION_TYPES_F
APPS.PQP_GB_PENSION_SCHEMES_V is referenced by following:

APPS
PACKAGE BODY - PQP_GB_PENSION_FUNCTIONS
PACKAGE - PQP_GB_PENSION_FUNCTIONS
PACKAGE BODY - PQP_GB_PENSION_SCHEME_TEMPLATE
PUBLIC
SYNONYM - PQP_GB_PENSION_SCHEMES_V

[top of page]

View: PQP_GB_PENSION_TEMPLATE_V

Comments
View Type

A supplementary view used to simplify forms coding.

Warning: Oracle does not recommend you query or alter datausing this view. It may change dramatically in subsequent minor or major releases.

Columns
Name Datatype Length Mandatory Comments
ELEMENT_TYPE_ID NUMBER (9) Y Primary key of base element
BUSINESS_GROUP_ID NUMBER (15)
Foreign key to HR_ALL_ORGANIZATION_UNITS
LEGISLATION_CODE VARCHAR2 (30)
Legislation code
CLASSIFICATION_ID NUMBER (9) Y Foreign key to HR_ORG_CLASSIFICATIONS
CLASSIFICATION_NAME VARCHAR2 (80)
Classification of base element
ELEMENT_NAME VARCHAR2 (80) Y Name of base element
REPORTING_NAME VARCHAR2 (80)
Reporting name of base element
DESCRIPTION VARCHAR2 (240)
Description of base element
SCHEME_TYPE VARCHAR2 (150)
Type of pension scheme
CONTRIBUTION_METHOD VARCHAR2 (150)
Method of contribution to pension scheme
ADDITIONAL_CONTRIBUTIONS VARCHAR2 (150)
Allow additional contributions to scheme?
EXCEPTIONAL_CONTRIBUTIONS VARCHAR2 (150)
Allow exceptional contributions to scheme?
EMPLOYER_CONTRIBUTIONS VARCHAR2 (1)
Allow employer contributions to scheme?
EMPLOYER_CONTRIBUTION_RATE VARCHAR2 (150)
Rate of employer contribution
EMPLOYER_CONTRIBUTION_TYPE VARCHAR2 (150)
Percentage of flat rate
EMPLOYER_CONTRIBUTION_TYPE_NM VARCHAR2 (80)
Percentage or flat rate
BUY_BACK_ADDED_YEARS VARCHAR2 (150)
Buy back added years AVC allowed?
FAMILY_WIDOWER_BENEFIT VARCHAR2 (150)
Family benefit AVC allowed
AVC_PERCENTAGE VARCHAR2 (1)
Percentage AVC allowed?
AVC_PERCENTAGE_PROVIDER VARCHAR2 (150)
Percentage AVC provider
AVC_FIXED_RATE VARCHAR2 (1)
Fixed rate AVC allowed?
AVC_FIXED_RATE_PROVIDER VARCHAR2 (150)
Fixed rate AVC provider
LIFE_ASSURANCE VARCHAR2 (1)
Life assurance AVC allowed?
LIFE_ASSURANCE_PROVIDER VARCHAR2 (150)
Life assurance AVC provider
EMPLOYEE_DEFAULT_CONTRIBUTION VARCHAR2 (150)
Default contribution payable by employee
LAST_UPDATE_DATE DATE

Standard WHO column
LAST_UPDATED_BY NUMBER (15)
Standard WHO column
LAST_UPDATE_LOGIN NUMBER (15)
Standard WHO column
CREATED_BY NUMBER (15)
Standard WHO column
CREATION_DATE DATE

Standard WHO column

[top of page]

APPS.PQP_GB_PENSION_TEMPLATE_V references the following:

APPS
PACKAGE - FND_GLOBAL
SYNONYM - FND_SESSIONS
PACKAGE - HR_API
VIEW - HR_LOOKUPS
SYNONYM - PAY_ELEMENT_CLASSIFICATIONS
SYNONYM - PAY_ELEMENT_TYPES_F
SYNONYM - PAY_ELEMENT_TYPE_EXTRA_INFO
APPS.PQP_GB_PENSION_TEMPLATE_V is referenced by following:

PUBLIC
SYNONYM - PQP_GB_PENSION_TEMPLATE_V

[top of page]

View: PQP_GB_STAKEHOLDER_TEMPLATE_V

Comments
View Type

A supplementary view used to simplify forms coding.

Warning: Oracle does not recommend you query or alter datausing this view. It may change dramatically in subsequent minor or major releases.

Columns
Name Datatype Length Mandatory Comments
ELEMENT_TYPE_ID NUMBER (9) Y Primary key of base element
BUSINESS_GROUP_ID NUMBER (15)
Foreign key to HR_ALL_ORGANIZATION_UNITS
LEGISLATION_CODE VARCHAR2 (30)
Legislation code
CLASSIFICATION_ID NUMBER (9) Y Foreign key to HR_ORG_CLASSIFICATIONS
CLASSIFICATION_NAME VARCHAR2 (80)
Classification of base element
ELEMENT_NAME VARCHAR2 (80)
Name of base element
REPORTING_NAME VARCHAR2 (80)
Reporting name of base element
DESCRIPTION VARCHAR2 (240)
Description of base element
SCHEME_TYPE VARCHAR2 (150)
Type of stakeholder pension scheme
CONTRIBUTION_METHOD VARCHAR2 (150)
Method of contribution to scheme
EMPLOYER_CONTRIBUTIONS VARCHAR2 (1)
Employer contributions payable?
EMPLOYER_CONTRIBUTION_RATE VARCHAR2 (150)
Rate of employer contributions
EMPLOYER_CONTRIBUTION_TYPE VARCHAR2 (150)
Type of employer contributions
EMPLOYER_CONTRIBUTION_TYPE_NM VARCHAR2 (80)
Type of employer contributions
EMPLOYEE_DEFAULT_CONTRIBUTION VARCHAR2 (150)
Default level of employee contribution payable
LAST_UPDATE_DATE DATE

Standard WHO column
LAST_UPDATED_BY NUMBER (15)
Standard WHO column
LAST_UPDATE_LOGIN NUMBER (15)
Standard WHO column
CREATED_BY NUMBER (15)
Standard WHO column
CREATION_DATE DATE

Standard WHO column

[top of page]

APPS.PQP_GB_STAKEHOLDER_TEMPLATE_V references the following:

APPS
PACKAGE - FND_GLOBAL
SYNONYM - FND_SESSIONS
PACKAGE - HR_API
VIEW - HR_LOOKUPS
SYNONYM - PAY_ELEMENT_CLASSIFICATIONS
SYNONYM - PAY_ELEMENT_TYPES_F
SYNONYM - PAY_ELEMENT_TYPE_EXTRA_INFO
APPS.PQP_GB_STAKEHOLDER_TEMPLATE_V is referenced by following:

PUBLIC
SYNONYM - PQP_GB_STAKEHOLDER_TEMPLATE_V

[top of page]

View: PQP_OMP_TEMPLATE_V

Comments
View Type

A supplementary view used to simplify forms coding.

Warning: Oracle does not recommend you query or alter datausing this view. It may change dramatically in subsequent minor or major releases.

Columns
Name Datatype Length Mandatory Comments
ELEMENT_TYPE_ID NUMBER (9) Y Primary key of absence information element
BUSINESS_GROUP_ID NUMBER (15)
Foreign key to HR_ALL_ORGANIZATION_UNITS
LEGISLATION_CODE VARCHAR2 (30)
Legislation code
CLASSIFICATION_ID NUMBER (9) Y Foreign key to HR_ORG_CLASSIFICATIONS
CLASSIFICATION_NAME VARCHAR2 (80)
Classification of absence information element
PROCESSING_TYPE VARCHAR2 (30) Y Processing type of the absence information element
BASE_NAME VARCHAR2 (50)
Base element name
ELEMENT_NAME VARCHAR2 (80) Y Element name
REPORTING_NAME VARCHAR2 (80)
Reporting name of the element
DESCRIPTION VARCHAR2 (240)
Description of absence information element
PROCESSING_PRIORITY NUMBER (9) Y Processing priority of the element
EFFECTIVE_START_DATE DATE
Y Effective start date of the element
EFFECTIVE_END_DATE DATE
Y Effective end date of the element
PLAN_ID VARCHAR2 (150)
Benefits plan id
PLAN_NAME VARCHAR2 (240) Y Benefits plan name
PLAN_DESCRIPTION VARCHAR2 (150)
Benefits plan description
LOS_CALC VARCHAR2 (150)
OMP qualifying date
LOS_DURATION VARCHAR2 (150)
OMP qualifying date duration
LOS_UOM VARCHAR2 (150)
OMP qualifying date Unit of measure
AVGEARN_DURATION VARCHAR2 (150)
Average earnings calculation duration
AVGEARN_UOM VARCHAR2 (150)
Average earnings calculation unit of measure
AVGEARN_BALNAME VARCHAR2 (150)
Average earnings calculation balance name
ABS_DAYS VARCHAR2 (150)
Absence Entitlement Type
ABS_ENT_MATLEAVES_UDT_ID VARCHAR2 (150)
Absence entitlement parameters user defined table id
ABS_ENT_MATERNITY_LEAVES VARCHAR2 (80)
Absence entitlement parameters user defined table name
ABS_ENT_HOLIDAYS_UDT_ID VARCHAR2 (150)
Absence entitlement calendar user defined table id
ABS_ENT_HOLIDAYS VARCHAR2 (80)
Absence entitlement calendar user defined table name
ABS_DAILYRATE_CALC VARCHAR2 (150)
Absence daily rate divisor
ABS_DAILYRATE_CALC_PERIOD VARCHAR2 (150)
Absence daily rate divisor type
ABS_DAILYRATE_CALC_DURATION VARCHAR2 (150)
Absence daily rate divisor duration
ABS_PAY_INFO_SRC_COMP VARCHAR2 (150)
Pay Component Rate Type
ABS_PAY_INFO_SRC_COMP_NAME VARCHAR2 (80)
Pay Component Rate Type Name
PRIMARY_ABS_INFO_ELE_FLAG VARCHAR2 (150)
Primary absence information element flag
ABS_DEFAULT_WORKPATTERN VARCHAR2 (150)
Default work pattern name
ELEMENT_TYPE VARCHAR2 (150)
Element type
ABS_TYPES_LIST_NAME VARCHAR2 (150)
Absence types list name
LAST_UPDATE_DATE DATE

Standard WHO column
LAST_UPDATED_BY NUMBER (15)
Standard WHO column
LAST_UPDATE_LOGIN NUMBER (15)
Standard WHO column
CREATED_BY NUMBER (15)
Standard WHO column
CREATION_DATE DATE

Standard WHO column
ABSENCE_CATEGORY VARCHAR2 (150)
Stores Absence Category i.e. Maternity

[top of page]

APPS.PQP_OMP_TEMPLATE_V references the following:

APPS
SYNONYM - BEN_PL_F
SYNONYM - BEN_PL_TYP_F
PACKAGE - FND_GLOBAL
PACKAGE - FND_NUMBER
SYNONYM - FND_SESSIONS
PACKAGE - HR_API
VIEW - HR_LOOKUPS
SYNONYM - PAY_ELEMENT_CLASSIFICATIONS
SYNONYM - PAY_ELEMENT_TEMPLATES
SYNONYM - PAY_ELEMENT_TYPES_F
SYNONYM - PAY_ELEMENT_TYPE_EXTRA_INFO
SYNONYM - PAY_TEMPLATE_CORE_OBJECTS
SYNONYM - PAY_USER_TABLES
APPS.PQP_OMP_TEMPLATE_V is referenced by following:

PUBLIC
SYNONYM - PQP_OMP_TEMPLATE_V

[top of page]

View: PQP_OSP_TEMPLATE_V

Comments
View Type

A supplementary view used to simplify forms coding.

Warning: Oracle does not recommend you query or alter datausing this view. It may change dramatically in subsequent minor or major releases.

Columns
Name Datatype Length Mandatory Comments
ELEMENT_TYPE_ID NUMBER (9) Y
BUSINESS_GROUP_ID NUMBER (15)
LEGISLATION_CODE VARCHAR2 (30)
CLASSIFICATION_ID NUMBER (9) Y
CLASSIFICATION_NAME VARCHAR2 (80)
PROCESSING_TYPE VARCHAR2 (30) Y
BASE_NAME VARCHAR2 (50)
ELEMENT_NAME VARCHAR2 (80) Y
REPORTING_NAME VARCHAR2 (80)
DESCRIPTION VARCHAR2 (240)
PROCESSING_PRIORITY NUMBER (9) Y
EFFECTIVE_START_DATE DATE
Y
EFFECTIVE_END_DATE DATE
Y
PLAN_ID VARCHAR2 (150)
PLAN_NAME VARCHAR2 (240) Y
PLAN_DESCRIPTION VARCHAR2 (150)
SCH_CAL_TYPE VARCHAR2 (150)
SCH_CAL_DURATION VARCHAR2 (150)
SCH_CAL_UOM VARCHAR2 (150)
SCH_CAL_START_DATE DATE

SCH_CAL_END_DATE DATE

ABS_DAYS VARCHAR2 (150)
ABS_ENT_SICKLEAVES_UDT_ID VARCHAR2 (150)
ABS_ENT_SICK_LEAVES VARCHAR2 (80)
ABS_ENT_HOLIDAYS_UDT_ID VARCHAR2 (150)
ABS_ENT_HOLIDAYS VARCHAR2 (80)
ABS_DAILYRATE_CALC VARCHAR2 (150)
ABS_DAILYRATE_CALC_PERIOD VARCHAR2 (150)
ABS_DAILYRATE_CALC_DURATION VARCHAR2 (150)
ELEMENT_TYPE VARCHAR2 (150)
ABS_PAY_INFO_SRC_COMP VARCHAR2 (150)
ABS_PAY_INFO_SRC_COMP_NAME VARCHAR2 (80)
PRIMARY_ABS_INFO_ELE_FLAG VARCHAR2 (150)
ABS_DEFAULT_WORKPATTERN VARCHAR2 (150)
ABS_OVERLAP_RULE VARCHAR2 (150)
ABS_TYPES_LIST_NAME VARCHAR2 (150)
LAST_UPDATE_DATE DATE

LAST_UPDATED_BY NUMBER (15)
LAST_UPDATE_LOGIN NUMBER (15)
CREATED_BY NUMBER (15)
CREATION_DATE DATE

SCH_CAL_DURATION_SEC VARCHAR2 (150)
SCH_CAL_UOM_SEC VARCHAR2 (150)
ABSENCE_CATEGORY VARCHAR2 (150)
ENTITLEMENT_PRORATION VARCHAR2 (150)
ABSENCE_SCHEDULE_WORKPATTERN VARCHAR2 (150)
PLAN_TYPES_EXTEND_PERIOD VARCHAR2 (150)
FT_ROUND_CONFIG VARCHAR2 (150)
PT_ROUND_CONFIG VARCHAR2 (150)

[top of page]

APPS.PQP_OSP_TEMPLATE_V references the following:

APPS
SYNONYM - BEN_PL_F
SYNONYM - BEN_PL_TYP_F
PACKAGE - FND_DATE
PACKAGE - FND_GLOBAL
PACKAGE - FND_NUMBER
SYNONYM - FND_SESSIONS
PACKAGE - HR_API
VIEW - HR_LOOKUPS
SYNONYM - PAY_ELEMENT_CLASSIFICATIONS
SYNONYM - PAY_ELEMENT_TEMPLATES
SYNONYM - PAY_ELEMENT_TYPES_F
SYNONYM - PAY_ELEMENT_TYPE_EXTRA_INFO
SYNONYM - PAY_TEMPLATE_CORE_OBJECTS
SYNONYM - PAY_USER_TABLES
APPS.PQP_OSP_TEMPLATE_V is referenced by following:

PUBLIC
SYNONYM - PQP_OSP_TEMPLATE_V

[top of page]

View: PQP_PROFESSIONAL_BODY_TEMP_V

Comments
View Type

A supplementary view used to simplify forms coding.

Warning: Oracle does not recommend you query or alter datausing this view. It may change dramatically in subsequent minor or major releases.

Columns
Name Datatype Length Mandatory Comments
ELEMENT_TYPE_ID NUMBER (9) Y
BUSINESS_GROUP_ID NUMBER (15)
LEGISLATION_CODE VARCHAR2 (30)
CLASSIFICATION_ID NUMBER (9) Y
CLASSIFICATION_NAME VARCHAR2 (80)
PROCESSING_TYPE VARCHAR2 (30) Y
ELEMENT_NAME VARCHAR2 (80) Y
REPORTING_NAME VARCHAR2 (80)
DESCRIPTION VARCHAR2 (240)
ORGANIZATION_ID VARCHAR2 (150)
PROFESSIONAL_BODY_NAME VARCHAR2 (240) Y
PROFESSIONAL_BODY_LEVEL_BAL VARCHAR2 (150)
OVERRIDE_AMOUNT VARCHAR2 (150)
THIRD_PARTY_PAYMENT VARCHAR2 (150)
LAST_UPDATE_DATE DATE

LAST_UPDATED_BY NUMBER (15)
LAST_UPDATE_LOGIN NUMBER (15)
CREATED_BY NUMBER (15)
CREATION_DATE DATE

[top of page]

APPS.PQP_PROFESSIONAL_BODY_TEMP_V references the following:

APPS
SYNONYM - FND_SESSIONS
SYNONYM - HR_ALL_ORGANIZATION_UNITS
SYNONYM - HR_ORGANIZATION_INFORMATION
SYNONYM - PAY_ELEMENT_CLASSIFICATIONS
SYNONYM - PAY_ELEMENT_TYPES_F
SYNONYM - PAY_ELEMENT_TYPE_EXTRA_INFO
APPS.PQP_PROFESSIONAL_BODY_TEMP_V is referenced by following:

PUBLIC
SYNONYM - PQP_PROFESSIONAL_BODY_TEMP_V

[top of page]

View: PQP_UNION_TEMPLATE_V

Comments
View Type

A supplementary view used to simplify forms coding.

Warning: Oracle does not recommend you query or alter datausing this view. It may change dramatically in subsequent minor or major releases.

Columns
Name Datatype Length Mandatory Comments
ELEMENT_TYPE_ID NUMBER (9) Y Primary key of base element
BUSINESS_GROUP_ID NUMBER (15)
Foreign key to HR_ALL_ORGANIZATION_UNITS
LEGISLATION_CODE VARCHAR2 (30)
Legislation code
CLASSIFICATION_ID NUMBER (9) Y Foreign key to HR_ORG_CLASSIFICATIONS
CLASSIFICATION_NAME VARCHAR2 (80)
Classification name of base element
PROCESSING_TYPE VARCHAR2 (30) Y Processing type of base element
ELEMENT_NAME VARCHAR2 (80) Y Name of base element
REPORTING_NAME VARCHAR2 (80)
Reporting name of base element
DESCRIPTION VARCHAR2 (240)
Description of base element
ORGANIZATION_ID VARCHAR2 (150)
Foreign key to HR_ALL_ORGANIZATION_UNITS
UNION_NAME VARCHAR2 (240) Y Name of union descibed by this element
UNION_LEVEL_BALANCE VARCHAR2 (150)
Name of balance for all templates associated with same union
RATE_TYPE VARCHAR2 (150)
Rate type lookup code
RATE_TYPE_NAME VARCHAR2 (80)
Rate type meaning
FUND_LIST VARCHAR2 (150)
List of available political funds
OVERRIDE_AMOUNT VARCHAR2 (1)
Override amount if non-standard contribution
TAX_RELIEF VARCHAR2 (1)
Tax relief available on contributions?
SUPPLEMENTARY_LEVY VARCHAR2 (1)
Optional supplementary levy payable?
LAST_UPDATE_DATE DATE

Standard WHO column
LAST_UPDATED_BY NUMBER (15)
Standard WHO column
LAST_UPDATE_LOGIN NUMBER (15)
Standard WHO column
CREATED_BY NUMBER (15)
Standard WHO column
CREATION_DATE DATE

Standard WHO column

[top of page]

APPS.PQP_UNION_TEMPLATE_V references the following:

APPS
PACKAGE - FND_GLOBAL
SYNONYM - FND_SESSIONS
SYNONYM - HR_ALL_ORGANIZATION_UNITS
PACKAGE - HR_API
VIEW - HR_LOOKUPS
SYNONYM - HR_ORGANIZATION_INFORMATION
SYNONYM - PAY_ELEMENT_CLASSIFICATIONS
SYNONYM - PAY_ELEMENT_TYPES_F
SYNONYM - PAY_ELEMENT_TYPE_EXTRA_INFO
SYNONYM - PAY_INPUT_VALUES_F
APPS.PQP_UNION_TEMPLATE_V is referenced by following:

PUBLIC
SYNONYM - PQP_UNION_TEMPLATE_V

[top of page]

View: PQP_VEHICLE_TEMPLATE_V

Comments
View Type

A supplementary view used to simplify forms coding.

Warning: Oracle does not recommend you query or alter datausing this view. It may change dramatically in subsequent minor or major releases.

Columns
Name Datatype Length Mandatory Comments
ELEMENT_TYPE_ID NUMBER (9) Y Primary key of base element
BUSINESS_GROUP_ID NUMBER (15)
Foreign key to HR_ALL_ORGANIZATION_UNITS
LEGISLATION_CODE VARCHAR2 (30)
Legislation code
CLASSIFICATION_ID NUMBER (9) Y Foreign key to HR_ORG_CLASSIFICATIONS
ELEMENT_NAME VARCHAR2 (80) Y Name of base element
DESCRIPTION VARCHAR2 (240)
Description of base element
REPORTING_NAME VARCHAR2 (80)
Reporting name of base element
VEHICLE_TYPE VARCHAR2 (150)
Vehicle type described
EFFECTIVE_START_DATE DATE
Y Effective Start Date
EFFECTIVE_END_DATE DATE
Y Effective End Date
LAST_UPDATE_DATE DATE

Standard WHO column
LAST_UPDATED_BY NUMBER (15)
Standard WHO column
LAST_UPDATE_LOGIN NUMBER (15)
Standard WHO column
CREATED_BY NUMBER (15)
Standard WHO column
CREATION_DATE DATE

Standard WHO column

[top of page]

APPS.PQP_VEHICLE_TEMPLATE_V references the following:

APPS
SYNONYM - FND_SESSIONS
SYNONYM - PAY_ELEMENT_TYPES_F
SYNONYM - PAY_ELEMENT_TYPE_EXTRA_INFO
APPS.PQP_VEHICLE_TEMPLATE_V is referenced by following:

PUBLIC
SYNONYM - PQP_VEHICLE_TEMPLATE_V

[top of page]
Copyright (c) 2001 - 2005, Oracle - Use Restricted by Contract