Table Detail Report

MAMMO_STUDY_PRSNL



Column Section Relationship Section Top of Page


Table-level Detail

Description: Mammography Study Personnel
Definition: Radiology personnel associated with the study.
Table Type: ACTIVITY





Column Detail - MAMMO_STUDY_PRSNL


Column Name Type Null? Definition
PHYSICIAN_IDENTIFIER_FLAG DOUBLE N As part of BIRADs 5.0 Enhancements, a mammo study can have information on more than one radiologist. This is called double read physicians. This column indicates the role played.
PRSNL_ID DOUBLE N This identifies the personnel that was involved with the case. This is a foreign key to the Prsnl table.
PRSNL_RELATION_FLAG DOUBLE N Identifies the role that the personnel had in regards to the case.
STUDY_ID DOUBLE N This identifies the study that the personnel are associated with.
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_STUDY_PRSNL


Child Column in MAMMO_STUDY_PRSNL(FK) Parent Table Name Parent Column Name
Parents: STUDY_ID MAMMO_STUDY STUDY_ID
PRSNL_ID PRSNL PERSON_ID


MAMMO_USER_DEF



Column Section Relationship Section Top of Page


Table-level Detail

Description: Mammography User Defined
Definition: User defined detail information about the mammo study
Table Type: ACTIVITY





Column Detail - MAMMO_USER_DEF


Column Name Type Null? Definition
FIELD_ID DOUBLE Y Identifies the follow-up field that is being valued. This is a foreign key to the Rad_Fol_Up_Field table.
NUMERIC_VALUE DOUBLE Y If the field is a numeric field this is the value assigned by the user.
STUDY_ID DOUBLE Y This identifies the study that the field values are a part of.
TEXT_VALUE VARCHAR(255) Y If the field is textual, this is the text 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.
USER_VALUE_ID DOUBLE N This is meaningless number that is only used to uniquely identify the row.
VALUE_DT_TM DATETIME Y If the field is a date/time, this is the date and time that has been assigned by the user.
VALUE_TZ DOUBLE Y Time zone associated with the corresponding DT_TM column.



Relationship Detail - MAMMO_USER_DEF


Child Column in MAMMO_USER_DEF(FK) Parent Table Name Parent Column Name
Parents: STUDY_ID MAMMO_STUDY STUDY_ID
FIELD_ID RAD_FOL_UP_FIELD FOLLOW_UP_FIELD_ID


RAD_FOLLOW_UP_CONTROL



Column Section Relationship Section Top of Page


Table-level Detail

Description: Rad Follow Up Control
Definition: The Rad_Follow_Up_Control table contains general information about patient follow up.
Table Type: REFERENCE





Column Detail - RAD_FOLLOW_UP_CONTROL


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.
ADVANCE_PRINT_INTERVAL DOUBLE Y The Advance_Print_Interval indicates how many days in advance that the follow up letter should be sent.
ALLOW_SUPPRESS_NOTIFY_LETT_IND DOUBLE N Indicates if a user can suppress patient notification letters from printing.
ASSESSMENT_4_DEFAULT_INTERVAL DOUBLE Y Stores the default recall interval in months for studies with Assessment 4. A value of -1 indicates "Now".
ASSESSMENT_5_DEFAULT_INTERVAL DOUBLE Y Stores the default recall interval in months for studies with Assessment 5. A value of -1 indicates "Now".
AUDIT_REPORT_TYPE_FLAG DOUBLE N The audit report type set in the domain
COMPLETE_FOLLOW_UP_IND DOUBLE Y This column indicates whether radiology exam management does mammography follow-up processing
DAYS_BEFORE_SURVEY DOUBLE N Sets the number of days after the study date that the physician survey letter would qualify to print.
DAYS_BEFORE_WARNING DOUBLE Y Number of days after recall date at which to send OVERDUE warning
DAYS_BETWEEN_WARNING DOUBLE Y If repeated warnings are sent, number of days between warnings
DUAL_BREAST_DENSITY_STMT_IND DOUBLE N If 1, indicates that separate density statements will be used for dense and non-dense breast types.
FOLLOW_UP_CONTROL_ID DOUBLE N This column serves as the primary key. It serves no other purpose other than to uniquely identify a row.
MAMMO_TAG_LTR_IND DOUBLE Y The determining factor if the mammography letters were defined using the tagging tool.
MAX_WARNING_LETTER_PRINTS DOUBLE N Sets the maximum number of times that a patient or physician warning letter will be printed.
NO_FOL_UP_REQ_DEFAULT_IND DOUBLE N No longer used.
ONLINE_BREAST_DIAGRAM_IND DOUBLE N If 1, indicates that online breast diagram will be used for all mammography exams ordered from that point forward.
PRINT_MAMMO_HDR_IND DOUBLE N If this indicator is 1 then the Facility information will print on the mammography letters, if it is 0 then it won't. The default is 1.
PROC_GROUP_ID DOUBLE N Identifies the mammography procedure group that is to be used for follow up
SIGNOUT_FOLLOW_UP_IND DOUBLE Y No longer used.
TRANS_FOLLOW_UP_IND DOUBLE Y The Signout_Follow_Up_Ind indicates if follow up information should be captured from the transcription application.
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 - RAD_FOLLOW_UP_CONTROL


