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 |