Table Detail Report

MAMMO_PROBLEM



Column Section Relationship Section Top of Page


Table-level Detail

Description: Mammography Problem
Definition: Problems reported as reason for mammogram.
Table Type: ACTIVITY





Column Detail - MAMMO_PROBLEM


Column Name Type Null? Definition
PROBLEM_ID DOUBLE N The problem reported as reason for mammogram. This is a foreign key to the Rad_Fol_Up_Field table.
STUDY_ID DOUBLE N This column uniquely identifies the study that the problem is related to.
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 - MAMMO_PROBLEM


Child Column in MAMMO_PROBLEM(FK) Parent Table Name Parent Column Name
Parents: STUDY_ID MAMMO_STUDY STUDY_ID
PROBLEM_ID RAD_FOL_UP_FIELD FOLLOW_UP_FIELD_ID


MAMMO_RECOMMEND_SEQ



Column Section Relationship Section Top of Page


Table-level Detail

Description: Secondary recommendations
Definition: Table stores secondary recommendations for a study whose primary info is on the mammo_study table.
Table Type: ACTIVITY





Column Detail - MAMMO_RECOMMEND_SEQ


Column Name Type Null? Definition
RECOMMENDATION_ID DOUBLE N The Radiologist's recommendation for follow-up (ACR). This is a foreign key to the Rad_Fol_Up_Field table. Choices depend on Assessment_Id
SEQUENCE DOUBLE N Holds the sequence of recommendations selected for each study_id
STUDY_ID DOUBLE N References a study_id from the mammo_study 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 - MAMMO_RECOMMEND_SEQ


Child Column in MAMMO_RECOMMEND_SEQ(FK) Parent Table Name Parent Column Name
Parents: STUDY_ID MAMMO_STUDY STUDY_ID
RECOMMENDATION_ID RAD_FOL_UP_FIELD FOLLOW_UP_FIELD_ID


MAMMO_RECOMMEND_SERIES



Column Section Relationship Section Top of Page


Table-level Detail

Description: mammo_recommend_seq
Definition: Holds secondary recommendations for a mammo study
Table Type: ACTIVITY





Column Detail - MAMMO_RECOMMEND_SERIES


Column Name Type Null? Definition
RECOMMENDATION_ID DOUBLE N Foreign key to rad_fol_up_field table, holds the recommendations for a given assessment series
SEQUENCE DOUBLE N Sequence of recommendations for a given assessment series
SERIES_ID DOUBLE N Foreign key to mammo_Assessment_series table
SERIES_INSTANCE_NBR DOUBLE N This is the column that contains the instance number for all the ASSESSMENT_IDs added for a particular series instance.
STUDY_ID DOUBLE N Foreign key to the mammo_study 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 - MAMMO_RECOMMEND_SERIES


Child Column in MAMMO_RECOMMEND_SERIES(FK) Parent Table Name Parent Column Name
Parents: SERIES_ID MAMMO_ASSESSMENT_SERIES SERIES_ID
STUDY_ID MAMMO_STUDY STUDY_ID
RECOMMENDATION_ID RAD_FOL_UP_FIELD FOLLOW_UP_FIELD_ID


MAMMO_RISK



Column Section Relationship Section Top of Page


Table-level Detail

Description: Mammography Risk
Definition: Mammography cancer risk factors
Table Type: ACTIVITY





Column Detail - MAMMO_RISK


Column Name Type Null? Definition
FACTOR_ID DOUBLE N This column identifies the risk factor for the study. This is a foreign key to the Rad_Fol_Up_Field table.
STUDY_ID DOUBLE N This column identifies the mammo study that the risk factor is a part of.
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 - MAMMO_RISK


Child Column in MAMMO_RISK(FK) Parent Table Name Parent Column Name
Parents: STUDY_ID MAMMO_STUDY STUDY_ID
FACTOR_ID RAD_FOL_UP_FIELD FOLLOW_UP_FIELD_ID


MAMMO_STUDY



Column Section Relationship Section Top of Page


Table-level Detail

Description: Mammography Study
Definition: Master record for Mammography follow up case.
Table Type: ACTIVITY





