Table Detail Report

RAD_VETTING_HOLD_DETAIL



Column Section Relationship Section Top of Page


Table-level Detail

Description: RadNet Vetting Hold Detail
Definition: Contains the vetting hold details added while holding the order.
Table Type: ACTIVITY





Column Detail - RAD_VETTING_HOLD_DETAIL


Column Name Type Null? Definition
HOLD_COMMENT_TXT VARCHAR(512) Y Comments added while holding the order.
LAST_UPDT_DT_TM DATETIME N Last time the row was updated.
LAST_UPDT_PRSNL_ID DOUBLE N The person that last updated this row.
LAST_UPDT_TZ DOUBLE N The time zone of the last update date.
ORDER_ID DOUBLE N The Radnet order of the vetting held order.
ORIG_HOLD_DT_TM DATETIME N The date of the original vetting hold.
ORIG_HOLD_PRSNL_ID DOUBLE N The personnel that originally held the vetting.
ORIG_HOLD_TZ DOUBLE N The time zone of the original hold date.
PROXY_HOLD_PRSNL_ID DOUBLE N The person who edits the vetting hold comments on behalf of original vetting hold personnel.
RAD_VETTING_HOLD_DETAIL_ID DOUBLE N Unique generated number that identifies a single row on the RAD_VETTING_HOLD_DETAIL 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 - RAD_VETTING_HOLD_DETAIL


Child Column in RAD_VETTING_HOLD_DETAIL(FK) Parent Table Name Parent Column Name
Parents: ORDER_ID ORDER_RADIOLOGY ORDER_ID
LAST_UPDT_PRSNL_ID PRSNL PERSON_ID
ORIG_HOLD_PRSNL_ID PRSNL PERSON_ID
PROXY_HOLD_PRSNL_ID PRSNL PERSON_ID


RAD_VETTING_HOLD_LOCK



Column Section Relationship Section Top of Page


Table-level Detail

Description: Radiology vetting hold lock
Definition: This table is similar to rad_rpt_lock, will contain lock information when users adding vetting hold information.
Table Type: ACTIVITY





Column Detail - RAD_VETTING_HOLD_LOCK


Column Name Type Null? Definition
HOLD_LOCK_DT_TM DATETIME Y When lock is added while saving vetting hold information, corresponding date/time is captured in this column
HOLD_LOCK_PRSNL_ID DOUBLE N Contains vetting hold lock personnel ID, who holds the lock
ORDER_ID DOUBLE N Primary key value from the ORDERS table (Foreign Key),
RAD_VETTING_HOLD_LOCK_ID DOUBLE N Primary Key on this 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 - RAD_VETTING_HOLD_LOCK


Child Column in RAD_VETTING_HOLD_LOCK(FK) Parent Table Name Parent Column Name
Parents: ORDER_ID ORDERS ORDER_ID
HOLD_LOCK_PRSNL_ID PRSNL PERSON_ID


RAD_WRKLST_COL_CHOICE



Column Section Relationship Section Top of Page


Table-level Detail

Description: Radiology Worklist Column Choice
Definition: This table defines the columns that a personnel has chosen to appear on all their worklists.
Table Type: REFERENCE





Column Detail - RAD_WRKLST_COL_CHOICE


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.
ACTIVE_STATUS_CD DOUBLE N Indicates the status of the row itself (not the data in the row) such as active, inactive, combined away, pending purge, etc.
ACTIVE_STATUS_DT_TM DATETIME Y The date and time that the active_status_cd was set.
ACTIVE_STATUS_PRSNL_ID DOUBLE N The person who caused the active_status_cd to be set or change.
ATTRIBUTE_CD DOUBLE N The column that a person has chosen to be on their worklist view.
PRSNL_ID DOUBLE N The personnel who is defining the column as a choice.
RAD_WRKLST_COL_CHOICE_ID DOUBLE N Unique, generated number that identifies a single row on the RAD_WRKLIST_COL_CHOICE table.
SEQ_NBR DOUBLE N Defines the order in which the columns are displayed to the user.
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.
WRKLST_TYPE_CD DOUBLE N The type of worklist the column will be a choice for.



Relationship Detail - RAD_WRKLST_COL_CHOICE


Child Column in RAD_WRKLST_COL_CHOICE(FK) Parent Table Name Parent Column Name
Parents: PRSNL_ID PRSNL PERSON_ID


RAD_WRKLST_CRIT



Column Section Relationship Section Top of Page


Table-level Detail

Description: Radiology Worklist Criteria
Definition: This table models the criteria of a radiologists' reading worklist.
Table Type: REFERENCE





Column Detail - RAD_WRKLST_CRIT


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.
CRITERIA_CD DOUBLE N The criteria that was specifically selected to be included or excluded on a worklist.
INCLUDE_IND DOUBLE N Used to indicate if the criteria values should be included or excluded.
RAD_WRKLST_CRIT_ID DOUBLE N Unique generated number that identifies a single row on the RAD_WRKLST_CRIT table.
RAD_WRKLST_DEF_ID DOUBLE N The radiology worklist that this criteria applies to.
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 - RAD_WRKLST_CRIT


Child Column in RAD_WRKLST_CRIT(FK) Parent Table Name Parent Column Name
Parents: RAD_WRKLST_DEF_ID RAD_WRKLST_DEF RAD_WRKLST_DEF_ID




Parent Column in RAD_WRKLST_CRIT (PK) Child Table Name Child Column Name
Children: RAD_WRKLST_CRIT_ID RAD_WRKLST_CRIT_VAL RAD_WRKLST_CRIT_ID


RAD_WRKLST_CRIT_VAL



Column Section Relationship Section Top of Page


Table-level Detail

Description: Radiology Worklist Criteria Value
Definition: This table models the criteria element values of a radiologists reading worklist.
Table Type: REFERENCE





Column Detail - RAD_WRKLST_CRIT_VAL


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.
ACTIVE_STATUS_CD DOUBLE N Indicates the status of the row itself (not the data in the row) such as active, inactive, combined away, pending purge, etc.
ACTIVE_STATUS_DT_TM DATETIME N The date and time that the active_status_cd was set.
ACTIVE_STATUS_PRSNL_ID DOUBLE N The person who caused the active_status_cd to be set or change.
END_OFFSET_QTY DOUBLE Y The end offset for a range type value
END_OFFSET_UNIT_CD DOUBLE N The end offset unit identifier for a range type value
PARENT_ENTITY_ID DOUBLE N The ID of the parent table row associated to the criteria value.
PARENT_ENTITY_NAME VARCHAR(30) N This is the name of the parent table where the value in parent_entity_id originates.
RAD_WRKLST_CRIT_ID DOUBLE N Identifies the criteria the value is associated with.
RAD_WRKLST_CRIT_VAL_ID DOUBLE N Unique, generated number that identifies a single row on the RAD_WRKLST_CRIT_VAL table.
START_OFFSET_QTY DOUBLE Y The start offset for a range type value
START_OFFSET_UNIT_CD DOUBLE N The start offset unit identifier for a range type value
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 - RAD_WRKLST_CRIT_VAL


Child Column in RAD_WRKLST_CRIT_VAL(FK) Parent Table Name Parent Column Name
Parents: RAD_WRKLST_CRIT_ID RAD_WRKLST_CRIT RAD_WRKLST_CRIT_ID