GVT_PAY_LIMITS(SQL Table) |
Index Back |
|---|---|
Federal Pay Limits |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  COMPANY |
Character(3) | VARCHAR2(3) NOT NULL |
Company
Prompt Table: COMPANY_TBL |
| 2 | PAYGROUP |
Character(3) | VARCHAR2(3) NOT NULL |
Pay Group
Prompt Table: PAYGROUP_TBL |
| 3 | PAY_END_DT |
Date(10) | DATE |
Pay Period End Date
Prompt Table: PAY_CALENDAR |
| 4 | OFF_CYCLE |
Character(1) | VARCHAR2(1) NOT NULL | Off Cycle ? |
| 5 | PAGE_NUM |
Number(4,0) | SMALLINT NOT NULL | Page # |
| 6 | LINE_NUM |
Number(2,0) | SMALLINT NOT NULL | Line # |
| 7 | SEPCHK |
Number(1,0) | SMALLINT NOT NULL | Separate check number. |
| 8 | ERNCD |
Character(3) | VARCHAR2(3) NOT NULL | Earnings Code |
| 9 | GVT_EARN_PROC_TYPE |
Character(2) | VARCHAR2(2) NOT NULL |
Earning Process Type
CA=Pay Limit - Total Annual CB=Pay Cap - Basic Pay CP=Pay Limit - Premium Pay OT=Overtime |
| 10 | EMPLID | Character(11) | VARCHAR2(11) NOT NULL | Employee ID |
| 11 | EMPL_RCD | Number(3,0) | SMALLINT NOT NULL | Empl Rcd Nbr |
| 12 | ADJUSTMT_AMT | Signed Number(20,3) | DECIMAL(18,3) NOT NULL | Adjustment Amount YTD |
| 13 | DT_COMPLETED | Date(10) | DATE | Date Completed |
| 14 | GVT_PAY_CAP_DISP | Character(1) | VARCHAR2(1) NOT NULL |
Disposition
D=Defer to following Year F=Forfeit |
| 15 | GVT_PAY_PROCESS | Character(1) | VARCHAR2(1) NOT NULL |
Pay Limit Flag
C=Confirmed P=Processed R=Calculated X=Calendar Year Unconfirm |