GVT_CPDF_ONLINE

(SQL Table)
 Index Back

CPDF Online Validation Data

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).
2 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
3 EMPL_RCD Number(3,0) SMALLINT NOT NULL Empl Rcd Nbr
4 EFFDT Date(10) DATE Effective Date
5 EFFSEQ Number(3,0) SMALLINT NOT NULL Effective Sequence
6 GVT_EDIT_ID Character(1) VARCHAR2(1) NOT NULL Edit ID
1=Status
2=Dynamic
3=Status and Dynamic
4=Pine
7 AGENCY_SUBELEMENT Character(4) VARCHAR2(4) NOT NULL Agency Subelement
8 GVT_CPDF_RUN_DT Date(10) DATE Run Date
9 COMPANY Character(3) VARCHAR2(3) NOT NULL Company
10 SSN Character(9) VARCHAR2(9) NOT NULL Social Security #
11 GVT_NOA_EFFDT Date(10) DATE NOA Effective Date
12 SEQUENCE_NBR Number(2,0) SMALLINT NOT NULL Sequence Number
13 GVT_DEPTID_CPDF Character(18) VARCHAR2(18) NOT NULL Department ID
14 GVT_POI Character(4) VARCHAR2(4) NOT NULL Personnel Office ID
15 GVT_CPDF_BIRTH_DT Character(6) VARCHAR2(6) NOT NULL CPDF Birth Date
16 GVT_VET_PREF_APPT Character(1) VARCHAR2(1) NOT NULL Veterans Preference

Prompt Table: GVT_VETPREF_TBL

