ADDRESS



Column Section Relationship Section Top of Page


Table-level Detail

Description: Address
Definition: The address table contains all addresses. An address table row is associated with a row in another table (i.e., person). Each address row is identified by the name of the table it is related to & the related table's primary row identifier.
Table Type: ACTIVITY





Column Detail - ADDRESS


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.
ADDRESS_FORMAT_CD DOUBLE N Address format code identifies the format to apply to the given address. (Future Use)
ADDRESS_ID DOUBLE N The address ID is the primary key of the address table.
ADDRESS_INFO_STATUS_CD DOUBLE N The current status of the address. An example would be 'Incorrect Address'.
ADDRESS_TYPE_CD DOUBLE N The address type is the code set value which identifies the type of address for the address row (i.e., home, business, etc.)
ADDRESS_TYPE_SEQ DOUBLE N This is the numeric sequence that determines the priority or precedence that one address row has over another when both address rows contain the same parent_entity_name, parent_entity_id, and address_type_cd with the same meaning.
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.
BEG_EFFECTIVE_MM_DD DOUBLE Y The numeric representation of the month and day of the month for which this row becomes effective within the current year.
CITY VARCHAR(100) Y The city field is the text name of the city associated with the address row.
CITY_CD DOUBLE N The city code is the code set value which identifies the city for the address row.
COMMENT_TXT VARCHAR(200) Y Comment giving additional information about the address.
CONTACT_NAME VARCHAR(200) Y The primary person or contact for this address.
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.
COUNTRY VARCHAR(100) Y The country field is the text name of the country associated with the address row.
COUNTRY_CD DOUBLE N The country code is the code set value which identifies the country for the address row.
COUNTY VARCHAR(100) Y The county field is the text name of the county associated with the address row.
COUNTY_CD DOUBLE N The county code is the code set value which identifies the county for the address row.
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.
DISTRICT_HEALTH_CD DOUBLE N This will hold the code_value of the District Health Authority.
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.
END_EFFECTIVE_MM_DD DOUBLE Y The numeric representation of the month and day of the month for which this row is no longer effective within the current year.
LONG_TEXT_ID DOUBLE N Foreign key from LONG_TEXT table. Ties free text comments to an address.
MAIL_STOP VARCHAR(100) Y Currently used internally by Cerner only. Identifies a Cerner organization mail stop number used to route inter-office mail.
OPERATION_HOURS VARCHAR(255) Y free text entry specifying the days and hours that this address is valid
PARENT_ENTITY_ID DOUBLE N The value of the primary identifier of the table to which the address row is related (i.e., person_id, organization_id, etc.)
PARENT_ENTITY_NAME VARCHAR(32) N The upper case name of the table to which this address row is related (i.e., PERSON, PRSNL, ORGANIZATION, etc.)
POSTAL_BARCODE_INFO VARCHAR(100) Y This contains Postal Barcode Information of the address. (future use)
POSTAL_IDENTIFIER VARCHAR(100) Y A code that is used to assist with finding or navigating to a specific location or delivery point. In some countries, this may provide better resolution than the standard postal address.
POSTAL_IDENTIFIER_KEY VARCHAR(100) Y Stores a version of column Postal Identifier with all the spaces removed and in upper case. Used as a consistent key field for column Postal Identifier.
PRIMARY_CARE_CD DOUBLE N This will hold the code_value of the Primary Care Trust.
RESIDENCE_CD DOUBLE N The residence code is the code set value which identifies a geographic area for user defined purposes. In Canada, the residence code is used for billing and statistical purposes between the provinces.
RESIDENCE_TYPE_CD DOUBLE N The residence type code is a code set value which describes key physical characteristics about the housing or building associated with the address. (I.e., apartment, house, etc.)
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.
STATE VARCHAR(100) Y The state field is the text name of the state or province associated with the address row.
STATE_CD DOUBLE N The state code is the code set value which identifies the state or province for the address row.
STREET_ADDR VARCHAR(100) Y This is the first line of the street address.
STREET_ADDR2 VARCHAR(100) Y This is the second line of the street address.
STREET_ADDR3 VARCHAR(100) Y This is the third line of the street address. The third line of the street address will generally only be used for international addresses.
STREET_ADDR4 VARCHAR(100) Y This is the fourth line of the street address. The fourth line of the street address will generally only be used for international addresses.
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.
VALIDATION_EXPIRE_DT_TM DATETIME Y The time in which the address validation expires.
ZIPCODE VARCHAR(25) Y This field contains the postal code for the street address in the address row.
ZIPCODE_KEY VARCHAR(25) Y Zipcode key field converted to nls format for internationalization and search requirements
ZIP_CODE_GROUP_CD DOUBLE N This contains the code set value for a zip code group. (future use)



Relationship Detail - ADDRESS


