Table Detail Report

PROP_COMMENT



Column Section Top of Page


Table-level Detail

Description: Contains the comments for PROP orders.
Definition: Comments for PROP orders.
Table Type: ACTIVITY





Column Detail - PROP_COMMENT


Column Name Type Null? Definition
COMMENT_TYPE_CD DOUBLE N Comment type code for the order.
LONG_TEXT_ID DOUBLE N Long Text Identifier
ORDER_ID DOUBLE N Unique number that ties the order laboratory row to the orders tables.
PROP_ID DOUBLE N The identifier of the row in the table.
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.


PROP_DETAIL



Column Section Top of Page


Table-level Detail

Description: Contains the order details for PROP orders.
Definition: Order details for PROP Orders.
Table Type: ACTIVITY





Column Detail - PROP_DETAIL


Column Name Type Null? Definition
DETAIL_SEQUENCE DOUBLE N The sequence of the order details.
FIELD_SEQUENCE DOUBLE Y A sequence number identifying the order of all the fields that have been grouped together using the group sequence.
GROUP_SEQUENCE DOUBLE Y A sequence number used to identify the ordering of fields on the format.
MODIFIED_IND DOUBLE Y Determines if the field was modified during order entry.
OE_FIELD_DISPLAY_VALUE VARCHAR(255) Y The display value of the order detail.
OE_FIELD_DT_TM_VALUE DATETIME Y The date and time value of the field if of type date/time.
OE_FIELD_ID DOUBLE N The id of the field.
OE_FIELD_MEANING VARCHAR(25) Y The meaning of the field.
OE_FIELD_MEANING_ID DOUBLE N The Cerner controlled value that id's the meaning of the field.
OE_FIELD_VALUE DOUBLE Y The value of the field if a numeric or coded value.
ORDER_ID DOUBLE N The id of the order.
PROP_ID DOUBLE N The identifier of the row in the prop_queue table
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.
VALUE_REQUIRED_IND DOUBLE Y An indicator on whether the field has to have a value entered.


PROP_ORDER



Column Section Relationship Section Top of Page


Table-level Detail

Description: Contains the order infomation for PROP orders.
Definition: Order information for PROP orders.
Table Type: ACTIVITY





Column Detail - PROP_ORDER


Column Name Type Null? Definition
ACCESSION VARCHAR(20) Y The accession for the order.
ACCESSION_ID DOUBLE N The identifier of the accession for the order.
ACTION_FLAG DOUBLE N Indicates the processing the PathNet Result Order Posting Server will perform.
APPLICATION_CD DOUBLE N Identifies the application placing the order.
APPLICATION_FLAG DOUBLE Y Order application specific flag whose value is determined by the client application.
CATALOG_CD DOUBLE N The catalog code of the orderable.
COLLECTION_LIST_ID DOUBLE N The identifier of the collection list, if the order is associated with one.
COLLECTION_METHOD_CD DOUBLE N The collection method of the order.
COMMENT_FLAG DOUBLE Y Indicates that comments exist on the prop_comment table.
COMMUNICATION_TYPE_CD DOUBLE N The code value identifying the communication type of the order.
CONTRIBUTOR_SYSTEM_CD DOUBLE N Contributor system identifies the source feed of data from which a row was populated. This is mainly used to determine how to update a set of data that may have originated from more than one source feed.
CS_FLAG DOUBLE Y This flag indicates whether this order is a parent or member of a CareSet.
CS_ITEMS DOUBLE Y Indicates the number of CareSet child rows for a CareSet parent.
CS_ORDER_ID DOUBLE N Parent Order ID of a CareSet child.
DEFAULT_DT_TM DATETIME Y The date and time the PathNet Result Order Posting server defaults for order details. This is the date and time from the PC.
DETAIL_FLAG DOUBLE Y Indicates that order details exist on the prop_detail table.
ENCNTR_ID DOUBLE N This is the value of the unique primary identifier of the encounter table. It is an internal system assigned number.
LABEL_FILE_PREFIX VARCHAR(5) Y The file prefix used to identify a label file.
LABEL_PRINTER_ID DOUBLE N The output destination for the labels.
ORDER_DT_TM DATETIME Y The date and time the order was placed.
ORDER_ID DOUBLE N Unique number that ties the order laboratory row to the orders tables.
ORDER_LOCATION_CD DOUBLE N The location where the order was placed.
ORDER_MNEMONIC VARCHAR(100) Y The primary or HNA order mnemonic for this orderable.
ORDER_PROVIDER_ID DOUBLE N The ID of the ordering provider.
PERSONNEL_ID DOUBLE N The ID of the personnel that generated the action.
PERSON_ID DOUBLE N This is the value of the unique primary identifier of the person table. It is an internal system assigned number.
PREVIOUS_ACTION_FLAG DOUBLE Y The previous action that was performed for this order.
PROP_ID DOUBLE N The identifier of the row in the table.
RECEIVED_LOCATION_CD DOUBLE N The received location of the specimen.
RESULT_FLAG DOUBLE Y Indicates the result exists on the prop_result table.
SERVICE_RESOURCE_CD DOUBLE N The service resource to which the order loaded.
SPECIMEN_TYPE_CD DOUBLE N The specimen type of the order.
START_DT_TM DATETIME Y The start date and time for the order.
STATUS_FLAG DOUBLE Y The status of the action flag
SYNONYM_ID DOUBLE N Id of the synonym for this order.
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.
VERIFY_FLAG DOUBLE Y Indicates that the order needs to verified before it is placed in the system.



