VIEW: HR.GHR_PA_REQUEST_SHADOW#

Source

View Text - Preformatted

select PA_REQUEST_ID PA_REQUEST_ID, ACADEMIC_DISCIPLINE ACADEMIC_DISCIPLINE, ANNUITANT_INDICATOR ANNUITANT_INDICATOR, APPROPRIATION_CODE1 APPROPRIATION_CODE1, APPROPRIATION_CODE2 APPROPRIATION_CODE2, BARGAINING_UNIT_STATUS BARGAINING_UNIT_STATUS, CITIZENSHIP CITIZENSHIP, DUTY_STATION_ID DUTY_STATION_ID, DUTY_STATION_LOCATION_ID DUTY_STATION_LOCATION_ID, EDUCATION_LEVEL EDUCATION_LEVEL, EMPLOYEE_DATE_OF_BIRTH EMPLOYEE_DATE_OF_BIRTH, 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, FLSA_CATEGORY FLSA_CATEGORY, FORWARDING_ADDRESS_LINE1 FORWARDING_ADDRESS_LINE1, FORWARDING_ADDRESS_LINE2 FORWARDING_ADDRESS_LINE2, FORWARDING_ADDRESS_LINE3 FORWARDING_ADDRESS_LINE3, 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, FUNCTIONAL_CLASS FUNCTIONAL_CLASS, PART_TIME_HOURS PART_TIME_HOURS, PAY_RATE_DETERMINANT PAY_RATE_DETERMINANT, POSITION_OCCUPIED POSITION_OCCUPIED, RETIREMENT_PLAN RETIREMENT_PLAN, SERVICE_COMP_DATE SERVICE_COMP_DATE, SUPERVISORY_STATUS SUPERVISORY_STATUS, TENURE TENURE, TO_AP_PREMIUM_PAY_INDICATOR TO_AP_PREMIUM_PAY_INDICATOR, TO_AUO_PREMIUM_PAY_INDICATOR TO_AUO_PREMIUM_PAY_INDICATOR, TO_OCC_CODE TO_OCC_CODE, TO_POSITION_ID TO_POSITION_ID, 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, VETERANS_PREFERENCE VETERANS_PREFERENCE, VETERANS_PREF_FOR_RIF VETERANS_PREF_FOR_RIF, VETERANS_STATUS VETERANS_STATUS, WORK_SCHEDULE WORK_SCHEDULE, YEAR_DEGREE_ATTAINED YEAR_DEGREE_ATTAINED, 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, AWARD_AMOUNT AWARD_AMOUNT, AWARD_UOM AWARD_UOM, AWARD_PERCENTAGE AWARD_PERCENTAGE, TO_GRADE_OR_LEVEL TO_GRADE_OR_LEVEL, TO_GRADE_ID TO_GRADE_ID, FIRST_ACTION_LA_CODE1 FIRST_ACTION_LA_CODE1, FIRST_ACTION_LA_CODE2 FIRST_ACTION_LA_CODE2, SECOND_ACTION_LA_CODE1 SECOND_ACTION_LA_CODE1, SECOND_ACTION_LA_CODE2 SECOND_ACTION_LA_CODE2 from "HR"."GHR_PA_REQUEST_SHADOW"

View Text - HTML Formatted

SELECT PA_REQUEST_ID PA_REQUEST_ID
, ACADEMIC_DISCIPLINE ACADEMIC_DISCIPLINE
, ANNUITANT_INDICATOR ANNUITANT_INDICATOR
, APPROPRIATION_CODE1 APPROPRIATION_CODE1
, APPROPRIATION_CODE2 APPROPRIATION_CODE2
, BARGAINING_UNIT_STATUS BARGAINING_UNIT_STATUS
, CITIZENSHIP CITIZENSHIP
, DUTY_STATION_ID DUTY_STATION_ID
, DUTY_STATION_LOCATION_ID DUTY_STATION_LOCATION_ID
, EDUCATION_LEVEL EDUCATION_LEVEL
, EMPLOYEE_DATE_OF_BIRTH EMPLOYEE_DATE_OF_BIRTH
, 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
, FLSA_CATEGORY FLSA_CATEGORY
, FORWARDING_ADDRESS_LINE1 FORWARDING_ADDRESS_LINE1
, FORWARDING_ADDRESS_LINE2 FORWARDING_ADDRESS_LINE2
, FORWARDING_ADDRESS_LINE3 FORWARDING_ADDRESS_LINE3
, 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
, FUNCTIONAL_CLASS FUNCTIONAL_CLASS
, PART_TIME_HOURS PART_TIME_HOURS
, PAY_RATE_DETERMINANT PAY_RATE_DETERMINANT
, POSITION_OCCUPIED POSITION_OCCUPIED
, RETIREMENT_PLAN RETIREMENT_PLAN
, SERVICE_COMP_DATE SERVICE_COMP_DATE
, SUPERVISORY_STATUS SUPERVISORY_STATUS
, TENURE TENURE
, TO_AP_PREMIUM_PAY_INDICATOR TO_AP_PREMIUM_PAY_INDICATOR
, TO_AUO_PREMIUM_PAY_INDICATOR TO_AUO_PREMIUM_PAY_INDICATOR
, TO_OCC_CODE TO_OCC_CODE
, TO_POSITION_ID TO_POSITION_ID
, 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
, VETERANS_PREFERENCE VETERANS_PREFERENCE
, VETERANS_PREF_FOR_RIF VETERANS_PREF_FOR_RIF
, VETERANS_STATUS VETERANS_STATUS
, WORK_SCHEDULE WORK_SCHEDULE
, YEAR_DEGREE_ATTAINED YEAR_DEGREE_ATTAINED
, 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
, AWARD_AMOUNT AWARD_AMOUNT
, AWARD_UOM AWARD_UOM
, AWARD_PERCENTAGE AWARD_PERCENTAGE
, TO_GRADE_OR_LEVEL TO_GRADE_OR_LEVEL
, TO_GRADE_ID TO_GRADE_ID
, FIRST_ACTION_LA_CODE1 FIRST_ACTION_LA_CODE1
, FIRST_ACTION_LA_CODE2 FIRST_ACTION_LA_CODE2
, SECOND_ACTION_LA_CODE1 SECOND_ACTION_LA_CODE1
, SECOND_ACTION_LA_CODE2 SECOND_ACTION_LA_CODE2
FROM "HR"."GHR_PA_REQUEST_SHADOW"