FO_ROLE_TMPL (SQL Table)	Index Back
Role-Template Record Record for templates based on the role.

FO_ROLE_TMPL

(SQL Table)

Role-Template Record

Record for templates based on the role.

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 ROLENAME Character(30) VARCHAR2(30) NOT NULL The name of a Role in the Role Definition Table (see PSROLEDEFN).
Prompt Table: FO_ROLENAME_VW

2 TEMPLATE_ID Character(30) VARCHAR2(30) NOT NULL Project Template
Prompt Table: FO_TEMPNAME_VW

3 DESCR1 Character(30) VARCHAR2(30) NOT NULL Descr

4 DESCR Character(30) VARCHAR2(30) NOT NULL Description
Prompt Table: FO_TEMPNAME_VW

5 FO_SINGLE_MAIL Character(1) VARCHAR2(1) NOT NULL Single mail template field
Y/N Table Edit

6 FO_MULTIPLE_MAIL Character(1) VARCHAR2(1) NOT NULL multiple mail template field
Y/N Table Edit

7 LASTUPDDTTM DateTime(26) TIMESTAMP Specifies the date and time of the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	ROLENAME	Character(30)	VARCHAR2(30) NOT NULL	The name of a Role in the Role Definition Table (see PSROLEDEFN). Prompt Table: FO_ROLENAME_VW
2	TEMPLATE_ID	Character(30)	VARCHAR2(30) NOT NULL	Project Template Prompt Table: FO_TEMPNAME_VW
3	DESCR1	Character(30)	VARCHAR2(30) NOT NULL	Descr
4	DESCR	Character(30)	VARCHAR2(30) NOT NULL	Description Prompt Table: FO_TEMPNAME_VW
5	FO_SINGLE_MAIL	Character(1)	VARCHAR2(1) NOT NULL	Single mail template field Y/N Table Edit
6	FO_MULTIPLE_MAIL	Character(1)	VARCHAR2(1) NOT NULL	multiple mail template field Y/N Table Edit
7	LASTUPDDTTM	DateTime(26)	TIMESTAMP	Specifies the date and time of the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.