LOGICAL_DOMAIN



Column Section Relationship Section Top of Page


Table-level Detail

Description: Logical Domain
Definition: The logical_domain table is used to represent a logical database partition used to sub-divide data on tables where data is not shared between partition owners. An example would be having multiple clients using the same domain and Millennium tables. Each client would have their own logical domain identifier.
Table Type: REFERENCE





Column Detail - LOGICAL_DOMAIN


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.
DESCRIPTION VARCHAR(255) N Description of the logical domain.
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.
MNEMONIC VARCHAR(100) N A character string used to identify the logical domain.
MNEMONIC_KEY VARCHAR(100) N The mnemonic in upper case with the non-alphanumeric characters removed.
MNEMONIC_KEY_A_NLS VARCHAR(400) Y MNEMONIC_KEY_A_NLS column
MNEMONIC_KEY_NLS VARCHAR(202) N Mnemonic Key field converted to NLS format for internationalization requirements.
SYSTEM_USER_ID DOUBLE N Identifies a system user for the given logical domain. This can be leveraged by applications needing to impersonate a user with access to this domain.
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 - LOGICAL_DOMAIN


Child Column in LOGICAL_DOMAIN(FK) Parent Table Name Parent Column Name
Parents: SYSTEM_USER_ID PRSNL PERSON_ID




