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 |