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 |