COMPETENCYCOURSESESSION_NBRCOMP_TRAINING(SQL View) |
Index Back |
|---|---|
Competency TrainingThis view selects active course sessions that train for a particular competency. |
| SELECT c.competency , b.course , b.session_nbr , b.course_start_dt , b.course_end_dt ,b.sessn_start_time ,b.sessn_end_time , b.max_students FROM PS_CRSE_SESSN_TBL B , ps_course_comps C WHERE c.course = b.course AND b.session_status = 'A' |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | COMPETENCY |
Character(8) | VARCHAR2(8) NOT NULL | Competency |
| 2 | COURSE |
Character(6) | VARCHAR2(6) NOT NULL | Course Code |
| 3 | SESSION_NBR |
Character(4) | VARCHAR2(4) NOT NULL | Course Session Nbr |
| 4 | COURSE_START_DT | Date(10) | DATE | Course Start Date |
| 5 | COURSE_END_DT | Date(10) | DATE | Course End Date |
| 6 | SESSN_START_TIME | Time(15) | TIMESTAMP | Start Time |
| 7 | SESSN_END_TIME | Time(15) | TIMESTAMP | End Time |
| 8 | MAX_STUDENTS | Number(3,0) | SMALLINT NOT NULL | Maximum Nbr of Students |