Table Detail Report

PERSON_PREF_COMM_HIST



Column Section Relationship Section Top of Page


Table-level Detail

Description: Person Communication Preference History
Definition: Stores information relating to a person's communication preferences
Table Type: ACTIVITY





Column Detail - PERSON_PREF_COMM_HIST


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.
ADDR_TYPE_CD DOUBLE Y identifies the type of address for postal deliveries.
CHANGE_BIT DOUBLE N Identifies which columns have had a change.
COMMUNICATION_TYPE_CD DOUBLE N identifies the type of communication (i.e., appointment reminders, clinical communication, statements, etc).
CONTACT_METHOD_CD DOUBLE N denotes the person's preferred method of communication should he or she need to be contacted for the associated communication type.
PERSON_PREF_COMM_HIST_ID DOUBLE N Unique generated number that identifies a row on the PERSON_PREF_COMM_HIST table.
PERSON_PREF_COMM_ID DOUBLE N Unique generated number that identifies a row on the PERSON_PREF_COMM table.
PHONE_TYPE_CD DOUBLE Y identifies the type of email, phone, or fax (i.e., home, business, etc).
PM_HIST_TRACKING_ID DOUBLE N This is the value of the unique primary identifier of the pm_hist_tracking table. It is an internal system assigned number.
TRACKING_BIT DOUBLE N Identifies which columns are being tracked for history.
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.
VERIFY_DT_TM DATETIME Y the date and time the communication type was last verified.



Relationship Detail - PERSON_PREF_COMM_HIST


Child Column in PERSON_PREF_COMM_HIST(FK) Parent Table Name Parent Column Name
Parents: PERSON_PREF_COMM_ID PERSON_PREF_COMM PERSON_PREF_COMM_ID
PM_HIST_TRACKING_ID PM_HIST_TRACKING PM_HIST_TRACKING_ID


PERSON_PREF_HIST



Column Section Relationship Section Top of Page


Table-level Detail

Description: Person Preference History
Definition: Used for tracking history changes to PERSON_PREFERNCE rows
Table Type: ACTIVITY





Column Detail - PERSON_PREF_HIST


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.
APPT_PROXIMITY_ADDR_TYPE_CD DOUBLE Y identifies the appointment proximity address type (i.e., home, business, etc.).
CHANGE_BIT DOUBLE N Identifies which columns have had a change.
FACILITY_ORGANIZATION_ID DOUBLE N The identifier of the preferred facility organization.
FRIDAY_APPT_TIME_CD DOUBLE Y The preferred appointment time for Friday.
MONDAY_APPT_TIME_CD DOUBLE Y The preferred appointment time for Monday.
PERSON_ID DOUBLE N Uniquely identifies the person related to the person preference.
PERSON_PREF_HIST_ID DOUBLE N Unique generated number that identifies a single row on the PERSON_PREF_HIST
PM_HIST_TRACKING_ID DOUBLE N This is the value of the unique primary identifier of the pm_hist_tracking table. It is an internal system assigned number.
PROVIDER_LANGUAGE_CD DOUBLE Y The preferred provider's language.
PROVIDER_SEX_CD DOUBLE Y The preferred provider's gender (sex).
SATURDAY_APPT_TIME_CD DOUBLE Y The preferred appointment time for Saturday
SUNDAY_APPT_TIME_CD DOUBLE Y The preferred appointment time for Sunday
THURSDAY_APPT_TIME_CD DOUBLE Y The preferred appointment time for Thursday
TRACKING_BIT DOUBLE N Identifies which columns are being tracked for history.
TUESDAY_APPT_TIME_CD DOUBLE Y The preferred appointment time for Tuesday
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.
WEDNESDAY_APPT_TIME_CD DOUBLE Y The preferred appointment time for Wednesday.



Relationship Detail - PERSON_PREF_HIST


Child Column in PERSON_PREF_HIST(FK) Parent Table Name Parent Column Name
Parents: FACILITY_ORGANIZATION_ID ORGANIZATION ORGANIZATION_ID
PERSON_ID PERSON_PREF PERSON_ID
PM_HIST_TRACKING_ID PM_HIST_TRACKING PM_HIST_TRACKING_ID


PERSON_PREF_PHARMACY_REV



Column Section Relationship Section Top of Page


Table-level Detail

Description: Person Preferred Pharmacy Review
Definition: This table is used to store the preferred pharmacy review information.
Table Type: ACTIVITY





Column Detail - PERSON_PREF_PHARMACY_REV


Column Name Type Null? Definition
PERSON_ID DOUBLE N Uniquely identifies the person to which this pharmacy information is related.
PERSON_PREF_PHARMACY_REV_ID DOUBLE N Uniquely identifies preferred pharmacy review information.
REVIEW_TZ DOUBLE N Indicates the time zone in which the review is performed.
REV_DT_TM DATETIME N The date and time at which the pharmacy information is reviewed.
REV_IND DOUBLE N An indicator used to identify whether patient's pharmacy information has been reviewed.
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 - PERSON_PREF_PHARMACY_REV


Child Column in PERSON_PREF_PHARMACY_REV(FK) Parent Table Name Parent Column Name
Parents: PERSON_ID PERSON PERSON_ID


PERSON_PRSNL_ORG_OVERRIDE



Column Section Relationship Section Top of Page


Table-level Detail

Description: Person Personnel Organization Override
Definition: The person personnel organization override table contains information regarding a personnel's permission to access a patient's data at a particular organization which overrides organization security.
Table Type: ACTIVITY





