HGA_PG_EMP_DET

(SQL Table)
 Index Back

Employee Details Table

This is clone of EMPLOYEES Table with few additional fields used for Absence Analytics. This table is populated by Employee Refresh Information AE.

  • Related Language Record: HGA_PG_EMP_LNG

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
    2 EMPL_RCD Number(3,0) SMALLINT NOT NULL Empl Record
    3 BIRTHDATE Date(10) DATE Date of Birth
    4 BIRTHPLACE Character(30) VARCHAR2(30) NOT NULL Birth Location
    5 DT_OF_DEATH Date(10) DATE Date of Death
    6 COUNTRY_NM_FORMAT Character(3) VARCHAR2(3) NOT NULL Supported Name Format Types

    Default Value: OPR_DEF_TBL_HR.COUNTRY

    Prompt Table: NAME_FORMAT_TBL

    7 NAME Character(50) VARCHAR2(50) NOT NULL Name
    8 NAME_INITIALS Character(6) VARCHAR2(6) NOT NULL Name Initials
    9 NAME_PREFIX Character(4) VARCHAR2(4) NOT NULL Name Prefix

    Prompt Table: NAME_PREFIX_TBL

    10 NAME_SUFFIX Character(15) VARCHAR2(15) NOT NULL Name Suffix

    Prompt Table: NAME_SUFFIX_TBL

    11 NAME_ROYAL_PREFIX Character(15) VARCHAR2(15) NOT NULL Name Royal Prefix
    12 NAME_ROYAL_SUFFIX Character(15) VARCHAR2(15) NOT NULL Name - Royal Suffix
    13 NAME_TITLE Character(30) VARCHAR2(30) NOT NULL Name Title

    Prompt Table: TITLE_TBL

    14 LAST_NAME_SRCH Character(30) VARCHAR2(30) NOT NULL Last Name
    15 FIRST_NAME_SRCH Character(30) VARCHAR2(30) NOT NULL First Name
    16 LAST_NAME Character(30) VARCHAR2(30) NOT NULL Last Name
    17 FIRST_NAME Character(30) VARCHAR2(30) NOT NULL First Name
    18 MIDDLE_NAME Character(30) VARCHAR2(30) NOT NULL MIDDLE_NAME
    19 SECOND_LAST_SRCH Character(30) VARCHAR2(30) NOT NULL Second Last Name
    20 SECOND_LAST_NAME Character(30) VARCHAR2(30) NOT NULL Second Last Name
    21 NAME_AC Character(50) VARCHAR2(50) NOT NULL Alternate Character Name
    22 PREF_FIRST_NAME Character(30) VARCHAR2(30) NOT NULL Preferred First Name
    23 LAST_NAME_PREF_NLD Character(1) VARCHAR2(1) NOT NULL The field Last Name Preference is used in the Netherlands specific for people who are married to indicated their preference regarding the last name, which can be 4 choices based on the own last name and the partners last name.
    1=Own Name
    2=Name Partner
    3=Name Partner + Own Name
    4=Own Name + Name Partner

    Default Value: 1

    24 COUNTRY Character(3) VARCHAR2(3) NOT NULL Country
    25 ADDRESS1 Character(55) VARCHAR2(55) NOT NULL Address 1
    26 ADDRESS2 Character(55) VARCHAR2(55) NOT NULL Address 2
    27 ADDRESS3 Character(55) VARCHAR2(55) NOT NULL Address 3
    28 ADDRESS4 Character(55) VARCHAR2(55) NOT NULL Address 4
    29 CITY Character(30) VARCHAR2(30) NOT NULL City
    30 NUM1 Character(6) VARCHAR2(6) NOT NULL Number 1
    31 NUM2 Character(6) VARCHAR2(6) NOT NULL Number 2
    32 HOUSE_TYPE Character(2) VARCHAR2(2) NOT NULL House Type
    AB=House Boat Reference
    WW=House Trailer Reference
    33 ADDR_FIELD1 Character(2) VARCHAR2(2) NOT NULL Address Field 1
    34 ADDR_FIELD2 Character(4) VARCHAR2(4) NOT NULL Address Field 2
    35 ADDR_FIELD3 Character(4) VARCHAR2(4) NOT NULL Address Field 3
    36 COUNTY Character(30) VARCHAR2(30) NOT NULL County

    Prompt Table: COUNTRY_TBL

    37 STATE Character(6) VARCHAR2(6) NOT NULL State

    Prompt Table: STATE_TBL

    38 POSTAL Character(12) VARCHAR2(12) NOT NULL Postal
    39 GEO_CODE Character(11) VARCHAR2(11) NOT NULL Geo Code
    40 IN_CITY_LIMIT Character(1) VARCHAR2(1) NOT NULL In City Limit
    41 HOME_PHONE Character(24) VARCHAR2(24) NOT NULL Home Phone #
    42 NATIONAL_ID_TYPE Character(6) VARCHAR2(6) NOT NULL National ID Type

    Prompt Table: NID_TYPE1_VW

    43 NATIONAL_ID Character(20) VARCHAR2(20) NOT NULL National ID
    44 SEX Character(1) VARCHAR2(1) NOT NULL Gender
    F=Female
    M=Male
    U=Unknown
    45 MAR_STATUS Character(1) VARCHAR2(1) NOT NULL Marital Status
    C=Common-Law
    D=Divorced
    E=Separated
    H=Head of Household
    L=DissDeclLost Civil Partner
    M=Married
    P=Civil Partnership
    S=Single
    T=Surviving Civil Partner
    U=Unknown
    V=Dissolved Civil Partnership
    W=Widowed
    46 HIGHEST_EDUC_LVL Character(2) VARCHAR2(2) NOT NULL Highest Education Level
    47 FT_STUDENT Character(1) VARCHAR2(1) NOT NULL Full-Time Student
    48 MILITARY_STATUS Character(1) VARCHAR2(1) NOT NULL Veteran Status / Military Status
    49 US_WORK_ELIGIBILTY Character(1) VARCHAR2(1) NOT NULL Eligible to Work in U.S.
    N=No
    Y=Yes
    50 MILIT_SITUATN_FRA Character(3) VARCHAR2(3) NOT NULL Military Status
    APA=No Country Person
    BEN=Asile Right
    DEG=Military Service Done
    ETR=Alien
    REF=Reformed (don't do milit serv)
    SER=Military Service to Come
    SUR=Military Service Delayed
    51 DISABLED Character(1) VARCHAR2(1) NOT NULL A flag that indicates whether or not (Y or N) a dependent is a disabled.
    52 DISABLED_VET Character(1) VARCHAR2(1) NOT NULL Disabled Veteran
    53 ETHNIC_GROUP Character(1) VARCHAR2(1) NOT NULL Ethnic Group
    1=White
    2=Black/African American
    3=Hispanic/Latino
    4=Asian
    5=American Indian/Alaska Native
    6=Not Applicable
    7=Native Hawaiian/Oth Pac Island
    A=American Indian/Alaskan Native
    B=Asian or Pacific Islander
    C=Black, not of Hispanic origin
    D=Hispanic
    E=White, not of Hispanic origin
    F=Asian Indian
    G=Chinese
    H=Filipino
    J=Guamanian
    K=Hawaiian
    L=Japanese
    M=Korean
    N=Samoan
    P=Vietnamese
    Q=All Other Asian o Pacific Is
    Y=Not Hispanic in Puerto Rico
    54 TWO_RACES_IND_USA Character(1) VARCHAR2(1) NOT NULL USA Two or More (Non-Hispanic) Races Indicator

    Y/N Table Edit

    Default Value: N

    55 CITIZENSHIP_STATUS Character(1) VARCHAR2(1) NOT NULL Citizenship Status
    56 ORIG_HIRE_DT Date(10) DATE Original Start Date
    57 PER_ORG Character(3) VARCHAR2(3) NOT NULL Defines the Organizational Relationship(s) that a Person has to the Organization. These are Employee, Contingent Worker, and Persons of Interest.
    CWR=Contingent Worker
    EMP=Employee
    POI=Person of Interest
    58 BENEFIT_RCD_NBR Number(3,0) SMALLINT NOT NULL Specifies a sequence number associated with each of multiple concurrent jobs for a one employee. It is used to determine the applicable benefit program for each job. The first job entered for an employee is automatically assigned a Benefit Record Number of zero (0). This field is linked with EMPL_RCD#, the Employment Record Number.
    59 CMPNY_SENIORITY_DT Date(10) DATE Company Seniority Date
    60 SERVICE_DT Date(10) DATE Service Date
    61 HOME_HOST_CLASS Character(1) VARCHAR2(1) NOT NULL Home/Host Classification
    M=Home
    S=Host
    62 LAST_INCREASE_DT Date(10) DATE Date Last Increase
    63 OWN_5PERCENT_CO Character(1) VARCHAR2(1) NOT NULL A flag that indicates whether or not (Y or N) an employee owns 5% or more of the company. This value is used in nondiscrimination testing.
    64 BUSINESS_TITLE Character(30) VARCHAR2(30) NOT NULL Business Title
    65 PROBATION_DT Date(10) DATE Probation Date
    66 EFFDT Date(10) DATE NOT NULL Effective Date
    67 EFFSEQ Number(3,0) SMALLINT NOT NULL Effective Sequence
    68 HIRE_DT Date(10) DATE First Start Date
    69 EXPECTED_RETURN_DT Date(10) DATE Expected Return Date
    70 TERMINATION_DT Date(10) DATE Termination Date
    71 LAST_DATE_WORKED Date(10) DATE Last Date Worked
    72 REPORTS_TO Character(8) VARCHAR2(8) NOT NULL Reports To Position Number
    73 SUPERVISOR_ID Character(11) VARCHAR2(11) NOT NULL Supervisor ID

    Prompt Table: PERSON_NAME

    74 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit

    Prompt Table: BUS_UNIT_TBL_HR

    75 DEPTID Character(10) VARCHAR2(10) NOT NULL Department

    Prompt Table: SET_DEPT_VW

    76 JOBCODE Character(6) VARCHAR2(6) NOT NULL Job Code

    Prompt Table: SET_JOBCD_VW2

    77 POSITION_NBR Character(8) VARCHAR2(8) NOT NULL Position Number
    78 EMPL_STATUS Character(1) VARCHAR2(1) NOT NULL Payroll Status
    A=Active
    D=Deceased
    L=Leave of Absence
    P=Leave With Pay
    Q=Retired With Pay
    R=Retired
    S=Suspended
    T=Terminated
    U=Terminated With Pay
    V=Terminated Pension Pay Out
    W=Short Work Break
    X=Retired-Pension Administration
    79 ACTION Character(3) VARCHAR2(3) NOT NULL Action

    Prompt Table: ACTION_TBL

    80 ACTION_DT Date(10) DATE Action Date
    81 ACTION_REASON Character(3) VARCHAR2(3) NOT NULL Reason Code

    Prompt Table: ACTN_REASON_TBL

    82 LOCATION Character(10) VARCHAR2(10) NOT NULL Location Code

    Prompt Table: SET_LOC_VW

    83 JOB_ENTRY_DT Date(10) DATE Job Entry Date
    84 DEPT_ENTRY_DT Date(10) DATE Department Entry Date
    85 POSITION_ENTRY_DT Date(10) DATE Position Entry Date
    86 SHIFT Character(1) VARCHAR2(1) NOT NULL Regular Shift
    1=Day
    2=Evening
    3=Night
    A=Any
    C=Compressed
    N=Not Applicable
    R=Rotating
    87 REG_TEMP Character(1) VARCHAR2(1) NOT NULL Regular/Temporary
    R=Regular
    T=Temporary
    88 FULL_PART_TIME Character(1) VARCHAR2(1) NOT NULL Full/Part Time
    D=On Demand
    F=Full-Time
    P=Part-Time
    89 FLSA_STATUS Character(1) VARCHAR2(1) NOT NULL FLSA Status
    A=Administrative
    C=Computer Employee
    E=Executive
    H=Highly Compensated Employees
    M=Management
    N=Nonexempt
    O=Outside Salesperson
    P=Professional
    V=Nonexempt Alt Overtime
    X=No FLSA Required
    90 OFFICER_CD Character(1) VARCHAR2(1) NOT NULL Officer Code
    C=Chairman
    D=Director
    N=None
    O=Officer
    P=President
    S=Secretary
    T=Treasurer
    V=Vice President
    91 COMPANY Character(3) VARCHAR2(3) NOT NULL Company

    Prompt Table: COMPANY_TBL

    92 PAYGROUP Character(3) VARCHAR2(3) NOT NULL Pay Group
    93 EMPL_TYPE Character(1) VARCHAR2(1) NOT NULL Employee Type
    E=Exception Hourly
    H=Hourly
    N=Not Applicable
    S=Salaried
    94 HOLIDAY_SCHEDULE Character(6) VARCHAR2(6) NOT NULL Holiday Schedule

    Prompt Table: HOLIDAY_TBL

    95 STD_HOURS Number(7,2) DECIMAL(6,2) NOT NULL Standard Hours
    96 STD_HRS_FREQUENCY Character(5) VARCHAR2(5) NOT NULL Standard Work Period
    97 REG_REGION Character(5) VARCHAR2(5) NOT NULL Regulatory Region
    98 PAID_HOURS Number(7,2) DECIMAL(6,2) NOT NULL Paid Hours
    99 PAID_FTE Number(8,6) DECIMAL(7,6) NOT NULL This field is si;ilqr to JOB.FTE field however it is computed with PAID_HOURS instead of STD_HOURS. It is a French specific field.
    100 PAID_HRS_FREQUENCY Character(5) VARCHAR2(5) NOT NULL Paid Work Period
    101 FTE Number(8,6) DECIMAL(7,6) NOT NULL This field represent Full Time Equivalence
    102 EEO_CLASS Character(1) VARCHAR2(1) NOT NULL EEO Classification
    E=Exclude from Count
    N=None of the Above
    P=Production Trainee
    W=White-Collar Trainee
    103 SAL_ADMIN_PLAN Character(4) VARCHAR2(4) NOT NULL Salary Administration Plan

    Prompt Table: SET_SALPLAN_VW

    104 GRADE Character(3) VARCHAR2(3) NOT NULL Salary Grade

    Prompt Table: SET_SALGRADE_VW

    105 GRADE_ENTRY_DT Date(10) DATE Grade Entry Date
    106 STEP Number(2,0) SMALLINT NOT NULL Step

    Prompt Table: SET_SALSTEP_VW

    107 STEP_ENTRY_DT Date(10) DATE Step Entry Date
    108 GL_PAY_TYPE Character(6) VARCHAR2(6) NOT NULL General Ledger Pay Type
    109 COMP_FREQUENCY Character(5) VARCHAR2(5) NOT NULL Compensation Frequency
    A=Annual
    B=Biweekly
    C=Contract
    D=Daily
    H=Hourly
    M=Monthly
    S=Semimonthly
    W=Weekly

    Prompt Table: COMP_FREQ_VW

    110 COMPRATE Number(19,6) DECIMAL(18,6) NOT NULL Compensation Rate
    111 CHANGE_AMT Signed Number(20,6) DECIMAL(18,6) NOT NULL Change Amount
    112 CHANGE_PCT Signed Number(8,3) DECIMAL(6,3) NOT NULL Change Percent
    113 ANNUAL_RT Number(19,3) DECIMAL(18,3) NOT NULL Annual Rate
    114 MONTHLY_RT Number(19,3) DECIMAL(18,3) NOT NULL Monthly Rate
    115 DAILY_RT Number(19,3) DECIMAL(18,3) NOT NULL Daily Rate
    116 HOURLY_RT Number(19,6) DECIMAL(18,6) NOT NULL Hourly Rate
    117 ANNL_BENEF_BASE_RT Number(19,3) DECIMAL(18,3) NOT NULL Specifies a compensation amount used to calculate benefits and benefit deductions for an employee. The base compensation amount may include commissions and bonuses in addition to regular compensation. If no Annual Benefits Base Rate is entered, then benefits calculations are based on an employee's regular compensation.
    118 SHIFT_RT Number(19,6) DECIMAL(18,6) NOT NULL Shift Differential Rate
    119 SHIFT_FACTOR Number(5,3) DECIMAL(4,3) NOT NULL Shift Differential Factor
    120 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code

    Prompt Table: CURRENCY_CD_TBL

    121 DIRECTLY_TIPPED Character(1) VARCHAR2(1) NOT NULL Tipped
    D=Directly Tipped
    I=Indirectly Tipped
    N=Not Tipped
    122 PAY_SYSTEM_FLG Character(2) VARCHAR2(2) NOT NULL Payroll System
    GP=Global Payroll
    NA=Payroll for North America
    OT=Other
    PI=Payroll Interface
    123 SETID_DEPT Character(5) VARCHAR2(5) NOT NULL Department Set ID
    124 SETID_JOBCODE Character(5) VARCHAR2(5) NOT NULL Job Code Set ID
    125 SETID_LOCATION Character(5) VARCHAR2(5) NOT NULL Location Set ID
    126 SETID_SALARY Character(5) VARCHAR2(5) NOT NULL Salary Set ID
    127 GP_PAYGROUP Character(10) VARCHAR2(10) NOT NULL Global Payroll pay group
    128 GP_ELIG_GRP Character(10) VARCHAR2(10) NOT NULL Eligibility Group
    129 CUR_RT_TYPE Character(5) VARCHAR2(5) NOT NULL Currency Rate Type
    130 GP_ASOF_DT_EXG_RT Character(1) VARCHAR2(1) NOT NULL This field is used as a flag to determine whether to use a default exchange rate or not.
    B=Pay Period Begin Date
    E=Pay Period End Date
    P=Payment Date
    131 JOB_INDICATOR Character(1) VARCHAR2(1) NOT NULL This Indicator is used on JOB to specify which employment record is considered to be the primary one for an employee. In case of Multiple Jobs per Employee, this property is being used to make a conscious decision in related features where only 1 Employment Record per Employee needs to be returned.
    N=Not Applicable
    P=Primary Job
    S=Secondary Job
    132 PAY_UNION_FEE Character(1) VARCHAR2(1) NOT NULL Pay Union Fee
    133 UNION_CD Character(3) VARCHAR2(3) NOT NULL Union Code

    Prompt Table: UNION_TBL

    134 BARG_UNIT Character(4) VARCHAR2(4) NOT NULL Bargaining Unit
    1=Bargaining Unit 1
    2=Bargaining Unit 2
    135 UNION_SENIORITY_DT Date(10) DATE Union Seniority Date
    136 ENTRY_DATE Date(10) DATE Date Entered
    137 LABOR_AGREEMENT Character(6) VARCHAR2(6) NOT NULL Labor Agreement

    Prompt Table: EMPL_CTG

    138 EMPL_CTG Character(6) VARCHAR2(6) NOT NULL Employee Category

    Prompt Table: EMPL_CTG_L1_VW

    139 EMPL_CTG_L1 Character(6) VARCHAR2(6) NOT NULL Employee Subcategory

    Prompt Table: EMPL_CTG_L2_VW

    140 EMPL_CTG_L2 Character(6) VARCHAR2(6) NOT NULL Employee Subcategory 2

    Prompt Table: EMPL_CTG_L3_VW

    141 SETID_LBR_AGRMNT Character(5) VARCHAR2(5) NOT NULL Labor Agreement SetID
    142 WPP_STOP_FLAG Character(1) VARCHAR2(1) NOT NULL Y/N Flag to indicated that Wage Progression is stopped on this Assignment.
    143 LABOR_FACILITY_ID Character(10) VARCHAR2(10) NOT NULL Labor Facility ID
    144 LBR_FAC_ENTRY_DT Date(10) DATE Date the Person was added to this Labor Facility.
    145 LAYOFF_EXEMPT_FLAG Character(1) VARCHAR2(1) NOT NULL Y/N Flag to indicate if a Person's Assignment is exempt from Layoff.
    146 LAYOFF_EXEMPT_RSN Character(11) VARCHAR2(11) NOT NULL Reason for the Exemption from Layoff
    147 VALUE_1_FRA Character(5) VARCHAR2(5) NOT NULL HFR
    148 VALUE_2_FRA Character(5) VARCHAR2(5) NOT NULL HFR
    149 VALUE_3_FRA Character(5) VARCHAR2(5) NOT NULL HCR
    150 VALUE_4_FRA Character(5) VARCHAR2(5) NOT NULL HFR
    151 VALUE_5_FRA Character(5) VARCHAR2(5) NOT NULL HFR
    152 GVT_SCD_RETIRE Date(10) DATE Service Comp Date - Retire
    153 GVT_MAND_RET_DT Date(10) DATE Mandatory Retirement Date
    154 GVT_SCD_TSP Date(10) DATE Service Comp Date - TSP
    155 GVT_SCD_SEVPAY Date(10) DATE Service Comp Date - Sev Pay
    156 GVT_DT_LEI Date(10) DATE Date Last Equivalent Increase
    157 GVT_PAY_BASIS Character(2) VARCHAR2(2) NOT NULL Pay Basis
    BW=Bi-weekly
    FB=Fee Basis
    PA=Per Annum
    PD=Per Diem
    PH=Per Hour
    PM=Per Month
    PW=Piece Work
    SM=Semi-monthly
    SY=School Year
    WC=Without Compensation
    158 GVT_WGI_STATUS Character(1) VARCHAR2(1) NOT NULL Current WGI Status
    A=Approved
    C=WGI Created
    D=Denied
    M=Manual WGI
    N=WGI Not Applicable
    P=Postponed
    W=Waiting WGI Processing
    159 GVT_WGI_DUE_DATE Date(10) DATE Within-Grade Increase Due Date
    160 GVT_INTRM_DAYS_WGI Number(3,0) SMALLINT NOT NULL Intermittent Days Worked
    161 GVT_LOCALITY_ADJ Number(8,2) DECIMAL(7,2) NOT NULL Locality Adjustment
    162 GVT_WORK_SCHED Character(1) VARCHAR2(1) NOT NULL Work Schedule
    B=Baylor Plan
    F=Full Time
    G=Full Time Seasonal
    I=Intermittent
    J=Intermittent-Seasonal
    P=Part Time
    Q=Part-Time Seasonal
    R=Part-Time Phased Retiree
    S=Part-Time Job Sharer
    T=Part-Time Seasonal Job Sharer
    163 GVT_SEVPAY_PRV_WKS Number(2,0) SMALLINT NOT NULL Severance Pay Previous Weeks
    164 GVT_BIWEEKLY_RT Number(10,2) DECIMAL(9,2) NOT NULL Biweekly Rate
    165 GVT_STEP Character(2) VARCHAR2(2) NOT NULL US Federal Step
    166 GVT_RTND_PAY_PLAN Character(2) VARCHAR2(2) NOT NULL Retained Pay Plan

    Prompt Table: ERN_PROGRAM_TBL

    167 GVT_RTND_SAL_PLAN Character(4) VARCHAR2(4) NOT NULL Retained Pay Table
    168 GVT_RTND_GRADE Character(3) VARCHAR2(3) NOT NULL Retained Grade
    169 GVT_RTND_STEP Number(2,0) SMALLINT NOT NULL Retained Step
    170 GVT_RTND_GVT_STEP Character(2) VARCHAR2(2) NOT NULL Retained US Federal Step
    171 GVT_RTND_GRADE_BEG Date(10) DATE Retained Grade Begins
    172 GVT_RTND_GRADE_EXP Date(10) DATE Retained Grade Expires
    173 GVT_TEMP_PRO_EXPIR Date(10) DATE Temp Promotion Expires
    174 GVT_TEMP_PSN_EXPIR Date(10) DATE Temporary Posn Change Expires
    175 GVT_DETAIL_EXPIRES Date(10) DATE Date Detail Expires
    176 GVT_SABBATIC_EXPIR Date(10) DATE Date Sabbatical Expires
    177 GVT_TYPE_OF_APPT Character(2) VARCHAR2(2) NOT NULL Type of Appointment
    10=Career (Competitive Svc Perm)
    15=Career-Conditional (Comp Perm)
    20=Nonpermanent (Comp NonPerm)
    30=Schedule A (Except Svc Perm)
    32=Schedule B (Except Svc Perm)
    34=Schedule C (Except Svc Perm)
    36=Executive (Except Svc Perm)
    38=Other (Except Svc Perm)
    40=Schedule A (Except NonPerm)
    42=Schedule B (Except NonPerm)
    44=Schedule C (Except NonPerm)
    46=Executive (Except NonPerm)
    48=Other (Except NonPerm)
    50=Career (Senior Exec Perm)
    55=Noncareer (Senior Exec Perm)
    60=Limited Term (Senior Exec NPrm
    65=Limited Emergency (SES NPerm)
    178 GVT_APPT_EXPIR_DT Date(10) DATE Appointment Expiration Date
    179 GVT_CAREER_CNV_DUE Date(10) DATE Conversion To Career Due
    180 GVT_SUPV_PROB_DT Date(10) DATE Supv/Manager Probation Date
    181 GVT_SES_PROB_DT Date(10) DATE SES Probation Date
    182 GVT_SEC_CLR_STATUS Character(1) VARCHAR2(1) NOT NULL Security Clearance Status
    A=Approved
    B=Pending - Investigative Agency
    C=Pending - Employee
    D=Pending - Agency
    N=Not Applicable
    S=Suspended
    183 GVT_CLRNCE_STAT_DT Date(10) DATE Security Clearance Status Date
    184 EEO1CODE Character(1) VARCHAR2(1) NOT NULL EEO-1 Job Category
    1=Officials and Managers
    2=Professionals
    3=Technicians
    4=Sales Workers
    5=Administrative Support Workers
    6=Craft Workers
    7=Operatives
    8=Laborers and Helpers
    9=Service Workers
    A=Executive/Sr Level Officials
    B=First/Mid Level Officials
    N=No EEO-1 Reporting
    185 EEO4CODE Character(1) VARCHAR2(1) NOT NULL EEO-4 Job Category
    1=Officials and Administrators
    2=Professionals
    3=Technicians
    4=Protective Service
    5=Paraprofessionals
    6=Administrative Support
    7=Skilled Craft
    8=Service Maintenance
    N=No EEO-4 Reporting
    186 EEO5CODE Character(2) VARCHAR2(2) NOT NULL EEO-5 Job Category
    1=Officials,Administrators,Mgrs
    10=Librarian/Audiovisual
    11=Consultants/Supv.of Instructn
    12=Other Professional Staff
    13=Teacher Aides
    14=Technicians
    15=Clerical/Secretarial
    16=Service Workers
    17=Craft Workers (Skilled)
    18=Laborers (Unskilled)
    2=Principals
    3=Asst. Principals-Teaching
    4=Asst. Principals-Nonteaching
    5=Elementary Classroom Teachers
    6=Secondary Classroom Teachers
    7=Other Classroom Teachers
    8=Guidance
    9=Psychological
    N=No EEO-5 Reporting
    187 EEO6CODE Character(1) VARCHAR2(1) NOT NULL EEO-6 Job Category
    1=Executive/Admin/Managerial
    2=Faculty
    3=Professional Nonfaculty
    4=Secretarial/Clerical
    5=Technical/Paraprofessional
    6=Skilled Crafts
    7=Service Maintenance Workers
    N=No EEO-6 Reporting
    188 EEO_JOB_GROUP Character(4) VARCHAR2(4) NOT NULL EEO Job Group
    189 JOB_FAMILY Character(6) VARCHAR2(6) NOT NULL Job Family
    190 JOB_KNOWHOW_POINTS Number(5,0) INTEGER NOT NULL Knowhow-Points
    191 JOB_ACCNTAB_POINTS Number(5,0) INTEGER NOT NULL Accountability-Points
    192 JOB_PROBSLV_POINTS Number(5,0) INTEGER NOT NULL Problem-Solving-Points
    193 JOB_POINTS_TOTAL Number(5,0) INTEGER NOT NULL Total Points
    194 JOB_KNOWHOW_PCT Number(5,1) DECIMAL(4,1) NOT NULL Knowhow-Percent
    195 JOB_ACCNTAB_PCT Number(5,1) DECIMAL(4,1) NOT NULL Accountability-Percent
    196 JOB_PROBSLV_PCT Number(5,1) DECIMAL(4,1) NOT NULL Problem-Solving-Percent
    197 IPEDSSCODE Character(1) VARCHAR2(1) NOT NULL IPEDS-S Job Category
    198 GVT_ORG_TTL_DESCR Character(70) VARCHAR2(70) NOT NULL Organization Position Title
    199 MANAGER_ID Character(11) VARCHAR2(11) NOT NULL Manager ID

    Prompt Table: PERSON_NAME

    200 EEO4_FUNCTION Character(2) VARCHAR2(2) NOT NULL U.S. EEO4 Function
    01=Financial Administration
    02=Streets and Highways
    03=Public Welfare
    04=Police Protection
    05=Fire Protection
    06=Natural Resources
    07=Hospitals & Sanatoriums
    08=Health
    09=Housing
    10=Community Development
    11=Corrections
    12=Utilities & Transportation
    13=Sanitation & Sewage
    14=Employment Security
    15=Other
    99=Not Counted for EEO Reporting
    201 ASOFDATE Date(10) DATE As of Date
    202 FROMDATE Date(10) DATE From Date
    203 JOBTITLE Character(30) VARCHAR2(30) NOT NULL Job Title
    204 JOBTITLE_ABBRV Character(10) VARCHAR2(10) NOT NULL Short Name
    205 DEPTNAME Character(30) VARCHAR2(30) NOT NULL Department Name
    206 DEPTNAME_ABBRV Character(10) VARCHAR2(10) NOT NULL Short Name
    207 REHIRE_DT Date(10) DATE Rehire Date
    208 WORK_PHONE Character(24) VARCHAR2(24) NOT NULL Work Phone #
    209 NID_COUNTRY Character(3) VARCHAR2(3) NOT NULL National ID Country
    210 GVT_OVERTIME_RT Number(8,3) DECIMAL(7,3) NOT NULL Overtime Hourly Rate
    211 GVT_RTND_PAY_BASIS Character(2) VARCHAR2(2) NOT NULL Retained Pay Basis
    212 SEC_CLEARANCE_TYPE Character(3) VARCHAR2(3) NOT NULL Security Clearance Type
    213 HR_STATUS Character(1) VARCHAR2(1) NOT NULL HR Status
    A=Active
    I=Inactive
    214 CONTRACT_TYPE Character(3) VARCHAR2(3) NOT NULL Contract Type
    215 ESTABID Character(12) VARCHAR2(12) NOT NULL Establishment ID
    216 ESTABL_DESCR Character(30) VARCHAR2(30) NOT NULL Establishment Description
    217 CONTRACT_TYPE_DESC Character(30) VARCHAR2(30) NOT NULL Contract Type
    218 EMPL_STATUS_DESCR Character(30) VARCHAR2(30) NOT NULL Employee Status
    219 EMPL_TYPE_DESCR Character(30) VARCHAR2(30) NOT NULL Employee Type
    220 HR_STATUS_DESCR Character(30) VARCHAR2(30) NOT NULL HR Status
    221 SUPERVISOR_NAME Character(50) VARCHAR2(50) NOT NULL Supervisor Name
    222 CONTRACT_NUM Character(25) VARCHAR2(25) NOT NULL Contract Number
    223 COMPANY_DESCR Character(30) VARCHAR2(30) NOT NULL Company
    224 LOCATION_DESCR Character(30) VARCHAR2(30) NOT NULL Location
    225 COUNTRY_DESCR Character(30) VARCHAR2(30) NOT NULL Country Description
    226 GP_PAYGROUP_DESCR Character(30) VARCHAR2(30) NOT NULL GP Paygroup
    227 REG_REGION_DESCR Character(50) VARCHAR2(50) NOT NULL Regulatory Region
    228 PAY_SYSTM_FLG_DESC Character(30) VARCHAR2(30) NOT NULL Payroll System
    229 POSITION_NBR_DESCR Character(30) VARCHAR2(30) NOT NULL Position Number
    230 REPORTS_TO_NAME Character(50) VARCHAR2(50) NOT NULL Reports To Name
    231 REPORTS_TO_DESCR Character(50) VARCHAR2(50) NOT NULL Reports To
    232 REPORTS_TO_EMPLID Character(11) VARCHAR2(11) NOT NULL Reports To Emplid
    233 PAY_ENTITY Character(10) VARCHAR2(10) NOT NULL Pay Entity
    234 PAY_ENTITY_DESCR Character(30) VARCHAR2(30) NOT NULL Pay Entity Description
    235 RT_TYPE Character(5) VARCHAR2(5) NOT NULL Defines a category of market rates for currency conversion. Some examples of rate types are commercial, average, floating, and historical.