wiki

Changes

MDCCD Data Warehouse Data Dictionary (view source)

Revision as of 14:10, 23 May 2024

4,175 bytes added ,  14:10, 23 May 2024
→‎MD_INS_CASE
Line 5: Line 5:     
=== MD_INS_CASE ===
 
=== MD_INS_CASE ===
 +
This table holds the main inspection information.
 +
{| class="wikitable"
 +
|+
 +
!Column Name
 +
!DataType
 +
!Nullable
 +
!Data Default
 +
!Example Data
 +
!Description
 +
|-
 +
|INSP_ID
 +
|VARCHAR2(36 CHAR)
 +
|No
 +
|
 +
|
 +
|-
 +
|INSP_NUM
 +
|VARCHAR2(200 CHAR)
 +
|No
 +
|
 +
|
 +
|-
 +
|SITE_ID
 +
|VARCHAR2(36 CHAR)
 +
|No
 +
|
 +
|
 +
|-
 +
|SITE_NAME
 +
|VARCHAR2(160 CHAR)
 +
|Yes
 +
|
 +
|
 +
|-
 +
|LICENCE_NO
 +
|NUMBER(6,0)
 +
|Yes
 +
|
 +
|
 +
|-
 +
|COMPANY_ID
 +
|NUMBER(6,0)
 +
|Yes
 +
|
 +
|
 +
|-
 +
|REG_FILE_NUMBER
 +
|VARCHAR2(250 BYTE)
 +
|Yes
 +
|
 +
|
 +
|-
 +
|REGION_CD_EN
 +
|VARCHAR2(50 CHAR)
 +
|Yes
 +
|
 +
|
 +
|-
 +
|REGION_CD_FR
 +
|VARCHAR2(50 CHAR)
 +
|Yes
 +
|
 +
|
 +
|-
 +
|INSP_TYPE_EN
 +
|VARCHAR2(100 CHAR)
 +
|Yes
 +
|
 +
|
 +
|-
 +
|INSP_TYPE_FR
 +
|VARCHAR2(100 CHAR)
 +
|Yes
 +
|
 +
|
 +
|-
 +
|LEAD_INSPECTOR_ID
 +
|VARCHAR2(36 CHAR)
 +
|Yes
 +
|
 +
|
 +
|-
 +
|LEAD_INSPECTOR
 +
|VARCHAR2(200 CHAR)
 +
|Yes
 +
|
 +
|
 +
|-
 +
|LEAD_INSPECTOR_BADGE
 +
|VARCHAR2(50 BYTE)
 +
|Yes
 +
|
 +
|
 +
|-
 +
|SUPERVISOR_ID
 +
|VARCHAR2(36 CHAR)
 +
|Yes
 +
|
 +
|
 +
|-
 +
|SUPERVISOR
 +
|VARCHAR2(200 CHAR)
 +
|Yes
 +
|
 +
|
 +
|-
 +
|INSP_STATUS_EN
 +
|VARCHAR2(100 CHAR)
 +
|Yes
 +
|
 +
|
 +
|-
 +
|INSP_STATUS_FR
 +
|VARCHAR2(100 CHAR)
 +
|Yes
 +
|
 +
|
 +
|-
 +
|COMP_STANDARD_EN
 +
|VARCHAR2(100 CHAR)
 +
|Yes
 +
|
 +
|
 +
|-
 +
|COMP_STANDARD_FR
 +
|VARCHAR2(100 CHAR)
 +
|Yes
 +
|
 +
|
 +
|-
 +
|DRAFT_REPORT_RATING_EN
 +
|VARCHAR2(100 CHAR)
 +
|Yes
 +
|
 +
|
 +
|-
 +
|DRAFT_REPORT_RATING_FR
 +
|VARCHAR2(100 CHAR)
 +
|Yes
 +
|
 +
|
 +
|-
 +
|DRAFT_REPORT_ISSUE_DATE
 +
|DATE
 +
|Yes
 +
|
 +
|
 +
|-
 +
|FINAL_REPORT_RATING_EN
 +
|VARCHAR2(100 CHAR)
 +
|Yes
 +
|
 +
|
 +
|-
 +
|FINAL_REPORT_RATING_FR
 +
|VARCHAR2(100 CHAR)
 +
|Yes
 +
|
 +
|
 +
|-
 +
|FINAL_REPORT_ISSUE_DATE
 +
|DATE
 +
|Yes
 +
|
 +
|
 +
|-
 +
|AMENDED_REPORT_ISSUE_DATE
 +
|DATE
 +
|Yes
 +
|
 +
|
 +
|-
 +
|SAMPLES_TAKEN
 +
|VARCHAR2(2000 CHAR)
 +
|Yes
 +
|
 +
|
 +
|-
 +
|INSP_START_DATE
 +
|DATE
 +
|Yes
 +
|
 +
|
 +
|-
 +
|INSP_END_DATE
 +
|DATE
 +
|Yes
 +
|
 +
|
 +
|-
 +
|CLOSING_MEETING_DATE
 +
|DATE
 +
|Yes
 +
|
 +
|
 +
|-
 +
|NEXT_INSPECTION_DATE
 +
|DATE
 +
|Yes
 +
|
 +
|
 +
|-
 +
|AMENDED_CD_EN
 +
|VARCHAR2(5 CHAR)
 +
|Yes
 +
|
 +
|
 +
|-
 +
|AMENDED_CD_FR
 +
|VARCHAR2(5 CHAR)
 +
|Yes
 +
|
 +
|
 +
|-
 +
|AMENDED_BY
 +
|VARCHAR2(200 CHAR)
 +
|Yes
 +
|
 +
|
 +
|-
 +
|AMENDED_DATE
 +
|DATE
 +
|Yes
 +
|
 +
|
 +
|-
 +
|FIRST_COMM_DATE
 +
|DATE
 +
|Yes
 +
|
 +
|
 +
|-
 +
|FIRST_COMM_MODE
 +
|VARCHAR2(100 CHAR)
 +
|Yes
 +
|
 +
|
 +
|-
 +
|FIRST_COMM_MODE_EN
 +
|VARCHAR2(100 CHAR)
 +
|Yes
 +
|
 +
|
 +
|-
 +
|FIRST_COMM_MODE_FR
 +
|VARCHAR2(100 CHAR)
 +
|Yes
 +
|
 +
|
 +
|-
 +
|EMERGENCY_CONTACT_NAME
 +
|VARCHAR2(100 CHAR)
 +
|Yes
 +
|
 +
|
 +
|-
 +
|EMERGENCY_CONTACT_PHONE
 +
|VARCHAR2(100 CHAR)
 +
|Yes
 +
|
 +
|
 +
|-
 +
|SENIOR_OFFICIAL_OFFICIAL_ID
 +
|VARCHAR2(36 CHAR)
 +
|Yes
 +
|
 +
|
 +
|-
 +
|SENIOR_OFFICIAL_NAME
 +
|VARCHAR2(200 CHAR)
 +
|Yes
 +
|
 +
|
 +
|-
 +
|SENIOR_OFFICIAL_TITLE
 +
|VARCHAR2(100 CHAR)
 +
|Yes
 +
|
 +
|
 +
|-
 +
|SITE_CONTACT_ID
 +
|VARCHAR2(36 CHAR)
 +
|Yes
 +
|
 +
|
 +
|-
 +
|SITE_CONTACT_NAME
 +
|VARCHAR2(200 CHAR)
 +
|Yes
 +
|
 +
|
 +
|-
 +
|SITE_CONTACT_TITLE
 +
|VARCHAR2(100 CHAR)
 +
|Yes
 +
|
 +
|
 +
|-
 +
|SITE_CONTACT_PHONE
 +
|VARCHAR2(100 CHAR)
 +
|Yes
 +
|
 +
|
 +
|-
 +
|SITE_CONTACT_FAX
 +
|VARCHAR2(100 CHAR)
 +
|Yes
 +
|
 +
|
 +
|-
 +
|SITE_CONTACT_EMAIL
 +
|VARCHAR2(100 CHAR)
 +
|Yes
 +
|
 +
|
 +
|-
 +
|SITE_ADDRESS_1
 +
|VARCHAR2(250 CHAR)
 +
|Yes
 +
|
 +
|
 +
|-
 +
|SITE_ADDRESS_2
 +
|VARCHAR2(250 CHAR)
 +
|Yes
 +
|
 +
|
 +
|-
 +
|SITE_ADDRESS_3
 +
|VARCHAR2(250 CHAR)
 +
|Yes
 +
|
 +
|
 +
|-
 +
|SITE_CITY
 +
|VARCHAR2(80 CHAR)
 +
|Yes
 +
|
 +
|
 +
|-
 +
|SITE_PROVINCE
 +
|VARCHAR2(50 CHAR)
 +
|Yes
 +
|
 +
|
 +
|-
 +
|SITE_POSTALCODE
 +
|VARCHAR2(20 CHAR)
 +
|Yes
 +
|
 +
|
 +
|-
 +
|SITE_COUNTRY
 +
|VARCHAR2(80 CHAR)
 +
|Yes
 +
|
 +
|
 +
|-
 +
|INSPECTION_SUMMARY
 +
|CLOB
 +
|Yes
 +
|
 +
|
 +
|-
 +
|REPORT_DELIVERED_TO_ID
 +
|VARCHAR2(36 CHAR)
 +
|Yes
 +
|
 +
|
 +
|-
 +
|REPORT_DELIVERED_TO
 +
|VARCHAR2(200 CHAR)
 +
|Yes
 +
|
 +
|
 +
|-
 +
|RESPONSE_EXPECTED_DATE
 +
|DATE
 +
|Yes
 +
|
 +
|
 +
|-
 +
|INTERNAL_CLOSING_COMMENTS
 +
|CLOB
 +
|Yes
 +
|
 +
|
 +
|-
 +
|PERSONNEL_CHANGES
 +
|VARCHAR2(2000 BYTE)
 +
|Yes
 +
|
 +
|
 +
|-
 +
|IID_STATUS_EN
 +
|VARCHAR2(50 CHAR)
 +
|Yes
 +
|
 +
|
 +
|-
 +
|IID_STATUS_FR
 +
|VARCHAR2(50 CHAR)
 +
|Yes
 +
|
 +
|
 +
|-
 +
|IID_STATUS_DATE
 +
|DATE
 +
|Yes
 +
|
 +
|
 +
|-
 +
|IID_REVISION_LOG
 +
|VARCHAR2(2000 CHAR)
 +
|Yes
 +
|
 +
|
 +
|-
 +
|IRC_STATUS_EN
 +
|VARCHAR2(50 CHAR)
 +
|Yes
 +
|
 +
|
 +
|-
 +
|IRC_STATUS_FR
 +
|VARCHAR2(50 CHAR)
 +
|Yes
 +
|
 +
|
 +
|-
 +
|INSP_RATING_EN
 +
|VARCHAR2(100 CHAR)
 +
|Yes
 +
|
 +
|
 +
|-
 +
|INSP_RATING_FR
 +
|VARCHAR2(100 CHAR)
 +
|Yes
 +
|
 +
|
 +
|-
 +
|INSP_OUTCOME_EN
 +
|VARCHAR2(2000 CHAR)
 +
|Yes
 +
|
 +
|
 +
|-
 +
|INSP_OUTCOME_FR
 +
|VARCHAR2(2000 CHAR)
 +
|Yes
 +
|
 +
|
 +
|-
 +
|INSP_REPORT_WAITING
 +
|VARCHAR2(200 CHAR)
 +
|Yes
 +
|
 +
|
 +
|-
 +
|INSP_REPORT_WAITING_DATE
 +
|DATE
 +
|Yes
 +
|
 +
|
 +
|-
 +
|INSP_REPORT_APPROVED_BY
 +
|VARCHAR2(200 CHAR)
 +
|Yes
 +
|
 +
|
 +
|-
 +
|INSP_REPORT_APPROVED_BY_DATE
 +
|DATE
 +
|Yes
 +
|
 +
|
 +
|-
 +
|INSP_CLOSED_WAITING
 +
|VARCHAR2(200 CHAR)
 +
|Yes
 +
|
 +
|
 +
|-
 +
|INSP_CLOSED_WAITING_DATE
 +
|DATE
 +
|Yes
 +
|
 +
|
 +
|-
 +
|INSP_CLOSED_APPROVED
 +
|VARCHAR2(200 CHAR)
 +
|Yes
 +
|
 +
|
 +
|-
 +
|INSP_CLOSED_APPROVED_DATE
 +
|DATE
 +
|Yes
 +
|
 +
|
 +
|-
 +
|CREATEDBYNAME
 +
|VARCHAR2(100 CHAR)
 +
|Yes
 +
|
 +
|
 +
|-
 +
|CREATEDON
 +
|DATE
 +
|Yes
 +
|
 +
|
 +
|-
 +
|MODIFIEDBYNAME
 +
|VARCHAR2(100 CHAR)
 +
|Yes
 +
|
 +
|
 +
|-
 +
|MODIFIEDON
 +
|DATE
 +
|Yes
 +
|
 +
|
 +
|}
    
=== MD_INS_CASE_CAPA ===
 
=== MD_INS_CASE_CAPA ===
Jeff.tyndall
71

edits

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