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