OPRIDPrompt Table: CS_OPRDEFTBL_VW
CS_OPRDEFTBL_VW(SQL View) |
Index Back |
|---|---|
SCMT user pref4/26/2019 Image 33 PSFTSCMT-258 SCMT user preferences |
| SELECT oprid , cs_full_access , cs_admin_access , cs_skip_approval , cs_import_appr , cs_update_current FROM PS_OPR_DEF_TBL_CS WHERE cs_admin_access = 'Y' |
| # | 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: CS_OPRDEFTBL_VW |
| 2 | CS_FULL_ACCESS | Character(1) | VARCHAR2(1) NOT NULL | Full Authorization for All Doc |
| 3 | CS_ADMIN_ACCESS | Character(1) | VARCHAR2(1) NOT NULL | Document Administrator |
| 4 | CS_SKIP_APPROVAL | Character(1) | VARCHAR2(1) NOT NULL | Bypass Approval |
| 5 | CS_IMPORT_APPR | Character(1) | VARCHAR2(1) NOT NULL | Import Document |
| 6 | CS_UPDATE_CURRENT | Character(1) | VARCHAR2(1) NOT NULL | Reset to Dispatch |