Table Detail Report

RAD_OMF_MAMMO_FIND



Column Section Relationship Section Top of Page


Table-level Detail

Description: This Table contains mammography finding summary data for PowerVision.
Definition: RadNet OMF Mammography Finding
Table Type: ACTIVITY





Column Detail - RAD_OMF_MAMMO_FIND


Column Name Type Null? Definition
FIND_ID DOUBLE N This is the primary key of the table. It is also the foreign key to the mammo_find table.
STUDY_ID DOUBLE N This is the 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 - RAD_OMF_MAMMO_FIND


Child Column in RAD_OMF_MAMMO_FIND(FK) Parent Table Name Parent Column Name
Parents: FIND_ID MAMMO_FIND FIND_ID
STUDY_ID MAMMO_STUDY STUDY_ID


RAD_OMF_MAMMO_FIND_DETAILS



Column Section Relationship Section Top of Page


Table-level Detail

Description: This table contains finding summary data for mammography PowerVision reports.
Definition: RadNet OMF Mammography Finding Details
Table Type: ACTIVITY





Column Detail - RAD_OMF_MAMMO_FIND_DETAILS


Column Name Type Null? Definition
CERNER_MEANING_STR VARCHAR(25) Y This column corresponds to the Cerner_meaning_str column on the rad_fol_up_field table. It uniquely identifies a field between ACR BI-RADS edtions.
FIELD_DESCRIPTION VARCHAR(255) Y This is the field description corresponding to the field description on the rad_fol_up_field table.
FIND_ID DOUBLE N This is the foreign key to both the rad_omf_mammo_find table and the mammo_find table.
FOLLOW_UP_FIELD_ID DOUBLE N This is the foreign key to the rad_fol_up_field table
MAMMO_FIND_ID DOUBLE N This it the primary key to the table.
NUMERIC_VALUE DOUBLE N This is the field that holds numeric summary data.
PARENT1_MEANING_STR VARCHAR(25) Y This is the parent meaning string for the Cerner meaning string on any given row.
PARENT2_MEANING_STR VARCHAR(25) Y This is the second parent meaning string for the Cerner meaning string on any given row. It is also the parent of parent 1 meaning string.
PARENT3_MEANING_STR VARCHAR(25) Y This is the third parent meaning string for the Cerner meaning string on any given row. It is also the parent of parent 2 meaning string.
PARENT4_MEANING_STR VARCHAR(25) Y This is the forth parent meaning string for the Cerner meaning string on any given row. It is also the parent of parent 3 meaning string.
TEXT_VALUE VARCHAR(255) Y This field holds string summary data.
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 This field holds date/time summary data.
VALUE_TZ DOUBLE Y Time zone associated with the corresponding DT_TM column.



Relationship Detail - RAD_OMF_MAMMO_FIND_DETAILS


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


RAD_OMF_MAMMO_USER_DEF



Column Section Top of Page


Table-level Detail

Description: This table holds abstract field for use with Mammo PV user defined fields.
Definition: Rad OMF Mammo User Defined
Table Type: REFERENCE





Column Detail - RAD_OMF_MAMMO_USER_DEF


Column Name Type Null? Definition
BEG_EFFECTIVE_DT_TM DATETIME N The date and time for which this table row becomes effective. Normally, this will be the date and time the row is added, but could be a past or future date and time.
CD_COLUMN VARCHAR(50) N This is a unique identifier for the mammography follow up fields. It corresponds to the Cerner_meaning_str column on rad_omf_mammo_details and rad_omf_mammo_find_details.
DISP_COLUMN VARCHAR(50) N This is the description that displays for a field.
END_EFFECTIVE_DT_TM DATETIME N The date/time after which the row is no longer valid as active current data. This may be valued with the date that the row became inactive.
FACT_IND DOUBLE N This is an indicator signifying whether or not a field is a FACT.
INDICATOR_CD DOUBLE N This is the foreign key to the omf_indicator table.
OMF_FACT_IND DOUBLE Y This is an indicator signifying whether or not a field is a fact.
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.


RAD_OMF_TC_INDICATOR



Column Section Relationship Section Top of Page


Table-level Detail

Description: Radiology OMF Tech Comments Indicators
Definition: This table acts as both an abstract table for tech comments omf indicators and as a reference table to build the indicators.
Table Type: REFERENCE





Column Detail - RAD_OMF_TC_INDICATOR


Column Name Type Null? Definition
BEG_EFFECTIVE_DT_TM DATETIME N The date and time for which this table row becomes effective. Normally, this will be the date and time the row is added, but could be a past or future date and time.
CD_COLUMN VARCHAR(50) N This field is a string version of indicator_cd that powervision will look at when reading an abstract table.
DISP_COLUMN VARCHAR(50) N This is the description of the indicator as seen by the user in PowerVision.
END_EFFECTIVE_DT_TM DATETIME Y The date/time after which the row is no longer valid as active current data. This may be valued with the date that the row became inactive.
FACT_IND DOUBLE N This is an indicator signifying whether or not a field is a fact.
FIELD_ID DOUBLE N This is a foreign key to and the unique identifier of the rad_tech_field table.
FIELD_TYPE_FLAG DOUBLE N This field defines what data type the filter searches. 0 = Header, 1 = Number, 2 = Text, 3 = Date
INDICATOR_CD DOUBLE N The unique identifier for a row on this table.
OMF_FACT_IND DOUBLE Y This is an indicator signifying whether or not a field is a fact.
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_OMF_TC_INDICATOR


Child Column in RAD_OMF_TC_INDICATOR(FK) Parent Table Name Parent Column Name
Parents: INDICATOR_CD CODE_VALUE CODE_VALUE
FIELD_ID RAD_TECH_FIELD FIELD_ID


RAD_OMF_TC_IND_R



Column Section Relationship Section Top of Page


Table-level Detail

Description: Radiology OMF Tech Comments Indicator Relation
Definition: Reference table containing the parent child hierarchy relationships for tech comments indicator fields
Table Type: REFERENCE





Column Detail - RAD_OMF_TC_IND_R


Column Name Type Null? Definition
FIELD_SEQ DOUBLE N This field contains the sequence at which a given parent_field_id resides in the hierarchy of parents_field_ids.
INDICATOR_CD DOUBLE N This is a foreign key to the omf_indicator table.
PARENT_FIELD_ID DOUBLE N This field contains the id of a tech comment field which is defined as a parent for the indicators field_id.
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_OMF_TC_IND_R


Child Column in RAD_OMF_TC_IND_R(FK) Parent Table Name Parent Column Name
Parents: PARENT_FIELD_ID RAD_TECH_FIELD FIELD_ID