Child Column in RAD_FOLLOW_UP_CONTROL(FK) Parent Table Name Parent Column Name
Parents: PROC_GROUP_ID RAD_PROCEDURE_GROUP PROC_GROUP_ID




Parent Column in RAD_FOLLOW_UP_CONTROL (PK) Child Table Name Child Column Name
Children: FOLLOW_UP_CONTROL_ID RAD_FOLLOW_UP_DEFAULT FOLLOW_UP_CONTROL_ID
RAD_FOLLOW_UP_PRINT_CTRL FOLLOW_UP_CONTROL_ID


RAD_FOLLOW_UP_DEFAULT



Column Section Relationship Section Top of Page


Table-level Detail

Description: Radnet Follow Up Default
Definition: This table contains default information regarding mammography follow up letters.
Table Type: REFERENCE





Column Detail - RAD_FOLLOW_UP_DEFAULT


Column Name Type Null? Definition
FOLLOW_UP_CONTROL_ID DOUBLE N This column serves as a foreign key to the Rad_Follow_Up_Control table. It identifies the follow-up system control entry that this is a part of.
FOLLOW_UP_DEFAULT_TYPE_CD DOUBLE Y Identifies the type of the follow-up letter that is being set up.
SEQUENCE DOUBLE N Indicates the order in which to send the letters
TEMPLATE_ID DOUBLE Y The Template_Id serves as a foreign key to the wp_template table. It uniquely identifies the template that is to be used for the letter.
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_DEFAULT


Child Column in RAD_FOLLOW_UP_DEFAULT(FK) Parent Table Name Parent Column Name
Parents: FOLLOW_UP_CONTROL_ID RAD_FOLLOW_UP_CONTROL FOLLOW_UP_CONTROL_ID
TEMPLATE_ID WP_TEMPLATE TEMPLATE_ID


RAD_FOLLOW_UP_PRINT_CTRL



Column Section Relationship Section Top of Page


Table-level Detail

Description: Radiology Follow Up Print Control
Definition: RadNet Mammography letter printer control
Table Type: REFERENCE





Column Detail - RAD_FOLLOW_UP_PRINT_CTRL


Column Name Type Null? Definition
DEPARTMENT_CD DOUBLE Y Department code for which printer is assigned
FOLLOW_UP_CONTROL_ID DOUBLE Y This serves as a foreign key to the Rad_Follow_Up_Control table. It uniquely identifies the follow-up system control that the printer control is a part of.
FOLLOW_UP_DEFAULT_TYPE_CD DOUBLE Y Identifies the type of follow-up letter that is involved.
FOLLOW_UP_PRINT_CTRL_ID DOUBLE N The Follow_Up_Print_Ctrl_Id serves as a primary key for the rad_follow_up_print_ctrl table. It serves no other purpose other than to uniquely identify the row.
SECTION_CD DOUBLE Y Section code for which printer is assigned
SEQUENCE DOUBLE Y Letter sequence that corresponds to Sequence on Rad_Follow_Up_Default. It identifies the order in which the letters should be sent.
SUBSECTION_CD DOUBLE Y The Subsection code for which the printer is assigned
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_PRINT_CTRL


Child Column in RAD_FOLLOW_UP_PRINT_CTRL(FK) Parent Table Name Parent Column Name
Parents: FOLLOW_UP_CONTROL_ID RAD_FOLLOW_UP_CONTROL FOLLOW_UP_CONTROL_ID
DEPARTMENT_CD SERVICE_RESOURCE SERVICE_RESOURCE_CD
SECTION_CD SERVICE_RESOURCE SERVICE_RESOURCE_CD
SUBSECTION_CD SERVICE_RESOURCE SERVICE_RESOURCE_CD