MAMMO_ASSESSMENT_SERIES



Column Section Relationship Section Top of Page


Table-level Detail

Description: Mammography Assessment Series
Definition: Table stores series information for mammography procedures that have been addended.
Table Type: ACTIVITY





Column Detail - MAMMO_ASSESSMENT_SERIES


Column Name Type Null? Definition
ASSESSMENT_ID DOUBLE N The Radiologist's assessment for follow-up (ACR). This is a foreign key to the Rad_Fol_Up_Field table.
ASSIGNED_DT_TM DATETIME N Assigned date and time of the series.
FOLLOW_UP_PROC_CD DOUBLE N The mammography follow up procedure for this instance of a series.
LETTER_ID DOUBLE N This is the letter_id for the mammo letter currently tied to this series.
RAD_ID DOUBLE N Radiologist ID whom signed out an instance of a series
RECALL_INTERVAL DOUBLE N The Recall Interval for the mammography procedure in the series. From the Mammo_study table beforethe series was written.
SEQUENCE DOUBLE N Sequence of the assessment series
SERIES_ID DOUBLE N Primary key for 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.
SERIES_OPEN_IND DOUBLE Y Indicates a series has been added for a specific mammography procedure but the addended report has not been finalized
STUDY_ID DOUBLE N Foreign key to 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_ASSESSMENT_SERIES


Child Column in MAMMO_ASSESSMENT_SERIES(FK) Parent Table Name Parent Column Name
Parents: STUDY_ID MAMMO_STUDY STUDY_ID
RAD_ID PRSNL PERSON_ID
ASSESSMENT_ID RAD_FOL_UP_FIELD FOLLOW_UP_FIELD_ID




Parent Column in MAMMO_ASSESSMENT_SERIES (PK) Child Table Name Child Column Name
Children: SERIES_ID MAMMO_RECOMMEND_SERIES SERIES_ID


MAMMO_BREAST_FIND



Column Section Relationship Section Top of Page


Table-level Detail

Description: Mammography Breast Finding
Definition: Mammography case Breast findings
Table Type: ACTIVITY





Column Detail - MAMMO_BREAST_FIND


Column Name Type Null? Definition
BREAST_COMP_ID DOUBLE N This identifies the breast composition. This is a foreign key to the Rad_Fol_Up_Field table.
BREAST_FIND_ID DOUBLE N This is a meaningless number that is used only to uniquely identify the row.
CHANGES_ID DOUBLE N Not Used
PARENT_BREAST_FIND_ID DOUBLE N Parent study's breast find id when the procedures are associated
PRIOR_SURG_FOL_UP_ID DOUBLE N Not Used
SIDE_ID DOUBLE N Identifies the breast(s) that the finding is related to.
STUDY_ID DOUBLE N This identifies the study that the findings are for.
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.



Relationship Detail - MAMMO_BREAST_FIND


Child Column in MAMMO_BREAST_FIND(FK) Parent Table Name Parent Column Name
Parents: PARENT_BREAST_FIND_ID MAMMO_BREAST_FIND BREAST_FIND_ID
STUDY_ID MAMMO_STUDY STUDY_ID
BREAST_COMP_ID RAD_FOL_UP_FIELD FOLLOW_UP_FIELD_ID
CHANGES_ID RAD_FOL_UP_FIELD FOLLOW_UP_FIELD_ID
PRIOR_SURG_FOL_UP_ID RAD_FOL_UP_FIELD FOLLOW_UP_FIELD_ID
SIDE_ID RAD_FOL_UP_FIELD FOLLOW_UP_FIELD_ID




Parent Column in MAMMO_BREAST_FIND (PK) Child Table Name Child Column Name
Children: BREAST_FIND_ID MAMMO_BREAST_FIND PARENT_BREAST_FIND_ID
MAMMO_FIND BREAST_FIND_ID


MAMMO_FIND



Column Section Relationship Section Top of Page


Table-level Detail

Description: Mammography Findings
Definition: Mammography Case Findings
Table Type: ACTIVITY





Column Detail - MAMMO_FIND


