Table Detail Report

RAD_FOLLOW_UP_RECALL



Column Section Relationship Section Top of Page


Table-level Detail

Description: Rad Follow Up Recall
Definition: The Rad_Follow_Up_Recall table contains patient follow up information specific to when the patient should return. This information is by procedure.
Table Type: REFERENCE





Column Detail - RAD_FOLLOW_UP_RECALL


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.
BEGINNING_AGE_RANGE DOUBLE N The Beginning_Age_Range contains the starting age for the age range that is to be used to determine follow up recall.
CATALOG_CD DOUBLE N The Catalog_Cd is a foreign key to the Order_Catalog table. It identifies the procedure that follow up rules are being established for.
ENDING_AGE_RANGE DOUBLE Y The Ending_Age_Range contains the ending age for the age range that is to be used to determine follow up recall.
RECALL_INTERVAL DOUBLE Y The Recall_Interval indicates the amount of time before the patient needs to return.
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_FOLLOW_UP_RECALL


Child Column in RAD_FOLLOW_UP_RECALL(FK) Parent Table Name Parent Column Name
Parents: CATALOG_CD ORDER_CATALOG CATALOG_CD


RAD_FOL_UP_CONTROL_SECT



Column Section Relationship Section Top of Page


Table-level Detail

Description: RadNet Follow Up Control by Section
Definition: Stores the general settings for patient follow-up that are section specific.
Table Type: REFERENCE





Column Detail - RAD_FOL_UP_CONTROL_SECT


Column Name Type Null? Definition
ADVANCE_PRINT_DAYS DOUBLE Y The number of days in advance that the follow-up letter should be sent.
ASSESS_3_DFLT_INTERVAL_MONTHS DOUBLE Y Stores the default recall interval in months for studies with Assessment 3. A value of -1 indicates "Now".
ASSESS_4_DFLT_INTERVAL_MONTHS DOUBLE Y Stores the default recall interval in months for studies with Assessment 4. A value of -1 indicates "Now".
ASSESS_5_DFLT_INTERVAL_MONTHS DOUBLE Y Stores the default recall interval in months for studies with Assessment 5. A value of -1 indicates "Now".
ASSESS_6_DFLT_INTERVAL_MONTHS DOUBLE Y Stores the default recall interval in months for studies with Assessment 6. A value of -1 indicates "Now".
BREAST_DENSITY_STMT_IND DOUBLE Y This column will save the responses to "Require breast density statement selection before signing the report" question in follow-up tools. Responses are saved at section level. Possible response values are Yes / No / empty string which is also the default response selected for this question.Planning to store these values as 2 (Yes), 1 (No), 0 (empty string)
INITIAL_WARNING_DAYS DOUBLE Y Number of days after recall date at which to send an OVERDUE warning.
MAX_WARNING_LETTER_PRINT_NBR DOUBLE Y The maximum number of times that a patient or physician warning letter will be printed.
RAD_FOL_UP_CONTROL_SECT_ID DOUBLE N Unique, generated number that identifies a single row on the RAD_FOL_UP_CONTROL_SECT table.
SERVICE_RESOURCE_CD DOUBLE N Location for which this follow up control section has been customized.
SURVEY_ELAPSED_DAYS DOUBLE Y The number of days after the study date that the physician survey letter would qualify to print.
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.
WARNING_INTERVAL_DAYS DOUBLE Y If repeated warnings are sent, the number of days between warnings.



Relationship Detail - RAD_FOL_UP_CONTROL_SECT


Child Column in RAD_FOL_UP_CONTROL_SECT(FK) Parent Table Name Parent Column Name
Parents: SERVICE_RESOURCE_CD SERVICE_RESOURCE SERVICE_RESOURCE_CD


RAD_FOL_UP_FIELD



Column Section Relationship Section Top of Page


Table-level Detail

Description: Rad Follow Up Field
Definition: The Rad_Fol_Up_Field table contains fields used for classification of a performed exam.
Table Type: REFERENCE





Column Detail - RAD_FOL_UP_FIELD


Column Name Type Null? Definition
ACR_CODED_FIELD VARCHAR(10) Y The BI-RADS code that corresponds with this field.
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.
BIRAD_GROUP_TXT VARCHAR(25) Y Used to define which birad group the nmd_group_code_nbr applies to.
CERNER_MEANING_STR VARCHAR(25) Y This column contains a unique string that can be used by Cerner applications.
EDITION_NBR DOUBLE Y This column indicates what ACR edition the follow up field is a part of. Edition 2 and edition 3 do not have decimal precision and will be assumed to mean 2.0 and 3.0. Starting with edition 3.1, the edition number appearing in the column on the table will be assumed to have a single decimal precision. In other words, edition 3.1 will be appear as 31 on the table.
FIELD_DESCRIPTION VARCHAR(255) Y The Field_Description is a textual description for a follow up field.
FIELD_TYPE_FLAG DOUBLE Y The Field_Type_Flag indicates if if the follow up field is a numeric entry or a coded value.
FOLLOW_UP_FIELD_ID DOUBLE N The Follow_Up_Field_Id uniquely identifies a row in the Rad_Fol_Up_Field table. It serves no otherpurpose other than to uniquely identify the row.
HISTFORM_PRINT_IND DOUBLE N A table row may be printed on the mammography patient history form. A value of 1 indicates that this row will be printed whereas any other value will cause the row not to print on the history form.
MODALITY_TYPE_FLAG DOUBLE N Indicates the type of modality group.
MODIFY_FLAG DOUBLE Y The Modify_Flag indicates if the follow up field is a standard field vs. a user defined field.It also indicates if a field is required and if it is modifiable or not.
MORE_COMPLETE_AUDIT_IND DOUBLE N Indicates if this field participates in the More Complete audit report generation. 0 = does not participate, 1 = does participate
NMD_GROUP_CODE_TXT VARCHAR(5) N Identifies the standard NMD code for this field.
PARENT_ID DOUBLE N This column is used to facilitate the hierarchy among the fields. It is a foreign key to the Rad_Fol_Up_Field table.
RANGE_MAX DOUBLE Y The Range_Max field contains the maximum value of a range that is specified for a numeric response.
RANGE_MIN DOUBLE Y The Range_Min field contains the minimum value of a range that is specified for a numeric response.
REFERENCE_CD DOUBLE N The Reference_Cd field provides a way to assign follow up fields to groups according to where they appear in the conversation.
SEQUENCE DOUBLE Y The sequence identifies the order in which the field is to be displayed in mammography case maintenance.
SPECIAL_PROCESS_FLAG DOUBLE Y Special processing flag used by case maintenance
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_FOL_UP_FIELD


