Table Detail Report

PERSON_INFO_HIST



Column Section Relationship Section Top of Page


Table-level Detail

Description: PERSON INFO HIST
Definition: Tracks modifications to history elements for a given person_info table.
Table Type: ACTIVITY





Column Detail - PERSON_INFO_HIST


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 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.
CHARTABLE_IND DOUBLE N Determines whether this Person Level comment can be charted
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.
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.
INFO_SUB_TYPE_CD DOUBLE Y Information Sub Type Cd
INFO_TYPE_CD DOUBLE N Information Type Code Value
INTERNAL_SEQ DOUBLE Y Internal Person Management sequence
LONG_TEXT_ID DOUBLE N A foreign key to the long_text table. ties a long_text row (such as a comment) to this table. person_info_hist_id becomes the parent_entity_id on the long_text table, and "person_info_hist" becomes the parent_entity_name.
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_INFO_HIST_ID DOUBLE N This is the value of the unique primary identifier of the person_info_hist table. It is an internal system assigned number.
PERSON_INFO_ID DOUBLE N FK from the Person_Info 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.
PRIORITY_SEQ DOUBLE Y Identifies a sequencing priority to be used when a duplicate relationship of the same type are created.
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.
VALUE_CD DOUBLE Y Stores historical values of type double from the parent table
VALUE_DT_TM DATETIME Y If the comment is of a date type, it is stored in this attribute
VALUE_LONG_TEXT_ID DOUBLE N This is the value of the unique primary identifier of the long_text table. It is an internal system assigned number.
VALUE_NUMERIC DOUBLE Y If the comment is of a numeric type, it is stored in this attribute.
VALUE_NUMERIC_IND DOUBLE N Indicates whether or not the input from the front end tool for column value_number is 0 or null.
VALUE_TYPE DOUBLE N ** obsolete ** This column is no longer being used. This field holds the indicator as to what type of user defined information is in the row.(1 -text , 2 - coded, 3 - data/time, 4 - indicator, 5 - numeric) ** obsolete **



Relationship Detail - PERSON_INFO_HIST


Child Column in PERSON_INFO_HIST(FK) Parent Table Name Parent Column Name
Parents: LONG_TEXT_ID LONG_TEXT LONG_TEXT_ID
PERSON_ID PERSON PERSON_ID
PERSON_INFO_ID PERSON_INFO PERSON_INFO_ID
PM_HIST_TRACKING_ID PM_HIST_TRACKING PM_HIST_TRACKING_ID


PERSON_MATCHES



Column Section Relationship Section Top of Page


Table-level Detail

Description: Person Matches
Definition: The person matches table contains proposed or suggested person matches based on search criteria used to help determine if a person has been entered into the system more than once. It is used as a work queue for performing person data reconciliation.
Table Type: ACTIVITY





Column Detail - PERSON_MATCHES


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.
A_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.
A_ALIAS VARCHAR(200) Y 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.
A_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.
A_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.
A_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.)
A_BIRTH_DT_TM DATETIME Y The date and time of birth for the person.
A_BIRTH_TZ DOUBLE Y Time zone associated with the corresponding DT_TM column.
A_CREATE_PRSNL_ID DOUBLE N This is the person responsible for creating a row in the person table.
A_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.
A_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.
A_NAME_MIDDLE VARCHAR(100) Y This is the person's middle or secondary given name or names.
A_PERSON_ID DOUBLE N This is the value of the unique primary identifier of the person table. It is an internal system assigned number.
A_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.
A_SEX_CD DOUBLE N The gender of the patient (i.e., male, female, unknown).
A_SSN_ALIAS VARCHAR(200) Y The Social Security Number (SSN) alias for 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.
B_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.
B_ALIAS VARCHAR(200) Y 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.
B_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.
B_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.
B_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, unknow, etc.)
B_BIRTH_DT_TM DATETIME Y The date and time of birth for the person.
B_BIRTH_TZ DOUBLE Y Time zone associated with the corresponding DT_TM column.
B_CREATE_PRSNL_ID DOUBLE N This is the person responsible for creating a row in the person table.
B_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.
B_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.
B_NAME_MIDDLE VARCHAR(100) Y This is the person's middle or secondary given name or names.
B_PERSON_ID DOUBLE N This is the value of the unique primary identifier of the person table. It is an internal system assigned number.
B_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.
B_SEX_CD DOUBLE N The gender of the patient (i.e., male, female, unknown).
B_SSN_ALIAS VARCHAR(200) Y The Social Security Number (SSN) alias for the person.
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 Indicates type of exception (ex. Block Reconcile, Open Encounter)
MATCH_DT_TM DATETIME Y The date and time when the potential or proposed person match was identified.
MATCH_SOURCE_CD DOUBLE N Identifies the general method used to identify the proposed person match.
MATCH_STATUS_CD DOUBLE N The current status of the proposed person match (I.e., proposed, review, match, no match, etc.).
MATCH_STATUS_CHG_DT_TM DATETIME Y The date/time when a person match row became pending person match row.
MATCH_STATUS_DT_TM DATETIME Y The date and time a pending match is to be updated.
MATCH_WEIGHT DOUBLE Y A value between 0 and 100 representing the confidence level of the match based on match parameters.
PERSON_MATCHES_ID DOUBLE N This is the person responsible for creating a row in the person matches table.
UPDT_APPLCTX DOUBLE N The application context number from the record info block.
UPDT_CNT DOUBLE N Set to 0 on insert. Incremented by 1 on update. Used to recognize update conflict where data in a row updated by one application is at risk of being lost by a second application attempting to update the row.
UPDT_DT_TM DATETIME N The date and time the row was last inserted or updated.
UPDT_ID DOUBLE N The person_id of the person from the personnel table (prsnl) that caused the last insert or update of the row in the table.
UPDT_TASK DOUBLE N The registered (assigned) task number for the process that inserted or updated the row.



