HRS_GPRI_LN_HST

(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.

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