Table Detail Report

RXS_TASK_ALERT_RELTN



Column Section Relationship Section Top of Page


Table-level Detail

Description: RxStation Task Alert Relation
Definition: Stores the relationship between RxStation Alerts and RXStation Tasks.
Table Type: ACTIVITY





Column Detail - RXS_TASK_ALERT_RELTN


Column Name Type Null? Definition
RELTN_TYPE_CD DOUBLE N The type of relation between this Alert and this Task.
RXS_ALERT_ID DOUBLE N The alert associated to this Task.
RXS_LOCATION_TASK_ID DOUBLE N The task that is associated to this Alert.
RXS_TASK_ALERT_RELTN_ID DOUBLE N Unique, generated number that identifies a single row on the RXS_TASK_ALERT_RELTN table.
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 - RXS_TASK_ALERT_RELTN


Child Column in RXS_TASK_ALERT_RELTN(FK) Parent Table Name Parent Column Name
Parents: RXS_ALERT_ID RXS_ALERT RXS_ALERT_ID
RXS_LOCATION_TASK_ID RXS_LOCATION_TASK RXS_LOCATION_TASK_ID


RXS_TASK_DISPENSE_RELTN



Column Section Relationship Section Top of Page


Table-level Detail

Description: RxStation Task Dispense Relation
Definition: Describes the relationship between location tasks and patient activities.
Table Type: ACTIVITY





Column Detail - RXS_TASK_DISPENSE_RELTN


Column Name Type Null? Definition
CREATE_DT_TM DATETIME N The date and time the relationship was made.
PROD_DISPENSE_HX_ID DOUBLE N Product dispense history information for the dispense event that is related to this location task.
RELTN_TYPE_CD DOUBLE N Helps to describe the nature of this relationship.
RXS_LOCATION_TASK_ID DOUBLE N The location task that is related to this prod dispense.
RXS_TASK_DISPENSE_RELTN_ID DOUBLE N Unique generated number that identifies a single row on the RXS_TASK_DISPENSE_RELTN table.
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 - RXS_TASK_DISPENSE_RELTN


Child Column in RXS_TASK_DISPENSE_RELTN(FK) Parent Table Name Parent Column Name
Parents: RXS_LOCATION_TASK_ID RXS_LOCATION_TASK RXS_LOCATION_TASK_ID


RXS_TASK_SR_HX



Column Section Relationship Section Top of Page


Table-level Detail

Description: RxStation Task Service Resource History
Definition: Stores RxStation tasks which are sent to service resources.
Table Type: ACTIVITY





Column Detail - RXS_TASK_SR_HX


Column Name Type Null? Definition
ACTIVITY_DT_TM DATETIME N The date and time when the task was sent to the service resource.
MSG_BODY_LONG_TEXT_ID DOUBLE N The message sent to the service resource.
RXS_LOCATION_TASK_ID DOUBLE N The task which was sent to the service resource.
RXS_TASK_SR_HX_ID DOUBLE N Unique generated number that identifies a single row on the RXS_TASK_SR_HX table.
SERVICE_RESOURCE_CD DOUBLE N The foreign device destination.
STATUS_CD DOUBLE N The status of the activity.
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 - RXS_TASK_SR_HX


Child Column in RXS_TASK_SR_HX(FK) Parent Table Name Parent Column Name
Parents: MSG_BODY_LONG_TEXT_ID LONG_TEXT LONG_TEXT_ID
RXS_LOCATION_TASK_ID RXS_LOCATION_TASK RXS_LOCATION_TASK_ID
SERVICE_RESOURCE_CD SERVICE_RESOURCE SERVICE_RESOURCE_CD


RXS_VERIFICATION



Column Section Relationship Section Top of Page


Table-level Detail

Description: RxStation Verification
Definition: Stores verification events performed on RxStation entities
Table Type: ACTIVITY





Column Detail - RXS_VERIFICATION


Column Name Type Null? Definition
CREATE_DT_TM DATETIME N The date and time this row was created.
PARENT_ENTITY_ID DOUBLE N Identifier that refers to the entity that is verified
PARENT_ENTITY_NAME VARCHAR(32) N Name of the entity that is verified
RXS_VERIFICATION_ID DOUBLE N Unique generated number that identifies a single row on the rxs_verification table.
STATUS_CD DOUBLE N Verification status (e.g. success, failure, 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.
VERIFICATION_TYPE_CD DOUBLE N Verification type code (e.g. barcode scanning, authentication, etc.)
VERIFIED_BY_PRSNL_ID DOUBLE N Identifier that refers to the person that performs the verification
WORKFLOW_CD DOUBLE N Workflow in which the verification is performed



Relationship Detail - RXS_VERIFICATION


Child Column in RXS_VERIFICATION(FK) Parent Table Name Parent Column Name
Parents: VERIFIED_BY_PRSNL_ID PRSNL PERSON_ID




Parent Column in RXS_VERIFICATION (PK) Child Table Name Child Column Name
Children: RXS_VERIFICATION_ID RXS_VERIFICATION_ATTR RXS_VERIFICATION_ID


RXS_VERIFICATION_ATTR



Column Section Relationship Section Top of Page


Table-level Detail

Description: RxStation Verification Attribute
Definition: Stores verification event attributes for a verification performed on an RxStation entity
Table Type: ACTIVITY





Column Detail - RXS_VERIFICATION_ATTR


Column Name Type Null? Definition
RXS_VERIFICATION_ATTR_ID DOUBLE N Unique generated number that identifies a single row on the rxs_verification_attr table.
RXS_VERIFICATION_ID DOUBLE N The verification that this attribute pertains to.
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.
VERIFICATION_ATTR_CD DOUBLE N Code value that identifies verification attribute type. Example: Scanned Barcode
VERIFICATION_ATTR_VALUE VARCHAR(255) N The value of a verification attribute



Relationship Detail - RXS_VERIFICATION_ATTR


Child Column in RXS_VERIFICATION_ATTR(FK) Parent Table Name Parent Column Name
Parents: RXS_VERIFICATION_ID RXS_VERIFICATION RXS_VERIFICATION_ID