Relationship Detail - PERSON_MATCHES


Child Column in PERSON_MATCHES(FK) Parent Table Name Parent Column Name
Parents: A_PERSON_ID PERSON PERSON_ID
B_PERSON_ID PERSON PERSON_ID




Parent Column in PERSON_MATCHES (PK) Child Table Name Child Column Name
Children: PERSON_MATCHES_ID PERSON_COMBINE_BATCH PERSON_MATCHES_ID


PERSON_MATCH_REV



Column Section Relationship Section Top of Page


Table-level Detail

Description: PERSON MATCH REV desc
Definition: PERSON MATCH REV
Table Type: ACTIVITY





Column Detail - PERSON_MATCH_REV


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.
A_ALIAS1 VARCHAR(200) Y This is the first alias.
A_ALIAS2 VARCHAR(200) Y This is the second alias.
A_ALIAS3 VARCHAR(200) Y This is the third alias.
A_ALIAS_POOL1_CD DOUBLE N The first alias pool code
A_ALIAS_POOL2_CD DOUBLE N The second alias pool code
A_ALIAS_POOL3_CD DOUBLE N The third alias pool code.
A_ALIAS_TYPE1_CD DOUBLE N First alias type code.
A_ALIAS_TYPE2_CD DOUBLE N Second alias type code.
A_ALIAS_TYPE3_CD DOUBLE N Third alias type code.
A_BIRTH_DT_TM DATETIME Y A birth date and time
A_NAME_FIRST_KEY VARCHAR(100) Y A name first key
A_NAME_FULL VARCHAR(100) Y A name full.
A_NAME_LAST_KEY VARCHAR(100) Y A Name Last Key
A_PERSON_ID DOUBLE N a person id
A_SEX_CD DOUBLE N a sex code
B_ALIAS1 VARCHAR(200) Y First b alias.
B_ALIAS2 VARCHAR(200) Y Second b alias
B_ALIAS3 VARCHAR(200) Y Third b alias
B_ALIAS_POOL1_CD DOUBLE N second b alias pool code
B_ALIAS_POOL2_CD DOUBLE N second b alias pool code
B_ALIAS_POOL3_CD DOUBLE N Third b alias pool code.
B_ALIAS_TYPE1_CD DOUBLE N First b alias type code
B_ALIAS_TYPE2_CD DOUBLE N second alias type code
B_ALIAS_TYPE3_CD DOUBLE N Third b alias type code
B_BIRTH_DT_TM DATETIME Y b birth date and time
B_NAME_FIRST_KEY VARCHAR(100) Y b name first key
B_NAME_FULL VARCHAR(100) Y b name full
B_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.
B_PERSON_ID DOUBLE N This is the value of the unique primary identifier of the person table. It is an internal system assigned number.
B_SEX_CD DOUBLE N The gender of the patient (i.e., male, female, unknown).
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.
MATCH_DT_TM DATETIME Y The date and time when the potential or proposed person match was identified.
MATCH_REV_FLAG DOUBLE Y The flag that determines the match rev.
MATCH_VAL1_CD DOUBLE N First match val code
MATCH_VAL2_CD DOUBLE N Second match value code
MATCH_VAL3_CD DOUBLE N third match val code
MATCH_VAL4_CD DOUBLE N forth match val code
MATCH_VAL5_CD DOUBLE N Fifth match val code
MATCH_VAL6_CD DOUBLE N Sixth match val code
MATCH_VAL7_CD DOUBLE N Seventh match val code
MATCH_VAL8_CD DOUBLE N Eighth match val code
PERSON_MATCH_REV_ID DOUBLE N Uniquely identifies a row on the person-match_rev 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 - PERSON_MATCH_REV


