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 |