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.