Child Column in PERSON_MATCH_REV(FK) Parent Table Name Parent Column Name
Parents: A_PERSON_ID PERSON PERSON_ID
B_PERSON_ID PERSON PERSON_ID


PERSON_MILITARY



Column Section Relationship Section Top of Page


Table-level Detail

Description: Person Military
Definition: The person military table contains various attributes about a person that is a member of the military.
Table Type: ACTIVITY





Column Detail - PERSON_MILITARY


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.
ASSIGNED_UNIT_ORG_ID DOUBLE N The military unit organization to which the military person's placement is relatively permanent. This is the value of the unique primary identifier of the organization table. it is an internal system assigned number.
ATTACHED_UNIT_ORG_ID DOUBLE N The military unit organization to which the military person's placement is relatively temporary.This is the value of the unique primary identifier of the organization table. it is an internal system assigned number.
COMMAND_SECURITY_CD DOUBLE N Represents the special access security program for the military person's command. It informs the user of the service member¿s responsibilities and can impact the care and medications that can be given to the patient. The special access programs require additional security protection, safeguards, and access restrictions which exceed those for regular classified information.
FLYING_STATUS_CD DOUBLE N Represents if the person is authorized and qualified (both technically and medically) for flight.
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.
UPDT_CNT DOUBLE N Set to 0 on insert. Incremented by 1 on update. Used to recognize update conflict where data in a row updated by one application is at risk of being lost by a second application attempting to update the row.
UPDT_DT_TM DATETIME N The date and time the row was last inserted or updated.
UPDT_ID DOUBLE N The person_id of the person from the personnel table (prsnl) that caused the last insert or update of the row in the table.
UPDT_TASK DOUBLE N The registered (assigned) task number for the process that inserted or updated the row.



Relationship Detail - PERSON_MILITARY


Child Column in PERSON_MILITARY(FK) Parent Table Name Parent Column Name
Parents: ASSIGNED_UNIT_ORG_ID ORGANIZATION ORGANIZATION_ID
ATTACHED_UNIT_ORG_ID ORGANIZATION ORGANIZATION_ID
PERSON_ID PERSON PERSON_ID


PERSON_MILITARY_HIST



Column Section Relationship Section Top of Page


Table-level Detail

Description: Person Military History
Definition: Used for tracking changes to the person military table.
Table Type: ACTIVITY





Column Detail - PERSON_MILITARY_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.
ASSIGNED_UNIT_ORG_ID DOUBLE N The military unit organization to which the military person's placement is relatively permanent. This is the value of the unique primary identifier of the organization table. it is an internal system assigned number.
ATTACHED_UNIT_ORG_ID DOUBLE N The military unit organization to which the military person's placement is relatively temporary.This is the value of the unique primary identifier of the organization table. it is an internal system assigned number.
CHANGE_BIT DOUBLE N Identifies which columns have had a change.
COMMAND_SECURITY_CD DOUBLE N Represents the special access security program for the military person's command. It informs the user of the service member¿s responsibilities and can impact the care and medications that can be given to the patient. The special access programs require additional security protection, safeguards, and access restrictions which exceed those for regular classified information.
FLYING_STATUS_CD DOUBLE N Represents if the person is authorized and qualified (both technically and medically) for flight.
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_MILITARY_HIST_ID DOUBLE N Unique generated number that identifies a single row on the PERSON_MILITARY_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.
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_MILITARY_HIST


Child Column in PERSON_MILITARY_HIST(FK) Parent Table Name Parent Column Name
Parents: ASSIGNED_UNIT_ORG_ID ORGANIZATION ORGANIZATION_ID
ATTACHED_UNIT_ORG_ID ORGANIZATION ORGANIZATION_ID
PERSON_ID PERSON PERSON_ID
PM_HIST_TRACKING_ID PM_HIST_TRACKING PM_HIST_TRACKING_ID