CHART_OF_ACCOUNT



Column Section Relationship Section Top of Page


Table-level Detail

Description: Chart of Accounts
Definition: Chart of Accounts
Table Type: REFERENCE





Column Detail - CHART_OF_ACCOUNT


Column Name Type Null? Definition
COST_CENTER_CD DOUBLE N Cost Center
ORGANIZATION_ID DOUBLE N Organization
SUB_ACCOUNT_CD DOUBLE N Sub Account Code
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 - CHART_OF_ACCOUNT


Child Column in CHART_OF_ACCOUNT(FK) Parent Table Name Parent Column Name
Parents: ORGANIZATION_ID ORGANIZATION ORGANIZATION_ID


COST_CENTER_TRANS_ACCOUNT



Column Section Relationship Section Top of Page


Table-level Detail

Description: COST CENTER TRANS ACCOUNT
Definition: Assigns cost centers to specific transaction types.
Table Type: REFERENCE





Column Detail - COST_CENTER_TRANS_ACCOUNT


Column Name Type Null? Definition
COST_CENTER_TRANS_ACCOUNT_ID DOUBLE N The identifier assigned to the cost center transaction account..
LOCATION_CD DOUBLE N The field identifies the current permanent location of the patient. The location for an inpatient will be valued with the lowest level location type in the hierarchy of facility, building, nurse unit, room, bed.
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.
TRANS_COST_CENTER_CD DOUBLE N The General Ledger Cost Center where this type of transaction will be charged for the selected location.
TRANS_SUB_ACCOUNT_CD DOUBLE N The general ledger sub account code or expense category that this additional amount will be charged to.
TRANS_SUB_TYPE_CD DOUBLE N The Transaction Sub Type Code is also known as a Transaction Reason Code. These Reason Codes allow you to define different reasons for transactions and code them to different general ledger accounts. For example an adjustment to inventory due to price changes might be coded differently than adjustments to inventory due to flood damage.
TRANS_TYPE_CD DOUBLE N The transaction type code is used to identify different transactions such as transfer/issue, vendor returns, adjustments etc.
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 - COST_CENTER_TRANS_ACCOUNT


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


FINANCIAL_PERIOD



Column Section Relationship Section Top of Page


Table-level Detail

Description: Financial Period
Definition: Financial Period
Table Type: REFERENCE





Column Detail - FINANCIAL_PERIOD


Column Name Type Null? Definition
FINANCIAL_PERIOD_ID DOUBLE N Part of the primary key.
FINANCIAL_YEAR_ID DOUBLE N Foreign key to financial_year table.
FROM_DT_TM DATETIME N The beginning date for this period.
TO_DT_TM DATETIME N The ending date for this period.
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 - FINANCIAL_PERIOD


Child Column in FINANCIAL_PERIOD(FK) Parent Table Name Parent Column Name
Parents: FINANCIAL_YEAR_ID FINANCIAL_YEAR FINANCIAL_YEAR_ID


FINANCIAL_YEAR



Column Section Relationship Section Top of Page


Table-level Detail

Description: Financial Year
Definition: Financial Year
Table Type: REFERENCE





Column Detail - FINANCIAL_YEAR


Column Name Type Null? Definition
DESCRIPTION VARCHAR(100) Y User defined description for this fiscal year.
FINANCIAL_YEAR_ID DOUBLE N Primary Key
ORGANIZATION_ID DOUBLE N Foreign key to organization 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.
YEAR_DT_TM DATETIME N The actual fiscal year.



Relationship Detail - FINANCIAL_YEAR


Child Column in FINANCIAL_YEAR(FK) Parent Table Name Parent Column Name
Parents: ORGANIZATION_ID ORGANIZATION ORGANIZATION_ID




Parent Column in FINANCIAL_YEAR (PK) Child Table Name Child Column Name
Children: FINANCIAL_YEAR_ID FINANCIAL_PERIOD FINANCIAL_YEAR_ID