s_dispo.center

From CCMDB Wiki
Jump to navigation Jump to search
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.

  • SMW

Legacy implementation right in the table

  • Cargo


  • Categories
  • Forms



Values

This is a three digit number.

  • 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)

  • SMW


  • Cargo


  • Categories