Table Detail Report

PERSON_PATIENT_HIST



Column Section Relationship Section Top of Page


Table-level Detail

Description: Person Patient History Table
Definition: Used for tracking history of certain columns on the person_patient table.
Table Type: ACTIVITY





Column Detail - PERSON_PATIENT_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.
ADOPTED_CD DOUBLE N Describes the adopted status of the person.
ADVOCATE_REQUIRED_CD DOUBLE N Identifies it the patient requires someone to be present to help them understand and make decisions around their clinical care.
BAD_DEBT_CD DOUBLE N Describes a level or status of bad debt risk represented by the person.
BAPTISED_CD DOUBLE N Describes the baptised status of the person
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.
BIRTH_CERTIFICATE_IDENT VARCHAR(100) Y The numeric or textual identifier of the government issued vital document which certifies the patient's birth.
BIRTH_LENGTH DOUBLE Y The numerical length of the person recorded at birth.
BIRTH_LENGTH_UNITS_CD DOUBLE N The units used to record the birth length.
BIRTH_MULTIPLE_CD DOUBLE N Identifies a birth of more than one baby (i.e., twins, triplets, etc.
BIRTH_ORDER DOUBLE Y In the case of a multiple birth, the number which represents the order of brith for the person.
BIRTH_ORDER_CD DOUBLE N In the case of a multiple birth, the number which represents the order of birth for the person. This is essentially the same information that is stored in column Birth_Order but the UK handles this field differently so this new column was needed to accomodate the UK processing.
BIRTH_SEX_CD DOUBLE N The sex, typically determined by biological characteristics such as reproductive anatomy or genetic makeup, assigned at birth for the purposes of birth registration.
BIRTH_WEIGHT DOUBLE Y The numerical weight of the person recorded at birth.
BIRTH_WEIGHT_UNITS_CD DOUBLE N The units used to record the birth weight.
CALLBACK_CONSENT_CD DOUBLE N Denotes if the person has provided their consent to be contacted.
CHANGE_BIT DOUBLE N Identifies which columns have had a change.
CHURCH_CD DOUBLE N Identifies the specific church or place of worship with which the person is associated.
CONTACT_FOR_RESEARCH_PERM_CD DOUBLE N Information regarding if the patient has given permission to be contacted for research purposes
CONTACT_LIST_CD DOUBLE N Indicates whether the person has a hard-copy of contact list information on file with the institution
CONTACT_METHOD_CD DOUBLE N Denotes the person's preferred method of communication should he or she need to be contacted.
CONTACT_TIME VARCHAR(255) Y The preferred contact times and days for the person.
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.
CREDIT_HRS_TAKING DOUBLE Y The current number of school credit hours the person is taking.
CUMM_LEAVE_DAYS DOUBLE Y future
CURRENT_BALANCE DOUBLE Y The current unpaid account balance owed by the person.
CURRENT_GRADE DOUBLE Y The current school grade of the person.
CUSTODY_CD DOUBLE N A person relationship code identifying the relationship of the person who has custody of the person.
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.
DEATH_CERTIFICATE_IDENT VARCHAR(100) Y The numeric or textual identifier of the government issued vital document which certifies the patient's birth.
DEGREE_COMPLETE_CD DOUBLE N The highest degree completed by the person.
DEMOG_VERIFY_DT_TM DATETIME Y The date and time at which the patient's demographics were last verified.
DIET_TYPE_CD DOUBLE N Identifies a special kind of diet for the person.
DISEASE_ALERT_CD DOUBLE N Identifies if the person has a disease that personnel need to be aware of.
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.
EXT_TRANSPORT_REQUIRED_CD DOUBLE N Identifies if the patient requires transportation to the health care facility.
FAMILY_INCOME DOUBLE Y The current income of the person's immediate family.
FAMILY_NBR_OF_MINORS_CNT DOUBLE Y The current number of minors in the person's immediate family.
FAMILY_SIZE DOUBLE Y The current number of people in the person's immediate family.
FINANCIAL_RISK_LEVEL_CD DOUBLE N Indicates the person's propensity to make payment on bills for services rendered based on client-defined rules for evaluating financial risk level.
FIN_STATEMENT_EXPIRE_DT_TM DATETIME Y The date and time when the financial statement will expire for the person.
FIN_STATEMENT_VERIFIED_DT_TM DATETIME Y The date and time when the financial statement was verified for the person.
GEST_AGE_AT_BIRTH DOUBLE Y The gestational age at birth in days.
GEST_AGE_METHOD_CD DOUBLE N The code value for the method that was used to determine gestational age at birth.
HEALTH_APP_ACCESS_OFFERED_CD DOUBLE N the information regarding if the patient (or patient-authorized representative) has been offered access to any application(s) of their choosing made available by the provider which accesses their health information via a certified vendor API
HEALTH_INFO_ACCESS_OFFERED_CD DOUBLE N the information regarding if the patient (or patient-authorized representative) has been offered access to view online, download, and transmit their health information
HIGHEST_GRADE_COMPLETE_CD DOUBLE N The highest grade completed by the person.
IMMUN_ON_FILE_CD DOUBLE N future functionality
INTERP_REQUIRED_CD DOUBLE N Identifies that a language interpreter is required. Otherwise, this field is NULL.
INTERP_TYPE_CD DOUBLE N If the interp_required_cd is not null, then this field may be valued to indicate the need for a specific type of interpreter.
IQH_PARTICIPANT_CD DOUBLE N The IQ health participation code stores the consent status for IQ Health personal health record.
LAST_ATD_ACTIVITY_DT_TM DATETIME Y is this still used (V400)??
LAST_BILL_DT_TM DATETIME Y The date and time that the last bill was sent to the person or insurance organization.
LAST_BIND_DT_TM DATETIME Y The last bind date and time of the patient
LAST_DISCHARGE_DT_TM DATETIME Y The date and time that the person was last discharged from the inpatient or ambulatory organization.
LAST_EVENT_UPDT_DT_TM DATETIME Y The date and time of the last clinical event of the patient.
LAST_PAYMENT_DT_TM DATETIME Y The date and time of the last payment received on behalf of the person.
LAST_TRAUMA_DT_TM DATETIME Y Date the last trauma related encounter occurred
LIVING_ARRANGEMENT_CD DOUBLE N The living arrangement of the patient
LIVING_DEPENDENCY_CD DOUBLE N The living dependency of the patient.
LIVING_WILL_CD DOUBLE N Provides a status of the patients living will.
MICROFILM_CD DOUBLE N Describes the existence of microfilm for the person's chart.
MOTHER_IDENTIFIER VARCHAR(100) Y Free-text attribute used to uniquely identify the persons mother
MOTHER_IDENTIFIER_CD DOUBLE N Identifies the type of alias specified in the MOTHER_IDENTIFIER attribute (MRN, SSN)
NBR_OF_BROTHERS DOUBLE Y The person's current number of brothers.
NBR_OF_PREGNANCIES DOUBLE Y Number of pregnancies
NBR_OF_SISTERS DOUBLE Y The person's current number of sisters.
ORGAN_DONOR_CD DOUBLE N Describes the organ donor status of the person.
PARENT_MARITAL_STATUS_CD DOUBLE N The marital status of the person's parents (I.e., divorced)
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_PATIENT_HIST_ID DOUBLE N This is the value of the unique primary identifier of the person_patient_hist table. It is an internal system assigned number.
PHONE_CONTACT_TYPE_CD DOUBLE N Denotes the person's preferred type of phone should he or she need to be contacted.
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.
PREV_CONTACT_IND DOUBLE N This attribute indicates if the patient has ever had previous contact with UK's NHS (National Health System).
PRIMARY_CARE_HOME_CD DOUBLE N Information regarding the patient's primary care home. A primary care home is a patient centered primary care setting where a group of medical professionals coordinate care within a defined population.
PROCESS_ALERT_CD DOUBLE N Identifies if there are special registration processes required for a person.
SMOKES_CD DOUBLE N Describes the smoking status of the person.
SOURCE_LAST_SYNC_DT_TM DATETIME Y The last date and time the record was synchronized with the master system. Added to support the UK's PDS serial change number.
SOURCE_SYNC_LEVEL_FLAG DOUBLE N Synchronization level indicates what level of synchronization with the master system is to be performed. 0 - the full person record should be synched with the master system when all other necessary criteria for synchronization have been met. 1 - the person record has been decoupled from the master system and no part of the record should be synched even when all other criteria necessary for synchronization have been met.
SOURCE_VERSION_NUMBER VARCHAR(255) Y Version number assigned from a master system to this record. added to support the uk's pds serial change number.
STUDENT_CD DOUBLE N Indicates if the patient is a student (full or part time).
TRACKING_BIT DOUBLE N Identifies which columns are being tracked for history
TRANSACTION_DT_TM DATETIME Y More aptly named activity_dt_tm; holds the current date and time of the system when the row was inserted. This will match the create_dt_tm from the corresponding pm_hist_tracking row.
TUMOR_REGISTRY_CD DOUBLE N The tumor registry of the patient
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.
WRITTEN_FORMAT_CD DOUBLE N This code indicates what is the preferred type of written communication that should be used for the patient. An example would be large print, braille, etc.



Relationship Detail - PERSON_PATIENT_HIST


Child Column in PERSON_PATIENT_HIST(FK) Parent Table Name Parent Column Name
Parents: PERSON_ID PERSON PERSON_ID
PM_HIST_TRACKING_ID PM_HIST_TRACKING PM_HIST_TRACKING_ID


PERSON_PAYMENT_PROPENSITY



Column Section Relationship Section Top of Page


Table-level Detail

Description: Person Payment Propensity
Definition: Table stores payment propensity scores and accompanying data for a person.
Table Type: ACTIVITY





Column Detail - PERSON_PAYMENT_PROPENSITY


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.
DATA_SOURCE_CD DOUBLE N The information describing the source of the person's payment propensity information. Examples may include various third party transactions or manual entry (name of the hospital).
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.
ESTIMATED_HOUSEHOLD_INCOME_AMT DOUBLE Y The estimated total income of those living within the person's household.
ESTIMATED_HOUSEHOLD_SIZE_CNT DOUBLE Y The estimated number of people in the person's household. A household usually includes the tax filer, their spouse if they have one, and their tax dependents.
HEALTHCARE_CREDIT_SCORE_VALUE DOUBLE Y The FICO propensity score for healthcare that is used to evaluate the probability that a person will pay off their healthcare debt.
NUMBER_OF_BANKRUPTCIES_CNT DOUBLE Y A person's number of open bankruptcies.
PARENT_ENTITY_ID DOUBLE N Used to store the identifier for the parent.
PARENT_ENTITY_NAME VARCHAR(30) N Used to store the identifier for the parent.
PERSON_PAYMENT_PROPENSITY_ID DOUBLE N Unique generated number that identifies a single row on the PERSON_PAYMENT_PROPENSITY table.
SCORE_DESC VARCHAR(100) Y The description of the payment propensity score value.
SCORE_VALUE_TXT VARCHAR(20) Y The score is a value, often a number, assigned to a person that indicates their propensity to make payment on bills for healthcare services rendered.
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_PAYMENT_PROPENSITY




Parent Column in PERSON_PAYMENT_PROPENSITY (PK) Child Table Name Child Column Name
Children: PERSON_PAYMENT_PROPENSITY_ID PERSON_PAY_PROPENSITY_HIST PERSON_PAYMENT_PROPENSITY_ID


PERSON_PAY_PROPENSITY_HIST



Column Section Relationship Section Top of Page


Table-level Detail

Description: Person Payment Propensity History
Definition: Table stores historical information about payment propensity scores and accompanying data for a person.
Table Type: ACTIVITY





Column Detail - PERSON_PAY_PROPENSITY_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.
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.
CHANGE_BIT DOUBLE N Identifies which columns have had a change.
DATA_SOURCE_CD DOUBLE N The information describing the source of the person's payment propensity information. Examples may include various third party transactions or manual entry (name of the hospital).
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.
ESTIMATED_HOUSEHOLD_INCOME_AMT DOUBLE Y The estimated total income of those living within the person's household.
ESTIMATED_HOUSEHOLD_SIZE_CNT DOUBLE Y The estimated number of people in the person's household. A household usually includes the tax filer, their spouse if they have one, and their tax dependents.
HEALTHCARE_CREDIT_SCORE_VALUE DOUBLE Y The FICO propensity score for healthcare that is used to evaluate the probability that a person will pay off their healthcare debt.
NUMBER_OF_BANKRUPTCIES_CNT DOUBLE Y A person's number of open bankruptcies.
PERSON_PAYMENT_PROPENSITY_ID DOUBLE N Unique generated number that identifies a single row on the PERSON_PAYMENT_PROPENSITY table.
PERSON_PAY_PROPENSITY_HIST_ID DOUBLE N Unique generated number that identifies a single row on the PERSON_PAY_PROPESNITY_HIST 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.
SCORE_DESC VARCHAR(100) Y The description of the payment propensity score value.
SCORE_VALUE_TXT VARCHAR(20) Y The score is a value, often a number, assigned to a person that indicates their propensity to make payment on bills for healthcare services rendered.
TRACKING_BIT DOUBLE N Identifies which columns are being tracked for history.
TRANSACTION_DT_TM DATETIME N ** 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_PAY_PROPENSITY_HIST


Child Column in PERSON_PAY_PROPENSITY_HIST(FK) Parent Table Name Parent Column Name
Parents: PERSON_PAYMENT_PROPENSITY_ID PERSON_PAYMENT_PROPENSITY PERSON_PAYMENT_PROPENSITY_ID
PM_HIST_TRACKING_ID PM_HIST_TRACKING PM_HIST_TRACKING_ID


PERSON_PERSON_RELTN



Column Section Relationship Section Top of Page


Table-level Detail

Description: Person Person Relationship
Definition: The person-person relationship table contains pointers to other related persons in the person table(i.e., family members, etc.). The kind of relationship and genetic indication defines how the two persons are related.
Table Type: ACTIVITY





Column Detail - PERSON_PERSON_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.
CONTACT_ROLE_CD DOUBLE N Identifies what type of role the contact person is.
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.
COPY_CORRESPONDENCE_CD DOUBLE N Denotes whether the related person should be copied on any correspondence to the person.
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.
DEFAULT_RELTN_IND DOUBLE N Identifies whether the relationship is the default displayable Mother-Child relationship.
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.
FAMILY_RELTN_SUB_TYPE_CD DOUBLE N The specific family relationship
FREE_TEXT_CD DOUBLE N Future Functionality
FT_REL_PERSON_NAME VARCHAR(100) Y If free textperson relationship was built the name is displayed here
GENETIC_RELATIONSHIP_IND DOUBLE N Indicates whether the two people specified in the relationship are geneticly tied
INTERNAL_SEQ DOUBLE N Internal Person Management Sequence
LIVING_WITH_IND DOUBLE N Indicates whether the two persons specified in the relationship live together
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_PERSON_RELTN_ID DOUBLE N The identifying key of Person Person Relationship
PERSON_RELTN_CD DOUBLE N Person Relation Code Value
PERSON_RELTN_TYPE_CD DOUBLE N Code value indicating what type of relationship this is
PRIORITY_SEQ DOUBLE N Identifies an sequencing priority to be used when there is more than one related person with the same person relationship type (I.e., emergency contact)
RELATED_PERSON_ID DOUBLE N Related Person ID
RELATED_PERSON_RELTN_CD DOUBLE N Related Person Relationship Code Value
RELATION_SEQ DOUBLE N Zero based sequence for all person_person_reltn rows across all relation types set by the master system. Added to support he UK's PDS transactions.
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.
VISITATION_ALLOWED_CD DOUBLE N Visitation Allowed Code Value



Relationship Detail - PERSON_PERSON_RELTN


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




Parent Column in PERSON_PERSON_RELTN (PK) Child Table Name Child Column Name
Children: PERSON_PERSON_RELTN_ID PERSON_PERSON_RELTN_HIST PERSON_PERSON_RELTN_ID


PERSON_PERSON_RELTN_HIST



Column Section Relationship Section Top of Page


Table-level Detail

Description: Person Person Relationship History
Definition: Contains transactional history of the PERSON_PERSON_RELTN table.
Table Type: ACTIVITY





Column Detail - PERSON_PERSON_RELTN_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 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.
CHANGE_BIT DOUBLE N Identifies which columns have changed.
CONTACT_ROLE_CD DOUBLE N Identifies what type of role the contact person is.
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.
COPY_CORRESPONDENCE_CD DOUBLE N Denotes whether the related person should be copied on any correspondence to the person.
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.
DEFAULT_RELTN_IND DOUBLE N Identifies whether the relationship is the default displayable Mother-Child relationship.
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.
FAMILY_RELTN_SUB_TYPE_CD DOUBLE N The specific family relationship
FREE_TEXT_CD DOUBLE N Future Functionality
FT_REL_PERSON_NAME VARCHAR(100) Y The name of the person in the 'free text' relationship indicated by the free_text_ind in the row being set to 'TRUE'.
GENETIC_RELATIONSHIP_IND DOUBLE Y Indicates whether the two people specified in the relationship are geneticly tied
INTERNAL_SEQ DOUBLE Y Sequence used within Cerner applications to order encounter person relationship rows.
LIVING_WITH_IND DOUBLE Y Indicates whether the two persons specified in the relationship live together
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_PERSON_RELTN_HIST_ID DOUBLE N The unique primary key of this table. It is internally generated by Cerner.
PERSON_PERSON_RELTN_ID DOUBLE N The primary key of the PERSON_PERSON_RELTN table that this history is related to.
PERSON_RELTN_CD DOUBLE N Person Relation Code Value
PERSON_RELTN_TYPE_CD DOUBLE N Code value indicating what type of relationship this is
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.
PRIORITY_SEQ DOUBLE Y Identifies an sequencing priority to be used when there is more than one related person with the same person relationship type (I.e., emergency contact)
RELATED_PERSON_ID DOUBLE N Related Person ID
RELATED_PERSON_RELTN_CD DOUBLE N Related Person Relationship Code Value
RELATION_SEQ DOUBLE N Zero based sequence for all person_person_reltn rows across all relation types set by the master system. Added to support he UK's PDS transactions.
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.
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.
VISITATION_ALLOWED_CD DOUBLE N Visitation Allowed Code Value



Relationship Detail - PERSON_PERSON_RELTN_HIST


Child Column in PERSON_PERSON_RELTN_HIST(FK) Parent Table Name Parent Column Name
Parents: PERSON_PERSON_RELTN_ID PERSON_PERSON_RELTN PERSON_PERSON_RELTN_ID
PM_HIST_TRACKING_ID PM_HIST_TRACKING PM_HIST_TRACKING_ID