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 Record |
| 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(6) | VARCHAR2(6) 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 |
| 22 | SEX | Character(1) | VARCHAR2(1) NOT NULL |
Gender
F=Female M=Male U=Unknown |
| 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 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 |
| 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 R=Part-Time Phased Retiree 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 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 |
| 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 Nbr 1 |
| 41 | GVT_CURR_APT_AUTH2 | Character(3) | VARCHAR2(3) NOT NULL | Current Appointment Auth Nbr 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(9) | VARCHAR2(9) 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). |
| 79 | GVT_DOB_PLUS_13YR | Date(10) | DATE | CPDF Date of Birth Plus 13 Years |
| 80 | GVT_DOB_PLUS_50YR | Character(4) | VARCHAR2(4) NOT NULL | CPDF Date of Birth Plus 50 Years |
| 81 | GVT_EFFDT_MIN_6MON | Date(10) | DATE | CPDF Personal Action Date Minus 6 Months |
| 82 | GVT_CPDF_SCD_DT1 | Date(10) | DATE | CPDF Service Computation Date |
| 83 | GVT_CPDF_ASOFDT | Date(10) | DATE | CPDF As Of Date |
| 84 | GVT_LOCALITY_AREA | Character(2) | VARCHAR2(2) NOT NULL | Locality Pay Area |
| 85 | GVT_CPDF_ETHNICITY | Character(6) | VARCHAR2(6) NOT NULL | Ethnicity Information |
| 86 | GVT_CYBER_SEC_CD | Character(3) | VARCHAR2(3) NOT NULL | Cyber Security Category / Speciality Area |
| 87 | GVT_CYBER_SEC_CD9 | Character(9) | VARCHAR2(9) NOT NULL | Cyber Security Category / Speciality Area for Repoting 9 charcater OPM code |
| 88 | GVT_CPDF_YR_ASOFDT | Character(4) | VARCHAR2(4) NOT NULL | Year of Effective Date |
| 89 | GVT_CPDF_YR_EFFDT | Character(4) | VARCHAR2(4) NOT NULL | Year of Effective Date |
| 90 | GVT_CPDF_REV_PRD1 | Date(10) | DATE | Review Period |
| 91 | GVT_GEOLOC_CD | Character(9) | VARCHAR2(9) NOT NULL | Geographic Location Code |
| 92 | GVT_CPDF_GEOLOC_PR | Character(9) | VARCHAR2(9) NOT NULL | Geographic Location Code |
| 93 | GVT_CPDF_LCLTY_PR | Character(2) | VARCHAR2(2) NOT NULL | Locality Pay Area |
| 94 | GVT_CPDF_SCD_RET1 | Date(10) | DATE | Created for CPDF report. This field picks the Service computation date(Retirement). |
| 95 | GVT_CPDF_PPM_ID | Character(1) | VARCHAR2(1) NOT NULL | GVT_CPDF_PPM_ID |
| 96 | 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 |