Table Detail Report

CE_PRODUCT



Column Section Relationship Section Top of Page


Table-level Detail

Description: ce product
Definition: Clinical Events Product Table
Table Type: ACTIVITY





Column Detail - CE_PRODUCT


Column Name Type Null? Definition
ABO_CD DOUBLE N Description of the ABO blood type.
EVENT_ID DOUBLE N Foreign key to the clinical event table.
PRODUCT_CD DOUBLE N Description of a product by code
PRODUCT_ID DOUBLE N Foreign key to the product table. Foreign key: XFK2 - (product)
PRODUCT_NBR VARCHAR(40) N Product number
PRODUCT_QUANTITY DOUBLE Y The number of products tested
PRODUCT_QUANTITY_UNIT_CD DOUBLE N CODE SET:54 The unit of the number of products tested, could be 'bag','unit', 'vials', etc.
PRODUCT_STATUS_CD DOUBLE N Status of product
PRODUCT_STRENGTH DOUBLE Y The concentration of the product
PRODUCT_STRENGTH_UNIT_CD DOUBLE N CODE SET:54 The unit of the concentration of the product
PRODUCT_VOLUME DOUBLE Y The volume of the product tested
PRODUCT_VOLUME_UNIT_CD DOUBLE N CODE SET:54 The unit of the volume for the product tested
RH_CD DOUBLE N Description of the Rh value.
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.
VALID_FROM_DT_TM DATETIME N Contains the Beginning Point of when this row is valid.
VALID_UNTIL_DT_TM DATETIME N Contains the "End Point" of when this row is valid.



Relationship Detail - CE_PRODUCT


Child Column in CE_PRODUCT(FK) Parent Table Name Parent Column Name
Parents: PRODUCT_ID PRODUCT PRODUCT_ID


CE_PRODUCT_ANTIGEN



Column Section Top of Page


Table-level Detail

Description: ce product antigen
Definition: ce product antigen
Table Type: ACTIVITY





Column Detail - CE_PRODUCT_ANTIGEN


Column Name Type Null? Definition
ANTIGEN_CD DOUBLE N Code to describe the antigen
ATTRIBUTE_IND DOUBLE Y 1 indicates an attribute and 0 indicates an antigen
EVENT_ID DOUBLE N Foreign key to the clinical event table.
PROD_ANT_SEQ_NBR DOUBLE N Sequence number to make the primary key unique when there is more than one antigen for a single product.
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.
VALID_FROM_DT_TM DATETIME N Contains the Beginning Point of when this row is valid.
VALID_UNTIL_DT_TM DATETIME N Contains the End Point of when this row is valid.


CE_RESULT_SET_LINK



Column Section Top of Page


Table-level Detail

Description: Clinical Event Result Set Link
Definition: Link Table that has grouping between clinical events and result sets
Table Type: ACTIVITY





Column Detail - CE_RESULT_SET_LINK


Column Name Type Null? Definition
ENTRY_TYPE_CD DOUBLE N CODESET: 255431Would have values indicating whether the row came from task completion service, PowerForms etc.
EVENT_ID DOUBLE N Key to clinical_event table Logical relation to EVENT_ID in CE, which is related to CE_EVENT_ID.
RELATION_TYPE_CD DOUBLE N Describes the relationship between clinical events that belong to the same result set.
RESULT_SET_ID DOUBLE N Sequence Name: RESULT_SET_SEQ. A Result Set will be defined as a group of results that can only be grouped based on a parameter not definable in the reference database or needs to be set in the activity database.
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.
VALID_FROM_DT_TM DATETIME N Creation date for row.
VALID_UNTIL_DT_TM DATETIME N Date row becomes historical.


CE_RTE_PRSNL_RELTN



Column Section Relationship Section Top of Page


Table-level Detail

Description: Clinical Event Results To Endorsement Personnel Relation
Definition: Stores the provider information to whom notifications are sent for RTE.
Table Type: ACTIVITY





