S dispo.center: Difference between revisions
Jump to navigation
Jump to search
Ttenbergen (talk | contribs) Created page with "{{DISPLAYTITLE:s_dispo.center}}{{Data_element | field_name = center | CCMDB_label = | CCMDB_tab = | element_description = aggregating field for s_dispo table used to define the order in which sites and units are listed on reports. | in_table = s_dispo table | data_type = long integer | datafield_length = | program_collecting = Med and CC | created_raw = Raw | data_element_start_date = 2016-07-01 | data_element_sort_index = 24 }} === Values === This is a three..." |
Ttenbergen (talk | contribs) No edit summary |
||
| Line 1: | Line 1: | ||
{{ | {{Data element | ||
| field_name = center | |field_name=center | ||
|in_table=s_dispo table | |||
|data_type=number | |||
|datafield_length=long integer | |||
| in_table = s_dispo table | |program_collecting=Med and CC | ||
| data_type = | |created_raw=Raw | ||
| datafield_length = | |data_element_start_date=2016-07-01 | ||
| program_collecting = Med and CC | |data_element_sort_index=24 | ||
| created_raw = Raw | |element_description=aggregating field for [[s_dispo table]] used to define the order in which sites and units are listed on [[reports]]. | ||
| data_element_start_date = 2016-07-01 | |||
| data_element_sort_index = 24 | |||
}} | }} | ||
{{DISPLAYTITLE:s_dispo.center}} | |||
=== Values === | === Values === | ||
Latest revision as of 17:09, 11 March 2025
| Data Element (edit) | |
| Field Name: | center |
| CCMDB Label: | not stated |
| CCMDB tab: | not stated |
| Table: | s_dispo table |
| Data type: | number |
| Length: | long integer |
| Program: | Med and CC |
| Created/Raw: | Raw |
| Start Date: | 2016-07-01 |
| End Date: | 2300-01-01 |
| Sort Index: | 24 |
aggregating field for s_dispo table used to define the order in which sites and units are listed on reports.
Values
This is a three digit number.
- First digit denotes the Program
- 1 - Critical Care (Critical Care program)?
- 2 - Medicine program
- Second digit denotes site
- 1 - Health Sciences Centre
- 2 - St Boniface Hospital
- 3 - Grace Hospital
- 4 - Victoria Hospital
- 5 - Concordia Hospital
- 6 - Seven Oaks Hospital
- Third digit
|
Is this just an arbitrary sorting of units or is there a plan to it? Ttenbergen 16:02, 11 March 2025 (CDT) |