HRS_G_PRIPL_LNG

(SQL Table)
 Index Back

Priority Placement

Use EDUCATN to record all education data for an employee or applicant. You can create multiple EDUCATN records for an employee. GVT: This table modified for US Federal nomenclature and values. The field DEGREE is called Education Level while the field MAJOR_CODE is called Instructional Program Code and MAJOR is called Instructional Program. This was done because US Federal captures more than just college-level education. It captures education from elementary school to trade school to advanced degrees. The codes for DEGREE and MAJOR come from OPM's Guide to Personnel Data Standards. The field DEGREE is actually only 2 characters and MAJOR_CODE is actually on 6 characters. The PeopleSoft field sizes have not been changed since they will accommodate our needs. Related Language record for GVT_PRI_PLCMNT.

  • Related Language Record for HRS_G_PRI_PL HRS_G_PRI_PL_I

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 HRS_PERSON_ID Number(15,0) DECIMAL(15) NOT NULL Person Id
    2 HRS_PROFILE_SEQ Number(3,0) SMALLINT NOT NULL Profile sequece
    3 GVT_PRIO_PLCMNT_CD Character(3) VARCHAR2(3) NOT NULL Priority Placement Code
    4 GVT_PRIO_DT_END Date(10) DATE Priority Placement End Date
    5 GVT_PAY_PLAN Character(2) VARCHAR2(2) NOT NULL Pay Plan
    6 SAL_ADMIN_PLAN Character(4) VARCHAR2(4) NOT NULL Salary Administration Plan
    7 GRADE Character(3) VARCHAR2(3) NOT NULL Salary Grade
    8 GVT_OCC_SERIES Character(4) VARCHAR2(4) NOT NULL Occupational Series
    9 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    10 COMMENTS Long Character CLOB Comment