GVT_CPDF_DYN(SQL Table) |
Index Back |
|---|---|
CPDF Dynamic Data |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | COMPANY | Character(3) | VARCHAR2(3) NOT NULL | Company |
| 2 | GVT_CPDF_RUN_DT | Date(10) | DATE | Run Date |
| 3 | EMPLID | Character(11) | VARCHAR2(11) NOT NULL | Employee ID |
| 4 | EMPL_RCD | Number(3,0) | SMALLINT NOT NULL | Empl Rcd Nbr |
| 5 | EFFDT | Date(10) | DATE | Effective Date |
| 6 | EFFSEQ | Number(3,0) | SMALLINT NOT NULL | Effective Sequence |
| 7 | AGENCY_SUBELEMENT | Character(4) | VARCHAR2(4) NOT NULL | Agency Subelement |
| 8 | SSN | Character(9) | VARCHAR2(9) NOT NULL | Social Security # |
| 9 | GVT_NOA_EFFDT | Date(10) | DATE | NOA Effective Date |
| 10 | SEQUENCE_NBR | Number(2,0) | SMALLINT NOT NULL | Sequence Number |
| 11 | GVT_DEPTID_CPDF | Character(18) | VARCHAR2(18) NOT NULL | Department ID |
| 12 | GVT_POI | Character(4) | VARCHAR2(4) NOT NULL | Personnel Office ID |
| 13 | GVT_CPDF_BIRTH_DT | Character(6) | VARCHAR2(6) NOT NULL | CPDF Birth Date |
| 14 | GVT_VET_PREF_APPT | Character(1) | VARCHAR2(1) NOT NULL |
Veterans Preference
Prompt Table: GVT_VETPREF_TBL |
| 15 | GVT_TENURE | Character(1) | VARCHAR2(1) NOT NULL |
Highest Career Tenure
0=None 1=Permanent 2=Conditional 3=Indefinite |
| 16 | GVT_CPDF_SCD_DT | Character(6) | VARCHAR2(6) NOT NULL | CPDF Service Computation Date |
| 17 | GVT_RETIRE_PLAN | Character(2) | VARCHAR2(2) NOT NULL | Retirement Plan |
| 18 | GVT_CRED_MIL_SVCE | Character(4) | VARCHAR2(4) NOT NULL | Creditable Military Service |
| 19 | GVT_CSRS_FROZN_SVC | Character(4) | VARCHAR2(4) NOT NULL | CSRS Frozen Service |
| 20 | GVT_PREV_RET_COVRG | Character(1) | VARCHAR2(1) NOT NULL |
Previous Retirement Coverage
N=Never Covered P=Previously Covered |
| 21 | 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 |
| 22 | SEX | Character(1) | VARCHAR2(1) NOT NULL |
Gender
F=Female M=Male U=Unknown X=Indeterminate/Intersex/Unspec |
| 23 | 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 |
| 24 | GVT_DISABILITY_CD | Character(2) | VARCHAR2(2) NOT NULL | Disability Code |
| 25 | GVT_NOA_CODE | Character(3) | VARCHAR2(3) NOT NULL | Nature of Action Code |
| 26 | GVT_NOA_CODE_2 | Character(3) | VARCHAR2(3) NOT NULL | NOA Code 2 |
| 27 | GVT_LEG_AUTH_1 | Character(3) | VARCHAR2(3) NOT NULL | Legal Authority (1) |
| 28 | GVT_LEG_AUTH_2 | Character(3) | VARCHAR2(3) NOT NULL | Legal Authority (2) |
| 29 | GVT_CPDF_ERN_PROG | Character(2) | VARCHAR2(2) NOT NULL | Pay Plan |
| 30 | GVT_OCC_SERIES | Character(4) | VARCHAR2(4) NOT NULL | Occupational Series |
| 31 | GVT_CPDF_GRADE | Character(2) | VARCHAR2(2) NOT NULL | Grade |
| 32 | GVT_STEP | Character(2) | VARCHAR2(2) NOT NULL | US Federal Step |
| 33 | GVT_CPDF_BASIC_PAY | Character(6) | VARCHAR2(6) NOT NULL | Basic Pay |
| 34 | 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 |
| 35 | 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 |
| 36 | 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 |
| 37 | GVT_POSN_OCCUPIED | Character(1) | VARCHAR2(1) NOT NULL |
Position Occupied
1=Competitive 2=Excepted 3=SES General 4=SES Career Reserved |
| 38 | GVT_CPDF_SUPV_STAT | Character(1) | VARCHAR2(1) NOT NULL | Supervisor Status |
| 39 | GVT_CPDF_LOCATION | Character(9) | VARCHAR2(9) NOT NULL | Duty Station Code |
| 40 | GVT_CURR_APT_AUTH1 | Character(3) | VARCHAR2(3) NOT NULL | Current Appointment Auth #1 |
| 41 | GVT_CURR_APT_AUTH2 | Character(3) | VARCHAR2(3) NOT NULL | Current Appointment Auth #2 |
| 42 | REVIEW_RATING | Character(1) | VARCHAR2(1) NOT NULL | Review Rating |
| 43 | GVT_CPDF_REVW_PTRN | Character(1) | VARCHAR2(1) NOT NULL | Review Pattern |
| 44 | GVT_CPDF_REV_PRD | Character(6) | VARCHAR2(6) NOT NULL | Review Period |
| 45 | GVT_AWARD_GROUP | Character(4) | VARCHAR2(4) NOT NULL | Award Group |
| 46 | GVT_CPDF_AWARD_AMT | Character(6) | VARCHAR2(6) NOT NULL | Award Amount |
| 47 | GVT_CPDF_BEN_AMT | Character(8) | VARCHAR2(8) NOT NULL | Benefit Amount |
| 48 | GVT_CPDF_NAME | Character(23) | VARCHAR2(23) NOT NULL | Employee Name |
| 49 | GVT_CPDF_ERN_PROG1 | Character(2) | VARCHAR2(2) NOT NULL | Prior Pay Plan |
| 50 | GVT_CPDF_OCC_SER1 | Character(4) | VARCHAR2(4) NOT NULL | Prior Occupational Series |
| 51 | GVT_CPDF_GRADE1 | Character(2) | VARCHAR2(2) NOT NULL | Prior Grade |
| 52 | GVT_CPDF_PREV_STEP | Character(2) | VARCHAR2(2) NOT NULL | Previous Step |
| 53 | GVT_CPDF_PR_PAY | Character(6) | VARCHAR2(6) NOT NULL | Prior Basic Pay |
| 54 | GVT_CPDF_PAY_BAS1 | Character(2) | VARCHAR2(2) NOT NULL | Prior Pay Basis |
| 55 | GVT_CPDF_WORK_SCH1 | Character(1) | VARCHAR2(1) NOT NULL | Prior Work Schedule |
| 56 | GVT_CPDF_PAYRTDET1 | Character(1) | VARCHAR2(1) NOT NULL | Prior Pay Rate Determinant |
| 57 | GVT_CPDF_CORR_NOA | Character(3) | VARCHAR2(3) NOT NULL | Corrected Nature of Action Cod |
| 58 | GVT_CPDF_COR_NOADT | Character(8) | VARCHAR2(8) NOT NULL | Corrected NOA Effective Date |
| 59 | GVT_CPDF_CORR_SSN | Character(9) | VARCHAR2(9) NOT NULL | Corrected SSN |
| 60 | GVT_CPDF_PR_LCLADJ | Character(5) | VARCHAR2(5) NOT NULL | Prior Locality Adjustment Amt |
| 61 | GVT_CPDF_PR_DTY_ST | Character(9) | VARCHAR2(9) NOT NULL | Priority Duty Station |
| 62 | GVT_CPDF_LCLTY_PAY | Character(5) | VARCHAR2(5) NOT NULL | Locality Pay |
| 63 | GVT_CPDF_STFF_DIFF | Character(5) | VARCHAR2(5) NOT NULL | Staffing Differential |
| 64 | GVT_CPDF_SUPV_DIFF | Character(5) | VARCHAR2(5) NOT NULL | Supervisory Differential |
| 65 | GVT_CPDF_RET_ALLW | Character(5) | VARCHAR2(5) NOT NULL | Retention Allowance |
| 66 | GVT_CPDF_HI_ED_LVL | Character(2) | VARCHAR2(2) NOT NULL | Highest Educational Level |
| 67 | GVT_CPDF_INST_PROG | Character(6) | VARCHAR2(6) NOT NULL | Instructional Program (major) |
| 68 | GVT_CPDF_YR_OF_DEG | Character(4) | VARCHAR2(4) NOT NULL | Year of Degree |
| 69 | GVT_CPDF_LAST_NAME | Character(35) | VARCHAR2(35) NOT NULL | Created for CPDF report. This field picks the last name. |
| 70 | GVT_CPDF_FIRST_NAM | Character(35) | VARCHAR2(35) NOT NULL | Created for CPDF report. This field picks the First Name. |
| 71 | GVT_CPDF_MID_NAME | Character(35) | VARCHAR2(35) NOT NULL | Created for CPDF report. This field picks the Middle name. |
| 72 | GVT_CPDF_SUFFIX | Character(4) | VARCHAR2(4) NOT NULL | Created for CPDF report. This field picks the name suffix. |
| 73 | GVT_CPDF_POS_TITLE | Character(60) | VARCHAR2(60) NOT NULL | Created for CPDF report. This field picks the Position title. |
| 74 | GVT_CPDF_GOAL_AMT | Character(9) | VARCHAR2(9) NOT NULL | Created for CPDF report. This field picks the Award dollar amount |
| 75 | GVT_CPDF_OTH_HRS | Character(9) | VARCHAR2(9) NOT NULL | Created for CPDF report. This field picks the numeber of hours. |
| 76 | GVT_CPDF_AWD_PRCNT | Character(9) | VARCHAR2(9) NOT NULL | Created for CPDF report. This field picks the Award Percent. |
| 77 | GVT_CPDF_SCD_RETIR | Character(8) | VARCHAR2(8) NOT NULL | Created for CPDF report. This field picks the Service computation date(Retirement). |
| 78 | GVT_CPDF_SCD_RIF | Character(8) | VARCHAR2(8) NOT NULL | Created for CPDF report. This field picks the Service computation date(Reduction in force). |