71
edits
Important: The GCConnex decommission will not affect GCCollab or GCWiki. Thank you and happy collaborating!
Changes
Jump to navigation
Jump to search
Line 777:
Line 777: − + Line 790:
Line 790: − + Line 826:
Line 826: − + Line 881:
Line 881: − + Line 894:
Line 894: − + Line 926:
Line 926: − + Line 989:
Line 989: − + Line 999:
Line 999: − + Line 1,005:
Line 1,005: − + Line 1,011:
Line 1,011: + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + − + + + + + + + + + − + − | + + + + + + + + − + + + + + + + + + + + + + + + + + + + + + + − + + + + + + + + + + − + − | + + + + + + + + − + + + + + + + + + + + + + + + + + + + + − + − + − | − | − | + + + − + − + − | − | − | + + + + − | − | − | − |} − − === MD_INS_CASE_INSPECTORS === − This table holds information that categorizes or "tags" an inspection. − {| class="wikitable" − |+ − !Column Name − !Data Type − !Key Type − !Nullable − !Example Data − !Description − !Comments + + + − + − | − | − | + + + − + − | − | − | + + + − + − | − | − | − + Line 1,174:
Line 1,262: − + Line 1,184:
Line 1,272: − + Line 1,211:
Line 1,299: − + − + Line 1,248:
Line 1,336: − + − + − + Line 1,285:
Line 1,373: − + Line 1,322:
Line 1,410: − + Line 1,331:
Line 1,419: − + Line 1,359:
Line 1,447: − + Line 1,396:
Line 1,484: − + Line 1,433:
Line 1,521: − + Line 1,470:
Line 1,558: − + Line 1,507:
Line 1,595: − + Line 1,544:
Line 1,632: − +
MDCCD Data Warehouse Data Dictionary (view source)
Revision as of 16:24, 23 May 2024
, 16:24, 23 May 2024no edit summary
|NULL
|NULL
|Vanessa Toussaint
|Vanessa Toussaint
|This identifies the resource that las modified the record.
|This identifies the resource that last modified the record.
|
|
|-
|-
|}
|}
=== MD_INS_CASE_CAPA ===
===MD_INS_CASE_CAPA===
This table holds information about the corrective action plan for an inspection observation.
This table holds information about the corrective action plan for an inspection observation.
{| class="wikitable"
{| class="wikitable"
|No
|No
|NULL
|NULL
|00086-BENEMAX DBA. BENEMAX HEALTH AND WELLNESS
|00086-BENEMAX DBA. BENEMAX HEALTH AND WELLNESS
|This is the parent inspection number.
|This is the parent inspection number.
|
|
|NULL
|NULL
|Jeff Tyndall
|Jeff Tyndall
|This identifies the resource that las modified the record.
|This identifies the resource that last modified the record.
|
|
|-
|-
|}
|}
=== MD_INS_CASE_DESIGNATION ===
===MD_INS_CASE_DESIGNATION===
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.
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"
|Foreign
|Foreign
|No
|No
|00070-QUART HEALTHCARE INC.
|00070-QUART HEALTHCARE INC.
|This is the parent inspection number.
|This is the parent inspection number.
|-
|-
|Yes
|Yes
|Jeff Tyndall
|Jeff Tyndall
|This identifies the resource that las modified the record.
|This identifies the resource that last modified the record.
|-
|-
|MODIFIEDON
|MODIFIEDON
|}
|}
=== MD_INS_CASE_ESTACTIVITY ===
===MD_INS_CASE_ESTACTIVITY===
This table holds information that categorizes or "tags" an inspection.
This table holds information that categorizes or "tags" an inspection.
{| class="wikitable"
{| class="wikitable"
!Column Name
!Column Name
!Data Type
!Data Type
!Key Type
! Key Type
!Nullable
!Nullable
!Example Data
!Example Data
!Comments
!Comments
|-
|-
|INSP_ACTIVITY_ID
|VARCHAR2(36 CHAR)
|Primary
|No
|
|
|This is the unique record identifier for the establishment activity.
|
|
|-
|INSP_ID
|VARCHAR2(36 CHAR)
|Foreign
|No
|
|
|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
|
|
|This is the parent inspection number.
|
|
|-
|ACTIVITY_ID
|VARCHAR2(36 CHAR)
|Foreign
|No
|
|
|This is the unique record identifier for the activity value.
|
|
|-
|-
|ACTIVITY_NAME
|VARCHAR2(205 CHAR)
|
|
| Yes
|
|
|This is the establishment activity.
|
|
|-
|ACTIVITY_DECODE_EN
|VARCHAR2(100 CHAR)
|
|
|Yes
|
|
|
|This is the name of the establishment activity in English.
|
|
|-
|-
|ACTIVITY_DECODE_FR
|VARCHAR2(100 CHAR)
|
|
|Yes
|
|
|This is the name of the establishment activity in French.
|
|
|-
|CREATEDBYNAME
|VARCHAR2(100 CHAR)
|
|
|Yes
|
|
|
|This identifies the resource that created the record.
|
|
|-
|-
|CREATEDON
|DATE
|
|
|Yes
|
|
|This identifies the date that record was created.
|
|
|-
|MODIFIEDBYNAME
|VARCHAR2(100 CHAR)
|
|
|Yes
|
|
|
| This identifies the resource that last modified the record.
|
|
|-
|-
|MODIFIEDON
|DATE
|
|
|Yes
|
|
|This identifies the date that record was last modified.
|
|
|}
===MD_INS_CASE_INSPECTORS===
This table holds information that categorizes or "tags" an inspection.
{| class="wikitable"
|+
!Column Name
!Data Type
!Key Type
!Nullable
!Example Data
!Description
!Comments
|-
|BK_ID
|VARCHAR2(36 CHAR)
|No
|
|
|
|
|
|This is the unique record identifier for the inspector listing.
|
|
|-
|-
|INSP_ID
|VARCHAR2(36 CHAR)
|No
|
|
|
|
|This is the unique record identifier for the parent inspection.
|Use to join with MD_INS_CASE.INSP_ID.
|-
|INSP_NUM
|VARCHAR2(200 CHAR)
|No
|
|
|
|
|
|This is the parent inspection number.
|
|
|-
|-
|INSPECTOR_NAME
|VARCHAR2(100 CHAR)
|Yes
|
|
|
|
|This is the name of the inspector.
|
|
|-
|LEADINSPECTOR_EN
|VARCHAR2(3 CHAR)
|Yes
|
|
|
|
|
|This indicates if the inspector is the lead inspector on the inspection in English.
|
|
|-
|-
|LEADINSPECTOR_FR
|VARCHAR2(3 CHAR)
|Yes
|
|
|
|
|This indicates if the inspector is the lead inspector on the inspection in French.
|
|
|-
|ASSIGNSTATUS_EN
|VARCHAR2(100 CHAR)
|Yes
|
|
|
|
|**Not used by program.**
|Contains default system information.
|-
|ASSIGNSTATUS_FR
|VARCHAR2(100 CHAR)
|Yes
|
|
|
|
|**Not used by program.**
|Contains default system information.
|-
|-
|STARTTIME
|DATE
|Yes
|
|
|
|
|
|**Not used by program.**
|
|Contains default system information.
|-
|-
|ENDTIME
|DATE
|Yes
|
|
|
|
|
|**Not used by program.**
|
|Contains default system information.
|-
|-
|CREATEDBYNAME
|VARCHAR2(100 CHAR)
|Yes
|
|
|
|
|This identifies the resource that created the record.
|
|
|-
|-
|CREATEDON
|DATE
|Yes
|
|
|
|
|
|This identifies the date that record was created.
|
|
|-
|-
|MODIFIEDBYNAME
|VARCHAR2(100 CHAR)
|Yes
|
|
|
|
|
|This identifies the resource that last modified the record.
|
|
|-
|-
|MODIFIEDON
|DATE
|Yes
|
|
|
|
|
|This identifies the date that record was last modified.
|
|
|}
|}
=== MD_INS_CASE_NOTES ===
===MD_INS_CASE_NOTES===
This table holds information that categorizes or "tags" an inspection.
This table holds information that categorizes or "tags" an inspection.
{| class="wikitable"
{| class="wikitable"
|}
|}
=== MD_INS_CASE_OBSERVATIONS ===
===MD_INS_CASE_OBSERVATIONS===
This table holds information that categorizes or "tags" an inspection.
This table holds information that categorizes or "tags" an inspection.
{| class="wikitable"
{| class="wikitable"
!Example Data
!Example Data
!Description
!Description
!Comments
! Comments
|-
|-
|
|
|}
|}
=== MD_INS_CASE_WORKFLOW ===
===MD_INS_CASE_WORKFLOW===
This table holds information that categorizes or "tags" an inspection.
This table holds information that categorizes or "tags" an inspection.
{| class="wikitable"
{| class="wikitable"
|+
|+
!Column Name
! Column Name
!Data Type
!Data Type
!Key Type
!Key Type
|}
|}
=== MD_INS_INS_IID ===
===MD_INS_INS_IID===
This table holds information that categorizes or "tags" an inspection.
This table holds information that categorizes or "tags" an inspection.
{| class="wikitable"
{| class="wikitable"
|+
|+
!Column Name
!Column Name
!Data Type
! Data Type
!Key Type
!Key Type
!Nullable
!Nullable
!Example Data
! Example Data
!Description
!Description
!Comments
!Comments
|}
|}
=== MD_INS_INS_INSPECTORLIST ===
===MD_INS_INS_INSPECTORLIST===
This table holds information that categorizes or "tags" an inspection.
This table holds information that categorizes or "tags" an inspection.
{| class="wikitable"
{| class="wikitable"
|}
|}
=== MD_INS_INS_IRC_ENFORCEMENT ===
===MD_INS_INS_IRC_ENFORCEMENT===
This table holds information that categorizes or "tags" an inspection.
This table holds information that categorizes or "tags" an inspection.
{| class="wikitable"
{| class="wikitable"
!Nullable
!Nullable
!Example Data
!Example Data
!Description
! Description
!Comments
!Comments
|-
|-
|}
|}
=== MD_INS_INS_IRC_MEASURES ===
=== MD_INS_INS_IRC_MEASURES===
This table holds information that categorizes or "tags" an inspection.
This table holds information that categorizes or "tags" an inspection.
{| class="wikitable"
{| class="wikitable"
|}
|}
=== MD_INS_INS_IRC_OBSERVATIONS ===
===MD_INS_INS_IRC_OBSERVATIONS===
This table holds information that categorizes or "tags" an inspection.
This table holds information that categorizes or "tags" an inspection.
{| class="wikitable"
{| class="wikitable"
|}
|}
=== MD_INS_INS_SITE ===
===MD_INS_INS_SITE===
This table holds information that categorizes or "tags" an inspection.
This table holds information that categorizes or "tags" an inspection.
{| class="wikitable"
{| class="wikitable"
|}
|}
=== MD_INS_INS_SITE_CONTACT ===
===MD_INS_INS_SITE_CONTACT===
This table holds information that categorizes or "tags" an inspection.
This table holds information that categorizes or "tags" an inspection.
{| class="wikitable"
{| class="wikitable"
|}
|}
=== MD_INS_INS_LICENCE ===
===MD_INS_INS_LICENCE===
This table holds information that categorizes or "tags" an inspection.
This table holds information that categorizes or "tags" an inspection.
{| class="wikitable"
{| class="wikitable"
|}
|}
=== MD_INS_INS_SITELICENCEACTIVITY ===
===MD_INS_INS_SITELICENCEACTIVITY===
This table holds information that categorizes or "tags" an inspection.
This table holds information that categorizes or "tags" an inspection.
{| class="wikitable"
{| class="wikitable"
