UPG801JOBTMP

(SQL Table)
Index Back

Upgrade Alt Overtime Job

Upgrade Alternative Overtime Job FLSA status

# 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 Rcd Nbr
3 EFFDT Date(10) DATE Effective Date

Default Value: %date

4 EFFSEQ Number(3,0) SMALLINT NOT NULL Effective Sequence
5 DEPTID Character(10) VARCHAR2(10) NOT NULL Department
6 JOBCODE Character(6) VARCHAR2(6) NOT NULL Job Code
7 POSITION_NBR Character(8) VARCHAR2(8) NOT NULL Position Number
8 APPT_TYPE Character(1) VARCHAR2(1) NOT NULL This field tracks whether a row is a Main Appointment (which all rows outside Japan are), or an Additional Appointment, which is a feature only used by Japanese customers.
0=Core Appointment
1=Japan Kenmu Appointment
2=French Public Sector Appt
3=Staffing
9 MAIN_APPT_NUM_JPN Number(3,0) SMALLINT NOT NULL Tracks the empl_rcd for the Main Appointment of this row. For a Main Appointment, this field stores the same value as the current empl_rcd, for an Additional Appointment, it stores the value of a different empl_rcd.
10 POSITION_OVERRIDE Character(1) VARCHAR2(1) NOT NULL Override Position Data
11 POSN_CHANGE_RECORD Character(1) VARCHAR2(1) NOT NULL Position Management Record
12 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
13 ACTION Character(3) VARCHAR2(3) NOT NULL Action
14 ACTION_DT Date(10) DATE Action Date
15 ACTION_REASON Character(3) VARCHAR2(3) NOT NULL Reason Code
16 LOCATION Character(10) VARCHAR2(10) NOT NULL Location Code
17 TAX_LOCATION_CD Character(10) VARCHAR2(10) NOT NULL Tax Location Code
18 JOB_ENTRY_DT Date(10) DATE Job Entry Date
19 DEPT_ENTRY_DT Date(10) DATE Department Entry Date
20 POSITION_ENTRY_DT Date(10) DATE Position Entry Date
21 SHIFT Character(1) VARCHAR2(1) NOT NULL Regular Shift
1=1
2=2
3=3
A=Any
C=Compressed
N=Not Applicable
R=Rotating
22 REG_TEMP Character(1) VARCHAR2(1) NOT NULL Regular/Temporary
R=Regular
T=Temporary
23 FULL_PART_TIME Character(1) VARCHAR2(1) NOT NULL Full/Part Time
D=On Demand
F=Full-Time
P=Part-Time
24 COMPANY Character(3) VARCHAR2(3) NOT NULL Company
25 PAYGROUP Character(3) VARCHAR2(3) NOT NULL Pay Group
26 BAS_GROUP_ID Character(3) VARCHAR2(3) NOT NULL Identifies a user-defined Benefits Administration group used to facilitate benefits processing. A group can represent the entire participant population of the enterprise, or a specific group of participants. It enables you to control processing by, for example, setting up separate Open Enrollment schedules for each group. If used, a BAS Group ID is assigned to each participant in a benefit program.
27 ELIG_CONFIG1 Character(10) VARCHAR2(10) NOT NULL This field is simply an unformatted and unvalidated character field which can be used to specify special benefits eligibility parameters for the employee, when the built-in eligibility rules are insufficient. This is one of nine similar fields.
28 ELIG_CONFIG2 Character(10) VARCHAR2(10) NOT NULL This field is simply an unformatted and unvalidated character field which can be used to specify special benefits eligibility parameters for the employee, when the built-in eligibility rules are insufficient. This is one of nine similar fields.
29 ELIG_CONFIG3 Character(10) VARCHAR2(10) NOT NULL This field is simply an unformatted and unvalidated character field which can be used to specify special benefits eligibility parameters for the employee, when the built-in eligibility rules are insufficient. This is one of nine similar fields.
30 ELIG_CONFIG4 Character(10) VARCHAR2(10) NOT NULL This field is simply an unformatted and unvalidated character field which can be used to specify special benefits eligibility parameters for the employee, when the built-in eligibility rules are insufficient. This is one of nine similar fields.
31 ELIG_CONFIG5 Character(10) VARCHAR2(10) NOT NULL This field is simply an unformatted and unvalidated character field which can be used to specify special benefits eligibility parameters for the employee, when the built-in eligibility rules are insufficient. This is one of nine similar fields.
32 ELIG_CONFIG6 Character(10) VARCHAR2(10) NOT NULL This field is simply an unformatted and unvalidated character field which can be used to specify special benefits eligibility parameters for the employee, when the built-in eligibility rules are insufficient. This is one of nine similar fields.
33 ELIG_CONFIG7 Character(10) VARCHAR2(10) NOT NULL This field is simply an unformatted and unvalidated character field which can be used to specify special benefits eligibility parameters for the employee, when the built-in eligibility rules are insufficient. This is one of nine similar fields.
34 ELIG_CONFIG8 Character(10) VARCHAR2(10) NOT NULL This field is simply an unformatted and unvalidated character field which can be used to specify special benefits eligibility parameters for the employee, when the built-in eligibility rules are insufficient. This is one of nine similar fields.
35 ELIG_CONFIG9 Character(10) VARCHAR2(10) NOT NULL This field is simply an unformatted and unvalidated character field which can be used to specify special benefits eligibility parameters for the employee, when the built-in eligibility rules are insufficient. This is one of nine similar fields.
36 BEN_STATUS Character(4) VARCHAR2(4) NOT NULL Specifies an employee's status relative to benefits, and is used to determine eligibility for benefits. Some examples of benefit status are Active, Suspended, Leave with Benefits, and Terminated.
A=Active
D=Deceased
L=Leave of Absence
P=Leave With Benefits
Q=Retired With Benefits
R=Retired
S=Suspended
T=Terminated
U=Terminated With Benefits
37 BAS_ACTION Character(3) VARCHAR2(3) NOT NULL Identifies a benefits-related process or event that is associated with a personnel action action reason combination. This provides the link between various personnel changes (both job-related and personal) and benefits eligibility. A BAS (PeopleSoft Benefits Administration System) action may correspond to a BAS Event Class, which defines how a benefits-related event is recognized and handled. Some examples of BAS actions (and event classes) are Hire, Family Status Change, and Open Enrollment.
38 COBRA_ACTION Character(3) VARCHAR2(3) NOT NULL Identifies a COBRA-related process or event that is associated with a personnel action action reason combination. This provides the link between various personnel changes (both job-related and personal) and COBRA benefits eligibility. A COBRA action may correspond to a COBRA event classification, which defines how a qualifying event is recognized and handled. Some examples of COBRA actions (and qualifying events) are Death, Divorce, Medicare, and Military Leave. U.S. only.
39 EMPL_TYPE Character(1) VARCHAR2(1) NOT NULL Employee Type
E=Exception Hourly
H=Hourly
N=Not Applicable
S=Salaried
40 HOLIDAY_SCHEDULE Character(6) VARCHAR2(6) NOT NULL Holiday Schedule
41 STD_HOURS Number(7,2) DECIMAL(6,2) NOT NULL Standard Hours
42 STD_HRS_FREQUENCY Character(5) VARCHAR2(5) NOT NULL Standard Work Period
43 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
44 EMPL_CLASS Character(3) VARCHAR2(3) NOT NULL Employee Classification
45 SAL_ADMIN_PLAN Character(4) VARCHAR2(4) NOT NULL Salary Administration Plan
46 GRADE Character(3) VARCHAR2(3) NOT NULL Salary Grade
47 GRADE_ENTRY_DT Date(10) DATE Grade Entry Date
48 STEP Number(2,0) SMALLINT NOT NULL Step
49 STEP_ENTRY_DT Date(10) DATE Step Entry Date
50 GL_PAY_TYPE Character(6) VARCHAR2(6) NOT NULL General Ledger Pay Type
51 ACCT_CD Character(25) VARCHAR2(25) NOT NULL Combination Code
52 EARNS_DIST_TYPE Character(1) VARCHAR2(1) NOT NULL Earnings Distribution Type
A=By Amount
H=By Hours
N=None
P=By Percent
53 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
54 COMPRATE Number(19,6) DECIMAL(18,6) NOT NULL Compensation Rate
55 CHANGE_AMT Signed Number(20,6) DECIMAL(18,6) NOT NULL Change Amount
56 CHANGE_PCT Signed Number(8,3) DECIMAL(6,3) NOT NULL Change Percent
57 ANNUAL_RT Number(19,3) DECIMAL(18,3) NOT NULL Annual Rate
58 MONTHLY_RT Number(19,3) DECIMAL(18,3) NOT NULL Monthly Rate
59 DAILY_RT Number(19,3) DECIMAL(18,3) NOT NULL Daily Rate
60 HOURLY_RT Number(19,6) DECIMAL(18,6) NOT NULL Hourly Rate
61 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.
62 SHIFT_RT Number(19,6) DECIMAL(18,6) NOT NULL Shift Differential Rate
63 SHIFT_FACTOR Number(5,3) DECIMAL(4,3) NOT NULL Shift Differential Factor
64 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code
65 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
66 SETID_DEPT Character(5) VARCHAR2(5) NOT NULL Department SetID
67 SETID_JOBCODE Character(5) VARCHAR2(5) NOT NULL Job Code SetID
68 SETID_LOCATION Character(5) VARCHAR2(5) NOT NULL Location SetID
69 SETID_SALARY Character(5) VARCHAR2(5) NOT NULL Salary SetID
70 REG_REGION Character(5) VARCHAR2(5) NOT NULL Regulatory Region
71 DIRECTLY_TIPPED Character(1) VARCHAR2(1) NOT NULL Tipped
D=Directly Tipped
I=Indirectly Tipped
N=Not Tipped
72 FLSA_STATUS Character(1) VARCHAR2(1) NOT NULL FLSA Status field
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