Child Column in ADDRESS(FK) Parent Table Name Parent Column Name
Parents: LONG_TEXT_ID LONG_TEXT LONG_TEXT_ID




Parent Column in ADDRESS (PK) Child Table Name Child Column Name
Children: ADDRESS_ID ADDRESS_HIST ADDRESS_ID
INVOICE REMIT_ADDRESS_ID
MRU_LOOKUP_FOLLOWUP ADDRESS_ID
PFT_AP_REFUND ADDRESS_ID
PM_TRANSACTION O_PER_BUS_ADDRESS_ID
PM_TRANSACTION O_PER_HOME_ADDRESS_ID
PRODUCT_DEFAULT_ADDRESS ADDRESS_ID
PURCHASE_ORDER BILL_TO_ADDRESS_ID
PURCHASE_ORDER SHIP_TO_ADDRESS_ID
PURCHASE_ORDER VENDOR_ADDRESS_ID
REQUESTER BILL_TO_ADDRESS_ID
REQUESTER MAIL_TO_ADDRESS_ID
ROI_REQUEST BILL_TO_ADDRESS_ID
ROI_REQUEST MAIL_TO_ADDRESS_ID
SI_UNMTCHD_PRSN_QUE ADDRESS_ID


ADDRESS_HIST



Column Section Relationship Section Top of Page


Table-level Detail

Description: ADDRESS HISTORY
Definition: Tracks modifications to history elements for a given address table.
Table Type: ACTIVITY





Column Detail - ADDRESS_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.
ADDRESS_HIST_ID DOUBLE N This is the value of the unique primary identifier of the address_hist table. It is an internal system assigned number.
ADDRESS_ID DOUBLE N The ADDRESS_ID value inherited from the ADDRESS table.
ADDRESS_INFO_STATUS_CD DOUBLE N The current status of the address. An example would be 'Incorrect Address'.
ADDRESS_TYPE_CD DOUBLE N The address type is the code set value which identifies the type of address for the address row (i.e., home, business, etc.)
ADDRESS_TYPE_SEQ DOUBLE Y This is the numeric sequence that determines the priority or precedence that one address row has over another when both address rows contain the same parent_entity_name, parent_entity_id and address_type_cd with the same meaning.
CHANGE_BIT DOUBLE N Identifies which columns have had a change.
CITY VARCHAR(100) Y The city field is the text name of the city associated with the address row.
CITY_CD DOUBLE N The city code is the code set value which identifies the city for the address row.
COMMENT_TXT VARCHAR(200) Y Comment giving additional information about the address.
CONTACT_NAME VARCHAR(200) Y The primary person or contact for this address.
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.
COUNTRY VARCHAR(100) Y The country field is the text name of the country associated with the address row.
COUNTRY_CD DOUBLE N The country code is the code set value which identifies the country for the address row.
COUNTY VARCHAR(100) Y The county field is the text name of the county associated with the address row.
COUNTY_CD DOUBLE N The county code is the code set value which identifies the county for the address row.
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.
MAIL_STOP VARCHAR(100) Y Currently used internally by Cerner only. Identifies a Cerner organization mail stop number used to route inter-office mail.
OPERATION_HOURS VARCHAR(255) Y Free-text entry specifying the days and hours that this address is valid
PARENT_BEG_EFFECTIVE_DT_TM DATETIME N This is the historical record of column BEG_EFFECTIVE_DT_TM in table ADDRESS.
PARENT_END_EFFECTIVE_DT_TM DATETIME N This is the historical record of column END_EFFECTIVE_DT_TM in table ADDRESS.
PARENT_ENTITY_ID DOUBLE N The value of the primary identifier of the table to which the address row is related (i.e., person_id, organization_id, etc.)
PARENT_ENTITY_NAME VARCHAR(30) Y The upper case name of the table to which this address row is related (i.e., PERSON, PRSNL, ORGANIZATION, etc.)
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.
POSTAL_IDENTIFIER VARCHAR(100) Y A code that is used to assist with finding or navigating to a specific location or delivery point. In some countries, this may provide better resolution than the standard postal address.
POSTAL_IDENTIFIER_KEY VARCHAR(100) Y Stores a version of column postal identifier with all the spaces removed and in upper case. Used as a consistent key field for column postal identifier.
RESIDENCE_CD DOUBLE N The residence code is the code set value which identifies a geographic area for user defined purposes. In Canada, the residence code is used for billing and statistical purposes between the provinces.
RESIDENCE_TYPE_CD DOUBLE N The residence type code is a code set value which describes key physical characteristics about the housing or building associated with the address. (I.e., apartment, house, etc.)
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.
STATE VARCHAR(100) Y The state field is the text name of the state or province associated with the address row.
STATE_CD DOUBLE N The state code is the code set value which identifies the state or province for the address row.
STREET_ADDR VARCHAR(100) Y This is the first line of the street address.
STREET_ADDR2 VARCHAR(100) Y This is the second line of the street address.
STREET_ADDR3 VARCHAR(100) Y This is the third line of the street address. The third line of the street address will generally only be used for international addresses.
STREET_ADDR4 VARCHAR(100) Y This is the fourth line of the street address. The fourth line of the street address will generally only be used for international addresses.
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.
VALIDATION_EXPIRE_DT_TM DATETIME Y The time in which the address validation expires.
ZIPCODE VARCHAR(25) Y This field contains the postal code for the street address in the address row.
ZIPCODE_KEY VARCHAR(25) Y alpha numeric zip code in NLS format.



