Skip to main content

Lists and Authorities

List item intrinsics (ca_list_items)

NameCodeDescriptionMandatory?Default
IdentifieridnoThe list item identifier. Must follow policy defined in configured numbering policy if app.conf setting require_valid_id_number_for_ca_list_items is set. Must be unique if app.conf setting allow_duplicate_id_number_for_ca_list_items is not set.Depends upon numbering policy
Typetype_idA value from the list_item_types list indicating the type of the record. Stored as an internally generated numeric item_id. When setting this value in a data import or via an API call the item identifier may be used.Yesnull
Parentparent_idReference to parent record. Will be null if no parent is defined. When setting this value in a data import or via an API call the identifier of the parent place may be used.Nonull
Listlist_idA reference to the list record (ca_lists) of which the list item is a part. Note that a list item is always part of a list. It cannot exist outside of a list. The raw database value contained list_id is an internally generated numeric list_id. However, when setting this intrinsic via an import mapping or API call you may also use the list’s code.No
Valueitem_valueValue represented by list item. This is distinct from the identifier and used to convey a text or numeric quantity when required.Yes
AccessaccessDetermines visibility of record in public-facing applications such as Pawtucket. Values are defined in the access_statuses list. Typically the list includes values for “public” and “private” visibility. For historical reasons the value stored in the intrinsic is the list item’s value field, not its identifer or label. By convention “0” is interpreted as private and “1” as public access, although this can be modified or expanded in app.conf if required.Yes0
StatusstatusRecords the general cataloguing workflow status of the record. Values are defined in the workflow_statuses list. For historical reasons the value stored in the intrinsic is the list item’s value field, not its identifer or label. Unlike access values, statuses have no functional impact on a record. They are merely informations and intended to provide a simple, straightforward way to track the cataloguing process.Yes0
IconiconIcon image to display for listitem.No
ColorcolorHighlight color for list item in hex format.No
Is enabled?is_enabledFlag indicating whether list item is available for use (value set to 1) or not available (value is 0).Yes0
Is default?is_defaultFlag indicating whether list item is the default selection for its list (value set to 1) or not (value is 0).Yes0
RankrankThe sort order position of the list item. Must be a whole number; lower numbers indicate higher ranking in sort.Yes0

List intrinsics (ca_lists)

NameCodeDescriptionMandatory?Default
List codelist_codeThe list identifier. Must be a unique alpha-numeric code without spaces or punctuation beyond underscores.Yes
Is system list?is_system_listFlag indicating whether list is required to support application functionality (value set to 1) or is purely for cataloguing purposes (value is 0).Yes0
Is hierarchical?is_hierarchicalFlag indicating whether list is hierarchical (value set to 1) or flat (value is 0).Yes0
Use as vocabulary?use_as_vocabularyFlag indicating whether list should be used in vocabulary (keyword) lookups (value set to 1) or not (value is 0).Yes0
Default sortdefault_sortSpecifies the default method to employ to order items in this list. Takes a numeric value indicating the sort order: 0 = Sort by list item label 1 = Sort by list item rank 2 = Sort by list item value 3 = Sort by list item identifierYes0