Default Value: X

73 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

Default Value: N

74 FUNCTION_CD Character(2) VARCHAR2(2) NOT NULL Function Code

Prompt Table: FUNCTION_CD_TBL

75 TARIFF_GER Character(2) VARCHAR2(2) NOT NULL Tariff
01=Metal Processing
02=Banking
03=Building and Civil Engineering
04=Clothing Industry
05=Chemical Industry
06=Printing Industry
07=Retail Trade
08=Fossil Oil and Gas Extraction
09=Glass Industry
10=Wholesale and Foreign Trade
11=Wood Processing
12=Rubber Processing
13=Ceramics
14=Agriculture
15=Leather Processing
16=Public Sector
17=Paper Industry
18=Paper Processing
19=Sawing Industry
20=German Seaports
21=Hard-Coal Mining
22=Textile Industry
23=Insurance
24=Housing Industry
25=Periodical Publishers
26=Newspaper Publishers
27=Tobacco Industry
76 TARIFF_AREA_GER Character(3) VARCHAR2(3) NOT NULL Tariff Area

Prompt Table: TARIFF_AREA_GER

77 PERFORM_GROUP_GER Character(2) VARCHAR2(2) NOT NULL Performance Group
A1=Blue Collar Performance Grp. 1
A2=Blue Collar Performance Grp. 2
A3=Blue Collar Performance Grp. 3
K1=Commercial White Collar Grp. 1
K2=Commercial White Collar Grp. 2
K3=Commercial White Collar Grp. 3
K4=Commercial White Collar Grp. 4
K5=Commerical White Collar Grp. 5
T1=Technical White Collar Grp. 1
T2=Technical White Collar Grp. 2
T3=Technical White Collar Grp. 3
T4=Technical White Collar Grp. 4
T5=Technical White Collar Grp. 5
78 LABOR_TYPE_GER Character(1) VARCHAR2(1) NOT NULL Labor Type
M=Management
N=Non-Management
79 SPK_COMM_ID_GER Character(9) VARCHAR2(9) NOT NULL Spokesmen Committee ID

