Table Detail Report

RX_FORMULA_RANGE



Column Section Relationship Section Top of Page


Table-level Detail

Description: PharmNet Formula Range
Definition: Stores criteria information used for selecting formulas
Table Type: REFERENCE





Column Detail - RX_FORMULA_RANGE


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.
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.
DEMOG_TYPE_FLAG DOUBLE N Flag for determining what type of demographic is stored on this row (age, weight, height, serum creatinine, result )
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.
ETHNICITY_CD DOUBLE N The ethnicity that this formula pertains to.
GENDER_CD DOUBLE N The gender that this formula pertains to.
MAX_VALUE DOUBLE Y The maximum value for the formula.
MIN_VALUE DOUBLE Y The minimum value for the formula.
OPERATOR_FLAG DOUBLE N Indicates which mathematical operator is stored on this row. (<. between, >)
RACE_CD DOUBLE N The race that this formula pertains to.
RX_FORMULA_ID DOUBLE N The formula this range is related to.
RX_FORMULA_RANGE_ID DOUBLE N Unique generated number that identifies a single row on the RX_FORMULA_RANGE table.
RX_FORMULA_RANGE_P_ID DOUBLE N Used for groupings versions of a Formula Range.
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_UOM_CD DOUBLE N The unit code for the given values.



Relationship Detail - RX_FORMULA_RANGE


Child Column in RX_FORMULA_RANGE(FK) Parent Table Name Parent Column Name
Parents: RX_FORMULA_ID RX_FORMULA RX_FORMULA_ID
RX_FORMULA_RANGE_P_ID RX_FORMULA_RANGE RX_FORMULA_RANGE_ID




Parent Column in RX_FORMULA_RANGE (PK) Child Table Name Child Column Name
Children: RX_FORMULA_RANGE_ID RX_FORMULA_RANGE RX_FORMULA_RANGE_P_ID


RX_IMAGE



Column Section Relationship Section Top of Page


Table-level Detail

Description: Pharmacy Order Image
Definition: Stores the unique key for an image to CDI as well as the corresponding image attributes.
Table Type: ACTIVITY





Column Detail - RX_IMAGE


Column Name Type Null? Definition
ANNOTATE_IND DOUBLE N Indicates if annotations exist on the image.
CLARIFY_REASON_CD DOUBLE N The code value for the reason the image was put in a clarify status.
COMMENT_ID DOUBLE N The link to LONG_TEXT which includes comments associated to the image.
CREATE_DT_TM DATETIME N The time the image was added into the system.
CREATE_TZ DOUBLE N The time zone associated with CREATE_DT_TM.
DEVICE_CD DOUBLE N The device that was responsible for sending the image.
DEVICE_FAC_CD DOUBLE N The facility the device is located in.
DEVICE_LOC_CD DOUBLE N The location the device was located at at the time the image was sent.
DOC_EVENT_TYPE_CD DOUBLE N The type of order stored within the image.
ENCNTR_ID DOUBLE N The encounter associated with the image.
IMAGE_HANDLE_IDENTIFIER VARCHAR(255) N The unique identifier for images within the CDI data model.
IMAGE_ID DOUBLE N The unique, generated identifier for images within the Pharmacy Order Imaging data model.
LAST_ACCESS_PRSNL_ID DOUBLE N The User ID associated to the user who has last accessed the image.
PARENT_IMAGE_ID DOUBLE N The unique identifier for the parent image if this image has been merged into.
PATIENT_FAC_CD DOUBLE N The patient's facility at the time that patient was assigned to an image.
PATIENT_LOC_CD DOUBLE N The patient's location at the time the patient was assigned to an image.
RX_PRIORITY_CD DOUBLE N The priority of the order stored within the image.
STATUS_CD DOUBLE N The current status of the image.
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 - RX_IMAGE


Child Column in RX_IMAGE(FK) Parent Table Name Parent Column Name
Parents: DEVICE_CD DEVICE DEVICE_CD
ENCNTR_ID ENCOUNTER ENCNTR_ID
DEVICE_FAC_CD LOCATION LOCATION_CD
DEVICE_LOC_CD LOCATION LOCATION_CD
COMMENT_ID LONG_TEXT LONG_TEXT_ID
LAST_ACCESS_PRSNL_ID PRSNL PERSON_ID
PARENT_IMAGE_ID RX_IMAGE IMAGE_ID




