PERS_DATA_USF

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID Default Value: PERS_DATA_EFFDT.EMPLID Prompt Table: PERSON
2	EFFDT	Date(10)	DATE NOT NULL	Effective Date Default Value: %date
3	GVT_CRED_MIL_SVCE	Character(4)	VARCHAR2(4) NOT NULL	Creditable Military Service
4	GVT_MILITARY_COMP	Character(1)	VARCHAR2(1) NOT NULL	Uniformed Service A=Air Force C=Coast Guard M=Marines N=Navy R=Army
5	GVT_MIL_GRADE	Character(3)	VARCHAR2(3) NOT NULL	Military Grade E1=E1 E2=E2 E3=E3 E4=E4 E5=E5 E6=E6 E7=E7 E8=E8 E9=E9 O1=O1 O10=O10 O2=O2 O3=O3 O4=O4 O5=O5 O6=O6 O7=O7 O8=O8 O9=O9 W1=W1 W2=W2 W3=W3 W4=W4
6	GVT_MIL_RESRVE_CAT	Character(1)	VARCHAR2(1) NOT NULL	Reserve Category A=IMA - Air Force B=IMA - Army C=IMA - Coast Guard D=IMA - Marines E=IMA - Navy F=Selected Reserve - Air Force G=Selected Reserve - Army H=Selected Reserve - Coast Guard I=Selected Reserve - Marine Corp J=Selected Reserves - Navy K=Air National Guard L=Army National Guard M=IRR - Air Force N=IRR - Army O=IRR - Coast Guard P=IRR - Marine Corps Q=IRR - Navy S=Standby Reserve - Air Force T=Standby Reserve - Army U=Standby Reserve - Coast Guard V=Standby Reserve - Marine Corps W=Standby Reserve - Navy X=Navy Reserve - Merchant Marine Y=Draft Eligible Z=Not Applicable
7	GVT_MIL_SEP_RET	Character(1)	VARCHAR2(1) NOT NULL	Military Separation Status R=Retired S=Separated Z=Not Applicable
8	GVT_MIL_SVCE_END	Date(10)	DATE	Military Service End Date
9	GVT_MIL_SVCE_START	Date(10)	DATE	Military Service Start Date
10	GVT_MIL_VERIFY	Character(1)	VARCHAR2(1) NOT NULL	Military Service Verified
11	GVT_PAR_NBR_LAST	Number(6,0)	INTEGER NOT NULL	Last Personnel Action Reqst #
12	GVT_UNIF_SVC_CTR	Character(1)	VARCHAR2(1) NOT NULL	Notify Military Pay Center
13	GVT_VET_PREF_APPT	Character(1)	VARCHAR2(1) NOT NULL	Veterans Preference
14	GVT_VET_PREF_RIF	Character(1)	VARCHAR2(1) NOT NULL	Veterans Preference RIF Default Value: N
15	GVT_CHANGE_FLAG	Character(1)	VARCHAR2(1) NOT NULL	Change Flag
16	GVT_DRAFT_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Draft Status N=Not Yet Registered R=Registered X=Not Applicable
17	GVT_YR_ATTAINED	Date(10)	DATE	Year Attained
18	DISABLED_VET	Character(1)	VARCHAR2(1) NOT NULL	Disabled Veteran Y/N Table Edit
19	DISABLED	Character(1)	VARCHAR2(1) NOT NULL	A flag that indicates whether or not (Y or N) a dependent is a disabled. Default Value: N
20	GVT_DISABILITY_CD	Character(2)	VARCHAR2(2) NOT NULL	Disability Code Default Value: 05
21	GRADE	Character(3)	VARCHAR2(3) NOT NULL	Salary Grade
22	SAL_ADMIN_PLAN	Character(4)	VARCHAR2(4) NOT NULL	Salary Administration Plan Default Value: 0000
23	GVT_CURR_AGCY_EMPL	Character(1)	VARCHAR2(1) NOT NULL	Current Agency Employee Y/N Table Edit Default Value: N
24	GVT_CURR_FED_EMPL	Character(1)	VARCHAR2(1) NOT NULL	Current Federal Employee Y/N Table Edit Default Value: N
25	GVT_HIGH_PAY_PLAN	Character(2)	VARCHAR2(2) NOT NULL	Highest Pay Plan
26	GVT_HIGH_GRADE	Character(3)	VARCHAR2(3) NOT NULL	Highest Grade
27	GVT_PREV_AGCY_EMPL	Character(1)	VARCHAR2(1) NOT NULL	Previous Agency Employee Y/N Table Edit Default Value: N
28	GVT_PREV_FED_EMPL	Character(1)	VARCHAR2(1) NOT NULL	Previous Federal Employee Y/N Table Edit Default Value: N
29	GVT_SEP_INCENTIVE	Character(1)	VARCHAR2(1) NOT NULL	Separation Incentive B=Buyout/VSIP E=Early Retirement O=Other Incentive
30	GVT_SEP_INCENT_DT	Date(10)	DATE	Separation Incentive Date
31	GVT_TENURE	Character(1)	VARCHAR2(1) NOT NULL	Highest Career Tenure 0=None 1=Permanent 2=Conditional 3=Indefinite
32	GVT_PAY_PLAN	Character(2)	VARCHAR2(2) NOT NULL	Pay Plan
33	BARG_UNIT	Character(4)	VARCHAR2(4) NOT NULL	Bargaining Unit 1=Bargaining Unit 1 2=Bargaining Unit 2