GPGB_PSLIPPFTLG(SQL Table) |
Index Back |
---|---|
UK Printed Payslips - FooterUK Printed Payslips - Footer |
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | Character(11) | VARCHAR2(11) NOT NULL | Employee ID | |
2 | Character(18) | VARCHAR2(18) NOT NULL | Calendar Run Id | |
3 | Number(3,0) | SMALLINT NOT NULL | Empl Rcd Nbr | |
4 | Character(10) | VARCHAR2(10) NOT NULL |
Global Payroll pay group
Prompt Table: GP_PYGRP |
|
5 | Character(18) | VARCHAR2(18) NOT NULL |
calendar id
Prompt Table: GP_CALENDAR |
|
6 | Number(4,0) | SMALLINT NOT NULL | Result Segment Number | |
7 | Character(1) | VARCHAR2(1) NOT NULL |
Message type
E=Employee Message P=Paygroup Message |
|
8 | Number(3,0) | SMALLINT NOT NULL | Instance Number | |
9 | Character(3) | VARCHAR2(3) NOT NULL | Language Code | |
10 | DESCRLONG | Long Character | CLOB | Long Description |