Parent Column in RX_IMAGE (PK) Child Table Name Child Column Name
Children: IMAGE_ID RX_IMAGE PARENT_IMAGE_ID
RX_IMAGE_HX IMAGE_ID
RX_IMG_IMGQUE_RELTN IMAGE_ID
RX_IMG_IMGQUE_RELTN_HX IMAGE_ID


RX_IMAGE_HX



Column Section Relationship Section Top of Page


Table-level Detail

Description: Pharmacy Order Image History
Definition: Stores the status hostiry of the order as well as who changed the status and when.
Table Type: ACTIVITY





Column Detail - RX_IMAGE_HX


Column Name Type Null? Definition
ACTION_DT_TM DATETIME Y The date time that an action was taken on an image.
ACTION_TZ DOUBLE N The time zone associated with ACTION_DT_TM.
IMAGE_HX_ID DOUBLE N Unique, generated identifier for RX_IMAGE_HX.
IMAGE_ID DOUBLE N The unique identifier for images within the Pharmacy Order Imaging data model.
STATUS_CD DOUBLE N The current status of the image.
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 - RX_IMAGE_HX


Child Column in RX_IMAGE_HX(FK) Parent Table Name Parent Column Name
Parents: IMAGE_ID RX_IMAGE IMAGE_ID


RX_IMAGE_QUEUE



Column Section Relationship Section Top of Page


Table-level Detail

Description: Image Queue
Definition: The queue within PharmNet Order Imaging where orders will be faxed or scanned so that pharmacy users can begin processing.
Table Type: REFERENCE





Column Detail - RX_IMAGE_QUEUE


Column Name Type Null? Definition
IMAGE_QUEUE_CD DOUBLE N The code value of the Image Queue.
IMAGE_QUEUE_ID DOUBLE N The generated, primary key for RX_IMAGE_QUEUE.
NCLUD_CMPLTD_IMAGE_FLAG DOUBLE N Flag to indicate to include completed images in a queue.
NCLUD_DEL_IMAGE_FLAG DOUBLE N Flag to indicate to include deleted images in a given queue.
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 - RX_IMAGE_QUEUE




Parent Column in RX_IMAGE_QUEUE (PK) Child Table Name Child Column Name
Children: IMAGE_QUEUE_ID RX_IMAGE_QUEUE_LOC_RELTN IMAGE_QUEUE_ID
RX_IMAGE_QUEUE_PRSNL_RELTN IMAGE_QUEUE_ID
RX_IMG_IMGQUE_RELTN IMAGE_QUEUE_ID
RX_IMG_IMGQUE_RELTN_HX IMAGE_QUEUE_ID


RX_IMAGE_QUEUE_LOC_RELTN



Column Section Relationship Section Top of Page


Table-level Detail

Description: Image Queue Location Relation
Definition: Stores the relationship between an RX_IMAGE_QUEUE and a LOCATION.
Table Type: REFERENCE





Column Detail - RX_IMAGE_QUEUE_LOC_RELTN


Column Name Type Null? Definition
IMAGE_QUEUE_ID DOUBLE N Identifies the Queue that is involved in this Queue/Location relationship.
IMAGE_QUEUE_LOC_RELTN_ID DOUBLE N The unique identifier for the Image Queue to Location relationship.
LOCATION_CD DOUBLE N Identifies the specific LOCATION that is involved in this Image Queue to Location relationship.
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 - RX_IMAGE_QUEUE_LOC_RELTN


Child Column in RX_IMAGE_QUEUE_LOC_RELTN(FK) Parent Table Name Parent Column Name
Parents: LOCATION_CD LOCATION LOCATION_CD
IMAGE_QUEUE_ID RX_IMAGE_QUEUE IMAGE_QUEUE_ID




Parent Column in RX_IMAGE_QUEUE_LOC_RELTN (PK) Child Table Name Child Column Name
Children: IMAGE_QUEUE_LOC_RELTN_ID RX_IMAGE_QUEUE_TIME IMAGE_QUEUE_LOC_RELTN_ID