Table Detail Report

PERSON_PORTAL_INVITE



Column Section Relationship Section Top of Page


Table-level Detail

Description: Person Portal Invite
Definition: Stores information relating to a person's portal enrollment invitation.
Table Type: ACTIVITY





Column Detail - PERSON_PORTAL_INVITE


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.
CHALLENGE_ANSWER_TXT VARCHAR(50) Y The answer to the challenge question selected by the patient or (authorized-patient representative). The challenge question paired with the answer is used for authenticating their identify when the invitation is claimed.
CHALLENGE_QUESTION_CD DOUBLE N The question selected by the patient or (authorized-patient representative) paired with the challenge answer for authenticating their identity when the invitation is claimed.
ERROR_REASON_CD DOUBLE N Information describing the reason that the attempt to send an invitation to the person was not successful.
INVITE_STATUS_CD DOUBLE N The status of the person's portal invitation (i.e., sent, sending, error, self-enrolled)
PATIENT_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_ID DOUBLE N This is the value of the unique primary identifier of the person table. It is an internal system assigned number.
PERSON_PORTAL_INVITE_ID DOUBLE N This is the value of the unique primary identifier of the person_portal_invite 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 - PERSON_PORTAL_INVITE


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




Parent Column in PERSON_PORTAL_INVITE (PK) Child Table Name Child Column Name
Children: PERSON_PORTAL_INVITE_ID PERSON_PORTAL_INVITE_HIST PERSON_PORTAL_INVITE_ID


PERSON_PORTAL_INVITE_HIST



Column Section Relationship Section Top of Page


Table-level Detail

Description: Person Portal Invite History
Definition: Used for tracking history changes to PERSON_PORTAL_INVITE rows.
Table Type: ACTIVITY





Column Detail - PERSON_PORTAL_INVITE_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.
CHALLENGE_ANSWER_TXT VARCHAR(50) Y The answer to the challenge question selected by the patient or (authorized-patient representative). The challenge question paired with the answer is used for authenticating their identify when the invitation is claimed.
CHALLENGE_QUESTION_CD DOUBLE N The question selected by the patient or (authorized-patient representative) paired with the challenge answer for authenticating their identity when the invitation is claimed.
CHANGE_BIT DOUBLE N Identifies which columns have had a change.
ERROR_REASON_CD DOUBLE N Information describing the reason that the attempt to send an invitation to the person was not successful.
INVITE_STATUS_CD DOUBLE N The status of the person's portal invitation (i.e., sent, sending, error, self-enrolled)
PATIENT_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_PORTAL_INVITE_HIST_ID DOUBLE N Uniquely Identifies a row on the PERSON_PORTAL_INVITE_HIST table.
PERSON_PORTAL_INVITE_ID DOUBLE N Uniquely identifies a related row on the PERSON_PORTAL_INVITE table.
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.
TRANSACTION_DT_TM DATETIME Y ** OBSOLETE **. Use column updt_dt_tm for any filtering/ordering query. If transaction date time is needed, it should be retrieved from pm_hist_tracking table. Note that its date may be in the past, as in before the update date time.
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_PORTAL_INVITE_HIST


Child Column in PERSON_PORTAL_INVITE_HIST(FK) Parent Table Name Parent Column Name
Parents: PATIENT_PERSON_ID PERSON PERSON_ID
PERSON_PORTAL_INVITE_ID PERSON_PORTAL_INVITE PERSON_PORTAL_INVITE_ID
PM_HIST_TRACKING_ID PM_HIST_TRACKING PM_HIST_TRACKING_ID


PERSON_PREF



Column Section Relationship Section Top of Page


Table-level Detail

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





Column Detail - PERSON_PREF


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 N identifies the appointment proximity address type (i.e., home, business, etc.).
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 this is the value of the unique primary identifier of the person table. it is an internal system assigned number.
PROVIDER_LANGUAGE_CD DOUBLE Y The preferred provider's language.
PROVIDER_SEX_CD DOUBLE N 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
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


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




Parent Column in PERSON_PREF (PK) Child Table Name Child Column Name
Children: PERSON_ID PERSON_PREF_HIST PERSON_ID


PERSON_PREFERRED_PHARMACY



Column Section Relationship Section Top of Page


Table-level Detail

Description: Person Preferred Pharmacy
Definition: Table is used to store the Pharmacy information for all the patients.
Table Type: ACTIVITY





Column Detail - PERSON_PREFERRED_PHARMACY


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.
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.
DEFAULT_IND DOUBLE N An indicator used to differentiate whether the pharmacy is the default. 1 - default pharmacy, 0 - not the default pharmacy.
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 Uniquely identifies the person related to this pharmacy information.
PERSON_PREFERRED_PHARMACY_ID DOUBLE N Uniquely identifies pharmacy information for a specific person.
PREFERRED_PHARMACY_UID VARCHAR(255) Y An identifier used to uniquely identified the related pharmacy.
REASON_CD DOUBLE N Contains the reason this pharmacy was chosen as a default.
REASON_TEXT VARCHAR(255) Y Contains free text of why this pharmacy was chosen as a default.
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_PREFERRED_PHARMACY


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


PERSON_PREF_COMM



Column Section Relationship Section Top of Page


Table-level Detail

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





Column Detail - PERSON_PREF_COMM


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.
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_ID DOUBLE N this is the value of the unique primary identifier of the person table. it is an internal system assigned number.
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).
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


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




Parent Column in PERSON_PREF_COMM (PK) Child Table Name Child Column Name
Children: PERSON_PREF_COMM_ID PERSON_PREF_COMM_HIST PERSON_PREF_COMM_ID