|
InfoAccess |
|
|
DATA VIEW NAME |
COURSE_ SECTION_ MEETING_STOUT |
|
OVERVIEW |
Contains the meeting information of course sections. Current and historical data. |
|
LOAD FREQUENCY |
Data is updated every night. |
|
DATA CUSTODIAN |
Registrar Records
& Registration |
|
AUTHORIZATION |
You must receive approval to access data from the data custodian. For information about how to get authorized for InfoAccess data views, connect to the InfoAccess web site |
|
SPECIAL CONSIDERATIONS |
Key fields are identified with an asterisk (*) |
|
QUESTIONS |
Contact: Division
of Information Technology Help Desk |
|
LAST UPDATED |
2/03 Created |
|
FIELD DEFINITIONS |
Key fields are identified with an asterisk (*). Field formats describe the field type and length. |
|
DATA FORMATS |
The codes following the field names in this document define the field. The different types are: |
|
CHAR 2(N) OR CHAR (N) |
Alphanumeric. (N)is the length of the field. Field contains letters and/or numbers. Example: CHAR (5) could contain ‘ABC12’ or ‘12345’ or ‘ABCDEF’ (N) is the length of the field. Field contains letters and/or numbers. |
|
NUM (N) |
Numeric Field. (N) is the length of the field. Field contains only numbers. Numbers with decimal points are represented as NUM (X.Y) X=total number of digits Y=the number of decimals after the decimal Examples: NUM (6,2) could contain 2500.12 NUM(6)could contain 000005 or 550000 |
|
DATE (XXXX) |
Date field. (XXXX)is the format of the field. Date can be in various formats and date functions available based on your query tool can be used against the field. Examples: DATE(YYMMDD);DATE(YYDDD);DATE(DD-MM-YY) |
|
Column Name |
Format |
Description |
|---|---|---|
|
MEETING_ID |
NUM 15 |
Sequence Number |
|
TERM |
CHAR 8 |
Term Course Offered In |
|
SECTION_ ID |
CHAR 8 |
Section ID |
|
INSTRUCTOR_NAME |
CHAR 40 |
Full Name Of Instructor |
|
INSTRUCTOR_LNAME |
CHAR 20 |
Last Name Of Instructor |
|
INSTRUCTOR_FNAME |
CHAR 20 |
First Name Of Instructor |
|
INSTRUCTOR_PERSON_ID |
CHAR 7 |
ID Of Instructor |
|
MEETING_START_TIME |
CHAR 7 |
Start Time Of Course Meeting |
|
MEETING_END_TIME |
CHAR 7 |
End Time Of Course Meeting |
|
MEETING_START_DATE |
DATE 19 |
Start Date Of Course Meeting |
|
MEETING_END_DATE |
DATE 19 |
End Date Of Course Meeting |
|
MEETING _BLDG |
CHAR 4 |
Building Class Is Held In |
|
MEETING_ ROOM |
CHAR 4 |
Room Class Is Held In |
|
MEETING_DAY_CODE |
CHAR 7 |
Code Of Day Of Week Class Is (ie. M W F) |
|
MEETING_INSTR_METHOD |
CHAR 4 |
Type Of Meeting (ie. Lab, Disc, Lect) |
|
EXTRACT_DATE_TIME |
DATE19 |
Date Time Transaction Loaded |