Table Detail Report
CASE_SPECIMEN_TYPE_R
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | Case Specimen Type Reltn |
Definition: | This reference table contains the relationships between specimens (from codeset 1306) and specimen types (Cerner-defined). |
Table Type: | REFERENCE |
Column Detail - CASE_SPECIMEN_TYPE_R
Column Name | Type | Null? | Definition |
---|---|---|---|
CASE_TYPE_CD | DOUBLE | N | This field contains the case type value (Autopsy, GYN, Fluid, Surgical, Other) associated with the accession prefix. Case type values are stored on codeset 1301. |
SPECIMEN_MEANING | VARCHAR(12) | N | This field contains the Cerner-defined code that is used to present the valid specimens based on the accession prefix. Specimen meanings are stored on codeset 1301. Using this, users can select from only tissue specimens for surgical cases, for example. |
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_TYPE_R
Child Column in CASE_SPECIMEN_TYPE_R(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | CASE_TYPE_CD | CODE_VALUE | CODE_VALUE |
CASSETTE
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | Cassette |
Definition: | This activity table contains entries for blocks that are created from specimens. Parameters such as the specimen, block/cassette identification code, fixative, and number of pieces of tissue are included. |
Table Type: | ACTIVITY |
Column Detail - CASSETTE
Column Name | Type | Null? | Definition |
---|---|---|---|
CASE_SPECIMEN_ID | DOUBLE | N | This field contains the foreign key value used to join to case and specimen information stored on the CASE_SPECIMEN activity table. |
CASSETTE_ID | DOUBLE | N | This field uniquely identifies a row included on the CASSETTE table (block/cassette). This field would be used to join to other tables (as a foreign key) such as the SLIDE table. |
CASSETTE_TAG_ID | DOUBLE | N | This field contains an identifier referencing the block/cassette identification code associated with the block/cassette. |
DISCARD_DT_TM | DATETIME | Y | The date and time the block was disposed. |
DISCARD_REASON_CD | DOUBLE | N | The reason why the block was disposed. |
EMBEDDING_MEDIA_CD | DOUBLE | N | This field is not used at this time. |
FIXATIVE_CD | DOUBLE | N | If the block/cassette was associated with a fixative, this field includes the identification code associated with the fixative. Fixatives are stored on codeset 1302. |
FROZEN_IND | DOUBLE | Y | This field is not used at this time. |
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 |
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 block was placed in storage. |
ORIGIN_MODIFIER | CHAR(7) | Y | If a block modifier value was associated with the processing task that caused the row to be added to the CASSETTE table, the modifier value entered by the user is stored in this field. |
OWNER_ID | DOUBLE | N | This field is not used at this time. |
PIECES | CHAR(3) | Y | If a number of pieces value was associated with the processing task that cause the row to be added to the CASSETTE table, the number of pieces value entered by the user is stored in this field. The order entry applications default this value to 1. |
SECTIONABLE_IND | DOUBLE | Y | This field is not used at this time. |
STORAGE_LOCATION_CD | DOUBLE | N | This field is not used at this time. |
SUPPLEMENTAL_TAG | CHAR(2) | Y | This field is not used at this time. |
TASK_ASSAY_CD | DOUBLE | N | This field stores the internal identification code associated with the discrete task that caused the row to be added to the CASSETTE table. This value could be used to join to the discrete task assay 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 - CASSETTE
Child Column in CASSETTE(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | CASSETTE_TAG_ID | AP_TAG | TAG_ID |
CASE_SPECIMEN_ID | CASE_SPECIMEN | CASE_SPECIMEN_ID | |
TASK_ASSAY_CD | DISCRETE_TASK_ASSAY | TASK_ASSAY_CD |
Parent Column in CASSETTE (PK) | Child Table Name | Child Column Name | |
---|---|---|---|
Children: | CASSETTE_ID | PROCESSING_TASK | CASSETTE_ID |
SLIDE | CASSETTE_ID |
CYTO_ADEQUACY_ALPHA_R
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | Cytology Adequacy Alpha Reltn |
Definition: | This reference table contains the classification of every alpha response code associated with the microscopic evaluation of specimen adequacy report component procedure for cytoloogy reports. |
Table Type: | REFERENCE |
Column Detail - CYTO_ADEQUACY_ALPHA_R
Column Name | Type | Null? | Definition |
---|---|---|---|
ADEQUACY_FLAG | DOUBLE | N | This field contains a flag value documenting the general category of microscopic adequacy (satisfactory, limited, or unsatisfactory, for example) associated with the associated alpha response code value. |
CATALOG_CD | DOUBLE | N | This field contains the internal identification code associated with the cytology report for which adequacy parameters are defined. This value could be used to join to the order catalog tables, if desired. |
NOMENCLATURE_ID | DOUBLE | N | This field contains the internal identification code associated with the nomenclature response documenting specimen adequacy. This value could be used to join to the NOMENCLATURE table. |
REASON_REQUIRED_IND | DOUBLE | Y | This field contains a flag value documenting whether or not the user should be forced to enter an inadequacy reason when the associated alpha response value is selected during the report entry process. |
TASK_ASSAY_CD | DOUBLE | N | This field contains the internal identification code associated with the discrete task within the cytology report which represents the statement of microscopic adequacy report component. |
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 - CYTO_ADEQUACY_ALPHA_R
Child Column in CYTO_ADEQUACY_ALPHA_R(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | CATALOG_CD | CYTO_REPORT_CONTROL | CATALOG_CD |
TASK_ASSAY_CD | DISCRETE_TASK_ASSAY | TASK_ASSAY_CD |
CYTO_ALPHA_SECURITY
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | Cytology Alpha Security |
Definition: | This reference table contains the verification limits, general classifications, and required rescreening requirements for every diagnosis alpha response code associated with a cytology report. |
Table Type: | REFERENCE |
Column Detail - CYTO_ALPHA_SECURITY
Column Name | Type | Null? | Definition |
---|---|---|---|
DEFINITION_IND | DOUBLE | N | Indicates whether this row has been defined for:0 = both cyto alpha security and follwo-up tracking parameters.1 = cyto alpha security parameters only2 = follow-up tracking parameters only |
DEGREES_FROM_NORMAL | DOUBLE | Y | This field contains a numeric value documenting the relative comparison of the designated alpha response (nomenclature) value to the normal diagnosis response. The greater the number, the more abnormal the response. |
DIAGNOSTIC_CATEGORY_CD | DOUBLE | N | This field value contains the internal identification code of the diagnostic category associated with the alpha response (nomenclature) code. Diagnostic categories are defined on codeset 1314. |
FOLLOWUP_FINAL_INTERVAL | DOUBLE | Y | This field value contains the number of days post report verification that should elapse before a report having the associated alpha response (nomenclature) value for the diagnosis is due for printing on the final overdue follow-up tracking report. |
FOLLOWUP_FIRST_INTERVAL | DOUBLE | Y | This field value contains the number of days post report verification that should elapse before a report having the associated alpha response (nomenclature) value for the diagnosis is due for printing on the initial overdue follow-up tracking report. |
FOLLOWUP_INITIAL_INTERVAL | DOUBLE | Y | This field value contains the number of days post report verification that should elapse before a report having the associated alpha response (nomenclature) value for the diagnosis is due for printing on the initial notification follow-up tracking report. |
FOLLOWUP_TERMINATION_INTERVAL | DOUBLE | Y | This field value contains the number of days post report verification that should elapse before a report having the associated alpha response (nomenclature) value for the diagnosis is due for being removed from the AP_FT_EVENT activity table. |
FOLLOWUP_TRACKING_TYPE_CD | DOUBLE | N | This field contains the internal identification code associated with the follow-up tracking type to which the alpha response (nomenclature) value is assigned. Follow-up tracking types are stored on codeset 1317. |
NOMENCLATURE_ID | DOUBLE | N | This field contains the internal identification code associated with the nomenclature response documenting the diagnosis (the alpha response value for which this table entry is associated). This value could be used to join to the NOMENCLATURE table. |
QA_FLAG_TYPE_CD | DOUBLE | N | This field contains a flag value documenting the generic categorization that is associated with cases having the associated alpha response entered as the diagnosis. Categorizations include normal, atypical, abnormal, and unsatisfactory, for example. |
REFERENCE_RANGE_FACTOR_ID | DOUBLE | N | This field contains the foreign key value used to join to the table storing the reference range (alpha response values, in this example) information for the diagnosis alpha response report component. |
REQUEUE_FLAG | DOUBLE | Y | This field contains a flag value documenting how (and if) requeueing occurs when a user selects the associated alpha response (nomenclature) value as the diagnosis but where the user has insufficient security to verify (also based on the alpha response). |
REQUEUE_SERVICE_RESOURCE_CD | DOUBLE | N | If a requeue to service resource value is defined for the alpha response (nomenclature) code, this field contains the internal identification code associated with the response. This value could be used to join to the location tables and codesets. |
SERVICE_RESOURCE_CD | DOUBLE | N | The routing location for which these cytology alpha security settings are defined. A value of 0.0 in this field signifies these are default cytology alpha security settings. |
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. |
VERIFY_LEVEL_IS | DOUBLE | Y | This field contains the numeric verification security level that a user must meet or exceed in order to be able to verify, at the time of initial screening, a case having the associated alpha response (nomenclature) code designated as the diagnosis. |
VERIFY_LEVEL_RS | DOUBLE | Y | This field contains the numeric verification security level that a user must meet or exceed in order to be able to verify, at the time of rescreening, a case having the associated alpha response (nomenclature) code designated as the diagnosis. |
WORKLOAD_CD | DOUBLE | N | This field is not used at this time. |
Relationship Detail - CYTO_ALPHA_SECURITY
Child Column in CYTO_ALPHA_SECURITY(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | NOMENCLATURE_ID | ALPHA_RESPONSES | NOMENCLATURE_ID |
REFERENCE_RANGE_FACTOR_ID | ALPHA_RESPONSES | REFERENCE_RANGE_FACTOR_ID | |
FOLLOWUP_TRACKING_TYPE_CD | AP_FT_TYPE | FOLLOWUP_TRACKING_TYPE_CD | |
REQUEUE_SERVICE_RESOURCE_CD | SERVICE_RESOURCE | SERVICE_RESOURCE_CD |
CYTO_DIAG_DISCREPANCY
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | Cytology Diagnosis Discrepancy |
Definition: | This reference table contains the variance and discrepancy designations assigned to combinations of initial screening diagnoses compared to the verification diagnoses for a gynecologic cytology report. These associations are based on alpha responses. |
Table Type: | REFERENCE |
Column Detail - CYTO_DIAG_DISCREPANCY
Column Name | Type | Null? | Definition |
---|---|---|---|
HCFA_FLAG | DOUBLE | Y | This field is not used at this time. |
INTERNAL_FLAG | DOUBLE | Y | This field contains a numeric flag value documenting the comparison relationship (discrepancy or variance, for example) for the two alpha response (nomenclature) values included in the table entry. |
NOMENCLATURE_X_ID | DOUBLE | N | This field contains the internal identification code associated with the X-axis alpha response (nomenclature) codes included in the comparison pair included as part of the table key. The internal ID code could be used to join to the NOMENCLATURE table. |
NOMENCLATURE_Y_ID | DOUBLE | N | This field contains the internal identification code associated with the Y-axis alpha response (nomenclature) codes included in the comparison pair included as part of the table key. The internal ID code could be used to join to the NOMENCLATURE table. |
REFERENCE_RANGE_FACTOR_ID | DOUBLE | N | This field contains the foreign key value used to join to the table storing the reference range (alpha response values, in this example) information for the diagnosis alpha response report component. |
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 - CYTO_DIAG_DISCREPANCY
Child Column in CYTO_DIAG_DISCREPANCY(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | NOMENCLATURE_X_ID | ALPHA_RESPONSES | NOMENCLATURE_ID |
NOMENCLATURE_Y_ID | ALPHA_RESPONSES | NOMENCLATURE_ID | |
REFERENCE_RANGE_FACTOR_ID | ALPHA_RESPONSES | REFERENCE_RANGE_FACTOR_ID | |
REFERENCE_RANGE_FACTOR_ID | ALPHA_RESPONSES | REFERENCE_RANGE_FACTOR_ID |