IN_PEG_USER_SEC(SQL Table) |
Index Back |
|---|---|
Pegging Security12/20/04 EGS: Created 05/30/07 EGS: Added ALLOW_COMP_CHNG and LIMIT_COMP_CHNG. |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  OPRID |
Character(30) | VARCHAR2(30) NOT NULL |
A user's ID (see PSOPRDEFN).
Prompt Table: PSOPRDEFN_SRCH |
| 2 | PEG_MSR | Character(1) | VARCHAR2(1) NOT NULL |
Peg Stock Requests
Y/N Table Edit Default Value: N |
| 3 | PEG_PO | Character(1) | VARCHAR2(1) NOT NULL |
Peg Purchase Orders
Y/N Table Edit Default Value: N |
| 4 | PEG_PRO | Character(1) | VARCHAR2(1) NOT NULL |
Peg Production Output
Y/N Table Edit Default Value: N |
| 5 | PEG_REQ | Character(1) | VARCHAR2(1) NOT NULL |
Peg Requisitions
Y/N Table Edit Default Value: N |
| 6 | PEG_XRS | Character(1) | VARCHAR2(1) NOT NULL |
Peg Transfer Supply
Y/N Table Edit Default Value: N |
| 7 | PEG_XFR | Character(1) | VARCHAR2(1) NOT NULL |
Peg Transfer Demand
Y/N Table Edit Default Value: N |
| 8 | PEG_WSM | Character(1) | VARCHAR2(1) NOT NULL |
Peg Work Orders
Y/N Table Edit Default Value: N |
| 9 | PEG_SO | Character(1) | VARCHAR2(1) NOT NULL |
Peg Sales Orders
Y/N Table Edit Default Value: N |
| 10 | ALLOW_COMP_CHNG | Character(1) | VARCHAR2(1) NOT NULL |
05/01/07 EGS: Created
Y/N Table Edit Default Value: N |
| 11 | LIMIT_COMP_CHNG | Character(1) | VARCHAR2(1) NOT NULL |
05/30/06 EGS: Created
Y/N Table Edit Default Value: Y |