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 1,000:
Line 1,000: − + − + Line 1,015:
Line 1,015: − + − + − + Line 1,031:
Line 1,031: − + Line 1,039:
Line 1,039: − + Line 1,046:
Line 1,046: − + − + Line 1,055:
Line 1,055: − + Line 1,063:
Line 1,063: − + Line 1,071:
Line 1,071: − + Line 1,079:
Line 1,079: − + − + − + − + Line 1,095:
Line 1,095: − + Line 1,101:
Line 1,101: − + Line 1,108:
Line 1,108: − + − + + − + − | Line 1,122:
Line 1,122: + − + − | Line 1,130:
Line 1,130: + − + − | Line 1,138:
Line 1,138: + − + − | − + + + − | − | − + + − + − | Line 1,162:
Line 1,162: + − + − | Line 1,170:
Line 1,170: + − | Line 1,178:
Line 1,178: + − + − | − + + − + − | Line 1,194:
Line 1,194: + − + − | Line 1,202:
Line 1,202: + − + − | Line 1,210:
Line 1,210: + − + − | Line 1,218:
Line 1,218: + − + − | Line 1,226:
Line 1,226: − + Line 1,237:
Line 1,237: + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + − + + + + + + + + + + + + + + + + + − + + + + + − + − + − + − | − | Line 1,266:
Line 1,314: − + Line 1,272:
Line 1,320: − + Line 1,341:
Line 1,389: − + − + Line 1,419:
Line 1,467: − + Line 1,447:
Line 1,495: − + − + − + − + Line 1,488:
Line 1,536: − + Line 1,603:
Line 1,651: − +
MDCCD Data Warehouse Data Dictionary (view source)
Revision as of 16:37, 23 May 2024
, 16:37, 23 May 2024no edit summary
===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
|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.
|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.
|
|
|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.
|
|
|VARCHAR2(205 CHAR)
|VARCHAR2(205 CHAR)
|
|
| Yes
|Yes
|
|Importateur - Classe 2
|This is the establishment activity.
|This is the establishment activity.
|
|
|
|
|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.
|
|
|
|
|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.
|
|
|
|
|Yes
|Yes
|
|Jeff Tyndall
|This identifies the resource that created the record.
|This identifies the resource that created the record.
|
|
|
|
|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.
|
|
|-
|-
|
|
|Yes
|Yes
|
|22-08-26
|This identifies the date that record was last modified.
|This identifies the date that record was last modified.
|
|
===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"
|+
|+
!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.
|
|
|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.
|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.
|
|
|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.
|
|
|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.
|ASSIGNSTATUS_FR
|ASSIGNSTATUS_FR
|VARCHAR2(100 CHAR)
|VARCHAR2(100 CHAR)
|
|Yes
|Yes
|
|
|**Not used by program.**
|**Not used by program.**
|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.
|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.
|
|
|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.
|
|
|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.
|
|
|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.
|
|
===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"
|+
|+
!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.
|
|
|}
|}
{| class="wikitable"
{| class="wikitable"
|+
|+
!Column Name
! Column Name
!Data Type
!Data Type
!Key Type
!Key Type
!Example Data
!Example Data
!Description
!Description
! Comments
!Comments
|-
|-
|
|
|+
|+
!Column Name
!Column Name
! Data Type
!Data Type
!Key Type
!Key Type
!Nullable
!Nullable
! Example Data
!Example Data
!Description
!Description
!Comments
!Comments
!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"
|+
|+
!Column Name
! Column Name
!Data Type
!Data Type
!Key Type
! Key Type
!Nullable
!Nullable
!Example Data
! Example Data
!Description
!Description
!Comments
!Comments
{| class="wikitable"
{| class="wikitable"
|+
|+
!Column Name
! Column Name
!Data Type
!Data Type
!Key Type
!Key Type
!Key Type
!Key Type
!Nullable
!Nullable
!Example Data
! Example Data
!Description
!Description
!Comments
!Comments