Column Detail - MAMMO_STUDY


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.
ASSESSMENT_ID DOUBLE N The Radiologist's case assessment. This is a foreign key to the Rad_Fol_Up_Field table.
CATALOG_CD DOUBLE N Identifies the mammography procedure
CONTRIBUTOR_SYSTEM_CD DOUBLE N Contributor system identifies the source feed of data from which a row was populated. This is mainly used to determine how to update a set of data that may have originated from more than one source feed.
DATA_CAPTURE_FLAG DOUBLE N tell whether the examination is done at the combination level or component level.0 = Default, 1 = Combination level, 2 = Component level
DOWNLOAD_IND DOUBLE Y This column indicates whether or not the study has been previously downloaded for the acr birads national mammography database. A 1 indicates that it has been downloaded.
EDITION_NBR DOUBLE N This column stores the ACR BI-RADS edition that the study falls under. 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.
ENCNTR_ID DOUBLE N This is the value of the unique primary identifier of the encounter table. It is an internal system assigned number.
EXCLUDE_FROM_AUDIT_IND DOUBLE N Indicates if case should be excluded from audit statistics
GROUP_REFERENCE_NBR VARCHAR(40) Y This is used along with the contributor_system_cd to uniquely identify the report that corresponds with this case.
INCLUDE_BREAST_DENSITY_IND DOUBLE Y This column will contain value of include breast density statement indicator value, as saved by user in Mammo case maintenance. If this is set to Yes, then the breast density statement set for the selected facility in breast_density_text in Rad_Config_Data table will be printed in mammo notification letters. If this is set to No or blank, then the set breast density statement will not be printed in the mammo notification letters.
LATERALITY_AUDIT_FLAG DOUBLE N tells whether the exam is being done at the separate breast level or at the patient level. 0 = Default, 1 = Patient level assessment, 2 = Separate breast level assessment.
LETTER_ID DOUBLE N This is the Letter Id of the letter currently assigned to the study
MAMMO_IMAGING_FLAG DOUBLE N Indicates how the facility defines standard screeningmammography images
MAPPED_ACTIVITY_SUBTYPE_CD DOUBLE N Indicates which modality the particular study belongs to.
NO_FOL_UP_REQ_IND DOUBLE Y If this field is 1, a follow up is not required. If it is 0 or NULL then a follow up is required.
ORDER_ID DOUBLE N This is a foreign key to the Order Radiology table. It identifies the order that the follow-up case is related to.
PERSON_ID DOUBLE N This is the value of the unique primary identifier of the person table. It is an internal system assigned number.
REASON_ID DOUBLE N Reason for the Mammography procedure. This is a foreign key to the Rad_Fol_Up_Field table.
RECALL_INTERVAL DOUBLE Y The recall interval in months
RECOMMENDATION_ID DOUBLE N The Radiologist's recommendation for follow-up (ACR). This is a foreign key to the Rad_Fol_Up_Field table. Choices depend on Assessment_Id
REPRINT_IND DOUBLE N This column is used to identify whether the study should be included for reprint when we run the ops job for the patient notification letter. Mainly used for linked exams. 0 - do not reprint. 1 - reprint.
SEQ_EXAM_ID DOUBLE N In the case of historical uploads, this field will be filled out with the seq_exam_id of the exam (exam_data) that the mammo data was uploaded with. If the study was not uploaded this will remain Null
STAT_CAT_FLAG DOUBLE Y This column stores the statistical category flag for the study.
STAT_CAT_ID DOUBLE N the Cases statistical category. This is a foreign key to the Rad_Fol_Up_Field table.
STUDY_DT_TM DATETIME Y The date and time that the mammogram was performed.
STUDY_ID DOUBLE N This column serves as a unique identifier for the row. It is meaningless other than to uniquely identify the row.
STUDY_TZ DOUBLE Y Time zone associated with the corresponding DT_TM column.
SUBSECTION_CD DOUBLE N Subsection in which the exam was performed
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.
US_IMAGING_FLAG DOUBLE N Indicates whether the facility defines standard screeningultrasound images .



Relationship Detail - MAMMO_STUDY


Child Column in MAMMO_STUDY(FK) Parent Table Name Parent Column Name
Parents: ENCNTR_ID ENCOUNTER ENCNTR_ID
SEQ_EXAM_ID EXAM_DATA SEQ_EXAM_ID
LETTER_ID MAMMO_LETTER LETTER_ID
ORDER_ID ORDER_RADIOLOGY ORDER_ID
PERSON_ID PERSON PERSON_ID
ASSESSMENT_ID RAD_FOL_UP_FIELD FOLLOW_UP_FIELD_ID
REASON_ID RAD_FOL_UP_FIELD FOLLOW_UP_FIELD_ID
RECOMMENDATION_ID RAD_FOL_UP_FIELD FOLLOW_UP_FIELD_ID
STAT_CAT_ID RAD_FOL_UP_FIELD FOLLOW_UP_FIELD_ID
SUBSECTION_CD SERVICE_RESOURCE SERVICE_RESOURCE_CD




Parent Column in MAMMO_STUDY (PK) Child Table Name Child Column Name
Children: STUDY_ID MAMMO_ASSESSMENT_SERIES STUDY_ID
MAMMO_BREAST_FIND STUDY_ID
MAMMO_FOLLOW_UP STUDY_ID
MAMMO_NOTIFICATION STUDY_ID
MAMMO_NOTIFICATION_HIST STUDY_ID
MAMMO_PROBLEM STUDY_ID
MAMMO_RECOMMEND_SEQ STUDY_ID
MAMMO_RECOMMEND_SERIES STUDY_ID
MAMMO_RISK STUDY_ID
MAMMO_STUDY_PRSNL STUDY_ID
MAMMO_USER_DEF STUDY_ID
RAD_MAMMO_STUDY_ASSESS_MGMT_R STUDY_ID
RAD_OMF_MAMMO STUDY_ID
RAD_OMF_MAMMO_DETAILS STUDY_ID
RAD_OMF_MAMMO_FIND STUDY_ID