IN_SDMC_TMPLATE

(SQL Table)
Index Back

Mass Change Email Templates

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