eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

VIEW: HR.PQP_ASSIGNMENT_ATTRIBUTES_F#

Source

View Text - Preformatted


select ASSIGNMENT_ATTRIBUTE_ID ASSIGNMENT_ATTRIBUTE_ID, EFFECTIVE_START_DATE EFFECTIVE_START_DATE, EFFECTIVE_END_DATE EFFECTIVE_END_DATE, BUSINESS_GROUP_ID BUSINESS_GROUP_ID, ASSIGNMENT_ID ASSIGNMENT_ID, CONTRACT_TYPE CONTRACT_TYPE, WORK_PATTERN WORK_PATTERN, START_DAY START_DAY, PRIMARY_COMPANY_CAR PRIMARY_COMPANY_CAR, PRIMARY_CAR_FUEL_BENEFIT PRIMARY_CAR_FUEL_BENEFIT, PRIMARY_CLASS_1A PRIMARY_CLASS_1A, PRIMARY_CAPITAL_CONTRIBUTION PRIMARY_CAPITAL_CONTRIBUTION, PRIMARY_PRIVATE_CONTRIBUTION PRIMARY_PRIVATE_CONTRIBUTION, SECONDARY_COMPANY_CAR SECONDARY_COMPANY_CAR, SECONDARY_CAR_FUEL_BENEFIT SECONDARY_CAR_FUEL_BENEFIT, SECONDARY_CLASS_1A SECONDARY_CLASS_1A, SECONDARY_CAPITAL_CONTRIBUTION SECONDARY_CAPITAL_CONTRIBUTION, SECONDARY_PRIVATE_CONTRIBUTION SECONDARY_PRIVATE_CONTRIBUTION, COMPANY_CAR_CALC_METHOD COMPANY_CAR_CALC_METHOD, COMPANY_CAR_RATES_TABLE_ID COMPANY_CAR_RATES_TABLE_ID, COMPANY_CAR_SECONDARY_TABLE_ID COMPANY_CAR_SECONDARY_TABLE_ID, PRIVATE_CAR PRIVATE_CAR, PRIVATE_CAR_CALC_METHOD PRIVATE_CAR_CALC_METHOD, PRIVATE_CAR_RATES_TABLE_ID PRIVATE_CAR_RATES_TABLE_ID, PRIVATE_CAR_ESSENTIAL_TABLE_ID PRIVATE_CAR_ESSENTIAL_TABLE_ID, LAST_UPDATE_DATE LAST_UPDATE_DATE, LAST_UPDATED_BY LAST_UPDATED_BY, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, CREATED_BY CREATED_BY, CREATION_DATE CREATION_DATE, OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER, TP_IS_TEACHER TP_IS_TEACHER, TP_SAFEGUARDED_GRADE TP_SAFEGUARDED_GRADE, TP_ELECTED_PENSION TP_ELECTED_PENSION, AAT_ATTRIBUTE_CATEGORY AAT_ATTRIBUTE_CATEGORY, AAT_ATTRIBUTE1 AAT_ATTRIBUTE1, AAT_ATTRIBUTE2 AAT_ATTRIBUTE2, AAT_ATTRIBUTE3 AAT_ATTRIBUTE3, AAT_ATTRIBUTE4 AAT_ATTRIBUTE4, AAT_ATTRIBUTE5 AAT_ATTRIBUTE5, AAT_ATTRIBUTE6 AAT_ATTRIBUTE6, AAT_ATTRIBUTE7 AAT_ATTRIBUTE7, AAT_ATTRIBUTE8 AAT_ATTRIBUTE8, AAT_ATTRIBUTE9 AAT_ATTRIBUTE9, AAT_ATTRIBUTE10 AAT_ATTRIBUTE10, AAT_ATTRIBUTE11 AAT_ATTRIBUTE11, AAT_ATTRIBUTE12 AAT_ATTRIBUTE12, AAT_ATTRIBUTE13 AAT_ATTRIBUTE13, AAT_ATTRIBUTE14 AAT_ATTRIBUTE14, AAT_ATTRIBUTE15 AAT_ATTRIBUTE15, AAT_ATTRIBUTE16 AAT_ATTRIBUTE16, AAT_ATTRIBUTE17 AAT_ATTRIBUTE17, AAT_ATTRIBUTE18 AAT_ATTRIBUTE18, AAT_ATTRIBUTE19 AAT_ATTRIBUTE19, AAT_ATTRIBUTE20 AAT_ATTRIBUTE20, AAT_INFORMATION_CATEGORY AAT_INFORMATION_CATEGORY, AAT_INFORMATION1 AAT_INFORMATION1, AAT_INFORMATION2 AAT_INFORMATION2, AAT_INFORMATION3 AAT_INFORMATION3, AAT_INFORMATION4 AAT_INFORMATION4, AAT_INFORMATION5 AAT_INFORMATION5, AAT_INFORMATION6 AAT_INFORMATION6, AAT_INFORMATION7 AAT_INFORMATION7, AAT_INFORMATION8 AAT_INFORMATION8, AAT_INFORMATION9 AAT_INFORMATION9, AAT_INFORMATION10 AAT_INFORMATION10, AAT_INFORMATION11 AAT_INFORMATION11, AAT_INFORMATION12 AAT_INFORMATION12, AAT_INFORMATION13 AAT_INFORMATION13, AAT_INFORMATION14 AAT_INFORMATION14, AAT_INFORMATION15 AAT_INFORMATION15, AAT_INFORMATION16 AAT_INFORMATION16, AAT_INFORMATION17 AAT_INFORMATION17, AAT_INFORMATION18 AAT_INFORMATION18, AAT_INFORMATION19 AAT_INFORMATION19, AAT_INFORMATION20 AAT_INFORMATION20, TP_SAFEGUARDED_RATE_TYPE TP_SAFEGUARDED_RATE_TYPE, TP_SAFEGUARDED_RATE_ID TP_SAFEGUARDED_RATE_ID, TP_SAFEGUARDED_SPINAL_POINT_ID TP_SAFEGUARDED_SPINAL_POINT_ID, TP_FAST_TRACK TP_FAST_TRACK, TP_SAFEGUARDED_GRADE_ID TP_SAFEGUARDED_GRADE_ID, TP_HEADTEACHER_GRP_CODE TP_HEADTEACHER_GRP_CODE, LGPS_PROCESS_FLAG LGPS_PROCESS_FLAG, LGPS_EXCLUSION_TYPE LGPS_EXCLUSION_TYPE, LGPS_PENSIONABLE_PAY LGPS_PENSIONABLE_PAY, LGPS_TRANS_ARRANG_FLAG LGPS_TRANS_ARRANG_FLAG, LGPS_MEMBERSHIP_NUMBER LGPS_MEMBERSHIP_NUMBER from "HR"."PQP_ASSIGNMENT_ATTRIBUTES_F"