Parent Column in LOGICAL_DOMAIN (PK) Child Table Name Child Column Name
Children: LOGICAL_DOMAIN_ID AC_CLASS_DEF LOGICAL_DOMAIN_ID
ADDITIONAL_AMOUNT_DEF LOGICAL_DOMAIN_ID
ALIAS_POOL LOGICAL_DOMAIN_ID
AM_FA_OPERATION_LOG LOGICAL_DOMAIN_ID
AP_EXT_DATA LOGICAL_DOMAIN_ID
AUTHORIZATION_AGE_RANGE LOGICAL_DOMAIN_ID
AUTHORIZATION_PROFILE LOGICAL_DOMAIN_ID
BATCH_TRANS LOGICAL_DOMAIN_ID
BILL_ITEM LOGICAL_DOMAIN_ID
BR_CCN LOGICAL_DOMAIN_ID
BR_CPC LOGICAL_DOMAIN_ID
BR_ELIGIBLE_PROVIDER LOGICAL_DOMAIN_ID
BR_GPRO LOGICAL_DOMAIN_ID
BR_GPRO_SUB LOGICAL_DOMAIN_ID
BR_GPRO_SUB_RELTN LOGICAL_DOMAIN_ID
BR_PORTAL_URL LOGICAL_DOMAIN_ID
CDI_ARCHIVE LOGICAL_DOMAIN_ID
CDI_CM_FOLDER LOGICAL_DOMAIN_ID
CDI_FORM LOGICAL_DOMAIN_ID
CDI_IMPORT_TYPE LOGICAL_DOMAIN_ID
CDI_LOGICAL_DOMAIN_CONFIG LOGICAL_DOMAIN_ID
CDI_PENDING_BATCH LOGICAL_DOMAIN_ID
CDI_PURGE_DOCUMENT LOGICAL_DOMAIN_ID
CDI_SERVICE_INSTANCE LOGICAL_DOMAIN_ID
CDI_WORK_QUEUE LOGICAL_DOMAIN_ID
CE_UUID LOGICAL_DOMAIN_ID
CHARGE_DESC_MASTER LOGICAL_DOMAIN_ID
CHARTING_OPERATIONS LOGICAL_DOMAIN_ID
CHART_DISTRIBUTION LOGICAL_DOMAIN_ID
CHART_LAW LOGICAL_DOMAIN_ID
CLASS_NODE LOGICAL_DOMAIN_ID
CLOUD_ALERT_FEEDS LOGICAL_DOMAIN_ID
CODE_VALUE_LOG_DOMAIN_R LOGICAL_DOMAIN_ID
COST_CENTER_TRANS_ACCOUNT LOGICAL_DOMAIN_ID
CP_PATHWAY LOGICAL_DOMAIN_ID
CP_PATHWAY_GROUP LOGICAL_DOMAIN_ID
CR_MASK LOGICAL_DOMAIN_ID
CR_REPORT_REQUEST_ARCHIVE LOGICAL_DOMAIN_ID
CT_CUSTOM_FIELD LOGICAL_DOMAIN_ID
CT_CUSTOM_FIELD_GROUP_RELTN LOGICAL_DOMAIN_ID
CT_DEFAULT_CUSTOM_FIELDS LOGICAL_DOMAIN_ID
CT_DEFAULT_MILESTONES LOGICAL_DOMAIN_ID
CT_DOMAIN_INFO LOGICAL_DOMAIN_ID
CT_PROT_TYPE_CONFIG LOGICAL_DOMAIN_ID
CV_SMART_CONFIG LOGICAL_DOMAIN_ID
DEM_XTRCT_NSTNC MILL_LOGICAL_DOMAIN_ID
DM_INFO INFO_DOMAIN_ID
DS_TAG LOGICAL_DOMAIN_ID
DS_TAG_TYPE LOGICAL_DOMAIN_ID
EHI_QUEUE LOGICAL_DOMAIN_ID
ELIG_QUEST_LIBRARY LOGICAL_DOMAIN_ID
EXPEDITE_PARAMS LOGICAL_DOMAIN_ID
EXPEDITE_TRIGGER LOGICAL_DOMAIN_ID
EXT_DOC_TEMPLATE_CONFIG LOGICAL_DOMAIN_ID
FAV_FOLDER_CAT LOGICAL_DOMAIN_ID
GEN_LAB_EXT_DATA LOGICAL_DOMAIN_ID
GL_TRANS_LOG LOGICAL_DOMAIN_ID
HEALTH_PLAN LOGICAL_DOMAIN_ID
HIM_CONFIG LOGICAL_DOMAIN_ID
HIM_CONFIG_INDEX LOGICAL_DOMAIN_ID
HM_EXPECT_SOURCE LOGICAL_DOMAIN_ID
HPD_ADDRESS LOGICAL_DOMAIN_ID
HPD_ORGANIZATION LOGICAL_DOMAIN_ID
HPD_PROVIDER LOGICAL_DOMAIN_ID
HPD_SPECIALTY LOGICAL_DOMAIN_ID
IBUS_DOMAIN LOGICAL_DOMAIN_ID
IDENTIFIER LOGICAL_DOMAIN_ID
INTERFACE_FILE LOGICAL_DOMAIN_ID
ITEM_DEFINITION LOGICAL_DOMAIN_ID
JOB_EXECUTION LOGICAL_DOMAIN_ID
LAB_EXT_IDENTIFIER LOGICAL_DOMAIN_ID
LEGAL_AUTHORITY LOGICAL_DOMAIN_ID
LH_D_BR_HCO LOGICAL_DOMAIN_ID
LH_D_BUILDING LOGICAL_DOMAIN_ID
LH_D_FACILITY LOGICAL_DOMAIN_ID
LH_D_NURSE_UNIT LOGICAL_DOMAIN_ID
LH_E_APHYBD_2024_METRICS LOGICAL_DOMAIN_ID
LH_E_HH_2023_METRICS LOGICAL_DOMAIN_ID
LH_E_HH_2024_METRICS LOGICAL_DOMAIN_ID
LH_E_HYBRID_2022_METRICS LOGICAL_DOMAIN_ID
LH_E_HYBRID_2023_METRICS LOGICAL_DOMAIN_ID
LH_E_HYBRID_2024_METRICS LOGICAL_DOMAIN_ID
LH_E_STEMI_2023_METRICS LOGICAL_DOMAIN_ID
LH_E_STEMI_2024_METRICS LOGICAL_DOMAIN_ID
LH_PERFORMANCE_AUDIT LOGICAL_DOMAIN_ID
LH_SDOH_METRICS LOGICAL_DOMAIN_ID
LH_THA_TKA_METRICS LOGICAL_DOMAIN_ID
LOGICAL_DOMAIN_GRP_RELTN LOGICAL_DOMAIN_ID
MIC_EXT_DATA LOGICAL_DOMAIN_ID
MM_DB_LOG LOGICAL_DOMAIN_ID
MM_OMF_ITEM_MASTER LOGICAL_DOMAIN_ID
MM_OMF_MFG_ITEM LOGICAL_DOMAIN_ID
MM_OMF_VENDOR_ITEM LOGICAL_DOMAIN_ID
MM_PROFILE LOGICAL_DOMAIN_ID
MM_PROJECT_NBR_TRACKING LOGICAL_DOMAIN_ID
MM_TRANS_HEADER LOGICAL_DOMAIN_ID
MM_XFI_ASN_HEADER LOGICAL_DOMAIN_ID
MM_XFI_ASN_LINE LOGICAL_DOMAIN_ID
MM_XFI_COST LOGICAL_DOMAIN_ID
MM_XFI_INSTANCE LOGICAL_DOMAIN_ID
MM_XFI_ITEM LOGICAL_DOMAIN_ID
MM_XFI_ITEMLOC LOGICAL_DOMAIN_ID
MM_XFI_LOCATOR LOGICAL_DOMAIN_ID
MM_XFI_PAYMENT LOGICAL_DOMAIN_ID
MM_XFI_QOH LOGICAL_DOMAIN_ID
MM_XFI_REQ_FILL LOGICAL_DOMAIN_ID
MM_XFI_REQ_FILL_LOT LOGICAL_DOMAIN_ID
OBJECT_IDENTIFIER_INDEX LOGICAL_DOMAIN_ID
OCS_ATTR_XCPTN LOGICAL_DOMAIN_ID
ORDER_RESULTS_HOLD_CONFIG LOGICAL_DOMAIN_ID
ORGANIZATION LOGICAL_DOMAIN_ID
ORG_TRANS_IDENT LOGICAL_DOMAIN_ID
PCT_CARE_TEAM LOGICAL_DOMAIN_ID
PERSON LOGICAL_DOMAIN_ID
PFT_ARWB_DATA_EXT LOGICAL_DOMAIN_ID
PFT_CHRG_GRP_RPRCS LOGICAL_DOMAIN_ID
PFT_CHRG_GRP_RPRCS_HIST LOGICAL_DOMAIN_ID
PFT_CONFIG INFO_DOMAIN_ID
PFT_DATE LOGICAL_DOMAIN_ID
PFT_DENIAL_CODE_REF LOGICAL_DOMAIN_ID
PFT_DUNNING_MSG LOGICAL_DOMAIN_ID
PFT_EVENT LOGICAL_DOMAIN_ID
PFT_PAYMENT_LOCATION_DEF LOGICAL_DOMAIN_ID
PFT_QUEUE_ASSIGNMENT LOGICAL_DOMAIN_ID
PFT_QUEUE_DEFINITION LOGICAL_DOMAIN_ID
PFT_QUEUE_ITEM LOGICAL_DOMAIN_ID
PFT_QUEUE_ITEM_HIST LOGICAL_DOMAIN_ID
PFT_QUEUE_ITEM_WF_HIST LOGICAL_DOMAIN_ID
PFT_RULE LOGICAL_DOMAIN_ID
PFT_RULESET LOGICAL_DOMAIN_ID
PFT_SURCHARGE_CONFIG LOGICAL_DOMAIN_ID
PFT_SURCHARGE_RATE_CONFIG LOGICAL_DOMAIN_ID
PFT_SYSTEM_ACTIVITY_LOG LOGICAL_DOMAIN_ID
PFT_TRANS_ALIAS LOGICAL_DOMAIN_ID
PFT_TRANS_DIST_CONFIG LOGICAL_DOMAIN_ID
PFT_WF_ISSUE LOGICAL_DOMAIN_ID
PFT_WF_PROCESS_MODEL LOGICAL_DOMAIN_ID
PIE_EXT_SOURCE LOGICAL_DOMAIN_ID
PM_CONSUMER_ACTIVITY LOGICAL_DOMAIN_ID
PM_DOC_DISTRIBUTION LOGICAL_DOMAIN_ID
PM_QUE_WORK_LIST_CONFIG LOGICAL_DOMAIN_ID
PM_SCH_COMMON_NAMES LOGICAL_DOMAIN_ID
PO_NUMBER_SEED LOGICAL_DOMAIN_ID
PPR_CONSENT_POLICY LOGICAL_DOMAIN_ID
PRACTICE_SITE LOGICAL_DOMAIN_ID
PRACTICE_SITE_MSG_ROUTING LOGICAL_DOMAIN_ID
PROT_DEFAULT_ROLES LOGICAL_DOMAIN_ID
PROT_MASTER LOGICAL_DOMAIN_ID
PROT_ROLE_ACCESS LOGICAL_DOMAIN_ID
PRSNL LOGICAL_DOMAIN_ID
PRSNL_GROUP_POOL LOGICAL_DOMAIN_ID
PULSE_GEN LOGICAL_DOMAIN_ID
RAD_STG_DATA LOGICAL_DOMAIN_ID
RAD_WRKLST_DEF LOGICAL_DOMAIN_ID
RCA_CONVERSATION LOGICAL_DOMAIN_ID
RCA_CONV_GROUP LOGICAL_DOMAIN_ID
RCA_CONV_TRANSIENT_FIELD LOGICAL_DOMAIN_ID
RCA_MOBILE_PROFILE LOGICAL_DOMAIN_ID
RCA_NOTIFICATION LOGICAL_DOMAIN_ID
RCA_REG_ACTION LOGICAL_DOMAIN_ID
RCA_RULE LOGICAL_DOMAIN_ID
RCA_RULE_SERVICE LOGICAL_DOMAIN_ID
RCM_THIRD_PARTY_ACCOUNT LOGICAL_DOMAIN_ID
RCM_TLC_ACCT_LD_R LOGICAL_DOMAIN_ID
RCR_GSR_CONTEXT LOGICAL_DOMAIN_ID
RCR_RVU_MODIFIER_FORMULA LOGICAL_DOMAIN_ID
RC_CLN_AREA MILL_LOGICAL_DOMAIN_ID
RC_CONFIG_DOCUMENT LOGICAL_DOMAIN_ID
RC_CONT_MODEL LOGICAL_DOMAIN_ID
RC_F_CASE_MIX MILL_LOGICAL_DOMAIN_ID
RC_F_MTH_CHRG_ASSOC_SMRY MILL_LOGICAL_DOMAIN_ID
RC_PARAMETER_SET LOGICAL_DOMAIN_ID
RC_SERVICE_SET LOGICAL_DOMAIN_ID
REQUESTER LOGICAL_DOMAIN_ID
REQUISITION LOGICAL_DOMAIN_ID
RVC_CLOCK_CONFIG LOGICAL_DOMAIN_ID
RX_VIEW_CONFIG LOGICAL_DOMAIN_ID
RX_WORK_ITEM_QUEUE LOGICAL_DOMAIN_ID
SCH_ACTIVITY LOGICAL_DOMAIN_ID
SCH_APPT_BOOK LOGICAL_DOMAIN_ID
SCH_APPT_OPTION_CONFIG LOGICAL_DOMAIN_ID
SCH_APPT_SYN LOGICAL_DOMAIN_ID
SCH_DATE_SET LOGICAL_DOMAIN_ID
SCH_DEF_SCHED LOGICAL_DOMAIN_ID
SCH_DISP_SCHEME LOGICAL_DOMAIN_ID
SCH_FLEX_STRING LOGICAL_DOMAIN_ID
SCH_JAVA_CONV LOGICAL_DOMAIN_ID
SCH_LIST_ROLE LOGICAL_DOMAIN_ID
SCH_OBJECT LOGICAL_DOMAIN_ID
SCH_QUERY LOGICAL_DOMAIN_ID
SCH_REPORT LOGICAL_DOMAIN_ID
SCH_RESOURCE LOGICAL_DOMAIN_ID
SCH_RESOURCE_LIST LOGICAL_DOMAIN_ID
SCH_RES_GROUP LOGICAL_DOMAIN_ID
SCH_ROLE LOGICAL_DOMAIN_ID
SCH_ROUTE LOGICAL_DOMAIN_ID
SCH_SLOT_GROUP LOGICAL_DOMAIN_ID
SCH_SLOT_TYPE LOGICAL_DOMAIN_ID
SCH_TEMPLATE LOGICAL_DOMAIN_ID
SERVICE_TYPE_GROUPING LOGICAL_DOMAIN_ID
SI_DIRECT_MESSAGE LOGICAL_DOMAIN_ID
SI_EXTERNAL_SERVICE LOGICAL_DOMAIN_ID
SI_UNMTCHD_PRSN_QUE LOGICAL_DOMAIN_ID
UCM_EXPL_MNU_SELECTION LOGICAL_DOMAIN_ID
VENDOR LOGICAL_DOMAIN_ID
WL_CRITERIA LOGICAL_DOMAIN_ID


