SPB_USER_LIST

(SQL Table)
Index Back

user created tracking table

SPRO - this table stores oprid and created by and created date. Populated only when registering new administrators and approvers.

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).
2 SPB_USER_TYPE Character(1) VARCHAR2(1) NOT NULL spro user type translate field
1=Requester
2=Service Coordinator
3=Service Provider Contact
4=Service Provider
5=Service Administrator
6=Approver
3 ROW_CREATE_USER Character(30) VARCHAR2(30) NOT NULL Row Added By
4 ROW_MODIFY_USER Character(30) VARCHAR2(30) NOT NULL Modified User