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 |