Column Detail - CE_RTE_PRSNL_RELTN


Column Name Type Null? Definition
ACTION_PRSNL_ID DOUBLE N The personnel who carried out the action.
CE_EVENT_ACTION_ID DOUBLE N The clinical event action that this notification was sent for.
CE_RTE_PRSNL_RELTN_ID DOUBLE N Unique generated number that identifies a single row on the CE_RTE_PRSNL_RELTN table.
RELTN_TYPE_CD DOUBLE N This defines the relationship between person and provider. Example: Attending Provider. CodeSet: 331 or 333.
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 - CE_RTE_PRSNL_RELTN


Child Column in CE_RTE_PRSNL_RELTN(FK) Parent Table Name Parent Column Name
Parents: CE_EVENT_ACTION_ID CE_EVENT_ACTION CE_EVENT_ACTION_ID
ACTION_PRSNL_ID PRSNL PERSON_ID


CE_SPECIMEN_COLL



Column Section Relationship Section Top of Page


Table-level Detail

Description: ce specimen coll
Definition: The ce_specimen_coll table contains information abouit the physical specimen upon which an event was performed. A specimen record can only be associated with a root event. For a group event, all detail events must be on the same specimen.
Table Type: ACTIVITY





Column Detail - CE_SPECIMEN_COLL


Column Name Type Null? Definition
BODY_SITE_CD DOUBLE N Body location where the collection was done (left arm, right thumb, etc.).
COLLECT_DT_TM DATETIME N Date and time of the collection.
COLLECT_LOC_CD DOUBLE N Patient¿s location when the specimen was collected.
COLLECT_METHOD_CD DOUBLE N Collection method (venous, arterial, etc.) (Is this the same as code set 2053 ¿ Collection Route?)
COLLECT_PRIORITY_CD DOUBLE N Collection priority.
COLLECT_PRSNL_ID DOUBLE N Identification number of the clinician who collected the specimen.
COLLECT_TZ DOUBLE Y Time zone associated with the corresponding DT_TM column.
COLLECT_UNIT_CD DOUBLE N Unit code of the collection volume.
COLLECT_VOLUME DOUBLE N Collection volume and unit specify the amount of collection
CONTAINER_ID DOUBLE N Foreign key to Container Table.
CONTAINER_TYPE_CD DOUBLE N Type of container (purple top, red top, AP pail, etc.).
DANGER_CD DOUBLE N Code or text indicating any known or suspected patient or specimen hazards.
EVENT_ID DOUBLE N Foreign key to the Event Table.
POSITIVE_IND DOUBLE N Foreign key to the Event Table.
RECVD_DT_TM DATETIME Y The date and time the specimen is received into the lab that will be processing it.
RECVD_TZ DOUBLE Y The time zone of the user who received the specimen in the lab that will be processing it.
SOURCE_TEXT VARCHAR(255) Y Free-text source.
SOURCE_TYPE_CD DOUBLE N Source of collection (blood, sputum, stool, etc.)
SPECIMEN_ID DOUBLE N Foreign key to Specimen Table. Foreign Key: XFK2 - (v500 specimen)
SPECIMEN_STATUS_CD DOUBLE N Status of the specimen (collected, transfer, received, etc.).
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.
VALID_FROM_DT_TM DATETIME N Contains the "Beginning Point" of when a row in the table is valid.
VALID_UNTIL_DT_TM DATETIME N Contains the "End Point" of when a row in the table is valid. Current version of the result has an open "Until Dt Tm" value. We need to determine what that value is.



Relationship Detail - CE_SPECIMEN_COLL


Child Column in CE_SPECIMEN_COLL(FK) Parent Table Name Parent Column Name
Parents: COLLECT_PRSNL_ID PRSNL PERSON_ID
SPECIMEN_ID V500_SPECIMEN SPECIMEN_ID