Table Detail Report
MAMMO_FOL_UP_LETTER_SECT
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | Mammography Follow Up Letter by Section |
Definition: | Stores the word processing template id or letter for a specific section or default. |
Table Type: | REFERENCE |
Column Detail - MAMMO_FOL_UP_LETTER_SECT
Column Name | Type | Null? | Definition |
---|---|---|---|
FOL_UP_LETTER_TYPE_CD | DOUBLE | N | This determines whether the letter is a Notification, Warning, etc. |
MAMMO_FOL_UP_LETTER_SECT_ID | DOUBLE | N | Unique, generated number that identifies a single row on the MAMMO_FOL_UP_LETTER_SECT table. |
SERVICE_RESOURCE_CD | DOUBLE | N | The location that this follow up letter has been created for. |
TEMPLATE_ID | DOUBLE | N | The template used for this follow up letter section. |
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_FOL_UP_LETTER_SECT
Child Column in MAMMO_FOL_UP_LETTER_SECT(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | SERVICE_RESOURCE_CD | SERVICE_RESOURCE | SERVICE_RESOURCE_CD |
TEMPLATE_ID | WP_TEMPLATE | TEMPLATE_ID |
MAMMO_LETTER
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | Mammography Letter |
Definition: | This table contains all of the Notification letters that can print out of Mammo |
Table Type: | REFERENCE |
Column Detail - MAMMO_LETTER
Column Name | Type | Null? | Definition |
---|---|---|---|
ACTIVE_IND | DOUBLE | N | 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. |
DEFAULT_IND | DOUBLE | N | This field determines whether or not the letter is the default letter for the specified recommendation. There should only be one letter with the default set to 1 for each recommendation. |
DESCRIPTION | VARCHAR(100) | Y | This is the Description of the Letter. |
LETTER_ID | DOUBLE | N | This is a unique meaningless number to represent each letter. |
LETTER_TYPE_FLAG | DOUBLE | N | This determines whether the letter is a Notification, Warning, etc. |
RECOMMENDATION_ID | DOUBLE | N | This is the Recommendation that a letter is associated with. |
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_LETTER
Child Column in MAMMO_LETTER(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | RECOMMENDATION_ID | RAD_FOL_UP_FIELD | FOLLOW_UP_FIELD_ID |
Parent Column in MAMMO_LETTER (PK) | Child Table Name | Child Column Name | |
---|---|---|---|
Children: | LETTER_ID | MAMMO_LETTER_DETAIL | LETTER_ID |
MAMMO_NOTIFICATION | LETTER_ID | ||
MAMMO_NOTIFICATION_HIST | LETTER_ID | ||
MAMMO_STUDY | LETTER_ID | ||
RAD_MAMMO_LETTER_MGMT_R | LETTER_ID |
MAMMO_LETTER_DETAIL
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | This table contains all of the templates required to make up a letter. |
Definition: | Mammo Letter Detail Table |
Table Type: | REFERENCE |
Column Detail - MAMMO_LETTER_DETAIL
Column Name | Type | Null? | Definition |
---|---|---|---|
LETTER_ID | DOUBLE | N | This is a foreign key to the Mammo Letter Table |
SEQUENCE | DOUBLE | N | This column makes up the primary key along with the Letter Id. The sequence also tells the order at which the templates will appear in the letter. |
TEMPLATE_ID | DOUBLE | N | This is the template Id of the template which makes up a letter. It creates a foreign key to the wp_template 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_LETTER_DETAIL
Child Column in MAMMO_LETTER_DETAIL(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | LETTER_ID | MAMMO_LETTER | LETTER_ID |
TEMPLATE_ID | WP_TEMPLATE | TEMPLATE_ID |
MAMMO_NOTIFICATION
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | Mammography Notification |
Definition: | This table keeps track of historical notification associated with mammo follow-up. |
Table Type: | ACTIVITY |
Column Detail - MAMMO_NOTIFICATION
Column Name | Type | Null? | Definition |
---|---|---|---|
FOLLOW_UP_DEFAULT_TYPE_CD | DOUBLE | N | This identifies the type of follow-up letter that was sent out. |
LETTER_ID | DOUBLE | N | This is the letter id of the letter that last printed. |
NOTIFY_DT_TM | DATETIME | Y | The date and time that the letter was generated and sent. |
SEQUENCE | DOUBLE | N | The sequence that the letter(s) was sent for positive values. A negative number indicates letter type(s) that are suppressed. |
STUDY_ID | DOUBLE | N | This identifies the study that the letters were sent out for. This is a foreign key to the Mammo_Study table. |
TEMPLATE_ID | DOUBLE | N | This identifies the template that was used in generating the follow-up letter. This is a foreign key to the WP_Template 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_NOTIFICATION
Child Column in MAMMO_NOTIFICATION(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | LETTER_ID | MAMMO_LETTER | LETTER_ID |
STUDY_ID | MAMMO_STUDY | STUDY_ID | |
TEMPLATE_ID | WP_TEMPLATE | TEMPLATE_ID |
MAMMO_NOTIFICATION_HIST
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | Mammo Notification History |
Definition: | This table keeps track of historical information off the mammo notification table. |
Table Type: | ACTIVITY |
Column Detail - MAMMO_NOTIFICATION_HIST
Column Name | Type | Null? | Definition |
---|---|---|---|
FOLLOW_UP_DEFAULT_TYPE_CD | DOUBLE | N | This identifies the type of follow-up letter that was sent out. |
HIST_SEQUENCE | DOUBLE | N | This creates a unique key along with study_id and sequence and is incremented each time a copy of a given study is made from the mammo_notification table. |
LETTER_ID | DOUBLE | N | This is the Letter Id of the letter that printed. |
NOTIFY_DT_TM | DATETIME | Y | The date and time that the letter was generated and sent. |
SEQUENCE | DOUBLE | N | The sequence that the letter(s) was sent |
STUDY_ID | DOUBLE | N | This identifies the study that the letters were sent out for. This is a foreign key to the Mammo_Study table. |
TEMPLATE_ID | DOUBLE | N | This identifies the template that was used in generating the follow-up letter. This is a foreign key to the WP_Template 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_NOTIFICATION_HIST
Child Column in MAMMO_NOTIFICATION_HIST(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | LETTER_ID | MAMMO_LETTER | LETTER_ID |
STUDY_ID | MAMMO_STUDY | STUDY_ID | |
TEMPLATE_ID | WP_TEMPLATE | TEMPLATE_ID |