RETROPAY_SEQ_NORETRO_PAYCHECK(SQL Table) |
Index Back |
|---|---|
Retro Pay Paycheck NbrRetro Pay Paycheck Nbr |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | RETROPAY_SEQ_NO |
Character(15) | VARCHAR2(15) NOT NULL | Retro Pay Sequence Number |
| 2 | PAYCHECK_NBR | Number(15,0) | DECIMAL(15) NOT NULL | Paycheck number. |
| 3 | COMPANY | Character(3) | VARCHAR2(3) NOT NULL | Company |
| 4 | PAYGROUP | Character(3) | VARCHAR2(3) NOT NULL | Pay Group |
| 5 | PAY_END_DT | Date(10) | DATE | Pay Period End Date |
| 6 | OFF_CYCLE | Character(1) | VARCHAR2(1) NOT NULL | Off Cycle ? |
| 7 | PAGE_NUM | Number(5,0) | INTEGER NOT NULL | Page Nbr |
| 8 | LINE_NUM | Number(3,0) | SMALLINT NOT NULL | Line Nbr |
| 9 | SEPCHK | Number(2,0) | SMALLINT NOT NULL | Separate check number. |