GPSG_IRAS_CATEGORYEFFDTDefault Value: %date
PIN_NUMPrompt Table: GPSG_YTD_ACM_VW
Default Value: 1
GPSG_NRP_IR1_VW(SQL View) |
Index Back |
|---|---|
GP Sgp IRAS Report CategoriesDefines the GP elements that are to be included each of the IRAS reporting categories |
| SELECT GPSG_IRAS_CATEGORY ,EFFDT ,PIN_NUM + 50000000 ,GPSG_MULTIPLIER FROM PS_GPSG_IRAS_CAT |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | 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. |
| 2 | EFFDT |
Date(10) | DATE NOT NULL |
Effective Date
Default Value: %date |
| 3 | PIN_NUM |
Number(8,0) | INTEGER NOT NULL |
PIN Number
Prompt Table: GPSG_YTD_ACM_VW |
| 4 | 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.
Default Value: 1 |