HRS_PERSON_IDHRS_RCMNT_IDY/N Table Edit
Default Value: N
Default Value: HRS_APP_NOTIF_UNS
Prompt Table: WL_TEMPLATE_GEN
Default Value: 2
Default Value: 48
HRS_UNSUB_NT_VW(SQL View) |
Index Back |
|---|---|
Unsubmitted Notification ViewUnsubmitted Notification View |
| SELECT A.HRS_PERSON_ID ,A.HRS_RCMNT_ID ,A.HRS_JOB_OPENING_ID ,A.HRS_SITE_ID ,B.HRS_DRAFTAPP_NOTFY ,B.HRS_USUB_TEMPLT_ID ,B.HRS_REMINDER_DAYS ,B.HRS_STOP_NOTFY_HRS FROM PS_HRS_JO_APP_SITE A , PS_HRS_SITE_ID B , PS_HRS_SITE_CG C WHERE A.HRS_SITE_ID = B.HRS_SITE_ID AND B.HRS_SITE_ID = C.HRS_SITE_ID |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | HRS_PERSON_ID |
Number(15,0) | DECIMAL(15) NOT NULL | Person Id |
| 2 | HRS_RCMNT_ID |
Number(15,0) | DECIMAL(15) NOT NULL | App Tracking Recruitment ID |
| 3 | HRS_JOB_OPENING_ID | Number(15,0) | DECIMAL(15) NOT NULL | Job Opening Clone |
| 4 | HRS_SITE_ID | Number(15,0) | DECIMAL(15) NOT NULL | Site ID |
| 5 | HRS_DRAFTAPP_NOTFY | Character(1) | VARCHAR2(1) NOT NULL |
Flag to check if email notification for unsubmitted/drafted applications is turned on.
Y/N Table Edit Default Value: N |
| 6 | HRS_USUB_TEMPLT_ID | Character(30) | VARCHAR2(30) NOT NULL |
Template to be used in Registration Notification.
Default Value: HRS_APP_NOTIF_UNS Prompt Table: WL_TEMPLATE_GEN |
| 7 | HRS_REMINDER_DAYS | Number(2,0) | SMALLINT NOT NULL |
Field to store number of days after which a repeat reminder to be sent.
Default Value: 2 |
| 8 | HRS_STOP_NOTFY_HRS | Number(3,0) | SMALLINT NOT NULL |
Field to store number of hours before job close date when the notification need to be stopped for unsubmitted/draft notifications.
Default Value: 48 |