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 |