SCC_GE_CATGRY_CODEOPRIDEFFDTDefault Value: %date
A=Active
I=Inactive
Default Value: A
SCC_GE_CD_SCTY3(SQL View) |
Index Back |
|---|---|
Eval Management Cd Scrty Vw3Evaluation Management System Evaluation Code Security View. Returns the Evaluation Codes the user has Update access for (based on the Category specified). |
| SELECT DISTINCT A.SCC_GE_EVAL_CATGRY %Concat 'x' %Concat A.SCC_GE_EVALUATN_CD , B.OPRID , A.EFFDT , A.EFF_STATUS , A.SCC_GE_EVAL_CATGRY , A.SCC_GE_EVALUATN_CD , A.SCC_GE_DESCR FROM PS_SCC_GE_EC_DEFN 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 (A.SCC_GE_EVALUATN_CD = B.SCC_GE_EVALUATN_CD OR B.SCC_GE_EVALUATN_CD = 'ALL') AND B.ENTRY_USE_IND = 'Y' |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | SCC_GE_CATGRY_CODE |
Character(21) | VARCHAR2(21) NOT NULL | Combines the values of SCC_GE_EVAL_CATGRY and SCC_GE_EVALUATION_Cd |
| 2 | OPRID |
Character(30) | VARCHAR2(30) NOT NULL | A user's ID (see PSOPRDEFN). |
| 3 | EFFDT |
Date(10) | DATE |
Effective Date
Default Value: %date |
| 4 | EFF_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Effective Status
A=Active I=Inactive Default Value: A |
| 5 | SCC_GE_EVAL_CATGRY | Character(10) | VARCHAR2(10) NOT NULL | Evaluation Category |
| 6 | SCC_GE_EVALUATN_CD | Character(10) | VARCHAR2(10) NOT NULL | Evaluation Code |
| 7 | SCC_GE_DESCR | Character(50) | VARCHAR2(50) NOT NULL | Description |