| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 EMPLID |
Character(11) |
VARCHAR2(11) NOT NULL |
Employee ID
Default Value: PERSON.EMPLID
Prompt Table:
PERSON
|
| 2 |
EMPL_RCD |
Number(3,0) |
SMALLINT NOT NULL |
Empl Record
|
| 3 |
PER_ORG |
Character(3) |
VARCHAR2(3) NOT NULL |
Defines the Organizational Relationship(s) that a Person has to the Organization. These are Employee, Contingent Worker, and Persons of Interest.
CWR=Contingent Worker
EMP=Employee
POI=Person of Interest
|
| 4 |
BENEFIT_RCD_NBR |
Number(3,0) |
SMALLINT NOT NULL |
Specifies a sequence number associated with each of multiple concurrent jobs for a one employee. It is used to determine the applicable benefit program for each job. The first job entered for an employee is automatically assigned a Benefit Record Number of zero (0). This field is linked with EMPL_RCD#, the Employment Record Number.
|
| 5 |
HOME_HOST_CLASS |
Character(1) |
VARCHAR2(1) NOT NULL |
Home/Host Classification
M=Home
S=Host
Default Value: M
|
| 6 |
LAST_DATE_WORKED |
Date(10) |
DATE |
Last Date Worked
|
| 7 |
HIRE_DT |
Date(10) |
DATE |
First Start Date
|
| 8 |
REHIRE_DT |
Date(10) |
DATE |
Rehire Date
|
| 9 |
TERMINATION_DT |
Date(10) |
DATE |
Termination Date
|
| 10 |
CMPNY_SENIORITY_DT |
Date(10) |
DATE |
Company Seniority Date
|
| 11 |
SERVICE_DT |
Date(10) |
DATE |
Service Date
|
| 12 |
PROF_EXPERIENCE_DT |
Date(10) |
DATE |
Professional Experience Date
|
| 13 |
LAST_VERIFICATN_DT |
Date(10) |
DATE |
Last Verification Date
|
| 14 |
EXPECTED_RETURN_DT |
Date(10) |
DATE |
Expected Return Date
|
| 15 |
LAST_INCREASE_DT |
Date(10) |
DATE |
Date Last Increase
|
| 16 |
OWN_5PERCENT_CO |
Character(1) |
VARCHAR2(1) NOT NULL |
A flag that indicates whether or not (Y or N) an employee owns 5% or more of the company. This value is used in nondiscrimination testing.
Y/N Table Edit
Default Value: N
|
| 17 |
PROBATION_DT |
Date(10) |
DATE |
Probation Date
|
| 18 |
NEE_PROVIDER_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
The ID for the Non Employee Provider, Agency, or Employer.
Prompt Table:
NEE_PROVIDR_TBL
|
| 19 |
POSITION_PHONE |
Character(24) |
VARCHAR2(24) NOT NULL |
Phone number for the Position
|
| 20 |
BUSINESS_TITLE |
Character(30) |
VARCHAR2(30) NOT NULL |
Business Title
|
| 21 |
REPORTS_TO |
Character(8) |
VARCHAR2(8) NOT NULL |
Reports To Position Number
|
| 22 |
SUPERVISOR_ID |
Character(11) |
VARCHAR2(11) NOT NULL |
Supervisor ID
|
| 23 |
GVT_SCD_RETIRE |
Date(10) |
DATE |
Service Comp Date - Retire
|
| 24 |
GVT_SCD_TSP |
Date(10) |
DATE |
Service Comp Date - TSP
|
| 25 |
GVT_SCD_LEO |
Date(10) |
DATE |
Service Comp Date - LEO
|
| 26 |
GVT_SCD_SEVPAY |
Date(10) |
DATE |
Service Comp Date - Sev Pay
|
| 27 |
GVT_SEVPAY_PRV_WKS |
Number(2,0) |
SMALLINT NOT NULL |
Severance Pay Previous Weeks
|
| 28 |
GVT_MAND_RET_DT |
Date(10) |
DATE |
Mandatory Retirement Date
|
| 29 |
GVT_WGI_STATUS |
Character(1) |
VARCHAR2(1) NOT NULL |
Current WGI Status
A=Approved
C=WGI Created
D=Denied
M=Manual WGI
N=WGI Not Applicable
P=Postponed
W=Waiting WGI Processing
Default Value: W
|
| 30 |
GVT_INTRM_DAYS_WGI |
Number(3,0) |
SMALLINT NOT NULL |
Intermittent Days Worked
|
| 31 |
GVT_NONPAY_NOA |
Character(3) |
VARCHAR2(3) NOT NULL |
NonPay Nature of Action - Last
|
| 32 |
GVT_NONPAY_HRS_WGI |
Number(7,2) |
DECIMAL(6,2) NOT NULL |
Non-Pay Hours WGI
|
| 33 |
GVT_NONPAY_HRS_SCD |
Number(7,2) |
DECIMAL(6,2) NOT NULL |
Non-Pay Hours for SCD
|
| 34 |
GVT_NONPAY_HRS_TNR |
Number(7,2) |
DECIMAL(6,2) NOT NULL |
Career Tenure Hours
|
| 35 |
GVT_NONPAY_HRS_PRB |
Number(7,2) |
DECIMAL(6,2) NOT NULL |
Non-Pay Hours for Probation
|
| 36 |
GVT_TEMP_PRO_EXPIR |
Date(10) |
DATE |
Temp Promotion Expires
|
| 37 |
GVT_TEMP_PSN_EXPIR |
Date(10) |
DATE |
Temporary Posn Change Expires
|
| 38 |
GVT_DETAIL_EXPIRES |
Date(10) |
DATE |
Date Detail Expires
|
| 39 |
GVT_SABBATIC_EXPIR |
Date(10) |
DATE |
Date Sabbatical Expires
|
| 40 |
GVT_RTND_GRADE_BEG |
Date(10) |
DATE |
Retained Grade Begins
|
| 41 |
GVT_RTND_GRADE_EXP |
Date(10) |
DATE |
Retained Grade Expires
|
| 42 |
GVT_CURR_APT_AUTH1 |
Character(3) |
VARCHAR2(3) NOT NULL |
Current Appointment Auth Nbr 1
|
| 43 |
GVT_CURR_APT_AUTH2 |
Character(3) |
VARCHAR2(3) NOT NULL |
Current Appointment Auth Nbr 2
|
| 44 |
GVT_APPT_EXPIR_DT |
Date(10) |
DATE |
Appointment Expiration Date
|
| 45 |
GVT_CNV_BEGIN_DATE |
Date(10) |
DATE |
Conv Begin Date
|
| 46 |
GVT_CAREER_CNV_DUE |
Date(10) |
DATE |
Conversion To Career Due
|
| 47 |
GVT_CAREER_COND_DT |
Date(10) |
DATE |
Career Cond Conversion Date
|
| 48 |
GVT_APPT_LIMIT_HRS |
Number(4,0) |
SMALLINT NOT NULL |
Appointment Limit in Hours
|
| 49 |
GVT_APPT_LIMIT_DYS |
Number(3,0) |
SMALLINT NOT NULL |
Appointment Limit in Days
|
| 50 |
GVT_APPT_LIMIT_AMT |
Number(6,0) |
INTEGER NOT NULL |
Appointment Limit Amount
|
| 51 |
GVT_SUPV_PROB_DT |
Date(10) |
DATE |
Supv/Manager Probation Date
|
| 52 |
GVT_SES_PROB_DT |
Date(10) |
DATE |
SES Probation Date
|
| 53 |
GVT_SEC_CLR_STATUS |
Character(1) |
VARCHAR2(1) NOT NULL |
Security Clearance Status
A=Approved
B=Pending - Investigative Agency
C=Pending - Employee
D=Pending - Agency
N=Not Applicable
S=Suspended
Default Value: N
|
| 54 |
GVT_CLRNCE_STAT_DT |
Date(10) |
DATE |
Security Clearance Status Date
Default Value: %date
|
| 55 |
GVT_ERN_PGM_PERM |
Character(2) |
VARCHAR2(2) NOT NULL |
Permanent Pay Plan - RIF
|
| 56 |
GVT_OCC_SERS_PERM |
Character(4) |
VARCHAR2(4) NOT NULL |
Permanent Occ Series - RIF
|
| 57 |
GVT_GRADE_PERM |
Character(3) |
VARCHAR2(3) NOT NULL |
Permanent Grade - RIF
|
| 58 |
GVT_COMP_AREA_PERM |
Character(2) |
VARCHAR2(2) NOT NULL |
Comp/Area Level
|
| 59 |
GVT_COMP_LVL_PERM |
Character(3) |
VARCHAR2(3) NOT NULL |
Permanent Comp Level - RIF
|
| 60 |
GVT_SPEP |
Character(2) |
VARCHAR2(2) NOT NULL |
Special Employment Program
00=Not Applicable
59=Veteran's Readjustment Program
69=Presidential Mgt Intern
80=SES Candidate Development
99=Other
Default Value: 00
|
| 61 |
GVT_WGI_DUE_DATE |
Date(10) |
DATE |
Within-Grade Increase Due Date
|
| 62 |
GVT_DT_LEI |
Date(10) |
DATE |
Date Last Equivalent Increase
|
| 63 |
GVT_FIN_DISCLOSURE |
Character(1) |
VARCHAR2(1) NOT NULL |
Financial Disclosure Required
Y/N Table Edit
Default Value: N
|
| 64 |
GVT_FIN_DISCL_DATE |
Date(10) |
DATE |
Financial Disclosure Due Date
|
| 65 |
GVT_TENURE |
Character(1) |
VARCHAR2(1) NOT NULL |
Highest Career Tenure
0=None
1=Permanent
2=Conditional
3=Indefinite
|
| 66 |
GVT_DETL_BARG_UNIT |
Character(4) |
VARCHAR2(4) NOT NULL |
Govt Detail Bargaining Unit
|
| 67 |
GVT_DETL_UNION_CD |
Character(3) |
VARCHAR2(3) NOT NULL |
Govt Detail Union Code
|
| 68 |
GVT_WELFARE_WK_CD |
Character(2) |
VARCHAR2(2) NOT NULL |
Welfare to Work
00=Not Applicable
50=Welfare to Work Program Hire
50=Welfare to Work Program Hire
60=Hire not Welfare to Work Prog
60=Hire not Welfare to Work Prog
Default Value: 00
|
| 69 |
GVT_EFFDT |
Date(10) |
DATE |
Effective Date
|
| 70 |
GVT_EFFDT_PROPOSED |
Date(10) |
DATE |
Proposed Effective Date
Default Value: %date
|
| 71 |
GVT_TRANS_NBR |
Number(1,0) |
SMALLINT NOT NULL |
Transaction Nbr
|
| 72 |
GVT_TRANS_NBR_SEQ |
Number(1,0) |
SMALLINT NOT NULL |
Transaction Nbr / Seq
|
| 73 |
GVT_WIP_STATUS |
Character(3) |
VARCHAR2(3) NOT NULL |
Work-in-Progress Status
|
| 74 |
GVT_STATUS_TYPE |
Character(3) |
VARCHAR2(3) NOT NULL |
Status Type
CAN=Cancelled
COM=Completed
COR=Corrected
IRR=IRR Reported
WIP=Work-in-progress
|
| 75 |
GVT_NOA_CODE |
Character(3) |
VARCHAR2(3) NOT NULL |
Nature of Action Code
|
| 76 |
GVT_LEG_AUTH_1 |
Character(3) |
VARCHAR2(3) NOT NULL |
Legal Authority (1)
|
| 77 |
GVT_PAR_AUTH_D1 |
Character(25) |
VARCHAR2(25) NOT NULL |
Authority 1 Descr - Part 1
|
| 78 |
GVT_PAR_AUTH_D1_2 |
Character(25) |
VARCHAR2(25) NOT NULL |
Authority 1 Descr - Part 2
|
| 79 |
GVT_LEG_AUTH_2 |
Character(3) |
VARCHAR2(3) NOT NULL |
Legal Authority (2)
|
| 80 |
GVT_PAR_AUTH_D2 |
Character(25) |
VARCHAR2(25) NOT NULL |
Authority 2 Descr - Part 1
|
| 81 |
GVT_PAR_AUTH_D2_2 |
Character(25) |
VARCHAR2(25) NOT NULL |
Authority 2 Descr - Part 2
|
| 82 |
GVT_PAR_NTE_DATE |
Date(10) |
DATE |
Not-to-Exceed Date
|
| 83 |
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
R=Part-Time Phased Retiree
S=Part-Time Job Sharer
T=Part-Time Seasonal Job Sharer
Default Value: F
|
| 84 |
GVT_SUB_AGENCY |
Character(2) |
VARCHAR2(2) NOT NULL |
Sub-Agency
|
| 85 |
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
|
| 86 |
GVT_FEHB_DT |
Date(10) |
DATE |
FEHB Eligibility Date
|
| 87 |
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
M=Continued IGA Pay
P=Preserved IGA Pay
R=Retained Pay - SES Removal
S=Continued SES Basic Pay
T=Below the Minimum Rate
U=Rtnd Grade & Pay - Same Posn
V=Rtnd Grade & Pay - Diff Posn
Y=NSPS Retained Pay
Z=Border Equalization Allowance
Default Value: 0
|
| 88 |
GVT_STEP |
Character(2) |
VARCHAR2(2) NOT NULL |
US Federal Step
|
| 89 |
GVT_RTND_PAY_PLAN |
Character(2) |
VARCHAR2(2) NOT NULL |
Retained Pay Plan
|
| 90 |
GVT_RTND_SAL_PLAN |
Character(4) |
VARCHAR2(4) NOT NULL |
Retained Pay Table
|
| 91 |
GVT_RTND_GRADE |
Character(3) |
VARCHAR2(3) NOT NULL |
Retained Grade
|
| 92 |
GVT_RTND_STEP |
Number(2,0) |
SMALLINT NOT NULL |
Retained Step
|
| 93 |
GVT_RTND_GVT_STEP |
Character(2) |
VARCHAR2(2) NOT NULL |
Retained US Federal Step
|
| 94 |
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
|
| 95 |
GVT_COMPRATE |
Number(19,6) |
DECIMAL(18,6) NOT NULL |
Comp Rate
|
| 96 |
GVT_LOCALITY_ADJ |
Number(8,2) |
DECIMAL(7,2) NOT NULL |
Locality Adjustment
|
| 97 |
GVT_BIWEEKLY_RT |
Number(10,2) |
DECIMAL(9,2) NOT NULL |
Biweekly Rate
|
| 98 |
GVT_DAILY_RT |
Number(10,2) |
DECIMAL(9,2) NOT NULL |
Daily Rate
|
| 99 |
GVT_HRLY_RT_NO_LOC |
Number(19,6) |
DECIMAL(18,6) NOT NULL |
Hourly Rate with out Location
|
| 100 |
GVT_DLY_RT_NO_LOC |
Number(10,2) |
DECIMAL(9,2) NOT NULL |
Daily Rate No Locality
|
| 101 |
GVT_BW_RT_NO_LOC |
Number(10,2) |
DECIMAL(9,2) NOT NULL |
No Locality Biweekly Rate
|
| 102 |
GVT_MNLY_RT_NO_LOC |
Number(19,3) |
DECIMAL(18,3) NOT NULL |
No Locality Monthly Rate
|
| 103 |
GVT_ANNL_RT_NO_LOC |
Number(19,3) |
DECIMAL(18,3) NOT NULL |
No Locality Annual Rate
|
| 104 |
GVT_XFER_FROM_AGCY |
Character(2) |
VARCHAR2(2) NOT NULL |
Transferred From Agency
|
| 105 |
GVT_XFER_TO_AGCY |
Character(2) |
VARCHAR2(2) NOT NULL |
Transferred To Agency
|
| 106 |
GVT_RETIRE_PLAN |
Character(2) |
VARCHAR2(2) NOT NULL |
Retirement Plan
Default Value: K
|
| 107 |
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
M=Former FERS Phased Retiree
N=FERS Phased Retiree Officer
P=Phased Ret/Former Enlisted FE
W=Phased Retiree/Former CS
X=CSRS Phased Retiree Officer
Y=Phased Ret/Former Enlisted CS
Default Value: 9
|
| 108 |
GVT_FEGLI |
Character(2) |
VARCHAR2(2) NOT NULL |
FEGLI Code
Default Value: C0
|
| 109 |
GVT_FEGLI_LIVING |
Character(1) |
VARCHAR2(1) NOT NULL |
FEGLI Living Benefits
Y/N Table Edit
Default Value: N
|
| 110 |
GVT_LIVING_AMT |
Number(8,0) |
INTEGER NOT NULL |
Living Benefit Coverage Amount
|
| 111 |
GVT_ANNUITY_OFFSET |
Number(8,0) |
INTEGER NOT NULL |
Annuity Offset Amount
|
| 112 |
GVT_CSRS_FROZN_SVC |
Character(4) |
VARCHAR2(4) NOT NULL |
CSRS Frozen Service
|
| 113 |
GVT_PREV_RET_COVRG |
Character(1) |
VARCHAR2(1) NOT NULL |
Previous Retirement Coverage
N=Never Covered
P=Previously Covered
Default Value: N
|
| 114 |
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
|
| 115 |
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
|
| 116 |
GVT_POI |
Character(4) |
VARCHAR2(4) NOT NULL |
Personnel Office ID
|
| 117 |
GVT_POSN_OCCUPIED |
Character(1) |
VARCHAR2(1) NOT NULL |
Position Occupied
1=Competitive
2=Excepted
3=SES General
4=SES Career Reserved
|
| 118 |
GVT_CONT_EMPLID |
Character(11) |
VARCHAR2(11) NOT NULL |
Contact Emplid
|
| 119 |
GVT_ROUTE_NEXT |
Character(11) |
VARCHAR2(11) NOT NULL |
Route to Next
|
| 120 |
GVT_CHANGE_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
Change Flag
Y/N Table Edit
Default Value: N
|
| 121 |
GVT_TSP_UPD_IND |
Character(1) |
VARCHAR2(1) NOT NULL |
TSP Status
N=Not Ready
P=Processed
R=Ready
Default Value: N
|
| 122 |
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
|
| 123 |
GVT_SF52_NBR |
Character(10) |
VARCHAR2(10) NOT NULL |
SF-52 Request Number
|
| 124 |
GVT_S113G_CEILING |
Character(1) |
VARCHAR2(1) NOT NULL |
SF-113G Ceiling
Y/N Table Edit
Default Value: Y
|
| 125 |
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
|
| 126 |
GVT_ANNUIT_COM_DT |
Date(10) |
DATE |
Annuity Commencement Date
|
| 127 |
GVT_BASIC_LIFE_RED |
Character(2) |
VARCHAR2(2) NOT NULL |
Federal Field
0=No Reduction
50=50% Reduction
75=75% Reduction
N=None
|
| 128 |
GVT_DED_PRORT_DT |
Date(10) |
DATE |
4 Day Date
|
| 129 |
GVT_FEGLI_BASC_PCT |
Number(8,6) |
DECIMAL(7,6) NOT NULL |
FEGLI Basic Percent
|
| 130 |
GVT_FEGLI_OPT_PCT |
Number(8,6) |
DECIMAL(7,6) NOT NULL |
FEGLI Optional Percent
|
| 131 |
GVT_FEHB_PCT |
Number(8,6) |
DECIMAL(7,6) NOT NULL |
FEHB %
|
| 132 |
GVT_RETRO_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
Retro Pay Flag
Default Value: N
|
| 133 |
GVT_RETRO_DED_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
Retro Ded Flag
Default Value: N
|
| 134 |
GVT_RETRO_JOB_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
Retro Job Flag
Default Value: N
|
| 135 |
GVT_RETRO_BSE_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
Retro Base Flag
Default Value: N
|
| 136 |
GVT_OTH_PAY_CHG |
Character(1) |
VARCHAR2(1) NOT NULL |
Other Pay Change Flag
Default Value: N
|
| 137 |
GVT_DETL_POSN_NBR |
Character(8) |
VARCHAR2(8) NOT NULL |
Govt Detail Position Number
|
| 138 |
ANNL_BEN_BASE_OVRD |
Character(1) |
VARCHAR2(1) NOT NULL |
Annual Benefit Base Rate Override
Y/N Table Edit
Default Value: N
|
| 139 |
BENEFIT_PROGRAM |
Character(3) |
VARCHAR2(3) NOT NULL |
Defines a collection of benefit plans and their associated rate and calculation rules.
|
| 140 |
UPDATE_PAYROLL |
Character(1) |
VARCHAR2(1) NOT NULL |
Update Payroll Flags
|
| 141 |
GVT_PAY_PLAN |
Character(2) |
VARCHAR2(2) NOT NULL |
Pay Plan
|
| 142 |
GVT_PAY_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
Pay Flag
|
| 143 |
GVT_NID_CHANGE |
Character(1) |
VARCHAR2(1) NOT NULL |
GVT_NID_CHANGE
Default Value: Y
|