VIEW: HR.GHR_CPDF_TEMP#

Source

View Text - Preformatted

select REPORT_TYPE REPORT_TYPE, SESSION_ID SESSION_ID, ACADEMIC_DISCIPLINE ACADEMIC_DISCIPLINE, AGENCY_CODE AGENCY_CODE, ANNUITANT_INDICATOR ANNUITANT_INDICATOR, AWARD_AMOUNT AWARD_AMOUNT, BARGAINING_UNIT_STATUS BARGAINING_UNIT_STATUS, BENEFIT_AMOUNT BENEFIT_AMOUNT, CITIZENSHIP CITIZENSHIP, CREDITABLE_MILITARY_SERVICE CREDITABLE_MILITARY_SERVICE, CURRENT_APPOINTMENT_AUTH1 CURRENT_APPOINTMENT_AUTH1, CURRENT_APPOINTMENT_AUTH2 CURRENT_APPOINTMENT_AUTH2, EDUCATION_LEVEL EDUCATION_LEVEL, EFFECTIVE_DATE EFFECTIVE_DATE, 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, FEGLI FEGLI, FERS_COVERAGE FERS_COVERAGE, FIRST_ACTION_LA_CODE1 FIRST_ACTION_LA_CODE1, FIRST_ACTION_LA_CODE2 FIRST_ACTION_LA_CODE2, FIRST_NOA_CODE FIRST_NOA_CODE, FLSA_CATEGORY FLSA_CATEGORY, FROM_BASIC_PAY FROM_BASIC_PAY, FROM_DUTY_STATION_CODE FROM_DUTY_STATION_CODE, FROM_GRADE_OR_LEVEL FROM_GRADE_OR_LEVEL, FROM_LOCALITY_ADJ FROM_LOCALITY_ADJ, FROM_NATIONAL_IDENTIFIER FROM_NATIONAL_IDENTIFIER, FROM_OCC_CODE FROM_OCC_CODE, FROM_PAY_BASIS FROM_PAY_BASIS, FROM_PAY_PLAN FROM_PAY_PLAN, FROM_PAY_RATE_DETERMINANT FROM_PAY_RATE_DETERMINANT, FROM_PAY_TABLE_ID FROM_PAY_TABLE_ID, FROM_RETIREMENT_COVERAGE FROM_RETIREMENT_COVERAGE, FROM_STEP_OR_RATE FROM_STEP_OR_RATE, FROM_TOTAL_SALARY FROM_TOTAL_SALARY, FROM_WORK_SCHEDULE FROM_WORK_SCHEDULE, FROZEN_SERVICE FROZEN_SERVICE, FUNCTIONAL_CLASS FUNCTIONAL_CLASS, HANDICAP_CODE HANDICAP_CODE, HEALTH_PLAN HEALTH_PLAN, INDIVIDUAL_GROUP_AWARD INDIVIDUAL_GROUP_AWARD, ORGANIZATIONAL_COMPONENT ORGANIZATIONAL_COMPONENT, PAY_STATUS PAY_STATUS, PERSONNEL_OFFICE_ID PERSONNEL_OFFICE_ID, POSITION_OCCUPIED POSITION_OCCUPIED, RACE_NATIONAL_ORIGIN RACE_NATIONAL_ORIGIN, RATING_OF_RECORD RATING_OF_RECORD, RATING_OF_RECORD_LEVEL RATING_OF_RECORD_LEVEL, RATING_OF_RECORD_PATTERN RATING_OF_RECORD_PATTERN, RATING_OF_RECORD_PERIOD_ENDS RATING_OF_RECORD_PERIOD_ENDS, RETAINED_STEP_OR_RATE RETAINED_STEP_OR_RATE, RETAINED_GRADE_OR_LEVEL RETAINED_GRADE_OR_LEVEL, RETAINED_PAY_PLAN RETAINED_PAY_PLAN, RETIREMENT_PLAN RETIREMENT_PLAN, SECOND_NOA_CODE SECOND_NOA_CODE, SERVICE_COMP_DATE SERVICE_COMP_DATE, SEX SEX, SUPERVISORY_STATUS SUPERVISORY_STATUS, TENURE TENURE, TO_BASIC_PAY TO_BASIC_PAY, TO_DUTY_STATION_CODE TO_DUTY_STATION_CODE, TO_GRADE_OR_LEVEL TO_GRADE_OR_LEVEL, TO_LOCALITY_ADJ TO_LOCALITY_ADJ, TO_NATIONAL_IDENTIFIER TO_NATIONAL_IDENTIFIER, TO_OCC_CODE TO_OCC_CODE, TO_PAY_BASIS TO_PAY_BASIS, TO_PAY_PLAN TO_PAY_PLAN, TO_PAY_RATE_DETERMINANT TO_PAY_RATE_DETERMINANT, TO_PAY_TABLE_ID TO_PAY_TABLE_ID, TO_RETENTION_ALLOWANCE TO_RETENTION_ALLOWANCE, TO_STAFFING_DIFFERENTIAL TO_STAFFING_DIFFERENTIAL, TO_STEP_OR_RATE TO_STEP_OR_RATE, TO_SUPERVISORY_DIFFERENTIAL TO_SUPERVISORY_DIFFERENTIAL, TO_TOTAL_SALARY TO_TOTAL_SALARY, TO_WORK_SCHEDULE TO_WORK_SCHEDULE, VETERANS_PREFERENCE VETERANS_PREFERENCE, VETERANS_STATUS VETERANS_STATUS, YEAR_DEGREE_ATTAINED YEAR_DEGREE_ATTAINED, 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, NAME_TITLE NAME_TITLE, POSITION_TITLE POSITION_TITLE, AWARD_DOLLARS AWARD_DOLLARS, AWARD_HOURS AWARD_HOURS, AWARD_PERCENTAGE AWARD_PERCENTAGE, SCD_RIF SCD_RIF, SCD_RETIREMENT SCD_RETIREMENT, VETERANS_PREF_FOR_RIF VETERANS_PREF_FOR_RIF, LANG_WRITE_PROF LANG_WRITE_PROF, IPA_BEN_NOTIFICATION IPA_BEN_NOTIFICATION, EHRI_EMPLOYEE_ID EHRI_EMPLOYEE_ID, SLCT_SERV_REGI_INDICATOR SLCT_SERV_REGI_INDICATOR, CAREER_TENURE_CODE CAREER_TENURE_CODE, SCD_SES SCD_SES, SCD_SPCL_RETIRE SCD_SPCL_RETIRE, FERS_ELECT_DATE FERS_ELECT_DATE, FERS_ELECT_INDICATOR FERS_ELECT_INDICATOR, DISABILITY_RETIRE_NOTIFY DISABILITY_RETIRE_NOTIFY, ACT_SVC_INDICATOR ACT_SVC_INDICATOR, MIL_CHAR_SVC_CODE MIL_CHAR_SVC_CODE, MIL_SVC_SNO MIL_SVC_SNO, MIL_SVC_START_DATE MIL_SVC_START_DATE, MIL_BRANCH_CODE MIL_BRANCH_CODE, MIL_DISCHARGE_CODE MIL_DISCHARGE_CODE, ALB_INDICATOR ALB_INDICATOR, ALB_ELECT_DATE ALB_ELECT_DATE, ALB_NOTIFY_DATE ALB_NOTIFY_DATE, FEGLI_INDICATOR FEGLI_INDICATOR, FEGLI_ELECT_DATE FEGLI_ELECT_DATE, FEGLI_NOTIFY_DATE FEGLI_NOTIFY_DATE, FEHB_INDICATOR FEHB_INDICATOR, FEHB_ELECT_DATE FEHB_ELECT_DATE, FEHB_NOTIFY_DATE FEHB_NOTIFY_DATE, RETIRE_INDICATOR RETIRE_INDICATOR, RETIRE_ELECT_DATE RETIRE_ELECT_DATE, RETIRE_NOTIFY_DATE RETIRE_NOTIFY_DATE, CONT_ELECT_DATE CONT_ELECT_DATE, CONT_NOTIFY_DATE CONT_NOTIFY_DATE, CONT_TERM_ELECT_DATE CONT_TERM_ELECT_DATE, CONT_INS_PAY_NOTIFY_DATE CONT_INS_PAY_NOTIFY_DATE, CONT_PAY_TYPE_CODE CONT_PAY_TYPE_CODE, COMP_POS_INDICATOR COMP_POS_INDICATOR, AGENCY_EMPLOYEE_ID AGENCY_EMPLOYEE_ID, SVC_OBLIG_TYPE_CODE1 SVC_OBLIG_TYPE_CODE1, SVC_OBLIG_TYPE_START_DATE1 SVC_OBLIG_TYPE_START_DATE1, SVC_OBLIG_TYPE_END_DATE1 SVC_OBLIG_TYPE_END_DATE1, SVC_OBLIG_TYPE_CODE2 SVC_OBLIG_TYPE_CODE2, SVC_OBLIG_TYPE_START_DATE2 SVC_OBLIG_TYPE_START_DATE2, SVC_OBLIG_TYPE_END_DATE2 SVC_OBLIG_TYPE_END_DATE2, SVC_OBLIG_TYPE_CODE3 SVC_OBLIG_TYPE_CODE3, SVC_OBLIG_TYPE_START_DATE3 SVC_OBLIG_TYPE_START_DATE3, SVC_OBLIG_TYPE_END_DATE3 SVC_OBLIG_TYPE_END_DATE3, SVC_OBLIG_TYPE_CODE4 SVC_OBLIG_TYPE_CODE4, SVC_OBLIG_TYPE_START_DATE4 SVC_OBLIG_TYPE_START_DATE4, SVC_OBLIG_TYPE_END_DATE4 SVC_OBLIG_TYPE_END_DATE4, INST_PROGRAM_CODE INST_PROGRAM_CODE, APPOINT_TYPE_CODE APPOINT_TYPE_CODE, PART_TIME_HOURS PART_TIME_HOURS, SPCL_SALARY_RATE SPCL_SALARY_RATE, TO_ADJ_BASIC_PAY TO_ADJ_BASIC_PAY, SPCL_PAY_TBL_TYPE SPCL_PAY_TBL_TYPE, APPROPRIATION_CODE APPROPRIATION_CODE, RATING_OF_RECORD_PERIOD_STARTS RATING_OF_RECORD_PERIOD_STARTS, FEGLI_LIFE_CHANGE_CODE FEGLI_LIFE_CHANGE_CODE, FEGLI_LIFE_EVENT_DATE FEGLI_LIFE_EVENT_DATE, FEGLI_ELECT_EFFECTIVE_DATE FEGLI_ELECT_EFFECTIVE_DATE, FEHB_PLAN_CODE FEHB_PLAN_CODE, FEHB_EVENT_CODE FEHB_EVENT_CODE, TSP_ELIGIBILITY_DATE TSP_ELIGIBILITY_DATE, TSP_EFFECTIVE_DATE TSP_EFFECTIVE_DATE, TSP_ELECT_CONTRIB_PCT TSP_ELECT_CONTRIB_PCT, LEAVE_SCD LEAVE_SCD, TSP_SCD TSP_SCD, WORK_ADDRESS_LINE1 WORK_ADDRESS_LINE1, WORK_ADDRESS_LINE2 WORK_ADDRESS_LINE2, WORK_ADDRESS_LINE3 WORK_ADDRESS_LINE3, WORK_ADDRESS_LINE4 WORK_ADDRESS_LINE4, WORK_CITY WORK_CITY, WORK_POSTAL_CODE WORK_POSTAL_CODE, WORK_REGION WORK_REGION, WORK_COUNTRY_CODE WORK_COUNTRY_CODE, WORK_EMPLOYEE_EMAIL WORK_EMPLOYEE_EMAIL, WORK_PHONE_NUMBER WORK_PHONE_NUMBER, HOME_PHONE_NUMBER HOME_PHONE_NUMBER, CELL_PHONE_NUMBER CELL_PHONE_NUMBER, EMRGNCY_CNTCT_FAMILY_NAME1 EMRGNCY_CNTCT_FAMILY_NAME1, EMRGNCY_CNTCT_GIVEN_NAME1 EMRGNCY_CNTCT_GIVEN_NAME1, EMRGNCY_CNTCT_MIDDLE_NAME1 EMRGNCY_CNTCT_MIDDLE_NAME1, EMRGNCY_CNTCT_SUFFIX1 EMRGNCY_CNTCT_SUFFIX1, EMRGNCY_CNTCT_INFRM_UPD_DT1 EMRGNCY_CNTCT_INFRM_UPD_DT1, EMRGNCY_CNTCT_PHONE1 EMRGNCY_CNTCT_PHONE1, EMRGNCY_CNTCT_FAMILY_NAME2 EMRGNCY_CNTCT_FAMILY_NAME2, EMRGNCY_CNTCT_GIVEN_NAME2 EMRGNCY_CNTCT_GIVEN_NAME2, EMRGNCY_CNTCT_MIDDLE_NAME2 EMRGNCY_CNTCT_MIDDLE_NAME2, EMRGNCY_CNTCT_SUFFIX2 EMRGNCY_CNTCT_SUFFIX2, EMRGNCY_CNTCT_INFRM_UPD_DT2 EMRGNCY_CNTCT_INFRM_UPD_DT2, EMRGNCY_CNTCT_PHONE2 EMRGNCY_CNTCT_PHONE2, LANGUAGE_CODE1 LANGUAGE_CODE1, LANG_PROF_TYPE1 LANG_PROF_TYPE1, LANG_PROF_LEVEL1 LANG_PROF_LEVEL1, LANGUAGE_CODE2 LANGUAGE_CODE2, LANG_PROF_TYPE2 LANG_PROF_TYPE2, LANG_PROF_LEVEL2 LANG_PROF_LEVEL2, LANGUAGE_CODE3 LANGUAGE_CODE3, LANG_PROF_TYPE3 LANG_PROF_TYPE3, LANG_PROF_LEVEL3 LANG_PROF_LEVEL3, LANGUAGE_CODE4 LANGUAGE_CODE4, LANG_PROF_TYPE4 LANG_PROF_TYPE4, LANG_PROF_LEVEL4 LANG_PROF_LEVEL4, LANGUAGE_CODE5 LANGUAGE_CODE5, LANG_PROF_TYPE5 LANG_PROF_TYPE5, LANG_PROF_LEVEL5 LANG_PROF_LEVEL5, LANGUAGE_CODE6 LANGUAGE_CODE6, LANG_PROF_TYPE6 LANG_PROF_TYPE6, LANG_PROF_LEVEL6 LANG_PROF_LEVEL6, LANGUAGE_CODE7 LANGUAGE_CODE7, LANG_PROF_TYPE7 LANG_PROF_TYPE7, LANG_PROF_LEVEL7 LANG_PROF_LEVEL7, LANGUAGE_CODE8 LANGUAGE_CODE8, LANG_PROF_TYPE8 LANG_PROF_TYPE8, LANG_PROF_LEVEL8 LANG_PROF_LEVEL8, APPOINTMENT_NTE_DATE APPOINTMENT_NTE_DATE, NOA_CORRECTED NOA_CORRECTED, PRIOR_FAMILY_NAME PRIOR_FAMILY_NAME, EFFECTIVE_DATE_CORRECTED EFFECTIVE_DATE_CORRECTED, PRIOR_GIVEN_NAME PRIOR_GIVEN_NAME, PRIOR_MIDDLE_NAME PRIOR_MIDDLE_NAME, PRIOR_NAME_SUFFIX PRIOR_NAME_SUFFIX, PRIOR_POSITION_TITLE PRIOR_POSITION_TITLE, SSN_CORRECTED SSN_CORRECTED, AGENCY_USE_CODE_FIELD AGENCY_USE_CODE_FIELD, PRIOR_POSITION_NUMBER PRIOR_POSITION_NUMBER, AGENCY_USE_TEXT_FIELD AGENCY_USE_TEXT_FIELD, PRIOR_POSITION_ORG PRIOR_POSITION_ORG, FROM_ADJ_BASIC_PAY FROM_ADJ_BASIC_PAY, POSITION_NUMBER POSITION_NUMBER, POSITION_ORG POSITION_ORG, AGENCY_DATA1 AGENCY_DATA1, AGENCY_DATA2 AGENCY_DATA2, AGENCY_DATA3 AGENCY_DATA3, AGENCY_DATA4 AGENCY_DATA4, AGENCY_DATA5 AGENCY_DATA5, ACTION_APPROVAL_DATE ACTION_APPROVAL_DATE, ACTION_AUTHR_FAMILY_NAME ACTION_AUTHR_FAMILY_NAME, ACTION_AUTHR_GIVEN_NAME ACTION_AUTHR_GIVEN_NAME, ACTION_AUTHR_MIDDLE_NAME ACTION_AUTHR_MIDDLE_NAME, ACTION_AUTHR_NAME_SUFFIX ACTION_AUTHR_NAME_SUFFIX, ACTION_AUTHR_TITLE ACTION_AUTHR_TITLE, REMARKS_TEXT REMARKS_TEXT, TSP_EMP_AMOUNT TSP_EMP_AMOUNT, WORK_STATE_CODE WORK_STATE_CODE, WORLD_CITIZENSHIP WORLD_CITIZENSHIP, MIL_SVC_END_DATE MIL_SVC_END_DATE, FROM_SPL_RATE_SUPPLEMENT FROM_SPL_RATE_SUPPLEMENT, TO_SPL_RATE_SUPPLEMENT TO_SPL_RATE_SUPPLEMENT, RACE_ETHNIC_INFO RACE_ETHNIC_INFO, FEHB_ELECT_EFF_DATE FEHB_ELECT_EFF_DATE, SPECIAL_POPULATION_CODE SPECIAL_POPULATION_CODE, CSRS_EXC_APPTS CSRS_EXC_APPTS, FERS_EXC_APPTS FERS_EXC_APPTS, FICA_COVERAGE_IND1 FICA_COVERAGE_IND1, FICA_COVERAGE_IND2 FICA_COVERAGE_IND2, PAREQ_LAST_UPDATED_DATE PAREQ_LAST_UPDATED_DATE, HYP_FULL_REG_DUTY_PART_EMP HYP_FULL_REG_DUTY_PART_EMP, FEGLI_ASSG_INDICATOR FEGLI_ASSG_INDICATOR, FEGLI_POST_ELC_BASIC_INS_AMT FEGLI_POST_ELC_BASIC_INS_AMT, FEGLI_COURT_ORD_IND FEGLI_COURT_ORD_IND, FEGLI_BENF_DESG_IND FEGLI_BENF_DESG_IND, NOAC_ORDER_OF_PROCESSING NOAC_ORDER_OF_PROCESSING, TELEWORK_INDICATOR TELEWORK_INDICATOR from "HR"."GHR_CPDF_TEMP"

