ACCOMPLISHMENTCOMPETENCYNVQ_UNIT_REQ_VW(SQL View) |
Index Back |
|---|---|
NVQ Units Required ViewUnits required for NVQ View |
| SELECT a.accomplishment ,a.competency ,a.unit_nbr ,b.unit_title ,a.unit_optional FROM PS_NVQ_UNITS_REQ a , ps_competency_tbl b WHERE a.competency=b.competency |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | ACCOMPLISHMENT |
Character(8) | VARCHAR2(8) NOT NULL | Accomplishment |
| 2 | COMPETENCY |
Character(8) | VARCHAR2(8) NOT NULL | Competency |
| 3 | UNIT_NBR | Number(2,0) | SMALLINT NOT NULL | Number |
| 4 | UNIT_TITLE | Character(70) | VARCHAR2(70) NOT NULL | Unit Title |
| 5 | UNIT_OPTIONAL | Character(1) | VARCHAR2(1) NOT NULL | Optional Unit Flag |