[Home] [Help]
[Dependency Information]
[Home] [Help]
[Dependency Information]
| Object Name: | GHR_CPDF_TEMP |
|---|---|
| Object Type: | TABLE |
| Owner: | HR |
| FND Design Data: |  GHR.GHR_CPDF_TEMP
|
| Subobject Name: | |
| Status: | VALID |
GHR_CPDF_TEMP temporarily stores information required to generate
various CPDF reports.
| Tablespace: |  APPS_TS_INTERFACE |
|---|---|
| PCT Free: | 10 |
| PCT Used: |
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| REPORT_TYPE | VARCHAR2 | (30) | Yes | Identifies the report to which the information relates. |
| SESSION_ID | NUMBER | (9) | Yes | Foreign key to FND_SESSIONS. |
| ACADEMIC_DISCIPLINE | VARCHAR2 | (30) | Academic discipline. | |
| AGENCY_CODE | VARCHAR2 | (30) | Agency code. | |
| ANNUITANT_INDICATOR | VARCHAR2 | (30) | Annuitant indicator. | |
| AWARD_AMOUNT | NUMBER | (15) | Award amount. | |
| BARGAINING_UNIT_STATUS | VARCHAR2 | (30) | Bargaining unit status. | |
| BENEFIT_AMOUNT | NUMBER | (15) | Benefit amount. | |
| CITIZENSHIP | VARCHAR2 | (30) | Citizenship. | |
| CREDITABLE_MILITARY_SERVICE | VARCHAR2 | (30) | Creditable military service. | |
| CURRENT_APPOINTMENT_AUTH1 | VARCHAR2 | (30) | Current appointment authority 1. | |
| CURRENT_APPOINTMENT_AUTH2 | VARCHAR2 | (30) | Current appointment authority 2. | |
| EDUCATION_LEVEL | VARCHAR2 | (30) | Education level. | |
| EFFECTIVE_DATE | DATE | Effective date for request for personnel action. | ||
| EMPLOYEE_DATE_OF_BIRTH | DATE | Employee?s date of birth. | ||
| EMPLOYEE_FIRST_NAME | VARCHAR2 | (150) | Employee?s first name. | |
| EMPLOYEE_LAST_NAME | VARCHAR2 | (150) | Employee?s last name. | |
| EMPLOYEE_MIDDLE_NAMES | VARCHAR2 | (60) | Employee?s middle names. | |
| FEGLI | VARCHAR2 | (30) | Federal employee?s group life insurance. | |
| FERS_COVERAGE | VARCHAR2 | (30) | Federal employee?s retirement system coverage. | |
| FIRST_ACTION_LA_CODE1 | VARCHAR2 | (30) | First action legal authority code 1. | |
| FIRST_ACTION_LA_CODE2 | VARCHAR2 | (30) | First action legal authority code 2. | |
| FIRST_NOA_CODE | VARCHAR2 | (4) | First nature of action code. | |
| FLSA_CATEGORY | VARCHAR2 | (30) | Fair labor standards act. | |
| FROM_BASIC_PAY | NUMBER | (15) | From basic pay. | |
| FROM_DUTY_STATION_CODE | VARCHAR2 | (9) | From duty station code. | |
| FROM_GRADE_OR_LEVEL | VARCHAR2 | (30) | From grade or level. | |
| FROM_LOCALITY_ADJ | NUMBER | (15) | From locality adjustment. | |
| FROM_NATIONAL_IDENTIFIER | VARCHAR2 | (30) | From national identifier. | |
| FROM_OCC_CODE | VARCHAR2 | (150) | From occupational code. | |
| FROM_PAY_BASIS | VARCHAR2 | (30) | From pay basis. | |
| FROM_PAY_PLAN | VARCHAR2 | (2) | From pay plan. | |
| FROM_PAY_RATE_DETERMINANT | VARCHAR2 | (30) | From pay rate determinant. | |
| FROM_PAY_TABLE_ID | VARCHAR2 | (30) | From pay table id. | |
| FROM_RETIREMENT_COVERAGE | VARCHAR2 | (30) | From retirement coverage. | |
| FROM_STEP_OR_RATE | VARCHAR2 | (30) | From step or rate. | |
| FROM_TOTAL_SALARY | NUMBER | (15) | From total salary. | |
| FROM_WORK_SCHEDULE | VARCHAR2 | (30) | From work schedule. | |
| FROZEN_SERVICE | VARCHAR2 | (30) | Frozen service. | |
| FUNCTIONAL_CLASS | VARCHAR2 | (30) | Functional class. | |
| HANDICAP_CODE | VARCHAR2 | (30) | Handicap code. | |
| HEALTH_PLAN | VARCHAR2 | (30) | Health plan. | |
| INDIVIDUAL_GROUP_AWARD | NUMBER | (15) | Individual group award. | |
| ORGANIZATIONAL_COMPONENT | VARCHAR2 | (30) | Organizational component. | |
| PAY_STATUS | VARCHAR2 | (30) | Pay status. | |
| PERSONNEL_OFFICE_ID | VARCHAR2 | (4) | Personnel office id. | |
| POSITION_OCCUPIED | VARCHAR2 | (30) | Position occupied. | |
| RACE_NATIONAL_ORIGIN | VARCHAR2 | (30) | Race or national origin. | |
| RATING_OF_RECORD | VARCHAR2 | (30) | Rating of record. | |
| RATING_OF_RECORD_LEVEL | VARCHAR2 | (30) | Rating of record level. | |
| RATING_OF_RECORD_PATTERN | VARCHAR2 | (30) | Rating of record pattern. | |
| RATING_OF_RECORD_PERIOD_ENDS | DATE | Date rating of record period ends. | ||
| RETAINED_STEP_OR_RATE | VARCHAR2 | (30) | Retained step or rate. | |
| RETAINED_GRADE_OR_LEVEL | VARCHAR2 | (30) | Retained grade or level. | |
| RETAINED_PAY_PLAN | VARCHAR2 | (2) | Retained pay plan. | |
| RETIREMENT_PLAN | VARCHAR2 | (30) | Retirement plan. | |
| SECOND_NOA_CODE | VARCHAR2 | (30) | Second nature of action code. | |
| SERVICE_COMP_DATE | DATE | Service computation date. | ||
| SEX | VARCHAR2 | (30) | Sex. | |
| SUPERVISORY_STATUS | VARCHAR2 | (30) | Supervisory status. | |
| TENURE | VARCHAR2 | (30) | Tenure. | |
| TO_BASIC_PAY | NUMBER | (15) | To basic pay. | |
| TO_DUTY_STATION_CODE | VARCHAR2 | (9) | To duty station code. | |
| TO_GRADE_OR_LEVEL | VARCHAR2 | (30) | To grade or level. | |
| TO_LOCALITY_ADJ | NUMBER | (15) | To locality adjustment. | |
| TO_NATIONAL_IDENTIFIER | VARCHAR2 | (30) | To national identifier. | |
| TO_OCC_CODE | VARCHAR2 | (30) | To occupational code. | |
| TO_PAY_BASIS | VARCHAR2 | (30) | To pay basis. | |
| TO_PAY_PLAN | VARCHAR2 | (2) | To pay plan. | |
| TO_PAY_RATE_DETERMINANT | VARCHAR2 | (30) | To pay rate determinant. | |
| TO_PAY_TABLE_ID | VARCHAR2 | (30) | To pay table id. | |
| TO_RETENTION_ALLOWANCE | NUMBER | (15) | To retention allowance. | |
| TO_STAFFING_DIFFERENTIAL | NUMBER | (15) | To staffing differential. | |
| TO_STEP_OR_RATE | VARCHAR2 | (30) | To step or rate. | |
| TO_SUPERVISORY_DIFFERENTIAL | NUMBER | (15) | To supervisory differential. | |
| TO_TOTAL_SALARY | NUMBER | (15) | To total salary. | |
| TO_WORK_SCHEDULE | VARCHAR2 | (30) | To work schedule. | |
| VETERANS_PREFERENCE | VARCHAR2 | (30) | Veteran?s preference. | |
| VETERANS_STATUS | VARCHAR2 | (30) | Veteran?s status. | |
| YEAR_DEGREE_ATTAINED | NUMBER | (4) | Year degree attained. | |
| CREATED_BY | NUMBER | (15) | Yes | Standard who column. |
| CREATION_DATE | DATE | Yes | Standard who column. | |
| LAST_UPDATED_BY | NUMBER | (15) | Yes | Standard who column. |
| LAST_UPDATE_DATE | DATE | Yes | Standard who column. | |
| LAST_UPDATE_LOGIN | NUMBER | (15) | Standard who column. | |
| NAME_TITLE | VARCHAR2 | (30) | Employee Name Title | |
| POSITION_TITLE | VARCHAR2 | (240) | Position Title | |
| AWARD_DOLLARS | NUMBER | (15) | Award Dollars | |
| AWARD_HOURS | NUMBER | (7) | Award Hours | |
| AWARD_PERCENTAGE | NUMBER | (5) | Award Percentage | |
| SCD_RIF | DATE | SCD RIF Date | ||
| SCD_RETIREMENT | DATE | SCD Retirement Date | ||
| VETERANS_PREF_FOR_RIF | VARCHAR2 | (30) | Veterans Preference for RIF | |
| LANG_WRITE_PROF | VARCHAR2 | (4) | Language Writing Proficiency | |
| IPA_BEN_NOTIFICATION | VARCHAR2 | (255) | IPA Ben. Notification | |
| EHRI_EMPLOYEE_ID | NUMBER | (20) | EHRI Employee ID | |
| SLCT_SERV_REGI_INDICATOR | VARCHAR2 | (4) | Selective Service Registration Indicator | |
| CAREER_TENURE_CODE | VARCHAR2 | (3) | Career Tenure Authority Code | |
| SCD_SES | DATE | SCD SES | ||
| SCD_SPCL_RETIRE | DATE | SCD Special Retirement | ||
| FERS_ELECT_DATE | DATE | FERS Election Date | ||
| FERS_ELECT_INDICATOR | VARCHAR2 | (4) | FERS Election Indicator | |
| DISABILITY_RETIRE_NOTIFY | DATE | Disability Retirement Notification Date | ||
| ACT_SVC_INDICATOR | VARCHAR2 | (4) | Active Uniformed Service Indicator | |
| MIL_CHAR_SVC_CODE | VARCHAR2 | (4) | Military Character Service Code | |
| MIL_SVC_SNO | VARCHAR2 | (35) | Military Service Serial Number | |
| MIL_SVC_START_DATE | DATE | Military Branch Service Start Date | ||
| MIL_BRANCH_CODE | VARCHAR2 | (4) | Military Branch Type Code | |
| MIL_DISCHARGE_CODE | VARCHAR2 | (4) | Military Discharge Type Code | |
| ALB_INDICATOR | VARCHAR2 | (4) | Annual Leave Balance Indicator | |
| ALB_ELECT_DATE | DATE | Annual Leave Balance Election Date | ||
| ALB_NOTIFY_DATE | DATE | Annual Leave Balance Elec. Notification Date | ||
| FEGLI_INDICATOR | VARCHAR2 | (4) | FEGLI Indicator | |
| FEGLI_ELECT_DATE | DATE | FEGLI Election Date | ||
| FEGLI_NOTIFY_DATE | DATE | FEGLI Election Notification Date | ||
| FEHB_INDICATOR | VARCHAR2 | (240) | FEHB Indicator | |
| FEHB_ELECT_DATE | DATE | FEHB Election Date | ||
| FEHB_NOTIFY_DATE | DATE | FEHB Election Notification Date | ||
| RETIRE_INDICATOR | VARCHAR2 | (4) | Retirement Indicator | |
| RETIRE_ELECT_DATE | DATE | Retirement Election Date | ||
| RETIRE_NOTIFY_DATE | DATE | Retirement Election Notification Date | ||
| CONT_ELECT_DATE | DATE | Continuation Election Date | ||
| CONT_NOTIFY_DATE | DATE | Continuation Election Notification Date | ||
| CONT_TERM_ELECT_DATE | DATE | Continuation Termination Insufficient Pay Election Date | ||
| CONT_INS_PAY_NOTIFY_DATE | DATE | Continuation Termination Insufficient Pay Notification Date | ||
| CONT_PAY_TYPE_CODE | VARCHAR2 | (4) | Continuation Termination Insufficient Pay Payment Type Code | |
| COMP_POS_INDICATOR | VARCHAR2 | (4) | Computer Position Indicator | |
| AGENCY_EMPLOYEE_ID | VARCHAR2 | (35) | Agency Employee ID | |
| SVC_OBLIG_TYPE_CODE1 | VARCHAR2 | (4) | Service Obligation Type Code 1 | |
| SVC_OBLIG_TYPE_START_DATE1 | DATE | Service Obligation Type Start Date 1 | ||
| SVC_OBLIG_TYPE_END_DATE1 | DATE | Service Obligation Type End Date1 | ||
| SVC_OBLIG_TYPE_CODE2 | VARCHAR2 | (4) | Service Obligation Type Code 2 | |
| SVC_OBLIG_TYPE_START_DATE2 | DATE | Service Obligation Type Start Date 2 | ||
| SVC_OBLIG_TYPE_END_DATE2 | DATE | Service Obligation Type End Date 2 | ||
| SVC_OBLIG_TYPE_CODE3 | VARCHAR2 | (4) | Service Obligation Type Code 3 | |
| SVC_OBLIG_TYPE_START_DATE3 | DATE | Service Obligation Type Start Date 3 | ||
| SVC_OBLIG_TYPE_END_DATE3 | DATE | Service Obligation Type End Date 3 | ||
| SVC_OBLIG_TYPE_CODE4 | VARCHAR2 | (4) | Service Obligation Type Code 4 | |
| SVC_OBLIG_TYPE_START_DATE4 | DATE | Service Obligation Type Start Date 4 | ||
| SVC_OBLIG_TYPE_END_DATE4 | DATE | Service Obligation Type End Date 4 | ||
| INST_PROGRAM_CODE | VARCHAR2 | (6) | Instructional Program Code | |
| APPOINT_TYPE_CODE | VARCHAR2 | (4) | Appointment Type Code | |
| PART_TIME_HOURS | NUMBER | (5) | Part Time Hours | |
| SPCL_SALARY_RATE | NUMBER | (9) | Special Salary Rate | |
| TO_ADJ_BASIC_PAY | NUMBER | (15) | Adjusted Basic Pay | |
| SPCL_PAY_TBL_TYPE | VARCHAR2 | (35) | Speical Pay Table Type Code | |
| APPROPRIATION_CODE | VARCHAR2 | (35) | Appropriation Code | |
| RATING_OF_RECORD_PERIOD_STARTS | DATE | Rating Record Period Start Date | ||
| FEGLI_LIFE_CHANGE_CODE | VARCHAR2 | (4) | FEGLI Life Change Code | |
| FEGLI_LIFE_EVENT_DATE | DATE | FEGLI Life Event Date | ||
| FEGLI_ELECT_EFFECTIVE_DATE | DATE | FEGLI Election Effective Date | ||
| FEHB_PLAN_CODE | VARCHAR2 | (10) | FEHB Plan Code | |
| FEHB_EVENT_CODE | VARCHAR2 | (4) | FEHB Event Code | |
| TSP_ELIGIBILITY_DATE | DATE | TSP Eligibility Date | ||
| TSP_EFFECTIVE_DATE | DATE | TSP Effective Date | ||
| TSP_ELECT_CONTRIB_PCT | NUMBER | (6) | TSP Election Contribution Percent | |
| LEAVE_SCD | DATE | Leave Service Computation Date | ||
| TSP_SCD | DATE | TSP Service Computation Date | ||
| WORK_ADDRESS_LINE1 | VARCHAR2 | (35) | Work Address Line 1 | |
| WORK_ADDRESS_LINE2 | VARCHAR2 | (35) | Work Address LIne 2 | |
| WORK_ADDRESS_LINE3 | VARCHAR2 | (35) | Work Address LIne 3 | |
| WORK_ADDRESS_LINE4 | VARCHAR2 | (35) | Work Address LIne 4 | |
| WORK_CITY | VARCHAR2 | (35) | Work City | |
| WORK_POSTAL_CODE | VARCHAR2 | (35) | Work Postal Code | |
| WORK_REGION | VARCHAR2 | (35) | Work Region | |
| WORK_COUNTRY_CODE | VARCHAR2 | (4) | Work Country Code | |
| WORK_EMPLOYEE_EMAIL | VARCHAR2 | (60) | Employee Work Email | |
| WORK_PHONE_NUMBER | VARCHAR2 | (35) | Work Phone Number | |
| HOME_PHONE_NUMBER | VARCHAR2 | (35) | Home Phone Number | |
| CELL_PHONE_NUMBER | VARCHAR2 | (35) | Cell Phone Number | |
| EMRGNCY_CNTCT_FAMILY_NAME1 | VARCHAR2 | (35) | Emergency Contact Family Name 1 | |
| EMRGNCY_CNTCT_GIVEN_NAME1 | VARCHAR2 | (35) | Emergency Contact Given Name 1 | |
| EMRGNCY_CNTCT_MIDDLE_NAME1 | VARCHAR2 | (35) | Emergency Contact Middle Name 1 | |
| EMRGNCY_CNTCT_SUFFIX1 | VARCHAR2 | (4) | Emergency Contact Suffix 1 | |
| EMRGNCY_CNTCT_INFRM_UPD_DT1 | DATE | Emergency Contact Information Update Date 1 | ||
| EMRGNCY_CNTCT_PHONE1 | VARCHAR2 | (35) | Emergency Contact Phone Number 1 | |
| EMRGNCY_CNTCT_FAMILY_NAME2 | VARCHAR2 | (35) | Emergency Contact Family Name 2 | |
| EMRGNCY_CNTCT_GIVEN_NAME2 | VARCHAR2 | (35) | Emergency Contact Given Name 2 | |
| EMRGNCY_CNTCT_MIDDLE_NAME2 | VARCHAR2 | (35) | Emergency Contact Middle Name 2 | |
| EMRGNCY_CNTCT_SUFFIX2 | VARCHAR2 | (4) | Emergency Contact Suffix 2 | |
| EMRGNCY_CNTCT_INFRM_UPD_DT2 | DATE | Emergency Contact Information Update Date 2 | ||
| EMRGNCY_CNTCT_PHONE2 | VARCHAR2 | (35) | Emergency Contact Phone Number 2 | |
| LANGUAGE_CODE1 | VARCHAR2 | (4) | Language Code 1 | |
| LANG_PROF_TYPE1 | VARCHAR2 | (4) | Lang Prof Type 1 | |
| LANG_PROF_LEVEL1 | VARCHAR2 | (4) | Lang Prof Level 1 | |
| LANGUAGE_CODE2 | VARCHAR2 | (4) | Language Code 2 | |
| LANG_PROF_TYPE2 | VARCHAR2 | (4) | Lang Prof Type 2 | |
| LANG_PROF_LEVEL2 | VARCHAR2 | (4) | Lang Prof Level 2 | |
| LANGUAGE_CODE3 | VARCHAR2 | (4) | Language Code 3 | |
| LANG_PROF_TYPE3 | VARCHAR2 | (4) | Lang Prof Type 3 | |
| LANG_PROF_LEVEL3 | VARCHAR2 | (4) | Lang Prof Level 3 | |
| LANGUAGE_CODE4 | VARCHAR2 | (4) | Language Code 4 | |
| LANG_PROF_TYPE4 | VARCHAR2 | (4) | Lang Prof Type 4 | |
| LANG_PROF_LEVEL4 | VARCHAR2 | (4) | Lang Prof Level 4 | |
| LANGUAGE_CODE5 | VARCHAR2 | (4) | Language Code 5 | |
| LANG_PROF_TYPE5 | VARCHAR2 | (4) | Lang Prof Type 5 | |
| LANG_PROF_LEVEL5 | VARCHAR2 | (4) | Lang Prof Level 5 | |
| LANGUAGE_CODE6 | VARCHAR2 | (4) | Language Code 6 | |
| LANG_PROF_TYPE6 | VARCHAR2 | (4) | Lang Prof Type 6 | |
| LANG_PROF_LEVEL6 | VARCHAR2 | (4) | Lang Prof Level 6 | |
| LANGUAGE_CODE7 | VARCHAR2 | (4) | Language Code 7 | |
| LANG_PROF_TYPE7 | VARCHAR2 | (4) | Lang Prof Type 7 | |
| LANG_PROF_LEVEL7 | VARCHAR2 | (4) | Lang Prof Level 7 | |
| LANGUAGE_CODE8 | VARCHAR2 | (4) | Language Code 8 | |
| LANG_PROF_TYPE8 | VARCHAR2 | (4) | Lang Prof Type 8 | |
| LANG_PROF_LEVEL8 | VARCHAR2 | (4) | Lang Prof Level8 | |
| APPOINTMENT_NTE_DATE | DATE | Appointment NTE Date | ||
| NOA_CORRECTED | VARCHAR2 | (4) | Nature of Action Being Corrected | |
| PRIOR_FAMILY_NAME | VARCHAR2 | (35) | Prior Family Name | |
| EFFECTIVE_DATE_CORRECTED | DATE | Effective Date of Personnel Action Being Corrected | ||
| PRIOR_GIVEN_NAME | VARCHAR2 | (35) | Prior Given Name | |
| PRIOR_MIDDLE_NAME | VARCHAR2 | (35) | Prior Middle Name | |
| PRIOR_NAME_SUFFIX | VARCHAR2 | (4) | Prior Name Suffix | |
| PRIOR_POSITION_TITLE | VARCHAR2 | (60) | Prior Position Title | |
| SSN_CORRECTED | VARCHAR2 | (35) | SSN Being Corrected | |
| AGENCY_USE_CODE_FIELD | VARCHAR2 | (10) | Agency Use Code Field | |
| PRIOR_POSITION_NUMBER | VARCHAR2 | (35) | Prior Position Number | |
| AGENCY_USE_TEXT_FIELD | VARCHAR2 | (35) | Agency Use Text Field | |
| PRIOR_POSITION_ORG | VARCHAR2 | (500) | Prior Position Org | |
| FROM_ADJ_BASIC_PAY | NUMBER | (15) | From Adjusted Basic Pay | |
| POSITION_NUMBER | VARCHAR2 | (35) | Position Number | |
| POSITION_ORG | VARCHAR2 | (500) | Position Org | |
| AGENCY_DATA1 | VARCHAR2 | (60) | Agency Data 1 | |
| AGENCY_DATA2 | VARCHAR2 | (60) | Agency Data 2 | |
| AGENCY_DATA3 | VARCHAR2 | (60) | Agency Data 3 | |
| AGENCY_DATA4 | VARCHAR2 | (60) | Agency Data 4 | |
| AGENCY_DATA5 | VARCHAR2 | (60) | Agency Data 5 | |
| ACTION_APPROVAL_DATE | DATE | Personnel Action Approval Date | ||
| ACTION_AUTHR_FAMILY_NAME | VARCHAR2 | (35) | Personnle Action Authroizer Family Name | |
| ACTION_AUTHR_GIVEN_NAME | VARCHAR2 | (35) | Personnle Action Authroizer Given Name | |
| ACTION_AUTHR_MIDDLE_NAME | VARCHAR2 | (35) | Personnle Action Authroizer Middle Name | |
| ACTION_AUTHR_NAME_SUFFIX | VARCHAR2 | (4) | Personnle Action Authroizer Name Suffix | |
| ACTION_AUTHR_TITLE | VARCHAR2 | (60) | Personnle Action Authroizer Title | |
| REMARKS_TEXT | VARCHAR2 | (2000) | Remarks Text | |
| TSP_EMP_AMOUNT | NUMBER | (6) | TSP Election Contribution Amount | |
| WORK_STATE_CODE | VARCHAR2 | (2) | Work State Code | |
| WORLD_CITIZENSHIP | VARCHAR2 | (2) | Country World Citizenship | |
| MIL_SVC_END_DATE | DATE | Date Retired Uniform Service | ||
| FROM_SPL_RATE_SUPPLEMENT | VARCHAR2 | (30) | From Special Rate Supplement | |
| TO_SPL_RATE_SUPPLEMENT | VARCHAR2 | (30) | To Special Rate Supplment | |
| RACE_ETHNIC_INFO | VARCHAR2 | (30) | Race Ethnic Category | |
| FEHB_ELECT_EFF_DATE | DATE | Federal Employees Health Benefits FEHB Election Effective Date | ||
| SPECIAL_POPULATION_CODE | VARCHAR2 | (6) | Special Population code | |
| CSRS_EXC_APPTS | VARCHAR2 | (2) | Appointment Excluded from CSRS Indicator | |
| FERS_EXC_APPTS | VARCHAR2 | (2) | Appointment Excluded from FERS Indicator | |
| FICA_COVERAGE_IND1 | VARCHAR2 | (2) | FICA Coverage Indicator 1 | |
| FICA_COVERAGE_IND2 | VARCHAR2 | (2) | FICA Coverage Indicator 2 | |
| PAREQ_LAST_UPDATED_DATE | DATE | PA Request Updated Date | ||
| HYP_FULL_REG_DUTY_PART_EMP | NUMBER | (9) | Hypothetical Full-time Regular Tour of Duty for Part-time Employees | |
| FEGLI_ASSG_INDICATOR | VARCHAR2 | (2) | FEGLI Assignment Indicator | |
| FEGLI_POST_ELC_BASIC_INS_AMT | NUMBER | (9) | FEGLI Post-Election Basic Insurance Amount | |
| FEGLI_COURT_ORD_IND | VARCHAR2 | (2) | Court Orders for FEGLI Purposes Indicator | |
| FEGLI_BENF_DESG_IND | VARCHAR2 | (2) | Designation of FEGLI Beneficiaries Indicator |
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
FROM HR.GHR_CPDF_TEMP;
HR.GHR_CPDF_TEMP does not reference any database object
HR.GHR_CPDF_TEMP is referenced by following:
APPS
GHR_CPDF_TEMP
GHR_CPDF_TEMP_WHO
PUBLIC
GHR_CPDF_TEMP
|
|
|
|