Table Detail Report

HNA_EXCEPT_AUDIT



Column Section Relationship Section Top of Page


Table-level Detail

Description: HNA Exception Audit
Definition: Audit trail for Reconcile Exceptions
Table Type: ACTIVITY





Column Detail - HNA_EXCEPT_AUDIT


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 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.
DOB DATETIME Y The DOB of the exception group that caused the row to be written to the table
DOB_TZ DOUBLE Y Time zone associated with the corresponding DT_TM column.
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.
EXCEPT_GROUP_ID DOUBLE N The id of the exception group that caused the row to be written to the table
FNAME VARCHAR(100) Y The first name of the exception group that caused the row to be written to the table
HNA_EXCEPT_AUDIT_ID DOUBLE N This is the value of the unique primary identifier of the hna_except_audit table. It is an internal system assigned number
LNAME VARCHAR(100) Y The last name of the exception group that caused the row to be written to the table
PERSON_ID DOUBLE N This is the value of the unique primary identifier of the person table. It is an internal system assigned number.
SSN VARCHAR(100) Y The SSN of the exception group that caused the row to be written to the table
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 - HNA_EXCEPT_AUDIT


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


HNA_RECONCILE_EXCEPT



Column Section Top of Page


Table-level Detail

Description: hna_reconcile_except
Definition: Stores the values that are excluded from reconcile.
Table Type: REFERENCE





