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 |
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 |