Table Detail Report

PERSON_NAME



Column Section Relationship Section Top of Page


Table-level Detail

Description: Person Name
Definition: The person name table contains the current name, previous name history, maiden name, and any other alias names for a person.
Table Type: ACTIVITY





Column Detail - PERSON_NAME


Column Name Type Null? Definition
ACTIVE_IND DOUBLE N The table row is active or inactive. A row is generally active unless it is in an inactive state such as logically deleted, combined away, pending purge, etc.
ACTIVE_STATUS_CD DOUBLE N Indicates the status of the row itself (not the data in the row) such as active, inactive, combined away, pending purge, etc.
ACTIVE_STATUS_DT_TM DATETIME N The date and time that the active_status_cd was set.
ACTIVE_STATUS_PRSNL_ID DOUBLE N The person who caused the active_status_cd to be set or change.
BEG_EFFECTIVE_DT_TM DATETIME 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.
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.
NAME_DEGREE VARCHAR(100) Y Is this the same as prefix or suffix?
NAME_FIRST VARCHAR(100) Y This is the person's first given name.
NAME_FIRST_KEY VARCHAR(100) Y First name key.
NAME_FIRST_KEY_A_NLS VARCHAR(400) Y NAME_FIRST_KEY_A_NLS column
NAME_FIRST_KEY_NLS VARCHAR(202) Y First name key (NLS).
NAME_FORMAT_CD DOUBLE N future
NAME_FULL VARCHAR(100) Y This is the complete person name including punctuation, formatting, prefix, and suffix.
NAME_INITIALS VARCHAR(100) Y The three character initial abbreviation of the person's name.
NAME_LAST VARCHAR(100) Y This is the person's family name.
NAME_LAST_KEY VARCHAR(100) Y Last name key.
NAME_LAST_KEY_A_NLS VARCHAR(400) Y NAME_LAST_KEY_A_NLS column
NAME_LAST_KEY_NLS VARCHAR(202) Y Last name key (NLS).
NAME_MIDDLE VARCHAR(100) Y This is the person's middle or secondary given name or names.
NAME_MIDDLE_KEY VARCHAR(100) Y Middle name key.
NAME_MIDDLE_KEY_A_NLS VARCHAR(400) Y NAME_MIDDLE_KEY_A_NLS column
NAME_MIDDLE_KEY_NLS VARCHAR(202) Y Middle name key (NLS).
NAME_ORIGINAL VARCHAR(100) Y This is the preserved value of the person name when initially enrolled in the system.
NAME_PREFIX VARCHAR(100) Y Name prefix includes any titles that will precede the regular person name.
NAME_SUFFIX VARCHAR(100) Y Name suffix includes any titles that will follow the regular person name.
NAME_TITLE VARCHAR(100) Y Is this the same as prefix or suffix?
NAME_TYPE_CD DOUBLE N This code identifies the type of name for the person name row (i.e., current, previous, maiden, other).
NAME_TYPE_SEQ DOUBLE N This is the numeric sequence that determines the priority or precedence that one name row has over another when both rows contain the same person_id and name_type_cd.
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_NAME_ID DOUBLE N This is the value of the unique primary identifier of the person name table. It is an internal system assigned number.
SOURCE_IDENTIFIER VARCHAR(255) Y Identifier assigned from a master system to this row. Added to support he UK's PDS Allocated Object Identifier. Used to help keep the UK master database in sync with Millennium.
UPDT_APPLCTX DOUBLE N The application context number from the record info block. 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_NAME


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




Parent Column in PERSON_NAME (PK) Child Table Name Child Column Name
Children: PERSON_NAME_ID PERSON_NAME_HIST PERSON_NAME_ID


PERSON_NAME_HIST



Column Section Relationship Section Top of Page


Table-level Detail

Description: PERSON NAME HIST
Definition: Used for tracking history of changes to person names.
Table Type: ACTIVITY





Column Detail - PERSON_NAME_HIST