Prompt Table: SPK_COMM_GER

80 HOURLY_RT_FRA Character(3) VARCHAR2(3) NOT NULL Hours Type

Prompt Table: HOURS_TYPE_FRA

81 ACCDNT_CD_FRA Character(1) VARCHAR2(1) NOT NULL Work Accident Type Code
0=Do not Pay
1=Building
2=Waterproofing
3=Floor Surface
4=Factory Making
5=Laboratory
6=WorkShop
7=Office
82 VALUE_1_FRA Character(5) VARCHAR2(5) NOT NULL Value 1
83 VALUE_2_FRA Character(5) VARCHAR2(5) NOT NULL Value 2
84 VALUE_3_FRA Character(5) VARCHAR2(5) NOT NULL Value 3
85 VALUE_4_FRA Character(5) VARCHAR2(5) NOT NULL Value 4
86 VALUE_5_FRA Character(5) VARCHAR2(5) NOT NULL Value 5
87 CTG_RATE Number(3,0) SMALLINT NOT NULL Category Rate
88 PAID_HOURS Number(7,2) DECIMAL(6,2) NOT NULL Paid Hours
89 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.
90 PAID_HRS_FREQUENCY Character(5) VARCHAR2(5) NOT NULL Paid Work Period

Prompt Table: STDHRS_FREQ_VW

