ALIAS_POOL



Column Section Relationship Section Top of Page


Table-level Detail

Description: Alias Pool
Definition: The alias pool table contains information about unique sets of numbers that are used for identification of different entities (I.e., persons, personnel, organizations, encounters, etc.).
Table Type: REFERENCE





Column Detail - ALIAS_POOL


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.
ALIAS_APPEND_VALUE VARCHAR(15) Y If valued, this value will be appended onto the end of a system assigned aliases created based on this alias pool.
ALIAS_METHOD_CD DOUBLE Y Alias method Cd
ALIAS_POOL_CD DOUBLE N Alias pool code identifies a unique set or list of identifiers (I.e., numbers). The alias pool code also determines the accept/display format for the unique set of identifiers.
ALIAS_POOL_EXT_CD DOUBLE Y Defines the alias pool to be used when selecting the assignment associated with Append Visit Sequence Number. The person's visit sequence will be appended to the alias within the defined alias pool to create a new alias.
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.
CHECK_DIGIT_CD DOUBLE N Identifies which check digit routine will be applied when generating the alias should one be defined.
CMB_INACTIVE_IND DOUBLE Y Determines which duplicate person MRN and CMRN alias to inactivate during a combine.
DESCRIPTION VARCHAR(200) N The description of the alias pool should represent a combination of the responsible organization and the alias type (I.e., XYZ Hospital Medical Record Number).
DUP_ALLOWED_FLAG DOUBLE Y Identifies whether or not duplicates aliases can exist within this alias pool.0- Duplicates are allowed; 1 - Duplicates are allowed; 2 - Duplicates are allowed but warn user; 3 - Duplicates are not allowed
EFFECTIVE_ALIAS_IND DOUBLE N When true (1) the system shall not insert(add) a new active, effective person_alias record if the person alias exists on the person record but is already marked as active and end effective.
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.
EXTERNAL_IND DOUBLE N When true (1), indicates the alias pool is for an assigning authority that is external to the health system network.
FORMAT_MASK VARCHAR(100) Y Character string which is used as a template to mask the raw alias stored in the ALIAS column so it can be displayed in it's formatted form.
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.
SECURITY_CHAR VARCHAR(1) Y The character to be used to secure characters in an alias when applying the mask.
SYS_ASSIGN_FLAG DOUBLE Y Identifies whether the alias can be automatically generated by the system.
SYS_ASSIGN_RELATED_PERSON_FLAG DOUBLE Y Identifies whether the related person alias can be automatically generated by the system.
UNIQUE_IND DOUBLE Y Unique Indicator
UNSECURED_CHAR_COUNT DOUBLE N Characters to secure when applying the alias mask. Positive number will mask the right hand characters. Negative numbers will mask the left hand characters.
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 - ALIAS_POOL


Child Column in ALIAS_POOL(FK) Parent Table Name Parent Column Name
Parents: LOGICAL_DOMAIN_ID LOGICAL_DOMAIN LOGICAL_DOMAIN_ID




Parent Column in ALIAS_POOL (PK) Child Table Name Child Column Name
Children: ALIAS_POOL_CD ALIAS_POOL_PPR_SELECTION ALIAS_POOL_CD
ALIAS_POOL_SEQ ALIAS_POOL_CD
ALIAS_POOL_TYPE_RELTN ALIAS_POOL_CD
ESI_ALIAS_TRANS ALIAS_POOL_CD
MATCH_TAG_PARMS ALIAS_POOL_CD
ORG_ALIAS_POOL_RELTN ALIAS_POOL_CD
PFT_ACCT_NUMBER ALIAS_POOL_ID
REFERRAL_MONIKER ALIAS_POOL_CD


ALIAS_POOL_PPR_SELECTION



Column Section Relationship Section Top of Page


Table-level Detail

Description: Alias Pool Person Person Relationship Selection
Definition: Defines the person relationship types that generate aliases for a related person.
Table Type: REFERENCE





Column Detail - ALIAS_POOL_PPR_SELECTION


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 Y 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 Y The person who caused the active_status_cd to be set or change.
ALIAS_POOL_CD DOUBLE Y Identifies the alias pool code to use when generating the alias for the related person.
ALIAS_POOL_PPR_SELECTION_ID DOUBLE N A system generated number to uniquely identify a row on the ALIAS_POOL_PPR_SELECTION table.
PERSON_RELTN_TYPE_CD DOUBLE Y Identifies the person relationship type code that determines if the alias should be generated for the related person.
UPDT_APPLCTX DOUBLE Y 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 Y 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 Y 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 Y 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 Y 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 - ALIAS_POOL_PPR_SELECTION