Child Column in RAD_FOL_UP_FIELD(FK) Parent Table Name Parent Column Name
Parents: PARENT_ID RAD_FOL_UP_FIELD FOLLOW_UP_FIELD_ID




Parent Column in RAD_FOL_UP_FIELD (PK) Child Table Name Child Column Name
Children: FOLLOW_UP_FIELD_ID MAMMO_ASSESSMENT_SERIES ASSESSMENT_ID
MAMMO_BREAST_FIND BREAST_COMP_ID
MAMMO_BREAST_FIND CHANGES_ID
MAMMO_BREAST_FIND PRIOR_SURG_FOL_UP_ID
MAMMO_BREAST_FIND SIDE_ID
MAMMO_FIND LESION_CLASS_ID
MAMMO_FIND PATH_ID
MAMMO_FIND_DETAIL FIELD_ID
MAMMO_LETTER RECOMMENDATION_ID
MAMMO_PROBLEM PROBLEM_ID
MAMMO_RECOMMEND_SEQ RECOMMENDATION_ID
MAMMO_RECOMMEND_SERIES RECOMMENDATION_ID
MAMMO_RISK FACTOR_ID
MAMMO_STUDY ASSESSMENT_ID
MAMMO_STUDY REASON_ID
MAMMO_STUDY RECOMMENDATION_ID
MAMMO_STUDY STAT_CAT_ID
MAMMO_USER_DEF FIELD_ID
RAD_FOL_UP_FIELD PARENT_ID
RAD_MAMMO_LETTER_MGMT_R FOLLOW_UP_FIELD_ID
RAD_MAMMO_STUDY_ASSESS_MGMT_R FOLLOW_UP_FIELD_ID
RAD_OMF_MAMMO_DETAILS FOLLOW_UP_FIELD_ID
RAD_OMF_MAMMO_FIND_DETAILS FOLLOW_UP_FIELD_ID
RAD_PROCEDURE_ASSOC INDICATION_FOR_EXAM_ID
RAD_TEMPLATE_GROUP ASSESSMENT_ID
RAD_TEMPLATE_GROUP RECOMMENDATION_ID


RAD_FOL_UP_FIELD_VALUES



Column Section Top of Page


Table-level Detail

Description: Rad Follow Up Field Values
Definition: The Rad_Fol_Up_Field_Values table contains valid values for the follow up fields used for classification.
Table Type: ACTIVITY





Column Detail - RAD_FOL_UP_FIELD_VALUES


Column Name Type Null? Definition
ACR_CODED_FIELD CHAR(10) Y The ACR_Coded_Field contains a code that is supplied by the American College of Radiology. This code is downloaded with the data and returned to the ACR. Certain fields are required by the ACR.
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.
FOLLOW_UP_FIELD_ID DOUBLE Y The Follow_Up_Field_Id serves as a foreign key to the Rad_Fol_Up_Field table. It identifies the follow up field that this value is associated with.
FOLLOW_UP_VALUE_ID DOUBLE N The Follow_Up_Value_Id uniquely identifies a row in the Rad_Fol_Up_Field_Values table. It serves no other purpose other than to uniquely identify the row.
MODIFY_IND DOUBLE Y The Modify_Ind indicates if the follow up field value is modifiable or not. Certain fields and field values are required by the ACR.
SEQUENCE DOUBLE Y The Sequence indicates the order that the field values should appear in a list.
SUB_FIELD_ID DOUBLE Y The Sub_Field_Id serves as a foreign key to the Rad_Fol_Up_Field table. It identifies another field that is related to this specific value.
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.
VALUE_DESCRIPTION VARCHAR(255) Y The Value_Description contains the actual textual response that can be chosen from a list.


RAD_MAMMO_LETTER_MGMT_R



Column Section Relationship Section Top of Page


Table-level Detail

Description: RadNet Mammography Letter Management Relation
Definition: Links a Mammo Letter with the patient recommendation (Management) steps that relate to it.
Table Type: REFERENCE





Column Detail - RAD_MAMMO_LETTER_MGMT_R


Column Name Type Null? Definition
FOLLOW_UP_FIELD_ID DOUBLE N The recommendations to the patient based on the assessment done.
LETTER_ID DOUBLE N The MAMMO_LETTER that this management information pertains to.
RAD_MAMMO_LETTER_MGMT_R_ID DOUBLE N Unique, generated number that identifies a single row on the RAD_MAMMO_LETTER_MGMT_R 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_MAMMO_LETTER_MGMT_R


Child Column in RAD_MAMMO_LETTER_MGMT_R(FK) Parent Table Name Parent Column Name
Parents: LETTER_ID MAMMO_LETTER LETTER_ID
FOLLOW_UP_FIELD_ID RAD_FOL_UP_FIELD FOLLOW_UP_FIELD_ID