LMS_CRSE_CMP_VW(SQL View) |
Index Back |
|---|---|
Course Component LMS File TypeThis view of the course component table is for the LMS file type |
| SELECT CRSE_ID ,EFFDT ,SSR_COMPONENT ,LMS_FILE_TYPE ,LMS_PROVIDER FROM PS_CRSE_COMPONENT |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  CRSE_ID |
Character(6) | VARCHAR2(6) NOT NULL |
Course ID
Prompt Table: CRSE_CATALOG |
| 2 | EFFDT |
Date(10) | DATE NOT NULL |
Effective Date
Default Value: %date |
| 3 | SSR_COMPONENT |
Character(3) | VARCHAR2(3) NOT NULL |
Course Component.
CLN=Clinical CON=Continuance DIS=Discussion FLD=Field Studies IND=Independent Study LAB=Laboratory LEC=Lecture PRA=Practicum RSC=Research SEM=Seminar SUP=Supervision THE=Thesis Research TUT=Tutorial |
| 4 | LMS_FILE_TYPE | Character(3) | VARCHAR2(3) NOT NULL |
LMS extract file type: XML compliant, Blackboard specific, and WebCT specific
BKB=Blackboard CourseInfo 4 WCT=API Input (old WebCT format) XML=XML V1.1 (req to authenticate) |
| 5 | LMS_PROVIDER | Character(30) | VARCHAR2(30) NOT NULL | Provider for Authentication |