Column Detail - HNA_RECONCILE_EXCEPT


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 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_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.
EXCEPTION_TYPE_CD DOUBLE N Type of Exception (ex. lname, fname, alias, dob)
EXCEPT_DT_TM DATETIME Y Date and Time Field that hold a date if the exception type is date of birth (DOB)
EXCEPT_GROUP_ID DOUBLE N This id groups exceptions together so that multiple rows will act like one exception. (ex. fname = John lname = Doe SSN = 999999999" ) It is an internal system assigned number.
EXCEPT_TEXT VARCHAR(100) Y The Field where the text is stored for each exception. (ex. If the exception was lname = doe then the except_text field would equal "DOE".)
GROUP_NAME VARCHAR(100) Y Name give by the creator of the exception
HNA_RECONCILE_EXCEPT_ID DOUBLE N This is the value of the unique primary identifier of the hna_reconcile_except table. It is an internal system assigned number.
POST_FLAG DOUBLE Y Future ESI functionality.
RECONCILE_FLAG DOUBLE Y Determines if the exception is going to exclude person matching the exception from person reconcile.
TEST_FLAG DOUBLE Y Distinguishes between a test exception and a non-test exception. A test exception will be updated when you change the exception. A non-test exception will inactivate the old exception and create a new exception.
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.


PERSON



Column Section Relationship Section Top of Page


Table-level Detail

Description: Person
Definition: The person table contains all persons in the system. A row in the person table may or may not represent a person who is a patient and/or personnel (i.e., doctor, nurse, etc.).
Table Type: ACTIVITY





Column Detail - PERSON


Column Name Type Null? Definition
ABS_BIRTH_DT_TM DATETIME Y The birth date/time "as entered" during registration. The date/time data in this field is "local" when the database is running in "UTC mode" and it is typically not populated (NULL) when the database is running in "local mode." This field is used for querying purposes only and helps eliminate edge cases where records fail to qualify because the user performing the search is in a different time zone than the patient.
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.
AGE_AT_DEATH DOUBLE N The age of the person when they became deceased.
AGE_AT_DEATH_PREC_MOD_FLAG DOUBLE N Precision modifier used to represent the precision of the age of death. A flag of 0 means unknown. 1 - The age is less than the stated age of death. 2 - The age is greater than the stated age of death. 3 - The stated age of death is approximated. 4 - The stated age of death is exact.
AGE_AT_DEATH_UNIT_CD DOUBLE N The unit of measurement for the age at death. (Years, Months, Days or Hours)
ARCHIVE_ENV_ID DOUBLE N This column will indicate the environment_id that contains the data for this person. This column will be 0 for persons that have not been archived.
ARCHIVE_STATUS_CD DOUBLE N This column will indicate the archive status for this person. It will use a new code set that is not yet created.
ARCHIVE_STATUS_DT_TM DATETIME Y This column will indicate the last time this person was involved in an archive or restore.
AUTOPSY_CD DOUBLE N Indicates whether an autopsy has been performed on this 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_DT_CD DOUBLE N Birth date code indicates the kind of birth date and time value that is contained in the birth_dt_tm field. (i.e., estimated, still born, unknown, etc.)
BIRTH_DT_TM DATETIME Y The date and time of birth for the person.
BIRTH_PREC_FLAG DOUBLE Y Used to denote what information was captured for birth date and time. A flag of 0 means the date is precise to the day, a flag of 1 means the date is precise to the full date and time, a flag of 2 means the date is precise to month and a flag of 3 means the date is precise to year.
BIRTH_TZ DOUBLE Y Time zone associated with the corresponding DT_TM column.
CAUSE_OF_DEATH VARCHAR(100) Y This is a text description of what caused the death of the person.
CAUSE_OF_DEATH_CD DOUBLE N This is a codified value of what caused the death of the person.
CITIZENSHIP_CD DOUBLE N Identifies the citizenship status for a person.
CONCEPTION_DT_TM DATETIME Y The date and time the person was conceived in the mother's womb.
CONFID_LEVEL_CD DOUBLE N Confidential level identifies a level of security that may restrict access or release of information.
CONFID_LEVEL_SOURCE_CD DOUBLE Y Defines the source that provided the confidentiality level information concerning a 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.
CREATE_DT_TM DATETIME Y This is the date and time that a row is created in the person table.
CREATE_PRSNL_ID DOUBLE N This is the person/personnel responsible for creating a row in the person table.
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.
DECEASED_CD DOUBLE N Identifies if the person is deceased.
DECEASED_DT_TM DATETIME Y The date and time of death for the person.
DECEASED_DT_TM_PREC_FLAG DOUBLE N Used to denote the precision of the deceased date and time. 0 - Precision is unknown. 1 - Date is precise to the full date and time. 2 - Date is precise to the month. 3 - Date is precise to the year. 4 - Date is precise to the day.
DECEASED_ID_METHOD_CD DOUBLE N Stores code values defining the specific way a patient was confirmed as being deceased. Possible values include Death Certificate, Physician Reported, etc. The code values are closely tied, workflow-wise, to the Deceased_Source_Cd which records if a patient was identified as being deceased from a Formal (Death Certificate) or Informal (no Death Certificate) source and the Deceased_Notify_Source_Cd which records who\ what provided the information regarding the patient's deceased status.
DECEASED_NOTIFY_SOURCE_CD DOUBLE Y Defines the particular source that gave notification regarding the deceased information concerning a person. For example, from a Government Agency Record, Inpatient Death, or Other.
DECEASED_SOURCE_CD DOUBLE N Defines the particular source that gave deceased information concerning a person. For example, from a Formal (Death Certificate) or Informal (no Death Certificate) source.
DECEASED_TZ DOUBLE N The time zone where the deceased date was entered.
EMANCIPATION_DT_TM DATETIME Y The date and time when the person was emancipated.
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.
ETHNIC_GRP_CD DOUBLE N Identifies a religious, national, racial, or cultural group of the person.
FT_ENTITY_ID DOUBLE N Used to identify the ID of the free textentity which this free textperson row is associated with.
FT_ENTITY_NAME VARCHAR(32) Y Name of the entity for which this free textperson row is associated.
LANGUAGE_CD DOUBLE N The primary language spoken by the person.
LANGUAGE_DIALECT_CD DOUBLE N The dialect of the primary language spoken by the person.
LAST_ACCESSED_DT_TM DATETIME N This column contains the date/time this person was last accessed. It affects when the person will be archived when archiving is active.
LAST_ENCNTR_DT_TM DATETIME Y The date and time of the last encounter for the person.
LOGICAL_DOMAIN_ID DOUBLE N The unique identifier for a logical domain. This identifier allows the data to be grouped by logical domain. For example, If you assign clients a logical_domain_id this would allow you to store data for multiple clients on this table.
MARITAL_TYPE_CD DOUBLE N This field identifies the status of the person with regard to being married.
MILITARY_BASE_LOCATION VARCHAR(100) Y The location of the military base at which the person is stationed.
MILITARY_RANK_CD DOUBLE N Military ranking of individual (i.e. Private, Seargent, General, etc.)
MILITARY_SERVICE_CD DOUBLE N Military status of an individual (i.e. Active Duty, Reserves, etc.)
MOTHER_MAIDEN_NAME VARCHAR(100) Y The mother's last name she was given at birth.
NAME_FIRST VARCHAR(200) Y This is the person's given first name.
NAME_FIRST_KEY VARCHAR(100) Y This is the person's first given name all capitals with punctuation removed. This field is used for indexing and searching for a person by name.
NAME_FIRST_KEY_A_NLS VARCHAR(400) Y NAME_FIRST_KEY_A_NLS column
NAME_FIRST_KEY_NLS VARCHAR(202) Y First Name Key field converted to NLS format for internationalization requirements
NAME_FIRST_PHONETIC VARCHAR(8) Y Phonetic representation of person's first name.
NAME_FIRST_SYNONYM_ID DOUBLE N First Name Synonym Id
NAME_FULL_FORMATTED VARCHAR(100) Y This is the complete person name including punctuation and formatting.
NAME_LAST VARCHAR(200) Y This is the person's family name.
NAME_LAST_KEY VARCHAR(100) Y This is the person's family name all capitals with punctuation removed. This field is used for indexing and searching for a person by name.
NAME_LAST_KEY_A_NLS VARCHAR(400) Y NAME_LAST_KEY_A_NLS column
NAME_LAST_KEY_NLS VARCHAR(202) Y Last Name Key field converted to NLS format for internationalization requirements
NAME_LAST_PHONETIC VARCHAR(8) Y Phonetic representation of person's last name.
NAME_MIDDLE VARCHAR(200) Y This is the given middle name for the person.
NAME_MIDDLE_KEY VARCHAR(100) Y This is the person's middle name with all capitals with punctuation removed. This field is used for indexing and searching for a person by name.
NAME_MIDDLE_KEY_A_NLS VARCHAR(400) Y NAME_MIDDLE_KEY_A_NLS column
NAME_MIDDLE_KEY_NLS VARCHAR(202) Y Last Name Key field converted to NLS format for internationalization requirements
NAME_PHONETIC CHAR(8) Y This is the Soundex coded representation of the person's name. This field is used for indexing and searching for a patient by name when the exact spelling is not known.
NATIONALITY_CD DOUBLE N This field Identifies the nationality associated with the person.
NEXT_RESTORE_DT_TM DATETIME Y This column contains the date/time when this person needs to be restored from archive.
PERSONAL_PRONOUN_CD DOUBLE Y The person's desired personal pronouns to use as a simple substitue for their proper name that they feel best represents their gender identity. Examples may include She/Her/Hers, He/Him/His,They/Them/Theirs, etc.
PERSONAL_PRONOUN_OTHER_TXT VARCHAR(100) Y The other personal pronoun text of the person when the person's personal pronoun code is OTHER.
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_STATUS_CD DOUBLE N The current status of the person
PERSON_TYPE_CD DOUBLE N The person type field identifies the general type of data being stored in a given person row. As a general guideline, most rows in the person table will be identified with a person type of PERSON. This field can be used to filter out NON-PERSON rows.
PURGE_OPTION_CD DOUBLE N OBSOLETE: Purge Option Code Value
RACE_CD DOUBLE N A group of people classified together on the basis of common history, nationality, or geographical distribution.
RELIGION_CD DOUBLE N A particular integrated system of belief in a supernatural power.
RESIDENT_CD DOUBLE N Identifies the resident status for a person.
SEX_AGE_CHANGE_IND DOUBLE Y This field indicates that the sex of the person has changed as the result of a correction of the data or actual physical change to the person.
SEX_CD DOUBLE N The sex/gender that the patient is considered to have for administration and record keeping purposes. This is typically asserted by the patient when they present to administrative users. This may not match the biological sex as determined by anatomy or genetics, or the individual's preferred identification (gender identity).
SPECIES_CD DOUBLE N A fundamental category of taxonomic classification, ranking after a genus and consisting of organisms capable of interbreeding.
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.
VET_MILITARY_STATUS_CD DOUBLE N Identifies the military status of a service veteran.
VIP_CD DOUBLE N Identifies and used to communicate that the person is identified as deserving special consideration during the stay or visit. A security level (confid_level_cd) may or may not be implied by a V.I.P. code. Examples include employee, famous person, etc.



Relationship Detail - PERSON


Child Column in PERSON(FK) Parent Table Name Parent Column Name
Parents: LOGICAL_DOMAIN_ID LOGICAL_DOMAIN LOGICAL_DOMAIN_ID




Parent Column in PERSON (PK) Child Table Name Child Column Name
Children: PERSON_ID ABSTRACTING PERSON_ID
ABSTRACT_DATA PERSON_ID
ABST_CODING_RELTN PERSON_ID
ACCT_BALANCE PERSON_ID
ACTIVITY_DATA_RELTN PERSON_ID
ACT_PW_COMP PERSON_ID
ACUTE_CARE_AUDIT_INFO AUDIT_PATIENT_ID
AC_CLASS_PERSON_RELTN PERSON_ID
ALERT_AUDIT_TRANSACTION PERSON_ID
ALLERGY PERSON_ID
ALLERGY_EXT_DATA CMB_PERSON_ID
ALLERGY_EXT_DATA PERSON_ID
AOAV_CONDITION PERSON_ID
AOAV_PERSON_ENCNTR PERSON_ID
APPLICATION_GROUP PERSON_ID
AP_EXT_DATA PERSON_ID
AP_FT_EVENT PERSON_ID
AP_QA_INFO PERSON_ID
ASSIGN PERSON_ID
AUTHORIZATION PERSON_ID
AUTO_DIRECTED PERSON_ID
AV_STATUS_EVENT PERSON_ID
BATCH_TRANS_FILE GUARANTOR_PERSON_ID
BBHIST_PRODUCT_EVENT PERSON_ID
BB_EDN_PRODUCT PERSON_ID
BB_EXCEPTION PERSON_ID
BB_SPEC_EXPIRE_OVRD PERSON_ID
BB_UPLOAD_REVIEW PERSON_ID
BCE_EVENT_LOG ACTIVE_STATUS_PRSNL_ID
BCE_EVENT_LOG PERSON_ID
BH_GROUP_DOC_PATIENT PERSON_ID
BLOOD_BANK_COMMENT PERSON_ID
BLOOD_PRODUCT DONOR_PERSON_ID
BMDI_ACQUIRED_DATA_TRACK PERSON_ID
BMDI_ACQUIRED_RESULTS PERSON_ID
BMDI_ASSOCIATION_HINTS PERSON_ID
CAC_DOCUMENT PERSON_ID
CBOS_PERSON_RELTN PERSON_ID
CDI_TRANS_LOG PERSON_ID
CE_AUDIT_LOG PERSON_ID
CE_DYNAMIC_LABEL PERSON_ID
CE_EVENT_ACTION PERSON_ID
CE_EVENT_MODIFIER MODIFIER_VALUE_PERSON_ID
CE_EVENT_PRSNL PERSON_ID
CE_EVENT_PRSNL RECEIVING_PERSON_ID
CE_FLAGGED_RESULT PERSON_ID
CE_GROUPING_QUEUE PERSON_ID
CE_INTAKE_OUTPUT_RESULT PERSON_ID
CE_IO_TOTAL_RESULT PERSON_ID
CE_MED_RESULT ADMIN_PROV_ID
CHARGE PERSON_ID
CHARGE_EVENT PERSON_ID
CHART_ENCNTR_DISCHARGE PERSON_ID
CHART_PROCESS PERSON_ID
CHART_REQUEST PERSON_ID
CHART_TEMP PERSON_ID
CLINICAL_EVENT PERSON_ID
CN_DCP_SHIFT_ASSIGNMENT_ST PERSON_ID
CN_DCP_SHIFT_ASSIGNMENT_ST RELATED_PERSON_ID
CODING PERSON_ID
CODING_AUDIT PERSON_ID
CODING_HIST PERSON_ID
CODING_SPECIALTY PERSON_ID
COMPLETION_HOLD PERSON_ID
CONCEPT_PRSNL_CROSSMAP PERSON_ID
CONDITION_PRIORITY PERSON_ID
CONDITION_SUMMARY PERSON_ID
CONSENT CONSENT_GIVEN_PERSON_ID
CONSENT PERSON_ID
CONSENT_PATIENTSYNC_AUDIT PERSON_ID
CONS_BO_SCHED PERSON_ID
CORRECTED_PRODUCT PERSON_ID
CP_PATHWAY_ACTIVITY PERSON_ID
CREDIT_CARD_RELTN PERSON_ID
CROSSMATCH PERSON_ID
CR_REPORT_REQUEST PERSON_ID
CR_XML_DOC_REQUEST PERSON_ID
CSA_USER_AGREEMENT_ACK PERSON_ID
CS_CPP_ERROR_LOG PERSON_ID
CS_CPP_UNDO PERSON_ID
CT_PROT_PRESCREEN_JOB_INFO PERSON_ID
CT_PT_PROT_BATCH_LIST PERSON_ID
CT_PT_SETTINGS PERSON_ID
CT_REASON_DELETED PERSON_ID
CT_USER_DOMAIN_INFO PERSON_ID
CUSTOM_PT_LIST_ENTRY PERSON_ID
CV_CASE PERSON_ID
CV_PROC PERSON_ID
CV_PROC_HX PERSON_ID
CV_STG_METADATA PERSON_ID
CW_DATA_CACHE PERSON_ID
DCP_FORMS_ACTIVITY PERSON_ID
DCP_MP_PL_CUSTOM_ENTRY PERSON_ID
DCP_PL_CUSTOM_ENTRY PERSON_ID
DCP_PL_PRIORITIZATION PERSON_ID
DCP_SHIFT_ASSIGNMENT PERSON_ID
DCP_SHIFT_ASSIGNMENT RELATED_PERSON_ID
DD_CONTRIBUTION PERSON_ID
DD_SDOC_SECTION PERSON_ID
DIAGNOSIS PERSON_ID
DIAGNOSIS_HIST PERSON_ID
DM_XNTR_JOB PERSON_ID
DM_XNT_JOB_LOG_DTL PERSON_ID
DOCUMENT_QUALITY_REVIEW PERSON_ID
DOC_TRANSCRIPTION_QUEUE PERSON_ID
DOSING_WEIGHT PERSON_ID
DQR_DOCUMENT_ACTION PERSON_ID
DRG PERSON_ID
DRG_ENCNTR_EXTENSION PERSON_ID
DRG_SPECIALTY PERSON_ID
DSM_ASSESSMENT PERSON_ID
DTS_TRANS_STATS PATIENT_ID
EEM_ABN_CHECK PERSON_ID
EEM_ABN_LINK PERSON_ID
EEM_ADDRESS_DETAIL PERSON_ID
EEM_AUTH_DETAIL DEP_PERSON_ID
EEM_AUTH_DETAIL SUB_PERSON_ID
EEM_COVERAGE_DETAIL PERSON_ID
EEM_DEMOG_DETAIL PERSON_ID
EEM_ELIG_DETAIL PAT_PERSON_ID
EEM_ELIG_DETAIL SUB_PERSON_ID
EEM_MOH_DETAIL PERSON_ID
EEM_NEWBORN_DETAIL PERSON_ID
EEM_RX_ELIG_DETAIL PERSON_ID
EEM_RX_MED_HIST_DETAIL PERSON_ID
EHI_QUEUE_PERSON_RELTN PERSON_ID
EI_ELIGIBLE_SERVICE PERSON_ID
EI_INTERMEDHX_TRANSACTION PERSON_ID
EKS_ADVSR_EVENT PERSON_ID
EKS_ALERT_ESCALATION PERSON_ID
EKS_ALERT_ESC_HIST PERSON_ID
EKS_DLG_EVENT PERSON_ID
EKS_MODULE_AUDIT_DET PERSON_ID
EMPI_CACHE_UPDATE_QUEUE PERSON_ID
EMPI_PROCESS_LOG PERSON_ID
ENCNTR_DOMAIN PERSON_ID
ENCNTR_EVENT_SET_IO PERSON_ID
ENCNTR_FINANCIAL PERSON_ID
ENCNTR_FLEX_HIST PERSON_ID
ENCNTR_PERSON_RELTN RELATED_PERSON_ID
ENCNTR_PLAN_RELTN PERSON_ID
ENCOUNTER PERSON_ID
EPA_RECORD PERSON_ID
EPISODE PERSON_ID
ESI_LOG PERSON_ID
EXAM_DATA PERSON_ID
EXPEDITE_MANUAL PERSON_ID
EXT_DATA_GROUP PERSON_ID
EXT_DATA_INFO PERSON_ID
EXT_REQ_STATUS PERSON_ID
FAMILY_RELATION_EXCEPTION PERSON_ID
FAMILY_RELATION_EXCEPTION SUGGESTED_RELATED_PERSON_ID
FHX_ACTIVITY PERSON_ID
FHX_ACTIVITY RELATED_PERSON_ID
FILL_PRINT_ORD_HX PERSON_ID
FN_OMF_ENCNTR PERSON_ID
FOLDER PERSON_ID
FOREIGN_FOLDER PERSON_ID
GEN_LAB_EXT_DATA PERSON_ID
GS_MED_CLAIM PERSON_ID
HANDHELD_DETAIL PERSON1_ID
HANDHELD_DETAIL PERSON2_ID
HAPLOTYPE_CHART PERSON_ID
HAPLOTYPE_DONOR PERSON_ID
HCM_COMM_EVENT CONTACTED_PERSON_ID
HCM_COMM_EVENT PERSON_ID
HCM_COMM_EVENT_H CONTACTED_PERSON_ID
HCM_COMM_EVENT_H PERSON_ID
HEALTH_CONCERN PERSON_ID
HIM_PV_CHART PERSON_ID
HIM_PV_DOCUMENT PERSON_ID
HIM_REQUEST_CRITERIA PERSON_ID
HIM_REQUEST_PATIENT PERSON_ID
HIM_UNSIGNED_ORDERS PERSON_ID
HISTORY_ACTION PERSON_ID
HIS_OBSERVATION PERSON_ID
HLA_ORDER_LOCK PERSON_ID
HLA_SERA_QUERY_SERUM PERSON_ID
HLA_XM_RES_TRAY DONOR_ID
HLA_X_SPECIMEN_ANALYSIS PERSON_ID
HM_EXPECT_MOD PERSON_ID
HM_EXPECT_MOD_HIST PERSON_ID
HM_PERSON_NOTIFICATION PERSON_ID
HM_RECOMMENDATION PERSON_ID
HNA_EXCEPT_AUDIT PERSON_ID
HOLD_QUEUE PERSON_ID
IB_RX_REQ_ACTION PROPOSED_PERSON_ID
ICLASS_PERSON_RELTN PERSON_ID
IMMUNIZATION_EXT_DATA PERSON_ID
IMMUNIZATION_MODIFIER CONSENT_PERSON_ID
IMMUNIZATION_MODIFIER PERSON_ID
IMMUNIZATION_OBSERVATION PERSON_ID
IMPLANT_HISTORY PERSON_ID
IM_U_NOTIFY PERSON_ID
INVTN_COMMUNICATION PERSON_ID
INVTN_INVITATION PERSON_ID
INVTN_INVITATION_ACTION PERSON_ID
IO_DEVICE_INTERRUPT PERSON_ID
IO_TOTAL_START_TIME PERSON_ID
LAB_EXT_IDENTIFIER PERSON_ID
LH_CNT_IC_PATIENT_POP PERSON_ID
LH_CNT_IC_PATIENT_POP_TAGS PERSON_ID
LH_CNT_IC_VAE PERSON_ID
LH_CNT_LTD_DATA PERSON_ID
LH_CNT_PATIENT_EXTENSION PERSON_ID
LH_CNT_READMIT_WORKLIST PERSON_ID
LH_CNT_WL_POP PERSON_ID
LH_CNT_WL_POP_H PERSON_ID
LINE_ITEM PERSON_ID
MAMMO_STUDY PERSON_ID
MARS_SUITE_RESPONSE PERSON_ID
MEDIA_ENCNTR_RELTN PERSON_ID
MEDIA_EXAM PERSON_ID
MEDIA_MASTER PERSON_ID
MED_ADMIN_INGREDIENT_META PERSON_ID
MED_ADMIN_MED_ERROR PERSON_ID
MED_ADMIN_PT_ERROR EXPECTED_PT_ID
MED_ADMIN_PT_ERROR IDENTIFIED_PT_ID
MED_ADMIN_RECORD PERSON_ID
MED_HISTORY_AUDIT PERSON_ID
MED_HISTORY_STATUS PERSON_ID
MESSAGING_AUDIT PERSON_ID
MESSAGING_FAVORITES PERSON_ID
MESSAGING_NOTIFY ASSIGN_PERSON_ID
MIC_ACT_ANG_SUM_RPT PERSON_ID
MIC_EXT_DATA PERSON_ID
MIC_IC_ORDERS PERSON_ID
MIC_STAT_ORDER PERSON_ID
MM_SUPPLY_CABINET PERSON_ID
MM_TRANS_HEADER TRANS_PERSON_ID
MM_TRANS_LINE PATIENT_ID
MP_NOTIFICATION PERSON_ID
MP_PRIMED_VIEW_ACT PERSON_ID
MP_PRIMED_VIEW_POP PERSON_ID
NC_CHARTED_SECTION PATIENT_ID
NC_CHARTED_VIEW PATIENT_ID
NOMENCLATURE_ENCNTR_DESC PERSON_ID
NOMEN_ENTITY_RELTN PERSON_ID
OMF_ABSTRACT_DATA_ST PERSON_ID
OMF_ABST_CODING_RELTN_ST PERSON_ID
OMF_CHARGE_ST PERSON_ID
OMF_CLINICAL_EVENT_ST PERSON_ID
OMF_ENCNTR_ST OTHER_INS_PERSON_ID
OMF_ENCNTR_ST PERSON_ID
OMF_ENCNTR_ST PRIM_INS_PERSON_ID
OMF_ENCNTR_ST SEC_INS_PERSON_ID
OMF_ENCNTR_TYPE_HIST_ST PERSON_ID
OMF_ORDER_ST PERSON_ID
OMF_POSTED_CHARGE_ST PERSON_ID
OMF_PRSNL_PAYPERIOD_ST PERSON_ID
OMF_PRSNL_TIMEDATE_ST PERSON_ID
OMF_RADMGMT_ORDER_ST PATIENT_ID
ONC_ADHOC_PLAN PERSON_ID
ONC_FORM_ACTIVITY PERSON_ID
ONC_II_AUTO_ACTIVITY PERSON_ID
ONC_INFUSION_ACTIVITY PERSON_ID
ONC_TC_CAL_ITEMS PERSON_ID
ORDERS PERSON_ID
ORDER_DAILY_REVIEW_RSPNL PERSON_ID
ORDER_DISPENSE PERSON_ID
ORDER_PROPOSAL PERSON_ID
ORDER_RADIOLOGY PERSON_ID
ORDER_RECON PERSON_ID
ORDER_RX_SCRATCHPAD PERSON_ID
ORDER_STAGING PERSON_ID
ORDER_TRACKING_WORKLIST PATIENT_ID
ORM_ERROR_LOG PERSON_ID
ORM_ORD_HIST_SNAPSHOT PATIENT_ID
OUTCOME_ACTIVITY PERSON_ID
PASSIVE_ALERT PERSON_ID
PATHOLOGY_CASE PERSON_ID
PATHWAY PERSON_ID
PATIENT_CASE PERSON_ID
PATIENT_DISPENSE PERSON_ID
PATIENT_EVENT PERSON_ID
PAT_ED_DOCUMENT PERSON_ID
PCA_ENCNTR_MEASURE_OUTCOME PERSON_ID
PCA_ENCNTR_TOPIC_RELTN PERSON_ID
PCA_PERSON_MEASURE_OUTCOME PERSON_ID
PCA_PERSON_TOPIC_RELTN PERSON_ID
PCT_IPASS PERSON_ID
PDOC_AUTOSAVE PATIENT_ID
PERSON_ABORH PERSON_ID
PERSON_ABORH_RESULT PERSON_ID
PERSON_ALIAS PERSON_ID
PERSON_ALIAS_HIST PERSON_ID
PERSON_ANTIBODY PERSON_ID
PERSON_ANTIGEN PERSON_ID
PERSON_CODE_VALUE_R PERSON_ID
PERSON_CODE_VALUE_R_HIST PERSON_ID
PERSON_COMBINE FROM_PERSON_ID
PERSON_COMBINE TO_PERSON_ID
PERSON_COMBINE_BATCH FROM_PERSON_ID
PERSON_COMBINE_BATCH TO_PERSON_ID
PERSON_DATA_NOT_COLL PERSON_ID
PERSON_DESIGNATION PERSON_ID
PERSON_DISMISSAL PERSON_ID
PERSON_FLEX_HIST PERSON_ID
PERSON_HLA_AB_SCN_AUDIT PERSON_ID
PERSON_HLA_AB_SCREEN PERSON_ID
PERSON_HLA_AB_SPEC PERSON_ID
PERSON_HLA_EVENT PERSON_ID
PERSON_HLA_EVENT_AUDIT PERSON_ID
PERSON_HLA_TYPE PERSON_ID
PERSON_HLA_TYPE_AUDIT PERSON_ID
PERSON_HLA_XM DONOR_ID
PERSON_HLA_XM PERSON_ID
PERSON_HLA_XM_AUDIT DONOR_ID
PERSON_INFO PERSON_ID
PERSON_INFO_HIST PERSON_ID
PERSON_MATCHES A_PERSON_ID
PERSON_MATCHES B_PERSON_ID
PERSON_MATCH_REV A_PERSON_ID
PERSON_MATCH_REV B_PERSON_ID
PERSON_MILITARY PERSON_ID
PERSON_MILITARY_HIST PERSON_ID
PERSON_NAME PERSON_ID
PERSON_NAME_HIST PERSON_ID
PERSON_ORGAN_DONOR PERSON_ID
PERSON_ORG_RELTN PERSON_ID
PERSON_PATIENT PERSON_ID
PERSON_PATIENT_HIST PERSON_ID
PERSON_PERSON_RELTN PERSON_ID
PERSON_PERSON_RELTN RELATED_PERSON_ID
PERSON_PHR_INFO PERSON_ID
PERSON_PHR_INFO_HIST PERSON_ID
PERSON_PLAN_PROFILE PERSON_ID
PERSON_PLAN_RELTN PERSON_ID
PERSON_PORTAL_INVITE PATIENT_PERSON_ID
PERSON_PORTAL_INVITE PERSON_ID
PERSON_PORTAL_INVITE_HIST PATIENT_PERSON_ID
PERSON_PREF PERSON_ID
PERSON_PREFERRED_PHARMACY PERSON_ID
PERSON_PREF_COMM PERSON_ID
PERSON_PREF_PHARMACY_REV PERSON_ID
PERSON_PRSNL_ACTIVITY PERSON_ID
PERSON_PRSNL_ORG_OVERRIDE PERSON_ID
PERSON_PRSNL_RELTN PERSON_ID
PERSON_RH_PHENOTYPE PERSON_ID
PERSON_RH_PHENO_RESULT PERSON_ID
PERSON_RX_PLAN_RELTN PERSON_ID
PERSON_SOCIAL_HEALTHCARE PERSON_ID
PERSON_TRANSPLANT_CANDIDATE PERSON_ID
PERSON_TRANS_REQ PERSON_ID
PERSON_TRIBAL_AFLTN PERSON_ID
PERSON_VETERAN PERSON_ID
PERSON_VETERAN_HIST PERSON_ID
PFT_BALANCE GUARANTOR_PERSON_ID
PFT_BALANCE PERSON_ID
PFT_CHARGE_GLOBAL_DAYS PERSON_ID
PFT_ENCNTR_CODE PERSON_ID
PFT_PRORATION PERSON_ID
PFT_PRSNL_ALIAS PERSON_ID
PFT_QUEUE_ITEM PERSON_ID
PFT_QUEUE_ITEM_HIST PERSON_ID
PFT_REG_MOD GUARANTOR_ID
PFT_SYSTEM_ACTIVITY_LOG PERSON_ID
PFT_TRANSACTION PERSON_ID
PFT_UMDAP PERSON_ID
PHA_DISP_OBS_ST PERSON_ID
PHA_ORD_ACT_OBS_ST PERSON_ID
PHA_PROD_DISP_OBS_ST PERSON_ID
PIE_DWL_LIST_PERSON_R PERSON_ID
PLAN_CONTACT PERSON_ID
PM_DOC_PRINT_HIST PERSON_ID
PM_HIST_TRACKING PERSON_ID
PM_PHY_ACT_HIST PERSON_ID
PM_POST_DOC RELATED_PERSON_ID
PM_POST_PROCESS COMPARISON_PERSON_ID
PM_POST_PROCESS PERSON_ID
PM_ROOM_BED_CHARGE PERSON_ID
PM_SCH_SETUP PERSON_ID
PM_WAIT_LIST PERSON_ID
PM_WAIT_LIST_HIST PERSON_ID
PM_WORK_QUEUE PERSON_ID
PPR_CONSENT_STATUS PERSON_ID
PP_AUDIT_EVENT PERSON_ID
PRECOMPONENT_ORDER_RELTN PERSON_ID
PREGNANCY_CHILD PERSON_ID
PREGNANCY_INFORMATION PERSON_ID
PREGNANCY_INSTANCE PERSON_ID
PRIVILEGE_DELETION PERSON_ID
PROBLEM PERSON_ID
PROBLEM_EXT_DATA PERSON_ID
PROCEDURE_EXT_DATA PERSON_ID
PRODUCT_EVENT PERSON_ID
PROP_ORDER PERSON_ID
PROT_DEFAULT_ROLES PERSON_ID
PRSNL PERSON_ID
PRSNL_RELTN_ACTIVITY PERSON_ID
PT_CONSENT CONSENTING_PERSON_ID
PT_CONSENT PERSON_ID
PT_CONTROL PERSON_ID
PT_ELIG_TRACKING PERSON_ID
PT_INTEREST_COMMENT PERSON_ID
PT_PROT_PRESCREEN PERSON_ID
PT_PROT_PRESCREEN_TEST PERSON_ID
PT_PROT_REG PERSON_ID
PULL_FOLDERS PERSON_ID
PULL_ORD_SCHED PERSON_ID
PULSE_GEN PERSON_ID
PULSE_GEN_ASSOC_HIST PERSON_ID
PVW_DATASET PERSON_ID
PW_PROCESSING_ACTION PERSON_ID
RAD_MEDS PERSON_ID
RAD_REQUEST PERSON_ID
RAD_STG_DATA PERSON_ID
RCA_MOBILE_SESSION PERSON_ID
RCM_DIRECT_COMM PERSON_ID
RCM_NOTE PERSON_ID
RCM_SECURITY_TOKEN PERSON_ID
REFERRAL PERSON_ID
REFERRAL_HIST PERSON_ID
REF_CD_MAP_HEADER PERSON_ID
REGIMEN PERSON_ID
RESULT PERSON_ID
REVIEW_GROUP_RELTN PERSON_ID
ROI_REQUEST PERSON_ID
RVR_CLEANUP_CONFIG LAST_PERSON_ID
RVR_CLEANUP_LOG PERSON_ID
RXS_FOREIGN_DEVICE_ALERT PATIENT_ID
RXS_LOCATOR_ENCNTR PERSON_ID
RXS_ORDER_TASK_QUEUE PERSON_ID
RX_PENDING_REFILL PERSON_ID
RX_PERSON PERSON_ID
RX_REFILL_HX PERSON_ID
RX_WORK_ITEM_QUEUE PERSON_ID
SA_ANESTHESIA_REC_FIELD_VALUES PERSON_ID
SCD_STORY PERSON_ID
SCH_APPT PERSON_ID
SCH_APPT_BOOK OWNER_PERSON_ID
SCH_BOOKING GRANTED_PRSNL_ID
SCH_BOOKING PERSON_ID
SCH_BOOKING RELEASE_PRSNL_ID
SCH_ENTRY PERSON_ID
SCH_EVENT_PATIENT PERSON_ID
SCH_EVENT_RECUR_ROLE PERSON_ID
SCH_LOC_BOOKING PERSON_ID
SCH_MESSAGING PERSON_ID
SCH_PEND_APPT PERSON_ID
SCH_PEND_EVENT PERSON_ID
SCH_USER_LINK PERSON_ID
SCRATCHPAD_SESSION PERSON_ID
SEAL PERSON_ID
SELECTED_RX_FORMULARY PERSON_ID
SHX_ACTIVITY PERSON_ID
SI_CUSTOM_CDG_LOG PERSON_ID
SI_DIRECT_MESSAGE PERSON_ID
SI_DOCUMENT_INFO PERSON_ID
SI_DOCUMENT_METADATA PERSON_ID
SI_DOCUMENT_TRANSACTION_LOG PERSON_ID
SI_ENTITY_UUID PERSON_ID
SI_ERX_DIGITAL_SIG_LOG PERSON_ID
SI_EXT_REGISTRY_RESPONSE PERSON_ID
SI_INTEROP_METADATA PERSON_ID
SI_TRANSACTION PERSON_ID
SI_TRANSACTION_SET PERSON_ID
SI_UNMTCHD_PRSN_QUE PERSON_ID
SI_XDOC_METADATA PERSON_ID
SI_XDOC_QUERY_PERSON_RELTN PERSON_ID
SUBSCRIPTION PERSON_ID
SURGICAL_CASE PERSON_ID
SURG_REQ PERSON_ID
TAG_COLOR PERSON_ID
TASK_ACTIVITY MSG_SENDER_PERSON_ID
TASK_ACTIVITY PERSON_ID
TASK_ACTIVITY_ASSIGNMENT ASSIGN_PERSON_ID
TASK_ACTIVITY_ASSIGN_MSG_H ASSIGN_PERSON_ID
TASK_ACTIVITY_HISTORY PERSON_ID
TASK_ACTIVITY_MSG_H MSG_SENDER_PERSON_ID
TASK_ACTIVITY_MSG_H PERSON_ID
TRACKING_ITEM PERSON_ID
TRACKING_PREARRIVAL ATTACHED_PERSON_ID
TRACK_TRIGGER_ACTIVITY PERSON_ID
TRANSACTION_ADDRESS_VERIFY PERSON_ID
TRANSACTION_ADMIT_NOTIFY PERSON_ID
TRANSACTION_ELIGIBILITY PERSON_ID
TRANSFUSION PERSON_ID
UCM_FAMILY_HISTORY_REVIEW PERSON_ID
UKR_SACT PERSON_ID
UM_CHARGE_EVENT_ST PATIENT_ID
VITALS_EXT_DATA PERSON_ID
WKF_WORKFLOW PERSON_ID
WL_ACTIVITY PERSON_ID
WORKING_VIEW_PERSON PERSON_ID


PERSON_ALIAS



Column Section Relationship Section Top of Page


Table-level Detail

Description: Person Alias
Definition: The person alias table contains information used to identify a person (i.e., medical record number, social security, etc.). There can be many rows in the person alias table that are related to a singlerow in the person table.
Table Type: ACTIVITY





Column Detail - PERSON_ALIAS


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.
ALIAS VARCHAR(200) N The alias is an identifier (I.e., SSN, medical record number, etc.) for a person. The alias may be unique or non-unique depending on the type of alias.
ALIAS_EXPIRY_DT_TM DATETIME Y The date and time for which the alias is expired.
ALIAS_POOL_CD DOUBLE N Alias pool code identifies a unique set or list of person identifiers (I.e., numbers). The alias pool code also determines the accept/display format for the unique set of identifiers.
ASSIGN_AUTHORITY_SYS_CD DOUBLE N This field identifies whether the ESI Server received a Person_Alias that was configured for Hold.
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.
CHECK_DIGIT DOUBLE Y This is the value of the check digit calculated according to the check_digit_method_cd. If the check digit is stored as part of the alias number, which is typical, then the check digit field may be NULL.
CHECK_DIGIT_METHOD_CD DOUBLE N The check digit method code identifies a specific routine, using the alias field, to calculate a check digit.
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 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.
HEALTH_CARD_EXPIRY_DT_TM DATETIME Y The date and time for which this health card becomes ineffective or expired.
HEALTH_CARD_ISSUE_DT_TM DATETIME Y The date and time for which this health card becomes effective or issued.
HEALTH_CARD_PROVINCE CHAR(3) Y Province in which the health card was issued with this alias was issued for a person.
HEALTH_CARD_TYPE VARCHAR(32) Y Type of health card which has a certain category or style.
HEALTH_CARD_VER_CODE CHAR(3) Y The latest recorded version of the health card with the associated alias value.
PERSON_ALIAS_ID DOUBLE N This is the value of the unique primary identifier of the person alias table. It is an internal system assigned number.
PERSON_ALIAS_RECORD_STATUS_CD DOUBLE N Defines the current state of this person alias record.
PERSON_ALIAS_STATUS_CD DOUBLE N Defines the current verification status of this person alias.
PERSON_ALIAS_SUB_TYPE_CD DOUBLE N Person alias sub type code identifies a category within a particular person alias type code. For example, NAME is an alias type and MAIDEN is an alias sub type.
PERSON_ALIAS_TYPE_CD DOUBLE N Person alias type code identifies a kind or type of alias (i.e., SSN, MRN, Financial Number, Community MRN, etc.). They have Cerner pre-defined meanings in the common data foundation table allowing HNA applications to look for a specific kind of alias.
PERSON_ID DOUBLE N This is the value of the unique primary identifier of the person 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.
VISIT_SEQ_NBR DOUBLE Y Value used to track the number of encounters that have been created using the particular alias.



Relationship Detail - PERSON_ALIAS


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




Parent Column in PERSON_ALIAS (PK) Child Table Name Child Column Name
Children: PERSON_ALIAS_ID MEDIA_MASTER PERSON_ALIAS_ID
PERSON_ORGAN_DONOR INTL_ALIAS_ID
PERSON_ORGAN_DONOR NMDP_ALIAS_ID
PERSON_ORGAN_DONOR OPO_ALIAS_ID
PERSON_ORGAN_DONOR UNOS_ALIAS_ID
PERSON_TRANSPLANT_CANDIDATE HIC_ALIAS_ID
PERSON_TRANSPLANT_CANDIDATE NMDP_ALIAS_ID
PERSON_TRANSPLANT_CANDIDATE OPO_ALIAS_ID
PERSON_TRANSPLANT_CANDIDATE PX_ALIAS_ID


PERSON_ALIAS_HIST



Column Section Relationship Section Top of Page


Table-level Detail

Description: Person Alias History Table
Definition: Used for tracking history of changes to person aliases.
Table Type: ACTIVITY





Column Detail - PERSON_ALIAS_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.
ALIAS VARCHAR(200) N The alias is an identifier (I.e., SSN, medical record number, etc.) for a person. The alias may be unique or non-unique depending on the type of alias.
ALIAS_EXPIRY_DT_TM DATETIME Y The date and time for which the alias is expired.
ALIAS_POOL_CD DOUBLE N Alias pool code identifies a unique set or list of person identifiers (i.e., numbers). the alias pool code also determines the accept/display format for the unique set of identifiers.
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.
CHANGE_BIT DOUBLE N Identifies which columns have had a change.
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 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.
HEALTH_CARD_EXPIRY_DT_TM DATETIME Y The date and time for which this health card becomes ineffective or expired.
HEALTH_CARD_ISSUE_DT_TM DATETIME Y The date and time for which this health card becomes effective or issued.
HEALTH_CARD_PROVINCE VARCHAR(3) Y Province in which the health card was issued with this alias was issued for a person.
HEALTH_CARD_TYPE VARCHAR(32) Y Type of health card which has a certain category or style.
HEALTH_CARD_VER_CODE VARCHAR(3) Y The latest recorded version of the health card with the associated alias value.
PERSON_ALIAS_HIST_ID DOUBLE N This is the value of the unique primary identifier of the person_alias_hist table. It is an internal system assigned number.
PERSON_ALIAS_ID DOUBLE N This is the value of the unique primary identifier of the person alias table. It is an internal system assigned number.
PERSON_ALIAS_RECORD_STATUS_CD DOUBLE N Defines the current state of this person alias record.
PERSON_ALIAS_STATUS_CD DOUBLE N Defines the current verification status of this person alias.
PERSON_ALIAS_SUB_TYPE_CD DOUBLE N Person slias sub type code identifies a category within a particular person alias type code. For example, NAME is an alias type and MAIDEN is an alias sub type.
PERSON_ALIAS_TYPE_CD DOUBLE N person alias type code identifies a kind or type of alias (i.e., ssn, mrn, financial number, community mrn, etc.). they have Cerner pre-defined meanings in the common data foundation table allowing hna applications to look for a specific kind of alias.
PERSON_ID DOUBLE N This is the value of the unique primary identifier of the person table. It is an internal system assigned number.
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 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.
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_ALIAS_HIST


Child Column in PERSON_ALIAS_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