Relationship Detail - PROP_ORDER


Child Column in PROP_ORDER(FK) Parent Table Name Parent Column Name
Parents: ACCESSION_ID ACCESSION ACCESSION_ID
COLLECTION_LIST_ID COLLECTION_LIST COLLECTION_LIST_ID
ENCNTR_ID ENCOUNTER ENCNTR_ID
CS_ORDER_ID ORDERS ORDER_ID
ORDER_ID ORDERS ORDER_ID
SYNONYM_ID ORDER_CATALOG_SYNONYM SYNONYM_ID
LABEL_PRINTER_ID OUTPUT_DEST OUTPUT_DEST_CD
PERSON_ID PERSON PERSON_ID
PROP_ID PROP_ACTION PROP_ID


PROP_RESULT



Column Section Relationship Section Top of Page


Table-level Detail

Description: Contains the result information for PROP orders.
Definition: Result information for PROP orders.
Table Type: ACTIVITY





Column Detail - PROP_RESULT


Column Name Type Null? Definition
CRITICAL_CD DOUBLE N Defines whether the result is a critical value.
CRITICAL_HIGH DOUBLE Y The defined high value the result is checked against to define when a result critical value is high. The result must be greater than the critical high to be flagged as high.
CRITICAL_LOW DOUBLE Y The defined low value the result is checked against to define when a result value is critical low. The result must be less than the normal low to be flagged as critical low.
CRITICAL_RANGE_FLAG DOUBLE Y Determines if a critical range has been defined.
DELTA_CD DOUBLE N Defines whether the result value has passed or failed a delta check.
FEASIBLE_CD DOUBLE N Describes whether a result has passed or failed feasible result ranges.
INTERFACE_FLAG DOUBLE Y Indicates how the result was entered into the table.
LESS_GREAT_FLAG DOUBLE Y Defines whether the result value should be viewed qualitatively with a < or > sign.
LINEAR_CD DOUBLE N Indicates whether a result has failed linear ranges.
MAX_DIGITS DOUBLE Y Maximum digits for a result.
MIN_DECIMAL_PLACES DOUBLE Y Minimum number of decimal places for a result.
MIN_DIGITS DOUBLE Y Minimum digits for a result.
NOMENCLATURE_ID DOUBLE N Defines the nomenclature selected for an alpha response. This is a unique, internal identification for nomenclature.
NORMAL_ALPHA VARCHAR(200) Y Defines the normal alpha response for a procedure with the result type of alpha.
NORMAL_CD DOUBLE N Defines the result to be normal, low, or high based on the result value as compared to the reference ranges. Designates if the ranges have been checked or not.
NORMAL_HIGH DOUBLE Y The defined high value the result is checked against to define when a result value is high. The result must be greater than the normal high to be flagged as high.
NORMAL_LOW DOUBLE Y The defined low value the result is checked against to define when a result value is low. The result must be less than the normal low to be flagged as low.
NORMAL_RANGE_FLAG DOUBLE Y Indicates if a critical range has been defined.
NOTIFY_CD DOUBLE N Indicates the notify flag is applied to this result value.
ORDER_ID DOUBLE N The identifier of the order.
PROMPT_TEST_IND DOUBLE Y Indicates that the result is a prompt test.
QC_OVERRIDE_CD DOUBLE Y A code value that identifies if the user has chosen to override the quality control validation when posting this result to the system.
REFERENCE_RANGE_FACTOR_ID DOUBLE N Used to store the ID value from REFERENCE_RANGE_FACTOR
RESOURCE_ERROR_CODES VARCHAR(255) Y Stores the error codes sent by an automated instrument while processing a result.
RESULT_ALPHA VARCHAR(200) Y Stores the alpha value text of an alpha procedure.
RESULT_COMMENT_ID DOUBLE N A unique internal system assigned number that identifies a result comment text. Creates a relationship with the long text table.
RESULT_DISPLAY_VALUE VARCHAR(255) Y The result display value.
RESULT_DT_TM DATETIME Y The date and time fhe result was performed by the user. This applies to all types of results.
RESULT_DT_TM_VALUE DATETIME Y The date and time the result was performed. This is populated only with the result value of data and time for procedures that are date/time result types.
RESULT_NOTE_ID DOUBLE N A unique internal system assigned number that identifies a result note text. Creates a relationship with the long text table.
RESULT_PERSONNEL_ID DOUBLE N Identifies the person responsible for the result.
RESULT_STATUS_CD DOUBLE N Indicates the status of the result, such as performed or verified.
RESULT_TYPE_CD DOUBLE N Indicates the type of result.
RESULT_TYPE_FLAG DOUBLE Y Indicates the type of result for prompt tests.
RESULT_VALUE DOUBLE N The discrete result value.
REVIEW_CD DOUBLE N Defines whether a result has been flagged for review. Also denotes whether the review ranges have been applied.
STATUS_FLAG DOUBLE Y The status of the result processing.
TASK_ASSAY_CD DOUBLE N The task assay code of the detail test.
UNITS_CD DOUBLE N Defines the units of measure for interpreting the result value for the procedure.
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 - PROP_RESULT


