My Oracle Support Banner

Extend HDI.HDI_BILL_ADJMT To Include Many Additional Attributes Especially UDAs (Doc ID 2720513.1)

Last updated on OCTOBER 30, 2020

Applies to:

Oracle Healthcare Foundation - Version 7.3 and later
Information in this document applies to any platform.

Goal

The purpose of this document is to advise that an ER was raised to extend HDI.HDI_BILL_ADJMT to include many additional attributes especially User Define Attributes (UDAs) to meet the Revenue reporting requirements of the customer. 

HDI.HDI_BILL_ADJMT ingestion table and HDM area needs substantial extension and the following are some examples of the extensions needed:

15-20 Text UDAs
5 Numeric UDAs
5 Date UDAs
10 Coding system UDAs
in addition to other specified columns such as:
  GL_COST_CNTR_INT_ID
  GL_COST_CNTR_DAT_SRC_NUM_ID
  GL_COMPANY_INT_ID
  GL_COMPANY_DAT_SRC_NUM_ID
  GL_ACCT_UNIT_INT_ID
  GL_ACCT_UNIT_DAT_SRC_NUM_ID
  BILL_LN_ITM_INT_ID
  BILL_LN_ITM_DAT_SRC_NUM_ID
  ENC_CHRG_NBR
  POSTED_CHRG_NBR
  ENC_INT_ID
  ENC_DAT_SRC_NUM_ID
  COMB_ENC_INT_ID
  COMB_ENC_DAT_SRC_NUM_ID
  BILL_ENTY_INT_ID
  BILL_ENTY_DAT_SRC_NUM_ID
  GL_PSTNG_STUS_CD
  GL_PSTNG_STUS_CDG_SYS
  GL_PSTNG_STUS_CDG_SYS_VER
  ACTIVITY_DT
  FIN_CLASS_CD
  FIN_CLASS_CDG_SYS
  FIN_CLASS_CDG_SYS_VER
  PT_INT_ID
  PT_DAT_SRC_NUM_ID
  FIN_TRANS_ALIAS
  FIN_TRANS_TYPE_CD
  FIN_TRANS_TYPE_CDG_SYS
  FIN_TRANS_TYPE_CDG_SYS_VER
  DR_CR_IND
  ACCT_NUM
  ACCT_ID
 

Solution

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Goal
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.