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.GHR_PA_REQUESTS#

Source

View Text - Preformatted


select PA_REQUEST_ID PA_REQUEST_ID, PA_NOTIFICATION_ID PA_NOTIFICATION_ID, NOA_FAMILY_CODE NOA_FAMILY_CODE, ROUTING_GROUP_ID ROUTING_GROUP_ID, ACADEMIC_DISCIPLINE ACADEMIC_DISCIPLINE, ADDITIONAL_INFO_PERSON_ID ADDITIONAL_INFO_PERSON_ID, ADDITIONAL_INFO_TEL_NUMBER ADDITIONAL_INFO_TEL_NUMBER, AGENCY_CODE AGENCY_CODE, ALTERED_PA_REQUEST_ID ALTERED_PA_REQUEST_ID, ANNUITANT_INDICATOR ANNUITANT_INDICATOR, ANNUITANT_INDICATOR_DESC ANNUITANT_INDICATOR_DESC, APPROPRIATION_CODE1 APPROPRIATION_CODE1, APPROPRIATION_CODE2 APPROPRIATION_CODE2, APPROVAL_DATE APPROVAL_DATE, APPROVING_OFFICIAL_FULL_NAME APPROVING_OFFICIAL_FULL_NAME, APPROVING_OFFICIAL_WORK_TITLE APPROVING_OFFICIAL_WORK_TITLE, AUTHORIZED_BY_PERSON_ID AUTHORIZED_BY_PERSON_ID, AUTHORIZED_BY_TITLE AUTHORIZED_BY_TITLE, AWARD_AMOUNT AWARD_AMOUNT, AWARD_PERCENTAGE AWARD_PERCENTAGE, AWARD_UOM AWARD_UOM, BARGAINING_UNIT_STATUS BARGAINING_UNIT_STATUS, CITIZENSHIP CITIZENSHIP, CONCURRENCE_DATE CONCURRENCE_DATE, CUSTOM_PAY_CALC_FLAG CUSTOM_PAY_CALC_FLAG, DUTY_STATION_CODE DUTY_STATION_CODE, DUTY_STATION_DESC DUTY_STATION_DESC, DUTY_STATION_ID DUTY_STATION_ID, DUTY_STATION_LOCATION_ID DUTY_STATION_LOCATION_ID, EDUCATION_LEVEL EDUCATION_LEVEL, EFFECTIVE_DATE EFFECTIVE_DATE, EMPLOYEE_ASSIGNMENT_ID EMPLOYEE_ASSIGNMENT_ID, EMPLOYEE_DATE_OF_BIRTH EMPLOYEE_DATE_OF_BIRTH, EMPLOYEE_DEPT_OR_AGENCY EMPLOYEE_DEPT_OR_AGENCY, EMPLOYEE_FIRST_NAME EMPLOYEE_FIRST_NAME, EMPLOYEE_LAST_NAME EMPLOYEE_LAST_NAME, EMPLOYEE_MIDDLE_NAMES EMPLOYEE_MIDDLE_NAMES, EMPLOYEE_NATIONAL_IDENTIFIER EMPLOYEE_NATIONAL_IDENTIFIER, FEGLI FEGLI, FEGLI_DESC FEGLI_DESC, FIRST_ACTION_LA_CODE1 FIRST_ACTION_LA_CODE1, FIRST_ACTION_LA_CODE2 FIRST_ACTION_LA_CODE2, FIRST_ACTION_LA_DESC1 FIRST_ACTION_LA_DESC1, FIRST_ACTION_LA_DESC2 FIRST_ACTION_LA_DESC2, FIRST_NOA_CANCEL_OR_CORRECT FIRST_NOA_CANCEL_OR_CORRECT, FIRST_NOA_CANC_PA_REQUEST_ID FIRST_NOA_CANC_PA_REQUEST_ID, FIRST_NOA_CODE FIRST_NOA_CODE, FIRST_NOA_DESC FIRST_NOA_DESC, FIRST_NOA_ID FIRST_NOA_ID, FIRST_NOA_PA_REQUEST_ID FIRST_NOA_PA_REQUEST_ID, FLSA_CATEGORY FLSA_CATEGORY, FORWARDING_ADDRESS_LINE1 FORWARDING_ADDRESS_LINE1, FORWARDING_ADDRESS_LINE2 FORWARDING_ADDRESS_LINE2, FORWARDING_ADDRESS_LINE3 FORWARDING_ADDRESS_LINE3, FORWARDING_COUNTRY FORWARDING_COUNTRY, FORWARDING_COUNTRY_SHORT_NAME FORWARDING_COUNTRY_SHORT_NAME, FORWARDING_POSTAL_CODE FORWARDING_POSTAL_CODE, FORWARDING_REGION_2 FORWARDING_REGION_2, FORWARDING_TOWN_OR_CITY FORWARDING_TOWN_OR_CITY, FROM_ADJ_BASIC_PAY FROM_ADJ_BASIC_PAY, FROM_AGENCY_CODE FROM_AGENCY_CODE, FROM_AGENCY_DESC FROM_AGENCY_DESC, FROM_BASIC_PAY FROM_BASIC_PAY, FROM_GRADE_OR_LEVEL FROM_GRADE_OR_LEVEL, FROM_LOCALITY_ADJ FROM_LOCALITY_ADJ, FROM_OCC_CODE FROM_OCC_CODE, FROM_OFFICE_SYMBOL FROM_OFFICE_SYMBOL, FROM_OTHER_PAY_AMOUNT FROM_OTHER_PAY_AMOUNT, FROM_PAY_BASIS FROM_PAY_BASIS, FROM_PAY_PLAN FROM_PAY_PLAN, FROM_POSITION_ID FROM_POSITION_ID, FROM_POSITION_ORG_LINE1 FROM_POSITION_ORG_LINE1, FROM_POSITION_ORG_LINE2 FROM_POSITION_ORG_LINE2, FROM_POSITION_ORG_LINE3 FROM_POSITION_ORG_LINE3, FROM_POSITION_ORG_LINE4 FROM_POSITION_ORG_LINE4, FROM_POSITION_ORG_LINE5 FROM_POSITION_ORG_LINE5, FROM_POSITION_ORG_LINE6 FROM_POSITION_ORG_LINE6, FROM_POSITION_NUMBER FROM_POSITION_NUMBER, FROM_POSITION_SEQ_NO FROM_POSITION_SEQ_NO, FROM_POSITION_TITLE FROM_POSITION_TITLE, FROM_STEP_OR_RATE FROM_STEP_OR_RATE, FROM_TOTAL_SALARY FROM_TOTAL_SALARY, FUNCTIONAL_CLASS FUNCTIONAL_CLASS, NOTEPAD NOTEPAD, NOTIFICATION_PRINTED_BY NOTIFICATION_PRINTED_BY, NO_OF_NOTIFICATION_PRINTED NO_OF_NOTIFICATION_PRINTED, PART_TIME_HOURS PART_TIME_HOURS, PAY_RATE_DETERMINANT PAY_RATE_DETERMINANT, PERSONNEL_OFFICE_ID PERSONNEL_OFFICE_ID, PERSON_ID PERSON_ID, POSITION_OCCUPIED POSITION_OCCUPIED, PROPOSED_EFFECTIVE_ASAP_FLAG PROPOSED_EFFECTIVE_ASAP_FLAG, PROPOSED_EFFECTIVE_DATE PROPOSED_EFFECTIVE_DATE, REQUESTED_BY_PERSON_ID REQUESTED_BY_PERSON_ID, REQUESTED_BY_TITLE REQUESTED_BY_TITLE, REQUESTED_DATE REQUESTED_DATE, REQUESTING_OFFICE_REMARKS_DESC REQUESTING_OFFICE_REMARKS_DESC, REQUESTING_OFFICE_REMARKS_FLAG REQUESTING_OFFICE_REMARKS_FLAG, REQUEST_NUMBER REQUEST_NUMBER, RESIGN_AND_RETIRE_REASON_DESC RESIGN_AND_RETIRE_REASON_DESC, RETIREMENT_PLAN RETIREMENT_PLAN, RETIREMENT_PLAN_DESC RETIREMENT_PLAN_DESC, SECOND_ACTION_LA_CODE1 SECOND_ACTION_LA_CODE1, SECOND_ACTION_LA_CODE2 SECOND_ACTION_LA_CODE2, SECOND_ACTION_LA_DESC1 SECOND_ACTION_LA_DESC1, SECOND_ACTION_LA_DESC2 SECOND_ACTION_LA_DESC2, SECOND_NOA_CANCEL_OR_CORRECT SECOND_NOA_CANCEL_OR_CORRECT, SECOND_NOA_CANC_PA_REQUEST_ID SECOND_NOA_CANC_PA_REQUEST_ID, SECOND_NOA_CODE SECOND_NOA_CODE, SECOND_NOA_DESC SECOND_NOA_DESC, SECOND_NOA_ID SECOND_NOA_ID, SECOND_NOA_PA_REQUEST_ID SECOND_NOA_PA_REQUEST_ID, SERVICE_COMP_DATE SERVICE_COMP_DATE, SF50_APPROVAL_DATE SF50_APPROVAL_DATE, SF50_APPROVING_OFCL_FULL_NAME SF50_APPROVING_OFCL_FULL_NAME, SF50_APPROVING_OFCL_WORK_TITLE SF50_APPROVING_OFCL_WORK_TITLE, STATUS STATUS, SUPERVISORY_STATUS SUPERVISORY_STATUS, TENURE TENURE, TO_ADJ_BASIC_PAY TO_ADJ_BASIC_PAY, TO_AP_PREMIUM_PAY_INDICATOR TO_AP_PREMIUM_PAY_INDICATOR, TO_AUO_PREMIUM_PAY_INDICATOR TO_AUO_PREMIUM_PAY_INDICATOR, TO_AU_OVERTIME TO_AU_OVERTIME, TO_AVAILABILITY_PAY TO_AVAILABILITY_PAY, TO_BASIC_PAY TO_BASIC_PAY, TO_GRADE_ID TO_GRADE_ID, TO_GRADE_OR_LEVEL TO_GRADE_OR_LEVEL, TO_JOB_ID TO_JOB_ID, TO_LOCALITY_ADJ TO_LOCALITY_ADJ, TO_OCC_CODE TO_OCC_CODE, TO_OFFICE_SYMBOL TO_OFFICE_SYMBOL, TO_ORGANIZATION_ID TO_ORGANIZATION_ID, TO_OTHER_PAY_AMOUNT TO_OTHER_PAY_AMOUNT, TO_PAY_BASIS TO_PAY_BASIS, TO_PAY_PLAN TO_PAY_PLAN, TO_POSITION_ID TO_POSITION_ID, TO_POSITION_ORG_LINE1 TO_POSITION_ORG_LINE1, TO_POSITION_ORG_LINE2 TO_POSITION_ORG_LINE2, TO_POSITION_ORG_LINE3 TO_POSITION_ORG_LINE3, TO_POSITION_ORG_LINE4 TO_POSITION_ORG_LINE4, TO_POSITION_ORG_LINE5 TO_POSITION_ORG_LINE5, TO_POSITION_ORG_LINE6 TO_POSITION_ORG_LINE6, TO_POSITION_NUMBER TO_POSITION_NUMBER, TO_POSITION_SEQ_NO TO_POSITION_SEQ_NO, TO_POSITION_TITLE TO_POSITION_TITLE, TO_RETENTION_ALLOWANCE TO_RETENTION_ALLOWANCE, TO_RETENTION_ALLOW_PERCENTAGE TO_RETENTION_ALLOW_PERCENTAGE, TO_STAFFING_DIFFERENTIAL TO_STAFFING_DIFFERENTIAL, TO_STAFFING_DIFF_PERCENTAGE TO_STAFFING_DIFF_PERCENTAGE, TO_STEP_OR_RATE TO_STEP_OR_RATE, TO_SUPERVISORY_DIFFERENTIAL TO_SUPERVISORY_DIFFERENTIAL, TO_SUPERVISORY_DIFF_PERCENTAGE TO_SUPERVISORY_DIFF_PERCENTAGE, TO_TOTAL_SALARY TO_TOTAL_SALARY, VETERANS_PREFERENCE VETERANS_PREFERENCE, VETERANS_PREF_FOR_RIF VETERANS_PREF_FOR_RIF, VETERANS_STATUS VETERANS_STATUS, WORK_SCHEDULE WORK_SCHEDULE, WORK_SCHEDULE_DESC WORK_SCHEDULE_DESC, YEAR_DEGREE_ATTAINED YEAR_DEGREE_ATTAINED, FIRST_NOA_INFORMATION_CAT FIRST_NOA_INFORMATION_CAT, FIRST_NOA_INFORMATION1 FIRST_NOA_INFORMATION1, FIRST_NOA_INFORMATION2 FIRST_NOA_INFORMATION2, FIRST_NOA_INFORMATION3 FIRST_NOA_INFORMATION3, FIRST_NOA_INFORMATION4 FIRST_NOA_INFORMATION4, FIRST_NOA_INFORMATION5 FIRST_NOA_INFORMATION5, SECOND_LAC1_INFORMATION_CAT SECOND_LAC1_INFORMATION_CAT, SECOND_LAC1_INFORMATION1 SECOND_LAC1_INFORMATION1, SECOND_LAC1_INFORMATION2 SECOND_LAC1_INFORMATION2, SECOND_LAC1_INFORMATION3 SECOND_LAC1_INFORMATION3, SECOND_LAC1_INFORMATION4 SECOND_LAC1_INFORMATION4, SECOND_LAC1_INFORMATION5 SECOND_LAC1_INFORMATION5, SECOND_LAC2_INFORMATION_CAT SECOND_LAC2_INFORMATION_CAT, SECOND_LAC2_INFORMATION1 SECOND_LAC2_INFORMATION1, SECOND_LAC2_INFORMATION2 SECOND_LAC2_INFORMATION2, SECOND_LAC2_INFORMATION3 SECOND_LAC2_INFORMATION3, SECOND_LAC2_INFORMATION4 SECOND_LAC2_INFORMATION4, SECOND_LAC2_INFORMATION5 SECOND_LAC2_INFORMATION5, SECOND_NOA_INFORMATION_CAT SECOND_NOA_INFORMATION_CAT, SECOND_NOA_INFORMATION1 SECOND_NOA_INFORMATION1, SECOND_NOA_INFORMATION2 SECOND_NOA_INFORMATION2, SECOND_NOA_INFORMATION3 SECOND_NOA_INFORMATION3, SECOND_NOA_INFORMATION4 SECOND_NOA_INFORMATION4, SECOND_NOA_INFORMATION5 SECOND_NOA_INFORMATION5, FIRST_LAC1_INFORMATION_CAT FIRST_LAC1_INFORMATION_CAT, FIRST_LAC1_INFORMATION1 FIRST_LAC1_INFORMATION1, FIRST_LAC1_INFORMATION2 FIRST_LAC1_INFORMATION2, FIRST_LAC1_INFORMATION3 FIRST_LAC1_INFORMATION3, FIRST_LAC1_INFORMATION4 FIRST_LAC1_INFORMATION4, FIRST_LAC1_INFORMATION5 FIRST_LAC1_INFORMATION5, FIRST_LAC2_INFORMATION_CAT FIRST_LAC2_INFORMATION_CAT, FIRST_LAC2_INFORMATION1 FIRST_LAC2_INFORMATION1, FIRST_LAC2_INFORMATION2 FIRST_LAC2_INFORMATION2, FIRST_LAC2_INFORMATION3 FIRST_LAC2_INFORMATION3, FIRST_LAC2_INFORMATION4 FIRST_LAC2_INFORMATION4, FIRST_LAC2_INFORMATION5 FIRST_LAC2_INFORMATION5, ATTRIBUTE_CATEGORY ATTRIBUTE_CATEGORY, ATTRIBUTE1 ATTRIBUTE1, ATTRIBUTE2 ATTRIBUTE2, ATTRIBUTE3 ATTRIBUTE3, ATTRIBUTE4 ATTRIBUTE4, ATTRIBUTE5 ATTRIBUTE5, ATTRIBUTE6 ATTRIBUTE6, ATTRIBUTE7 ATTRIBUTE7, ATTRIBUTE8 ATTRIBUTE8, ATTRIBUTE9 ATTRIBUTE9, ATTRIBUTE10 ATTRIBUTE10, ATTRIBUTE11 ATTRIBUTE11, ATTRIBUTE12 ATTRIBUTE12, ATTRIBUTE13 ATTRIBUTE13, ATTRIBUTE14 ATTRIBUTE14, ATTRIBUTE15 ATTRIBUTE15, ATTRIBUTE16 ATTRIBUTE16, ATTRIBUTE17 ATTRIBUTE17, ATTRIBUTE18 ATTRIBUTE18, ATTRIBUTE19 ATTRIBUTE19, ATTRIBUTE20 ATTRIBUTE20, CREATED_BY CREATED_BY, CREATION_DATE CREATION_DATE, LAST_UPDATED_BY LAST_UPDATED_BY, LAST_UPDATE_DATE LAST_UPDATE_DATE, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER, RPA_TYPE RPA_TYPE, MASS_ACTION_ID MASS_ACTION_ID, MASS_ACTION_ELIGIBLE_FLAG MASS_ACTION_ELIGIBLE_FLAG, MASS_ACTION_SELECT_FLAG MASS_ACTION_SELECT_FLAG, MASS_ACTION_COMMENTS MASS_ACTION_COMMENTS, AWARD_SALARY AWARD_SALARY, PA_INCENTIVE_PAYMENT_OPTION PA_INCENTIVE_PAYMENT_OPTION, INPUT_PAY_RATE_DETERMINANT INPUT_PAY_RATE_DETERMINANT, FROM_PAY_TABLE_IDENTIFIER FROM_PAY_TABLE_IDENTIFIER, TO_PAY_TABLE_IDENTIFIER TO_PAY_TABLE_IDENTIFIER, AUTHORIZED_BY_FULL_NAME AUTHORIZED_BY_FULL_NAME, REQUESTED_BY_FULL_NAME REQUESTED_BY_FULL_NAME from "HR"."GHR_PA_REQUESTS"

