BUSINESS_UNITPrompt Table: SP_BU_SF_NONVW
OPRIDCASHIER_OFFICEN=No Access
Y=Read/Write Access
SP_CSHOFF_OPRVW(SQL View) |
Index Back |
|---|---|
Sec Vw - BU Cashier - Operator |
| select a.business_unit ,b.oprid ,a.cashier_office ,c.descr ,a.access_cd from ps_sec_cshoff_opr a ,PSOPRDEFN b ,ps_csh_off_tbl c where a.access_cd = 'Y' and a.business_unit = c.business_unit and a.cashier_office = c.cashier_office and a.oprid = b.oprid |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | BUSINESS_UNIT |
Character(5) | VARCHAR2(5) NOT NULL |
Business Unit
Prompt Table: SP_BU_SF_NONVW |
| 2 | OPRID |
Character(30) | VARCHAR2(30) NOT NULL | A user's ID (see PSOPRDEFN). |
| 3 | CASHIER_OFFICE |
Character(8) | VARCHAR2(8) NOT NULL | Cashier's Office |
| 4 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
| 5 | ACCESS_CD | Character(1) | VARCHAR2(1) NOT NULL |
Access Code
N=No Access Y=Read/Write Access |