GVT_CPDF_STATUS(SQL Table) |
Index Back |
|---|---|
CPDF STATUS FILE |
| # | 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 Record |
| 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(6) | VARCHAR2(6) 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 |
| 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 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 |
| 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 |
| 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 Applicable 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 R=Part-Time Phased Retiree 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 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 |
| 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
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 Nbr 1 |
| 39 | GVT_CURR_APT_AUTH2 | Character(3) | VARCHAR2(3) NOT NULL | Current Appointment Auth Nbr 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). |
| 63 | GVT_DOB_PLUS_13YR | Date(10) | DATE | CPDF Date of Birth Plus 13 Years |
| 64 | GVT_DOB_PLUS_17YR | Character(4) | VARCHAR2(4) NOT NULL | CPDF Date of Birth Plus 17 Years |
| 65 | GVT_EFFDT_MIN_5YRS | Date(10) | DATE | CPDF Personal Action Date Minus 5 Years |
| 66 | GVT_ASOFDT_MIN_5YR | Date(10) | DATE | CPDF Personal Action Date Minus 5 Years |
| 67 | GVT_CPDF_SCD_DT1 | Date(10) | DATE | CPDF Service Computation Date |
| 68 | GVT_CPDF_ASOFDT | Date(10) | DATE | CPDF As Of Date |
| 69 | GVT_LOCALITY_AREA | Character(2) | VARCHAR2(2) NOT NULL | Locality Pay Area |
| 70 | GVT_CPDF_ETHNICITY | Character(6) | VARCHAR2(6) NOT NULL | Ethnicity Information |
| 71 | GVT_CYBER_SEC_CD | Character(3) | VARCHAR2(3) NOT NULL | Cyber Security Category / Speciality Area |
| 72 | GVT_CYBER_SEC_CD9 | Character(9) | VARCHAR2(9) NOT NULL | Cyber Security Category / Speciality Area for Repoting 9 charcater OPM code |
| 73 | GVT_CPDF_YR_ASOFDT | Character(4) | VARCHAR2(4) NOT NULL | Year of Effective Date |
| 74 | GVT_CPDF_YR_EFFDT | Character(4) | VARCHAR2(4) NOT NULL | Year of Effective Date |
| 75 | GVT_CPDF_REV_PRD1 | Date(10) | DATE | Review Period |
| 76 | GVT_GEOLOC_CD | Character(9) | VARCHAR2(9) NOT NULL | Geographic Location Code |
| 77 | GVT_CPDF_SCD_RET1 | Date(10) | DATE | Created for CPDF report. This field picks the Service computation date(Retirement). |
| 78 | GVT_CPDF_PPM_ID | Character(1) | VARCHAR2(1) NOT NULL | GVT_CPDF_PPM_ID |
| 79 | GVT_RW_TW_TYPE | Character(2) | VARCHAR2(2) NOT NULL |
Remote/Telework Type
MW=Mobile Work Agreement NN=Non-teleworker RW=Remote Work Agreement TF=Frequent Routine Telework TP=Periodic Routine Telework TS=Situational Telework Agreement |