HRS_CRSP_IDHRS_PERSON_IDI=In Process
N=Not Processed
Y=Processed
Default Value: N
HRS_GACT_APPCSP(SQL Table) |
Index Back |
|---|---|
Staging table for HRS_ACT_MAILThis record is used to temporarily store data from HRS_APP_CRSP 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 | HRS_PERSON_ID |
Number(15,0) | DECIMAL(15) NOT NULL | Person Id |
| 3 | NAME_DISPLAY | Character(50) | VARCHAR2(50) NOT NULL | Display Name - name formatted for Display based on the Country |
| 4 | EMAIL_ADDR | Character(70) | VARCHAR2(70) NOT NULL | Email Address |
| 5 | HRS_PROFILE_SEQ | Number(3,0) | SMALLINT NOT NULL | Profile sequece |
| 6 | FIRST_NAME | Character(30) | VARCHAR2(30) NOT NULL | First Name |
| 7 | LAST_NAME | Character(30) | VARCHAR2(30) NOT NULL | Last Name |
| 8 | PROCESSED | Character(1) | VARCHAR2(1) NOT NULL |
Processed?
I=In Process N=Not Processed Y=Processed Default Value: N |
| 9 | HRS_INFO_URL | Long Character(2000) | VARCHAR2(2000) | Used to store the URL to go to for information on a source. |