Relationship Detail - ADDRESS_HIST


Child Column in ADDRESS_HIST(FK) Parent Table Name Parent Column Name
Parents: ADDRESS_ID ADDRESS ADDRESS_ID
PM_HIST_TRACKING_ID PM_HIST_TRACKING PM_HIST_TRACKING_ID


EMPI_CACHE_UPDATE_QUEUE



Column Section Relationship Section Top of Page


Table-level Detail

Description: Enterprise Management Person Index Cache Update Queue
Definition: Used as a queue to process updates to an external search engine.
Table Type: ACTIVITY





Column Detail - EMPI_CACHE_UPDATE_QUEUE


Column Name Type Null? Definition
ACTION_FLAG DOUBLE N This is the action that should be taken on the record in the external search engine. 1 - Add2 - Update3 - Delete
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.
EMPI_CACHE_UPDATE_QUEUE_ID DOUBLE N Uniquely identifies a process update to an external search engine.
PERSON_ID DOUBLE N Uniquely identifies the related person.
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 - EMPI_CACHE_UPDATE_QUEUE


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


EMPI_IMPORT_MATCH



Column Section Relationship Section Top of Page


Table-level Detail

Description: EMPI Import Match
Definition: EMPI Import Offsite MPI Extract - The EMPI
Table Type: ACTIVITY





Column Detail - EMPI_IMPORT_MATCH


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.
A_PERSON_IDENT VARCHAR(255) N The a person match identifier of a match pair.
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_PERSON_IDENT VARCHAR(255) N The b person match identifier of a match pair
CREATE_DT_TM DATETIME N 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
EMPI_IMPORT_MATCH_ID DOUBLE N Unique generated number that identifies a single row on the empi_import_match_table.
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_MPI_PERSON_UUID VARCHAR(255) Y This is the unique id in the external MPI that links that row.
EXT_USERNAME VARCHAR(50) Y The username of the person who provided the match from the external system.
GROUP_SCORE_NBR DOUBLE Y Group Match Confidence Score
HUMAN_LINK_IND DOUBLE Y A value of 1 means a human performed the link in the foreign system. A value of 0 means a computer assisted link was created in the foreign system.
HUMAN_MERGE_IND DOUBLE Y A value of 1 means a human performed the merge in the foreign system. A value of 0 means a computer assisted merge was created in the foreign system.
IDENTIFIER_NAME VARCHAR(255) N Name of the identifier used for the person match pairs
LINK_DT_TM DATETIME Y The date of the Link in the foreign MPI
LINK_SCORE_NBR DOUBLE Y Link Similarity Score between A and B
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.
MERGE_DIRECTION_TXT VARCHAR(50) Y Intended merge direction provided by the foreign system (e.g. MERGEINTOA, MERGEINTOB).
PERSON_COMBINE_BATCH_ID DOUBLE N ID of the generated person_combine_batch_id.
PROCESSED_DT_TM DATETIME Y Date and time the row was processed.
PROCESSED_IND DOUBLE N Indicates that the imported match record has been processed.
PROCESSED_STATUS_CD DOUBLE N Contains the status of the processed 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 - EMPI_IMPORT_MATCH


Child Column in EMPI_IMPORT_MATCH(FK) Parent Table Name Parent Column Name
Parents: PERSON_COMBINE_BATCH_ID PERSON_COMBINE_BATCH PERSON_COMBINE_BATCH_ID


EMPI_PROCESS_LOG



Column Section Relationship Section Top of Page


Table-level Detail

Description: EMPI PROCESS LOG
Definition: Person managements conversation options.
Table Type: ACTIVITY





Column Detail - EMPI_PROCESS_LOG


Column Name Type Null? Definition
AUTO_RECONCILES_CNT DOUBLE Y Number of Auto Reconciles.
CREATE_DT_TM DATETIME N Date and time row was created.
EMPI_PROCESS DOUBLE N EMPI Process which created the row.
EMPI_PROCESS_LOG_ID DOUBLE N Unique identifier for the Empi_process_log table.
MATCHES_CNT DOUBLE Y Number of matches.
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 - EMPI_PROCESS_LOG


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