Column Name Type Null? Definition
ACTIVE_IND DOUBLE N The table row is active or inactive. A row is generally active unless it is in an inactive state such as logically deleted, combined away, pending purge, etc.
ACTIVE_STATUS_CD DOUBLE N Indicates the status of the row itself (not the data in the row) such as active, inactive, combined away, pending purge, etc.
ACTIVE_STATUS_DT_TM DATETIME N The date and time that the active_status_cd was set.
ACTIVE_STATUS_PRSNL_ID DOUBLE N The person who caused the active_status_cd to be set or change.
BEG_EFFECTIVE_DT_TM DATETIME 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.
NAME_DEGREE VARCHAR(100) Y This is the person's abbreviation that represents a degree or certification.
NAME_FIRST VARCHAR(100) Y This is the person's first given 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_FULL VARCHAR(100) Y This is the complete person name including punctuation, formatting, prefix, and suffix.
NAME_INITIALS VARCHAR(100) Y The three character initial abbreviation of the person's name.
NAME_LAST VARCHAR(100) 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_MIDDLE VARCHAR(100) Y This is the person's middle or secondary given name or names.
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_PREFIX VARCHAR(100) Y Name prefix includes any titles that will precede the regular person name.
NAME_SUFFIX VARCHAR(100) Y Name suffix includes any titles that will follow the regular person name.
NAME_TITLE VARCHAR(100) Y This is the person's abbreviation that represents formal method of addressing, such as Mr. or Mrs.
NAME_TYPE_CD DOUBLE N This code identifies the type of name for the person name row (i.e., current, previous, maiden, other).
NAME_TYPE_SEQ DOUBLE N This is the numeric sequence that determines the priority or precedence that one name row has over another when both rows contain the same person_id and name_type_cd.
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_NAME_HIST_ID DOUBLE N Unique identifier for the Person_name_hist table.
PERSON_NAME_ID DOUBLE N This is the value of the unique primary identifier of the person name 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.
SOURCE_IDENTIFIER VARCHAR(255) Y Identifier assigned from a master system to this row. Added to support the uk's pds allocated object identifier. Used to help keep the uk master database in sync with millennium.
TRACKING_BIT DOUBLE N Identifies which columns are being tracked for history.
TRANSACTION_DT_TM DATETIME Y 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_NAME_HIST


Child Column in PERSON_NAME_HIST(FK) Parent Table Name Parent Column Name
Parents: PERSON_ID PERSON PERSON_ID
PERSON_NAME_ID PERSON_NAME PERSON_NAME_ID
PM_HIST_TRACKING_ID PM_HIST_TRACKING PM_HIST_TRACKING_ID


PERSON_ORG_RELTN



Column Section Relationship Section Top of Page


Table-level Detail

Description: Person Organization Relationship
Definition: The person-organization relationship table contains pointers to related organizations in the person table. This table contains data about the type of relationship (I.e., employment, organ donor, student, etc.)
Table Type: ACTIVITY





Column Detail - PERSON_ORG_RELTN