View Text - HTML Formatted

SELECT PA_REQUEST_ID PA_REQUEST_ID
, PA_NOTIFICATION_ID PA_NOTIFICATION_ID
, NOA_FAMILY_CODE NOA_FAMILY_CODE
, ROUTING_GROUP_ID ROUTING_GROUP_ID
, ACADEMIC_DISCIPLINE ACADEMIC_DISCIPLINE
, ADDITIONAL_INFO_PERSON_ID ADDITIONAL_INFO_PERSON_ID
, ADDITIONAL_INFO_TEL_NUMBER ADDITIONAL_INFO_TEL_NUMBER
, AGENCY_CODE AGENCY_CODE
, ALTERED_PA_REQUEST_ID ALTERED_PA_REQUEST_ID
, ANNUITANT_INDICATOR ANNUITANT_INDICATOR
, ANNUITANT_INDICATOR_DESC ANNUITANT_INDICATOR_DESC
, APPROPRIATION_CODE1 APPROPRIATION_CODE1
, APPROPRIATION_CODE2 APPROPRIATION_CODE2
, APPROVAL_DATE APPROVAL_DATE
, APPROVING_OFFICIAL_FULL_NAME APPROVING_OFFICIAL_FULL_NAME
, APPROVING_OFFICIAL_WORK_TITLE APPROVING_OFFICIAL_WORK_TITLE
, AUTHORIZED_BY_PERSON_ID AUTHORIZED_BY_PERSON_ID
, AUTHORIZED_BY_TITLE AUTHORIZED_BY_TITLE
, AWARD_AMOUNT AWARD_AMOUNT
, AWARD_PERCENTAGE AWARD_PERCENTAGE
, AWARD_UOM AWARD_UOM
, BARGAINING_UNIT_STATUS BARGAINING_UNIT_STATUS
, CITIZENSHIP CITIZENSHIP
, CONCURRENCE_DATE CONCURRENCE_DATE
, CUSTOM_PAY_CALC_FLAG CUSTOM_PAY_CALC_FLAG
, DUTY_STATION_CODE DUTY_STATION_CODE
, DUTY_STATION_DESC DUTY_STATION_DESC
, DUTY_STATION_ID DUTY_STATION_ID
, DUTY_STATION_LOCATION_ID DUTY_STATION_LOCATION_ID
, EDUCATION_LEVEL EDUCATION_LEVEL
, EFFECTIVE_DATE EFFECTIVE_DATE
, EMPLOYEE_ASSIGNMENT_ID EMPLOYEE_ASSIGNMENT_ID
, EMPLOYEE_DATE_OF_BIRTH EMPLOYEE_DATE_OF_BIRTH
, EMPLOYEE_DEPT_OR_AGENCY EMPLOYEE_DEPT_OR_AGENCY
, EMPLOYEE_FIRST_NAME EMPLOYEE_FIRST_NAME
, EMPLOYEE_LAST_NAME EMPLOYEE_LAST_NAME
, EMPLOYEE_MIDDLE_NAMES EMPLOYEE_MIDDLE_NAMES
, EMPLOYEE_NATIONAL_IDENTIFIER EMPLOYEE_NATIONAL_IDENTIFIER
, FEGLI FEGLI
, FEGLI_DESC FEGLI_DESC
, FIRST_ACTION_LA_CODE1 FIRST_ACTION_LA_CODE1
, FIRST_ACTION_LA_CODE2 FIRST_ACTION_LA_CODE2
, FIRST_ACTION_LA_DESC1 FIRST_ACTION_LA_DESC1
, FIRST_ACTION_LA_DESC2 FIRST_ACTION_LA_DESC2
, FIRST_NOA_CANCEL_OR_CORRECT FIRST_NOA_CANCEL_OR_CORRECT
, FIRST_NOA_CANC_PA_REQUEST_ID FIRST_NOA_CANC_PA_REQUEST_ID
, FIRST_NOA_CODE FIRST_NOA_CODE
, FIRST_NOA_DESC FIRST_NOA_DESC
, FIRST_NOA_ID FIRST_NOA_ID
, FIRST_NOA_PA_REQUEST_ID FIRST_NOA_PA_REQUEST_ID
, FLSA_CATEGORY FLSA_CATEGORY
, FORWARDING_ADDRESS_LINE1 FORWARDING_ADDRESS_LINE1
, FORWARDING_ADDRESS_LINE2 FORWARDING_ADDRESS_LINE2
, FORWARDING_ADDRESS_LINE3 FORWARDING_ADDRESS_LINE3
, FORWARDING_COUNTRY FORWARDING_COUNTRY
, FORWARDING_COUNTRY_SHORT_NAME FORWARDING_COUNTRY_SHORT_NAME
, FORWARDING_POSTAL_CODE FORWARDING_POSTAL_CODE
, FORWARDING_REGION_2 FORWARDING_REGION_2
, FORWARDING_TOWN_OR_CITY FORWARDING_TOWN_OR_CITY
, FROM_ADJ_BASIC_PAY FROM_ADJ_BASIC_PAY
, FROM_AGENCY_CODE FROM_AGENCY_CODE
, FROM_AGENCY_DESC FROM_AGENCY_DESC
, FROM_BASIC_PAY FROM_BASIC_PAY
, FROM_GRADE_OR_LEVEL FROM_GRADE_OR_LEVEL
, FROM_LOCALITY_ADJ FROM_LOCALITY_ADJ
, FROM_OCC_CODE FROM_OCC_CODE
, FROM_OFFICE_SYMBOL FROM_OFFICE_SYMBOL
, FROM_OTHER_PAY_AMOUNT FROM_OTHER_PAY_AMOUNT
, FROM_PAY_BASIS FROM_PAY_BASIS
, FROM_PAY_PLAN FROM_PAY_PLAN
, FROM_POSITION_ID FROM_POSITION_ID
, FROM_POSITION_ORG_LINE1 FROM_POSITION_ORG_LINE1
, FROM_POSITION_ORG_LINE2 FROM_POSITION_ORG_LINE2
, FROM_POSITION_ORG_LINE3 FROM_POSITION_ORG_LINE3
, FROM_POSITION_ORG_LINE4 FROM_POSITION_ORG_LINE4
, FROM_POSITION_ORG_LINE5 FROM_POSITION_ORG_LINE5
, FROM_POSITION_ORG_LINE6 FROM_POSITION_ORG_LINE6
, FROM_POSITION_NUMBER FROM_POSITION_NUMBER
, FROM_POSITION_SEQ_NO FROM_POSITION_SEQ_NO
, FROM_POSITION_TITLE FROM_POSITION_TITLE
, FROM_STEP_OR_RATE FROM_STEP_OR_RATE
, FROM_TOTAL_SALARY FROM_TOTAL_SALARY
, FUNCTIONAL_CLASS FUNCTIONAL_CLASS
, NOTEPAD NOTEPAD
, NOTIFICATION_PRINTED_BY NOTIFICATION_PRINTED_BY
, NO_OF_NOTIFICATION_PRINTED NO_OF_NOTIFICATION_PRINTED
, PART_TIME_HOURS PART_TIME_HOURS
, PAY_RATE_DETERMINANT PAY_RATE_DETERMINANT
, PERSONNEL_OFFICE_ID PERSONNEL_OFFICE_ID
, PERSON_ID PERSON_ID
, POSITION_OCCUPIED POSITION_OCCUPIED
, PROPOSED_EFFECTIVE_ASAP_FLAG PROPOSED_EFFECTIVE_ASAP_FLAG
, PROPOSED_EFFECTIVE_DATE PROPOSED_EFFECTIVE_DATE
, REQUESTED_BY_PERSON_ID REQUESTED_BY_PERSON_ID
, REQUESTED_BY_TITLE REQUESTED_BY_TITLE
, REQUESTED_DATE REQUESTED_DATE
, REQUESTING_OFFICE_REMARKS_DESC REQUESTING_OFFICE_REMARKS_DESC
, REQUESTING_OFFICE_REMARKS_FLAG REQUESTING_OFFICE_REMARKS_FLAG
, REQUEST_NUMBER REQUEST_NUMBER
, RESIGN_AND_RETIRE_REASON_DESC RESIGN_AND_RETIRE_REASON_DESC
, RETIREMENT_PLAN RETIREMENT_PLAN
, RETIREMENT_PLAN_DESC RETIREMENT_PLAN_DESC
, SECOND_ACTION_LA_CODE1 SECOND_ACTION_LA_CODE1
, SECOND_ACTION_LA_CODE2 SECOND_ACTION_LA_CODE2
, SECOND_ACTION_LA_DESC1 SECOND_ACTION_LA_DESC1
, SECOND_ACTION_LA_DESC2 SECOND_ACTION_LA_DESC2
, SECOND_NOA_CANCEL_OR_CORRECT SECOND_NOA_CANCEL_OR_CORRECT
, SECOND_NOA_CANC_PA_REQUEST_ID SECOND_NOA_CANC_PA_REQUEST_ID
, SECOND_NOA_CODE SECOND_NOA_CODE
, SECOND_NOA_DESC SECOND_NOA_DESC
, SECOND_NOA_ID SECOND_NOA_ID
, SECOND_NOA_PA_REQUEST_ID SECOND_NOA_PA_REQUEST_ID
, SERVICE_COMP_DATE SERVICE_COMP_DATE
, SF50_APPROVAL_DATE SF50_APPROVAL_DATE
, SF50_APPROVING_OFCL_FULL_NAME SF50_APPROVING_OFCL_FULL_NAME
, SF50_APPROVING_OFCL_WORK_TITLE SF50_APPROVING_OFCL_WORK_TITLE
, STATUS STATUS
, SUPERVISORY_STATUS SUPERVISORY_STATUS
, TENURE TENURE
, TO_ADJ_BASIC_PAY TO_ADJ_BASIC_PAY
, TO_AP_PREMIUM_PAY_INDICATOR TO_AP_PREMIUM_PAY_INDICATOR
, TO_AUO_PREMIUM_PAY_INDICATOR TO_AUO_PREMIUM_PAY_INDICATOR
, TO_AU_OVERTIME TO_AU_OVERTIME
, TO_AVAILABILITY_PAY TO_AVAILABILITY_PAY
, TO_BASIC_PAY TO_BASIC_PAY
, TO_GRADE_ID TO_GRADE_ID
, TO_GRADE_OR_LEVEL TO_GRADE_OR_LEVEL
, TO_JOB_ID TO_JOB_ID
, TO_LOCALITY_ADJ TO_LOCALITY_ADJ
, TO_OCC_CODE TO_OCC_CODE
, TO_OFFICE_SYMBOL TO_OFFICE_SYMBOL
, TO_ORGANIZATION_ID TO_ORGANIZATION_ID
, TO_OTHER_PAY_AMOUNT TO_OTHER_PAY_AMOUNT
, TO_PAY_BASIS TO_PAY_BASIS
, TO_PAY_PLAN TO_PAY_PLAN
, TO_POSITION_ID TO_POSITION_ID
, TO_POSITION_ORG_LINE1 TO_POSITION_ORG_LINE1
, TO_POSITION_ORG_LINE2 TO_POSITION_ORG_LINE2
, TO_POSITION_ORG_LINE3 TO_POSITION_ORG_LINE3
, TO_POSITION_ORG_LINE4 TO_POSITION_ORG_LINE4
, TO_POSITION_ORG_LINE5 TO_POSITION_ORG_LINE5
, TO_POSITION_ORG_LINE6 TO_POSITION_ORG_LINE6
, TO_POSITION_NUMBER TO_POSITION_NUMBER
, TO_POSITION_SEQ_NO TO_POSITION_SEQ_NO
, TO_POSITION_TITLE TO_POSITION_TITLE
, TO_RETENTION_ALLOWANCE TO_RETENTION_ALLOWANCE
, TO_RETENTION_ALLOW_PERCENTAGE TO_RETENTION_ALLOW_PERCENTAGE
, TO_STAFFING_DIFFERENTIAL TO_STAFFING_DIFFERENTIAL
, TO_STAFFING_DIFF_PERCENTAGE TO_STAFFING_DIFF_PERCENTAGE
, TO_STEP_OR_RATE TO_STEP_OR_RATE
, TO_SUPERVISORY_DIFFERENTIAL TO_SUPERVISORY_DIFFERENTIAL
, TO_SUPERVISORY_DIFF_PERCENTAGE TO_SUPERVISORY_DIFF_PERCENTAGE
, TO_TOTAL_SALARY TO_TOTAL_SALARY
, VETERANS_PREFERENCE VETERANS_PREFERENCE
, VETERANS_PREF_FOR_RIF VETERANS_PREF_FOR_RIF
, VETERANS_STATUS VETERANS_STATUS
, WORK_SCHEDULE WORK_SCHEDULE
, WORK_SCHEDULE_DESC WORK_SCHEDULE_DESC
, YEAR_DEGREE_ATTAINED YEAR_DEGREE_ATTAINED
, FIRST_NOA_INFORMATION_CAT FIRST_NOA_INFORMATION_CAT
, FIRST_NOA_INFORMATION1 FIRST_NOA_INFORMATION1
, FIRST_NOA_INFORMATION2 FIRST_NOA_INFORMATION2
, FIRST_NOA_INFORMATION3 FIRST_NOA_INFORMATION3
, FIRST_NOA_INFORMATION4 FIRST_NOA_INFORMATION4
, FIRST_NOA_INFORMATION5 FIRST_NOA_INFORMATION5
, SECOND_LAC1_INFORMATION_CAT SECOND_LAC1_INFORMATION_CAT
, SECOND_LAC1_INFORMATION1 SECOND_LAC1_INFORMATION1
, SECOND_LAC1_INFORMATION2 SECOND_LAC1_INFORMATION2
, SECOND_LAC1_INFORMATION3 SECOND_LAC1_INFORMATION3
, SECOND_LAC1_INFORMATION4 SECOND_LAC1_INFORMATION4
, SECOND_LAC1_INFORMATION5 SECOND_LAC1_INFORMATION5
, SECOND_LAC2_INFORMATION_CAT SECOND_LAC2_INFORMATION_CAT
, SECOND_LAC2_INFORMATION1 SECOND_LAC2_INFORMATION1
, SECOND_LAC2_INFORMATION2 SECOND_LAC2_INFORMATION2
, SECOND_LAC2_INFORMATION3 SECOND_LAC2_INFORMATION3
, SECOND_LAC2_INFORMATION4 SECOND_LAC2_INFORMATION4
, SECOND_LAC2_INFORMATION5 SECOND_LAC2_INFORMATION5
, SECOND_NOA_INFORMATION_CAT SECOND_NOA_INFORMATION_CAT
, SECOND_NOA_INFORMATION1 SECOND_NOA_INFORMATION1
, SECOND_NOA_INFORMATION2 SECOND_NOA_INFORMATION2
, SECOND_NOA_INFORMATION3 SECOND_NOA_INFORMATION3
, SECOND_NOA_INFORMATION4 SECOND_NOA_INFORMATION4
, SECOND_NOA_INFORMATION5 SECOND_NOA_INFORMATION5
, FIRST_LAC1_INFORMATION_CAT FIRST_LAC1_INFORMATION_CAT
, FIRST_LAC1_INFORMATION1 FIRST_LAC1_INFORMATION1
, FIRST_LAC1_INFORMATION2 FIRST_LAC1_INFORMATION2
, FIRST_LAC1_INFORMATION3 FIRST_LAC1_INFORMATION3
, FIRST_LAC1_INFORMATION4 FIRST_LAC1_INFORMATION4
, FIRST_LAC1_INFORMATION5 FIRST_LAC1_INFORMATION5
, FIRST_LAC2_INFORMATION_CAT FIRST_LAC2_INFORMATION_CAT
, FIRST_LAC2_INFORMATION1 FIRST_LAC2_INFORMATION1
, FIRST_LAC2_INFORMATION2 FIRST_LAC2_INFORMATION2
, FIRST_LAC2_INFORMATION3 FIRST_LAC2_INFORMATION3
, FIRST_LAC2_INFORMATION4 FIRST_LAC2_INFORMATION4
, FIRST_LAC2_INFORMATION5 FIRST_LAC2_INFORMATION5
, ATTRIBUTE_CATEGORY ATTRIBUTE_CATEGORY
, ATTRIBUTE1 ATTRIBUTE1
, ATTRIBUTE2 ATTRIBUTE2
, ATTRIBUTE3 ATTRIBUTE3
, ATTRIBUTE4 ATTRIBUTE4
, ATTRIBUTE5 ATTRIBUTE5
, ATTRIBUTE6 ATTRIBUTE6
, ATTRIBUTE7 ATTRIBUTE7
, ATTRIBUTE8 ATTRIBUTE8
, ATTRIBUTE9 ATTRIBUTE9
, ATTRIBUTE10 ATTRIBUTE10
, ATTRIBUTE11 ATTRIBUTE11
, ATTRIBUTE12 ATTRIBUTE12
, ATTRIBUTE13 ATTRIBUTE13
, ATTRIBUTE14 ATTRIBUTE14
, ATTRIBUTE15 ATTRIBUTE15
, ATTRIBUTE16 ATTRIBUTE16
, ATTRIBUTE17 ATTRIBUTE17
, ATTRIBUTE18 ATTRIBUTE18
, ATTRIBUTE19 ATTRIBUTE19
, ATTRIBUTE20 ATTRIBUTE20
, CREATED_BY CREATED_BY
, CREATION_DATE CREATION_DATE
, LAST_UPDATED_BY LAST_UPDATED_BY
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER
, RPA_TYPE RPA_TYPE
, MASS_ACTION_ID MASS_ACTION_ID
, MASS_ACTION_ELIGIBLE_FLAG MASS_ACTION_ELIGIBLE_FLAG
, MASS_ACTION_SELECT_FLAG MASS_ACTION_SELECT_FLAG
, MASS_ACTION_COMMENTS MASS_ACTION_COMMENTS
, AWARD_SALARY AWARD_SALARY
, PA_INCENTIVE_PAYMENT_OPTION PA_INCENTIVE_PAYMENT_OPTION
, INPUT_PAY_RATE_DETERMINANT INPUT_PAY_RATE_DETERMINANT
, FROM_PAY_TABLE_IDENTIFIER FROM_PAY_TABLE_IDENTIFIER
, TO_PAY_TABLE_IDENTIFIER TO_PAY_TABLE_IDENTIFIER
, AUTHORIZED_BY_FULL_NAME AUTHORIZED_BY_FULL_NAME
, REQUESTED_BY_FULL_NAME REQUESTED_BY_FULL_NAME
FROM "HR"."GHR_PA_REQUESTS"