# |
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_IRAS_CATEGORY |
Character(2) |
VARCHAR2(2) NOT NULL |
This field is used to group GP elements into categories for use in Singapore IRAS reporting.
|
3 |
EFFDT |
Date(10) |
DATE |
Effective Date
|
4 |
PIN_NUM |
Number(8,0) |
INTEGER NOT NULL |
PIN Number
|
5 |
GPSG_MULTIPLIER |
Signed Number(2,0) |
DECIMAL(1) NOT NULL |
Element Multiplier - used in categorising GP elements for IRAS reporting to determine if they add to or subtract from the total.
|