GPSG_NRP_IR1_AD

(SQL Table)
Index Back

GP Sgp IRAS Report Categories

Defines the GP elements that are to be included each of the IRAS reporting categories

# 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.