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 |