HRS_EMAIL_SETUP_ID10=Active
20=Inactive
Prompt Table: HRS_EML_NODE_VW
Prompt Table: HRS_VSOURCE_VW2
HRS_EMAIL_SETUP(SQL Table) |
Index Back |
|---|---|
Email SetupEmail Setup |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | HRS_EMAIL_SETUP_ID |
Number(15,0) | DECIMAL(15) NOT NULL | Email Setup ID |
| 2 | HRS_EMAIL_STATUS | Character(3) | VARCHAR2(3) NOT NULL |
Email Setup Status
10=Active 20=Inactive |
| 3 | HRS_EMAIL_ADDR | Character(200) | VARCHAR2(200) NOT NULL | Email Address |
| 4 | MCF_USER | Character(254) | VARCHAR2(254) NOT NULL | User name |
| 5 | MCF_PASSWORD | Character(254) | VARCHAR2(254) NOT NULL | Password |
| 6 | MCF_SERVER | Character(254) | VARCHAR2(254) NOT NULL | Server Address |
| 7 | MSGNODENAME | Character(30) | VARCHAR2(30) NOT NULL |
Application Message Node Name. Name of the Application Message Node Definition. (see PSMSGNODEDEFN).
Prompt Table: HRS_EML_NODE_VW |
| 8 | HRS_SOURCE_ID | Number(15,0) | DECIMAL(15) NOT NULL |
Source ID
Prompt Table: HRS_VSOURCE_VW2 |
| 9 | HRS_APPSERVER_PATH | Long Character(2000) | VARCHAR2(2000) NOT NULL | Application Server Path |