Table Detail Report

PERSON_FIN_ASSET



Column Section Relationship Section Top of Page


Table-level Detail

Description: Person Financial Asset
Definition: Records a person's financial assets (examples include bank accounts, vehicles, real estate etc.)
Table Type: ACTIVITY





Column Detail - PERSON_FIN_ASSET


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.
ASSET_DETAIL_TXT VARCHAR(255) Y The freetext description which gives additional information about the person's financial asset.
ASSET_TYPE_CD DOUBLE N The financial asset type code defines the tyep of asset (for example: bank accounts, vehicles, re estate properties, etc.)
ASSET_VALUE DOUBLE Y The monetary value of the financial asset as defined by the person's financial asset type code.
PARENT_ENTITY_ID DOUBLE N The value of the primary identifier of the parent table to which the person's financial asset row is related.
PARENT_ENTITY_NAME VARCHAR(30) N The upper case name of the table to which this person's financial asset is related (for example: person, financial_case, etc.)
PERSON_FIN_ASSET_ID DOUBLE N Uniquely generated number to identify a row on the PERSON_FIN_ASSET 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.
VERIFY_DT_TM DATETIME Y The date and time the financial asset was last verified.



Relationship Detail - PERSON_FIN_ASSET




Parent Column in PERSON_FIN_ASSET (PK) Child Table Name Child Column Name
Children: PERSON_FIN_ASSET_ID PERSON_FIN_ASSET_HIST PERSON_FIN_ASSET_ID


PERSON_FIN_ASSET_HIST



Column Section Relationship Section Top of Page


Table-level Detail

Description: Person Financial Asset History
Definition: Contains historical information from the PERSON_FIN_ASSET table
Table Type: ACTIVITY





Column Detail - PERSON_FIN_ASSET_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.
ASSET_DETAIL_TXT VARCHAR(255) Y The freetext description which gives additional information about the person's financial asset.
ASSET_TYPE_CD DOUBLE N The financial asset type code defines the tyep of asset (for example: bank accounts, vehicles, re estate properties, etc.)
ASSET_VALUE DOUBLE Y The monetary value of the financial asset as defined by the person's financial asset type code.
CHANGE_BIT DOUBLE N Identifies which columns have had a change.
PARENT_ENTITY_ID DOUBLE N The value of the primary identifier of the parent table to which the person's financial asset row is related.
PARENT_ENTITY_NAME VARCHAR(30) N The upper case name of the table to which this person financial asset row is related (i.e., person, financial_case, etc).
PERSON_FIN_ASSET_HIST_ID DOUBLE N Uniquely generated number to identify a specific row on the PERSON_FIN_ASSET_HIST table.
PERSON_FIN_ASSET_ID DOUBLE N Uniquely generated number to identify a row on the PERSON_FIN_ASSET 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 ** 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.
VERIFY_DT_TM DATETIME Y The date and time the financial asset was last verified.



Relationship Detail - PERSON_FIN_ASSET_HIST


Child Column in PERSON_FIN_ASSET_HIST(FK) Parent Table Name Parent Column Name
Parents: PERSON_FIN_ASSET_ID PERSON_FIN_ASSET PERSON_FIN_ASSET_ID
PM_HIST_TRACKING_ID PM_HIST_TRACKING PM_HIST_TRACKING_ID


PERSON_FLEX_HIST



Column Section Relationship Section Top of Page


Table-level Detail

Description: Person Flexible History Table
Definition: Used for tracking history of certain columns on the person table.
Table Type: ACTIVITY





Column Detail - PERSON_FLEX_HIST


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



Relationship Detail - PERSON_FLEX_HIST


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


PERSON_GTTD



Column Section Top of Page


Table-level Detail

Description: Person Global Temporary
Definition: Global temporary table to save a list of person ids.
Table Type: ACTIVITY





Column Detail - PERSON_GTTD


Column Name Type Null? Definition
PERSON_ID DOUBLE Y Should contain a person_id.


PERSON_INFO



Column Section Relationship Section Top of Page


Table-level Detail

Description: PERSON INFO
Definition: Person level comments
Table Type: ACTIVITY





Column Detail - PERSON_INFO


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.
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 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.
INFO_SUB_TYPE_CD DOUBLE Y This column stores more detailed information about what information is written to the row. Such as the actual field name of the information being stored on this row.
INFO_TYPE_CD DOUBLE N This column stores what type of information is written to the row.
INTERNAL_SEQ DOUBLE Y Internal Person Management sequence
LONG_TEXT_ID DOUBLE N Foreign Key to the LONG_TEXT table. Allows textual Person level comments
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_ID DOUBLE N The unique primary key of this table.
PRIORITY_SEQ DOUBLE Y Identifies a sequencing priority to be used when a duplicate relationship of the same type are created.
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.
VALUE_CD DOUBLE Y If the comment if of a codified type, the value should be placed in this attribute
VALUE_DT_TM DATETIME Y If the comment is of a date type, it is stored in this attribute. If the INFO_SUB_TYPE_CD is a date field, then this column will be filled out.
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.



Relationship Detail - PERSON_INFO


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




Parent Column in PERSON_INFO (PK) Child Table Name Child Column Name
Children: PERSON_INFO_ID PERSON_INFO_HIST PERSON_INFO_ID