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 |