SPB_USRSTP_ROLE (SQL Table)	Index Back
Roles for User Setup Roles for User Setup

SPB_USRSTP_ROLE

(SQL Table)

Roles for User Setup

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 SP_USER_TYPE Character(2) VARCHAR2(2) NOT NULL Field to identify User Types
AD=Service Administrator
CM=Common
CO=Service Coordinator
EA=Expense Approver
IA=Invoice Approver
PA=Progress Log Approver
PC=Service Provider Contact
RA=Requisition Approver
RQ=Requester
SA=Supplier Administrator
SC=Supplier Coordinator
SP=Service Provider
TA=Timesheet Approver
WA=Work Order Approver

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

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	SP_USER_TYPE	Character(2)	VARCHAR2(2) NOT NULL	Field to identify User Types AD=Service Administrator CM=Common CO=Service Coordinator EA=Expense Approver IA=Invoice Approver PA=Progress Log Approver PC=Service Provider Contact RA=Requisition Approver RQ=Requester SA=Supplier Administrator SC=Supplier Coordinator SP=Service Provider TA=Timesheet Approver WA=Work Order Approver
2	ROLENAME	Character(30)	VARCHAR2(30) NOT NULL	The name of a Role in the Role Definition Table (see PSROLEDEFN). Prompt Table: PSROLEDEFN