S previous service table: Difference between revisions

From CCMDB Wiki
Jump to navigation Jump to search
Created page with "The S previous service table contains options to populate the previous service field. This field is part of the 2016 Time and Place changes. {| class="wikitable..."
 
m Text replacement - "[[Category: " to "[[Category:"
 
(6 intermediate revisions by the same user not shown)
Line 1: Line 1:
The [[S previous service table]] contains options to populate the [[previous service field]].  
{{DISPLAYTITLE: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]].
This field is part of the [[2016 Time and Place changes]].
Line 9: Line 9:
!| description
!| description
|-
|-
|| '''dispo_ID''' || text || unique ID  
|| '''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)
|}
|}


[[Category: Data structure]]
[[Category:Data structure]]
[[Category:2016 Time and Place changes]]

Latest revision as of 11:05, 30 July 2025

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)