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