[Home] [Help]
[Dependency Information]
[Home] [Help]
[Dependency Information]
| Object Name: | PQP_ASSIGNMENT_ATTRIBUTES_F |
|---|---|
| Object Type: | TABLE |
| Owner: | HR |
| FND Design Data: |  PQP.PQP_ASSIGNMENT_ATTRIBUTES_F
|
| Subobject Name: | |
| Status: | VALID |
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.
| Tablespace: |  APPS_TS_TX_DATA |
|---|---|
| PCT Free: | 10 |
| PCT Used: |
| Index | Type | Uniqueness | Tablespace | Column |
|---|---|---|---|---|
| PQP_ASSIGNMENT_ATTRIBUTES_F_PK | NORMAL | UNIQUE |
APPS_TS_TX_IDX
|
 ASSIGNMENT_ATTRIBUTE_ID
EFFECTIVE_START_DATE
EFFECTIVE_END_DATE
|
| PQP_ASSIGNMENT_ATTRIBUTES_F_N1 | NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
ASSIGNMENT_ID
EFFECTIVE_START_DATE
EFFECTIVE_END_DATE
|
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| ASSIGNMENT_ATTRIBUTE_ID | NUMBER | (15) | Yes | System generated primary key column |
| EFFECTIVE_START_DATE | DATE | Yes | Effective start date | |
| EFFECTIVE_END_DATE | DATE | Yes | Effective End Date | |
| BUSINESS_GROUP_ID | NUMBER | (15) | Yes | Foreign Key to HR_ORGANIZATION_UNITS |
| ASSIGNMENT_ID | NUMBER | (15) | Yes | 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) | Yes | 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 |
Cut, paste (and edit) the following text to query this object:
SELECT ASSIGNMENT_ATTRIBUTE_ID
, EFFECTIVE_START_DATE
, EFFECTIVE_END_DATE
, BUSINESS_GROUP_ID
, ASSIGNMENT_ID
, CONTRACT_TYPE
, WORK_PATTERN
, START_DAY
, PRIMARY_COMPANY_CAR
, PRIMARY_CAR_FUEL_BENEFIT
, PRIMARY_CLASS_1A
, PRIMARY_CAPITAL_CONTRIBUTION
, PRIMARY_PRIVATE_CONTRIBUTION
, SECONDARY_COMPANY_CAR
, SECONDARY_CAR_FUEL_BENEFIT
, SECONDARY_CLASS_1A
, SECONDARY_CAPITAL_CONTRIBUTION
, SECONDARY_PRIVATE_CONTRIBUTION
, COMPANY_CAR_CALC_METHOD
, COMPANY_CAR_RATES_TABLE_ID
, COMPANY_CAR_SECONDARY_TABLE_ID
, PRIVATE_CAR
, PRIVATE_CAR_CALC_METHOD
, PRIVATE_CAR_RATES_TABLE_ID
, PRIVATE_CAR_ESSENTIAL_TABLE_ID
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_LOGIN
, CREATED_BY
, CREATION_DATE
, OBJECT_VERSION_NUMBER
, TP_IS_TEACHER
, TP_SAFEGUARDED_GRADE
, TP_ELECTED_PENSION
, AAT_ATTRIBUTE_CATEGORY
, AAT_ATTRIBUTE1
, AAT_ATTRIBUTE2
, AAT_ATTRIBUTE3
, AAT_ATTRIBUTE4
, AAT_ATTRIBUTE5
, AAT_ATTRIBUTE6
, AAT_ATTRIBUTE7
, AAT_ATTRIBUTE8
, AAT_ATTRIBUTE9
, AAT_ATTRIBUTE10
, AAT_ATTRIBUTE11
, AAT_ATTRIBUTE12
, AAT_ATTRIBUTE13
, AAT_ATTRIBUTE14
, AAT_ATTRIBUTE15
, AAT_ATTRIBUTE16
, AAT_ATTRIBUTE17
, AAT_ATTRIBUTE18
, AAT_ATTRIBUTE19
, AAT_ATTRIBUTE20
, AAT_INFORMATION_CATEGORY
, AAT_INFORMATION1
, AAT_INFORMATION2
, AAT_INFORMATION3
, AAT_INFORMATION4
, AAT_INFORMATION5
, AAT_INFORMATION6
, AAT_INFORMATION7
, AAT_INFORMATION8
, AAT_INFORMATION9
, AAT_INFORMATION10
, AAT_INFORMATION11
, AAT_INFORMATION12
, AAT_INFORMATION13
, AAT_INFORMATION14
, AAT_INFORMATION15
, AAT_INFORMATION16
, AAT_INFORMATION17
, AAT_INFORMATION18
, AAT_INFORMATION19
, AAT_INFORMATION20
, TP_SAFEGUARDED_RATE_TYPE
, TP_SAFEGUARDED_RATE_ID
, TP_SAFEGUARDED_SPINAL_POINT_ID
, TP_FAST_TRACK
, TP_SAFEGUARDED_GRADE_ID
, TP_HEADTEACHER_GRP_CODE
, LGPS_PROCESS_FLAG
, LGPS_EXCLUSION_TYPE
, LGPS_PENSIONABLE_PAY
, LGPS_TRANS_ARRANG_FLAG
, LGPS_MEMBERSHIP_NUMBER
FROM HR.PQP_ASSIGNMENT_ATTRIBUTES_F;
HR.PQP_ASSIGNMENT_ATTRIBUTES_F does not reference any database object
HR.PQP_ASSIGNMENT_ATTRIBUTES_F is referenced by following:
HR
PQP_ASSIGNMENT_ATTRIBUTES_F#
|
|
|
|