| # |
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
|