Table Detail Report

RAD_PRIOR_PREFS



Column Section Relationship Section Top of Page


Table-level Detail

Description: RadNet Prior Preferences
Definition: Stores the number of relevant priors to retrieve and the look-back range per modality as specified by a user.
Table Type: REFERENCE





Column Detail - RAD_PRIOR_PREFS


Column Name Type Null? Definition
ACTIVITY_SUBTYPE_CD DOUBLE N Stores the code value for the activity sub-type that is used to filter order catalog items within activity type. Radiology modality.
LOOKBACK_RANGE_UOM_CD DOUBLE N The measure of the date range in lookback_range_value.
LOOKBACK_RANGE_VALUE DOUBLE N Date range for relevant priors to qualify. A value of zero denotes that the entire history should be considered.
PRIOR_DISPLAY_QTY DOUBLE N Maximum number of relevant priors to display.
PRSNL_ID DOUBLE N The personnel that these preferences are set for.
RAD_PRIOR_PREFS_ID DOUBLE N Unique generated number that identifies a single row on the RAD_PRIOR_PREFS 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_PRIOR_PREFS


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


RAD_PROCEDURE_ASSOC



Column Section Relationship Section Top of Page


Table-level Detail

Description: Rad Procedure Associations
Definition: The Rad_Procedure_Assoc table contain the procedures that exist within a procedure grouping.
Table Type: REFERENCE





Column Detail - RAD_PROCEDURE_ASSOC


Column Name Type Null? Definition
ASSESSMENT_RECOMMENDATION_FLAG DOUBLE N Indicates if Assessment is Required(1), Optional(2) or Not Allowed (3)
CATALOG_CD DOUBLE N The Catalog_Cd is a foreign key to the Order_Catalog table. This identifies the procedure is a part of the procedure group.
EXCLUDE_FROM_AUDIT_FLAG DOUBLE N Indicates if cases containing this procedure should be Excluded(1) from or Included(2) in audit calculations
INDICATION_FOR_EXAM_ID DOUBLE N Reason the exam is required for this procedure.
MANAGEMENT_FLAG DOUBLE N Indicates if a recommendation is Required(1), Optional(2) or Not Allowed (3)
NOTIFICATION_LETTER_FLAG DOUBLE N Indicates if Notification Letter is Required(1) or Optional(2)
NO_FOLLOW_UP_FLAG DOUBLE N Indicates if No Follow-up is Required(1), Optional(2) or Not Allowed (3).
PROC_GROUP_ID DOUBLE N The Proc_Group_Id is a foreign key to the Rad_Procedure_Assoc table. This uniquely identifies the procedure group.
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_PROCEDURE_ASSOC


Child Column in RAD_PROCEDURE_ASSOC(FK) Parent Table Name Parent Column Name
Parents: CATALOG_CD ORDER_CATALOG CATALOG_CD
INDICATION_FOR_EXAM_ID RAD_FOL_UP_FIELD FOLLOW_UP_FIELD_ID
PROC_GROUP_ID RAD_PROCEDURE_GROUP PROC_GROUP_ID


RAD_PROCEDURE_GROUP



Column Section Relationship Section Top of Page


Table-level Detail

Description: Rad Procedure Group
Definition: The Rad_Procedure_Group table contains general information about a procedure group. A procedure group is a way to group procedures together for replacement purposes.
Table Type: REFERENCE





Column Detail - RAD_PROCEDURE_GROUP


Column Name Type Null? Definition
ACTIVE_IND DOUBLE Y 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.
GROUP_DESC VARCHAR(50) Y The Group_Desc is the description of the procedure grouping.
GROUP_TYPE_CD DOUBLE N This column contains a code value to designate the type of grouping for the procedures. This allow application to distinguish the group defined for relevant priors or just groupings of procedures for other purposes such as Mammo group.
PROC_GROUP_ID DOUBLE N The Proc_Group_Id uniquely identifies a row in the Rad_Procedure_Group table. It serves no other purpose other than to uniquely identify the row.
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_PROCEDURE_GROUP




Parent Column in RAD_PROCEDURE_GROUP (PK) Child Table Name Child Column Name
Children: PROC_GROUP_ID RAD_FOLLOW_UP_CONTROL PROC_GROUP_ID
RAD_PROCEDURE_ASSOC PROC_GROUP_ID


RAD_PROTOCOL_CATALOG_R



Column Section Relationship Section Top of Page


Table-level Detail

Description: RadNet Protocol Catalog Relation
Definition: Stores the relationship between protocols and the procedures they may be used for in specific exam rooms.
Table Type: REFERENCE





Column Detail - RAD_PROTOCOL_CATALOG_R


Column Name Type Null? Definition
CATALOG_CD DOUBLE N The orderable that pertains to a specific protocol.
DEFAULT_IND DOUBLE N Indicates that this is the default Protocol for this combination of Orderable and Service Resource.
RAD_PROTOCOL_CATALOG_R_ID DOUBLE N Unique, generated number that identifies a single row on the RAD_PROTOCOL_CATALOG_R table.
RAD_PROTOCOL_DEFINITION_ID DOUBLE N The protocol that pertains to a specific radiology orderable.
SERVICE_RESOURCE_CD DOUBLE N The Service Resource for this orderable/protocol combination. Usually denotes a room.
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_PROTOCOL_CATALOG_R


Child Column in RAD_PROTOCOL_CATALOG_R(FK) Parent Table Name Parent Column Name
Parents: RAD_PROTOCOL_DEFINITION_ID RAD_PROTOCOL_DEFINITION RAD_PROTOCOL_DEFINITION_ID
CATALOG_CD SERVICE_DIRECTORY CATALOG_CD
SERVICE_RESOURCE_CD SERVICE_RESOURCE SERVICE_RESOURCE_CD


RAD_PROTOCOL_CONFIG



Column Section Relationship Section Top of Page


Table-level Detail

Description: RadNet Protocol Configuration
Definition: Contains the procedures which are protocolled information for a given facility.
Table Type: REFERENCE





Column Detail - RAD_PROTOCOL_CONFIG


Column Name Type Null? Definition
FACILITY_CD DOUBLE N Facility that this protocol configuration applies to.
OPTION_FLAG DOUBLE N Holds the protocol option for a procedure and for a given facility.
PROCEDURE_CD DOUBLE N The procedure that is for this facility.
RAD_PROTOCOL_CONFIG_ID DOUBLE N Unique generated number that identifies a single row on the RAD_PROTOCOL_CONFIG 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_PROTOCOL_CONFIG


Child Column in RAD_PROTOCOL_CONFIG(FK) Parent Table Name Parent Column Name
Parents: FACILITY_CD LOCATION LOCATION_CD
PROCEDURE_CD ORDER_CATALOG CATALOG_CD