91 GVT_EFFDT Date(10) DATE Effective Date
92 GVT_EFFDT_PROPOSED Date(10) DATE Proposed Effective Date
93 GVT_TRANS_NBR Number(1,0) SMALLINT NOT NULL Transaction #
94 GVT_TRANS_NBR_SEQ Number(1,0) SMALLINT NOT NULL Sequence
95 GVT_WIP_STATUS Character(3) VARCHAR2(3) NOT NULL Work-in-Progress Status
96 GVT_STATUS_TYPE Character(3) VARCHAR2(3) NOT NULL Status Type
CAN=Cancelled
COM=Completed
COR=Corrected
IRR=IRR Reported
WIP=Work-in-progress
97 GVT_NOA_CODE Character(3) VARCHAR2(3) NOT NULL Nature of Action Code
98 GVT_LEG_AUTH_1 Character(3) VARCHAR2(3) NOT NULL Legal Authority (1)
99 GVT_PAR_AUTH_D1 Character(25) VARCHAR2(25) NOT NULL Authority 1 Descr - Part 1
100 GVT_PAR_AUTH_D1_2 Character(25) VARCHAR2(25) NOT NULL Authority 1 Descr - Part 2
101 GVT_LEG_AUTH_2 Character(3) VARCHAR2(3) NOT NULL Legal Authority (2)
102 GVT_PAR_AUTH_D2 Character(25) VARCHAR2(25) NOT NULL Authority 2 Descr - Part 1
103 GVT_PAR_AUTH_D2_2 Character(25) VARCHAR2(25) NOT NULL Authority 2 Descr - Part 2
104 GVT_PAR_NTE_DATE Date(10) DATE Not To Exceed Date
105 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
S=Part-Time Job Sharer
T=Part-Time Seasonal Job Sharer
106 GVT_SUB_AGENCY Character(2) VARCHAR2(2) NOT NULL Sub-Agency
107 GVT_ELIG_FEHB Character(3) VARCHAR2(3) NOT NULL Eligible for FEHB
CC=Continuing Coverage
NE=Not Eligible
PER=Permanent
TAP=Temporary Appointment > 1 yr
TSV=Temp Appt < 1yr + FedSvc > 1yr
108 GVT_FEHB_DT Date(10) DATE FEHB Eligibility Date
109 GVT_PAY_RATE_DETER Character(1) VARCHAR2(1) NOT NULL Pay Rate Determinant
0=Regular Rate
2=Saved Rate - Indefinite
3=Retained Pay - Spec Rt Adjust
4=Saved Rate - Other
5=Special & Superior Quals
6=Special Rate
7=Superior Qualifications Rate
A=Retained Grade - Diff Posn
B=Retained Grade - Same Posn
C=Critical Position Pay
E=Rtnd Grd & Spec Rt - Diff Posn
F=Rtnd Grd & Spec Rt - Same Posn
J=Retained Pay - Same Position
K=Retained Pay - Diff Posn
M=Continued IGA Pay
P=Preserved IGA Pay
R=Retained Pay - SES Removal
S=Continued SES Basic Pay
U=Rtnd Grade & Pay - Same Posn
V=Rtnd Grade & Pay - Diff Posn
110 GVT_STEP Character(2) VARCHAR2(2) NOT NULL US Federal Step
111 GVT_RTND_PAY_PLAN Character(2) VARCHAR2(2) NOT NULL Retained Pay Plan
112 GVT_RTND_SAL_PLAN Character(4) VARCHAR2(4) NOT NULL Retained Pay Table
113 GVT_RTND_GRADE Character(3) VARCHAR2(3) NOT NULL Retained Grade
114 GVT_RTND_STEP Number(2,0) SMALLINT NOT NULL Retained Step
115 GVT_RTND_GVT_STEP Character(2) VARCHAR2(2) NOT NULL Retained US Federal Step
116 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
117 GVT_COMPRATE Number(19,6) DECIMAL(18,6) NOT NULL Base Pay
118 GVT_LOCALITY_ADJ Number(8,2) DECIMAL(7,2) NOT NULL Locality Adjustment
119 GVT_BIWEEKLY_RT Number(10,2) DECIMAL(9,2) NOT NULL Biweekly Rate
120 GVT_DAILY_RT Number(10,2) DECIMAL(9,2) NOT NULL Daily Rate
121 GVT_HRLY_RT_NO_LOC Number(19,6) DECIMAL(18,6) NOT NULL Hourly Rate with out Location
122 GVT_DLY_RT_NO_LOC Number(10,2) DECIMAL(9,2) NOT NULL Daily Rate No Locality
123 GVT_BW_RT_NO_LOC Number(10,2) DECIMAL(9,2) NOT NULL No Locality Biweekly Rate
124 GVT_MNLY_RT_NO_LOC Number(19,3) DECIMAL(18,3) NOT NULL No Locality Monthly Rate
125 GVT_ANNL_RT_NO_LOC Number(19,3) DECIMAL(18,3) NOT NULL No Locality Annual Rate
126 GVT_XFER_FROM_AGCY Character(2) VARCHAR2(2) NOT NULL Transferred From Agency
127 GVT_XFER_TO_AGCY Character(2) VARCHAR2(2) NOT NULL Transferred To Agency
128 GVT_RETIRE_PLAN Character(2) VARCHAR2(2) NOT NULL Retirement Plan
129 GVT_ANN_IND Character(1) VARCHAR2(1) NOT NULL Annuitant Indicator
1=Reempl Ann-CS
2=Ret Officer
3=Ret Enlisted
4=Ret Off/Reempl Ann-CS
5=Ret Enl/Reempl Ann-CS
6=CS-No Reduction
7=Ret Off/CS-No Reduc
8=Ret Enl/CS-No Reduc
9=Not Applicable
A=Reempl Ann-FE
B=Former Ann-FE
C=Ret Off/Reempl Ann-FE
D=Ret Off/Former Ann-FE
E=Ret Enl/Reempl Ann-FE
F=Ret Enl/Former Ann-FE
G=FE - No Reduction
H=Ret Off/FE-No Reduc
J=Ret Enl/FE-No Reduc
130 GVT_FEGLI Character(2) VARCHAR2(2) NOT NULL FEGLI Code
131 GVT_FEGLI_LIVING Character(1) VARCHAR2(1) NOT NULL FEGLI Living Benefits
132 GVT_LIVING_AMT Number(8,0) INTEGER NOT NULL Living Benefit Coverage Amount
133 GVT_ANNUITY_OFFSET Number(8,0) INTEGER NOT NULL CSRS Annuity Offset Amount
134 GVT_CSRS_FROZN_SVC Character(4) VARCHAR2(4) NOT NULL CSRS Frozen Service
135 GVT_PREV_RET_COVRG Character(1) VARCHAR2(1) NOT NULL Previous Retirement Coverage
N=Never Covered
P=Previously Covered
136 GVT_FERS_COVERAGE Character(1) VARCHAR2(1) NOT NULL FERS Coverage
A=Automatically Covered By FERS
E=Elected Coverage Under FERS
N=Not Covered By FERS
137 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)
138 GVT_POI Character(4) VARCHAR2(4) NOT NULL Personnel Office ID
139 GVT_POSN_OCCUPIED Character(1) VARCHAR2(1) NOT NULL Position Occupied
1=Competitive
2=Excepted
3=SES General
4=SES Career Reserved
140 GVT_CONT_EMPLID Character(11) VARCHAR2(11) NOT NULL Contact Emplid
141 GVT_ROUTE_NEXT Character(11) VARCHAR2(11) NOT NULL Route to Next
142 GVT_CHANGE_FLAG Character(1) VARCHAR2(1) NOT NULL Change Flag
143 GVT_TSP_UPD_IND Character(1) VARCHAR2(1) NOT NULL TSP Status
N=Not Ready to Process
P=Processed
R=Ready to Process
144 GVT_PI_UPD_IND Character(1) VARCHAR2(1) NOT NULL PI upd ind
A=Applied at NFC
I=Auto Action Inserted
N=Not Ready to Process
P=In Process
R=Ready To Process
S=SINQ Error
Z=Other
145 GVT_SF52_NBR Character(10) VARCHAR2(10) NOT NULL SF-52 Request Number
146 GVT_S113G_CEILING Character(1) VARCHAR2(1) NOT NULL SF-113G Ceiling
147 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
148 GVT_ANNUIT_COM_DT Date(10) DATE Annuity Commencement Date
149 GVT_BASIC_LIFE_RED Character(2) VARCHAR2(2) NOT NULL Federal Field
0=No Reduction
50=50% Reduction
75=75% Reduction
N=None
150 GVT_DED_PRORT_DT Date(10) DATE 4 Day Date
151 GVT_FEGLI_BASC_PCT Number(8,6) DECIMAL(7,6) NOT NULL FEGLI Basic Percent
152 GVT_FEGLI_OPT_PCT Number(8,6) DECIMAL(7,6) NOT NULL FEGLI Optional Percent
153 GVT_FEHB_PCT Number(8,6) DECIMAL(7,6) NOT NULL FEHB %
154 GVT_RETRO_FLAG Character(1) VARCHAR2(1) NOT NULL Retro Pay Flag
155 GVT_RETRO_DED_FLAG Character(1) VARCHAR2(1) NOT NULL Retro Ded Flag
156 GVT_RETRO_JOB_FLAG Character(1) VARCHAR2(1) NOT NULL Retro Job Flag
157 GVT_RETRO_BSE_FLAG Character(1) VARCHAR2(1) NOT NULL Retro Base Flag
158 GVT_OTH_PAY_CHG Character(1) VARCHAR2(1) NOT NULL Other Pay Change Flag
159 GVT_DETL_POSN_NBR Character(8) VARCHAR2(8) NOT NULL GVT Detail Position Number
160 ANNL_BEN_BASE_OVRD Character(1) VARCHAR2(1) NOT NULL Annl Benefit Base Rt Override
161 BENEFIT_PROGRAM Character(3) VARCHAR2(3) NOT NULL Defines a collection of benefit plans and their associated rate and calculation rules.
162 UPDATE_PAYROLL Character(1) VARCHAR2(1) NOT NULL Update Payroll Flags
163 GVT_PAY_PLAN Character(2) VARCHAR2(2) NOT NULL Pay Plan
164 GVT_PAY_FLAG Character(1) VARCHAR2(1) NOT NULL GVT_PAY_FLAG
165 GVT_NID_CHANGE Character(1) VARCHAR2(1) NOT NULL GVT_NID_CHANGE
166 UNION_FULL_PART Character(1) VARCHAR2(1) NOT NULL Union Participation
F=Full Time
P=Part Time
167 UNION_POS Character(1) VARCHAR2(1) NOT NULL Union Position
L=Leader of the union
N=National Leader
R=Registered
S=Leader of S.O.C.
168 MATRICULA_NBR Number(5,0) INTEGER NOT NULL Matricula Number
169 SOC_SEC_RISK_CODE Character(3) VARCHAR2(3) NOT NULL Occupation Code