View Text - HTML Formatted

SELECT REPORT_TYPE REPORT_TYPE
, SESSION_ID SESSION_ID
, ACADEMIC_DISCIPLINE ACADEMIC_DISCIPLINE
, AGENCY_CODE AGENCY_CODE
, ANNUITANT_INDICATOR ANNUITANT_INDICATOR
, AWARD_AMOUNT AWARD_AMOUNT
, BARGAINING_UNIT_STATUS BARGAINING_UNIT_STATUS
, BENEFIT_AMOUNT BENEFIT_AMOUNT
, CITIZENSHIP CITIZENSHIP
, CREDITABLE_MILITARY_SERVICE CREDITABLE_MILITARY_SERVICE
, CURRENT_APPOINTMENT_AUTH1 CURRENT_APPOINTMENT_AUTH1
, CURRENT_APPOINTMENT_AUTH2 CURRENT_APPOINTMENT_AUTH2
, EDUCATION_LEVEL EDUCATION_LEVEL
, EFFECTIVE_DATE EFFECTIVE_DATE
, 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
, FEGLI FEGLI
, FERS_COVERAGE FERS_COVERAGE
, FIRST_ACTION_LA_CODE1 FIRST_ACTION_LA_CODE1
, FIRST_ACTION_LA_CODE2 FIRST_ACTION_LA_CODE2
, FIRST_NOA_CODE FIRST_NOA_CODE
, FLSA_CATEGORY FLSA_CATEGORY
, FROM_BASIC_PAY FROM_BASIC_PAY
, FROM_DUTY_STATION_CODE FROM_DUTY_STATION_CODE
, FROM_GRADE_OR_LEVEL FROM_GRADE_OR_LEVEL
, FROM_LOCALITY_ADJ FROM_LOCALITY_ADJ
, FROM_NATIONAL_IDENTIFIER FROM_NATIONAL_IDENTIFIER
, FROM_OCC_CODE FROM_OCC_CODE
, FROM_PAY_BASIS FROM_PAY_BASIS
, FROM_PAY_PLAN FROM_PAY_PLAN
, FROM_PAY_RATE_DETERMINANT FROM_PAY_RATE_DETERMINANT
, FROM_PAY_TABLE_ID FROM_PAY_TABLE_ID
, FROM_RETIREMENT_COVERAGE FROM_RETIREMENT_COVERAGE
, FROM_STEP_OR_RATE FROM_STEP_OR_RATE
, FROM_TOTAL_SALARY FROM_TOTAL_SALARY
, FROM_WORK_SCHEDULE FROM_WORK_SCHEDULE
, FROZEN_SERVICE FROZEN_SERVICE
, FUNCTIONAL_CLASS FUNCTIONAL_CLASS
, HANDICAP_CODE HANDICAP_CODE
, HEALTH_PLAN HEALTH_PLAN
, INDIVIDUAL_GROUP_AWARD INDIVIDUAL_GROUP_AWARD
, ORGANIZATIONAL_COMPONENT ORGANIZATIONAL_COMPONENT
, PAY_STATUS PAY_STATUS
, PERSONNEL_OFFICE_ID PERSONNEL_OFFICE_ID
, POSITION_OCCUPIED POSITION_OCCUPIED
, RACE_NATIONAL_ORIGIN RACE_NATIONAL_ORIGIN
, RATING_OF_RECORD RATING_OF_RECORD
, RATING_OF_RECORD_LEVEL RATING_OF_RECORD_LEVEL
, RATING_OF_RECORD_PATTERN RATING_OF_RECORD_PATTERN
, RATING_OF_RECORD_PERIOD_ENDS RATING_OF_RECORD_PERIOD_ENDS
, RETAINED_STEP_OR_RATE RETAINED_STEP_OR_RATE
, RETAINED_GRADE_OR_LEVEL RETAINED_GRADE_OR_LEVEL
, RETAINED_PAY_PLAN RETAINED_PAY_PLAN
, RETIREMENT_PLAN RETIREMENT_PLAN
, SECOND_NOA_CODE SECOND_NOA_CODE
, SERVICE_COMP_DATE SERVICE_COMP_DATE
, SEX SEX
, SUPERVISORY_STATUS SUPERVISORY_STATUS
, TENURE TENURE
, TO_BASIC_PAY TO_BASIC_PAY
, TO_DUTY_STATION_CODE TO_DUTY_STATION_CODE
, TO_GRADE_OR_LEVEL TO_GRADE_OR_LEVEL
, TO_LOCALITY_ADJ TO_LOCALITY_ADJ
, TO_NATIONAL_IDENTIFIER TO_NATIONAL_IDENTIFIER
, TO_OCC_CODE TO_OCC_CODE
, TO_PAY_BASIS TO_PAY_BASIS
, TO_PAY_PLAN TO_PAY_PLAN
, TO_PAY_RATE_DETERMINANT TO_PAY_RATE_DETERMINANT
, TO_PAY_TABLE_ID TO_PAY_TABLE_ID
, TO_RETENTION_ALLOWANCE TO_RETENTION_ALLOWANCE
, TO_STAFFING_DIFFERENTIAL TO_STAFFING_DIFFERENTIAL
, TO_STEP_OR_RATE TO_STEP_OR_RATE
, TO_SUPERVISORY_DIFFERENTIAL TO_SUPERVISORY_DIFFERENTIAL
, TO_TOTAL_SALARY TO_TOTAL_SALARY
, TO_WORK_SCHEDULE TO_WORK_SCHEDULE
, VETERANS_PREFERENCE VETERANS_PREFERENCE
, VETERANS_STATUS VETERANS_STATUS
, YEAR_DEGREE_ATTAINED YEAR_DEGREE_ATTAINED
, 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
, NAME_TITLE NAME_TITLE
, POSITION_TITLE POSITION_TITLE
, AWARD_DOLLARS AWARD_DOLLARS
, AWARD_HOURS AWARD_HOURS
, AWARD_PERCENTAGE AWARD_PERCENTAGE
, SCD_RIF SCD_RIF
, SCD_RETIREMENT SCD_RETIREMENT
, VETERANS_PREF_FOR_RIF VETERANS_PREF_FOR_RIF
, LANG_WRITE_PROF LANG_WRITE_PROF
, IPA_BEN_NOTIFICATION IPA_BEN_NOTIFICATION
, EHRI_EMPLOYEE_ID EHRI_EMPLOYEE_ID
, SLCT_SERV_REGI_INDICATOR SLCT_SERV_REGI_INDICATOR
, CAREER_TENURE_CODE CAREER_TENURE_CODE
, SCD_SES SCD_SES
, SCD_SPCL_RETIRE SCD_SPCL_RETIRE
, FERS_ELECT_DATE FERS_ELECT_DATE
, FERS_ELECT_INDICATOR FERS_ELECT_INDICATOR
, DISABILITY_RETIRE_NOTIFY DISABILITY_RETIRE_NOTIFY
, ACT_SVC_INDICATOR ACT_SVC_INDICATOR
, MIL_CHAR_SVC_CODE MIL_CHAR_SVC_CODE
, MIL_SVC_SNO MIL_SVC_SNO
, MIL_SVC_START_DATE MIL_SVC_START_DATE
, MIL_BRANCH_CODE MIL_BRANCH_CODE
, MIL_DISCHARGE_CODE MIL_DISCHARGE_CODE
, ALB_INDICATOR ALB_INDICATOR
, ALB_ELECT_DATE ALB_ELECT_DATE
, ALB_NOTIFY_DATE ALB_NOTIFY_DATE
, FEGLI_INDICATOR FEGLI_INDICATOR
, FEGLI_ELECT_DATE FEGLI_ELECT_DATE
, FEGLI_NOTIFY_DATE FEGLI_NOTIFY_DATE
, FEHB_INDICATOR FEHB_INDICATOR
, FEHB_ELECT_DATE FEHB_ELECT_DATE
, FEHB_NOTIFY_DATE FEHB_NOTIFY_DATE
, RETIRE_INDICATOR RETIRE_INDICATOR
, RETIRE_ELECT_DATE RETIRE_ELECT_DATE
, RETIRE_NOTIFY_DATE RETIRE_NOTIFY_DATE
, CONT_ELECT_DATE CONT_ELECT_DATE
, CONT_NOTIFY_DATE CONT_NOTIFY_DATE
, CONT_TERM_ELECT_DATE CONT_TERM_ELECT_DATE
, CONT_INS_PAY_NOTIFY_DATE CONT_INS_PAY_NOTIFY_DATE
, CONT_PAY_TYPE_CODE CONT_PAY_TYPE_CODE
, COMP_POS_INDICATOR COMP_POS_INDICATOR
, AGENCY_EMPLOYEE_ID AGENCY_EMPLOYEE_ID
, SVC_OBLIG_TYPE_CODE1 SVC_OBLIG_TYPE_CODE1
, SVC_OBLIG_TYPE_START_DATE1 SVC_OBLIG_TYPE_START_DATE1
, SVC_OBLIG_TYPE_END_DATE1 SVC_OBLIG_TYPE_END_DATE1
, SVC_OBLIG_TYPE_CODE2 SVC_OBLIG_TYPE_CODE2
, SVC_OBLIG_TYPE_START_DATE2 SVC_OBLIG_TYPE_START_DATE2
, SVC_OBLIG_TYPE_END_DATE2 SVC_OBLIG_TYPE_END_DATE2
, SVC_OBLIG_TYPE_CODE3 SVC_OBLIG_TYPE_CODE3
, SVC_OBLIG_TYPE_START_DATE3 SVC_OBLIG_TYPE_START_DATE3
, SVC_OBLIG_TYPE_END_DATE3 SVC_OBLIG_TYPE_END_DATE3
, SVC_OBLIG_TYPE_CODE4 SVC_OBLIG_TYPE_CODE4
, SVC_OBLIG_TYPE_START_DATE4 SVC_OBLIG_TYPE_START_DATE4
, SVC_OBLIG_TYPE_END_DATE4 SVC_OBLIG_TYPE_END_DATE4
, INST_PROGRAM_CODE INST_PROGRAM_CODE
, APPOINT_TYPE_CODE APPOINT_TYPE_CODE
, PART_TIME_HOURS PART_TIME_HOURS
, SPCL_SALARY_RATE SPCL_SALARY_RATE
, TO_ADJ_BASIC_PAY TO_ADJ_BASIC_PAY
, SPCL_PAY_TBL_TYPE SPCL_PAY_TBL_TYPE
, APPROPRIATION_CODE APPROPRIATION_CODE
, RATING_OF_RECORD_PERIOD_STARTS RATING_OF_RECORD_PERIOD_STARTS
, FEGLI_LIFE_CHANGE_CODE FEGLI_LIFE_CHANGE_CODE
, FEGLI_LIFE_EVENT_DATE FEGLI_LIFE_EVENT_DATE
, FEGLI_ELECT_EFFECTIVE_DATE FEGLI_ELECT_EFFECTIVE_DATE
, FEHB_PLAN_CODE FEHB_PLAN_CODE
, FEHB_EVENT_CODE FEHB_EVENT_CODE
, TSP_ELIGIBILITY_DATE TSP_ELIGIBILITY_DATE
, TSP_EFFECTIVE_DATE TSP_EFFECTIVE_DATE
, TSP_ELECT_CONTRIB_PCT TSP_ELECT_CONTRIB_PCT
, LEAVE_SCD LEAVE_SCD
, TSP_SCD TSP_SCD
, WORK_ADDRESS_LINE1 WORK_ADDRESS_LINE1
, WORK_ADDRESS_LINE2 WORK_ADDRESS_LINE2
, WORK_ADDRESS_LINE3 WORK_ADDRESS_LINE3
, WORK_ADDRESS_LINE4 WORK_ADDRESS_LINE4
, WORK_CITY WORK_CITY
, WORK_POSTAL_CODE WORK_POSTAL_CODE
, WORK_REGION WORK_REGION
, WORK_COUNTRY_CODE WORK_COUNTRY_CODE
, WORK_EMPLOYEE_EMAIL WORK_EMPLOYEE_EMAIL
, WORK_PHONE_NUMBER WORK_PHONE_NUMBER
, HOME_PHONE_NUMBER HOME_PHONE_NUMBER
, CELL_PHONE_NUMBER CELL_PHONE_NUMBER
, EMRGNCY_CNTCT_FAMILY_NAME1 EMRGNCY_CNTCT_FAMILY_NAME1
, EMRGNCY_CNTCT_GIVEN_NAME1 EMRGNCY_CNTCT_GIVEN_NAME1
, EMRGNCY_CNTCT_MIDDLE_NAME1 EMRGNCY_CNTCT_MIDDLE_NAME1
, EMRGNCY_CNTCT_SUFFIX1 EMRGNCY_CNTCT_SUFFIX1
, EMRGNCY_CNTCT_INFRM_UPD_DT1 EMRGNCY_CNTCT_INFRM_UPD_DT1
, EMRGNCY_CNTCT_PHONE1 EMRGNCY_CNTCT_PHONE1
, EMRGNCY_CNTCT_FAMILY_NAME2 EMRGNCY_CNTCT_FAMILY_NAME2
, EMRGNCY_CNTCT_GIVEN_NAME2 EMRGNCY_CNTCT_GIVEN_NAME2
, EMRGNCY_CNTCT_MIDDLE_NAME2 EMRGNCY_CNTCT_MIDDLE_NAME2
, EMRGNCY_CNTCT_SUFFIX2 EMRGNCY_CNTCT_SUFFIX2
, EMRGNCY_CNTCT_INFRM_UPD_DT2 EMRGNCY_CNTCT_INFRM_UPD_DT2
, EMRGNCY_CNTCT_PHONE2 EMRGNCY_CNTCT_PHONE2
, LANGUAGE_CODE1 LANGUAGE_CODE1
, LANG_PROF_TYPE1 LANG_PROF_TYPE1
, LANG_PROF_LEVEL1 LANG_PROF_LEVEL1
, LANGUAGE_CODE2 LANGUAGE_CODE2
, LANG_PROF_TYPE2 LANG_PROF_TYPE2
, LANG_PROF_LEVEL2 LANG_PROF_LEVEL2
, LANGUAGE_CODE3 LANGUAGE_CODE3
, LANG_PROF_TYPE3 LANG_PROF_TYPE3
, LANG_PROF_LEVEL3 LANG_PROF_LEVEL3
, LANGUAGE_CODE4 LANGUAGE_CODE4
, LANG_PROF_TYPE4 LANG_PROF_TYPE4
, LANG_PROF_LEVEL4 LANG_PROF_LEVEL4
, LANGUAGE_CODE5 LANGUAGE_CODE5
, LANG_PROF_TYPE5 LANG_PROF_TYPE5
, LANG_PROF_LEVEL5 LANG_PROF_LEVEL5
, LANGUAGE_CODE6 LANGUAGE_CODE6
, LANG_PROF_TYPE6 LANG_PROF_TYPE6
, LANG_PROF_LEVEL6 LANG_PROF_LEVEL6
, LANGUAGE_CODE7 LANGUAGE_CODE7
, LANG_PROF_TYPE7 LANG_PROF_TYPE7
, LANG_PROF_LEVEL7 LANG_PROF_LEVEL7
, LANGUAGE_CODE8 LANGUAGE_CODE8
, LANG_PROF_TYPE8 LANG_PROF_TYPE8
, LANG_PROF_LEVEL8 LANG_PROF_LEVEL8
, APPOINTMENT_NTE_DATE APPOINTMENT_NTE_DATE
, NOA_CORRECTED NOA_CORRECTED
, PRIOR_FAMILY_NAME PRIOR_FAMILY_NAME
, EFFECTIVE_DATE_CORRECTED EFFECTIVE_DATE_CORRECTED
, PRIOR_GIVEN_NAME PRIOR_GIVEN_NAME
, PRIOR_MIDDLE_NAME PRIOR_MIDDLE_NAME
, PRIOR_NAME_SUFFIX PRIOR_NAME_SUFFIX
, PRIOR_POSITION_TITLE PRIOR_POSITION_TITLE
, SSN_CORRECTED SSN_CORRECTED
, AGENCY_USE_CODE_FIELD AGENCY_USE_CODE_FIELD
, PRIOR_POSITION_NUMBER PRIOR_POSITION_NUMBER
, AGENCY_USE_TEXT_FIELD AGENCY_USE_TEXT_FIELD
, PRIOR_POSITION_ORG PRIOR_POSITION_ORG
, FROM_ADJ_BASIC_PAY FROM_ADJ_BASIC_PAY
, POSITION_NUMBER POSITION_NUMBER
, POSITION_ORG POSITION_ORG
, AGENCY_DATA1 AGENCY_DATA1
, AGENCY_DATA2 AGENCY_DATA2
, AGENCY_DATA3 AGENCY_DATA3
, AGENCY_DATA4 AGENCY_DATA4
, AGENCY_DATA5 AGENCY_DATA5
, ACTION_APPROVAL_DATE ACTION_APPROVAL_DATE
, ACTION_AUTHR_FAMILY_NAME ACTION_AUTHR_FAMILY_NAME
, ACTION_AUTHR_GIVEN_NAME ACTION_AUTHR_GIVEN_NAME
, ACTION_AUTHR_MIDDLE_NAME ACTION_AUTHR_MIDDLE_NAME
, ACTION_AUTHR_NAME_SUFFIX ACTION_AUTHR_NAME_SUFFIX
, ACTION_AUTHR_TITLE ACTION_AUTHR_TITLE
, REMARKS_TEXT REMARKS_TEXT
, TSP_EMP_AMOUNT TSP_EMP_AMOUNT
, WORK_STATE_CODE WORK_STATE_CODE
, WORLD_CITIZENSHIP WORLD_CITIZENSHIP
, MIL_SVC_END_DATE MIL_SVC_END_DATE
, FROM_SPL_RATE_SUPPLEMENT FROM_SPL_RATE_SUPPLEMENT
, TO_SPL_RATE_SUPPLEMENT TO_SPL_RATE_SUPPLEMENT
, RACE_ETHNIC_INFO RACE_ETHNIC_INFO
, FEHB_ELECT_EFF_DATE FEHB_ELECT_EFF_DATE
, SPECIAL_POPULATION_CODE SPECIAL_POPULATION_CODE
, CSRS_EXC_APPTS CSRS_EXC_APPTS
, FERS_EXC_APPTS FERS_EXC_APPTS
, FICA_COVERAGE_IND1 FICA_COVERAGE_IND1
, FICA_COVERAGE_IND2 FICA_COVERAGE_IND2
, PAREQ_LAST_UPDATED_DATE PAREQ_LAST_UPDATED_DATE
, HYP_FULL_REG_DUTY_PART_EMP HYP_FULL_REG_DUTY_PART_EMP
, FEGLI_ASSG_INDICATOR FEGLI_ASSG_INDICATOR
, FEGLI_POST_ELC_BASIC_INS_AMT FEGLI_POST_ELC_BASIC_INS_AMT
, FEGLI_COURT_ORD_IND FEGLI_COURT_ORD_IND
, FEGLI_BENF_DESG_IND FEGLI_BENF_DESG_IND
, NOAC_ORDER_OF_PROCESSING NOAC_ORDER_OF_PROCESSING
, TELEWORK_INDICATOR TELEWORK_INDICATOR
FROM "HR"."GHR_CPDF_TEMP"