Section

section_record

Each row of section_record contains data fields for a specific section record.

Column

Data Type

Not NULL?

Comment

id

bigint

false

System-generated sequential ID.

record_id

bigint

false

Foreign key to record.

location_code

varchar

false

The room location code where the sessions take place.

status_code

char

false

The status of the section.

CODE     

DEFINITION

a

ACTIVE

i

INACTIVE

c

CANCELLED

 

program_record_id

bigint

false

Foreign key to program_record.

section_display_order

int

false

Integer to manage the display order of a list.

min_seats

int

false

The fewest number of registrations required in order for the section to take place.

max_seats

int

false

The largest number of registrations allowed for the section.

reg_open_date_gmt

timestamp

false

The earliest date and time at which patrons can register for the section.

reg_close_date_gmt

timestamp

false

The date and time at which registration closes and patrons can no longer register for the section.

ecommerce_code

char

false

Code indicating ecommerce payment.

max_alert_sent_date_gmt

timestamp

false

The date and time the system sent a Section Filling alert email to the supervisor.

tickler_sent_date_gmt

timestamp

false

The date and time the system sent a Section Starting Soon alert email to the operator and an email reminder to the instructor and all patrons registered for the section.

min_alert_sent_date_gmt

timestamp

false

The date and time the system sent a Minimum alert email to the supervisor.

max_waitlist_num

int

false

The largest number of waitlist entries allowed for the section. A value of 0 deactivates the waitlist and does not enable the system, staff, or patrons to place entries on the waitlist. The default value is 99.

zcode1

char

false

The library determines the name and purpose of this code and the code's definition.

zcode2

char

false

The library determines the name and purpose of this code and the code's definition.

zcode3

char

false

Controls display of the section in the WebPAC.

CODE     

DEFINITION

-

DISPLAY

n

SUPPRESS

 

is_suppressed

boolean

false

Specifies whether the record is suppressed from public display.

section_record_session

Each row of section_record_session describes a program section record.

Column

Data Type

Not NULL?

Comment

section_record_id

bigint

false

Foreign key to section_record.

start_date

timestamptz

false

Start date of the session.

duration_minutes

int

false

Duration of the section, in minutes.

session_display_order

int

false

Integer to manage the display order of a session list.

id

bigint

false

System-generated sequential ID.

start_date_str

char

false

Start date of the session. (Alternate format)

section_registration_seat

Each row of section_registration_seat describes the status of section registration seat.

Column

Data Type

Not NULL?

Comment

id

bigint

false

System-generated sequential ID.

section_record_id

bigint

false

Foreign key to section_record.

patron_record_id

bigint

false

Foreign key to patron_record.

reg_date_gmt

timestamp

false

Date the seat was registered.

is_registered

boolean

false

Specifies whether the seat is registered.

seat_note

varchar

false

Text note associated with the section seat.

payment_id

bigint

false

Foreign key to payment.

reg_date

char

false

Date the seat was registered. (Alternate format)

section_view

Each row of section_view includes metadata and data for one section record. The contents include identification and descriptive information, 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., 's'.

record_num

int

false

Record number.

location_code

varchar

false

The room location code where the sessions take place.

status_code

char

false

The status of the section.

CODE 

DEFINITION

a

ACTIVE

i

INACTIVE

c

CANCELLED

 

program_record_id

bigint

false

Foreign key to program_record.

section_display_order

int

false

Integer to manage the display order of a list.

min_seats

int

false

The fewest number of registrations required in order for the section to take place.

max_seats

int

false

The largest number of registrations allowed for the section.

reg_open_date_gmt

timestamp

false

The earliest date and time at which patrons can register for the section.

reg_close_date_gmt

timestamp

false

The date and time at which registration closes and patrons can no longer register for the section.

ecommerce_code

char

false

Code indicating ecommerce payment.

max_alert_sent_date_gmt

timestamp

false

The date and time the system sent a Section Filling alert email to the supervisor.

tickler_sent_date_gmt

timestamp

false

The date and time the system sent a Section Starting Soon alert email to the operator and an email reminder to the instructor and all patrons registered for the section.

min_alert_sent_date_gmt

timestamp

false

The date and time the system sent a Minimum alert email to the supervisor.

max_waitlist_num

int

false

The largest number of waitlist entries allowed for the section. A value of 0 deactivates the waitlist and does not enable the system, staff, or patrons to place entries on the waitlist. The default value is 99.

zcode1

char

false

The library determines the name and purpose of this code and the code's definition.

zcode2

char

false

The library determines the name and purpose of this code and the code's definition.

zcode3

char

false

Controls display of the section in the WebPAC.

CODE     

DEFINITION

-

DISPLAY

n

SUPPRESS

 

is_suppressed

boolean

false

Specifies whether the record is suppressed from public display.

session_attendance

Each row of session_attendance describes the program session attendance history of a patron.

Column

Data Type

Not NULL?

Comment

id

bigint

false

System-generated sequential ID.

section_record_session_id

bigint

false

Foreign key to section_record_session.

section_registration_seat_id

bigint

false

Foreign key to section_registration_seat.

patron_record_id

bigint

false

Foreign key to patron_record.

total_attended

int

false

Total number of sessions attended by the associated patron.

user_defined_zcode1_myuser

Each row of user_defined_zcode1_myuser identifies a user-defined fixed-length field for section 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_zcode2_myuser

Each row of user_defined_zcode2_myuser identifies a user-defined fixed-length field for section 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_zcode3_myuser

Each row of user_defined_zcode3_myuser identifies a user-defined fixed-length field for section 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.