Table Detail Report
ACCESSION_EXTERNAL_SMRY
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | Accession External Summary |
Definition: | This table contains a single record of the summary for the external accession assigned to the contents of an accession in Millennium |
Table Type: | ACTIVITY |
Column Detail - ACCESSION_EXTERNAL_SMRY
Column Name | Type | Null? | Definition |
---|---|---|---|
ACCESSION_EXTERNAL_SMRY_ID | DOUBLE | N | Uniquely identifies a summary record for the external accession assigned to the contents of an accession in Millennium. |
ACCESSION_ID | DOUBLE | N | Uniquely identifies the accession that the external summary has been recorded for. |
COLLECTED_DT_TM | DATETIME | Y | This is the collected date and time associated with the external accession. |
EXTERNAL_ACCESSION | VARCHAR(40) | N | This field contains the formatted representation of the accession number. |
EXTERNAL_ACCESSION_COMMENT_ID | DOUBLE | N | Uniquely identifies the comment describing the external accession. |
EXTERNAL_ACCESSION_KEY | VARCHAR(40) | N | This field contains the alpha numeric characters of the external accession. |
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 - ACCESSION_EXTERNAL_SMRY
Child Column in ACCESSION_EXTERNAL_SMRY(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | ACCESSION_ID | ACCESSION | ACCESSION_ID |
EXTERNAL_ACCESSION_COMMENT_ID | LONG_TEXT | LONG_TEXT_ID |
ACCESSION_ORDER_R
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | Accession/Order relationship |
Definition: | The resolution table between accessions and orders. This table will tell you what orders belong to an accession. It will also tell you what accession(s) an order belongs to. |
Table Type: | ACTIVITY |
Column Detail - ACCESSION_ORDER_R
Column Name | Type | Null? | Definition |
---|---|---|---|
ACCESSION | VARCHAR(20) | Y | An accession uniquely identifies a specimen. |
ACCESSION_ID | DOUBLE | N | A system generated number that uniquely identifies an accession number. |
ACTIVITY_TYPE_CD | DOUBLE | N | A code value that uniquely identifies to which "net" (such as PathNet or RadNet) and/or what department (such as General Lab or Microbiology) an order belongs. |
ORDER_ID | DOUBLE | N | A system generated number that uniquely identifies an order. |
PRIMARY_FLAG | DOUBLE | N | Determines if this is the primary accession for the order.0 - This is the primary accession for the order.1 - This is the secondary accession for the order. This is the original accession that was created for the order but replaced due to a missed collection and reshcedule of the order. |
PRIMARY_IND | DOUBLE | Y | This field identifies which accession is the current, primary indicator for a particular order. The field should be set to 1 if the accession on this row is the current primary accession for the order on this row, otherwise it should be set to 0. This field will be used for future functionality. |
RESTRICT_AV_IND | DOUBLE | N | The restrict autoverification indicator is set from the AVStatus.dll and indicates when the accession is restricted from being autoverified. A value of 1 indicates the accession is restricted from being autoverified. A value of 0 indicates the accession is not restricted from being autoverified. |
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 - ACCESSION_ORDER_R
Child Column in ACCESSION_ORDER_R(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | ORDER_ID | ORDERS | ORDER_ID |
ACCESSION_SETUP
Column Section | Top of Page |
Table-level Detail
Description: | Accession setup |
Definition: | Holds the global settings for accession numbers. |
Table Type: | REFERENCE |
Column Detail - ACCESSION_SETUP
Column Name | Type | Null? | Definition |
---|---|---|---|
ACCEPT_FUTURE_DAYS | DOUBLE | Y | The number of days in the future that an accession number can be accepted from the current day. |
ACCESSION_SETUP_ID | DOUBLE | N | The system generated number that identifies the row in the table. |
ALPHA_SEQUENCE_LENGTH | DOUBLE | Y | Defines the length of the sequence portion of alpha prefixed accession numbers. |
ASSIGN_FUTURE_DAYS | DOUBLE | Y | The number of days in the future that an accession number can be assigned. |
DEFAULT_SITE_CD | DOUBLE | N | If site prefixes are turned on, this is default that the accession assignment routine will use if the client application does not pass in the facility. |
JULIAN_SEQUENCE_LENGTH | DOUBLE | Y | This is the length of the sequence portion of Julian date format accession numbers. |
MANUAL_ASSIGN_IND | DOUBLE | Y | Global switch to turn on the ability to manually assign accession numbers. |
SITE_CODE_LENGTH | DOUBLE | Y | If site prefixes are turned on, this determines the display length of the site prefixes. |
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. |
YEAR_DISPLAY_LENGTH | DOUBLE | Y | In the database all four digits of the year portion of an accession number are stored. This field controls how many digits of the year are displayed. Recommended value: 2. |
ASSAY_RESOURCE_LIST
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | Assay Resource List |
Definition: | The resolution table between discrete task assays and service resources. This table will tell you all of the possible service resources for which a given task/assay can be performed. |
Table Type: | REFERENCE |
Column Detail - ASSAY_RESOURCE_LIST
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. |
ACTIVE_STATUS_CD | DOUBLE | N | Indicates the status of the row itself (not the data in the row) such as active, inactive, combined away, pending purge, etc. |
ACTIVE_STATUS_DT_TM | DATETIME | Y | The date and time that the active_status_cd was set. |
ACTIVE_STATUS_PRSNL_ID | DOUBLE | N | The person who caused the active_status_cd to be set or change. |
BEG_EFFECTIVE_DT_TM | DATETIME | N | The date and time for which this table row becomes effective. Normally, this will be the date and time the row is added, but could be a past or future date and time. |
END_EFFECTIVE_DT_TM | DATETIME | N | The date/time after which the row is no longer valid as active current data. This may be valued with the date that the row became inactive. |
PRIMARY_IND | DOUBLE | Y | Indicates if the service resource will be the primary one for the specified task/assay and, as such, will be the default service resource to be routed to if all other loading logic fails. |
RESOURCE_GROUP_CD | DOUBLE | N | Not used currently |
RESOURCE_ROUTE_FLAG | DOUBLE | Y | Not used currently |
SCRIPT_NAME | VARCHAR(50) | Y | Name of the script to be used for site-required loading logic not provided through the calendar logic. |
SEQUENCE | DOUBLE | Y | Used to determine the sequence by which service resources will be tested for routing logic. Once the routing server has found a match by sequence, loading will occur and no other service resources will be tested. The rule is to give the exceptions a lower sequence. |
SERVICE_RESOURCE_CD | DOUBLE | N | Used to store the code for the service resource related to the task/assays. |
TASK_ASSAY_CD | DOUBLE | N | Used to store the code for the task/assays associated with the service resource. |
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 - ASSAY_RESOURCE_LIST
Child Column in ASSAY_RESOURCE_LIST(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | TASK_ASSAY_CD | DISCRETE_TASK_ASSAY | TASK_ASSAY_CD |
SERVICE_RESOURCE_CD | SERVICE_RESOURCE | SERVICE_RESOURCE_CD |
CONCEPT_IDENTIFIER_DTA
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | Concept Identifier Discrete Task Assay |
Definition: | Stores reference data linking unique Discrete Task Assay/Specimen Type/Service Resource combinations with concept identifier codes (LOINC) |
Table Type: | REFERENCE |
Column Detail - CONCEPT_IDENTIFIER_DTA
Column Name | Type | Null? | Definition |
---|---|---|---|
ACTIVE_IND | DOUBLE | N | 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. |
ACTIVE_STATUS_CD | DOUBLE | N | Indicates the status of the row itself (not the data in the row) such as active, inactive, combined away, pending purge, etc. |
ACTIVE_STATUS_DT_TM | DATETIME | N | The date and time that the active_status_cd was set. |
ACTIVE_STATUS_PRSNL_ID | DOUBLE | N | The person who caused the active_status_cd to be set or change. |
BEG_EFFECTIVE_DT_TM | DATETIME | N | The date and time for which this table row becomes effective. Normally, this will be the date and time the row is added, but could be a past or future date and time. |
CONCEPT_CKI | VARCHAR(255) | Y | The concept identifier. Used to link to the nomenclature row containing additional information about the concept identifier. |
CONCEPT_IDENTIFIER_DTA_ID | DOUBLE | N | Uniquely identifies a specific relationship between a discrete task assay/specimen type/service resource with a concept identifier code (LOINC) |
CONCEPT_TYPE_FLAG | DOUBLE | N | Identifies the type of concept identifier associated to the antibiotic and susceptibility method. 1 = LOINC Analyte Code 2 - LOINC Attachment Code |
END_EFFECTIVE_DT_TM | DATETIME | N | The date/time after which the row is no longer valid as active current data. This may be valued with the date that the row became inactive. |
IGNORE_IND | DOUBLE | N | Identifies that the row will be ignored by the LOINC service. |
SERVICE_RESOURCE_CD | DOUBLE | N | A code value that identifies the specific service resource associated with the concept identifier. |
SPECIMEN_TYPE_CD | DOUBLE | N | A code value that identifies the specific specimen associated with the concept identifier. |
TASK_ASSAY_CD | DOUBLE | N | A code value that identifies the specific discrete task assay associated with the concept identifier. |
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 - CONCEPT_IDENTIFIER_DTA
Child Column in CONCEPT_IDENTIFIER_DTA(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | TASK_ASSAY_CD | DISCRETE_TASK_ASSAY | TASK_ASSAY_CD |
SERVICE_RESOURCE_CD | SERVICE_RESOURCE | SERVICE_RESOURCE_CD |