GVT_MASSORGPAET

(SQL Table)
Index Back

Mass Org Temp Record

Used by Mass Organizational Update as temporary record to store job, salary, and other pertinent information

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance
2 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
3 EMPL_RCD Number(3,0) SMALLINT NOT NULL Empl Record
4 EFFDT Date(10) DATE Effective Date

Default Value: %date

5 EFFSEQ Number(3,0) SMALLINT NOT NULL Effective Sequence
6 POSITION_NBR Character(8) VARCHAR2(8) NOT NULL Position Number
7 JOBCODE Character(6) VARCHAR2(6) NOT NULL Job Code
8 LOCATION Character(10) VARCHAR2(10) NOT NULL Location Code
9 SHIFT Character(1) VARCHAR2(1) NOT NULL Regular Shift
1=Day
2=Evening
3=Night
A=Any
C=Compressed
N=Not Applicable
R=Rotating
10 REG_TEMP Character(1) VARCHAR2(1) NOT NULL Regular/Temporary
R=Regular
T=Temporary
11 FULL_PART_TIME Character(1) VARCHAR2(1) NOT NULL Full/Part Time
D=On Demand
F=Full-Time
P=Part-Time
12 COMPANY Character(3) VARCHAR2(3) NOT NULL Company
13 SAL_ADMIN_PLAN Character(4) VARCHAR2(4) NOT NULL Salary Administration Plan
14 GRADE Character(3) VARCHAR2(3) NOT NULL Salary Grade
15 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
16 REG_REGION Character(5) VARCHAR2(5) NOT NULL Regulatory Region
17 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
18 GVT_POI Character(4) VARCHAR2(4) NOT NULL Personnel Office ID
19 GVT_POSN_OCCUPIED Character(1) VARCHAR2(1) NOT NULL Position Occupied
1=Competitive
2=Excepted
3=SES General
4=SES Career Reserved
20 GVT_LEO_POSITION Character(1) VARCHAR2(1) NOT NULL LEO/Fire Position
5=5USC 5305 LEO
C=D.C. Police Forces
F=Fire Fighter
N=Not Applicable
P=Primary FEPCA
S=Secondary FEPCA
21 GVT_PAY_PLAN Character(2) VARCHAR2(2) NOT NULL Pay Plan
22 COUNTRY_CODE Character(3) VARCHAR2(3) NOT NULL Country Code
23 PHONE Character(24) VARCHAR2(24) NOT NULL Telephone
24 BUSINESS_UNIT2 Character(5) VARCHAR2(5) NOT NULL Business Unit
25 REPORTS_TO Character(8) VARCHAR2(8) NOT NULL Reports To Position Number
26 DEPTID Character(10) VARCHAR2(10) NOT NULL Department