wiki

Changes

MDCCD Data Warehouse Data Dictionary (view source)

Revision as of 15:37, 23 May 2024

1,571 bytes added ,  23 May
no edit summary
Line 1,000: Line 1,000:     
===MD_INS_CASE_ESTACTIVITY===
 
===MD_INS_CASE_ESTACTIVITY===
−
This table holds information that categorizes or "tags" an inspection.
+
This table holds information on the activities conducted by the company at the time of the inspection as recorded by the inspector.
 
{| class="wikitable"
 
{| class="wikitable"
 
|+
 
|+
 
!Column Name
 
!Column Name
 
!Data Type
 
!Data Type
−
! Key Type
+
!Key Type
 
!Nullable
 
!Nullable
 
!Example Data
 
!Example Data
Line 1,015: Line 1,015:  
|Primary
 
|Primary
 
|No
 
|No
−
|
+
|7a743745-5fec-ee11-a1fd-002248af8802
 
|This is the unique record identifier for the establishment activity.
 
|This is the unique record identifier for the establishment activity.
 
|
 
|
 
|-
 
|-
−
|INSP_ID
+
| INSP_ID
 
|VARCHAR2(36 CHAR)
 
|VARCHAR2(36 CHAR)
 
|Foreign
 
|Foreign
 
|No
 
|No
−
|
+
|4c1aa941-ff7d-4e44-9238-82f4ad624d7e
 
|This is the unique record identifier for the parent inspection.
 
|This is the unique record identifier for the parent inspection.
 
|Use to join with MD_INS_CASE.INSP_ID.
 
|Use to join with MD_INS_CASE.INSP_ID.
Line 1,031: Line 1,031:  
|Foreign
 
|Foreign
 
|No
 
|No
−
|
+
|00082-(DR. FARGO)GUANGZHOU HEHOU INFORMATION TECHNOLOGY CO., LTD.
 
|This is the parent inspection number.
 
|This is the parent inspection number.
 
|
 
|
Line 1,039: Line 1,039:  
|Foreign
 
|Foreign
 
|No
 
|No
−
|
+
|d7ce3513-4d14-ee11-9cbe-002248af8a65
 
|This is the unique record identifier for the activity value.
 
|This is the unique record identifier for the activity value.
 
|
 
|
Line 1,046: Line 1,046:  
|VARCHAR2(205 CHAR)
 
|VARCHAR2(205 CHAR)
 
|
 
|
−
| Yes
+
|Yes
−
|
+
|Importateur - Classe 2
 
|This is the establishment activity.
 
|This is the establishment activity.
 
|
 
|
Line 1,055: Line 1,055:  
|
 
|
 
|Yes
 
|Yes
−
|
+
|Importer - Class 2
 
|This is the name of the establishment activity in English.
 
|This is the name of the establishment activity in English.
 
|
 
|
Line 1,063: Line 1,063:  
|
 
|
 
|Yes
 
|Yes
−
|
+
|Importateur - Classe 2
 
|This is the name of the establishment activity in French.
 
|This is the name of the establishment activity in French.
 
|
 
|
Line 1,071: Line 1,071:  
|
 
|
 
|Yes
 
|Yes
−
|
+
|Jeff Tyndall
 
|This identifies the resource that created the record.
 
|This identifies the resource that created the record.
 
|
 
|
Line 1,079: Line 1,079:  
|
 
|
 
|Yes
 
|Yes
−
|
+
|22-08-26
 
|This identifies the date that record was created.
 
|This identifies the date that record was created.
 
|
 
|
 
|-
 
|-
−
|MODIFIEDBYNAME
+
| MODIFIEDBYNAME
 
|VARCHAR2(100 CHAR)
 
|VARCHAR2(100 CHAR)
 
|
 
|
 
|Yes
 
|Yes
−
|
+
|Jeff Tyndall
−
| This identifies the resource that last modified the record.
+
|This identifies the resource that last modified the record.
 
|
 
|
 
|-
 
|-
Line 1,095: Line 1,095:  
|
 
|
 
|Yes
 
|Yes
−
|
+
|22-08-26
 
|This identifies the date that record was last modified.
 
|This identifies the date that record was last modified.
 
|
 
|
Line 1,101: Line 1,101:     
===MD_INS_CASE_INSPECTORS===
 
===MD_INS_CASE_INSPECTORS===
−
This table holds information that categorizes or "tags" an inspection.
+
This table holds a listing of inspectors assigned to an inspection.
 
{| class="wikitable"
 
{| class="wikitable"
 
|+
 
|+
Line 1,108: Line 1,108:  
!Key Type
 
!Key Type
 
!Nullable
 
!Nullable
−
!Example Data
+
! Example Data
 
!Description
 
!Description
−
!Comments
+
! Comments
 
|-
 
|-
 
|BK_ID
 
|BK_ID
 
|VARCHAR2(36 CHAR)
 
|VARCHAR2(36 CHAR)
 +
|Primary
 
|No
 
|No
−
|
+
|10cd1617-e303-ef11-9f89-002248b15d0c
−
|
   
|This is the unique record identifier for the inspector listing.
 
|This is the unique record identifier for the inspector listing.
 
|
 
|
Line 1,122: Line 1,122:  
|INSP_ID
 
|INSP_ID
 
|VARCHAR2(36 CHAR)
 
|VARCHAR2(36 CHAR)
 +
|Foreign
 
|No
 
|No
−
|
+
|19c5e07e-63cd-49e6-9cdc-ac0f318f4752
−
|
   
|This is the unique record identifier for the parent inspection.
 
|This is the unique record identifier for the parent inspection.
 
|Use to join with MD_INS_CASE.INSP_ID.
 
|Use to join with MD_INS_CASE.INSP_ID.
Line 1,130: Line 1,130:  
|INSP_NUM
 
|INSP_NUM
 
|VARCHAR2(200 CHAR)
 
|VARCHAR2(200 CHAR)
 +
|Foreign
 
|No
 
|No
−
|
+
|00093-ROCHE DIAGNOSTICS
−
|
   
|This is the parent inspection number.
 
|This is the parent inspection number.
 
|
 
|
Line 1,138: Line 1,138:  
|INSPECTOR_NAME
 
|INSPECTOR_NAME
 
|VARCHAR2(100 CHAR)
 
|VARCHAR2(100 CHAR)
 +
|
 
|Yes
 
|Yes
−
|
+
|Jeff Tyndall
−
|
   
|This is the name of the inspector.
 
|This is the name of the inspector.
 
|
 
|
 
|-
 
|-
 
|LEADINSPECTOR_EN
 
|LEADINSPECTOR_EN
−
|VARCHAR2(3 CHAR)
+
| VARCHAR2(3 CHAR)
 +
|
 +
|Yes
 
|Yes
 
|Yes
−
|
  −
|
   
|This indicates if the inspector is the lead inspector on the inspection in English.
 
|This indicates if the inspector is the lead inspector on the inspection in English.
 
|
 
|
 
|-
 
|-
 
|LEADINSPECTOR_FR
 
|LEADINSPECTOR_FR
−
|VARCHAR2(3 CHAR)
+
| VARCHAR2(3 CHAR)
 +
|
 
|Yes
 
|Yes
−
|
+
|Oui
−
|
   
|This indicates if the inspector is the lead inspector on the inspection in French.
 
|This indicates if the inspector is the lead inspector on the inspection in French.
 
|
 
|
Line 1,162: Line 1,162:  
|ASSIGNSTATUS_EN
 
|ASSIGNSTATUS_EN
 
|VARCHAR2(100 CHAR)
 
|VARCHAR2(100 CHAR)
 +
|
 
|Yes
 
|Yes
−
|
+
|Scheduled
−
|
   
|**Not used by program.**
 
|**Not used by program.**
 
|Contains default system information.
 
|Contains default system information.
Line 1,170: Line 1,170:  
|ASSIGNSTATUS_FR
 
|ASSIGNSTATUS_FR
 
|VARCHAR2(100 CHAR)
 
|VARCHAR2(100 CHAR)
 +
|
 
|Yes
 
|Yes
−
|
   
|
 
|
 
|**Not used by program.**
 
|**Not used by program.**
Line 1,178: Line 1,178:  
|STARTTIME
 
|STARTTIME
 
|DATE
 
|DATE
 +
|
 
|Yes
 
|Yes
−
|
+
|23-10-20
−
|
   
|**Not used by program.**
 
|**Not used by program.**
 
|Contains default system information.
 
|Contains default system information.
 
|-
 
|-
−
|ENDTIME
+
| ENDTIME
 
|DATE
 
|DATE
 +
|
 
|Yes
 
|Yes
−
|
+
|23-10-20
−
|
   
|**Not used by program.**
 
|**Not used by program.**
 
|Contains default system information.
 
|Contains default system information.
Line 1,194: Line 1,194:  
|CREATEDBYNAME
 
|CREATEDBYNAME
 
|VARCHAR2(100 CHAR)
 
|VARCHAR2(100 CHAR)
 +
|
 
|Yes
 
|Yes
−
|
+
|Jeff Tyndall
−
|
   
|This identifies the resource that created the record.
 
|This identifies the resource that created the record.
 
|
 
|
Line 1,202: Line 1,202:  
|CREATEDON
 
|CREATEDON
 
|DATE
 
|DATE
 +
|
 
|Yes
 
|Yes
−
|
+
|22-08-26
−
|
   
|This identifies the date that record was created.
 
|This identifies the date that record was created.
 
|
 
|
Line 1,210: Line 1,210:  
|MODIFIEDBYNAME
 
|MODIFIEDBYNAME
 
|VARCHAR2(100 CHAR)
 
|VARCHAR2(100 CHAR)
 +
|
 
|Yes
 
|Yes
−
|
+
|Jeff Tyndall
−
|
   
|This identifies the resource that last modified the record.
 
|This identifies the resource that last modified the record.
 
|
 
|
Line 1,218: Line 1,218:  
|MODIFIEDON
 
|MODIFIEDON
 
|DATE
 
|DATE
 +
|
 
|Yes
 
|Yes
−
|
+
|22-08-26
−
|
   
|This identifies the date that record was last modified.
 
|This identifies the date that record was last modified.
 
|
 
|
Line 1,226: Line 1,226:     
===MD_INS_CASE_NOTES===
 
===MD_INS_CASE_NOTES===
−
This table holds information that categorizes or "tags" an inspection.
+
This table holds notes related to the inspection.
 
{| class="wikitable"
 
{| class="wikitable"
 
|+
 
|+
Line 1,237: Line 1,237:  
!Comments
 
!Comments
 
|-
 
|-
 +
|ANNOTATION_ID
 +
|VARCHAR2(36 CHAR)
 +
|Primary
 +
|No
 +
|d2fa45bc-f953-8e06-8fc1-e116086f174f
 +
|This is the unique record identifier for the note.
 
|
 
|
 +
|-
 +
|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
 +
|00027-FUTURE HEALTH TECHNOLOGIES
 +
|This is the parent inspection number.
 
|
 
|
 +
|-
 +
|SUBJECT
 +
|VARCHAR2(500 CHAR)
 
|
 
|
 +
|Yes
 +
|Talked to client and set out inspection plan.
 +
|This is the subject of the note.
 
|
 
|
 +
|-
 +
|NOTETEXT
 +
|CLOB
 
|
 
|
−
|
+
|Yes
 +
|Communication with company on 2023-09-01.
 +
|This is the body of the note.
 
|
 
|
 
|-
 
|-
 +
|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 last modified the record.
 
|
 
|
 
|-
 
|-
 +
|MODIFIEDON
 +
|DATE
 
|
 
|
−
|
+
|Yes
−
|
+
|22-08-26
−
|
+
|This identifies the date that record was last modified.
−
|
  −
|
   
|
 
|
 
|}
 
|}
Line 1,266: Line 1,314:  
{| class="wikitable"
 
{| class="wikitable"
 
|+
 
|+
−
!Column Name
+
! Column Name
 
!Data Type
 
!Data Type
 
!Key Type
 
!Key Type
Line 1,272: Line 1,320:  
!Example Data
 
!Example Data
 
!Description
 
!Description
−
! Comments
+
!Comments
 
|-
 
|-
 
|
 
|
Line 1,341: Line 1,389:  
|+
 
|+
 
!Column Name
 
!Column Name
−
! Data Type
+
!Data Type
 
!Key Type
 
!Key Type
 
!Nullable
 
!Nullable
−
! Example Data
+
!Example Data
 
!Description
 
!Description
 
!Comments
 
!Comments
Line 1,419: Line 1,467:  
!Nullable
 
!Nullable
 
!Example Data
 
!Example Data
−
! Description
+
!Description
 
!Comments
 
!Comments
 
|-
 
|-
Line 1,447: Line 1,495:  
|}
 
|}
   −
=== 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"
 
|+
 
|+
−
!Column Name
+
! Column Name
 
!Data Type
 
!Data Type
−
!Key Type
+
! Key Type
 
!Nullable
 
!Nullable
−
!Example Data
+
! Example Data
 
!Description
 
!Description
 
!Comments
 
!Comments
Line 1,488: Line 1,536:  
{| class="wikitable"
 
{| class="wikitable"
 
|+
 
|+
−
!Column Name
+
! Column Name
 
!Data Type
 
!Data Type
 
!Key Type
 
!Key Type
Line 1,603: Line 1,651:  
!Key Type
 
!Key Type
 
!Nullable
 
!Nullable
−
!Example Data
+
! Example Data
 
!Description
 
!Description
 
!Comments
 
!Comments
Jeff.tyndall
71

edits

Retrieved from "https://wiki.gccollab.ca/Special:MobileDiff/120553"