Prompt Table: %EDITTABLE12

170 UNION_FEE_AMOUNT Number(9,2) DECIMAL(8,2) NOT NULL Union Fee Amount
171 UNION_FEE_START_DT Date(10) DATE Union Fee Start Date
172 UNION_FEE_END_DT Date(10) DATE Union Fee End Date
173 EXEMPT_JOB_LBR Character(1) VARCHAR2(1) NOT NULL Exempted

Y/N Table Edit

Default Value: N

174 EXEMPT_HOURS_MONTH Number(3,0) SMALLINT NOT NULL Exempted Hours per Month
175 WRKS_CNCL_FUNCTION Character(1) VARCHAR2(1) NOT NULL Works Council Function
M=Member
P=President
S=Secretary
176 INTERCTR_WRKS_CNCL Character(1) VARCHAR2(1) NOT NULL InterCtr.Works Cnil Function
1=Member 1
2=Member 2
3=Member 3
177 CURRENCY_CD1 Character(3) VARCHAR2(3) NOT NULL Currency Code

Prompt Table: CURRENCY_CD_TBL

178 PAY_UNION_FEE Character(1) VARCHAR2(1) NOT NULL Pay Union Fee

Y/N Table Edit

Default Value: N

179 UNION_CD Character(3) VARCHAR2(3) NOT NULL Union Code

