TEMPLATE_IDSDMC_EMAIL_SRC1=User Id
2=Role
3=Email Address
SDMC_EMAIL_VALUE1=User Id
2=Role
3=Email Address
Prompt Table: %EDITTABLE
A=Active
I=Inactive
Default Value: A
IN_SDMC_TMPLATE(SQL Table) |
Index Back |
|---|---|
Mass Change Email TemplatesTemplate for grouping email users |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | TEMPLATE_ID |
Character(30) | VARCHAR2(30) NOT NULL | Project Template |
| 2 | SDMC_EMAIL_SRC |
Character(1) | VARCHAR2(1) NOT NULL |
Email Source
1=User Id 2=Role 3=Email Address |
| 3 | SDMC_EMAIL_VALUE |
Character(100) | VARCHAR2(100) NOT NULL |
Email Value
1=User Id 2=Role 3=Email Address Prompt Table: %EDITTABLE |
| 4 | EFF_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Effective Status
A=Active I=Inactive Default Value: A |
| 5 | ROLENAME | Character(30) | VARCHAR2(30) NOT NULL | The name of a Role in the Role Definition Table (see PSROLEDEFN). |
| 6 | EMAILID | Character(70) | VARCHAR2(70) NOT NULL | A user's E-mail address |
| 7 | OPRID | Character(30) | VARCHAR2(30) NOT NULL | A user's ID (see PSOPRDEFN). |