Table Detail Report

MSG_LETTER_TEMPLATE



Column Section Relationship Section Top of Page


Table-level Detail

Description: MSG_LETTER_TEMPLATE
Definition: Points to the letter template assigned to a user or position.
Table Type: REFERENCE





Column Detail - MSG_LETTER_TEMPLATE


Column Name Type Null? Definition
LONG_BLOB_REF_ID DOUBLE N Row in the LONG_BLOB_REFERENCE table that holds the assigned template text.
MSG_LETTER_TEMPLATE_ID DOUBLE N Primary key
POSITION_CD DOUBLE N Position assigned to the referenced template. Will be zero if PRSNL_ID is non-zero.
PRSNL_ID DOUBLE N Personnel assigned to the referenced template. Will be zero if POSITION_CD is non-zero.
TEMPLATE_TYPE_FLAG DOUBLE N Defines the type of template being saved. 0 represents the standard default result letter template, and 1 represents the patient ad hoc letter template.
TEXT_SEQUENCE DOUBLE N The sequence the text entries should be read back if they spans multiple blob rows.
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 - MSG_LETTER_TEMPLATE


Child Column in MSG_LETTER_TEMPLATE(FK) Parent Table Name Parent Column Name
Parents: LONG_BLOB_REF_ID LONG_BLOB_REFERENCE LONG_BLOB_ID
PRSNL_ID PRSNL PERSON_ID