Table Detail Report
AUTH_ERROR
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | Auth_Error |
Definition: | This activity table is used to track instances where a user has attempted to verify a result and attempts to reauthenticate themselves unsuccessfully three (consecutive) times. One row is written after the third consecutive incorrect attempt. |
Table Type: | ACTIVITY |
Column Detail - AUTH_ERROR
Column Name | Type | Null? | Definition |
---|---|---|---|
APPLICATION_NUMBER | DOUBLE | N | This column is used to store the number of the application the user was using when unsuccessfully attempting to re-authenticate themselves. |
AUTH_ERROR_ID | DOUBLE | N | This field uniquely identifies a row on the Auth_Error table. This field would be used to join to the auth_error_detail table. |
ERROR_DT_TM | DATETIME | N | This column is used to store the date and time of when the user unsuccessfully attempted to re-authenticate themselves. |
PERSON_ID | DOUBLE | N | This is the value of the unique primary identifier of the person table. It is an internal system assigned number. |
TASK_NUMBER | DOUBLE | N | This column is used to store the number of the task the user was using when unsuccessfully attempting to re-authenticate themselves. |
UPDT_APPLCTX | DOUBLE | N | The application context number from the record info block. |
UPDT_CNT | DOUBLE | N | Set to 0 on insert. Incremented by 1 on update. Used to recognize update conflict where data in a row updated by one application is at risk of being lost by a second application attempting to update the row. |
UPDT_DT_TM | DATETIME | N | The date and time the row was last inserted or updated. |
UPDT_ID | DOUBLE | N | The person_id of the person from the personnel table (prsnl) that caused the last insert or update of the row in the table. |
UPDT_TASK | DOUBLE | N | The registered (assigned) task number for the process that inserted or updated the row. |
Relationship Detail - AUTH_ERROR
Child Column in AUTH_ERROR(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | PERSON_ID | PRSNL | PERSON_ID |
Parent Column in AUTH_ERROR (PK) | Child Table Name | Child Column Name | |
---|---|---|---|
Children: | AUTH_ERROR_ID | AUTH_ERROR_DETAIL | AUTH_ERROR_ID |
AUTH_ERROR_DETAIL
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | Auth_Error_Detail |
Definition: | This activity table is used to record additional logging information when a user attempts to reauthenticate themselves incorrectly three consecutive times. |
Table Type: | ACTIVITY |
Column Detail - AUTH_ERROR_DETAIL
Column Name | Type | Null? | Definition |
---|---|---|---|
AUTH_ERROR_ID | DOUBLE | N | This field uniquely identifies a row on the Auth_Error_Detail table in conjunction with the sequence field. |
DISPLAY_LABEL | VARCHAR(40) | Y | This field is used as a data label for the display_value field when printing the CCL audit for the Auth_Error table. |
DISPLAY_VALUE | VARCHAR(40) | Y | This field is used as to hold additional logging information when printing the CCL audit for the Auth_Error table. |
SEQUENCE | DOUBLE | N | This field uniquely identifies a row on the Auth_Error_Detail table in conjunction with the auth_error_id field. |
UPDT_APPLCTX | DOUBLE | N | The application context number from the record info block. |
UPDT_CNT | DOUBLE | N | Set to 0 on insert. Incremented by 1 on update. Used to recognize update conflict where data in a row updated by one application is at risk of being lost by a second application attempting to update the row. |
UPDT_DT_TM | DATETIME | N | The date and time the row was last inserted or updated. |
UPDT_ID | DOUBLE | N | The person_id of the person from the personnel table (prsnl) that caused the last insert or update of the row in the table. |
UPDT_TASK | DOUBLE | N | The registered (assigned) task number for the process that inserted or updated the row. |
Relationship Detail - AUTH_ERROR_DETAIL
Child Column in AUTH_ERROR_DETAIL(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | AUTH_ERROR_ID | AUTH_ERROR | AUTH_ERROR_ID |
CASE_PROVIDER
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | Case Provider |
Definition: | This activity table contains entries for all current cases having copy to physicians associated. The case/physician relationships are stored. |
Table Type: | ACTIVITY |
Column Detail - CASE_PROVIDER
Column Name | Type | Null? | Definition |
---|---|---|---|
CASE_ID | DOUBLE | N | This field contains the foreign key value used to join to case information stored on the PATHOLOGY_CASE activity table. |
PHYSICIAN_ID | DOUBLE | N | This field contains the unique internal identifier of the physician who was designated as a copy to physician. This ID could be used to access user information by joining to the PRSNL or PERSON tables. |
UPDT_APPLCTX | DOUBLE | N | The application context number from the record info block. |
UPDT_CNT | DOUBLE | N | Set to 0 on insert. Incremented by 1 on update. Used to recognize update conflict where data in a row updated by one application is at risk of being lost by a second application attempting to update the row. |
UPDT_DT_TM | DATETIME | N | The date and time the row was last inserted or updated. |
UPDT_ID | DOUBLE | N | The person_id of the person from the personnel table (prsnl) that caused the last insert or update of the row in the table. |
UPDT_TASK | DOUBLE | N | The registered (assigned) task number for the process that inserted or updated the row. |
Relationship Detail - CASE_PROVIDER
Child Column in CASE_PROVIDER(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | CASE_ID | PATHOLOGY_CASE | CASE_ID |
PHYSICIAN_ID | PRSNL | PERSON_ID |
CASE_REPORT
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | Case Report |
Definition: | This activity table contains entries for all current cases having one or more reports associated. The case/report relationship is stored. The ID of the user who ordered the report is stored, as is the current report status and cancellation information. |
Table Type: | ACTIVITY |
Column Detail - CASE_REPORT
Column Name | Type | Null? | Definition |
---|---|---|---|
BLOB_BITMAP | DOUBLE | Y | This field contains a value that indicates whether there is any special blob data that is associated to this report (i.e. images). |
CANCEL_CD | DOUBLE | N | If a report has been updated to a cancelled status, this field includes the identification code assigned to the cancellation reason specified by the user performing the cancellation activity. |
CANCEL_DT_TM | DATETIME | Y | If a report has been updated to a cancelled status, this field contains the date and time the cancellation activity occurred. |
CANCEL_PRSNL_ID | DOUBLE | N | If a report has been updated to a cancelled status, this field contains the internal identification code associated with the user who cancelled the report. This ID could be used to access user information by joining to the PRSNL or PERSON tables. |
CASE_ID | DOUBLE | N | This field contains the foreign key value used to join to case information stored on the PATHOLOGY_CASE activity table. |
CATALOG_CD | DOUBLE | N | This field contains the unique internal reference of the report order catalog item associated with the case. This ID could be used to access order catalog information for the report by joining to the order catalog tables. |
EVENT_ID | DOUBLE | N | This field contains the unique internal reference of the report to the report information stored in the Clinical_Event table. |
REPORT_ID | DOUBLE | N | This field uniquely defines a row included on the CASE_REPORT table (the specific case and report reference). This field would be used to join to other tables (as a foreign key) such as the REPORT_TASK table. |
REPORT_SEQUENCE | DOUBLE | N | This field contains a numeric value that is used to sequence reports when a single report order catalog item has been ordered more than one time for a single case. For example, this field would be used to sequence addendum #1 and addendum #2. |
REQUEST_DT_TM | DATETIME | Y | This field contains the date and time the report was ordered. |
REQUEST_PRSNL_ID | DOUBLE | N | This field contains the internal identification code associated with the user who ordered the report. This value could be used to join to personnel information included on the PRSNL or PERSON tables. |
SIGNING_LOCATION_CD | DOUBLE | N | Lab facility or location where case was read and diagnosed. |
STATUS_CD | DOUBLE | N | This field contains the report status code ID value. Report status codes are stored on codeset 1305. |
STATUS_DT_TM | DATETIME | Y | This field contains the date and time the report reached the status identified in the STATUS_CD field. |
STATUS_PRSNL_ID | DOUBLE | N | This field contains the internal identification code associated with the user who caused the report to be updated to the status stored in the STATUS_CD field. This value could be used to join to personnel information on the PRSNL and PERSON tables. |
SYNOPTIC_STALE_DT_TM | DATETIME | Y | This field indicates if the synoptic generated text in a report section on this report has become stale or is in need of regenerating text based on changes in specimen or Synoptic worksheet data. |
UPDT_APPLCTX | DOUBLE | N | The application context number from the record info block. |
UPDT_CNT | DOUBLE | N | Set to 0 on insert. Incremented by 1 on update. Used to recognize update conflict where data in a row updated by one application is at risk of being lost by a second application attempting to update the row. |
UPDT_DT_TM | DATETIME | N | The date and time the row was last inserted or updated. |
UPDT_ID | DOUBLE | N | The person_id of the person from the personnel table (prsnl) that caused the last insert or update of the row in the table. |
UPDT_TASK | DOUBLE | N | The registered (assigned) task number for the process that inserted or updated the row. |
Relationship Detail - CASE_REPORT
Child Column in CASE_REPORT(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | CATALOG_CD | ORDER_CATALOG | CATALOG_CD |
CASE_ID | PATHOLOGY_CASE | CASE_ID |
Parent Column in CASE_REPORT (PK) | Child Table Name | Child Column Name | |
---|---|---|---|
Children: | REPORT_ID | AP_CASE_SYNOPTIC_WS | REPORT_ID |
AP_TRANS_STAT | REPORT_ID | ||
REPORT_DETAIL_IMAGE | REPORT_ID | ||
REPORT_QUEUE_R | REPORT_ID | ||
REPORT_TASK | REPORT_ID |
CASE_SPECIMEN
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | Case Specimen |
Definition: | This activity table contains entries for all cases having one or more specimens associated. The case/specimen relationship is stored. Specimen-specific parameters entered by the user accessioning the case are stored. |
Table Type: | ACTIVITY |
Column Detail - CASE_SPECIMEN
Column Name | Type | Null? | Definition |
---|---|---|---|
ADEQUACY_IND | DOUBLE | Y | This field is not used at this time. |
CANCEL_CD | DOUBLE | N | If the specimen was cancelled, this field includes the cancellation reason code associated with the cancellation activity. |
CASE_ID | DOUBLE | N | This field contains the foreign key value used to join to case information stored on the PATHOLOGY_CASE activity table. |
CASE_SPECIMEN_ID | DOUBLE | N | This field uniquely identifies a row on the CASE_SPECIMEN table (a case-specimen relationship). This field would be used to join to other tables (as a foreign key) such as the CASSETTE table. |
COLLECT_DT_TM | DATETIME | Y | This field includes the date and time the specimen was collected. |
DISCARD_DT_TM | DATETIME | Y | The date and time the specimen was disposed. |
DISCARD_REASON_CD | DOUBLE | N | The reason why the specimen was disposed. |
FIXATIVE_ADDED_CD | DOUBLE | N | This field is not used at this time. |
FROZEN_REPORT_ID | DOUBLE | N | This field is not used at this time. |
INADEQUACY_REASON_CD | DOUBLE | N | If the specimen was documented as inadequate in the Maintain Case application, this field includes the identification code associated with the inadequacy reason. Specimen inadequacy reasons are stored on codeset 1318. |
LABEL_CREATE_DT_TM | DATETIME | Y | The date and time the last label was created. |
LABEL_CREATE_TYPE_FLAG | DOUBLE | N | The type of method used to creat the label.0 = Spooled,1 = Flat File3 = Nice Label Flat File |
NOMENCLATURE_ID | DOUBLE | N | This field is not used at this time. |
ON_LOAN_LOCN_CD | DOUBLE | N | This field is not used at this time. |
ORIGINAL_STORAGE_DT_TM | DATETIME | Y | The date and time the specimen was placed in storage. |
RECEIVED_DT_TM | DATETIME | Y | This field includes the date and time the specimen was received. |
RECEIVED_FIXATIVE_CD | DOUBLE | N | If the specimen was associated with a fixative in the Maintain Case application, this field includes the identification code associated with the fixative. Fixatives are stored on codeset 1302. |
RECEIVED_ID | DOUBLE | N | This field includes the internal identification code associated with the user who updated the specimen to a received [in pathology] status. This value could be used to join to personnel information on the PRSNL and PERSON tables. |
SPECIAL_COMMENTS | VARCHAR(200) | Y | This field is no longer used. Please refer to the SPEC_COMMENT_LONG_TEXT_ID for information regarding the specimen commentl. |
SPECIMEN_CD | DOUBLE | N | This field stores the internal identification code associated with the specimen submitted. Specimens are stored on codeset 1306. |
SPECIMEN_DESCRIPTION | VARCHAR(255) | Y | This field stores the description associated with the specimen. |
SPECIMEN_TAG_ID | DOUBLE | N | This field stores the reference to the actual identification code value associated with the specimen. The identification code values are stored on the AP_TAG reference table. |
SPEC_COMMENTS_LONG_TEXT_ID | DOUBLE | N | This field contains the value representing the entry on the LONG_TEXT table that contains the specimen comment. |
STORAGE_LOCN_CD | DOUBLE | N | This field is not used at this time. |
UPDT_APPLCTX | DOUBLE | N | The application context number from the record info block. |
UPDT_CNT | DOUBLE | N | Set to 0 on insert. Incremented by 1 on update. Used to recognize update conflict where data in a row updated by one application is at risk of being lost by a second application attempting to update the row. |
UPDT_DT_TM | DATETIME | N | The date and time the row was last inserted or updated. |
UPDT_ID | DOUBLE | N | The person_id of the person from the personnel table (prsnl) that caused the last insert or update of the row in the table. |
UPDT_TASK | DOUBLE | N | The registered (assigned) task number for the process that inserted or updated the row. |
Relationship Detail - CASE_SPECIMEN
Child Column in CASE_SPECIMEN(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | SPECIMEN_TAG_ID | AP_TAG | TAG_ID |
SPEC_COMMENTS_LONG_TEXT_ID | LONG_TEXT | LONG_TEXT_ID | |
CASE_ID | PATHOLOGY_CASE | CASE_ID |
Parent Column in CASE_SPECIMEN (PK) | Child Table Name | Child Column Name | |
---|---|---|---|
Children: | CASE_SPECIMEN_ID | AP_CASE_SYNOPTIC_WS | CASE_SPECIMEN_ID |
CASSETTE | CASE_SPECIMEN_ID | ||
PROCESSING_TASK | CASE_SPECIMEN_ID | ||
SLIDE | CASE_SPECIMEN_ID |