SCC_GE_EVAL_CATGRYOPRIDSCC_GE_CATSCTY2(SQL View) |
Index Back |
|---|---|
Eval Management Ctgy Scrty Vw2Evaluation Management System Security View for Evaluation Categories. Returns the Evaluation Categories the user has 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.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 |