Table Detail Report

OMF_GL_ACCT



Column Section Relationship Section Top of Page


Table-level Detail

Description: Contains the OMF General Ledger account data.
Definition: omf_gl_acct
Table Type: ACTIVITY





Column Detail - OMF_GL_ACCT


Column Name Type Null? Definition
ACCT_CODE VARCHAR(50) Y An abbreviation for an account
ACCT_DESC VARCHAR(100) Y A descriptive name that identifies the nature of the transactions that are posted to the general ledger.
ACCT_TYPE VARCHAR(100) Y The name of a grouping of like accounts in a general ledger.
ACCT_TYPE_CODE VARCHAR(50) Y The abbreviation for an account type.
COST_CENTER_CD DOUBLE N The cost center to which the general ledger account belongs.
COST_CENTER_CODE VARCHAR(50) Y The abbreviation for a cost center.
COST_CENTER_DESC VARCHAR(100) Y The description of a cost center.
DEPT_CD DOUBLE N The department to which a general ledger account belongs
DEPT_CODE VARCHAR(50) Y The abbreviation for the department.
DEPT_DESC VARCHAR(100) Y The description of the department.
FACILITY_CD DOUBLE N The facility to which a general ledger account belongs.
FACILITY_CODE VARCHAR(50) Y The abbreviation for the facility.
FACILITY_DESC VARCHAR(100) Y The description of the facility
FUND_CODE VARCHAR(50) Y The abbreviation for the fund.
FUND_DESC VARCHAR(100) Y The fund to which a general ledger account belongs.
GL_ACCT_IDENT VARCHAR(255) Y The concatenation of all component parts that identify a general ledger account.
GL_ACCT_IDENT_CODE VARCHAR(100) Y The abbreviation for a GL account ID.
INSTITUTION_CD DOUBLE N The institution to which a general ledger account belongs.
INSTITUTION_CODE VARCHAR(50) Y The abbreviation for the institution.
INSTITUTION_DESC VARCHAR(100) Y The description for the institution.
OMF_GL_ACCT_ID DOUBLE N The unique identifier for the omf_gl_acct table.
PROJECT_CODE VARCHAR(50) Y The abbreviation for the project.
PROJECT_DESC VARCHAR(100) Y The project to which a general ledger account belongs.
SMRY_GRP10_CODE VARCHAR(50) Y Client defined grouping of accounts.
SMRY_GRP10_DESC VARCHAR(100) Y Client defined grouping of accounts.
SMRY_GRP1_CODE VARCHAR(50) Y Client defined grouping of accounts.
SMRY_GRP1_DESC VARCHAR(100) Y Client defined grouping of accounts.
SMRY_GRP2_CODE VARCHAR(50) Y Client defined grouping of accounts.
SMRY_GRP2_DESC VARCHAR(100) Y Client defined grouping of accounts.
SMRY_GRP3_CODE VARCHAR(50) Y Client defined grouping of accounts.
SMRY_GRP3_DESC VARCHAR(100) Y Client defined grouping of accounts.
SMRY_GRP4_CODE VARCHAR(50) Y Client defined grouping of accounts.
SMRY_GRP4_DESC VARCHAR(100) Y Client defined grouping of accounts.
SMRY_GRP5_CODE VARCHAR(50) Y Client defined grouping of accounts.
SMRY_GRP5_DESC VARCHAR(100) Y Client defined grouping of accounts.
SMRY_GRP6_CODE VARCHAR(50) Y Client defined grouping of accounts.
SMRY_GRP6_DESC VARCHAR(100) Y Client defined grouping of accounts.
SMRY_GRP7_CODE VARCHAR(50) Y Client defined grouping of accounts.
SMRY_GRP7_DESC VARCHAR(100) Y Client defined grouping of accounts.
SMRY_GRP8_CODE VARCHAR(50) Y Client defined grouping of accounts.
SMRY_GRP8_DESC VARCHAR(100) Y Client defined grouping of accounts.
SMRY_GRP9_CODE VARCHAR(50) Y Client defined grouping of accounts.
SMRY_GRP9_DESC VARCHAR(100) Y Client defined grouping of accounts.
SUB_ACCT1_CODE VARCHAR(50) Y The abbreviation for the sub account.
SUB_ACCT1_DESC VARCHAR(100) Y A descriptive name that identifies the nature of transactions that are posted to the GL.
SUB_ACCT2_CODE VARCHAR(50) Y The abbreviation for the sub account.
SUB_ACCT2_DESC VARCHAR(100) Y A descriptive name that identifies the nature of transactions that are posted to the GL.
SUB_ACCT3_CODE VARCHAR(50) Y The abbreviation for the sub account.
SUB_ACCT3_DESC VARCHAR(100) Y A descriptive name that identifies the nature of transactions that are posted to the GL.
SUB_ACCT4_CODE VARCHAR(50) Y The abbreviation for the sub account.
SUB_ACCT4_DESC VARCHAR(100) Y A descriptive name that identifies the nature of transactions that are posted to the GL.
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.



