Table Detail Report

SIGN_LINE_EP_R



Column Section Top of Page


Table-level Detail

Description: Sign Line Encounter Pathway Relation
Definition: This table contains the relationships between the encounter pathway used in Case Integration with the signature line format.
Table Type: REFERENCE





Column Detail - SIGN_LINE_EP_R


Column Name Type Null? Definition
ACTIVE_IND DOUBLE Y The table row is active or inactive. A row is generally active unless it is in an inactive state such as logically deleted, combined away, pending purge, etc.
CKI_IDENTIFIER VARCHAR(50) N This column indicates the CKI Identifier of the pattern selected to be associated with the given signature line. This identifier originates in the SCR Pattern table.
CKI_SOURCE VARCHAR(12) N This column indicates the CKI Source of the pattern selected to be associated with the given signature line. this identifier originates in the SCR Pattern Table.
FORMAT_ID DOUBLE N This column contains the internal identification code representing the signature line format. This value is used to join to the signature line format information stored on the SIGN_LINE_FORMAT table.
SIGN_LINE_EP_R_ID DOUBLE N Unique identifier for the signature line to pattern relationship for case integration signature lines.
STATUS_FLAG DOUBLE Y This column contains a flag value representing the result status for which the signature line format is associated. Currently, signature lines can be associated with:2 - Verified and Corrected
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.


SIGN_LINE_FORMAT



Column Section Relationship Section Top of Page


Table-level Detail

Description: Signature Line Format Table
Definition: This table includes the primary identification code and description for a signature line format. The signature line format attributes are stored on the SIGN_LINE_FORMAT_DETAIL table.
Table Type: REFERENCE





Column Detail - SIGN_LINE_FORMAT


Column Name Type Null? Definition
ACTIVE_IND DOUBLE Y The table row is active or inactive. A row is generally active unless it is in an inactive state such as logically deleted, combined away, pending purge, etc.
DESCRIPTION VARCHAR(60) Y This field contains the description established for the signature line format.
FORMAT_ID DOUBLE N This internal identification code value uniquely identifies a row on this table. This value is used to join to other tables, such as the SIGN_LINE_FORMAT_DETAIL table.
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 - SIGN_LINE_FORMAT




Parent Column in SIGN_LINE_FORMAT (PK) Child Table Name Child Column Name
Children: FORMAT_ID SIGN_LINE_DTA_R FORMAT_ID
SIGN_LINE_FORMAT_DETAIL FORMAT_ID
SIGN_LINE_LAYOUT_FIELD_R FORMAT_ID


SIGN_LINE_FORMAT_DETAIL



Column Section Relationship Section Top of Page


Table-level Detail

Description: Signature Line Format Detail Parameters Table
Definition: This table includes the line by line format attributes associated with a signature line format.
Table Type: REFERENCE





Column Detail - SIGN_LINE_FORMAT_DETAIL


Column Name Type Null? Definition
COLUMN_POS DOUBLE N This field identifies the column position to which the signature line format element is located. If a non-negative number is included in this field, the field represents the actual column print position. If a negative number is included, the field represents the option to let the data elements and literals 'float' together to appear as a single element.
DATA_ELEMENT_CD DOUBLE N This field contains the internal identification code of the data element, from codeset 14287, to beprinted in the column position and line number specified.
DATA_ELEMENT_FORMAT_CD DOUBLE N This field contains the internal identification code of the data element format, from codeset 22669. This field determines the formatting for the data_element_cd.
FORMAT_ID DOUBLE N This field contains the internal identifier representing the signature line format. It is used to join to the SIGN_LINE_FORMAT table, which contains the high-level parameters for the signature line format.
LINE_NBR DOUBLE N This field identifies the line number within the signature line format to which the format information included on this record applies.
LITERAL_DISPLAY VARCHAR(100) Y This field contains the literal display value associated with the literal element, if any, specified to print in the signature line format column position and line number.
LITERAL_SIZE DOUBLE N This field contains the printable size (number of characters) for the associated literal display value. This number is automatically calculated by the value written to the LITERAL_DISPLAY field, butcan be overridden by the user building the signature line format.
MAX_SIZE DOUBLE N This field contains the printable size (number of characters) for the associated data element display value. This number is automatically calculated by the value written to the DATA_ELEMENT_CD field, but can be overridden by the user building the signature line format.
SEQUENCE DOUBLE N This field, in combination with the FORMAT_ID field, uniquely identifies a row on this table.
SUPPRESS_LINE_IND DOUBLE N This field indicates whether a line should be suppressed from the signature line if it is empty.
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 - SIGN_LINE_FORMAT_DETAIL


