Table Columns and Values

You also need to know what columns you can search and the values stored in those columns. Sometimes those values are codes, such as “main” for location. Sometimes they are numbers or small integers.

For example, the circulation privilege column in the circulation_privilege_code table has 26 different privileges (loan period, fine rate, etc.). Each loan privilege is assigned a number. Loan privilege is 0, renewal period is 1, and so on. If you do not know the value, open the view for the table and display the Values group; it lists the value for each option in the column.

 


© 1998-2017 Sirsi Corporation