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). |