GPSG_APPRATE_VW (SQL View)	Index Back
Sgp IRAS Benefit Rates Search view of IRAS rates table to include X'lat long name as alt search (since only short name usually appears).

GPSG_APPRATE_VW

(SQL View)

Sgp IRAS Benefit Rates

Search view of IRAS rates table to include X'lat long name as alt search (since only short name usually appears).

SELECT AR.GPSG_BEN_TYP_U , AR.EFFDT , X.XLATLONGNAME FROM PS_GPSG_APP_RATE AR , PSXLATITEM X WHERE X.FIELDNAME = 'GPSG_BEN_TYP_U' AND X.FIELDVALUE = AR.GPSG_BEN_TYP_U AND X.EFFDT = ( SELECT MAX(X1.EFFDT) FROM PSXLATITEM X1 WHERE X1.FIELDNAME = 'GPSG_BEN_TYP_U' AND X1.FIELDVALUE = AR.GPSG_BEN_TYP_U)

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 GPSG_BEN_TYP_U Character(3) VARCHAR2(3) NOT NULL Subset of Benifit Types used in Singapore IRAS reporting that require a unit rate to be provided.

2 EFFDT Date(10) DATE NOT NULL Effective Date
Default Value: %date

3 DESCR Character(30) VARCHAR2(30) NOT NULL Description

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	GPSG_BEN_TYP_U	Character(3)	VARCHAR2(3) NOT NULL	Subset of Benifit Types used in Singapore IRAS reporting that require a unit rate to be provided.
2	EFFDT	Date(10)	DATE NOT NULL	Effective Date Default Value: %date
3	DESCR	Character(30)	VARCHAR2(30) NOT NULL	Description