Column Name Type Null? Definition
ACTIVE_IND DOUBLE N The table row is active or inactive. A row is generally active unless it is in an inactive state such as logically deleted, combined away, pending purge, etc.
ACTIVE_STATUS_CD DOUBLE N Indicates the status of the row itself (not the data in the row) such as active, inactive, combined away, pending purge, etc.
ACTIVE_STATUS_DT_TM DATETIME N The date and time that the active_status_cd was set.
ACTIVE_STATUS_PRSNL_ID DOUBLE N The person who caused the active_status_cd to be set or change.
BEG_EFFECTIVE_DT_TM DATETIME N The date and time for which this table row becomes effective. Normally, this will be the date and time the row is added, but could be a past or future date and time.
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.
EMPL_CONTACT VARCHAR(100) Y The name of the person at the employer organization to verify employment.
EMPL_CONTACT_TITLE VARCHAR(100) Y The title of the person (empl_contact) at the employer organization who verify employment.
EMPL_HIRE_DT_TM DATETIME Y Date the employee was hired
EMPL_OCCUPATION_CD DOUBLE N The codified representation of the person's type of work performed on behalf of the employer organization.
EMPL_OCCUPATION_NOMEN_ID DOUBLE Y The identifying information of the nomenclature defining the person's type of work performed on behalf of the employer organization. Examples may include Bank Officer, Java Software Developer, and Nurse Practitioner.
EMPL_OCCUPATION_TEXT VARCHAR(100) Y The textual description of the person's type of work performed on behalf of the employer organization.
EMPL_OCC_INDUSTRY_NOMEN_ID DOUBLE Y The identifying information of the nomenclature defining the type of business of the employer organization that compensates the person for work or assigns work to the person as an unpaid worker or volunteer. Examples may include Federal Savings Banks, Computer Software Support Services, and Pharmacies.
EMPL_POSITION VARCHAR(100) Y Employee position is the work position given to the employee by the employer organization.
EMPL_RETIRE_DT_TM DATETIME Y Date the employee retired
EMPL_STATUS_CD DOUBLE N Employee status indicates a condition of employment (I.e., probation, leave, employed, terminated)
EMPL_TERM_DT_TM DATETIME Y Date the employee was terminated
EMPL_TITLE VARCHAR(100) Y Employee title is the work title given to the employee by the employer organization.
EMPL_TITLE_CD DOUBLE N Employee title code is the codified work title given to the employee by the employer organization.
EMPL_TYPE_CD DOUBLE N Employee type identifies the kind of employment related to the number of hours worked and/or how the employee is paid (I.e., part time-hourly, full time-salary, etc.).
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.
FREE_TEXT_IND DOUBLE Y Indicates whether the relationship is with a free textorganization
FT_ORG_NAME VARCHAR(100) Y The Organization Name entered in free text form.
INTERNAL_SEQ DOUBLE N Internal Person Management sequence
ORGANIZATION_ID DOUBLE N This is the value of the unique primary identifier of the organization table. It is an internal system assigned number.
PERSON_ID DOUBLE N This is the value of the unique primary identifier of the person table. It is an internal system assigned number.
PERSON_ORG_ALIAS VARCHAR(100) Y This is a secondary external identifier for the person organization relationship.
PERSON_ORG_NBR VARCHAR(100) Y This is the primary external identifier for the person organization relationship (I.e., employee number, student id number, etc.)
PERSON_ORG_RELTN_CD DOUBLE N Identifies the specific type of relationship of the person to the organization. This field has Cerner defined meanings (I.e., employee, student, etc.)
PERSON_ORG_RELTN_ID DOUBLE N This is the value of the unique primary identifier of the person organization relationship table. It is an internal system assigned number.
PRIORITY_SEQ DOUBLE N Identifies a sequencing priority to be used when a duplicate relationship of the same type is created
SOURCE_IDENTIFIER VARCHAR(255) Y Identifier assigned from a master system to this row. Added to support he UK's PDS Allocated Object Identifier. Used to help keep the UK master database in sync with Millennium.
UPDT_APPLCTX DOUBLE N The application context number from the record info block. 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_ORG_RELTN


Child Column in PERSON_ORG_RELTN(FK) Parent Table Name Parent Column Name
Parents: EMPL_OCCUPATION_NOMEN_ID NOMENCLATURE NOMENCLATURE_ID
EMPL_OCC_INDUSTRY_NOMEN_ID NOMENCLATURE NOMENCLATURE_ID
ORGANIZATION_ID ORGANIZATION ORGANIZATION_ID
PERSON_ID PERSON PERSON_ID




Parent Column in PERSON_ORG_RELTN (PK) Child Table Name Child Column Name
Children: PERSON_ORG_RELTN_ID ENCNTR_PLAN_RELTN PERSON_ORG_RELTN_ID
ENCNTR_PLAN_RELTN SPONSOR_PERSON_ORG_RELTN_ID
PERSON_ORG_RELTN_HIST PERSON_ORG_RELTN_ID
PERSON_PLAN_RELTN PERSON_ORG_RELTN_ID
PERSON_PLAN_RELTN SPONSOR_PERSON_ORG_RELTN_ID


PERSON_ORG_RELTN_HIST



Column Section Relationship Section Top of Page


