Table Detail Report

STICKY_NOTE



Column Section Top of Page


Table-level Detail

Description: Sticky Note
Definition: Stores different types of sticky notes, notes that can be 'stuck' to any entity
Table Type: ACTIVITY





Column Detail - STICKY_NOTE


Column Name Type Null? Definition
BEG_EFFECTIVE_DT_TM DATETIME Y 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.
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.
LONG_TEXT_ID DOUBLE N This is the id to the long text table, If the note is too long to fit on the sticky note table it will be written to the long text table and referenced here.
PARENT_ENTITY_ID DOUBLE N The primary index of the row in the table that the sticky note is 'stuck' to.
PARENT_ENTITY_NAME VARCHAR(40) N The table name that the sticky note is 'stuck' to. (i.e. PERSON)
PUBLIC_IND DOUBLE Y Indicator specifying whether note is public to view, printable on reports, or any other similar use
STICKY_NOTE_ID DOUBLE N The unique, primary index for a row on the table
STICKY_NOTE_STATUS_CD DOUBLE N Status of note for purging purposes
STICKY_NOTE_TEXT VARCHAR(255) Y the text 'on' the sticky note
STICKY_NOTE_TYPE_CD DOUBLE N This distiguishes the types of sticky notes (i.e. powerchart's vs. profile's)
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.


SVCCAT_CLINSVC_RELTN



Column Section Top of Page


Table-level Detail

Description: SVCCAT CLINSVC RELTN
Definition: This table stores a mapping between service categories and clinical services.
Table Type: REFERENCE





Column Detail - SVCCAT_CLINSVC_RELTN


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.
ACTIVE_STATUS_CD DOUBLE N Indicates the status of the row itself (not the data in the row) such as active, inactive, combined away, pending purge, etc.
ACTIVE_STATUS_DT_TM DATETIME N The date and time that the active_status_cd was set.
ACTIVE_STATUS_PRSNL_ID DOUBLE N The person who caused the active_status_cd to be set or change.
CLINICAL_SERVICE_CD DOUBLE N Clinical service code value
SERVICE_CATEGORY_CD DOUBLE N Service category code value
SVCCAT_CLINSVC_RELTN_ID DOUBLE N SEQUENCE_NAME: PROFILE_SEQThis is the value of the unique primary identifier of the SVC_CAT_CLIN_SVC_RELTN table. It is an internal system assigned number.
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.


TAG_COLOR



Column Section Relationship Section Top of Page


Table-level Detail

Description: Tag Color
Definition: Stores the tag color for a physician/media.
Table Type: ACTIVITY





Column Detail - TAG_COLOR


Column Name Type Null? Definition
ACTIVE_IND DOUBLE Y 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.
ACTIVE_STATUS_CD DOUBLE N Indicates the status of the row itself (not the data in the row) such as active, inactive, combined away, pending purge, etc.
ACTIVE_STATUS_DT_TM DATETIME Y The date and time that the active_status_cd was set.
ACTIVE_STATUS_PRSNL_ID DOUBLE N The person who caused the active_status_cd to be set or change.
BEG_EFFECTIVE_DT_TM DATETIME Y 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.
DEPARTMENT_CD DOUBLE N This is the department code.
ENCNTR_ID DOUBLE N This is the value of the unique primary identifier of the encounter table. It is an internal system assigned number.
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.
ORGANIZATION_ID DOUBLE N This is the value of the unique primary identifier of the organization table. It is an internal system assigned number.
PERSON_ID DOUBLE N This is the value of the unique primary identifier of the person table. It is an internal system assigned number.
PHYSICIAN_ID DOUBLE N This is the value of the unique primary identifier of the prsnl table. It is an internal system assigned number
TAG_COLOR_CD DOUBLE N The tag color for this physician/encounter
TAG_COLOR_ID DOUBLE N This is the value of the unique primary identifier of the tag color table. It is an internal system assigned number
UPDT_APPLCTX DOUBLE N The application context number from the record info block. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic.
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. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic.
UPDT_DT_TM DATETIME N The date and time the row was last inserted or updated. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic.
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. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic.
UPDT_TASK DOUBLE N The registered (assigned) task number for the process that inserted or updated the row. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic.