Child Column in PROP_RESULT(FK) Parent Table Name Parent Column Name
Parents: NOMENCLATURE_ID NOMENCLATURE NOMENCLATURE_ID
ORDER_ID ORDERS ORDER_ID
REFERENCE_RANGE_FACTOR_ID REFERENCE_RANGE_FACTOR REFERENCE_RANGE_FACTOR_ID


SPEC_LBL_PRINTER_DEF



Column Section Relationship Section Top of Page


Table-level Detail

Description: Specimen Label Printer Default
Definition: This table stores the default label printers for nurse units, ambulatory locations and clinics. When 'immediate print' Lab orders come across an HIS interface, this table tells the system where to print the collection labels.
Table Type: REFERENCE





Column Detail - SPEC_LBL_PRINTER_DEF


Column Name Type Null? Definition
COLLECTION_CLASS_CD DOUBLE N A collection class which will route labels to a printer based on the orderables collection class. Not implemented at this time.
COLL_PRIORITY_CD DOUBLE N A collection priority which will route labels to a printer if an order is placed with the given collection priority.
KEY_ID DOUBLE N A unique identifier for a row.
LBL_PRINTER_ID DOUBLE N The system identifier for a label printer any orders meeting the criteria will print to.
LBL_PRINT_QUEUE VARCHAR(20) Y The queue name for the label printer.
LOCATION_CD DOUBLE N An ambulatory, clinic, or nurse unit which will route labels to a printer if an order is placed on a patient is at the given location.
NURSE_COLLECT_IND DOUBLE Y An indicator that will route labels to a printer based on if the order is flagged as a nurse collect.
NURSE_COLL_LBL_PRINTER_ID DOUBLE N The system identifier for a label printer any orders meeting the criteria will print too.
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 - SPEC_LBL_PRINTER_DEF


Child Column in SPEC_LBL_PRINTER_DEF(FK) Parent Table Name Parent Column Name
Parents: LOCATION_CD LOCATION LOCATION_CD