Table-level Detail

Description: Person Organization Relation History
Definition: Used to store transactional history for person organization relationships.
Table Type: ACTIVITY





Column Detail - PERSON_ORG_RELTN_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 N The date and time that the active_status_cd was set.
ACTIVE_STATUS_PRSNL_ID DOUBLE N The person who caused the active_status_cd to be set or change.
BEG_EFFECTIVE_DT_TM DATETIME N The date and time for which this table row becomes effective. Normally, this will be the date and time the row is added, but could be a past or future date and time.
CHANGE_BIT DOUBLE N Identifies which columns have had a change.
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.
EMPL_CONTACT VARCHAR(100) Y The name of the person at the employer organization to verify employment.
EMPL_HIRE_DT_TM DATETIME Y The date the employee was hired.
EMPL_OCCUPATION_CD DOUBLE N The codified representation of the person's type of work performed on behalf of the employer organization.
EMPL_OCCUPATION_NOMEN_ID DOUBLE Y The identifying information of the nomenclature defining the person's type of work performed on behalf of the employer organization. Examples may include Bank Officer, Java Software Developer, and Nurse Practitioner.
EMPL_OCCUPATION_TEXT VARCHAR(100) Y The textual description of the person's type of work performed on behalf of the employer organization.
EMPL_OCC_INDUSTRY_NOMEN_ID DOUBLE Y The identifying information of the nomenclature defining the type of business that compensates the person for work or assigns work to the person as an unpaid worker or volunteer. Examples may include Federal Savings Banks, Computer Software Support Services, and Pharmacies.
EMPL_POSITION VARCHAR(100) Y The work position given to the employee by the employer organization.
EMPL_RETIRE_DT_TM DATETIME Y The date the employee retired.
EMPL_STATUS_CD DOUBLE N Indicates a condition of employment (i.e. probation, leave, employed, terminated).
EMPL_TERM_DT_TM DATETIME Y Date the employee was terminated.
EMPL_TITLE VARCHAR(100) N Employee title is the work title given to the employee by the employer organization.
EMPL_TITLE_CD DOUBLE N Employee title code is the codified work title given to the employee by the employer organization.
EMPL_TYPE_CD DOUBLE N Employee type identifies the kind of employment related to the number of hours worked and/or how the employee is paid (I.e., part time-hourly, full time-salary, etc.).
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.
ORGANIZATION_ID DOUBLE N This is the value of the unique primary identifier of the organization table. It is an internal system assigned number.
PERSON_ORG_NBR VARCHAR(100) Y This is the primary external identifier for the person organization relationship (I.e., employee number, student id number, etc.)
PERSON_ORG_RELTN_CD DOUBLE N Identifies the specific type of relationship of the person to the organization. This field has Cerner defined meanings (I.e., employee, student, etc.)
PERSON_ORG_RELTN_HIST_ID DOUBLE N The primary key of the PERSON_ORG_RELTN_HIST table.
PERSON_ORG_RELTN_ID DOUBLE N This is the value of the unique primary identifier of the person organization relationship table. It is an internal system assigned number.
PM_HIST_TRACKING_ID DOUBLE N This is the unique primary identifier of the pm_hist_tracking table. It is an internal system assigned number.
PRIORITY_SEQ DOUBLE N Identifies a sequencing priority to be used when a duplicate relationship of the same type is created.
SOURCE_IDENTIFIER VARCHAR(255) Y Identifier assigned from a master system to this row. Added to support the uk's pds allocated object identifier. Used to help keep the uk master in sync with millennium.
TRACKING_BIT DOUBLE N Identifies which columns have had a change.
TRANSACTION_DT_TM DATETIME N ** OBSOLETE **. Use column updt_dt_tm for any filtering/ordering query. If transaction date time is needed, it should be retrieved from pm_hist_tracking table. Note that its date may be in the past, as in before the update date time.
UPDT_APPLCTX DOUBLE N The application context number from the record info block. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic.
UPDT_CNT DOUBLE N Set to 0 on insert. Incremented by 1 on update. Used to recognize update conflict where data in a row updated by one application is at risk of being lost by a second application attempting to update the row. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic.
UPDT_DT_TM DATETIME N The date and time the row was last inserted or updated. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic.
UPDT_ID DOUBLE N The person_id of the person from the personnel table (prsnl) that caused the last insert or update of the row in the table. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic.
UPDT_TASK DOUBLE N The registered (assigned) task number for the process that inserted or updated the row. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic.



