HRS_PERSON_IDHRS_RCMNT_IDA=External Applicant
E=Employee
N=Non-Employee
Y/N Table Edit
Default Value: N
Default Value: HRS_APP_NOTIF_UNS
Prompt Table: WL_TEMPLATE_GEN
Default Value: 2
Default Value: 48
HRS_DRFTEXT_TAO(SQL Table) |
Index Back |
|---|---|
Candidate Communication EnhancTemporary record used in Unsubmitted Application text reminder Notification. |
| # | 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 | POSTING_TITLE | Character(200) | VARCHAR2(200) NOT NULL | Job posting title |
| 5 | FIRST_NAME | Character(30) | VARCHAR2(30) NOT NULL | First Name |
| 6 | APP_PER_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Identifies the type of applicant - External Applicant, Employee or Non-Employee
A=External Applicant E=Employee N=Non-Employee |
| 7 | HRS_SITE_ID | Number(15,0) | DECIMAL(15) NOT NULL | Site ID |
| 8 | 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 |
| 9 | 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 |
| 10 | 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 |
| 11 | 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 |
| 12 | HRS_APP_CREATED_DT | DateTime(26) | TIMESTAMP | date application created |