Relationship Detail - OMF_GL_ACCT




Parent Column in OMF_GL_ACCT (PK) Child Table Name Child Column Name
Children: OMF_GL_ACCT_ID OMF_ACR_FACT OMF_GL_ACCT_ID
OMF_BLS_FACT OMF_GL_ACCT_ID
OMF_ICS_BDGT OMF_GL_ACCT_ID
OMF_ICS_FACT OMF_GL_ACCT_ID


OMF_ICS_BDGT



Column Section Relationship Section Top of Page


Table-level Detail

Description: Income statement budget
Definition: omf_ics_bdgt
Table Type: ACTIVITY





Column Detail - OMF_ICS_BDGT


Column Name Type Null? Definition
BDGT_ACTIVITY DOUBLE Y The net budgeted activity.
BDGT_UNITS_SERV1 DOUBLE Y The budgeted units of service 1 volume
BDGT_UNITS_SERV2 DOUBLE Y The budgeted units of service 2 volume
OMF_FISCAL_DATE_ID DOUBLE N The unique identifier for the omf_fiscal_date table.
OMF_GL_ACCT_ID DOUBLE N The unique identifier for the omf_gl_acct table.
OMF_ICS_BDGT_ID DOUBLE N The unique identifier for the omf_ics_bdgt table.
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.



Relationship Detail - OMF_ICS_BDGT


Child Column in OMF_ICS_BDGT(FK) Parent Table Name Parent Column Name
Parents: OMF_FISCAL_DATE_ID OMF_FISCAL_CALENDAR OMF_FISCAL_CALENDAR_ID
OMF_GL_ACCT_ID OMF_GL_ACCT OMF_GL_ACCT_ID


OMF_ICS_FACT



Column Section Relationship Section Top of Page


Table-level Detail

Description: Stores the transaction level data from the OMF income statement interface.
Definition: omf_ics_fact
Table Type: ACTIVITY





Column Detail - OMF_ICS_FACT


Column Name Type Null? Definition
ACCT_CR DOUBLE Y The total dollar amount credited to an account.
ACCT_DR DOUBLE Y The total dollar amount debited to an account.
INTERFACE_DT_TM DATETIME Y The date/time on which the transaction was sent through the interface.
INTERFACE_TZ DOUBLE Y Time zone associated with the corresponding DT_TM column.
NBR_UNITS_OF_SERVICE1 DOUBLE Y Volume of unit of service 1.
NBR_UNITS_OF_SERVICE2 DOUBLE Y Volume of Units of service 2.
NET_ACCT_ACTIVITY DOUBLE Y The net dollar amount posted to the account for the designated time period.
NET_ACCT_ACTIVITY_PYEAR DOUBLE Y The net dollar amount posted to the account for the designated time period the prior year.
OMF_FISCAL_DATE_ID DOUBLE N The unique identifier for the omf_fiscal_date table.
OMF_GL_ACCT_ID DOUBLE N The unique identifier for the omf_gl_acct table.
OMF_ICS_FACT_ID DOUBLE N The unique identifier for the omf_ics_fact table.
UNITS_OF_SERVICE1_DESC VARCHAR(100) Y Client defined unit of service they choose to use to measure GL activity against.
UNITS_OF_SERVICE2_DESC VARCHAR(100) Y Client defined unit of service they choose to use to measure GL activity against.
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.



Relationship Detail - OMF_ICS_FACT


Child Column in OMF_ICS_FACT(FK) Parent Table Name Parent Column Name
Parents: OMF_FISCAL_DATE_ID OMF_FISCAL_CALENDAR OMF_FISCAL_CALENDAR_ID
OMF_GL_ACCT_ID OMF_GL_ACCT OMF_GL_ACCT_ID


OMF_INTERFACE_ERROR



Column Section Top of Page


Table-level Detail

Description: Logs errors from omf interfaces
Definition: omf_interface_error
Table Type: ACTIVITY





Column Detail - OMF_INTERFACE_ERROR


