71
edits
Changes
Jump to navigation
Jump to search
Line 106:
Line 106: + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + +
no edit summary
* 4 Code: [PROGRAM]_[FUNCTION]_[TABLE GROUP]_[TABLE]
* 4 Code: [PROGRAM]_[FUNCTION]_[TABLE GROUP]_[TABLE]
** Example: MD_INS_CASE_CAPA (Medical Device Inspections, Case Table Grouping, Corrective Action Plan Table.)
** Example: MD_INS_CASE_CAPA (Medical Device Inspections, Case Table Grouping, Corrective Action Plan Table.)
=== Table Listing by Schema & Program ===
==== MDCCD_DM_OWNER ====
{| class="wikitable"
|+Medical Devices
!Table Name
!Table Description
|-
|MD_INS_CASE
|This table is the main medical device inspection table.
|-
|MD_INS_CASE_CAPA
|This table holds information about the corrective action plan for an inspection observation.
|-
|MD_INS_CASE_DESIGNATION
|This table holds designation codes for an inspection.
|-
|MD_INS_CASE_ESTACTIVITY
|This table holds the activities of the establishment as entered by the inspector.
|-
|MD_INS_CASE_INSPECTORS
|This table holds a list of inspectors working on the inspection.
|-
|MD_INS_CASE_NOTES
|This table holds the notes for an inspection.
|-
|MD_INS_CASE_OBSERVATIONS
|This table holds the observations for an inspection.
|-
|MD_INS_CASE_WORKFLOW
|This table holds the busienss process flow (workflow) for an inspection.
|-
|MD_INS_IID
|This table holds the ''Initial Inspection Deficiency'' information for an inspection.
|-
|MD_INS_INSPECTORLIST
|This table holds a list of inspectors in the MDID system.
|-
|MD_INS_IRC_ENFORCEMENT
|This table holds the enforcement actions listed for an inspection as part of the ''Inspection Report Card''.
|-
|MD_INS_IRC_MEASURES
|This table holds the measures listed for an inspection as part of the ''Inspection Report Card''.
|-
|MD_INS_IRC_OBSERVATIONS
|This table holds the observations listed for an inspection as part of the ''Inspection Report Card''.
|-
|MD_INS_SITE
|This table holds the listing of sites from the MDID system including those migrated from the Medical Device System (MDS).
|-
|MD_INS_SITE_CONTACT
|This table holds the listing of site contacts from the MDID system including those migrated from the Medical Device System (MDS).
|-
|MD_INS_SITE_LICENCE
|This table holds the listing of site establishment licences from the MDID system including those migrated from the Medical Device System (MDS).
|-
|MD_INS_SITE_LICENCEACTIVITY
|This table holds the listing of site establishment licence activities from the MDID system including those migrated from the Medical Device System (MDS).
|}
== Contacts ==
== Contacts ==
