SPB_USRTYPSRC_V(SQL View) |
Index Back |
|---|---|
User Type Search ViewSearch view for User Type |
| SELECT DISTINCT U.SP_USER_TYPE , X1.XLATLONGNAME FROM PSXLATITEM X1 , ps_SPB_USRSTP_ROLE U WHERE X1.FIELDNAME= 'SP_USER_TYPE' AND %EffdtCheck(PSXLATITEM X2, X1, %CurrentDateIn) AND X1.EFF_STATUS = 'A' AND X1.FIELDVALUE = U.SP_USER_TYPE |
| # | 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 | XLATLONGNAME | Character(30) | VARCHAR2(30) NOT NULL | Translate Long Name |