IN_SDMC_TMPL_VW

(SQL View)
 Index Back

Mass Change Email Templates

Template for grouping email users

SELECT H.TEMPLATE_ID , H.SDMC_EMAIL_SRC , H.SDMC_EMAIL_VALUE , H.EFF_STATUS , H.ROLENAME , H.EMAILID , H.OPRID FROM PS_IN_SDMC_TMPLATE H

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