Column Name Type Null? Definition
CONTRIBUTOR_SOURCE_CD DOUBLE N This will be used to specify the primary contributor source when performing alias codification/decodification for ESI and ESO transaction processes.
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.
CONTRIBUTOR_SYSTEM_STR VARCHAR(100) Y 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.
DATA_STR VARCHAR(255) Y The raw data string sent in the omf interface
ERROR_MSG VARCHAR(255) Y The error message resulting from an error in the omf interface.
INTERFACE_COL_DESC VARCHAR(100) Y The column description of the field that produced an error in the omf interface.
INTERFACE_DT_TM DATETIME Y The date/time that the omf interface was executed.
INTERFACE_SEQ VARCHAR(25) Y The interface sequence of the column that resulted in an error in the omf interface.
OMF_INTERFACE_ERROR_ID DOUBLE N The unique identifier for the omf_interface_error table
PARENT_ENTITY_ALIAS VARCHAR(200) Y The alias value for the field that resulted in an error in the omf interface.
PARENT_ENTITY_ALIAS_TYPE VARCHAR(50) Y The alias type of the field that resulted in an error in the omf interface.
PARENT_ENTITY_ID DOUBLE N Column no longer used. The unique identifier of the field that resulted in an error in the omf interface
PARENT_ENTITY_NAME VARCHAR(50) Y Column no longer used. The table name for the column value that resulted in an error in the omf interface.
SEGMENT VARCHAR(25) Y The segment that resulted in an error in the omf interface.
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.


OMF_LOCATION_HIST_ST



Column Section Relationship Section Top of Page


Table-level Detail

Description: OMF LOCATION HIST ST
Definition: Stores location history for a given encounter.
Table Type: ACTIVITY





Column Detail - OMF_LOCATION_HIST_ST


Column Name Type Null? Definition
BEG_TRANSACTION_DT_NBR DOUBLE Y The Julian date for the date on which the person was moved to this location.
BEG_TRANSACTION_DT_TM DATETIME Y The date/time on which the person was moved to this location.
BEG_TRANSACTION_MIN_NBR DOUBLE Y The minute of the day on which the person was moved to this location.
BEG_TRANSACTION_TZ DOUBLE Y Time zone associated with the corresponding DT_TM column.
ENCNTR_ID DOUBLE N This is the value of the unique primary identifier of the encounter table. It is an internal system assigned number.
ENCNTR_LOC_HIST_ID DOUBLE N This is the value of the unique primary identifier of the encounter location history table. It is an internal system assigned number.
END_TRANSACTION_DT_NBR DOUBLE Y The Julian date on which the person was moved from this location.
END_TRANSACTION_DT_TM DATETIME Y The date/time on which the person was moved from this location.
END_TRANSACTION_MIN_NBR DOUBLE Y The minute of the day on which the person was moved from this location.
END_TRANSACTION_TZ DOUBLE Y Time zone associated with the corresponding DT_TM column.
LOC_BED_CD DOUBLE N The code_value for the bed in which the patient is located.
LOC_BUILDING_CD DOUBLE N The code value for the building at which the patient is located.
LOC_FACILITY_CD DOUBLE N The code value for the facility at which the patient is located.
LOC_NURSE_UNIT_CD DOUBLE N The code value for the nurse unit at which the patient is located.
LOC_NURSE_UNIT_GRP2_CD DOUBLE N The code_value representing the second nurse unit grouping as defined within the OMF Grouping Tool.
LOC_NURSE_UNIT_GRP_CD DOUBLE N The code_value representing the nurse unit grouping as defined within the OMF Grouping Tool.
LOC_ROOM_CD DOUBLE N The code_value representing the room in which the patient is located.
NU_ARRIVE_DT_NBR DOUBLE Y The Julian date for on which the person arrived at the nurse unit.
NU_ARRIVE_DT_TM DATETIME Y The date/time on which the person arrived at the nurse unit.
NU_ARRIVE_MIN_NBR DOUBLE Y The minute at which the person arrived at the nurse unit.
NU_ARRIVE_TZ DOUBLE Y Time zone associated with the corresponding DT_TM column.
NU_DEPART_DT_NBR DOUBLE Y The Julian date on which the person transferred from the nurse unit.
NU_DEPART_DT_TM DATETIME Y The date/time on which the person was transferred from the nurse unit.
NU_DEPART_MIN_NBR DOUBLE Y The minute on which the person was transferred from the nurse unit.
NU_DEPART_TZ DOUBLE Y Time zone associated with the corresponding DT_TM column.
PREVIOUS_NURSE_UNIT_CD DOUBLE N The code_value representing the nurse unit from which the patient was transferred.
TRANSACTION_IND DOUBLE Y Transaction counter - value should always be 1.
TRANSFER_REASON_CD DOUBLE N The reason for the patient transfer
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 - OMF_LOCATION_HIST_ST


Child Column in OMF_LOCATION_HIST_ST(FK) Parent Table Name Parent Column Name
Parents: ENCNTR_ID ENCOUNTER ENCNTR_ID