SPB_USR_TYPE_VW(SQL View) |
Index Back |
|---|---|
User Type viewList of User Types |
| SELECT DISTINCT SP_USER_TYPE FROM PS_SPB_USRSTP_ROLE |
| # | 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 |