HRS_APP_NOT_TAO (SQL Table)	Index Back
Candidate Communication Enhanc Candidate Communication Enhancement. Temporary record used in Unsubmitted Application reminder Notification.

HRS_APP_NOT_TAO

(SQL Table)

Candidate Communication Enhanc

Candidate Communication Enhancement. Temporary record used in Unsubmitted Application 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 NAME_DISPLAY Character(50) VARCHAR2(50) NOT NULL Display Name - name formatted for Display based on the Country

7 EMAIL_ADDR Character(70) VARCHAR2(70) NOT NULL Email Address

8 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

9 HRS_SITE_ID Number(15,0) DECIMAL(15) NOT NULL Site ID

10 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

11 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

12 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

13 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

14 HRS_APP_CREATED_DT DateTime(26) TIMESTAMP date application created

#	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	NAME_DISPLAY	Character(50)	VARCHAR2(50) NOT NULL	Display Name - name formatted for Display based on the Country
7	EMAIL_ADDR	Character(70)	VARCHAR2(70) NOT NULL	Email Address
8	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
9	HRS_SITE_ID	Number(15,0)	DECIMAL(15) NOT NULL	Site ID
10	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
11	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
12	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
13	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
14	HRS_APP_CREATED_DT	DateTime(26)	TIMESTAMP	date application created