Prompt Table: UNION_TBL

180 BARG_UNIT Character(4) VARCHAR2(4) NOT NULL Bargaining Unit
1=Bargaining Unit 1
2=Bargaining Unit 2

Prompt Table: HR_BARG_UNIT

181 UNION_SENIORITY_DT Date(10) DATE Union Seniority Date
182 ENTRY_DATE Date(10) DATE Date Entered
183 LABOR_AGREEMENT Character(6) VARCHAR2(6) NOT NULL Labor Agreement

Prompt Table: HR_LABOR_AGRMNT

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

Prompt Table: EMPL_CTG_L1_VW

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

Prompt Table: EMPL_CTG_L2_VW

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

Prompt Table: EMPL_CTG_L3_VW

187 SETID_LBR_AGRMNT Character(5) VARCHAR2(5) NOT NULL Labor Agreement SetID
188 WPP_STOP_FLAG Character(1) VARCHAR2(1) NOT NULL Y/N Flag to indicated that Wage Progression is stopped on this Assignment.

Y/N Table Edit

Default Value: N

189 LABOR_FACILITY_ID Character(10) VARCHAR2(10) NOT NULL Labor Facility ID

Prompt Table: HR_LBR_FAC_VW

190 LBR_FAC_ENTRY_DT Date(10) DATE Date the Person was added to this Labor Facility.
191 LAYOFF_EXEMPT_FLAG Character(1) VARCHAR2(1) NOT NULL Y/N Flag to indicate if a Person's Assignment is exempt from Layoff.

