| # |
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 |
field used in HD_360_RESPONSE_SYNC message.
|
| 3 |
EFFDT |
Date(10) |
DATE NOT NULL |
Effective Date
Default Value: %date
|
| 4 |
EFFSEQ |
Number(3,0) |
SMALLINT NOT NULL |
Effective Sequence
|
| 5 |
DEPTID |
Character(15) |
VARCHAR2(15) NOT NULL |
Department
|
| 6 |
JOBCODE |
Character(15) |
VARCHAR2(15) NOT NULL |
Job Code or Job Title.
|
| 7 |
POSITION_NBR |
Character(8) |
VARCHAR2(8) NOT NULL |
POSITION_NBR field used in the HCM/ CRM sync Application Messages.
|
| 8 |
POSITION_OVERRIDE |
Character(1) |
VARCHAR2(1) NOT NULL |
POSITION_OVERRIDE field is being used in one of the HCM/CRM Application Messages.
Y/N Table Edit
Default Value: N
|
| 9 |
POSN_CHANGE_RECORD |
Character(1) |
VARCHAR2(1) NOT NULL |
POSN_CHANGE_RECORD field is being used in one of the HCM/CRM Application Messages.
Y/N Table Edit
Default Value: N
|
| 10 |
EMPL_STATUS |
Character(1) |
VARCHAR2(1) NOT NULL |
Employment Status. e.g., Active, Leave of Absence, Terminated, Retired, etc.
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
Default Value: A
|
| 11 |
ACTION |
Character(3) |
VARCHAR2(3) NOT NULL |
This field describes job action in job details record.
|
| 12 |
ACTION_DT |
Date(10) |
DATE |
Action Date - this field is brought over from HRMS.
Default Value: %date
|
| 13 |
ACTION_REASON |
Character(3) |
VARCHAR2(3) NOT NULL |
Action reason for Job details.
|
| 14 |
LOCATION |
Character(15) |
VARCHAR2(15) NOT NULL |
This field stores the Location Code.
|
| 15 |
TAX_LOCATION_CD |
Character(10) |
VARCHAR2(10) NOT NULL |
Tax Location Code field used in HD_360_RESPONSE_SYNC message.
|
| 16 |
JOB_ENTRY_DT |
Date(10) |
DATE |
Job Entry Date
|
| 17 |
DEPT_ENTRY_DT |
Date(10) |
DATE |
This is the department entry date field.
|
| 18 |
POSITION_ENTRY_DT |
Date(10) |
DATE |
POSITION_ENTRY_DT field is being used in one of the HCM/CRM Application Messages.
|
| 19 |
SHIFT |
Character(1) |
VARCHAR2(1) NOT NULL |
SHIFT field used in the HCM/ CRM sync Application Messages.
1=1
2=2
3=3
C=Compressed
N=Not Applicable
R=Rotating
Default Value: N
|
| 20 |
REG_TEMP |
Character(1) |
VARCHAR2(1) NOT NULL |
Identifies whether the worker is a Regular employee or a Temporary employee.
R=Regular
T=Temporary
Default Value: R
|
| 21 |
FULL_PART_TIME |
Character(1) |
VARCHAR2(1) NOT NULL |
Identifies whether the employee works Full Time or Part Time.
F=Full-Time
P=Part-Time
Default Value: F
|
| 22 |
COMPANY |
Character(3) |
VARCHAR2(3) NOT NULL |
Company
|
| 23 |
PAYGROUP |
Character(3) |
VARCHAR2(3) NOT NULL |
Payment Group field used in HD_360_RESPONSE_SYNC message.
|
| 24 |
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.
|
| 25 |
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.
|
| 26 |
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.
|
| 27 |
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.
|
| 28 |
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.
|
| 29 |
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.
|
| 30 |
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.
|
| 31 |
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.
|
| 32 |
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.
|
| 33 |
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.
|
| 34 |
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.
|
| 35 |
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.
|
| 36 |
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.
|
| 37 |
EMPL_TYPE |
Character(1) |
VARCHAR2(1) NOT NULL |
This is the employee type field.
|
| 38 |
HOLIDAY_SCHEDULE |
Character(6) |
VARCHAR2(6) NOT NULL |
This is the holiday schedule field.
|
| 39 |
STD_HOURS |
Number(7,2) |
DECIMAL(6,2) NOT NULL |
Standard Hours field used in HD_360_RESPONSE_SYNC message.
|
| 40 |
STD_HRS_FREQUENCY |
Character(5) |
VARCHAR2(5) NOT NULL |
STD_HRS_FREQUENCY field used in the HCM/ CRM sync Application Messages.
|
| 41 |
OFFICER_CD |
Character(1) |
VARCHAR2(1) NOT NULL |
Officer Code for a company. E.g., Chairman, Director, President, Treasurer, etc.
C=Chairman
D=Director
N=None
O=Officer
P=President
S=Secretary
T=Treasurer
V=Vice President
Default Value: N
|
| 42 |
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
|
| 43 |
SAL_ADMIN_PLAN |
Character(4) |
VARCHAR2(4) NOT NULL |
SAL_ADMIN_PLAN field used in the HCM/ CRM sync Application Messages.
|
| 44 |
GRADE |
Character(3) |
VARCHAR2(3) NOT NULL |
This is the salary grade field.
|
| 45 |
GRADE_ENTRY_DT |
Date(10) |
DATE |
This is the Grade Entry Date field.
|
| 46 |
STEP |
Number(2,0) |
SMALLINT NOT NULL |
STEP field is being use in one of the HCM/CRM Application Message.
|
| 47 |
STEP_ENTRY_DT |
Date(10) |
DATE |
STEP_ENTRY_DT field used in the HCM/ CRM sync Application Messages.
|
| 48 |
GL_PAY_TYPE |
Character(6) |
VARCHAR2(6) NOT NULL |
This is the general ledger pay type field.
|
| 49 |
ACCT_CD |
Character(25) |
VARCHAR2(25) NOT NULL |
Account Code
|
| 50 |
EARNS_DIST_TYPE |
Character(1) |
VARCHAR2(1) NOT NULL |
Earnings Distribution Type
Default Value: N
|
| 51 |
SALARY_MATRIX_CD |
Character(5) |
VARCHAR2(5) NOT NULL |
SALARY_MATRIX_CD field used in the HCM/ CRM sync Application Messages.
|
| 52 |
RATING_SCALE |
Character(4) |
VARCHAR2(4) NOT NULL |
RATING_SCALE field used in the HCM/ CRM sync Application Messages.
|
| 53 |
REVIEW_RATING |
Character(1) |
VARCHAR2(1) NOT NULL |
REVIEW_RATING field used in the HCM/ CRM sync Application Messages.
|
| 54 |
REVIEW_DT |
Date(10) |
DATE |
REVIEW_DT field used in the HCM/ CRM sync Application Messages.
|
| 55 |
COMP_FREQUENCY |
Character(1) |
VARCHAR2(1) NOT NULL |
Compensation Frequency
A=Annual
B=Biweekly
C=Contract
D=Daily
H=Hourly
M=Monthly
S=Semimonthly
W=Weekly
|
| 56 |
COMPRATE |
Number(19,6) |
DECIMAL(18,6) NOT NULL |
This is the compensation rate field.
|
| 57 |
CHANGE_AMT |
Signed Number(20,6) |
DECIMAL(18,6) NOT NULL |
This is the change amount field.
|
| 58 |
CHANGE_PCT |
Signed Number(8,3) |
DECIMAL(6,3) NOT NULL |
This is the change percent field.
|
| 59 |
ANNUAL_RT |
Number(19,3) |
DECIMAL(18,3) NOT NULL |
ANNUAL RATE
|
| 60 |
MONTHLY_RT |
Number(19,3) |
DECIMAL(18,3) NOT NULL |
MONTHLY RATE
|
| 61 |
DAILY_RT |
Number(19,3) |
DECIMAL(18,3) NOT NULL |
DAILY RATE
|
| 62 |
HOURLY_RT |
Number(19,6) |
DECIMAL(18,6) NOT NULL |
HOURLY RATE
|
| 63 |
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.
|
| 64 |
SHIFT_RT |
Number(19,6) |
DECIMAL(18,6) NOT NULL |
SHIFT RATE
|
| 65 |
SHIFT_FACTOR |
Number(5,3) |
DECIMAL(4,3) NOT NULL |
SHIFT_FACTOR field used in the HCM/ CRM sync Application Messages.
|
| 66 |
CURRENCY_CD |
Character(3) |
VARCHAR2(3) NOT NULL |
This field stores the Currency Code value.
|
| 67 |
BUSINESS_UNIT |
Character(5) |
VARCHAR2(5) NOT NULL |
Business Unit
|
| 68 |
SETID_DEPT |
Character(5) |
VARCHAR2(5) NOT NULL |
Department SetID
|
| 69 |
SETID_JOBCODE |
Character(5) |
VARCHAR2(5) NOT NULL |
SETID_JOBCODE field used in the HCM/ CRM sync Application Messages.
|
| 70 |
SETID_LOCATION |
Character(5) |
VARCHAR2(5) NOT NULL |
Location SetID
|
| 71 |
SETID_SALARY |
Character(5) |
VARCHAR2(5) NOT NULL |
SETID_SALARY field used in the HCM/ CRM sync Application Messages.
|
| 72 |
REG_REGION |
Character(5) |
VARCHAR2(5) NOT NULL |
REG_REGION field used in the HCM / CRM sync Application Messages.
|
| 73 |
DIRECTLY_TIPPED |
Character(1) |
VARCHAR2(1) NOT NULL |
This is the direct indication of the tip field.
D=Directly Tipped
I=Indirectly Tipped
N=Not Tipped
Default Value: JOBCODE_TBL.DIRECTLY_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 |
Worker Paid hours. Displayed as part of Job Summary on HRMS 360-degree view.
|
| 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
|
| 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
CAN=Canceled
COM=Completed
COR=Corrected
IRR=IRR Reported
WIP=Work-in-progress
|
| 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
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
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
|
| 131 |
GVT_XFER_TO_AGCY |
Character(2) |
VARCHAR2(2) NOT NULL |
Transferred To Agency
|
| 132 |
GVT_RETIRE_PLAN |
Character(2) |
VARCHAR2(2) NOT NULL |
Increased field length and used in USF 360 degree view
|
| 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
|
| 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
A=Automatically Covered by FERS
E=Elected Coverage Under FERS
N=Not Covered By FERS
Default Value: A
|
| 141 |
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)
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
1=Competitive
2=Excepted
3=SES General
4=SES Career Reserved
|
| 144 |
GVT_CONT_EMPLID |
Character(11) |
VARCHAR2(11) NOT NULL |
Contact id
|
| 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
N=Not Ready to Process
P=Processed
R=Ready To Process
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
5=5USC 5305 LEO
C=D.C. Police Forces
F=Fire Fighter
N=Not Applicable
P=Primary FEPCA
S=Secondary FEPCA
|
| 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 |
Defines a collection of benefit plans and their associated rate and calculation rules.
|
| 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
|
| 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_CD field used in the HCM/ CRM sync Application Messages.
|
| 187 |
BARG_UNIT |
Character(4) |
VARCHAR2(4) NOT NULL |
Bargaining Unit
|
| 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. This field gets the value from HCM.
|
| 191 |
EMPL_CTG |
Character(6) |
VARCHAR2(6) NOT NULL |
Employee Category. Data is fetched from HCM.
|
| 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
|
| 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
|
| 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 |
Add to full time equivalent actual.
Y/N Table Edit
Default Value: N
|
| 202 |
CLASS_INDC |
Character(1) |
VARCHAR2(1) NOT NULL |
This is the classified indicator field.
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(4,2) |
DECIMAL(3,2) NOT NULL |
This is the full time employee field.
|
| 206 |
PRORATE_CNT_AMT |
Character(1) |
VARCHAR2(1) NOT NULL |
PRORATE_CNT_AMT field used in the HCM/ CRM sync Application Messages.
Default Value: N
|
| 207 |
PAY_SYSTEM_FLG |
Character(2) |
VARCHAR2(2) NOT NULL |
Payment System Flag field used in HD_360_RESPONSE_SYNC message.
GP=Global Payroll
NA=Payroll for North America
OT=Other
PI=Payroll Interface
|
| 208 |
BORDER_WALKER |
Character(1) |
VARCHAR2(1) NOT NULL |
Indicating whether a worker is a cross Border Worker.
Y/N Table Edit
Default Value: N
|
| 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 |
This field is used to represent the contract number
|
| 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.
|
| 215 |
WORK_DAY_HOURS |
Number(7,2) |
DECIMAL(6,2) NOT NULL |
Number of Hours in a Work Day
|
| 216 |
SUPERVISOR_ID |
Character(15) |
VARCHAR2(15) NOT NULL |
ID of a worker's supervisor.
|
| 217 |
REPORTS_TO |
Character(8) |
VARCHAR2(8) NOT NULL |
REPORTS_TO field used in the HCM/ CRM sync Application Messages.
|
| 218 |
HR_STATUS |
Character(1) |
VARCHAR2(1) NOT NULL |
An indication whether a worker is still on payroll.
HR_STATUS = "A" if EMPL_STATUS in ("A", "L", "P", "S", "W");
HR_STATUS = "A" if EMPL_STATUS not in ("A", "L", "P", "S", "W");
A=Active
I=Inactive
|
| 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.
Used to Map HCM Messages.
CWR=Contingent Worker
EMP=Employee
POI=Person of Interest
|
| 220 |
POI_TYPE |
Character(5) |
VARCHAR2(5) NOT NULL |
Defines the Transactional usage of POIs in HRMS.
|
| 221 |
HIRE_DT |
Date(10) |
DATE |
Hire Date field used in HD_360_RESPONSE_SYNC message.
|
| 222 |
TERMINATION_DT |
Date(10) |
DATE |
TERMINATION_DT field used in the HCM/ CRM sync Application Messages.
|
| 223 |
ASGN_START_DT |
Date(10) |
DATE |
Start date of an assignment. This is different from the Person's Hire date.
|
| 224 |
ASGN_END_DT |
Date(10) |
DATE |
End date of the specific EMPL_RCD assignment. This is different from the Person's Termination date.
|
| 225 |
LAST_DATE_WORKED |
Date(10) |
DATE |
Last date at Work
|