EM_ROLE_CONFIG (SQL Table)	Index Back
eS - Rolename System Access eSettlements table for configuring user-defined roleanames with the equivalent eSettlements system access.

EM_ROLE_CONFIG

(SQL Table)

eS - Rolename System Access

eSettlements table for configuring user-defined roleanames with the equivalent eSettlements system access.

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 EM_ROLENAME Character(30) VARCHAR2(30) NOT NULL The name of a Role in the Role Definition table. Used in the eS Role Configuration page.
Prompt Table: ROLEDEFN_VW1

2 EM_ROLETYPE Character(2) VARCHAR2(2) NOT NULL Field indicates for each user-defined Role, what type of Role it is in relation to the eS application.
05=Buyer User
10=Buyer Administrator
15=Buyer Accountant
20=Operational Approver
25=Supplier User
30=Supplier Administrator
35=System Administrator

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	EM_ROLENAME	Character(30)	VARCHAR2(30) NOT NULL	The name of a Role in the Role Definition table. Used in the eS Role Configuration page. Prompt Table: ROLEDEFN_VW1
2	EM_ROLETYPE	Character(2)	VARCHAR2(2) NOT NULL	Field indicates for each user-defined Role, what type of Role it is in relation to the eS application. 05=Buyer User 10=Buyer Administrator 15=Buyer Accountant 20=Operational Approver 25=Supplier User 30=Supplier Administrator 35=System Administrator