Relationship Detail - TAG_COLOR


Child Column in TAG_COLOR(FK) Parent Table Name Parent Column Name
Parents: ENCNTR_ID ENCOUNTER ENCNTR_ID
ORGANIZATION_ID ORGANIZATION ORGANIZATION_ID
PERSON_ID PERSON PERSON_ID


TASK_ACTION_HISTORY



Column Section Top of Page


Table-level Detail

Description: TASK ACTION HISTORY
Definition: The history of task action
Table Type: ACTIVITY





Column Detail - TASK_ACTION_HISTORY


Column Name Type Null? Definition
ACTIVE_IND DOUBLE Y 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.
ACTIVE_STATUS_CD DOUBLE N Indicates the status of the row itself (not the data in the row) such as active, inactive, combined away, pending purge, etc.
ACTIVE_STATUS_DT_TM DATETIME Y The date and time that the active_status_cd was set.
ACTIVE_STATUS_PRSNL_ID DOUBLE N The person who caused the active_status_cd to be set or change.
BEG_EFFECTIVE_DT_TM DATETIME Y 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.
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.
RESCHEDULE_REASON_CD DOUBLE N Reason for rescheduling
TASK_ACTION_HISTORY_ID DOUBLE N The primary key of this table
TASK_ACTION_SEQ DOUBLE Y sequence for task
TASK_DT_TM DATETIME Y Date of task
TASK_ID DOUBLE N primary key for task activity
TASK_STATUS_CD DOUBLE N status of task
TASK_STATUS_REASON_CD DOUBLE N reason for changing task status
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.


TASK_ACTIVITY_HISTORY



Column Section Relationship Section Top of Page


Table-level Detail

Description: TASK ACTIVITY HISTORY
Definition: It holds completed HIM tasks
Table Type: ACTIVITY





Column Detail - TASK_ACTIVITY_HISTORY


Column Name Type Null? Definition
ACTIVE_IND DOUBLE Y 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.
ACTIVE_STATUS_CD DOUBLE N Indicates the status of the row itself (not the data in the row) such as active, inactive, combined away, pending purge, etc.
ACTIVE_STATUS_DT_TM DATETIME Y The date and time that the active_status_cd was set.
ACTIVE_STATUS_PRSNL_ID DOUBLE N The person who caused the active_status_cd to be set or change.
BEG_EFFECTIVE_DT_TM DATETIME Y 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.
ENCNTR_ID DOUBLE N This is the value of the unique primary identifier of the encounter table. It is an internal system assigned number.
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.
LOCATION_CD DOUBLE N location of visit
PERSON_ID DOUBLE N This is the value of the unique primary identifier of the person table. It is an internal system assigned number.
TASK_ACTIVITY_HISTORY_ID DOUBLE N The primary key of this table
TASK_CLASS_CD DOUBLE N the class of tasks
TASK_COMPLETED_DT_TM DATETIME Y Date/time task was completed
TASK_COMPLETED_PRSNL_ID DOUBLE N Person who completed the task
TASK_CREATE_DT_TM DATETIME Y The date of task created
TASK_DT_TM DATETIME Y The date of task completed
TASK_ID DOUBLE N The unique ID for a task
TASK_STATUS_CD DOUBLE N The status of the task
TASK_TYPE_CD DOUBLE N Type of task
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 - TASK_ACTIVITY_HISTORY


Child Column in TASK_ACTIVITY_HISTORY(FK) Parent Table Name Parent Column Name
Parents: ENCNTR_ID ENCOUNTER ENCNTR_ID
PERSON_ID PERSON PERSON_ID