GVT_CPDF_STATUS

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	COMPANY	Character(3)	VARCHAR2(3) NOT NULL	Company
2	AGENCY_SUBELEMENT	Character(4)	VARCHAR2(4) NOT NULL	Agency Subelement
3	GVT_CPDF_RUN_DT	Date(10)	DATE	Run Date
4	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID
5	EMPL_RCD	Number(3,0)	SMALLINT NOT NULL	Empl Rcd Nbr
6	SSN	Character(9)	VARCHAR2(9) NOT NULL	Social Security #
7	GVT_DEPTID_CPDF	Character(18)	VARCHAR2(18) NOT NULL	Department ID
8	GVT_POI	Character(4)	VARCHAR2(4) NOT NULL	Personnel Office ID
9	GVT_CPDF_BIRTH_DT	Character(6)	VARCHAR2(6) NOT NULL	CPDF Birth Date
10	GVT_VET_PREF_APPT	Character(1)	VARCHAR2(1) NOT NULL	Veterans Preference Prompt Table: GVT_VETPREF_TBL
11	GVT_TENURE	Character(1)	VARCHAR2(1) NOT NULL	Highest Career Tenure 0=None 1=Permanent 2=Conditional 3=Indefinite
12	GVT_CPDF_SCD_DT	Character(6)	VARCHAR2(6) NOT NULL	CPDF Service Computation Date
13	GVT_RETIRE_PLAN	Character(2)	VARCHAR2(2) NOT NULL	Retirement Plan
14	GVT_CRED_MIL_SVCE	Character(4)	VARCHAR2(4) NOT NULL	Creditable Military Service
15	GVT_CSRS_FROZN_SVC	Character(4)	VARCHAR2(4) NOT NULL	CSRS Frozen Service
16	GVT_FEGLI	Character(2)	VARCHAR2(2) NOT NULL	FEGLI Code Prompt Table: GVT_FEGLI
17	HEALTH_PLAN	Character(3)	VARCHAR2(3) NOT NULL	Health Plan
18	MILITARY_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Veteran Status / Military Status 1=Not indicated 2=No Military Service 3=Veteran of the Vietnam Era 4=Active Duty/Campaign Badge Vet 4=Other Protected Veteran 5=Active Reserve 6=Inactive Reserve 7=Retired Military 8=Veteran (VA Ineligible) 9=Vietnam & Active Duty Vet 9=Vietnam & Other Protected Vet A=Armed Forces Service Medal Vet B=Pre-Vietnam-Era Veteran C=Separated/Srvc Medal/Active C=Separated/Srvc Medal/Other Vet D=Protected, Not Classified N=Not a Vietnam-Era Veteran O=Service Medal & Active Duty O=Service Medal & Other Vet P=Post-Vietnam-Era Veteran R=Recently Separated Veteran S=Separated & Service Medal Vet T=Separated & Active Duty Vet T=Separated & Other Vet V=Vietnam-Era Veteran X=Not a Veteran X=Not a Veteran Z=Not a Protected Veteran
19	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
20	CITIZENSHIP_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Citizenship Status
21	SEX	Character(1)	VARCHAR2(1) NOT NULL	Gender F=Female M=Male U=Unknown X=Indeterminate/Intersex/Unspec
22	ETHNIC_GROUP	Character(1)	VARCHAR2(1) NOT NULL	Ethnic Group 1=White 2=Black/African American 3=Hispanic/Latino 4=Asian 5=American Indian/Alaska Native 6=Not Specified 7=Native Hawaiian/Oth Pac Island A=American Indian/Alaskan Native B=Asian or Pacific Islander C=Black, not of Hispanic origin D=Hispanic E=White, not of Hispanic origin F=Asian Indian G=Chinese H=Filipino J=Guamanian K=Hawaiian L=Japanese M=Korean N=Samoan P=Vietnamese Q=All Other Asian o Pacific Is Y=Not Hispanic in Puerto Rico
23	GVT_DISABILITY_CD	Character(2)	VARCHAR2(2) NOT NULL	Disability Code
24	GVT_CPDF_ERN_PROG	Character(2)	VARCHAR2(2) NOT NULL	Pay Plan
25	GVT_OCC_SERIES	Character(4)	VARCHAR2(4) NOT NULL	Occupational Series
26	GVT_CPDF_GRADE	Character(2)	VARCHAR2(2) NOT NULL	Grade
27	GVT_STEP	Character(2)	VARCHAR2(2) NOT NULL	US Federal Step
28	GVT_CPDF_BASIC_PAY	Character(6)	VARCHAR2(6) NOT NULL	Basic Pay
29	GVT_FUNC_CLASS	Character(2)	VARCHAR2(2) NOT NULL	Functional Class 00=Not Applicable 11=Research 12=Research,Contract/Grant Admin 13=Development 14=Test and Evaluation 21=Design 22=Construction 23=Production 24=Install/Operations/Maintenance 31=Data Collect/Process/Analysis 32=Scientific/Technical Info 41=Standards and Specifications 42=Regulatory Enforcement/License 51=Natural Resource Operations 81=Clinical Practice/Counseling 91=Planning 92=Management 93=Teaching/Training 94=Technical Assistance/Consult 99=Other
30	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
31	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
32	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
33	GVT_POSN_OCCUPIED	Character(1)	VARCHAR2(1) NOT NULL	Position Occupied 1=Competitive 2=Excepted 3=SES General 4=SES Career Reserved
34	GVT_CPDF_SUPV_STAT	Character(1)	VARCHAR2(1) NOT NULL	Supervisor Status
35	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
36	BARG_UNIT	Character(4)	VARCHAR2(4) NOT NULL	Bargaining Unit 1=Bargaining Unit 1 2=Bargaining Unit 2
37	GVT_CPDF_LOCATION	Character(9)	VARCHAR2(9) NOT NULL	Duty Station Code
38	GVT_CURR_APT_AUTH1	Character(3)	VARCHAR2(3) NOT NULL	Current Appointment Auth #1
39	GVT_CURR_APT_AUTH2	Character(3)	VARCHAR2(3) NOT NULL	Current Appointment Auth #2
40	GVT_CPDF_RTNERNPRG	Character(2)	VARCHAR2(2) NOT NULL	Retained Pay Plan
41	GVT_CPDF_RTND_GRD	Character(2)	VARCHAR2(2) NOT NULL	Retained Grade
42	GVT_CPDF_RTND_STEP	Character(2)	VARCHAR2(2) NOT NULL	CPDF Retained Step
43	REVIEW_RATING	Character(1)	VARCHAR2(1) NOT NULL	Review Rating
44	GVT_CPDF_REVW_PTRN	Character(1)	VARCHAR2(1) NOT NULL	Review Pattern
45	GVT_CPDF_REV_PRD	Character(6)	VARCHAR2(6) NOT NULL	Review Period
46	GVT_CPDF_PAY_STAT	Character(1)	VARCHAR2(1) NOT NULL	Pay Status
47	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
48	GVT_CPDF_LCLTY_PAY	Character(5)	VARCHAR2(5) NOT NULL	Locality Pay
49	GVT_CPDF_STFF_DIFF	Character(5)	VARCHAR2(5) NOT NULL	Staffing Differential
50	GVT_CPDF_SUPV_DIFF	Character(5)	VARCHAR2(5) NOT NULL	Supervisory Differential
51	GVT_CPDF_RET_ALLW	Character(5)	VARCHAR2(5) NOT NULL	Retention Allowance
52	SAL_ADMIN_PLAN	Character(4)	VARCHAR2(4) NOT NULL	Salary Administration Plan
53	GVT_CPDF_HI_ED_LVL	Character(2)	VARCHAR2(2) NOT NULL	Highest Educational Level
54	GVT_CPDF_YR_OF_DEG	Character(4)	VARCHAR2(4) NOT NULL	Year of Degree
55	GVT_CPDF_INST_PROG	Character(6)	VARCHAR2(6) NOT NULL	Instructional Program (major)
56	GVT_CPDF_LAST_NAME	Character(35)	VARCHAR2(35) NOT NULL	Created for CPDF report. This field picks the last name.
57	GVT_CPDF_FIRST_NAM	Character(35)	VARCHAR2(35) NOT NULL	Created for CPDF report. This field picks the First Name.
58	GVT_CPDF_MID_NAME	Character(35)	VARCHAR2(35) NOT NULL	Created for CPDF report. This field picks the Middle name.
59	GVT_CPDF_SUFFIX	Character(4)	VARCHAR2(4) NOT NULL	Created for CPDF report. This field picks the name suffix.
60	GVT_CPDF_POS_TITLE	Character(60)	VARCHAR2(60) NOT NULL	Created for CPDF report. This field picks the Position title.
61	GVT_CPDF_SCD_RETIR	Character(8)	VARCHAR2(8) NOT NULL	Created for CPDF report. This field picks the Service computation date(Retirement).
62	GVT_CPDF_SCD_RIF	Character(8)	VARCHAR2(8) NOT NULL	Created for CPDF report. This field picks the Service computation date(Reduction in force).