|
SELECT A.EMPLID , A.EMPL_RCD , A.EFFDT , A.EFFSEQ , A.DEPTID , A.JOBCODE , A.POSITION_NBR , '0' , 0 , A.POSITION_OVERRIDE , A.POSN_CHANGE_RECORD , A.EMPL_STATUS , A.ACTION , A.ACTION_DT , A.ACTION_REASON , A.LOCATION , A.TAX_LOCATION_CD , A.JOB_ENTRY_DT , A.DEPT_ENTRY_DT , A.POSITION_ENTRY_DT , A.SHIFT , A.REG_TEMP , A.FULL_PART_TIME , A.COMPANY , A.PAYGROUP , A.BAS_GROUP_ID , A.ELIG_CONFIG1 , A.ELIG_CONFIG2 , A.ELIG_CONFIG3 , A.ELIG_CONFIG4 , A.ELIG_CONFIG5 , A.ELIG_CONFIG6 , A.ELIG_CONFIG7 , A.ELIG_CONFIG8 , A.ELIG_CONFIG9 , A.BEN_STATUS , A.BAS_ACTION , A.COBRA_ACTION , A.EMPL_TYPE , A.HOLIDAY_SCHEDULE , A.STD_HOURS , A.STD_HRS_FREQUENCY , A.OFFICER_CD , A.EMPL_CLASS , A.SAL_ADMIN_PLAN , A.GRADE , A.GRADE_ENTRY_DT , A.STEP , A.STEP_ENTRY_DT , A.GL_PAY_TYPE , A.ACCT_CD , A.EARNS_DIST_TYPE , A.COMP_FREQUENCY , A.COMPRATE , A.CHANGE_AMT , A.CHANGE_PCT , A.ANNUAL_RT , A.MONTHLY_RT , A.DAILY_RT , A.HOURLY_RT , A.ANNL_BENEF_BASE_RT , A.SHIFT_RT , A.SHIFT_FACTOR , A.CURRENCY_CD , A.BUSINESS_UNIT , A.SETID_DEPT , A.SETID_JOBCODE , A.SETID_LOCATION , A.SETID_SALARY , A.REG_REGION , A.DIRECTLY_TIPPED , %subrec(JOB_USA_SBR,A) , %subrec(JOB_GER_SBR,A) , %subrec(JOB_FRA_SBR,A) , %subrec(JOB_FED_SBR,A) , %subrec(JOB_ITA_SBR,A) , %subrec(JOB_ESP_SBR,A) , %subrec(JOB_LBR_GBL_SBR,A) , %subrec(JOB_GP_SBR,A) , A.ADDS_TO_FTE_ACTUAL , A.CLASS_INDC , A.ENCUMB_OVERRIDE , A.FICA_STATUS_EE , A.FTE , A.PRORATE_CNT_AMT , A.PAY_SYSTEM_FLG , A.BORDER_WALKER , A.LUMP_SUM_PAY , A.CONTRACT_NUM , A.JOB_INDICATOR , %subrec(JOB_CHE_SBR,A) , A.BENEFIT_SYSTEM , A.WORK_DAY_HOURS , A.SUPERVISOR_ID , A.REPORTS_TO , %CurrentDateIn , '002' ,A.ESTABID FROM PS_GVT_JOB A , PS_GVT_NOAC_TBL B WHERE ( A.GVT_STATUS_TYPE = 'COR' OR A.GVT_STATUS_TYPE = 'COM' ) AND B.ACTION = A.ACTION AND B.GVT_NOA_CODE = A.GVT_NOA_CODE AND B.GVT_NOA_PAR_PUSH = 'Y' AND B.EFFDT = ( SELECT MAX(BB.EFFDT) FROM PS_GVT_NOAC_TBL BB WHERE BB.ACTION = A.ACTION AND BB.GVT_NOA_CODE = A.GVT_NOA_CODE AND BB.GVT_NOA_PAR_PUSH = 'Y' AND BB.EFF_STATUS = 'A' AND BB.EFFDT <= A.EFFDT)
|
| # |
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:
PERSON
|
| 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 |
DEPTID |
Character(10) |
VARCHAR2(10) NOT NULL |
Department
Prompt Table:
DEPT_TBL
|
| 6 |
JOBCODE |
Character(6) |
VARCHAR2(6) NOT NULL |
Job Code
Prompt Table:
JOBCODE_TBL
|
| 7 |
POSITION_NBR |
Character(8) |
VARCHAR2(8) NOT NULL |
Position Number
Prompt Table:
POSITION_DATA
|
| 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
Y/N Table Edit
Default Value: N
|
| 11 |
POSN_CHANGE_RECORD |
Character(1) |
VARCHAR2(1) NOT NULL |
Position Management Record
Y/N Table Edit
Default Value: N
|
| 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
Default Value: A
|
| 13 |
ACTION |
Character(3) |
VARCHAR2(3) NOT NULL |
Action
Prompt Table:
ACTION_TBL
|
| 14 |
ACTION_DT |
Date(10) |
DATE |
Action Date
Default Value: %date
|
| 15 |
ACTION_REASON |
Character(3) |
VARCHAR2(3) NOT NULL |
Reason Code
Prompt Table:
ACTN_REASON_TBL
|
| 16 |
LOCATION |
Character(10) |
VARCHAR2(10) NOT NULL |
Location Code
Prompt Table:
LOCATION_TBL
|
| 17 |
TAX_LOCATION_CD |
Character(10) |
VARCHAR2(10) NOT NULL |
Tax Location Code
Prompt Table:
%RECNAME_EDIT
|
| 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
Default Value: N
|
| 22 |
REG_TEMP |
Character(1) |
VARCHAR2(1) NOT NULL |
Regular/Temporary
R=Regular
T=Temporary
Default Value: R
|
| 23 |
FULL_PART_TIME |
Character(1) |
VARCHAR2(1) NOT NULL |
Full/Part Time
D=On Demand
F=Full-Time
P=Part-Time
Default Value: F
|
| 24 |
COMPANY |
Character(3) |
VARCHAR2(3) NOT NULL |
Company
Prompt Table:
COMPANY_TBL
|
| 25 |
PAYGROUP |
Character(3) |
VARCHAR2(3) NOT NULL |
Pay Group
Prompt Table:
PAYGROUP_TBL
|
| 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.
Prompt Table:
BAS_GROUP_TBL
|
| 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
Prompt Table:
PAYGRP_EMPLTYPE
|
| 40 |
HOLIDAY_SCHEDULE |
Character(6) |
VARCHAR2(6) NOT NULL |
Holiday Schedule
Prompt Table:
HOLIDAY_TBL
|
| 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
Default Value: N
|
| 44 |
EMPL_CLASS |
Character(3) |
VARCHAR2(3) NOT NULL |
Employee Classification
|
| 45 |
SAL_ADMIN_PLAN |
Character(4) |
VARCHAR2(4) NOT NULL |
Salary Administration Plan
Prompt Table:
SAL_PLAN_TBL
|
| 46 |
GRADE |
Character(3) |
VARCHAR2(3) NOT NULL |
Salary Grade
Prompt Table:
SAL_GRADE_TBL
|
| 47 |
GRADE_ENTRY_DT |
Date(10) |
DATE |
Grade Entry Date
|
| 48 |
STEP |
Number(2,0) |
SMALLINT NOT NULL |
Step
Prompt Table:
SAL_STEP_TBL
|
| 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
Prompt Table:
ACCT_CD_TBL
|
| 52 |
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
|
| 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
Default Value: INSTALLATION.COMP_FREQUENCY
|
| 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
Default Value: OPR_DEF_TBL_HR.EXCHNG_TO_CURRENCY
Prompt Table:
CURRENCY_CD_TBL
|
| 65 |
BUSINESS_UNIT |
Character(5) |
VARCHAR2(5) NOT NULL |
Business Unit
Default Value: OPR_DEF_TBL_HR.BUSINESS_UNIT
Prompt Table:
BUS_UNIT_TBL_HR
|
| 66 |
SETID_DEPT |
Character(5) |
VARCHAR2(5) NOT NULL |
Department SetID
Default Value: OPR_DEF_TBL_HR.SETID
|
| 67 |
SETID_JOBCODE |
Character(5) |
VARCHAR2(5) NOT NULL |
Job Code SetID
Default Value: OPR_DEF_TBL_HR.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
Default Value: OPR_DEF_TBL_HR.REG_REGION
Prompt Table:
REG_STANDARD_VW
|
| 71 |
DIRECTLY_TIPPED |
Character(1) |
VARCHAR2(1) NOT NULL |
Tipped
D=Directly Tipped
I=Indirectly Tipped
N=Not Tipped
Default Value: JOBCODE_TBL.DIRECTLY_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
Default Value: %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
Prompt Table:
GVT_WIP_STS_VW
|
| 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
Prompt Table:
GVT_NOAC_TBL
|
| 98 |
GVT_LEG_AUTH_1 |
Character(3) |
VARCHAR2(3) NOT NULL |
Legal Authority (1)
Prompt Table:
GVT_AUTH_VAL_VW
|
| 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)
Prompt Table:
GVT_AUTH_VAL_VW
|
| 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
Default Value: F
|
| 106 |
GVT_SUB_AGENCY |
Character(2) |
VARCHAR2(2) NOT NULL |
Sub-Agency
Prompt Table:
GVT_SUBAGCY_TBL
|
| 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
Default Value: NE
|
| 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
Default Value: 0
|
| 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
Prompt Table:
GVT_RTND_PP_VW
|
| 112 |
GVT_RTND_SAL_PLAN |
Character(4) |
VARCHAR2(4) NOT NULL |
Retained Pay Table
Prompt Table:
GVT_RTND_SP_VW
|
| 113 |
GVT_RTND_GRADE |
Character(3) |
VARCHAR2(3) NOT NULL |
Retained Grade
Prompt Table:
GVT_RTND_SG_VW
|
| 114 |
GVT_RTND_STEP |
Number(2,0) |
SMALLINT NOT NULL |
Retained Step
Prompt Table:
GVT_RTND_SS_VW
|
| 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
Default Value: PA
|
| 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
Prompt Table:
COMPANY_TBL
|
| 127 |
GVT_XFER_TO_AGCY |
Character(2) |
VARCHAR2(2) NOT NULL |
Transferred To Agency
Prompt Table:
COMPANY_TBL
|
| 128 |
GVT_RETIRE_PLAN |
Character(2) |
VARCHAR2(2) NOT NULL |
Retirement Plan
Default Value: K
Prompt Table:
GVT_RETIRE_VW
|
| 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
Default Value: 9
Prompt Table:
GVT_ANNUITY_VW
|
| 130 |
GVT_FEGLI |
Character(2) |
VARCHAR2(2) NOT NULL |
FEGLI Code
Default Value: C0
Prompt Table:
GVT_FEGLI
|
| 131 |
GVT_FEGLI_LIVING |
Character(1) |
VARCHAR2(1) NOT NULL |
FEGLI Living Benefits
Y/N Table Edit
Default Value: N
|
| 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
Default Value: N
|
| 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
Default Value: A
|
| 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)
Default Value: 10
|
| 138 |
GVT_POI |
Character(4) |
VARCHAR2(4) NOT NULL |
Personnel Office ID
Prompt Table:
GVT_POI_VW
|
| 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
Prompt Table:
PERSON_NAME
|
| 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
Y/N Table Edit
Default Value: N
|
| 143 |
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
|
| 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
Default Value: N
|
| 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
Y/N Table Edit
Default Value: Y
|
| 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
Default Value: N
|
| 155 |
GVT_RETRO_DED_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
Retro Ded Flag
Default Value: N
|
| 156 |
GVT_RETRO_JOB_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
Retro Job Flag
Default Value: N
|
| 157 |
GVT_RETRO_BSE_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
Retro Base Flag
Default Value: N
|
| 158 |
GVT_OTH_PAY_CHG |
Character(1) |
VARCHAR2(1) NOT NULL |
Other Pay Change Flag
Default Value: N
|
| 159 |
GVT_DETL_POSN_NBR |
Character(8) |
VARCHAR2(8) NOT NULL |
GVT Detail Position Number
Prompt Table:
POSITION_DATA
|
| 160 |
ANNL_BEN_BASE_OVRD |
Character(1) |
VARCHAR2(1) NOT NULL |
Annl Benefit Base Rt Override
Y/N Table Edit
Default Value: N
|
| 161 |
BENEFIT_PROGRAM |
Character(3) |
VARCHAR2(3) NOT NULL |
Defines a collection of benefit plans and their associated rate and calculation rules.
Prompt Table:
BEN_DEFN_PGM
|
| 162 |
UPDATE_PAYROLL |
Character(1) |
VARCHAR2(1) NOT NULL |
Update Payroll Flags
|
| 163 |
GVT_PAY_PLAN |
Character(2) |
VARCHAR2(2) NOT NULL |
Pay Plan
Prompt Table:
GVT_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
Default Value: Y
|
| 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
Default Value: C
|
| 202 |
ENCUMB_OVERRIDE |
Character(1) |
VARCHAR2(1) NOT NULL |
Encumbrance Override
Default Value: N
|
| 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
Default Value: N
|
| 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
Default Value: OPR_DEF_TBL_HR.PAY_SYSTEM_FLG
|
| 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
Default Value: N
|
| 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
Default Value: P
|
| 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
|