Y/N Table Edit

Default Value: N

192 LAYOFF_EXEMPT_RSN Character(11) VARCHAR2(11) NOT NULL Reason for the Exemption from Layoff

Prompt Table: HR_LAY_EXEM_TBL

193 GP_PAYGROUP Character(10) VARCHAR2(10) NOT NULL Global Payroll pay group

Prompt Table: %EDITTABLE6

194 GP_DFLT_ELIG_GRP Character(1) VARCHAR2(1) NOT NULL Y/N assign default value from Pay Group (as opposed to assigning value at the payee / job level)

Y/N Table Edit

Default Value: Y

195 GP_ELIG_GRP Character(10) VARCHAR2(10) NOT NULL Eligibility Group

Prompt Table: GP_ELIG_GRP

196 GP_DFLT_CURRTTYP Character(1) VARCHAR2(1) NOT NULL Y/N assign default value from Pay Group (as opposed to assigning value at the payee / job level)

Y/N Table Edit

Default Value: Y

197 CUR_RT_TYPE Character(5) VARCHAR2(5) NOT NULL Currency Rate Type

Prompt Table: RT_TYPE_TBL

198 GP_DFLT_EXRTDT Character(1) VARCHAR2(1) NOT NULL Y/N assign default value from Pay Group (as opposed to assigning value at the payee / job level)

Y/N Table Edit

Default Value: Y

