| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 GP_PKG_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Field used for element packaging
|
| 2 |
GPSG_PAYSLIP_ID |
Character(18) |
VARCHAR2(18) NOT NULL |
Defines the payslip template ID
|
| 3 |
EFFDT |
Date(10) |
DATE |
Effective Date
|
| 4 |
SEQ_NUM |
Number(3,0) |
SMALLINT NOT NULL |
Sequence
|
| 5 |
DESCR |
Character(30) |
VARCHAR2(30) NOT NULL |
Description
|
| 6 |
GPSG_PIN_AC1_NUM |
Number(8,0) |
INTEGER NOT NULL |
This field will be used to store the pin number of accumulator 1. This accumulator is used for on-line and hard-copy payslips.
|
| 7 |
GPSG_PIN_AC2_NUM |
Number(8,0) |
INTEGER NOT NULL |
This field will be used to store the pin number of accumulator 2. This accumulator is used for on-line and hard-copy payslips.
|
| 8 |
GPSG_PIN_AC3_NUM |
Number(8,0) |
INTEGER NOT NULL |
This field will be used to store the pin number of accumulator 3. This accumulator is used for on-line and hard-copy payslips.
|
| 9 |
GPSG_PIN_AC4_NUM |
Number(8,0) |
INTEGER NOT NULL |
This field will be used to store the pin number of accumulator 4. This accumulator is used for on-line and hard-copy payslips.
|
| 10 |
GPSG_PIN_AC5_NUM |
Number(8,0) |
INTEGER NOT NULL |
This field will be used to store the pin number of accumulator 5. This accumulator is used for on-line and hard-copy payslips.
|
| 11 |
GPSG_PIN_AC6_NUM |
Number(8,0) |
INTEGER NOT NULL |
This field will be used to store the pin number of accumulator 6. This accumulator is used for on-line and hard-copy payslips.
|