Refer to these tables and columns when creating SQL statements:
Table name |
Columns in table |
auth |
auth# tag |
auth_control |
auth# create_date create_time create_user change_date change_time change_user status status_change_date status_change_time status_change_user staff_only_author staff_only_subject staff_only_series |
bib |
bib# tag |
bib_control |
bib# create_date create_time create_user change_date change_time change_user status status_change_date status_change_time status_change_user staff_only |
item |
bib# location collection call itype item_status source price creation_date last_update_date last_status_update_date |
© 1998-2017 Sirsi Corporation