PROCESS_INSTANCEGPAU_COMSUPR_AGCYGPAU_PAY_RUN_NBRGPAU_COMSUP_HDR(SQL Table) |
Index Back |
|---|---|
ComSuper Header RecordThis holds the ComSuper header data |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | PROCESS_INSTANCE |
Number(10,0) | DECIMAL(10) NOT NULL | Process Instance |
| 2 | GPAU_COMSUPR_AGCY |
Character(20) | VARCHAR2(20) NOT NULL | GPAUS - Stores the Scheme ID for ComSuper Employees - CSS or PSS. |
| 3 | GPAU_PAY_RUN_NBR |
Number(8,0) | INTEGER NOT NULL | This is the Payroll run number for com-super |
| 4 | END_DATE | Date(10) | DATE | End Date |
| 5 | GPAU_PAYCENTER_NO | Character(10) | VARCHAR2(10) NOT NULL | Pay Center Number |