HRS_SITE_TEXT

(SQL Table)
Index Back

RS Text Site Table

Record storing the text configuration for site

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 HRS_SITE_ID Number(15,0) DECIMAL(15) NOT NULL Site ID
2 HRS_ALLOW_TXT Character(1) VARCHAR2(1) NOT NULL Flag to check if email notification for registration is turned on.

Y/N Table Edit

Default Value: N

3 HRS_TXT_REG_ACK_ID Character(5) VARCHAR2(5) NOT NULL Registration Acknowledgement ID

Prompt Table: HRS_ESIGN_DVW

4 HRS_OTP_DURATION Number(6,0) INTEGER NOT NULL OTP Expiry Duration(seconds)

Default Value: 60

5 HRS_REGISTER_NOTFY Character(1) VARCHAR2(1) NOT NULL Flag to check if email notification for registration is turned on.

Y/N Table Edit

Default Value: N

6 HRS_REG_TXT_ID Character(18) VARCHAR2(18) NOT NULL Text Template

Default Value: HRAM_APP_REG_TEXT

Prompt Table: HRS_SSTEXT_VW3

7 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

8 HRS_DFT_TXT_ID Character(18) VARCHAR2(18) NOT NULL Draft Text Template

Default Value: HRAM_APP_DRFT_TEXT

Prompt Table: HRS_SSTEXT_VW3

9 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.
10 HRS_REMINDER_DAYS Number(2,0) SMALLINT NOT NULL Field to store number of days after which a repeat reminder to be sent.
11 TW_ACCOUNT_ID Character(35) VARCHAR2(35) NOT NULL Twilio Account ID

Prompt Table: HRS_TWILIO