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,417:
Line 1,417: − + Line 1,638:
Line 1,638: + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + − + − + − + − + − | + + − + − + − + − + − | − | + + − + − + − + − + − | + + − + − + − + − + − | + + − + − + − + − + − | + + − + − + − + − + − | + + − + − + − + − + − | − | + + − + − + − + − + − | + + − + − + − + − +
MDCCD Data Warehouse Data Dictionary (view source)
Revision as of 16:00, 24 May 2024
, 16:00, 24 May 2024no edit summary
|5c6afa3c-3f8a-4641-8da4-9588ec7769d7
|5c6afa3c-3f8a-4641-8da4-9588ec7769d7
|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.
|-
|-
|INSP_NUM
|INSP_NUM
! scope="col" style="width: 350px;" |Comments
! scope="col" style="width: 350px;" |Comments
|-
|-
|WF_ID
|VARCHAR2(36 CHAR)
|Primary
|No
|NULL
|5c6afa3c-3f8a-4641-8da4-9588ec7769d7
|This is the unique record identifier for the workflow.
|
|
|-
|WF_NAME
|VARCHAR2(50 BYTE)
|
|
|Yes
|NULL
|Inspection Business Process
|This is the name of the workflow.
|
|
|-
|INSP_ID
|VARCHAR2(36 CHAR)
|Foreign
|No
|NULL
|5c6afa3c-3f8a-4641-8da4-9588ec7769d7
|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
|NULL
|00070-MDCCD HEALTHCARE INC
|This is the parent inspection number.
|
|
|-
|ACTIVESTAGEID
|VARCHAR2(36 CHAR)
|
|
|No
|NULL
|5c6afa3c-3f8a-4641-8da4-9588ec7769d7
|This is the unique record identifier for the current stage of the workflow.
|
|
|-
|-
|STAGE_NAME_EN
|VARCHAR2(50 BYTE)
|
|
|
|Yes
|
|NULL
|
|Start Of Inspection
|
|This is the name of the current workflow stage in English.
|
|
|-
|-
|STAGE_NAME_FR
|VARCHAR2(50 BYTE)
|
|
|
|Yes
|
|NULL
|
|Début de l'inspection
|
|This is the name of the current workflow stage in French.
|
|
|-
|-
|STAGE_START_DATE
|DATE
|
|
|
|Yes
|
|NULL
|
|23-11-09
|
|This is the date that the current workflow stage was started.
|
|
|-
|-
|WF_COMPLETE_DATE
|DATE
|
|
|
|Yes
|
|NULL
|
|23-11-09
|
|This is the date the workflow was completed.
|
|
|-
|-
|WF_DURATION
|NUMBER(4,0)
|
|
|
|Yes
|
|NULL
|
|42
|
|This identifies how many days the workflow was active.
|
|
|-
|-
|CREATEDBYNAME
|VARCHAR2(100 CHAR)
|
|
|
|Yes
|
|NULL
|
|John Smith
|
|This identifies the resource that created the record.
|
|
|-
|-
|CREATEDON
|DATE
|
|
|
|Yes
|
|NULL
|
|22-08-26
|
|This identifies the date that record was created.
|-
|-
|MODIFIEDBYNAME
|VARCHAR2(100 CHAR)
|
|
|
|Yes
|
|NULL
|
|John Smith
|
|This identifies the resource that last modified the record.
|
|
|-
|-
|MODIFIEDON
|DATE
|
|
|
|Yes
|
|NULL
|
|22-08-26
|
|This identifies the date that record was last modified.
|
|
|}
|}
