SCD_EVALUATION_IDSCD_EVL_INFO_VW(SQL View) |
Index Back |
|---|---|
Evaluation Information for KPIEvaluation Information for KPI |
| SELECT H.SCD_EVALUATION_ID , H.SCD_EVALTEE_SETID AS VENDOR_SETID , H.SCD_EVALUATEE_ID AS VENDOR_ID , H.SCD_CAL_SETID CALENDAR_SETID , H.CALENDAR_ID , H.SCD_FROM_DATE , H.SCD_TO_DATE FROM PS_SCD_BLD_EVAL_HD H |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | SCD_EVALUATION_ID |
Character(10) | VARCHAR2(10) NOT NULL | Evaluation ID |
| 2 | VENDOR_SETID | Character(5) | VARCHAR2(5) NOT NULL | Vendor SetID |
| 3 | VENDOR_ID | Character(10) | VARCHAR2(10) NOT NULL | Vendor Identifier |
| 4 | CALENDAR_SETID | Character(5) | VARCHAR2(5) NOT NULL | Calendar SetID |
| 5 | CALENDAR_ID | Character(2) | VARCHAR2(2) NOT NULL | Calendar ID |
| 6 | SCD_FROM_DATE | Date(10) | DATE | From Date |
| 7 | SCD_TO_DATE | Date(10) | DATE | To Date |