199 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
200 ADDS_TO_FTE_ACTUAL Character(1) VARCHAR2(1) NOT NULL Adds to FTE Actual Count
201 CLASS_INDC Character(1) VARCHAR2(1) NOT NULL Classified/Unclassified Indc
B=All
C=Classified
T=Temporary
U=Unclassified
202 ENCUMB_OVERRIDE Character(1) VARCHAR2(1) NOT NULL Encumbrance Override
203 FICA_STATUS_EE Character(1) VARCHAR2(1) NOT NULL FICA Status-Employee
E=Exempt
H=ER FICA Exmpt
M=Medicare only
N=Subject
204 FTE Number(8,6) DECIMAL(7,6) NOT NULL This field represent Full Time Equivalence
205 PRORATE_CNT_AMT Character(1) VARCHAR2(1) NOT NULL Prorate Contract Change Amount
C=Prorate Over Contract Period
N=No Proration of Change Amt.
P=Prorate over Payment Period
206 PAY_SYSTEM_FLG Character(2) VARCHAR2(2) NOT NULL Payroll System
GP=Global Payroll
NA=Payroll for North America
OT=Other
PI=Payroll Interface
207 BORDER_WALKER Character(1) VARCHAR2(1) NOT NULL Cross Border Worker
208 LUMP_SUM_PAY Character(1) VARCHAR2(1) NOT NULL Lump Sum Retro Payment
209 CONTRACT_NUM Character(25) VARCHAR2(25) NOT NULL Contract Number
210 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
211 WRKS_CNCL_ROLE_CHE Character(30) VARCHAR2(30) NOT NULL Work Council Role
212 BENEFIT_SYSTEM Character(2) VARCHAR2(2) NOT NULL A flag that indicates whether the benefits for an employee are administered under PeopleSoft Benefits Administration or PeopleSoft Base Benefits.
BA=Benefits Administration
BN=Base Benefits
OT=Not Managed in PeopleSoft
213 WORK_DAY_HOURS Number(7,2) DECIMAL(6,2) NOT NULL Number of Hours in a Work Day
214 SUPERVISOR_ID Character(11) VARCHAR2(11) NOT NULL Supervisor ID
215 REPORTS_TO Character(8) VARCHAR2(8) NOT NULL Reports To Position Number
216 FORCE_PUBLISH Date(10) DATE Used to Force a publish on a row of data that wouldn't otherwise have been changed. This field is a system field only and will not appear on any Page so it does not need to be translated.
217 JOB_DATA_SRC_CD Character(3) VARCHAR2(3) NOT NULL This field indicates the source of a job row ie. whether the job row was User Generated (ie. online), Batch Generated, Staff Movement generated, etc. A blank in this field implies that the job row is user generated.
000=User Generated
001=Batch Generated
002=Staff Movement Generated
218 ESTABID Character(12) VARCHAR2(12) NOT NULL Establishment ID
219 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
220 HR_STATUS Character(1) VARCHAR2(1) NOT NULL HR Status
A=Active
I=Inactive
221 SUPV_LVL_ID Character(8) VARCHAR2(8) NOT NULL Supervisor Level ID for use in capability grade system
222 SETID_SUPV_LVL Character(5) VARCHAR2(5) NOT NULL Stored setid for the Supervisor Level.
223 ABSENCE_SYSTEM_CD Character(3) VARCHAR2(3) NOT NULL What Absence System this Assignment is tied to.
AM=Absence Management
OT=Other
224 POI_TYPE Character(5) VARCHAR2(5) NOT NULL Defines the Transactional usage of POIs in HRMS.
225 HIRE_DT Date(10) DATE First Start Date
226 LAST_HIRE_DT Date(10) DATE Latest Start Date - The latest time that an Employee or a Contingent Worker has started - based on EMPLID/EMPL_RCD.
227 TERMINATION_DT Date(10) DATE Termination Date
228 ASGN_START_DT Date(10) DATE Start date of the specific EMPL_RCD assignment. This is different from the Person's Hire date.
229 LST_ASGN_START_DT Date(10) DATE Lastest start date of the specific EMPL_RCD assignment. This is different from the Person's organizational instance Last Hire Date.
230 ASGN_END_DT Date(10) DATE End date of the specific EMPL_RCD assignment. This is different from the Person's Termination date.
231 LDW_OVR Character(1) VARCHAR2(1) NOT NULL Used to indicate whether the user has overridden the Last Date Worked - ON THIS JOB_DATES row. It will only be set to 'Y' on the row where the date is entered, it will be 'N' on the later rows. This allows us to identify which JOB_DATES row is the row where the Date was either set or updated without having to look at the previous row. If the LDW = ( EFFDT - 1 ) or the LDW_OVR is 'Y', then this is the row where the LDW was set - and therefore can be corrected.

Y/N Table Edit

Default Value: N

232 LAST_DATE_WORKED Date(10) DATE Last Date Worked
233 EXPECTED_RETURN_DT Date(10) DATE Expected Return Date
234 EXPECTED_END_DATE Date(10) DATE Expected End Date of a job.
235 AUTO_END_FLG Character(1) VARCHAR2(1) NOT NULL This field is on the Job page and it allows the users to indicate whether they want the system to automatically end this job on the Expected End Date of the job. This field is dependent on the Expected End Date having a value.

Y/N Table Edit

Default Value: N

236 LASTUPDDTTM DateTime(26) TIMESTAMP Specifies the date and time of the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.
237 LASTUPDOPRID Character(30) VARCHAR2(30) NOT NULL Specifies the User ID which made the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.
238 SALARY_MATRIX_CD Character(5) VARCHAR2(5) NOT NULL Salary Matrix Code
239 RATING_SCALE Character(4) VARCHAR2(4) NOT NULL Rating Scale
240 REVIEW_RATING Character(1) VARCHAR2(1) NOT NULL Review Rating
241 REVIEW_DT Date(10) DATE Review Date
242 WRKS_CNCL_MEM_GER Character(3) VARCHAR2(3) NOT NULL Works Council Member
243 INAIL_CODE Character(11) VARCHAR2(11) NOT NULL INAIL Code
244 UNITA_PROD_CD Character(6) VARCHAR2(6) NOT NULL Productive Unit
245 ACTION_ITA Character(3) VARCHAR2(3) NOT NULL Turnover - Action
HIR=Hire
LAY=Lay off
LEA=Leave of Absence
TER=Termination
246 ACTION_REASON_ITA Character(3) VARCHAR2(3) NOT NULL Turnover Action Reason
247 WRKS_CNCL_ID_LCL Character(9) VARCHAR2(9) NOT NULL Works Council ID