| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 MC_DEFN_ID |
Character(30) |
VARCHAR2(30) NOT NULL |
Mass Change Definition
|
| 2 |
MC_STATUS |
Character(3) |
VARCHAR2(3) NOT NULL |
Mass Change Status
APR=Approved Transaction
CAN=Cancel Transaction
ERR=Errored Transaction
PND=Pending Transaction
SCS=Successful Transaction
|
| 3 |
EMPLID |
Character(11) |
VARCHAR2(11) NOT NULL |
Employee ID
Prompt Table:
PERSON
|
| 4 |
EMPL_RCD |
Number(3,0) |
SMALLINT NOT NULL |
Empl Rcd Nbr
|
| 5 |
EFFDT |
Date(10) |
DATE |
Effective Date
|
| 6 |
EFFSEQ |
Number(3,0) |
SMALLINT NOT NULL |
Effective Sequence
|
| 7 |
GVT_TRANS_NBR |
Number(1,0) |
SMALLINT NOT NULL |
Transaction #
|
| 8 |
GVT_TRANS_NBR_SEQ |
Number(1,0) |
SMALLINT NOT NULL |
Sequence
|
| 9 |
MC_TEMPLATE_ID |
Character(30) |
VARCHAR2(30) NOT NULL |
Mass Change Template ID
|
| 10 |
JOB_EFFDT |
Date(10) |
DATE |
Job Effective Date
|
| 11 |
JOB_EFFSEQ |
Number(3,0) |
SMALLINT NOT NULL |
Job Effective Sequence
|
| 12 |
DEPTID |
Character(10) |
VARCHAR2(10) NOT NULL |
Department
Prompt Table:
DEPT_TBL
|
| 13 |
JOBCODE |
Character(6) |
VARCHAR2(6) NOT NULL |
Job Code
Prompt Table:
JOBCODE_TBL
|
| 14 |
POSITION_NBR |
Character(8) |
VARCHAR2(8) NOT NULL |
Position Number
Prompt Table:
POSITION_DATA
|
| 15 |
POSITION_OVERRIDE |
Character(1) |
VARCHAR2(1) NOT NULL |
Override Position Data
|
| 16 |
POSN_CHANGE_RECORD |
Character(1) |
VARCHAR2(1) NOT NULL |
Position Management Record
|
| 17 |
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
|
| 18 |
ACTION |
Character(3) |
VARCHAR2(3) NOT NULL |
Action
|
| 19 |
ACTION_DT |
Date(10) |
DATE |
Action Date
|
| 20 |
ACTION_REASON |
Character(3) |
VARCHAR2(3) NOT NULL |
Reason Code
Prompt Table:
ACTN_REASON_TBL
|
| 21 |
LOCATION |
Character(10) |
VARCHAR2(10) NOT NULL |
Location Code
Prompt Table:
LOCATION_TBL
|
| 22 |
TAX_LOCATION_CD |
Character(10) |
VARCHAR2(10) NOT NULL |
Tax Location Code
|
| 23 |
JOB_ENTRY_DT |
Date(10) |
DATE |
Job Entry Date
|
| 24 |
DEPT_ENTRY_DT |
Date(10) |
DATE |
Department Entry Date
|
| 25 |
POSITION_ENTRY_DT |
Date(10) |
DATE |
Position Entry Date
|
| 26 |
SHIFT |
Character(1) |
VARCHAR2(1) NOT NULL |
Regular Shift
1=1
2=2
3=3
A=Any
C=Compressed
N=Not Applicable
R=Rotating
|
| 27 |
REG_TEMP |
Character(1) |
VARCHAR2(1) NOT NULL |
Regular/Temporary
R=Regular
T=Temporary
|
| 28 |
FULL_PART_TIME |
Character(1) |
VARCHAR2(1) NOT NULL |
Full/Part Time
D=On Demand
F=Full-Time
P=Part-Time
|
| 29 |
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
|
| 30 |
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
|
| 31 |
COMPANY |
Character(3) |
VARCHAR2(3) NOT NULL |
Company
Prompt Table:
COMPANY_TBL
|
| 32 |
PAYGROUP |
Character(3) |
VARCHAR2(3) NOT NULL |
Pay Group
Prompt Table:
PAYGROUP_TBL
|
| 33 |
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.
Prompt Table:
BAS_GROUP_TBL
|
| 34 |
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.
|
| 35 |
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.
|
| 36 |
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.
|
| 37 |
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.
|
| 38 |
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.
|
| 39 |
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.
|
| 40 |
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.
|
| 41 |
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.
|
| 42 |
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.
|
| 43 |
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
|
| 44 |
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.
|
| 45 |
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.
|
| 46 |
EMPL_TYPE |
Character(1) |
VARCHAR2(1) NOT NULL |
Employee Type
E=Exception Hourly
H=Hourly
N=Not Applicable
S=Salaried
Prompt Table:
PAYGRP_EMPLTYPE
|
| 47 |
HOLIDAY_SCHEDULE |
Character(6) |
VARCHAR2(6) NOT NULL |
Holiday Schedule
Prompt Table:
HOLIDAY_TBL
|
| 48 |
STD_HOURS |
Number(7,2) |
DECIMAL(6,2) NOT NULL |
Standard Hours
|
| 49 |
STD_HRS_FREQUENCY |
Character(5) |
VARCHAR2(5) NOT NULL |
Standard Work Period
Prompt Table:
STDHRS_FREQ_VW
|
| 50 |
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
|
| 51 |
EMPL_CLASS |
Character(3) |
VARCHAR2(3) NOT NULL |
Employee Classification
|
| 52 |
SAL_ADMIN_PLAN |
Character(4) |
VARCHAR2(4) NOT NULL |
Salary Administration Plan
Prompt Table:
SAL_PLAN_TBL
|
| 53 |
GRADE |
Character(3) |
VARCHAR2(3) NOT NULL |
Salary Grade
Prompt Table:
SAL_GRADE_TBL
|
| 54 |
GRADE_ENTRY_DT |
Date(10) |
DATE |
Grade Entry Date
|
| 55 |
STEP |
Number(2,0) |
SMALLINT NOT NULL |
Step
Prompt Table:
SAL_STEP_TBL
|
| 56 |
STEP_ENTRY_DT |
Date(10) |
DATE |
Step Entry Date
|
| 57 |
GL_PAY_TYPE |
Character(6) |
VARCHAR2(6) NOT NULL |
General Ledger Pay Type
|
| 58 |
ACCT_CD |
Character(25) |
VARCHAR2(25) NOT NULL |
Combination Code
Prompt Table:
ACCT_CD_TBL
|
| 59 |
EARNS_DIST_TYPE |
Character(1) |
VARCHAR2(1) NOT NULL |
Earnings Distribution Type
A=By Amount
H=By Hours
N=None
P=By Percent
|
| 60 |
SALARY_MATRIX_CD |
Character(5) |
VARCHAR2(5) NOT NULL |
Salary Matrix Code
Prompt Table:
SAL_MATRIX_TBL
|
| 61 |
RATING_SCALE |
Character(4) |
VARCHAR2(4) NOT NULL |
Rating Scale
|
| 62 |
REVIEW_RATING |
Character(1) |
VARCHAR2(1) NOT NULL |
Review Rating
Prompt Table:
REVW_RATING_TBL
|
| 63 |
REVIEW_DT |
Date(10) |
DATE |
Review Date
|
| 64 |
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:
COMP_FREQ_VW
|
| 65 |
COMPRATE |
Number(19,6) |
DECIMAL(18,6) NOT NULL |
Compensation Rate
|
| 66 |
CHANGE_AMT |
Signed Number(20,6) |
DECIMAL(18,6) NOT NULL |
Change Amount
|
| 67 |
CHANGE_PCT |
Signed Number(8,3) |
DECIMAL(6,3) NOT NULL |
Change Percent
|
| 68 |
ANNUAL_RT |
Number(19,3) |
DECIMAL(18,3) NOT NULL |
Annual Rate
|
| 69 |
MONTHLY_RT |
Number(19,3) |
DECIMAL(18,3) NOT NULL |
Monthly Rate
|
| 70 |
DAILY_RT |
Number(19,3) |
DECIMAL(18,3) NOT NULL |
Daily Rate
|
| 71 |
HOURLY_RT |
Number(19,6) |
DECIMAL(18,6) NOT NULL |
Hourly Rate
|
| 72 |
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.
|
| 73 |
SHIFT_RT |
Number(19,6) |
DECIMAL(18,6) NOT NULL |
Shift Differential Rate
|
| 74 |
SHIFT_FACTOR |
Number(5,3) |
DECIMAL(4,3) NOT NULL |
Shift Differential Factor
|
| 75 |
CURRENCY_CD |
Character(3) |
VARCHAR2(3) NOT NULL |
Currency Code
Prompt Table:
CURRENCY_CD_TBL
|
| 76 |
BUSINESS_UNIT |
Character(5) |
VARCHAR2(5) NOT NULL |
Business Unit
Prompt Table:
BUS_UNIT_TBL_HR
|
| 77 |
SETID_DEPT |
Character(5) |
VARCHAR2(5) NOT NULL |
Department SetID
|
| 78 |
SETID_JOBCODE |
Character(5) |
VARCHAR2(5) NOT NULL |
Job Code SetID
|
| 79 |
SETID_LOCATION |
Character(5) |
VARCHAR2(5) NOT NULL |
Location SetID
|
| 80 |
SETID_SALARY |
Character(5) |
VARCHAR2(5) NOT NULL |
Salary SetID
|
| 81 |
FUNCTION_CD |
Character(2) |
VARCHAR2(2) NOT NULL |
Function Code
|
| 82 |
HOURLY_RT_FRA |
Character(3) |
VARCHAR2(3) NOT NULL |
Hours Type
|
| 83 |
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
|
| 84 |
ESTABID |
Character(12) |
VARCHAR2(12) NOT NULL |
Establishment ID
|
| 85 |
REG_REGION |
Character(5) |
VARCHAR2(5) NOT NULL |
Regulatory Region
|
| 86 |
DIRECTLY_TIPPED |
Character(1) |
VARCHAR2(1) NOT NULL |
Tipped
D=Directly Tipped
I=Indirectly Tipped
N=Not Tipped
|
| 87 |
PAY_SYSTEM_FLG |
Character(2) |
VARCHAR2(2) NOT NULL |
Payroll System
GP=Global Payroll
NA=Payroll for North America
OT=Other
PI=Payroll Interface
|
| 88 |
BORDER_WALKER |
Character(1) |
VARCHAR2(1) NOT NULL |
Cross Border Worker
|
| 89 |
LUMP_SUM_PAY |
Character(1) |
VARCHAR2(1) NOT NULL |
Lump Sum Retro Payment
Y/N Table Edit
Default Value: N
|
| 90 |
CONTRACT_NUM |
Character(25) |
VARCHAR2(25) NOT NULL |
Contract Number
|
| 91 |
GP_PAYGROUP |
Character(10) |
VARCHAR2(10) NOT NULL |
Global Payroll pay group
Prompt Table:
GP_PYGRP
|
| 92 |
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
|
| 93 |
GP_ELIG_GRP |
Character(10) |
VARCHAR2(10) NOT NULL |
Eligibility Group
Prompt Table:
GP_ELIG_GRP
|
| 94 |
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
|
| 95 |
CUR_RT_TYPE |
Character(5) |
VARCHAR2(5) NOT NULL |
Currency Rate Type
Prompt Table:
RT_TYPE_TBL
|
| 96 |
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
|
| 97 |
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
Default Value: B
|
| 98 |
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
|
| 99 |
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
|
| 100 |
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
|
| 101 |
TARIFF_AREA_GER |
Character(3) |
VARCHAR2(3) NOT NULL |
Tariff Area
|
| 102 |
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
|
| 103 |
LABOR_TYPE_GER |
Character(1) |
VARCHAR2(1) NOT NULL |
Labor Type
M=Management
N=Non-Management
|
| 104 |
SPK_COMM_ID_GER |
Character(9) |
VARCHAR2(9) NOT NULL |
Spokesmen Committee ID
|
| 105 |
VALUE_1_FRA |
Character(5) |
VARCHAR2(5) NOT NULL |
Value 1
|
| 106 |
VALUE_2_FRA |
Character(5) |
VARCHAR2(5) NOT NULL |
Value 2
|
| 107 |
VALUE_3_FRA |
Character(5) |
VARCHAR2(5) NOT NULL |
Value 3
|
| 108 |
VALUE_4_FRA |
Character(5) |
VARCHAR2(5) NOT NULL |
Value 4
|
| 109 |
VALUE_5_FRA |
Character(5) |
VARCHAR2(5) NOT NULL |
Value 5
|
| 110 |
CTG_RATE |
Number(3,0) |
SMALLINT NOT NULL |
Category Rate
|
| 111 |
PAID_HOURS |
Number(7,2) |
DECIMAL(6,2) NOT NULL |
Paid Hours
|
| 112 |
PAID_HRS_FREQUENCY |
Character(5) |
VARCHAR2(5) NOT NULL |
Paid Work Period
|
| 113 |
ANNL_BEN_BASE_OVRD |
Character(1) |
VARCHAR2(1) NOT NULL |
Annl Benefit Base Rt Override
|
| 114 |
BENEFIT_PROGRAM |
Character(3) |
VARCHAR2(3) NOT NULL |
Defines a collection of benefit plans and their associated rate and calculation rules.
|
| 115 |
UPDATE_PAYROLL |
Character(1) |
VARCHAR2(1) NOT NULL |
Update Payroll Flags
|
| 116 |
UNION_FULL_PART |
Character(1) |
VARCHAR2(1) NOT NULL |
Union Participation
F=Full Time
P=Part Time
|
| 117 |
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.
|
| 118 |
MATRICULA_NBR |
Number(5,0) |
INTEGER NOT NULL |
Matricula Number
|
| 119 |
SOC_SEC_RISK_CODE |
Character(3) |
VARCHAR2(3) NOT NULL |
Occupation Code
|
| 120 |
UNION_FEE_AMOUNT |
Number(9,2) |
DECIMAL(8,2) NOT NULL |
Union Fee Amount
|
| 121 |
UNION_FEE_START_DT |
Date(10) |
DATE |
Union Fee Start Date
|
| 122 |
UNION_FEE_END_DT |
Date(10) |
DATE |
Union Fee End Date
|
| 123 |
EXEMPT_JOB_LBR |
Character(1) |
VARCHAR2(1) NOT NULL |
Exempted
|
| 124 |
EXEMPT_HOURS_MONTH |
Number(3,0) |
SMALLINT NOT NULL |
Exempted Hours per Month
|
| 125 |
WRKS_CNCL_FUNCTION |
Character(1) |
VARCHAR2(1) NOT NULL |
Works Council Function
M=Member
P=President
S=Secretary
|
| 126 |
INTERCTR_WRKS_CNCL |
Character(1) |
VARCHAR2(1) NOT NULL |
InterCtr.Works Cnil Function
1=Member 1
2=Member 2
3=Member 3
|
| 127 |
PAY_UNION_FEE |
Character(1) |
VARCHAR2(1) NOT NULL |
Pay Union Fee
|
| 128 |
UNION_CD |
Character(3) |
VARCHAR2(3) NOT NULL |
Union Code
|
| 129 |
BARG_UNIT |
Character(4) |
VARCHAR2(4) NOT NULL |
Bargaining Unit
1=Bargaining Unit 1
2=Bargaining Unit 2
Prompt Table:
GVT_BARG_UNIT
|
| 130 |
UNION_SENIORITY_DT |
Date(10) |
DATE |
Union Seniority Date
|
| 131 |
ENTRY_DATE |
Date(10) |
DATE |
Date Entered
|
| 132 |
LABOR_AGREEMENT |
Character(6) |
VARCHAR2(6) NOT NULL |
Labor Agreement
|
| 133 |
EMPL_CTG |
Character(6) |
VARCHAR2(6) NOT NULL |
Employee Category
|
| 134 |
EMPL_CTG_L1 |
Character(6) |
VARCHAR2(6) NOT NULL |
Employee Subcategory
|
| 135 |
EMPL_CTG_L2 |
Character(6) |
VARCHAR2(6) NOT NULL |
Employee Subcategory 2
|
| 136 |
ADDS_TO_FTE_ACTUAL |
Character(1) |
VARCHAR2(1) NOT NULL |
Adds to FTE Actual Count
|
| 137 |
CLASS_INDC |
Character(1) |
VARCHAR2(1) NOT NULL |
Classified/Unclassified Indc
B=All
C=Classified
T=Temporary
U=Unclassified
|
| 138 |
ENCUMB_OVERRIDE |
Character(1) |
VARCHAR2(1) NOT NULL |
Encumbrance Override
|
| 139 |
FICA_STATUS_EE |
Character(1) |
VARCHAR2(1) NOT NULL |
FICA Status-Employee
E=Exempt
H=ER FICA Exmpt
M=Medicare only
N=Subject
|
| 140 |
FTE |
Number(8,6) |
DECIMAL(7,6) NOT NULL |
This field represent Full Time Equivalence
|
| 141 |
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
|
| 142 |
WRKS_CNCL_ROLE_CHE |
Character(30) |
VARCHAR2(30) NOT NULL |
Work Council Role
|
| 143 |
WORK_DAY_HOURS |
Number(7,2) |
DECIMAL(6,2) NOT NULL |
Number of Hours in a Work Day
|
| 144 |
SUPERVISOR_ID |
Character(11) |
VARCHAR2(11) NOT NULL |
Supervisor ID
|
| 145 |
REPORTS_TO |
Character(8) |
VARCHAR2(8) NOT NULL |
Reports To Position Number
|
| 146 |
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.
|
| 147 |
GVT_EFFDT |
Date(10) |
DATE |
Effective Date
|
| 148 |
GVT_EFFDT_PROPOSED |
Date(10) |
DATE |
Proposed Effective Date
Default Value: %date
|
| 149 |
GVT_WIP_STATUS |
Character(3) |
VARCHAR2(3) NOT NULL |
Work-in-Progress Status
Prompt Table:
GVT_WIP_STS_VW
|
| 150 |
GVT_STATUS_TYPE |
Character(3) |
VARCHAR2(3) NOT NULL |
Status Type
CAN=Cancelled
COM=Completed
COR=Corrected
IRR=IRR Reported
WIP=Work-in-progress
|
| 151 |
GVT_NOA_CODE |
Character(3) |
VARCHAR2(3) NOT NULL |
Nature of Action Code
Prompt Table:
GVT_NOAC_TBL
|
| 152 |
GVT_LEG_AUTH_1 |
Character(3) |
VARCHAR2(3) NOT NULL |
Legal Authority (1)
Prompt Table:
GVT_AUTH_VAL_VW
|
| 153 |
GVT_PAR_AUTH_D1 |
Character(25) |
VARCHAR2(25) NOT NULL |
Authority 1 Descr - Part 1
|
| 154 |
GVT_PAR_AUTH_D1_2 |
Character(25) |
VARCHAR2(25) NOT NULL |
Authority 1 Descr - Part 2
|
| 155 |
GVT_LEG_AUTH_2 |
Character(3) |
VARCHAR2(3) NOT NULL |
Legal Authority (2)
Prompt Table:
GVT_LEGAL_AUTH
|
| 156 |
GVT_PAR_AUTH_D2 |
Character(25) |
VARCHAR2(25) NOT NULL |
Authority 2 Descr - Part 1
|
| 157 |
GVT_PAR_AUTH_D2_2 |
Character(25) |
VARCHAR2(25) NOT NULL |
Authority 2 Descr - Part 2
|
| 158 |
GVT_PAR_NTE_DATE |
Date(10) |
DATE |
Not To Exceed Date
|
| 159 |
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
|
| 160 |
GVT_SUB_AGENCY |
Character(2) |
VARCHAR2(2) NOT NULL |
Sub-Agency
Prompt Table:
GVT_SUBAGCY_TBL
|
| 161 |
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
|
| 162 |
GVT_FEHB_DT |
Date(10) |
DATE |
FEHB Eligibility Date
|
| 163 |
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
Default Value: 0
|
| 164 |
GVT_STEP |
Character(2) |
VARCHAR2(2) NOT NULL |
US Federal Step
Default Value: 00
|
| 165 |
GVT_RTND_PAY_PLAN |
Character(2) |
VARCHAR2(2) NOT NULL |
Retained Pay Plan
Prompt Table:
GVT_RTND_PP_VW
|
| 166 |
GVT_RTND_SAL_PLAN |
Character(4) |
VARCHAR2(4) NOT NULL |
Retained Pay Table
Prompt Table:
GVT_RTND_SP_VW
|
| 167 |
GVT_RTND_GRADE |
Character(3) |
VARCHAR2(3) NOT NULL |
Retained Grade
Prompt Table:
GVT_RTND_SG_VW
|
| 168 |
GVT_RTND_STEP |
Number(2,0) |
SMALLINT NOT NULL |
Retained Step
Prompt Table:
GVT_RTND_SS_VW
|
| 169 |
GVT_RTND_GVT_STEP |
Character(2) |
VARCHAR2(2) NOT NULL |
Retained US Federal Step
|
| 170 |
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
Default Value: PA
|
| 171 |
GVT_COMPRATE |
Number(19,6) |
DECIMAL(18,6) NOT NULL |
Base Pay
|
| 172 |
GVT_LOCALITY_ADJ |
Number(8,2) |
DECIMAL(7,2) NOT NULL |
Locality Adjustment
|
| 173 |
GVT_BIWEEKLY_RT |
Number(10,2) |
DECIMAL(9,2) NOT NULL |
Biweekly Rate
|
| 174 |
GVT_DAILY_RT |
Number(10,2) |
DECIMAL(9,2) NOT NULL |
Daily Rate
|
| 175 |
GVT_HRLY_RT_NO_LOC |
Number(19,6) |
DECIMAL(18,6) NOT NULL |
Hourly Rate with out Location
|
| 176 |
GVT_DLY_RT_NO_LOC |
Number(10,2) |
DECIMAL(9,2) NOT NULL |
Daily Rate No Locality
|
| 177 |
GVT_BW_RT_NO_LOC |
Number(10,2) |
DECIMAL(9,2) NOT NULL |
No Locality Biweekly Rate
|
| 178 |
GVT_MNLY_RT_NO_LOC |
Number(19,3) |
DECIMAL(18,3) NOT NULL |
No Locality Monthly Rate
|
| 179 |
GVT_ANNL_RT_NO_LOC |
Number(19,3) |
DECIMAL(18,3) NOT NULL |
No Locality Annual Rate
|
| 180 |
GVT_XFER_FROM_AGCY |
Character(2) |
VARCHAR2(2) NOT NULL |
Transferred From Agency
Prompt Table:
COMPANY_TBL
|
| 181 |
GVT_XFER_TO_AGCY |
Character(2) |
VARCHAR2(2) NOT NULL |
Transferred To Agency
Prompt Table:
COMPANY_TBL
|
| 182 |
GVT_RETIRE_PLAN |
Character(2) |
VARCHAR2(2) NOT NULL |
Retirement Plan
Default Value: K
Prompt Table:
GVT_RETIRE_VW
|
| 183 |
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
Default Value: 9
Prompt Table:
GVT_ANNUITY_VW
|
| 184 |
GVT_FEGLI |
Character(2) |
VARCHAR2(2) NOT NULL |
FEGLI Code
Default Value: C0
Prompt Table:
GVT_FEGLI
|
| 185 |
GVT_FEGLI_LIVING |
Character(1) |
VARCHAR2(1) NOT NULL |
FEGLI Living Benefits
Y/N Table Edit
Default Value: N
|
| 186 |
GVT_LIVING_AMT |
Number(8,0) |
INTEGER NOT NULL |
Living Benefit Coverage Amount
|
| 187 |
GVT_ANNUITY_OFFSET |
Number(8,0) |
INTEGER NOT NULL |
CSRS Annuity Offset Amount
|
| 188 |
GVT_CSRS_FROZN_SVC |
Character(4) |
VARCHAR2(4) NOT NULL |
CSRS Frozen Service
Default Value: 0000
|
| 189 |
GVT_PREV_RET_COVRG |
Character(1) |
VARCHAR2(1) NOT NULL |
Previous Retirement Coverage
N=Never Covered
P=Previously Covered
Default Value: N
|
| 190 |
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
|
| 191 |
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
|
| 192 |
GVT_POI |
Character(4) |
VARCHAR2(4) NOT NULL |
Personnel Office ID
Prompt Table:
GVT_POI_VW
|
| 193 |
GVT_POSN_OCCUPIED |
Character(1) |
VARCHAR2(1) NOT NULL |
Position Occupied
1=Competitive
2=Excepted
3=SES General
4=SES Career Reserved
|
| 194 |
GVT_CONT_EMPLID |
Character(11) |
VARCHAR2(11) NOT NULL |
Contact Emplid
Prompt Table:
PERSON
|
| 195 |
GVT_ROUTE_NEXT |
Character(11) |
VARCHAR2(11) NOT NULL |
Route to Next
|
| 196 |
GVT_CHANGE_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
Change Flag
Y/N Table Edit
Default Value: N
|
| 197 |
GVT_TSP_UPD_IND |
Character(1) |
VARCHAR2(1) NOT NULL |
TSP Status
N=Not Ready to Process
P=Processed
R=Ready to Process
Default Value: N
|
| 198 |
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
Default Value: N
|
| 199 |
GVT_SF52_NBR |
Character(10) |
VARCHAR2(10) NOT NULL |
SF-52 Request Number
|
| 200 |
GVT_S113G_CEILING |
Character(1) |
VARCHAR2(1) NOT NULL |
SF-113G Ceiling
Y/N Table Edit
Default Value: Y
|
| 201 |
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
|
| 202 |
GVT_ANNUIT_COM_DT |
Date(10) |
DATE |
Annuity Commencement Date
|
| 203 |
GVT_BASIC_LIFE_RED |
Character(2) |
VARCHAR2(2) NOT NULL |
Federal Field
0=No Reduction
50=50% Reduction
75=75% Reduction
N=None
|
| 204 |
GVT_DED_PRORT_DT |
Date(10) |
DATE |
4 Day Date
|
| 205 |
GVT_FEGLI_BASC_PCT |
Number(8,6) |
DECIMAL(7,6) NOT NULL |
FEGLI Basic Percent
|
| 206 |
GVT_FEGLI_OPT_PCT |
Number(8,6) |
DECIMAL(7,6) NOT NULL |
FEGLI Optional Percent
|
| 207 |
GVT_FEHB_PCT |
Number(8,6) |
DECIMAL(7,6) NOT NULL |
FEHB %
|
| 208 |
GVT_RETRO_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
Retro Pay Flag
Default Value: N
|
| 209 |
GVT_RETRO_DED_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
Retro Ded Flag
Default Value: N
|
| 210 |
GVT_RETRO_JOB_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
Retro Job Flag
Default Value: N
|
| 211 |
GVT_RETRO_BSE_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
Retro Base Flag
Default Value: N
|
| 212 |
GVT_OTH_PAY_CHG |
Character(1) |
VARCHAR2(1) NOT NULL |
Other Pay Change Flag
Default Value: N
|
| 213 |
GVT_DETL_POSN_NBR |
Character(8) |
VARCHAR2(8) NOT NULL |
GVT Detail Position Number
Prompt Table:
POSITION_DATA
|
| 214 |
GVT_PAY_PLAN |
Character(2) |
VARCHAR2(2) NOT NULL |
Pay Plan
Prompt Table:
GVT_PAY_PLAN
|
| 215 |
GVT_PAY_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
GVT_PAY_FLAG
|
| 216 |
GVT_NID_CHANGE |
Character(1) |
VARCHAR2(1) NOT NULL |
GVT_NID_CHANGE
Default Value: Y
|
| 217 |
SUPV_LVL_ID |
Character(8) |
VARCHAR2(8) NOT NULL |
Supervisor Level ID for use in capability grade system
Prompt Table:
SUPVSR_LVL_TBL
|
| 218 |
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
|
| 219 |
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.
|