71
edits
Changes
MDCCD Data Warehouse Data Dictionary (view source)
Revision as of 16:14, 23 May 2024
, 16:14, 23 May 2024no edit summary
|-
|-
|INSP_NUM
|INSP_NUM
|
|Foreign
|VARCHAR2(200 CHAR)
|VARCHAR2(200 CHAR)
|No
|No
|INSP_NUM
|INSP_NUM
|VARCHAR2(200 CHAR)
|VARCHAR2(200 CHAR)
|
|Foreign
|No
|No
|NULL
|NULL
=== MD_INS_CASE_DESIGNATION ===
=== MD_INS_CASE_DESIGNATION ===
This table holds information that categorizes or "tags" an inspection.
This table holds information that categorizes or "tags" an inspection. These are flexible codes used to capture information if a designated field does not exist.
{| class="wikitable"
{| class="wikitable"
|+
|+
!Comments
!Comments
|-
|-
|INSP_DESIGNATION_ID
|VARCHAR2(36 CHAR)
|Primary
|No
|dca846bf-cc2f-ee11-bdf4-002248b32010
|This is the unique record identifier for the designation.
|
|
|-
|-
|
|INSP_ID
|
|VARCHAR2(36 CHAR)
|
|Foreign
|
|No
|
|3d7a309e-ce46-40c5-a6c2-f3ea80971d48
|
|This is the unique record identifier for the parent inspection.
|Use to join with MD_INS_CASE.INSP_ID.
|-
|INSP_NUM
|VARCHAR2(200 CHAR)
|Foreign
|No
|00070-QUART HEALTHCARE INC.
|This is the parent inspection number.
|-
|DESIGNATION_ID
|VARCHAR2(36 CHAR)
|Foreign
|No
|ea30c0ef-5214-ee11-9cbe-002248af8a65
|This is the unique record identifier for the designation code.
|
|
|-
|-
|DESIGNATION_CODE
|VARCHAR2(100 CHAR)
|
|
|
|Yes
|
|5006
|
|This is the designation code.
|
|
|-
|-
|DESIGNATION_NAME
|VARCHAR2(250 CHAR)
|
|
|
|Yes
|
|Covid
|
|This is the name of the designation code.
|
|
|-
|-
|DESIGNATION_DECODE_EN
|VARCHAR2(100 CHAR)
|
|
|
|Yes
|
|Covid
|
|This is the name of the designation code in English.
|
|
|-
|-
|DESIGNATION_DECODE_FR
|VARCHAR2(100 CHAR)
|
|
|
|Yes
|
|Covid
|
|This is the name of the designation code in French.
|
|
|-
|-
|CREATEDBYNAME
|VARCHAR2(100 CHAR)
|
|
|
|Yes
|
|Jeff Tyndall
|
|This identifies the resource that created the record.
|
|
|-
|-
|CREATEDON
|DATE
|
|
|
|Yes
|
|22-08-26
|
|This identifies the date that record was created.
|-
|-
|MODIFIEDBYNAME
|VARCHAR2(100 CHAR)
|
|
|
|Yes
|
|Jeff Tyndall
|
|This identifies the resource that las modified the record.
|-
|-
|MODIFIEDON
|DATE
|
|
|
|Yes
|
|22-08-26
|
|This identifies the date that record was last modified.
|}
|}