SCC_GE_EVAL_CATGRYOPRIDSCC_GE_CAT_SCTY(SQL View) |
Index Back |
|---|---|
Eval Management Ctgry Scrty VwEvaluation Management System Security View for Evaluation Categories. Returns the Evaluation Categories the user has Inquiry or Update access for. |
| SELECT DISTINCT A.SCC_GE_EVAL_CATGRY , B.OPRID ,A.SCC_GE_DESCR FROM PS_SCC_GE_CATEGORY A , PS_SCC_GE_SCRTY B WHERE (A.SCC_GE_EVAL_CATGRY = B.SCC_GE_EVAL_CATGRY OR B.SCC_GE_EVAL_CATGRY = 'ALL') AND (B.INQUIRY_USE_IND = 'Y' OR B.ENTRY_USE_IND = 'Y') |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | SCC_GE_EVAL_CATGRY |
Character(10) | VARCHAR2(10) NOT NULL | Evaluation Category |
| 2 | OPRID |
Character(30) | VARCHAR2(30) NOT NULL | A user's ID (see PSOPRDEFN). |
| 3 | SCC_GE_DESCR | Character(50) | VARCHAR2(50) NOT NULL | Description |