LOGICAL_DOMAIN_GRP



Column Section Relationship Section Top of Page


Table-level Detail

Description: Logical Domain Group
Definition: This table is used to group various domains into logical groups. One use of this would be to assign authority by logical domain group which would allow a user to access the data for more than one domain
Table Type: REFERENCE





Column Detail - LOGICAL_DOMAIN_GRP


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.
DESCRIPTION VARCHAR(255) N The description of the logical domain group.
LOGICAL_DOMAIN_GRP_ID DOUBLE N The unique primary key of this table.
MNEMONIC VARCHAR(100) N A character string used to identify the logical domain group.
MNEMONIC_KEY VARCHAR(100) N The mnemonic in upper case with the non-alphanumeric characters removed.
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 - LOGICAL_DOMAIN_GRP




Parent Column in LOGICAL_DOMAIN_GRP (PK) Child Table Name Child Column Name
Children: LOGICAL_DOMAIN_GRP_ID LOGICAL_DOMAIN_GRP_RELTN LOGICAL_DOMAIN_GRP_ID
PRSNL LOGICAL_DOMAIN_GRP_ID


LOGICAL_DOMAIN_GRP_RELTN



Column Section Relationship Section Top of Page


Table-level Detail

Description: Logical Domain Group Relation
Definition: This relation table associates logical domains with a logical domain group.
Table Type: REFERENCE





Column Detail - LOGICAL_DOMAIN_GRP_RELTN


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.
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.
LOGICAL_DOMAIN_GRP_ID DOUBLE N The ID of the group the logical domain ID is related to. It is the primary key of the Logical_Domain_Grp table.
LOGICAL_DOMAIN_GRP_RELTN_ID DOUBLE N The unique primary key of this table.
LOGICAL_DOMAIN_ID DOUBLE N The identifier of the logical domain that is related to the logical domain group. It is the primary key of the Logical_Domain_Group table.
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 - LOGICAL_DOMAIN_GRP_RELTN


Child Column in LOGICAL_DOMAIN_GRP_RELTN(FK) Parent Table Name Parent Column Name
Parents: LOGICAL_DOMAIN_ID LOGICAL_DOMAIN LOGICAL_DOMAIN_ID
LOGICAL_DOMAIN_GRP_ID LOGICAL_DOMAIN_GRP LOGICAL_DOMAIN_GRP_ID