Table Detail Report
ACCT_TEMPLATE
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | Account Template |
Definition: | This table stores the default behaviors for all accounts that are created based on this template. An account template is only owned by one billing entity and cannot be used to create accounts for other billing entities. |
Table Type: | REFERENCE |
Column Detail - ACCT_TEMPLATE
Column Name | Type | Null? | Definition |
---|---|---|---|
ACCT_SUB_TYPE_CD | DOUBLE | N | Is a sub type of the Acct_Type_Cd to further define the account. |
ACCT_TEMPL_DESC | VARCHAR(250) | Y | Description of the purpose of the template |
ACCT_TEMPL_ID | DOUBLE | N | Primary key and unique identifier. |
ACCT_TEMPL_NAME | VARCHAR(50) | Y | Stores the name given to the template |
ACCT_TEMPL_NAME_KEY | VARCHAR(250) | Y | Key Field for the Account Template Name in order to be sorted. |
ACCT_TYPE_CD | DOUBLE | N | Stores the type of accounts for this template (Cash, Revenue, General Patient) |
ACTIVE_IND | DOUBLE | Y | 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 | Y | 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. |
CONSOLIDATION_CD | DOUBLE | N | Determines whether an account based on this template will be consolidated. |
DEF_POST_METHOD_CD | DOUBLE | N | Sets the default posting method for all accounts based on this template (FIFO, LIFO, Distributed) - No longer used |
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. |
INACTIVITY_DAYS | DOUBLE | Y | Facilitates the automated process of closing accounts after a certain period of inactivity. |
OPEN_IND | DOUBLE | Y | Used to determine whether new accounts can be created off of this template. |
PRSNL_SEC_IND | DOUBLE | Y | Indicates whether this template has security permissions that override those at the Billing Entity level. - No longer used |
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 - ACCT_TEMPLATE
Parent Column in ACCT_TEMPLATE (PK) | Child Table Name | Child Column Name | |
---|---|---|---|
Children: | ACCT_TEMPL_ID | ACCOUNT | ACCT_TEMPL_ID |
ACCT_TEMPL_HIST | ACCOUNT_TEMPLATE_ID | ||
AT_ACCT_RELTN | ACCT_TEMPL_ID | ||
BE_AT_RELTN | ACCT_TEMPL_ID | ||
PFT_CHARGE | CR_ACCT_TEMPL_ID | ||
PFT_CHARGE | DR_ACCT_TEMPL_ID |
ACCT_TEMPL_HIST
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | This table holds the history of ProFit Account Templates |
Definition: | Account Template History |
Table Type: | REFERENCE |
Column Detail - ACCT_TEMPL_HIST
Column Name | Type | Null? | Definition |
---|---|---|---|
ACCOUNT_TEMPLATE_ID | DOUBLE | N | Account Template ID |
ACCT_SUB_TYPE_CD | DOUBLE | N | Account Sub Type Code |
ACCT_TEMPL_DESC | VARCHAR(250) | Y | Account Template Description |
ACCT_TEMPL_NAME | VARCHAR(250) | Y | Account Template Name |
ACCT_TYPE_CD | DOUBLE | N | Code value indicating the type of account. |
ACTIVE_IND | DOUBLE | Y | 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 | Y | 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. |
AT_VRSN_NBR | DOUBLE | N | Account Template Version Number |
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. |
CONSOLIDATION_CD | DOUBLE | N | Consolidation Code |
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. |
INACTIVITY_DAYS | DOUBLE | Y | The number of days an account must be inactive before being closed |
OPEN_IND | DOUBLE | Y | Whether the account template is open for creating new accounts - 0 = closed, 1 = open |
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 - ACCT_TEMPL_HIST
Child Column in ACCT_TEMPL_HIST(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | ACCOUNT_TEMPLATE_ID | ACCT_TEMPLATE | ACCT_TEMPL_ID |
ACCT_TYPE_GL_ALIAS_RELTN
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | Account Type General Ledger Alias Relation |
Definition: | Contains information about the relationship between the account type and the general ledger alias. |
Table Type: | REFERENCE |
Column Detail - ACCT_TYPE_GL_ALIAS_RELTN
Column Name | Type | Null? | Definition |
---|---|---|---|
ACCT_TYPE_CD | DOUBLE | N | Code value indicating the type of account. |
ACCT_TYPE_GL_ALIAS_RELTN_ID | DOUBLE | N | Primary Key |
ACTIVE_IND | DOUBLE | Y | 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 | Y | 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. |
GL_ALIAS_ID | DOUBLE | N | FK to the gl_alias 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 - ACCT_TYPE_GL_ALIAS_RELTN
Child Column in ACCT_TYPE_GL_ALIAS_RELTN(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | GL_ALIAS_ID | GL_ALIAS | GL_ALIAS_ID |
AM_FA_OPERATION_LOG
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | Account Management Financial Accounts Operation Log |
Definition: | This table will store the external operations performed on the Financial Accounts model |
Table Type: | ACTIVITY |
Column Detail - AM_FA_OPERATION_LOG
Column Name | Type | Null? | Definition |
---|---|---|---|
AM_FA_OPERATION_LOG_ID | DOUBLE | N | Unique generated number that identifies a single row on the AM_FA_OPERATION_LOG. |
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. |
OPERATION_DT_TM | DATETIME | Y | This represents when the operation occurred. |
OPERATION_IDENT | VARCHAR(30) | N | The external identifier for operation being applied to Financial Accounts model. |
OPERATION_TYPE_ENUM | DOUBLE | N | Operation type of the current operation. |
PARENT_AM_FA_OPERATION_LOG_ID | DOUBLE | Y | Identifies the parent AM_FA_OPERATION_LOG_ID to which the operation is associated. |
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 - AM_FA_OPERATION_LOG
Child Column in AM_FA_OPERATION_LOG(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | PARENT_AM_FA_OPERATION_LOG_ID | AM_FA_OPERATION_LOG | AM_FA_OPERATION_LOG_ID |
LOGICAL_DOMAIN_ID | LOGICAL_DOMAIN | LOGICAL_DOMAIN_ID |
Parent Column in AM_FA_OPERATION_LOG (PK) | Child Table Name | Child Column Name | |
---|---|---|---|
Children: | AM_FA_OPERATION_LOG_ID | AM_FA_OPERATION_LOG | PARENT_AM_FA_OPERATION_LOG_ID |
AR_BALANCE
Column Section | Top of Page |
Table-level Detail
Description: | AR BALANCE |
Definition: | Stores the balance information related to an A/R account. |
Table Type: | ACTIVITY |
Column Detail - AR_BALANCE
Column Name | Type | Null? | Definition |
---|---|---|---|
ACCOUNT_TYPE_CD | DOUBLE | N | Code value identifying the type of account (e.g. A/R, Cash, Revenue etc.) |
ACTIVE_IND | DOUBLE | Y | 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 | Y | 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. |
ADJUSTMENTS | DOUBLE | Y | Adjustment on an A/R account. |
ADJ_DR_CR_FLAG | DOUBLE | Y | Identifies the type of adjustment, debit or credit. |
AR_BALANCE | DOUBLE | Y | Balance on an A/R account. |
AR_BALANCE_ID | DOUBLE | N | Primary Key |
AR_DR_CR_FLAG | DOUBLE | Y | Identifies debit or credit. |
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. |
BILLING_ENTITY_ID | DOUBLE | N | Foreign key reference to the billing_entity table. |
CHARGES | DOUBLE | Y | Charges on an A/R account. |
CHRG_DR_CR_FLAG | DOUBLE | Y | Identifies the type of charge, debit or credit. |
ENDING_BALANCE | DOUBLE | Y | Ending Balance on an A/R account. |
ENDING_DR_CR_FLAG | DOUBLE | Y | Identifies the type of ending balance, debit or credit. |
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. |
OPENING_BALANCE | DOUBLE | Y | Opening balance on an A/R account. |
OPENING_DR_CR_FLAG | DOUBLE | Y | Identifies the type of opening balance, debit or credit. |
PAYMENTS | DOUBLE | Y | Payment on an A/R account. |
PMTS_DR_CR_FLAG | DOUBLE | Y | Identifies the type of payment, debit or credit. |
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. |