GPSG_IRAS_CATEGORYEFFDTDefault Value: %date
GPSG_IRAS_CATVW(SQL View) |
Index Back |
|---|---|
GP Sgp IRAS Report CategoriesSearch view of Singapore IRAS reporting categories to include X'lat long name as search field. |
| SELECT AR.GPSG_IRAS_CATEGORY , AR.EFFDT , X.XLATLONGNAME FROM PS_GPSG_IRAS_CATHD AR , PSXLATITEM X WHERE X.FIELDNAME = 'GPSG_IRAS_CATEGORY' AND X.FIELDVALUE = AR.GPSG_IRAS_CATEGORY AND X.EFFDT = ( SELECT MAX(X1.EFFDT) FROM PSXLATITEM X1 WHERE X1.FIELDNAME = 'GPSG_IRAS_CATEGORY' AND X1.FIELDVALUE = AR.GPSG_IRAS_CATEGORY) |
| # | 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 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |