HRS_CRSP_IDSEQNOEML=Email
LTR=Letter
1=Public
2=Private
I=In Process
N=Not Processed
Y=Processed
Default Value: N
HRS_GACT_STG(SQL Table) |
Index Back |
|---|---|
Staging table for HRS_ACT_MAILThis record is used to temporarily store data to be processed by the Application Engine program HRS_ACT_MAIL. |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | HRS_CRSP_ID |
Number(15,0) | DECIMAL(15) NOT NULL | Correspondence ID |
| 2 | SEQNO |
Number(5,0) | INTEGER NOT NULL | Sequence Number |
| 3 | HRS_RTE_ID | Number(15,0) | DECIMAL(15) NOT NULL | Route ID |
| 4 | HRS_RTE_SEQ | Number(3,0) | SMALLINT NOT NULL | Route Sequence |
| 5 | HRS_PERSON_ID | Number(15,0) | DECIMAL(15) NOT NULL | Person Id |
| 6 | HRS_RCMNT_ID | Number(15,0) | DECIMAL(15) NOT NULL | App Tracking Recruitment ID |
| 7 | HRS_CRSP_CHNL | Character(4) | VARCHAR2(4) NOT NULL |
Contact Method
EML=Email LTR=Letter |
| 8 | HRS_TMPL_ID | Character(30) | VARCHAR2(30) NOT NULL | Template ID |
| 9 | HRS_CRSP_EMAIL_TO | Long Character | CLOB | To |
| 10 | HRS_CRSP_EMAIL_CC | Long Character | CLOB | Cc |
| 11 | HRS_CRSP_EMAIL_BCC | Long Character | CLOB | Bcc |
| 12 | HRS_CRSP_FRM | Character(60) | VARCHAR2(60) NOT NULL | From |
| 13 | HRS_CRSP_SUBJ | Character(254) | VARCHAR2(254) NOT NULL | Subject |
| 14 | HRS_CRSP_MSG | Long Character | CLOB | Message |
| 15 | EMPLID | Character(11) | VARCHAR2(11) NOT NULL | Employee ID |
| 16 | HRS_CRSP_AUD | Character(1) | VARCHAR2(1) NOT NULL |
Access
1=Public 2=Private |
| 17 | HRS_INCLUDE_INTPTY | Character(1) | VARCHAR2(1) NOT NULL | Include Interested Parties |
| 18 | HRS_REPORT_DEFN_ID | Character(12) | VARCHAR2(12) NOT NULL | The Fusion Publisher Report Definition ID used by Recruiting |
| 19 | HRS_REPORT_TMPL_ID | Character(30) | VARCHAR2(30) NOT NULL | The Fusion publisher Report template ID used by RS. |
| 20 | HRS_RCPNT_INCL_EDT | Character(253) | VARCHAR2(253) NOT NULL | Include |
| 21 | HRS_SNDR_INCL_EDT | Character(253) | VARCHAR2(253) NOT NULL | Include |
| 22 | ROUTE_TO_ID | Character(11) | VARCHAR2(11) NOT NULL | Route To ID |
| 23 | HRS_APPL_NOTES | Long Character | CLOB | Notes |
| 24 | DESCRLONG | Long Character | CLOB | Long Description |
| 25 | PROCESSED | Character(1) | VARCHAR2(1) NOT NULL |
Processed?
I=In Process N=Not Processed Y=Processed Default Value: N |
| 26 | RESPONSE_DUE_DT | Date(10) | DATE | Response Due Date |