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 |
N |
The table row is active or inactive. A row is generally active unless it is in an inactive state such as logically deleted, combined away, pending purge, etc. |
ACTIVE_STATUS_CD |
DOUBLE |
N |
Indicates the status of the row itself (not the data in the row) such as active, inactive, combined away, pending purge, etc. |
ACTIVE_STATUS_DT_TM |
DATETIME |
Y |
The date and time that the active_status_cd was set. |
ACTIVE_STATUS_PRSNL_ID |
DOUBLE |
N |
The person who caused the active_status_cd to be set or change. |
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. |
CHANGE_BIT |
DOUBLE |
N |
Identifies which columns have had a change. |
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 |
The date and time the record was created. |
CREATE_PRSNL_ID |
DOUBLE |
N |
The personnel ID of the person who created the row in the 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 deceased information concerning a person was given. |
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_FLEX_HIST_ID |
DOUBLE |
N |
This is the value of the unique primary identifier of the person_flex_hist 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_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. |
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. |
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. |
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. |
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. |