| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 EMPLID |
Character(11) |
VARCHAR2(11) NOT NULL |
Employee ID
Default Value: NEW
Prompt Table:
PERSONAL_DATA
|
| 2 |
EMPL_RCD |
Number(3,0) |
SMALLINT NOT NULL |
Empl Rcd Nbr
|
| 3 |
EFFDT |
Date(10) |
DATE NOT NULL |
Effective Date
Default Value: %date
|
| 4 |
EFFSEQ |
Number(3,0) |
SMALLINT NOT NULL |
Effective Sequence
|
| 5 |
BUSINESS_UNIT |
Character(5) |
VARCHAR2(5) NOT NULL |
Business Unit
Prompt Table:
SP_BURSHR_NONVW
|
| 6 |
DEPTID |
Character(10) |
VARCHAR2(10) NOT NULL |
Department
Prompt Table:
DEPTID_NB_VW
|
| 7 |
JOBCODE |
Character(6) |
VARCHAR2(6) NOT NULL |
Job Code
Prompt Table:
JOBCODE_TBL
|
| 8 |
POSITION_NBR |
Character(8) |
VARCHAR2(8) NOT NULL |
Position Number
Prompt Table:
POSITION_DATA
|
| 9 |
POSITION_OVERRIDE |
Character(1) |
VARCHAR2(1) NOT NULL |
Position Data Override
Y/N Table Edit
Default Value: N
|
| 10 |
POSN_CHANGE_RECORD |
Character(1) |
VARCHAR2(1) NOT NULL |
Position Management Record
Y/N Table Edit
Default Value: N
|
| 11 |
EMPL_STATUS |
Character(1) |
VARCHAR2(1) NOT NULL |
Employee Status
A=Active
D=Deceased
I=Inactive
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
Default Value: A
|
| 12 |
ACTION |
Character(3) |
VARCHAR2(3) NOT NULL |
Action
|
| 13 |
ACTION_DT |
Date(10) |
DATE |
Action Date
Default Value: %date
|
| 14 |
ACTION_REASON |
Character(3) |
VARCHAR2(3) NOT NULL |
Reason Code
Prompt Table:
ACTN_REASON_TBL
|
| 15 |
LOCATION |
Character(10) |
VARCHAR2(10) NOT NULL |
Location Code
Prompt Table:
LOCATION_TBL
|
| 16 |
TAX_LOCATION_CD |
Character(10) |
VARCHAR2(10) NOT NULL |
Tax Location Code
Prompt Table:
%RECNAME_EDIT
|
| 17 |
JOB_ENTRY_DT |
Date(10) |
DATE |
Job Entry Date
|
| 18 |
DEPT_ENTRY_DT |
Date(10) |
DATE |
Department Entry Date
|
| 19 |
POSITION_ENTRY_DT |
Date(10) |
DATE |
Position Entry Date
|
| 20 |
SHIFT |
Character(1) |
VARCHAR2(1) NOT NULL |
Regular Shift
1=1
2=2
3=3
C=Compressed
N=Not Applicable
R=Rotating
Default Value: N
|
| 21 |
REG_TEMP |
Character(1) |
VARCHAR2(1) NOT NULL |
Regular/Temporary
R=Regular
T=Temporary
Default Value: R
|
| 22 |
FULL_PART_TIME |
Character(1) |
VARCHAR2(1) NOT NULL |
Full/Part Time
F=Full-Time
P=Part-Time
Default Value: F
|
| 23 |
COMPANY |
Character(3) |
VARCHAR2(3) NOT NULL |
Company
Prompt Table:
COMPANY_TBL
|
| 24 |
PAYGROUP |
Character(3) |
VARCHAR2(3) NOT NULL |
Pay Group
|
| 25 |
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.
|
| 26 |
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.
|
| 27 |
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.
|
| 28 |
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.
|
| 29 |
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.
|
| 30 |
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.
|
| 31 |
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.
|
| 32 |
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.
|
| 33 |
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.
|
| 34 |
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.
|
| 35 |
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
|
| 36 |
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.
|
| 37 |
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.
|
| 38 |
EMPL_TYPE |
Character(1) |
VARCHAR2(1) NOT NULL |
Employee Type
E=Exception Hourly
H=Hourly
N=Not Applicable
S=Salaried
|
| 39 |
HOLIDAY_SCHEDULE |
Character(6) |
VARCHAR2(6) NOT NULL |
Holiday Schedule
Prompt Table:
RS_HOLIDAY_TBL
|
| 40 |
STD_HOURS |
Number(7,2) |
DECIMAL(6,2) NOT NULL |
Standard Hours
|
| 41 |
STD_HRS_FREQUENCY |
Character(5) |
VARCHAR2(5) NOT NULL |
Standard Work Period
Prompt Table:
STDHRS_FREQ_VW
|
| 42 |
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
Default Value: N
|
| 43 |
EMPL_CLASS |
Character(3) |
VARCHAR2(3) NOT NULL |
Employee Classification
A=Assignee
C=Consultant
E=Expatriate
G=Agency/Temp
I=Intern
P=Apprentice
R=Contractor
T=Trainee
|
| 44 |
SAL_ADMIN_PLAN |
Character(4) |
VARCHAR2(4) NOT NULL |
Salary Administration Plan
|
| 45 |
GRADE |
Character(3) |
VARCHAR2(3) NOT NULL |
Salary Grade
|
| 46 |
GRADE_ENTRY_DT |
Date(10) |
DATE |
Grade Entry Date
|
| 47 |
STEP |
Number(2,0) |
SMALLINT NOT NULL |
Step
|
| 48 |
STEP_ENTRY_DT |
Date(10) |
DATE |
Step Entry Date
|
| 49 |
GL_PAY_TYPE |
Character(6) |
VARCHAR2(6) NOT NULL |
General Ledger Pay Type
|
| 50 |
ACCT_CD |
Character(25) |
VARCHAR2(25) NOT NULL |
Account Code
Prompt Table:
%EDITTABLE
|
| 51 |
EARNS_DIST_TYPE |
Character(1) |
VARCHAR2(1) NOT NULL |
Earnings Distribution Type
A=By Amount
H=By Hours
N=None
P=By Percent
Default Value: N
|
| 52 |
SALARY_MATRIX_CD |
Character(5) |
VARCHAR2(5) NOT NULL |
Salary Matrix Code
|
| 53 |
RATING_SCALE |
Character(4) |
VARCHAR2(4) NOT NULL |
Rating Scale
|
| 54 |
REVIEW_RATING |
Character(1) |
VARCHAR2(1) NOT NULL |
Review Rating
Prompt Table:
REVW_RATING_TBL
|
| 55 |
REVIEW_DT |
Date(10) |
DATE |
Review Date
|
| 56 |
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
Prompt Table:
GM_COMP_FREQ_VW
|
| 57 |
COMPRATE |
Number(19,6) |
DECIMAL(18,6) NOT NULL |
Compensation Rate
|
| 58 |
CHANGE_AMT |
Signed Number(20,6) |
DECIMAL(18,6) NOT NULL |
Change Amount
|
| 59 |
CHANGE_PCT |
Signed Number(8,3) |
DECIMAL(6,3) NOT NULL |
Change Percent
|
| 60 |
ANNUAL_RT |
Number(19,3) |
DECIMAL(18,3) NOT NULL |
Annual Rate
|
| 61 |
MONTHLY_RT |
Number(19,3) |
DECIMAL(18,3) NOT NULL |
Monthly Rate
|
| 62 |
DAILY_RT |
Number(19,3) |
DECIMAL(18,3) NOT NULL |
Daily Rate
|
| 63 |
HOURLY_RT |
Number(19,6) |
DECIMAL(18,6) NOT NULL |
Hourly Rate
|
| 64 |
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.
|
| 65 |
SHIFT_RT |
Number(19,6) |
DECIMAL(18,6) NOT NULL |
Shift Differential Rate
|
| 66 |
SHIFT_FACTOR |
Number(5,3) |
DECIMAL(4,3) NOT NULL |
Shift Differential Factor
|
| 67 |
CURRENCY_CD |
Character(3) |
VARCHAR2(3) NOT NULL |
Currency Code
Prompt Table:
CURRENCY_CD_TBL
|
| 68 |
SETID_DEPT |
Character(5) |
VARCHAR2(5) NOT NULL |
Department SetID
Prompt Table:
SETID_TBL
|
| 69 |
SETID_JOBCODE |
Character(5) |
VARCHAR2(5) NOT NULL |
Job Code SetID
Prompt Table:
SETID_TBL
|
| 70 |
SETID_LOCATION |
Character(5) |
VARCHAR2(5) NOT NULL |
Location SetID
|
| 71 |
SETID_SALARY |
Character(5) |
VARCHAR2(5) NOT NULL |
Salary SetID
|
| 72 |
REG_REGION |
Character(5) |
VARCHAR2(5) NOT NULL |
Regulatory Region
|
| 73 |
DIRECTLY_TIPPED |
Character(1) |
VARCHAR2(1) NOT NULL |
Tipped
D=Directly Tipped
I=Indirectly Tipped
N=Not Tipped
|
| 74 |
FLSA_STATUS |
Character(1) |
VARCHAR2(1) NOT NULL |
FLSA Status
A=Administrative
E=Executive
M=Management
N=Nonexempt
O=Outside Salesperson
P=Professional
X=No FLSA Required
Default Value: X
|
| 75 |
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
|
| 76 |
FUNCTION_CD |
Character(2) |
VARCHAR2(2) NOT NULL |
Function Code
|
| 77 |
TARIFF_GER |
Character(2) |
VARCHAR2(2) NOT NULL |
Tariff
|
| 78 |
TARIFF_AREA_GER |
Character(3) |
VARCHAR2(3) NOT NULL |
Tarif Area
|
| 79 |
PERFORM_GROUP_GER |
Character(2) |
VARCHAR2(2) NOT NULL |
Performance Group
|
| 80 |
LABOR_TYPE_GER |
Character(1) |
VARCHAR2(1) NOT NULL |
Labor Type
|
| 81 |
SPK_COMM_ID_GER |
Character(9) |
VARCHAR2(9) NOT NULL |
Spokesman Committee ID
|
| 82 |
WRKS_CNCL_MEM_GER |
Character(3) |
VARCHAR2(3) NOT NULL |
Works Council Member
|
| 83 |
HOURLY_RT_FRA |
Character(3) |
VARCHAR2(3) NOT NULL |
Hours Type
|
| 84 |
ACCDNT_CD_FRA |
Character(1) |
VARCHAR2(1) NOT NULL |
Work Accident Type Code
|
| 85 |
ESTABID |
Character(12) |
VARCHAR2(12) NOT NULL |
Establishment ID
|
| 86 |
VALUE_1_FRA |
Character(5) |
VARCHAR2(5) NOT NULL |
Value 1
|
| 87 |
VALUE_2_FRA |
Character(5) |
VARCHAR2(5) NOT NULL |
Value 2
|
| 88 |
VALUE_3_FRA |
Character(5) |
VARCHAR2(5) NOT NULL |
Value 3
|
| 89 |
VALUE_4_FRA |
Character(5) |
VARCHAR2(5) NOT NULL |
Value 4
|
| 90 |
VALUE_5_FRA |
Character(5) |
VARCHAR2(5) NOT NULL |
Value 5
|
| 91 |
CTG_RATE |
Number(3,0) |
SMALLINT NOT NULL |
Category Rate
|
| 92 |
PAID_HOURS |
Number(7,2) |
DECIMAL(6,2) NOT NULL |
Paid Hours
|
| 93 |
PAID_FTE |
Number(4,2) |
DECIMAL(3,2) 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.
|
| 94 |
PAID_HRS_FREQUENCY |
Character(5) |
VARCHAR2(5) NOT NULL |
Paid Work Period
Prompt Table:
STDHRS_FREQ_VW
|
| 95 |
GVT_EFFDT |
Date(10) |
DATE |
Effective Date
|
| 96 |
GVT_EFFDT_PROPOSED |
Date(10) |
DATE |
Proposed Effective Date
Default Value: %date
|
| 97 |
GVT_TRANS_NBR |
Number(1,0) |
SMALLINT NOT NULL |
Transaction #
|
| 98 |
GVT_TRANS_NBR_SEQ |
Number(1,0) |
SMALLINT NOT NULL |
Sequence
|
| 99 |
GVT_WIP_STATUS |
Character(3) |
VARCHAR2(3) NOT NULL |
Work-in-Progress Status
|
| 100 |
GVT_STATUS_TYPE |
Character(3) |
VARCHAR2(3) NOT NULL |
Status Type
|
| 101 |
GVT_NOA_CODE |
Character(3) |
VARCHAR2(3) NOT NULL |
Nature of Action Code
|
| 102 |
GVT_LEG_AUTH_1 |
Character(3) |
VARCHAR2(3) NOT NULL |
Legal Authority (1)
|
| 103 |
GVT_PAR_AUTH_D1 |
Character(25) |
VARCHAR2(25) NOT NULL |
Authority 1 Descr - Part 1
|
| 104 |
GVT_PAR_AUTH_D1_2 |
Character(25) |
VARCHAR2(25) NOT NULL |
Authority 1 Descr - Part 2
|
| 105 |
GVT_LEG_AUTH_2 |
Character(3) |
VARCHAR2(3) NOT NULL |
Legal Authority (2)
|
| 106 |
GVT_PAR_AUTH_D2 |
Character(25) |
VARCHAR2(25) NOT NULL |
Authority 2 Descr - Part 1
|
| 107 |
GVT_PAR_AUTH_D2_2 |
Character(25) |
VARCHAR2(25) NOT NULL |
Authority 2 Descr - Part 2
|
| 108 |
GVT_PAR_NTE_DATE |
Date(10) |
DATE |
Not To Exceed Date
|
| 109 |
GVT_WORK_SCHED |
Character(1) |
VARCHAR2(1) NOT NULL |
Work Schedule
Default Value: F
|
| 110 |
GVT_SUB_AGENCY |
Character(2) |
VARCHAR2(2) NOT NULL |
Sub-Agency
|
| 111 |
GVT_ELIG_FEHB |
Character(3) |
VARCHAR2(3) NOT NULL |
Eligible for FEHB
Default Value: Y
|
| 112 |
GVT_FEHB_DT |
Date(10) |
DATE |
FEHB Eligibility Date
|
| 113 |
GVT_PAY_RATE_DETER |
Character(1) |
VARCHAR2(1) NOT NULL |
Pay Rate Determinant
Default Value: 0
|
| 114 |
GVT_STEP |
Character(2) |
VARCHAR2(2) NOT NULL |
US Federal Step
Default Value: 00
|
| 115 |
GVT_RTND_PAY_PLAN |
Character(2) |
VARCHAR2(2) NOT NULL |
Retained Pay Plan
|
| 116 |
GVT_RTND_SAL_PLAN |
Character(4) |
VARCHAR2(4) NOT NULL |
Retained Pay Table
|
| 117 |
GVT_RTND_GRADE |
Character(3) |
VARCHAR2(3) NOT NULL |
Retained Grade
|
| 118 |
GVT_RTND_STEP |
Number(2,0) |
SMALLINT NOT NULL |
Retained Step
|
| 119 |
GVT_RTND_GVT_STEP |
Character(2) |
VARCHAR2(2) NOT NULL |
Retained US Federal Step
|
| 120 |
GVT_PAY_BASIS |
Character(2) |
VARCHAR2(2) NOT NULL |
Pay Basis
Default Value: PA
|
| 121 |
GVT_COMPRATE |
Number(19,6) |
DECIMAL(18,6) NOT NULL |
Base Pay
|
| 122 |
GVT_LOCALITY_ADJ |
Number(8,2) |
DECIMAL(7,2) NOT NULL |
Locality Adjustment
|
| 123 |
GVT_BIWEEKLY_RT |
Number(10,2) |
DECIMAL(9,2) NOT NULL |
Biweekly Rate
|
| 124 |
GVT_DAILY_RT |
Number(10,2) |
DECIMAL(9,2) NOT NULL |
Daily Rate
|
| 125 |
GVT_HRLY_RT_NO_LOC |
Number(19,6) |
DECIMAL(18,6) NOT NULL |
Hourly Rate with out Location
|
| 126 |
GVT_DLY_RT_NO_LOC |
Number(10,2) |
DECIMAL(9,2) NOT NULL |
Daily Rate No Locality
|
| 127 |
GVT_BW_RT_NO_LOC |
Number(10,2) |
DECIMAL(9,2) NOT NULL |
No Locality Biweekly Rate
|
| 128 |
GVT_MNLY_RT_NO_LOC |
Number(19,3) |
DECIMAL(18,3) NOT NULL |
No Locality Monthly Rate
|
| 129 |
GVT_ANNL_RT_NO_LOC |
Number(19,3) |
DECIMAL(18,3) NOT NULL |
No Locality Annual Rate
|
| 130 |
GVT_XFER_FROM_AGCY |
Character(2) |
VARCHAR2(2) NOT NULL |
Transferred From Agency
Prompt Table:
COMPANY_TBL
|
| 131 |
GVT_XFER_TO_AGCY |
Character(2) |
VARCHAR2(2) NOT NULL |
Transferred To Agency
Prompt Table:
COMPANY_TBL
|
| 132 |
GVT_RETIRE_PLAN |
Character(1) |
VARCHAR2(1) NOT NULL |
Retirement Plan
Default Value: K
|
| 133 |
GVT_ANN_IND |
Character(1) |
VARCHAR2(1) NOT NULL |
Annuitant Indicator
Default Value: 9
|
| 134 |
GVT_FEGLI |
Character(2) |
VARCHAR2(2) NOT NULL |
FEGLI Code
Default Value: C0
|
| 135 |
GVT_FEGLI_LIVING |
Character(1) |
VARCHAR2(1) NOT NULL |
FEGLI Living Benefits
Y/N Table Edit
Default Value: N
|
| 136 |
GVT_LIVING_AMT |
Number(8,0) |
INTEGER NOT NULL |
Living Benefit Coverage Amount
|
| 137 |
GVT_ANNUITY_OFFSET |
Number(8,0) |
INTEGER NOT NULL |
CSRS Annuity Offset Amount
|
| 138 |
GVT_CSRS_FROZN_SVC |
Character(4) |
VARCHAR2(4) NOT NULL |
CSRS Frozen Service
Default Value: 0000
|
| 139 |
GVT_PREV_RET_COVRG |
Character(1) |
VARCHAR2(1) NOT NULL |
Previous Retirement Coverage
Default Value: N
|
| 140 |
GVT_FERS_COVERAGE |
Character(1) |
VARCHAR2(1) NOT NULL |
FERS Coverage
Default Value: A
|
| 141 |
GVT_TYPE_OF_APPT |
Character(2) |
VARCHAR2(2) NOT NULL |
Type of Appointment
Default Value: 10
|
| 142 |
GVT_POI |
Character(4) |
VARCHAR2(4) NOT NULL |
Personnel Office ID
|
| 143 |
GVT_POSN_OCCUPIED |
Character(1) |
VARCHAR2(1) NOT NULL |
Position Occupied
|
| 144 |
GVT_CONT_EMPLID |
Character(11) |
VARCHAR2(11) NOT NULL |
Contact Emplid
Prompt Table:
PERSONAL_DATA
|
| 145 |
GVT_ROUTE_NEXT |
Character(11) |
VARCHAR2(11) NOT NULL |
Route to Next
|
| 146 |
GVT_CHANGE_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
Change Flag
Y/N Table Edit
Default Value: N
|
| 147 |
GVT_TSP_UPD_IND |
Character(1) |
VARCHAR2(1) NOT NULL |
TSP Status
Default Value: N
|
| 148 |
GVT_PI_UPD_IND |
Character(1) |
VARCHAR2(1) NOT NULL |
pi upd ind
Default Value: N
|
| 149 |
GVT_SF52_NBR |
Character(10) |
VARCHAR2(10) NOT NULL |
SF-52 Request Number
|
| 150 |
GVT_S113G_CEILING |
Character(1) |
VARCHAR2(1) NOT NULL |
SF-113G Ceiling
Y/N Table Edit
Default Value: Y
|
| 151 |
GVT_LEO_POSITION |
Character(1) |
VARCHAR2(1) NOT NULL |
LEO/Fire Position
|
| 152 |
GVT_ANNUIT_COM_DT |
Date(10) |
DATE |
Annuity Commencement Date
|
| 153 |
GVT_BASIC_LIFE_RED |
Character(2) |
VARCHAR2(2) NOT NULL |
Post 65 Basic Life Reduction
|
| 154 |
GVT_DED_PRORT_DT |
Date(10) |
DATE |
4 Day Date
|
| 155 |
GVT_FEGLI_BASC_PCT |
Number(8,6) |
DECIMAL(7,6) NOT NULL |
FEGLI Basic Percent
|
| 156 |
GVT_FEGLI_OPT_PCT |
Number(8,6) |
DECIMAL(7,6) NOT NULL |
FEGLI Optional Percent
|
| 157 |
GVT_FEHB_PCT |
Number(8,6) |
DECIMAL(7,6) NOT NULL |
FEHB %
|
| 158 |
GVT_RETRO_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
Retro Pay Flag
Default Value: N
|
| 159 |
GVT_RETRO_DED_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
Retro Ded Flag
Default Value: N
|
| 160 |
GVT_RETRO_JOB_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
Retro Job Flag
Default Value: N
|
| 161 |
GVT_RETRO_BSE_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
Retro Base Flag
Default Value: N
|
| 162 |
GVT_OTH_PAY_CHG |
Character(1) |
VARCHAR2(1) NOT NULL |
Other Pay Change Flag
Default Value: N
|
| 163 |
GVT_DETL_POSN_NBR |
Character(8) |
VARCHAR2(8) NOT NULL |
GVT Detail Position Number
|
| 164 |
ANNL_BEN_BASE_OVRD |
Character(1) |
VARCHAR2(1) NOT NULL |
Annl Benefit Base Rt Override
Y/N Table Edit
Default Value: N
|
| 165 |
BENEFIT_PROGRAM |
Character(3) |
VARCHAR2(3) NOT NULL |
Benefit Program
Prompt Table:
BEN_DEFN_PGM
|
| 166 |
UPDATE_PAYROLL |
Character(1) |
VARCHAR2(1) NOT NULL |
Update Payroll Flags
|
| 167 |
GVT_PAY_PLAN |
Character(2) |
VARCHAR2(2) NOT NULL |
Pay Plan
|
| 168 |
GVT_PAY_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
GVT_PAY_FLAG
|
| 169 |
GVT_NID_CHANGE |
Character(1) |
VARCHAR2(1) NOT NULL |
GVT_NID_CHANGE
Default Value: Y
|
| 170 |
UNION_FULL_PART |
Character(1) |
VARCHAR2(1) NOT NULL |
Union Full/Part Time
|
| 171 |
UNION_POS |
Character(1) |
VARCHAR2(1) NOT NULL |
Union Position
|
| 172 |
INAIL_CODE |
Character(11) |
VARCHAR2(11) NOT NULL |
INAIL Code
|
| 173 |
UNITA_PROD_CD |
Character(6) |
VARCHAR2(6) NOT NULL |
Productive Unit
|
| 174 |
ACTION_ITA |
Character(3) |
VARCHAR2(3) NOT NULL |
Turnover - Action
HIR=Hire
LAY=Lay off
LEA=Leave of Absence
TER=Termination
|
| 175 |
ACTION_REASON_ITA |
Character(3) |
VARCHAR2(3) NOT NULL |
Turnover Action Reason
|
| 176 |
MATRICULA_NBR |
Number(3,0) |
SMALLINT NOT NULL |
Matricula Number
|
| 177 |
SOC_SEC_RISK_CODE |
Character(3) |
VARCHAR2(3) NOT NULL |
Social Security Risk Code
|
| 178 |
UNION_FEE_AMOUNT |
Number(9,2) |
DECIMAL(8,2) NOT NULL |
Union Fee Amount
|
| 179 |
UNION_FEE_START_DT |
Date(10) |
DATE |
Union Fee Start Date
|
| 180 |
UNION_FEE_END_DT |
Date(10) |
DATE |
Union Fee End Date
|
| 181 |
EXEMPT_JOB_LBR |
Character(1) |
VARCHAR2(1) NOT NULL |
Exempted
Y/N Table Edit
Default Value: N
|
| 182 |
EXEMPT_HOURS_MONTH |
Number(3,0) |
SMALLINT NOT NULL |
Exempted Hours per Month
|
| 183 |
WRKS_CNCL_FUNCTION |
Character(1) |
VARCHAR2(1) NOT NULL |
Works Council Function
|
| 184 |
INTERCTR_WRKS_CNCL |
Character(1) |
VARCHAR2(1) NOT NULL |
InterCtr.Works Cnil Function
|
| 185 |
PAY_UNION_FEE |
Character(1) |
VARCHAR2(1) NOT NULL |
Pay Union Fee
Y/N Table Edit
|
| 186 |
UNION_CD |
Character(3) |
VARCHAR2(3) NOT NULL |
Union Code
|
| 187 |
BARG_UNIT |
Character(4) |
VARCHAR2(4) NOT NULL |
Bargaining Unit
1=Bargaining Unit 1
2=Bargaining Unit 2
|
| 188 |
UNION_SENIORITY_DT |
Date(10) |
DATE |
Union Seniority Date
|
| 189 |
ENTRY_DATE |
Date(10) |
DATE |
Date Entered
Default Value: JOB.EFFDT
|
| 190 |
LABOR_AGREEMENT |
Character(6) |
VARCHAR2(6) NOT NULL |
Labor Agreement
Prompt Table:
EMPL_CTG_VW
|
| 191 |
EMPL_CTG |
Character(6) |
VARCHAR2(6) NOT NULL |
Employee Category
|
| 192 |
EMPL_CTG_L1 |
Character(6) |
VARCHAR2(6) NOT NULL |
Employee Subcategory
|
| 193 |
EMPL_CTG_L2 |
Character(6) |
VARCHAR2(6) NOT NULL |
Employee Subcategory 2
|
| 194 |
GP_PAYGROUP |
Character(10) |
VARCHAR2(10) NOT NULL |
Pay Group
Prompt Table:
GP_PYGRP
|
| 195 |
GP_DFLT_ELIG_GRP |
Character(1) |
VARCHAR2(1) NOT NULL |
Use Pay Group Value
Y/N Table Edit
Default Value: Y
|
| 196 |
GP_ELIG_GRP |
Character(10) |
VARCHAR2(10) NOT NULL |
Eligibility Group
|
| 197 |
GP_DFLT_CURRTTYP |
Character(1) |
VARCHAR2(1) NOT NULL |
Use Pay Group Value
Y/N Table Edit
Default Value: Y
|
| 198 |
CUR_RT_TYPE |
Character(5) |
VARCHAR2(5) NOT NULL |
Currency Rate Type
Prompt Table:
CUR_RT_TYPE_TBL
|
| 199 |
GP_DFLT_EXRTDT |
Character(1) |
VARCHAR2(1) NOT NULL |
Use Pay Group Value
Y/N Table Edit
Default Value: Y
|
| 200 |
GP_ASOF_DT_EXG_RT |
Character(1) |
VARCHAR2(1) NOT NULL |
Use Rate As Of
|
| 201 |
ADDS_TO_FTE_ACTUAL |
Character(1) |
VARCHAR2(1) NOT NULL |
Adds to FTE Actual Count
Y/N Table Edit
Default Value: N
|
| 202 |
CLASS_INDC |
Character(1) |
VARCHAR2(1) NOT NULL |
Classified/Unclassified Indc
B=All
C=Classified
T=Temporary
U=Unclassified
Default Value: C
|
| 203 |
ENCUMB_OVERRIDE |
Character(1) |
VARCHAR2(1) NOT NULL |
Encumbrance Override
Y/N Table Edit
Default Value: N
|
| 204 |
FICA_STATUS_EE |
Character(1) |
VARCHAR2(1) NOT NULL |
FICA Status-Employee
E=Exempt
M=Medicare only
N=Subject
|
| 205 |
FTE |
Number(8,6) |
DECIMAL(7,6) NOT NULL |
FTE
|
| 206 |
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
Default Value: N
|
| 207 |
PAY_SYSTEM_FLG |
Character(2) |
VARCHAR2(2) NOT NULL |
Payroll System
GB=European
GP=Global Payroll
GS=German/Swiss Payroll
NA=North American Payroll
OT=Other
PI=Payroll Interface
|
| 208 |
BORDER_WALKER |
Character(1) |
VARCHAR2(1) NOT NULL |
Cross Border Walker
|
| 209 |
LUMP_SUM_PAY |
Character(1) |
VARCHAR2(1) NOT NULL |
Lump Sum Retro Payment
Y/N Table Edit
Default Value: N
|
| 210 |
CONTRACT_NUM |
Character(25) |
VARCHAR2(25) NOT NULL |
Contract
|
| 211 |
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
Default Value: P
|
| 212 |
WRKS_CNCL_ROLE_CHE |
Character(30) |
VARCHAR2(30) NOT NULL |
Work Council Role
|
| 213 |
WRKS_CNCL_ID_LCL |
Character(9) |
VARCHAR2(9) NOT NULL |
Works Council ID
|
| 214 |
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
|
| 215 |
WORK_DAY_HOURS |
Number(7,2) |
DECIMAL(6,2) NOT NULL |
Number of Hours in a Work Day
|
| 216 |
SUPERVISOR_ID |
Character(11) |
VARCHAR2(11) NOT NULL |
Supervisor ID
Prompt Table:
RS_ELGBL_EMP_VW
|
| 217 |
REPORTS_TO |
Character(8) |
VARCHAR2(8) NOT NULL |
Reports To Position Number
|