GPS_POST_NT_VW1

(SQL View)
Index Back

GPS Post Mngmnt Notifications

mangage notifications

SELECT EMPLID , EMPL_RCD , ACTION , GPS_NOTIFIC_SRC FROM PS_GPS_POST_NOTIFY WHERE ( GPS_NOTIFIC_SRC= 'HR' OR (GPS_NOTIFIC_SRC= 'ADP' AND (ACTION='ABS' OR ACTION='CC'))) AND GPS_CHECK_FLAG <> 'Y' GROUP BY EMPLID, EMPL_RCD, ACTION, GPS_NOTIFIC_SRC

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
2 EMPL_RCD Number(3,0) SMALLINT NOT NULL Empl Record
3 ACTION Character(3) VARCHAR2(3) NOT NULL Action

Prompt Table: GPS_ADP_ACT_VW

4 GPS_NOTIFIC_SRC Character(4) VARCHAR2(4) NOT NULL Post Management Notification Source
ADP=ADP
HR=Human Resources