Child Column in ALIAS_POOL_PPR_SELECTION(FK) Parent Table Name Parent Column Name
Parents: ALIAS_POOL_CD ALIAS_POOL ALIAS_POOL_CD


ALIAS_POOL_SEQ



Column Section Relationship Section Top of Page


Table-level Detail

Description: Alias Pool Sequence Table
Definition: Table used to hold sequence number information for assigning aliases
Table Type: REFERENCE





Column Detail - ALIAS_POOL_SEQ


Column Name Type Null? Definition
ALIAS_POOL_CD DOUBLE N Unique identifier for associated alias pool
AP_SEQ_TYPE_CD DOUBLE N Unique identifier for sequence type
MAX_NBR DOUBLE N The upper value for alias sequence assignment
NEXT_NBR DOUBLE N The sequence value to be assigned next
START_NBR DOUBLE N The beginning value for alias sequence assignment
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 - ALIAS_POOL_SEQ


Child Column in ALIAS_POOL_SEQ(FK) Parent Table Name Parent Column Name
Parents: ALIAS_POOL_CD ALIAS_POOL ALIAS_POOL_CD


ALIAS_POOL_TYPE_RELTN



Column Section Relationship Section Top of Page


Table-level Detail

Description: Alias Pool Type Relationship
Definition: Defines relationships of alias pools to alias types.
Table Type: REFERENCE





Column Detail - ALIAS_POOL_TYPE_RELTN


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 Y 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 Y The person who caused the active_status_cd to be set or change.
ALIAS_ENTITY_ALIAS_TYPE_CD DOUBLE Y Identifies the type of alias for the given alias_entity_name (e.g. MRN, SSN, HNAMPERSONID, CMRN).
ALIAS_ENTITY_NAME VARCHAR(32) Y The entity name to which this alias pool relationship row is related (i.e. PERSON).
ALIAS_POOL_CD DOUBLE Y Identifies a unique set or list of identifiers (i.e. numbers). The alias pool code also determines the accept/display format for the unique set of identifies.
ALIAS_POOL_TYPE_RELTN_ID DOUBLE N A system generated number used to uniquely identify a row on the ALIAS_POOL_TYPE_RELTN table.
UPDT_APPLCTX DOUBLE Y 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 Y 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 Y 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 Y 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 Y 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 - ALIAS_POOL_TYPE_RELTN


Child Column in ALIAS_POOL_TYPE_RELTN(FK) Parent Table Name Parent Column Name
Parents: ALIAS_POOL_CD ALIAS_POOL ALIAS_POOL_CD


ORG_ALIAS_POOL_RELTN



Column Section Relationship Section Top of Page


Table-level Detail

Description: Organization Alias Pool Relationship
Definition: Defines relationships of organizations to alias pools.
Table Type: REFERENCE





Column Detail - ORG_ALIAS_POOL_RELTN


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.
ALIAS_ENTITY_ALIAS_TYPE_CD DOUBLE N Alias entity type code identifies the type of the alias for the given entity_name. (MRN, SSN, FIN, ESIORGALIAS, etc.)
ALIAS_ENTITY_NAME VARCHAR(32) N The upper case name of the table to which this alias relation row is related.
ALIAS_POOL_CD DOUBLE N Alias pool code identifies a unique set or list of identifiers (I.e., numbers). The alias pool code also determines the accept/display format for the unique set of identifiers.
AUTO_ASSIGN_FLAG DOUBLE Y Automatic Assignment Flag determines the assignment of the alias. (Future Use)
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.
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.
ORGANIZATION_ID DOUBLE N This is the value of the unique primary identifier of the organization 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 - ORG_ALIAS_POOL_RELTN


Child Column in ORG_ALIAS_POOL_RELTN(FK) Parent Table Name Parent Column Name
Parents: ALIAS_POOL_CD ALIAS_POOL ALIAS_POOL_CD
ORGANIZATION_ID ORGANIZATION ORGANIZATION_ID