HRS_SITE_TEXT(SQL Table) |
Index Back |
---|---|
RS Text Site TableRecord 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 |