NOTIFICATION_IDE=Error Notification
H=Hire Notifications
Default Value: H
Prompt Table: HR_HIRE_QRY
HR_HIR_NTF_VW(SQL View) |
Index Back |
|---|---|
Hire Notification |
| SELECT NOTIFICATION_ID ,NOTIFICATION_TYPE ,ROLE_QUERY_NM FROM PS_NOTIFCATN_SETUP WHERE NOTIFICATION_TYPE = 'H' |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | NOTIFICATION_ID |
Number(10,0) | DECIMAL(10) NOT NULL | Notification ID to track each Notifications |
| 2 | NOTIFICATION_TYPE | Character(1) | VARCHAR2(1) NOT NULL |
Notification Type
E=Error Notification H=Hire Notifications Default Value: H |
| 3 | ROLE_QUERY_NM | Character(30) | VARCHAR2(30) NOT NULL |
Role Query Name
Prompt Table: HR_HIRE_QRY |