s_previous_service table
The s_previous_service table contains options to populate the Previous Service field.
This field is part of the 2016 Time and Place changes.
| field | type | description |
|---|---|---|
| previous_service_ID | long integer | unique ID |
| previous_service | text | actual name |
| active | true/false | available for collection |
| notes | text | notes about entry |
| sort_order | integer | sort order index for showing in drop-downs (e.g. to be able to sort "not applicable" to bottom) |