SCD_BLD_EVTR_VW(SQL View) |
Index Back |
---|
SELECT 'IN' ,oprid ,oprdefndesc FROM PSOPRDEFN UNION SELECT 'RO' , rolename ,descr FROM PSROLEDEFN |
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | SCD_EVALUATOR_TYPE | Character(2) | VARCHAR2(2) NOT NULL |
Evaluator Type
IN=Individual RO=Role Default Value: IN |
2 | SCD_EVALUATOR_ID | Character(30) | VARCHAR2(30) NOT NULL | Evaluator ID |
3 | SCD_DESCR45 | Character(45) | VARCHAR2(45) NOT NULL | 45 Character Description |