Column Name Type Null? Definition
BREAST_FIND_ID DOUBLE N This identifies the breast findings related to the mammogram. This is a foreign key to the Mammo_Breast_Find table.
FIND_ID DOUBLE N This is a meaningless number used only to uniquely identify the row.
LESION_CLASS_ID DOUBLE N This column identifies the lesion class. This is a foreign key to the Rad_Fol_Up_Field table.
PARENT_MAMMO_FIND_ID DOUBLE N This is used to group the different findings and store the same finding data for that group
PATH_ID DOUBLE N This column identifies the pathology code used for ACR. This is a foreign key to the Rad_Fol_Up_Field table.
SCD_TERM_ID DOUBLE N The designated terminology that maps to this finding.
SEQUENCE DOUBLE Y This is used to sequence the findings.
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.



Relationship Detail - MAMMO_FIND


Child Column in MAMMO_FIND(FK) Parent Table Name Parent Column Name
Parents: BREAST_FIND_ID MAMMO_BREAST_FIND BREAST_FIND_ID
PARENT_MAMMO_FIND_ID MAMMO_FIND FIND_ID
LESION_CLASS_ID RAD_FOL_UP_FIELD FOLLOW_UP_FIELD_ID
PATH_ID RAD_FOL_UP_FIELD FOLLOW_UP_FIELD_ID
SCD_TERM_ID SCD_TERM SCD_TERM_ID




Parent Column in MAMMO_FIND (PK) Child Table Name Child Column Name
Children: FIND_ID MAMMO_FIND PARENT_MAMMO_FIND_ID
MAMMO_FIND_DETAIL FIND_ID
RAD_OMF_MAMMO_FIND FIND_ID
RAD_OMF_MAMMO_FIND_DETAILS FIND_ID


MAMMO_FIND_DETAIL



Column Section Relationship Section Top of Page


Table-level Detail

Description: Mammography Finding Detail
Definition: This table stores the details of the mammography findings.
Table Type: ACTIVITY





Column Detail - MAMMO_FIND_DETAIL


Column Name Type Null? Definition
FIELD_ID DOUBLE N This identifies the follow-up field that is being valued.
FIND_DETAIL_ID DOUBLE N This is a meaningless number that is used to uniquely identify the row.
FIND_ID DOUBLE N This identifies the finding that this detail information is a part of.
NUMERIC_VALUE DOUBLE Y if the field is numeric, then this is the value assigned by the user.
TEXT_VALUE VARCHAR(255) Y if the field is textual, this is the text that was assigned by the user.
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_DT_TM DATETIME Y If the field is a date/time, then this is the date and time that the user assigned.
VALUE_TZ DOUBLE Y Time zone associated with the corresponding DT_TM column.



Relationship Detail - MAMMO_FIND_DETAIL


Child Column in MAMMO_FIND_DETAIL(FK) Parent Table Name Parent Column Name
Parents: FIND_ID MAMMO_FIND FIND_ID
FIELD_ID RAD_FOL_UP_FIELD FOLLOW_UP_FIELD_ID


MAMMO_FOLLOW_UP



Column Section Relationship Section Top of Page


Table-level Detail

Description: Mammography Follow Up
Definition: Contains information regarding the follow-up for a mammography case.
Table Type: ACTIVITY





Column Detail - MAMMO_FOLLOW_UP


Column Name Type Null? Definition
CASE_STATUS_CD DOUBLE Y Identifies the current status of the case follow-up.
CATALOG_CD DOUBLE Y This identifies the follow-up procedure to be done.
RECALL_DT_TM DATETIME Y The Recall_Dt_Tm column identifies when the follow-up procedure should be performed.
STUDY_ID DOUBLE N This column identifies the study that the follow-up has been defined for.
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.



Relationship Detail - MAMMO_FOLLOW_UP


Child Column in MAMMO_FOLLOW_UP(FK) Parent Table Name Parent Column Name
Parents: STUDY_ID MAMMO_STUDY STUDY_ID
CATALOG_CD ORDER_CATALOG CATALOG_CD