Column Detail - PERSON_PRSNL_ORG_OVERRIDE


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.
BEG_EFFECTIVE_DT_TM DATETIME N 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.
CHART_ACCESS_ORGANIZATION_ID DOUBLE N The identifier of the chart access organization which contains the data of the patient that the personnel is requesting persmission to access.
END_EFFECTIVE_DT_TM DATETIME N 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.
PERSON_ID DOUBLE N The person identifier of the patient to which the personnel requests permission to access data.
PERSON_PRSNL_ORG_OVERRIDE_ID DOUBLE N Unique generated number that identifies a single row on the PERSON_PRSNL_ORG_OVERRIDE table.
PRSNL_ID DOUBLE N The personnel identifier of the user requesting access to patient data associated with the organization.
SOURCE_CHILD_ORGANIZATION_ID DOUBLE N The identifier of the source child organization from where the personnel requests permission to access data. This is also used to limit the scope of the access being granted. This would be optional and not be needed in most workflows. For Sweden workflows, this would be the care unit.
SOURCE_PARENT_ORGANIZATION_ID DOUBLE N The identifier of the source parent organization from where the personnel requests permission to access data. This is also used to limit the scope of the access being granted. This would be optional and not be needed in most workflows. For Sweden workflows, this would be the care giver.
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 - PERSON_PRSNL_ORG_OVERRIDE


Child Column in PERSON_PRSNL_ORG_OVERRIDE(FK) Parent Table Name Parent Column Name
Parents: CHART_ACCESS_ORGANIZATION_ID ORGANIZATION ORGANIZATION_ID
SOURCE_CHILD_ORGANIZATION_ID ORGANIZATION ORGANIZATION_ID
SOURCE_PARENT_ORGANIZATION_ID ORGANIZATION ORGANIZATION_ID
PERSON_ID PERSON PERSON_ID
PRSNL_ID PRSNL PERSON_ID


PERSON_PRSNL_RELTN



Column Section Relationship Section Top of Page


Table-level Detail

Description: Person Personnel Relationship
Definition: The person-personnel relationship table contains pointers to related personnel in the personnel table. The kind of relationship (i.e., primary care physician, etc.) defines how the person and personnel are related.
Table Type: ACTIVITY





Column Detail - PERSON_PRSNL_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 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 N 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.
CONTRIBUTOR_SYSTEM_CD DOUBLE N Contributor system identifies the source feed of data from which a row was populated. This is mainly used to determine how to update a set of data that may have originated from more than one source feed.
DATA_STATUS_CD DOUBLE N Data status indicates a level of authenticity of the row data. Typically this will either be AUTHENTICATED or UNAUTHENTICATED.
DATA_STATUS_DT_TM DATETIME Y The date and time that the data_status_cd was set.
DATA_STATUS_PRSNL_ID DOUBLE N The person who caused the data_status_cd to be set or change.
END_EFFECTIVE_DT_TM DATETIME N 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.
FREE_TEXT_CD DOUBLE N When set to a meaning of 'FTBRIEF', this indicates that the prsnl_person_id is NULL, meaning that there is no reference to the personnel table. This is a 'free text' relationship with the name of this
FT_PRSNL_NAME VARCHAR(100) Y The name of the personnel in the 'free text' relationship indicated by the free_text_ind in the row being set to 'TRUE'.
INTERNAL_SEQ DOUBLE N Internal Person Management sequence
MANUAL_CREATE_BY_ID DOUBLE N Person Id of the person who manually created the relationship
MANUAL_CREATE_DT_TM DATETIME Y Date and Time relationship was manually created.
MANUAL_CREATE_IND DOUBLE N Indicator that this relationship was manually created
MANUAL_INACT_BY_ID DOUBLE N Person Id of the person who manually inactivated the relationship
MANUAL_INACT_DT_TM DATETIME Y Date & time that this relationship was manually inactivated
MANUAL_INACT_IND DOUBLE N Indicator that this relationship was manually inactivated
NOTIFICATION_CD DOUBLE N Personnel preferred method of notification for issues concerning related person.
PERSON_ID DOUBLE N This is the value of the unique primary identifier of the person table. It is an internal system assigned number.
PERSON_PRSNL_RELTN_ID DOUBLE N This is the value of the unique primary identifier of the person-personnel relationship table. It is an internally assigned number and generally not revealed to the user.
PERSON_PRSNL_R_CD DOUBLE N Person Prsnl Relationship Id
PRIORITY_SEQ DOUBLE N Identifies a sequencing priority to be used when a duplicate relationship of the same type is created
PRSNL_PERSON_ID DOUBLE N This is the value of the unique primary identifier of the personnel table. This is a 'role' name for the reference to person_id in the personnel table and used to differentiate between other references to person_id in this table.
SOURCE_IDENTIFIER VARCHAR(255) Y Identifier assigned from a master system to this row. Added to support he UK's PDS Allocated Object Identifier. Used to help keep the UK master database in sync with Millennium.
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 - PERSON_PRSNL_RELTN


Child Column in PERSON_PRSNL_RELTN(FK) Parent Table Name Parent Column Name
Parents: PERSON_ID PERSON PERSON_ID
PRSNL_PERSON_ID PRSNL PERSON_ID




Parent Column in PERSON_PRSNL_RELTN (PK) Child Table Name Child Column Name
Children: PERSON_PRSNL_RELTN_ID PERSON_PRSNL_RELTN_HISTORY PERSON_PRSNL_RELTN_ID