HR_PG_WF_DIVERS

(SQL Table)
 Index Back

Workforce Diversity

Workforce Diversity Record for HR Analytics

  • Related Language Record: HR_PG_WF_DV_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 HR_DIV_TYPE Character(1) VARCHAR2(1) NOT NULL Field used to list Diversity Types.
    A=Age
    D=Disability
    E=Ethnicity
    G=Gender
    V=Veteran Status
    4 DESCR100 Character(100) VARCHAR2(100) NOT NULL Length 100 Description
    5 HR_STATUS Character(1) VARCHAR2(1) NOT NULL HR Status
    A=Active
    I=Inactive
    6 HR_STATUS_DESCR Character(30) VARCHAR2(30) NOT NULL HR Status
    7 BIRTHDATE Date(10) DATE Date of Birth
    8 BIRTHPLACE Character(30) VARCHAR2(30) NOT NULL Birth Location
    9 DT_OF_DEATH Date(10) DATE Date of Death
    10 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

    11 NAME Character(50) VARCHAR2(50) NOT NULL Name
    12 NAME_INITIALS Character(6) VARCHAR2(6) NOT NULL Name Initials
    13 NAME_PREFIX Character(4) VARCHAR2(4) NOT NULL Name Prefix

    Prompt Table: NAME_PREFIX_TBL

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

    Prompt Table: NAME_SUFFIX_TBL

    15 NAME_ROYAL_PREFIX Character(15) VARCHAR2(15) NOT NULL Name Royal Prefix
    16 NAME_ROYAL_SUFFIX Character(15) VARCHAR2(15) NOT NULL Name - Royal Suffix
    17 NAME_TITLE Character(30) VARCHAR2(30) NOT NULL Name Title

    Prompt Table: TITLE_TBL

    18 LAST_NAME_SRCH Character(30) VARCHAR2(30) NOT NULL Last Name
    19 FIRST_NAME_SRCH Character(30) VARCHAR2(30) NOT NULL First Name
    20 LAST_NAME Character(30) VARCHAR2(30) NOT NULL Last Name
    21 FIRST_NAME Character(30) VARCHAR2(30) NOT NULL First Name
    22 MIDDLE_NAME Character(30) VARCHAR2(30) NOT NULL MIDDLE_NAME
    23 SECOND_LAST_SRCH Character(30) VARCHAR2(30) NOT NULL Second Last Name
    24 SECOND_LAST_NAME Character(30) VARCHAR2(30) NOT NULL Second Last Name
    25 NAME_AC Character(50) VARCHAR2(50) NOT NULL Alternate Character Name
    26 PREF_FIRST_NAME Character(30) VARCHAR2(30) NOT NULL Preferred First Name
    27 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

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

    Prompt Table: COUNTRY_TBL

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

    Prompt Table: STATE_TBL

    42 POSTAL Character(12) VARCHAR2(12) NOT NULL Postal
    43 GEO_CODE Character(11) VARCHAR2(11) NOT NULL Geo Code
    44 IN_CITY_LIMIT Character(1) VARCHAR2(1) NOT NULL In City Limit
    45 HOME_PHONE Character(24) VARCHAR2(24) NOT NULL Home Phone #
    46 NATIONAL_ID_TYPE Character(6) VARCHAR2(6) NOT NULL National ID Type

    Prompt Table: NID_TYPE1_VW

    47 NATIONAL_ID Character(20) VARCHAR2(20) NOT NULL National ID
    48 SEX Character(1) VARCHAR2(1) NOT NULL Gender
    F=Female
    M=Male
    U=Unknown
    49 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
    50 HIGHEST_EDUC_LVL Character(2) VARCHAR2(2) NOT NULL Highest Education Level
    51 FT_STUDENT Character(1) VARCHAR2(1) NOT NULL Full-Time Student
    52 MILITARY_STATUS Character(1) VARCHAR2(1) NOT NULL Veteran Status / Military Status
    53 US_WORK_ELIGIBILTY Character(1) VARCHAR2(1) NOT NULL Eligible to Work in U.S.
    N=No
    Y=Yes
    54 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
    55 DISABLED Character(1) VARCHAR2(1) NOT NULL A flag that indicates whether or not (Y or N) a dependent is a disabled.
    56 DISABLED_VET Character(1) VARCHAR2(1) NOT NULL Disabled Veteran
    57 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
    58 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

    59 CITIZENSHIP_STATUS Character(1) VARCHAR2(1) NOT NULL Citizenship Status
    60 ORIG_HIRE_DT Date(10) DATE Original Start Date
    61 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
    62 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.
    63 CMPNY_SENIORITY_DT Date(10) DATE Company Seniority Date
    64 SERVICE_DT Date(10) DATE Service Date
    65 HOME_HOST_CLASS Character(1) VARCHAR2(1) NOT NULL Home/Host Classification
    M=Home
    S=Host
    66 LAST_INCREASE_DT Date(10) DATE Date Last Increase
    67 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.
    68 BUSINESS_TITLE Character(30) VARCHAR2(30) NOT NULL Business Title
    69 PROBATION_DT Date(10) DATE Probation Date
    70 EFFDT Date(10) DATE NOT NULL Effective Date
    71 EFFSEQ Number(3,0) SMALLINT NOT NULL Effective Sequence
    72 HIRE_DT Date(10) DATE First Start Date
    73 EXPECTED_RETURN_DT Date(10) DATE Expected Return Date
    74 TERMINATION_DT Date(10) DATE Termination Date
    75 LAST_DATE_WORKED Date(10) DATE Last Date Worked
    76 REPORTS_TO Character(8) VARCHAR2(8) NOT NULL Reports To Position Number
    77 SUPERVISOR_ID Character(11) VARCHAR2(11) NOT NULL Supervisor ID

    Prompt Table: PERSON_NAME

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

    Prompt Table: BUS_UNIT_TBL_HR

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

    Prompt Table: SET_DEPT_VW

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

    Prompt Table: SET_JOBCD_VW2

    81 POSITION_NBR Character(8) VARCHAR2(8) NOT NULL Position Number
    82 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
    83 ACTION Character(3) VARCHAR2(3) NOT NULL Action

    Prompt Table: ACTION_TBL

    84 ACTION_DT Date(10) DATE Action Date
    85 ACTION_REASON Character(3) VARCHAR2(3) NOT NULL Reason Code

    Prompt Table: ACTN_REASON_TBL

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

    Prompt Table: SET_LOC_VW

    87 JOB_ENTRY_DT Date(10) DATE Job Entry Date
    88 DEPT_ENTRY_DT Date(10) DATE Department Entry Date
    89 POSITION_ENTRY_DT Date(10) DATE Position Entry Date
    90 SHIFT Character(1) VARCHAR2(1) NOT NULL Regular Shift
    1=Day
    2=Evening
    3=Night
    A=Any
    C=Compressed
    N=Not Applicable
    R=Rotating
    91 REG_TEMP Character(1) VARCHAR2(1) NOT NULL Regular/Temporary
    R=Regular
    T=Temporary
    92 FULL_PART_TIME Character(1) VARCHAR2(1) NOT NULL Full/Part Time
    D=On Demand
    F=Full-Time
    P=Part-Time
    93 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
    94 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
    95 COMPANY Character(3) VARCHAR2(3) NOT NULL Company

    Prompt Table: COMPANY_TBL

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

    Prompt Table: HOLIDAY_TBL

    99 STD_HOURS Number(7,2) DECIMAL(6,2) NOT NULL Standard Hours
    100 STD_HRS_FREQUENCY Character(5) VARCHAR2(5) NOT NULL Standard Work Period
    101 REG_REGION Character(5) VARCHAR2(5) NOT NULL Regulatory Region
    102 PAID_HOURS Number(7,2) DECIMAL(6,2) NOT NULL Paid Hours
    103 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.
    104 PAID_HRS_FREQUENCY Character(5) VARCHAR2(5) NOT NULL Paid Work Period
    105 FTE Number(8,6) DECIMAL(7,6) NOT NULL This field represent Full Time Equivalence
    106 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
    107 SAL_ADMIN_PLAN Character(4) VARCHAR2(4) NOT NULL Salary Administration Plan

    Prompt Table: SET_SALPLAN_VW

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

    Prompt Table: SET_SALGRADE_VW

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

    Prompt Table: SET_SALSTEP_VW

    111 STEP_ENTRY_DT Date(10) DATE Step Entry Date
    112 GL_PAY_TYPE Character(6) VARCHAR2(6) NOT NULL General Ledger Pay Type
    113 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

    114 COMPRATE Number(19,6) DECIMAL(18,6) NOT NULL Compensation Rate
    115 CHANGE_AMT Signed Number(20,6) DECIMAL(18,6) NOT NULL Change Amount
    116 CHANGE_PCT Signed Number(8,3) DECIMAL(6,3) NOT NULL Change Percent
    117 ANNUAL_RT Number(19,3) DECIMAL(18,3) NOT NULL Annual Rate
    118 MONTHLY_RT Number(19,3) DECIMAL(18,3) NOT NULL Monthly Rate
    119 DAILY_RT Number(19,3) DECIMAL(18,3) NOT NULL Daily Rate
    120 HOURLY_RT Number(19,6) DECIMAL(18,6) NOT NULL Hourly Rate
    121 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.
    122 SHIFT_RT Number(19,6) DECIMAL(18,6) NOT NULL Shift Differential Rate
    123 SHIFT_FACTOR Number(5,3) DECIMAL(4,3) NOT NULL Shift Differential Factor
    124 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code

    Prompt Table: CURRENCY_CD_TBL

    125 DIRECTLY_TIPPED Character(1) VARCHAR2(1) NOT NULL Tipped
    D=Directly Tipped
    I=Indirectly Tipped
    N=Not Tipped
    126 PAY_SYSTEM_FLG Character(2) VARCHAR2(2) NOT NULL Payroll System
    GP=Global Payroll
    NA=Payroll for North America
    OT=Other
    PI=Payroll Interface
    127 SETID_DEPT Character(5) VARCHAR2(5) NOT NULL Department Set ID
    128 SETID_JOBCODE Character(5) VARCHAR2(5) NOT NULL Job Code Set ID
    129 SETID_LOCATION Character(5) VARCHAR2(5) NOT NULL Location Set ID
    130 SETID_SALARY Character(5) VARCHAR2(5) NOT NULL Salary Set ID
    131 GP_PAYGROUP Character(10) VARCHAR2(10) NOT NULL Global Payroll pay group
    132 GP_ELIG_GRP Character(10) VARCHAR2(10) NOT NULL Eligibility Group
    133 CUR_RT_TYPE Character(5) VARCHAR2(5) NOT NULL Currency Rate Type
    134 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
    135 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
    136 PAY_UNION_FEE Character(1) VARCHAR2(1) NOT NULL Pay Union Fee
    137 UNION_CD Character(3) VARCHAR2(3) NOT NULL Union Code

    Prompt Table: UNION_TBL

    138 BARG_UNIT Character(4) VARCHAR2(4) NOT NULL Bargaining Unit
    1=Bargaining Unit 1
    2=Bargaining Unit 2
    139 UNION_SENIORITY_DT Date(10) DATE Union Seniority Date
    140 ENTRY_DATE Date(10) DATE Date Entered
    141 LABOR_AGREEMENT Character(6) VARCHAR2(6) NOT NULL Labor Agreement

    Prompt Table: EMPL_CTG

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

    Prompt Table: EMPL_CTG_L1_VW

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

    Prompt Table: EMPL_CTG_L2_VW

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

    Prompt Table: EMPL_CTG_L3_VW

    145 SETID_LBR_AGRMNT Character(5) VARCHAR2(5) NOT NULL Labor Agreement SetID
    146 WPP_STOP_FLAG Character(1) VARCHAR2(1) NOT NULL Y/N Flag to indicated that Wage Progression is stopped on this Assignment.
    147 LABOR_FACILITY_ID Character(10) VARCHAR2(10) NOT NULL Labor Facility ID
    148 LBR_FAC_ENTRY_DT Date(10) DATE Date the Person was added to this Labor Facility.
    149 LAYOFF_EXEMPT_FLAG Character(1) VARCHAR2(1) NOT NULL Y/N Flag to indicate if a Person's Assignment is exempt from Layoff.
    150 LAYOFF_EXEMPT_RSN Character(11) VARCHAR2(11) NOT NULL Reason for the Exemption from Layoff
    151 VALUE_1_FRA Character(5) VARCHAR2(5) NOT NULL HFR
    152 VALUE_2_FRA Character(5) VARCHAR2(5) NOT NULL HFR
    153 VALUE_3_FRA Character(5) VARCHAR2(5) NOT NULL HCR
    154 VALUE_4_FRA Character(5) VARCHAR2(5) NOT NULL HFR
    155 VALUE_5_FRA Character(5) VARCHAR2(5) NOT NULL HFR
    156 GVT_SCD_RETIRE Date(10) DATE Service Comp Date - Retire
    157 GVT_MAND_RET_DT Date(10) DATE Mandatory Retirement Date
    158 GVT_SCD_TSP Date(10) DATE Service Comp Date - TSP
    159 GVT_SCD_SEVPAY Date(10) DATE Service Comp Date - Sev Pay
    160 GVT_DT_LEI Date(10) DATE Date Last Equivalent Increase
    161 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
    162 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
    163 GVT_WGI_DUE_DATE Date(10) DATE Within-Grade Increase Due Date
    164 GVT_INTRM_DAYS_WGI Number(3,0) SMALLINT NOT NULL Intermittent Days Worked
    165 GVT_LOCALITY_ADJ Number(8,2) DECIMAL(7,2) NOT NULL Locality Adjustment
    166 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
    167 GVT_SEVPAY_PRV_WKS Number(2,0) SMALLINT NOT NULL Severance Pay Previous Weeks
    168 GVT_BIWEEKLY_RT Number(10,2) DECIMAL(9,2) NOT NULL Biweekly Rate
    169 GVT_STEP Character(2) VARCHAR2(2) NOT NULL US Federal Step
    170 GVT_RTND_PAY_PLAN Character(2) VARCHAR2(2) NOT NULL Retained Pay Plan

    Prompt Table: ERN_PROGRAM_TBL

    171 GVT_RTND_SAL_PLAN Character(4) VARCHAR2(4) NOT NULL Retained Pay Table
    172 GVT_RTND_GRADE Character(3) VARCHAR2(3) NOT NULL Retained Grade
    173 GVT_RTND_STEP Number(2,0) SMALLINT NOT NULL Retained Step
    174 GVT_RTND_GVT_STEP Character(2) VARCHAR2(2) NOT NULL Retained US Federal Step
    175 GVT_RTND_GRADE_BEG Date(10) DATE Retained Grade Begins
    176 GVT_RTND_GRADE_EXP Date(10) DATE Retained Grade Expires
    177 GVT_TEMP_PRO_EXPIR Date(10) DATE Temp Promotion Expires
    178 GVT_TEMP_PSN_EXPIR Date(10) DATE Temporary Posn Change Expires
    179 GVT_DETAIL_EXPIRES Date(10) DATE Date Detail Expires
    180 GVT_SABBATIC_EXPIR Date(10) DATE Date Sabbatical Expires
    181 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)
    182 GVT_APPT_EXPIR_DT Date(10) DATE Appointment Expiration Date
    183 GVT_CAREER_CNV_DUE Date(10) DATE Conversion To Career Due
    184 GVT_SUPV_PROB_DT Date(10) DATE Supv/Manager Probation Date
    185 GVT_SES_PROB_DT Date(10) DATE SES Probation Date
    186 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
    187 GVT_CLRNCE_STAT_DT Date(10) DATE Security Clearance Status Date
    188 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
    189 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
    190 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
    191 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
    192 EEO_JOB_GROUP Character(4) VARCHAR2(4) NOT NULL EEO Job Group
    193 JOB_FAMILY Character(6) VARCHAR2(6) NOT NULL Job Family
    194 JOB_KNOWHOW_POINTS Number(5,0) INTEGER NOT NULL Knowhow-Points
    195 JOB_ACCNTAB_POINTS Number(5,0) INTEGER NOT NULL Accountability-Points
    196 JOB_PROBSLV_POINTS Number(5,0) INTEGER NOT NULL Problem-Solving-Points
    197 JOB_POINTS_TOTAL Number(5,0) INTEGER NOT NULL Total Points
    198 JOB_KNOWHOW_PCT Number(5,1) DECIMAL(4,1) NOT NULL Knowhow-Percent
    199 JOB_ACCNTAB_PCT Number(5,1) DECIMAL(4,1) NOT NULL Accountability-Percent
    200 JOB_PROBSLV_PCT Number(5,1) DECIMAL(4,1) NOT NULL Problem-Solving-Percent
    201 IPEDSSCODE Character(1) VARCHAR2(1) NOT NULL IPEDS-S Job Category
    202 GVT_ORG_TTL_DESCR Character(70) VARCHAR2(70) NOT NULL Organization Position Title
    203 MANAGER_ID Character(11) VARCHAR2(11) NOT NULL Manager ID

    Prompt Table: PERSON_NAME

    204 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
    205 ASOFDATE Date(10) DATE As of Date
    206 FROMDATE Date(10) DATE From Date
    207 THRUDATE Date(10) DATE End Date
    208 JOBTITLE Character(30) VARCHAR2(30) NOT NULL Job Title
    209 JOBTITLE_ABBRV Character(10) VARCHAR2(10) NOT NULL Short Name
    210 DEPTNAME Character(30) VARCHAR2(30) NOT NULL Department Name
    211 DEPTNAME_ABBRV Character(10) VARCHAR2(10) NOT NULL Short Name
    212 REHIRE_DT Date(10) DATE Rehire Date
    213 WORK_PHONE Character(24) VARCHAR2(24) NOT NULL Work Phone #
    214 NID_COUNTRY Character(3) VARCHAR2(3) NOT NULL National ID Country
    215 GVT_OVERTIME_RT Number(8,3) DECIMAL(7,3) NOT NULL Overtime Hourly Rate
    216 GVT_RTND_PAY_BASIS Character(2) VARCHAR2(2) NOT NULL Retained Pay Basis
    217 SEC_CLEARANCE_TYPE Character(3) VARCHAR2(3) NOT NULL Security Clearance Type
    218 JOBCODE_DESCR Character(30) VARCHAR2(30) NOT NULL Job Code Description
    219 POSN_DESCR Character(30) VARCHAR2(30) NOT NULL Position Description
    220 JOB_DESCR Character(30) VARCHAR2(30) NOT NULL Job Description
    221 LOCATION_DESCR Character(30) VARCHAR2(30) NOT NULL Location Description
    222 DEPT_DESCR Character(30) VARCHAR2(30) NOT NULL Department Description
    223 BUSINESS_DESCR Character(60) VARCHAR2(60) NOT NULL Business Description
    224 COMPANY_DESCR Character(30) VARCHAR2(30) NOT NULL Company Descr
    225 EMPL_TYPE_DESCR Character(30) VARCHAR2(30) NOT NULL Employee Type
    226 REG_REGION_DESCR Character(50) VARCHAR2(50) NOT NULL Regulatory Region
    227 MANAGER_NAME Character(30) VARCHAR2(30) NOT NULL Manager Name
    228 DISABILITY_STS_USA Character(1) VARCHAR2(1) NOT NULL Disability (Section 503) Status USA
    N=Not Disabled
    X=Not Indicated
    Y=Disabled
    229 AGE Number(3,0) SMALLINT NOT NULL Age
    230 HR_AGE_RANGE Character(1) VARCHAR2(1) NOT NULL Age Range
    1=<18
    2=18-24
    3=25-34
    4=35-44
    5=45-54
    6=55-64
    7=65+
    N=Not Available
    231 VETERAN_STATUS Character(1) VARCHAR2(1) NOT NULL Veteran Status
    N=Not a Veteran
    X=Not Indicated
    Y=Veteran