View Text - HTML Formatted

SELECT ASSIGNMENT_ATTRIBUTE_ID ASSIGNMENT_ATTRIBUTE_ID
, EFFECTIVE_START_DATE EFFECTIVE_START_DATE
, EFFECTIVE_END_DATE EFFECTIVE_END_DATE
, BUSINESS_GROUP_ID BUSINESS_GROUP_ID
, ASSIGNMENT_ID ASSIGNMENT_ID
, CONTRACT_TYPE CONTRACT_TYPE
, WORK_PATTERN WORK_PATTERN
, START_DAY START_DAY
, PRIMARY_COMPANY_CAR PRIMARY_COMPANY_CAR
, PRIMARY_CAR_FUEL_BENEFIT PRIMARY_CAR_FUEL_BENEFIT
, PRIMARY_CLASS_1A PRIMARY_CLASS_1A
, PRIMARY_CAPITAL_CONTRIBUTION PRIMARY_CAPITAL_CONTRIBUTION
, PRIMARY_PRIVATE_CONTRIBUTION PRIMARY_PRIVATE_CONTRIBUTION
, SECONDARY_COMPANY_CAR SECONDARY_COMPANY_CAR
, SECONDARY_CAR_FUEL_BENEFIT SECONDARY_CAR_FUEL_BENEFIT
, SECONDARY_CLASS_1A SECONDARY_CLASS_1A
, SECONDARY_CAPITAL_CONTRIBUTION SECONDARY_CAPITAL_CONTRIBUTION
, SECONDARY_PRIVATE_CONTRIBUTION SECONDARY_PRIVATE_CONTRIBUTION
, COMPANY_CAR_CALC_METHOD COMPANY_CAR_CALC_METHOD
, COMPANY_CAR_RATES_TABLE_ID COMPANY_CAR_RATES_TABLE_ID
, COMPANY_CAR_SECONDARY_TABLE_ID COMPANY_CAR_SECONDARY_TABLE_ID
, PRIVATE_CAR PRIVATE_CAR
, PRIVATE_CAR_CALC_METHOD PRIVATE_CAR_CALC_METHOD
, PRIVATE_CAR_RATES_TABLE_ID PRIVATE_CAR_RATES_TABLE_ID
, PRIVATE_CAR_ESSENTIAL_TABLE_ID PRIVATE_CAR_ESSENTIAL_TABLE_ID
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, LAST_UPDATED_BY LAST_UPDATED_BY
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, CREATED_BY CREATED_BY
, CREATION_DATE CREATION_DATE
, OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER
, TP_IS_TEACHER TP_IS_TEACHER
, TP_SAFEGUARDED_GRADE TP_SAFEGUARDED_GRADE
, TP_ELECTED_PENSION TP_ELECTED_PENSION
, AAT_ATTRIBUTE_CATEGORY AAT_ATTRIBUTE_CATEGORY
, AAT_ATTRIBUTE1 AAT_ATTRIBUTE1
, AAT_ATTRIBUTE2 AAT_ATTRIBUTE2
, AAT_ATTRIBUTE3 AAT_ATTRIBUTE3
, AAT_ATTRIBUTE4 AAT_ATTRIBUTE4
, AAT_ATTRIBUTE5 AAT_ATTRIBUTE5
, AAT_ATTRIBUTE6 AAT_ATTRIBUTE6
, AAT_ATTRIBUTE7 AAT_ATTRIBUTE7
, AAT_ATTRIBUTE8 AAT_ATTRIBUTE8
, AAT_ATTRIBUTE9 AAT_ATTRIBUTE9
, AAT_ATTRIBUTE10 AAT_ATTRIBUTE10
, AAT_ATTRIBUTE11 AAT_ATTRIBUTE11
, AAT_ATTRIBUTE12 AAT_ATTRIBUTE12
, AAT_ATTRIBUTE13 AAT_ATTRIBUTE13
, AAT_ATTRIBUTE14 AAT_ATTRIBUTE14
, AAT_ATTRIBUTE15 AAT_ATTRIBUTE15
, AAT_ATTRIBUTE16 AAT_ATTRIBUTE16
, AAT_ATTRIBUTE17 AAT_ATTRIBUTE17
, AAT_ATTRIBUTE18 AAT_ATTRIBUTE18
, AAT_ATTRIBUTE19 AAT_ATTRIBUTE19
, AAT_ATTRIBUTE20 AAT_ATTRIBUTE20
, AAT_INFORMATION_CATEGORY AAT_INFORMATION_CATEGORY
, AAT_INFORMATION1 AAT_INFORMATION1
, AAT_INFORMATION2 AAT_INFORMATION2
, AAT_INFORMATION3 AAT_INFORMATION3
, AAT_INFORMATION4 AAT_INFORMATION4
, AAT_INFORMATION5 AAT_INFORMATION5
, AAT_INFORMATION6 AAT_INFORMATION6
, AAT_INFORMATION7 AAT_INFORMATION7
, AAT_INFORMATION8 AAT_INFORMATION8
, AAT_INFORMATION9 AAT_INFORMATION9
, AAT_INFORMATION10 AAT_INFORMATION10
, AAT_INFORMATION11 AAT_INFORMATION11
, AAT_INFORMATION12 AAT_INFORMATION12
, AAT_INFORMATION13 AAT_INFORMATION13
, AAT_INFORMATION14 AAT_INFORMATION14
, AAT_INFORMATION15 AAT_INFORMATION15
, AAT_INFORMATION16 AAT_INFORMATION16
, AAT_INFORMATION17 AAT_INFORMATION17
, AAT_INFORMATION18 AAT_INFORMATION18
, AAT_INFORMATION19 AAT_INFORMATION19
, AAT_INFORMATION20 AAT_INFORMATION20
, TP_SAFEGUARDED_RATE_TYPE TP_SAFEGUARDED_RATE_TYPE
, TP_SAFEGUARDED_RATE_ID TP_SAFEGUARDED_RATE_ID
, TP_SAFEGUARDED_SPINAL_POINT_ID TP_SAFEGUARDED_SPINAL_POINT_ID
, TP_FAST_TRACK TP_FAST_TRACK
, TP_SAFEGUARDED_GRADE_ID TP_SAFEGUARDED_GRADE_ID
, TP_HEADTEACHER_GRP_CODE TP_HEADTEACHER_GRP_CODE
, LGPS_PROCESS_FLAG LGPS_PROCESS_FLAG
, LGPS_EXCLUSION_TYPE LGPS_EXCLUSION_TYPE
, LGPS_PENSIONABLE_PAY LGPS_PENSIONABLE_PAY
, LGPS_TRANS_ARRANG_FLAG LGPS_TRANS_ARRANG_FLAG
, LGPS_MEMBERSHIP_NUMBER LGPS_MEMBERSHIP_NUMBER
FROM "HR"."PQP_ASSIGNMENT_ATTRIBUTES_F"