GVT_PAR_PRT

(SQL Table)
Index Back

Selected PAR Data

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).
2 RUN_CNTL_ID Character(30) VARCHAR2(30) NOT NULL Run Control ID
3 GVT_WIP_RECORD Character(25) VARCHAR2(25) NOT NULL Transaction
4 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
5 EMPL_RCD Number(3,0) SMALLINT NOT NULL Empl Rcd Nbr
6 EFFDT Date(10) DATE Effective Date
7 EFFSEQ Number(3,0) SMALLINT NOT NULL Effective Sequence
8 GVT_PAR_CUR_STATUS Character(3) VARCHAR2(3) NOT NULL Current PAR Status
9 NAME Character(50) VARCHAR2(50) NOT NULL Name
10 SSN Character(9) VARCHAR2(9) NOT NULL Social Security #
11 LOCATION Character(10) VARCHAR2(10) NOT NULL Location Code
12 DEPTID Character(10) VARCHAR2(10) NOT NULL Department
13 POSITION_NBR Character(8) VARCHAR2(8) NOT NULL Position Number
14 JOBCODE Character(6) VARCHAR2(6) NOT NULL Job Code
15 GVT_WIP_STATUS Character(3) VARCHAR2(3) NOT NULL Work-in-Progress Status
16 GVT_DATE_WRK Date(10) DATE Action Taken