ACCESSION



Column Section Relationship Section Top of Page


Table-level Detail

Description: Accession
Definition: Every accession number generated by the system will be represented by a row in this table.
Table Type: ACTIVITY





Column Detail - ACCESSION


Column Name Type Null? Definition
ACCESSION VARCHAR(20) N An accession number identifies an order or a group of orders.
ACCESSION_CLASS_CD DOUBLE N The internal number assigned by the system as a code value for the Accession Class.
ACCESSION_DAY DOUBLE Y The Julian day of an accession number. The Julian day for an alpha prefixed accession will be the Julian day the accession number was assigned.
ACCESSION_FORMAT_CD DOUBLE N The internal number assigned by the system as a code value for the Accession Format.
ACCESSION_ID DOUBLE N A system generated number that uniquely identifies an accession number.
ACCESSION_NBR_CHECK VARCHAR(50) Y An internal representation of an accession number used to uniquely identify an accession number.
ACCESSION_POOL_ID DOUBLE N A system generated number that uniquely identifies an accession assignment pool.
ACCESSION_SEQUENCE_NBR DOUBLE Y The sequence number of an accession number.
ACCESSION_YEAR DOUBLE Y The year of the accession number.
ALPHA_PREFIX CHAR(2) Y The alpha prefix of the accession number. Julian day accession will not have an alpha prefix.
ASSIGNMENT_IND DOUBLE N Used to differentiate manually assigned accessions from system assigned.
PREACTIVE_IND DOUBLE Y For Quality Control accessions, this will be true while the accession number is in a pre-active state.
SITE_PREFIX_CD DOUBLE N The internal number assigned by the system as a code value for the Site Prefix of an accession number.
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 - ACCESSION




Parent Column in ACCESSION (PK) Child Table Name Child Column Name
Children: ACCESSION_ID ACCESSION_EXTERNAL_SMRY ACCESSION_ID
AP_LOGIN_ORDER_LIST ACCESSION_ID
AP_PROMPT_TEST ACCESSION_ID
CHARGE_EVENT_ACT ACCESSION_ID
CV_PROC ACCESSION_ID
ESI_LOG ACCESSION_ID
HLA_XM_TRAY_WELL QC_ACCESSION_ID
HLA_XM_TRAY_WELL_SCORE QC_ACCESSION_ID
ORDER_RADIOLOGY ACCESSION_ID
PCS_ORDER_GROUP GROUP_ACCESSION_ID
PROP_ORDER ACCESSION_ID
RESOURCE_ACCESSION_R ACCESSION_ID
RR_ACCESSION_R ACCESSION_ID
UCM_SPECIMEN_COMMENT ACCESSION_ID
WORKLIST_ACCESSION_R ACCESSION_ID
WORKLIST_REF_POS ACCESSION_ID


ACCESSION_ASSIGNMENT



Column Section Relationship Section Top of Page


Table-level Detail

Description: Accession Assignment
Definition: This is the actual accession bucket used to generate accession numbers.
Table Type: ACTIVITY





Column Detail - ACCESSION_ASSIGNMENT


Column Name Type Null? Definition
ACCESSION_SEQ_NBR DOUBLE Y The current sequence number of an accession bucket.
ACC_ASSIGN_DATE DATETIME N The date the accession bucket was created.
ACC_ASSIGN_POOL_ID DOUBLE N A system generated number that uniquely identifies an accession bucket.
INCREMENT_VALUE DOUBLE Y The increment value of an accession bucket.
LAST_INCREMENT_DT_TM DATETIME Y The date and time the accession bucket was increment.
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_ASSIGNMENT


Child Column in ACCESSION_ASSIGNMENT(FK) Parent Table Name Parent Column Name
Parents: ACC_ASSIGN_POOL_ID ACCESSION_ASSIGN_POOL ACCESSION_ASSIGNMENT_POOL_ID


ACCESSION_ASSIGN_POOL



Column Section Relationship Section Top of Page


Table-level Detail

Description: Accession Assignment Pool
Definition: The templates for the accession buckets (accession_assignment table).
Table Type: REFERENCE





Column Detail - ACCESSION_ASSIGN_POOL


Column Name Type Null? Definition
ACCESSION_ASSIGNMENT_POOL_ID DOUBLE N A system generated number that uniquely identifies an accession pool.
ACTIVITY_TYPE_CD DOUBLE N Stores the code value for the activity type that is used to filter order catalog items within catalog type
DESCRIPTION VARCHAR(50) Y The description of the accession bucket.
INCREMENT_VALUE DOUBLE Y The increment value of an accession bucket.
INITIAL_VALUE DOUBLE Y The initial value of the accession bucket.
RESET_FREQUENCY DOUBLE Y Currently not used.
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_ASSIGN_POOL




Parent Column in ACCESSION_ASSIGN_POOL (PK) Child Table Name Child Column Name
Children: ACCESSION_ASSIGNMENT_POOL_ID ACCESSION_ASSIGNMENT ACC_ASSIGN_POOL_ID
ACCESSION_ASSIGN_XREF ACCESSION_ASSIGNMENT_POOL_ID
PREFIX_GROUP GROUP_ID


ACCESSION_ASSIGN_XREF



Column Section Relationship Section Top of Page


Table-level Detail

Description: Accession Assignment Cross Reference
Definition: This table associates accession formats with an assignment bucket.
Table Type: REFERENCE





Column Detail - ACCESSION_ASSIGN_XREF


Column Name Type Null? Definition
ACCESSION_ASSIGNMENT_POOL_ID DOUBLE N A system generated number that uniquely identifies an accession assignment bucket.
ACCESSION_FORMAT_CD DOUBLE N The internal number assigned by the system as a code value for the Accession Format.
ACTIVITY_TYPE_CD DOUBLE N A code value that uniquely identifies to which "net" (PathNet, RadNet) and/or what department (General Lab, Microbiology) an order belongs.
SITE_PREFIX_CD DOUBLE N The internal number assigned by the system as a code value for the Site Prefix of an accession number.
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_ASSIGN_XREF


Child Column in ACCESSION_ASSIGN_XREF(FK) Parent Table Name Parent Column Name
Parents: ACCESSION_ASSIGNMENT_POOL_ID ACCESSION_ASSIGN_POOL ACCESSION_ASSIGNMENT_POOL_ID




Parent Column in ACCESSION_ASSIGN_XREF (PK) Child Table Name Child Column Name
Children: ACCESSION_FORMAT_CD AP_PREFIX ACCESSION_FORMAT_CD
SITE_PREFIX_CD AP_PREFIX SITE_CD


ACCESSION_CLASS



Column Section Relationship Section Top of Page


Table-level Detail

Description: Accession Class
Definition: All accession classes (codeset 2056) are stored in this table with their corresponding accession format.
Table Type: REFERENCE





Column Detail - ACCESSION_CLASS


Column Name Type Null? Definition
ACCESSION_CLASS_CD DOUBLE N The internal number assigned by the system as a code value for the Accession Class.
ACCESSION_FORMAT_CD DOUBLE N The internal number assigned by the system as a code value for the Accession Format to be assigned to orders having this Accession Class.
GROUP_IND DOUBLE N Indicates whether the accession class is to be used as a group identifier for linking patient orders.
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_CLASS




Parent Column in ACCESSION_CLASS (PK) Child Table Name Child Column Name
Children: ACCESSION_CLASS_CD PROCEDURE_SPECIMEN_TYPE ACCESSION_CLASS_CD