17 GVT_TENURE Character(1) VARCHAR2(1) NOT NULL Highest Career Tenure
0=None
1=Permanent
2=Conditional
3=Indefinite
18 GVT_CPDF_SCD_DT Character(6) VARCHAR2(6) NOT NULL CPDF Service Computation Date
19 GVT_CPDF_RTNERNPRG Character(2) VARCHAR2(2) NOT NULL Retained Pay Plan
20 GVT_CPDF_RTND_GRD Character(2) VARCHAR2(2) NOT NULL Retained Grade
21 GVT_CPDF_RTND_STEP Character(2) VARCHAR2(2) NOT NULL CPDF Retained Step
22 SAL_ADMIN_PLAN Character(4) VARCHAR2(4) NOT NULL Salary Administration Plan
23 GVT_CPDF_PAY_STAT Character(1) VARCHAR2(1) NOT NULL Pay Status
24 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
25 GVT_RETIRE_PLAN Character(2) VARCHAR2(2) NOT NULL Retirement Plan
26 GVT_CRED_MIL_SVCE Character(4) VARCHAR2(4) NOT NULL Creditable Military Service
27 GVT_CSRS_FROZN_SVC Character(4) VARCHAR2(4) NOT NULL CSRS Frozen Service
28 GVT_FEGLI Character(2) VARCHAR2(2) NOT NULL FEGLI Code
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 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
31 BARG_UNIT Character(4) VARCHAR2(4) NOT NULL Bargaining Unit
1=Bargaining Unit 1
2=Bargaining Unit 2
32 HEALTH_PLAN Character(3) VARCHAR2(3) NOT NULL Health Plan
33 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
34 GVT_PREV_RET_COVRG Character(1) VARCHAR2(1) NOT NULL Previous Retirement Coverage
N=Never Covered
P=Previously Covered
35 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
36 SEX Character(1) VARCHAR2(1) NOT NULL Gender
F=Female
M=Male
U=Unknown
X=Indeterminate/Intersex/Unspec
37 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
38 CITIZENSHIP_STATUS Character(1) VARCHAR2(1) NOT NULL Citizenship Status
39 GVT_DISABILITY_CD Character(2) VARCHAR2(2) NOT NULL Disability Code
40 GVT_NOA_CODE Character(3) VARCHAR2(3) NOT NULL Nature of Action Code
41 GVT_NOA_CODE_2 Character(3) VARCHAR2(3) NOT NULL NOA Code 2
42 GVT_LEG_AUTH_1 Character(3) VARCHAR2(3) NOT NULL Legal Authority (1)
43 GVT_LEG_AUTH_2 Character(3) VARCHAR2(3) NOT NULL Legal Authority (2)
44 GVT_CPDF_ERN_PROG Character(2) VARCHAR2(2) NOT NULL Pay Plan
45 GVT_OCC_SERIES Character(4) VARCHAR2(4) NOT NULL Occupational Series
46 GVT_CPDF_GRADE Character(2) VARCHAR2(2) NOT NULL Grade
47 GVT_STEP Character(2) VARCHAR2(2) NOT NULL US Federal Step
48 GVT_CPDF_BASIC_PAY Character(6) VARCHAR2(6) NOT NULL Basic Pay
49 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
50 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
51 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
52 GVT_POSN_OCCUPIED Character(1) VARCHAR2(1) NOT NULL Position Occupied
1=Competitive
2=Excepted
3=SES General
4=SES Career Reserved
53 GVT_CPDF_SUPV_STAT Character(1) VARCHAR2(1) NOT NULL Supervisor Status
54 GVT_CPDF_LOCATION Character(9) VARCHAR2(9) NOT NULL Duty Station Code
55 GVT_CURR_APT_AUTH1 Character(3) VARCHAR2(3) NOT NULL Current Appointment Auth #1
56 GVT_CURR_APT_AUTH2 Character(3) VARCHAR2(3) NOT NULL Current Appointment Auth #2
57 REVIEW_RATING Character(1) VARCHAR2(1) NOT NULL Review Rating
58 GVT_CPDF_REVW_PTRN Character(1) VARCHAR2(1) NOT NULL Review Pattern
59 GVT_CPDF_REV_PRD Character(6) VARCHAR2(6) NOT NULL Review Period
60 GVT_AWARD_GROUP Character(4) VARCHAR2(4) NOT NULL Award Group
61 GVT_CPDF_AWARD_AMT Character(6) VARCHAR2(6) NOT NULL Award Amount
62 GVT_CPDF_BEN_AMT Character(8) VARCHAR2(8) NOT NULL Benefit Amount
63 GVT_CPDF_NAME Character(23) VARCHAR2(23) NOT NULL Employee Name
64 GVT_CPDF_ERN_PROG1 Character(2) VARCHAR2(2) NOT NULL Prior Pay Plan
65 GVT_CPDF_OCC_SER1 Character(4) VARCHAR2(4) NOT NULL Prior Occupational Series
66 GVT_CPDF_GRADE1 Character(2) VARCHAR2(2) NOT NULL Prior Grade
67 GVT_CPDF_PREV_STEP Character(2) VARCHAR2(2) NOT NULL Previous Step
68 GVT_CPDF_PR_PAY Character(6) VARCHAR2(6) NOT NULL Prior Basic Pay
69 GVT_CPDF_PAY_BAS1 Character(2) VARCHAR2(2) NOT NULL Prior Pay Basis
70 GVT_CPDF_WORK_SCH1 Character(1) VARCHAR2(1) NOT NULL Prior Work Schedule
71 GVT_CPDF_PAYRTDET1 Character(1) VARCHAR2(1) NOT NULL Prior Pay Rate Determinant
72 GVT_CPDF_CORR_NOA Character(3) VARCHAR2(3) NOT NULL Corrected Nature of Action Cod
73 GVT_CPDF_COR_NOADT Character(8) VARCHAR2(8) NOT NULL Corrected NOA Effective Date
74 GVT_CPDF_CORR_SSN Character(9) VARCHAR2(9) NOT NULL Corrected SSN
75 GVT_CPDF_PR_LCLADJ Character(5) VARCHAR2(5) NOT NULL Prior Locality Adjustment Amt
76 GVT_CPDF_PR_DTY_ST Character(9) VARCHAR2(9) NOT NULL Priority Duty Station
77 GVT_CPDF_LCLTY_PAY Character(5) VARCHAR2(5) NOT NULL Locality Pay
78 GVT_CPDF_STFF_DIFF Character(5) VARCHAR2(5) NOT NULL Staffing Differential
79 GVT_CPDF_SUPV_DIFF Character(5) VARCHAR2(5) NOT NULL Supervisory Differential
80 GVT_CPDF_RET_ALLW Character(5) VARCHAR2(5) NOT NULL Retention Allowance
81 GVT_CPDF_HI_ED_LVL Character(2) VARCHAR2(2) NOT NULL Highest Educational Level
82 GVT_CPDF_INST_PROG Character(6) VARCHAR2(6) NOT NULL Instructional Program (major)
83 GVT_CPDF_YR_OF_DEG Character(4) VARCHAR2(4) NOT NULL Year of Degree
84 GVT_CPDF_LAST_NAME Character(35) VARCHAR2(35) NOT NULL Created for CPDF report. This field picks the last name.
85 GVT_CPDF_FIRST_NAM Character(35) VARCHAR2(35) NOT NULL Created for CPDF report. This field picks the First Name.
86 GVT_CPDF_MID_NAME Character(35) VARCHAR2(35) NOT NULL Created for CPDF report. This field picks the Middle name.
87 GVT_CPDF_SUFFIX Character(4) VARCHAR2(4) NOT NULL Created for CPDF report. This field picks the name suffix.
88 GVT_CPDF_POS_TITLE Character(60) VARCHAR2(60) NOT NULL Created for CPDF report. This field picks the Position title.
89 GVT_CPDF_SCD_RETIR Character(8) VARCHAR2(8) NOT NULL Created for CPDF report. This field picks the Service computation date(Retirement).
90 GVT_CPDF_SCD_RIF Character(8) VARCHAR2(8) NOT NULL Created for CPDF report. This field picks the Service computation date(Reduction in force).
91 GVT_CPDF_GOAL_AMT Character(9) VARCHAR2(9) NOT NULL Created for CPDF report. This field picks the Award dollar amount
92 GVT_CPDF_OTH_HRS Character(9) VARCHAR2(9) NOT NULL Created for CPDF report. This field picks the numeber of hours.
93 GVT_CPDF_AWD_PRCNT Character(9) VARCHAR2(9) NOT NULL Created for CPDF report. This field picks the Award Percent.