GPS_PSTFUTDT_VW (SQL View)	Index Back
GPS Detect Future Dated row Detects if a details row has future effective date. This will then be displayed on the details grid

GPS_PSTFUTDT_VW

(SQL View)

GPS Detect Future Dated row

Detects if a details row has future effective date. This will then be displayed on the details grid

SELECT SETID ,GPS_POST_ID ,'Y' FROM PS_GPS_POST_DTL WHERE effdt > %CurrentDateIn

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 SETID Character(5) VARCHAR2(5) NOT NULL SetID

2 GPS_POST_ID Character(8) VARCHAR2(8) NOT NULL GPS post id

3 GPS_HAS_FUTURE_DT Character(1) VARCHAR2(1) NOT NULL Has Future Date
Y/N Table Edit

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	SETID	Character(5)	VARCHAR2(5) NOT NULL	SetID
2	GPS_POST_ID	Character(8)	VARCHAR2(8) NOT NULL	GPS post id
3	GPS_HAS_FUTURE_DT	Character(1)	VARCHAR2(1) NOT NULL	Has Future Date Y/N Table Edit