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