Course

Detailed View

course_record

Each row of course_record contains data fields for a specific course record.

Column	Data Type	Not NULL?	Comment
id	bigint	false	System-generated sequential ID.
record_id	bigint	false	Foreign key to record.
begin_date	timestamptz	false	The date on which the course begins.
end_date	timestamptz	false	The date on which the course ends.
location_code	varchar	false	The code for the physical location of the items placed on reserve.
ccode1	varchar	false	The library determines the name and purpose of this code and the code's definition.
ccode2	varchar	false	The library determines the name and purpose of this code and the code's definition.
ccode3	varchar	false	The library determines the name and purpose of this code and the code's definition.
is_suppressed	boolean	false	Specifies whether the record is suppressed from public display.

course_view

Each row of course_view includes metadata and data for one course record. The contents include identification, descriptive information, and library-specified course codes 1-3, as well as data that determines how the system handles the record.

Column	Data Type	Not NULL?	Comment
id	bigint	false	System-generated sequential ID.
record_type_code	char	false	Record type code, i.e., 'r'.
record_num	int	false	Record number.
begin_date	timestamptz	false	The date on which the course begins.
end_date	timestamptz	false	The date on which the course ends.
location_code	varchar	false	The code for the physical location of the items placed on reserve.
ccode1	varchar	false	The library determines the name and purpose of this code and the code's definition.
ccode2	varchar	false	The library determines the name and purpose of this code and the code's definition.
ccode3	varchar	false	The library determines the name and purpose of this code and the code's definition.
record_creation_date_gmt	timestamptz	false	Record creation date.

user_defined_ccode1_myuser

Each row of user_defined_ccode1_myuser identifies a user-defined fixed-length field for course records.

Column	Data Type	Not NULL?	Comment
code	varchar	false	User-defined code to represent the user-defined field.
user_defined_category_id	int	false	Foreign key to user_defined_category.
display_order	int	false	Integer to manage the display order of a list.
name	varchar	false	The user-defined name assigned to the user-defined field.

user_defined_ccode2_myuser

Each row of user_defined_ccode2_myuser identifies a user-defined fixed-length field for course records.

Column	Data Type	Not NULL?	Comment
code	varchar	false	User-defined code to represent the user-defined field.
user_defined_category_id	int	false	Foreign key to user_defined_category.
display_order	int	false	Integer to manage the display order of a list.
name	varchar	false	The user-defined name assigned to the user-defined field.

user_defined_ccode3_myuser

Each row of user_defined_ccode32_myuser identifies a user-defined fixed-length field for course records.

Column	Data Type	Not NULL?	Comment
code	varchar	false	User-defined code to represent the user-defined field.
user_defined_category_id	int	false	Foreign key to user_defined_category.
display_order	int	false	Integer to manage the display order of a list.
name	varchar	false	The user-defined name assigned to the user-defined field.