Table Detail Report

DD_SESSION_DATA



Column Section Relationship Section Top of Page


Table-level Detail

Description: Dynamic Documentation - Session Data
Definition: This table stores temporary data during an active session. An example is the raw XML returned by the Data Retrieval Queries that need to be temporarily stored until the user explictly saves the note.
Table Type: ACTIVITY





Column Detail - DD_SESSION_DATA


Column Name Type Null? Definition
CONTENT_INSTANCE_IDENT VARCHAR(255) Y Used to associate session data tied to the document's XHTML blob. Optional.
DD_SESSION_DATA_ID DOUBLE N Uniquely identifies temporary data for which queries have been made during the current user's session.
DD_SESSION_ID DOUBLE N Uniquely identifies the session associated to the blob.
LONG_BLOB_ID DOUBLE N Uniquely identifies the data. The type of data is stored in the CONTENT_STATE_KEY.
SESSION_DATA_KEY VARCHAR(80) N Indicates the type of blob stored.
SHORT_TXT VARCHAR(255) Y Used to store data less than or equal to 255 characters.
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 - DD_SESSION_DATA


Child Column in DD_SESSION_DATA(FK) Parent Table Name Parent Column Name
Parents: DD_SESSION_ID DD_SESSION DD_SESSION_ID


PDOC_AUTOSAVE



Column Section Relationship Section Top of Page


Table-level Detail

Description: Physicial Documentation Auto Save
Definition: This table stores details about auto saved entries
Table Type: ACTIVITY





Column Detail - PDOC_AUTOSAVE


Column Name Type Null? Definition
AUTHOR_ID DOUBLE N Contains the id of the author that created the content being auto saved.
ENCNTR_ID DOUBLE N Identifies the encounter to which the auto saved content belongs.
LONG_BLOB_ID DOUBLE N Uniquely identifies the auto saved content.
PATIENT_ID DOUBLE N Identifies the patient to which the auto saved content belongs.
PDOC_AUTOSAVE_ID DOUBLE N Uniquely identifies information about an auto saved document.
REFERENCE_TXT VARCHAR(255) N Identifies the type of content being auto saved. Should not contain user, patient, or encounter identifiers or patient combines will not work.
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 - PDOC_AUTOSAVE


Child Column in PDOC_AUTOSAVE(FK) Parent Table Name Parent Column Name
Parents: ENCNTR_ID ENCOUNTER ENCNTR_ID
LONG_BLOB_ID LONG_BLOB LONG_BLOB_ID
PATIENT_ID PERSON PERSON_ID
AUTHOR_ID PRSNL PERSON_ID