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