EX_EE_PRIV_LANG (SQL Table)	Index Back
Privilege Template Privilege Template. This record stores the privilege templates for the T&E approval transactions.

EX_EE_PRIV_LANG

(SQL Table)

Privilege Template

Privilege Template. This record stores the privilege templates for the T&E approval transactions.

Related Language Record for EX_EE_PRIV_TMPL

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 SETID Character(5) VARCHAR2(5) NOT NULL SetID
Prompt Table: SP_SETID_NONVW

2 TE_TRANS_TYPE Character(2) VARCHAR2(2) NOT NULL User Privilege Template Transaction Types
CA=Cash Advance
ER=Expense Report
TA=Travel Authorization
TR=Time Report

3 PRIVILEGE_TMPL_ID Character(15) VARCHAR2(15) NOT NULL Privilege Template Id. Contains the name of the privilege template.

4 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code

5 EFFDT Date(10) DATE NOT NULL Effective Date
Default Value: %date

6 DESCR Character(30) VARCHAR2(30) NOT NULL Description

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	SETID	Character(5)	VARCHAR2(5) NOT NULL	SetID Prompt Table: SP_SETID_NONVW
2	TE_TRANS_TYPE	Character(2)	VARCHAR2(2) NOT NULL	User Privilege Template Transaction Types CA=Cash Advance ER=Expense Report TA=Travel Authorization TR=Time Report
3	PRIVILEGE_TMPL_ID	Character(15)	VARCHAR2(15) NOT NULL	Privilege Template Id. Contains the name of the privilege template.
4	LANGUAGE_CD	Character(3)	VARCHAR2(3) NOT NULL	Language Code
5	EFFDT	Date(10)	DATE NOT NULL	Effective Date Default Value: %date
6	DESCR	Character(30)	VARCHAR2(30) NOT NULL	Description