GPS_MSG_EMPLIDPrompt Table: GPS_MSG_PERS_VW
EMPL_RCDGPS_EFFDT_STREFFSEQGPS_NOTIFIC_SRCADP=ADP
HR=Human Resources
Prompt Table: ACTION_TBL
Y/N Table Edit
Default Value: N
Prompt Table: ACTN_REASON_TBL
Default Value: %date
GPS_POST_NTF_VW(SQL View) |
Index Back |
|---|---|
GPS Post Mngmnt NotificationsGeman Public Sector notifications for Post Management. |
| SELECT DISTINCT N.EMPLID ,N.EMPL_RCD ,%DateOut(N.EFFDT) ,N.EFFSEQ ,N.GPS_NOTIFIC_SRC ,N.ACTION ,N.PIN_NM ,N.GPS_CHECK_FLAG ,N.ACTION_REASON ,N.BEGIN_DT ,N.RETURN_DT FROM %Table(GPS_POST_NOTIFY) N WHERE GPS_NOTIFIC_SRC= 'HR' OR (GPS_NOTIFIC_SRC= 'ADP' AND (ACTION='ABS' OR ACTION='CC')) |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | GPS_MSG_EMPLID |
Character(11) | VARCHAR2(11) NOT NULL |
Employee Id for GPS System Mesage query
Prompt Table: GPS_MSG_PERS_VW |
| 2 | EMPL_RCD |
Number(3,0) | SMALLINT NOT NULL | Empl Record |
| 3 | GPS_EFFDT_STR |
Character(10) | VARCHAR2(10) NOT NULL | effective date |
| 4 | EFFSEQ |
Number(3,0) | SMALLINT NOT NULL | Effective Sequence |
| 5 | GPS_NOTIFIC_SRC |
Character(4) | VARCHAR2(4) NOT NULL |
Post Management Notification Source
ADP=ADP HR=Human Resources |
| 6 | ACTION | Character(3) | VARCHAR2(3) NOT NULL |
Action
Prompt Table: ACTION_TBL |
| 7 | PIN_NM | Character(18) | VARCHAR2(18) NOT NULL | Element Name field |
| 8 | GPS_CHECK_FLAG | Character(1) | VARCHAR2(1) NOT NULL |
Marked as Read flag.
Y/N Table Edit Default Value: N |
| 9 | ACTION_REASON | Character(3) | VARCHAR2(3) NOT NULL |
Reason Code
Prompt Table: ACTN_REASON_TBL |
| 10 | BEGIN_DT | Date(10) | DATE |
Begin Date
Default Value: %date |
| 11 | RETURN_DT | Date(10) | DATE | Return Date |