Program

gtype_property

Each row of gtype_property identifies a program type code.

Column

Data Type

Not NULL?

Comment

id

int

false

System-generated sequential ID.

code_num

int

false

Program type code.

display_order

int

false

Integer to manage the display order of a list.

gtype_property_myuser

Each row of gtype_property_myuser identifies a program type, with the name presented in the language associated with the user's login account. Each library maintains its own list of program types.

Column

Data Type

Not NULL?

Comment

code

int

false

Program type code.

display_order

int

false

Integer to manage the display order of a list.

name

varchar

false

Program type name.

gtype_property_name

Each row of gtype_property_name identifies a program type name.

Column

Data Type

Not NULL?

Comment

gtype_property_id

int

false

Foreign key to gtype_property.

iii_language_id

int

false

Foreign key to iii_language.

name

varchar

false

Program type name.

program_record

Each row of program_record contains data fields for a specific program record.

Column

Data Type

Not NULL?

Comment

id

bigint

false

System-generated sequential ID.

record_id

bigint

false

Foreign key to record.

program_name

varchar

false

Name of the program.

reg_allowed_code

char

false

A value that determines whether the registration is:

CODE

DEFINITION

t

possible and required through the Millennium system, or optional (true or blank)

f

not possible through Millennium (false)

s

required by a third party but not possible through Millennium (special)

a

is used for an announcement in the program calendar (announcement)

m

possible in the Program Registration client, but not in the WebPAC (moderated)

n

not possible through Millennium (none)

 

allocation_rule_code

char

false

Code indicating a rule that controls multiple-registration maximums.

cost

numeric

false

The cost of attending the program.

eligibility_code

char

false

The code from the library's Patron Eligibility table for the patron types enabled to register in the program.

publication_start_date_gmt

timestamp

false

The date the program information is published to the WebPAC.

publication_end_date_gmt

timestamp

false

The date the program information is removed from the WebPAC.

tickler_days_to_start

int

false

The number of days before the first session of each section associated with the program that the system notifies staff, registered patrons, and the instructor of the impending first session.

min_alert_days_to_start

int

false

The number of days before the first session of each section associated with the program that the system notifies the program supervisor if the number of registrations is lower than the amount specified by the section MIN SEATS fixed-length field.

max_alert_seats_open

int

false

The number of vacant seats remaining in a section that triggers the Section Filling alert email.

reg_per_patron

int

false

Registrations per patron. The number of times a patron can register for the program. A value of '0' prevents any patron from registering for the program without a library staff member override.

program_type_code

int

false

The program type, defined by the library.

auto_transfer_code

char

false

Specifies whether patrons on the waitlist are automatically transferred to the registration list when seats on the registration list become available due to a cancellation (true) or whether transfers from the waitlist to the registration list must be done manually (false or blank).

is_right_result_exact

boolean

false

Controls program display position in the catalog search results.

gcode1

char

false

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

gcode2

char

false

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

gcode3

char

false

Controls display of the program in the WebPAC.

CODE

DEFINITION

-

DISPLAY

n

SUPPRESS

 

is_suppressed

boolean

false

Specifies whether the record is suppressed from public display.

program_record_location

Each row of program_record_location associates a program record with a location code.

Column

Data Type

Not NULL?

Comment

id

bigint

false

System-generated sequential ID.

program_record_id

bigint

false

Foreign key to program_record.

location_code

varchar

false

Location code.

display_order

int

false

Integer to manage the display order of a list.

program_view

Each row of program_view includes metadata and data for one program 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., 'g'.

record_num

int

false

Record number.

program_name

varchar

false

Name of the program.

reg_allowed_code

char

false

A value that determines whether the registration is:

CODE

DEFINITION

t

possible and required through the Millennium system, or optional (true or blank)

f

not possible through Millennium (false)

s

required by a third party but not possible through Millennium (special)

a

is used for an announcement in the program calendar (announcement)

m

possible in the Program Registration client, but not in the WebPAC (moderated)

n

not possible through Millennium (none)

 

allocation_rule_code

char

false

Code specifying a rule that controls multiple-registration maximums.

cost

numeric

false

The cost of attending the program.

eligibility_code

char

false

The code from the library's Patron Eligibility table for the patron types enabled to register in the program.

publication_start_date_gmt

timestamp

false

The date the program information is published to the WebPAC.

publication_end_date_gmt

timestamp

false

The date the program information is removed from the WebPAC.

tickler_days_to_start

int

false

The number of days before the first session of each section associated with the program that the system notifies staff, registered patrons, and the instructor of the impending first session.

min_alert_days_to_start

int

false

The number of days before the first session of each section associated with the program that the system notifies the program supervisor if the number of registrations is lower than the amount specified by the section MIN SEATS fixed-length field.

max_alert_seats_open

int

false

The number of vacant seats remaining in a section that triggers the Section Filling alert email.

reg_per_patron

int

false

Registrations per patron. The number of times a patron can register for the program. A value of '0' prevents any patron from registering for the program without a library staff member override.

program_type_code

int

false

The program type, defined by the library.

auto_transfer_code

char

false

Specifies whether patrons on the waitlist are automatically transferred to the registration list when seats on the registration list become available due to a cancellation (true) or whether transfers from the waitlist to the registration list must be done manually (false or blank).

is_right_result_exact

boolean

false

Controls program display position in the catalog search results.

gcode1

char

false

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

gcode2

char

false

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

gcode3

char

false

Controls display of the program in the WebPAC.

CODE

DEFINITION

-

DISPLAY

n

SUPPRESS

 

is_suppressed

boolean

false

Specifies whether the record is suppressed from public display.

record_creation_date_gmt

timestamptz

false

Record creation date.

user_defined_gcode1_myuser

Each row of user_defined_gcode1_myuser identifies a user-defined fixed-length field for program 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_gcode2_myuser

Each row of user_defined_gcode2_myuser identifies a user-defined fixed-length field for program 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_gcode3_myuser

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