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
Contact: Larry Graves

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
Phone:  264-HELP (4357)

LAST UPDATED

2/03 Created
03/08 Data Custodian change

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