Child Column in SIGN_LINE_FORMAT_DETAIL(FK) Parent Table Name Parent Column Name
Parents: FORMAT_ID SIGN_LINE_FORMAT FORMAT_ID


SLIDE



Column Section Relationship Section Top of Page


Table-level Detail

Description: Slide
Definition: This activity table includes records for slides that are created from specimens or blocks. Parameters associated with the slide, such as the stain, slide count category (half-slide, full-slide), and slide origin (specimen or block) are stored.
Table Type: ACTIVITY





Column Detail - SLIDE


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. This field is filled out only when the slide inventory is created from a specimen.
CASSETTE_ID DOUBLE N This field contains the foreign key value used to join to cassette information stored on the CASSETTE activity table. This field is filled out only when the slide inventory is created from a cassette.
DISCARD_DT_TM DATETIME Y The date and time the slide was disposed.
DISCARD_REASON_CD DOUBLE N The reason why the slide was disposed.
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 slide was placed in storage.
ORIGIN_MODIFIER CHAR(7) Y If a slide modifier value was associated with the processing task that caused the row to be added to the SLIDE 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.
SCREENING_IND DOUBLE N Indicated screening status of the slide.
SEQUENCE_NBR DOUBLE Y This field contains a sequence value used to identify the relationship from one slide to the next for a single case.
SLIDE_ID DOUBLE N This field uniquely identifies a row (a slide) included in the SLIDE table.
SPECIAL_STAIN_IND DOUBLE Y If the slide was designated as a stained slide, this field stores the internal identification code associated with the discrete task associated with the specific stain. This value could be used to join to the discrete task assay tables.
STAIN_TASK_ASSAY_CD DOUBLE N This field contains the internal identification code assigned to the processing task representing the activity which, through its completion, caused the slide to be stained. This code could be used to join to the discrete_task_assay table.
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.
TAG_ID DOUBLE N This field stores the reference to the actual identification code value associated with the slide. The identification code values are stored on the AP_TAG_GROUP and AP_TAG reference tables.
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 SLIDE 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. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic.
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. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic.
UPDT_DT_TM DATETIME N The date and time the row was last inserted or updated. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic.
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. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic.
UPDT_TASK DOUBLE N The registered (assigned) task number for the process that inserted or updated the row. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic.



Relationship Detail - SLIDE


Child Column in SLIDE(FK) Parent Table Name Parent Column Name
Parents: TAG_ID AP_TAG TAG_ID
CASE_SPECIMEN_ID CASE_SPECIMEN CASE_SPECIMEN_ID
CASSETTE_ID CASSETTE CASSETTE_ID
STAIN_TASK_ASSAY_CD DISCRETE_TASK_ASSAY TASK_ASSAY_CD
TASK_ASSAY_CD DISCRETE_TASK_ASSAY TASK_ASSAY_CD




Parent Column in SLIDE (PK) Child Table Name Child Column Name
Children: SLIDE_ID AP_DIGITAL_SLIDE SLIDE_ID
PROCESSING_TASK SLIDE_ID


SPECIMEN_GROUPING_R



Column Section Relationship Section Top of Page


Table-level Detail

Description: Specimen Grouping Reltn
Definition: This reference table contains specimen groupings that can optionally be associated with a case prefix. Specimen groupings (sublists of specimens from codeset 1306) provide an option for the specimen list to be more specific to the case prefix.
Table Type: REFERENCE





Column Detail - SPECIMEN_GROUPING_R


Column Name Type Null? Definition
CATEGORY_CD DOUBLE N This field stores the foreign key reference to the specimen groupings (stored on codeset 1312).
SOURCE_CD DOUBLE N This field stores the foreign key reference to the specimens (stored on codeset 1306) associated to the specimen groupings (stored on codeset 1312).
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 - SPECIMEN_GROUPING_R


Child Column in SPECIMEN_GROUPING_R(FK) Parent Table Name Parent Column Name
Parents: CATEGORY_CD CODE_VALUE CODE_VALUE
SOURCE_CD CODE_VALUE CODE_VALUE