Relationship Detail - PERSON_ORG_RELTN_HIST


Child Column in PERSON_ORG_RELTN_HIST(FK) Parent Table Name Parent Column Name
Parents: EMPL_OCCUPATION_NOMEN_ID NOMENCLATURE NOMENCLATURE_ID
EMPL_OCC_INDUSTRY_NOMEN_ID NOMENCLATURE NOMENCLATURE_ID
ORGANIZATION_ID ORGANIZATION ORGANIZATION_ID
PERSON_ORG_RELTN_ID PERSON_ORG_RELTN PERSON_ORG_RELTN_ID
PM_HIST_TRACKING_ID PM_HIST_TRACKING PM_HIST_TRACKING_ID


PERSON_PATIENT



Column Section Relationship Section Top of Page


Table-level Detail

Description: Person Patient
Definition: The person patient table is a logical extension of the person table. A single row in the person patient table is related to a single row in the person table. The person patient table contains data that is collected when a person becomes a patient.
Table Type: ACTIVITY





Column Detail - PERSON_PATIENT


Column Name Type Null? Definition
ACTIVE_IND DOUBLE N The table row is active or inactive. A row is generally active unless it is in an inactive state such as logically deleted, combined away, pending purge, etc.
ACTIVE_STATUS_CD DOUBLE N Indicates the status of the row itself (not the data in the row) such as active, inactive, combined away, pending purge, etc.
ACTIVE_STATUS_DT_TM DATETIME N The date and time that the active_status_cd was set.
ACTIVE_STATUS_PRSNL_ID DOUBLE N The person who caused the active_status_cd to be set or change.
ADOPTED_CD DOUBLE N Describes the adopted status of the person.
ADVOCATE_REQUIRED_CD DOUBLE N Identifies it the patient requires someone to be present to help them understand and make decisions around their clinical care.
BAD_DEBT_CD DOUBLE N Describes a level or status of bad debt risk represented by the person.
BAPTISED_CD DOUBLE N Describes the baptised status of the person
BEG_EFFECTIVE_DT_TM DATETIME N The date and time for which this table row becomes effective. Normally, this will be the date and time the row is added, but could be a past or future date and time.
BIRTH_CERTIFICATE_IDENT VARCHAR(100) Y The numeric or textual identifier of the government issued vital document which certifies the patient's birth.
BIRTH_LENGTH DOUBLE Y The numerical length of the person recorded at birth.
BIRTH_LENGTH_UNITS_CD DOUBLE N The units used to record the birth length.
BIRTH_MULTIPLE_CD DOUBLE N Identifies a birth of more than one baby (I.e., twins, triplets, etc.)
BIRTH_NAME VARCHAR(100) Y The name given to the person at birth.
BIRTH_ORDER DOUBLE Y In the case of a multiple birth, the number which represents the order of birth for the person.
BIRTH_ORDER_CD DOUBLE N In the case of a multiple birth, the number which represents the order of birth for the person. This is essentially the same information that is stored in column Birth_Order but the UK handles this field differently so this new column was needed to accomodate the UK processing.
BIRTH_SEX_CD DOUBLE N The sex, typically determined by biological characteristics such as reproductive anatomy or genetic makeup, assigned at birth for the purposes of birth registration.
BIRTH_WEIGHT DOUBLE Y The numerical weight of the person recorded at birth.
BIRTH_WEIGHT_UNITS_CD DOUBLE N The units used to record the birth weight.
CALLBACK_CONSENT_CD DOUBLE N Denotes if the person has provided their consent to be contacted.
CHURCH_CD DOUBLE N Identifies a the specific church or place of worship that the person is associated with.
CONTACT_FOR_RESEARCH_PERM_CD DOUBLE N Information regarding if the patient has given permission to be contacted for research purposes
CONTACT_LIST_CD DOUBLE N Indicates whether the person has a hard-copy of contact list information on file with the institution
CONTACT_METHOD_CD DOUBLE N Denotes the person's preferred method of communication should he or she need to be contacted.
CONTACT_TIME VARCHAR(255) Y The preferred contact times and days for the person.
CONTRIBUTOR_SYSTEM_CD DOUBLE N Contributor system identifies the source feed of data from which a row was populated. This is mainly used to determine how to update a set of data that may have originated from more than one source feed.
CREDIT_HRS_TAKING DOUBLE Y The current number of school credit hours the person is taking.
CUMM_LEAVE_DAYS DOUBLE Y future
CURRENT_BALANCE DOUBLE Y The current unpaid account balance owed by the person.
CURRENT_GRADE DOUBLE Y The current school grade of the person.
CUSTODY_CD DOUBLE N A person relationship code identifying the relationship of the person who has custody of the person.
DATA_STATUS_CD DOUBLE N Data status indicates a level of authenticity of the row data. Typically this will either be AUTHENTICATED or UNAUTHENTICATED.
DATA_STATUS_DT_TM DATETIME Y The date and time that the data_status_cd was set.
DATA_STATUS_PRSNL_ID DOUBLE N The person who caused the data_status_cd to be set or change.
DEATH_CERTIFICATE_IDENT VARCHAR(100) Y The numeric or textual identifier of the government issued vital document which certifies the patient's birth.
DEGREE_COMPLETE_CD DOUBLE N The highest degree completed by the person.
DEMOG_VERIFY_DT_TM DATETIME Y The date and time at which the patient's demographics were last verified.
DIET_TYPE_CD DOUBLE N Identifies a special kind of diet for the person.
DISEASE_ALERT_CD DOUBLE N Disease Alert
END_EFFECTIVE_DT_TM DATETIME N The date/time after which the row is no longer valid as active current data. This may be valued with the date that the row became inactive.
EXT_TRANSPORT_REQUIRED_CD DOUBLE N Identifies if the patient requires transportation to the health care facility.
FAMILY_INCOME DOUBLE Y The current income of the person's immediate family.
FAMILY_NBR_OF_MINORS_CNT DOUBLE Y The current number of minors in the person's immediate family.
FAMILY_SIZE DOUBLE Y The current number of people in the person's immediate family.
FINANCIAL_RISK_LEVEL_CD DOUBLE N Indicates the person's propensity to make payment on bills for services rendered based on client-defined rules for evaluating financial risk level.
FIN_STATEMENT_EXPIRE_DT_TM DATETIME Y The data and time of when the financial statement will expire for the person.
FIN_STATEMENT_VERIFIED_DT_TM DATETIME Y The date and time of when the financial statement was verified for the person.
GEST_AGE_AT_BIRTH DOUBLE Y The gestational age at birth in days.
GEST_AGE_METHOD_CD DOUBLE N The code value for the method that was used to determine gestational age at birth.
HEALTH_APP_ACCESS_OFFERED_CD DOUBLE N the information regarding if the patient (or patient-authorized representative) has been offered access to any application(s) of their choosing made available by the provider which accesses their health information via a certified vendor API
HEALTH_INFO_ACCESS_OFFERED_CD DOUBLE N Information regarding if the patient (or patient-authorized representative) has been provided access to view online, download, and transmit their health information
HIGHEST_GRADE_COMPLETE_CD DOUBLE N The highest grade completed by the person.
IMMUN_ON_FILE_CD DOUBLE N future functionality
INTERP_REQUIRED_CD DOUBLE N Identifies that a language interpreter is required. Otherwise, this field is NULL.
INTERP_TYPE_CD DOUBLE N If the interp_required_cd is not NULL, then this field may be valued to indicate the need for a specific type of interpreter.
IQH_PARTICIPANT_CD DOUBLE N The IQ health participation code stores the consent status for IQ Health personal health record.
LAST_ATD_ACTIVITY_DT_TM DATETIME Y is this still used (V400)??
LAST_BILL_DT_TM DATETIME Y The date and time that the last bill was sent to the person or insurance organization.
LAST_BIND_DT_TM DATETIME Y The last bind date and time of the patient
LAST_DISCHARGE_DT_TM DATETIME Y The date and time that the person was last discharged from the inpatient or ambulatory organization.
LAST_EVENT_UPDT_DT_TM DATETIME Y is this still used (V400)??
LAST_PAYMENT_DT_TM DATETIME Y The date and time of the last payment received on behalf of the person.
LAST_TRAUMA_DT_TM DATETIME Y Date the last trauma related encounter occurred
LIVING_ARRANGEMENT_CD DOUBLE N The living arrangement of the patient
LIVING_DEPENDENCY_CD DOUBLE N The living dependency of the patient
LIVING_WILL_CD DOUBLE N Living Will Code Value
MICROFILM_CD DOUBLE N Describes the existence of microfilm for the person's chart.
MOTHER_IDENTIFIER VARCHAR(100) Y Free-text attribute used to uniquely identify the persons mother
MOTHER_IDENTIFIER_CD DOUBLE N Identifies the type of alias specified in the MOTHER_IDENTIFIER attribute (MRN, SSN)
NBR_OF_BROTHERS DOUBLE Y The person's current number of brothers.
NBR_OF_PREGNANCIES DOUBLE Y Number of pregnancies
NBR_OF_SISTERS DOUBLE Y The person's current number of sisters.
ORGAN_DONOR_CD DOUBLE N Describes the organ donor status of the person.
PARENT_MARITAL_STATUS_CD DOUBLE N The marital status of the person's parents (I.e., divorced)
PERSON_ID DOUBLE N This is the value of the unique primary identifier of the person table. It is an internal system assigned number.
PHONE_CONTACT_TYPE_CD DOUBLE N Denotes the person's preferred type of phone should he or she need to be contacted.
PREV_CONTACT_IND DOUBLE N This attribute indicates if the patient has ever had previous contact with UK's NHS (National Health System).
PRIMARY_CARE_HOME_CD DOUBLE N Information regarding the patient's primary care home. A primary care home is a patient centered primary care setting where a group of medical professionals coordinate care within a defined population.
PROCESS_ALERT_CD DOUBLE N Process Alert
SMOKES_CD DOUBLE N Describes the smoking status of the person.
SOURCE_LAST_SYNC_DT_TM DATETIME Y The last date and time the record was synchronized with the master system. Added to support the UK's PDS serial change number.
SOURCE_SYNC_LEVEL_FLAG DOUBLE N Synchronization level indicates what level of synchronization with the master system is to be performed. 0 - the full person record should be synched with the master system when all other necessary criteria for synchronization have been met. 1 - the person record has been decoupled from the master system and no part of the record should be synched even when all other criteria necessary for synchronization have been met.
SOURCE_VERSION_NUMBER VARCHAR(255) Y Version number assigned from a master system to this record. Added to support the UK's PDS Serial Change Number.
STUDENT_CD DOUBLE N Indicates if the patient is a student (full or part time).
TUMOR_REGISTRY_CD DOUBLE N The tumor registry of the patient
UPDT_APPLCTX DOUBLE N The application context number from the record info block. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic.
UPDT_CNT DOUBLE N Set to 0 on insert. Incremented by 1 on update. Used to recognize update conflict where data in a row updated by one application is at risk of being lost by a second application attempting to update the row. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic.
UPDT_DT_TM DATETIME N The date and time the row was last inserted or updated. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic.
UPDT_ID DOUBLE N The person_id of the person from the personnel table (prsnl) that caused the last insert or update of the row in the table. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic.
UPDT_TASK DOUBLE N The registered (assigned) task number for the process that inserted or updated the row. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic.
WRITTEN_FORMAT_CD DOUBLE N This code indicates what is the preferred type of written communication that should be used for the patient. An example would be large print, braille, etc.



Relationship Detail - PERSON_PATIENT


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