ACCOUNT



Column Section Relationship Section Top of Page


Table-level Detail

Description: Account
Definition: The account table will hold information about internal organization accounts as well as patient accounts
Table Type: REFERENCE





Column Detail - ACCOUNT


Column Name Type Null? Definition
ACCT_BALANCE DOUBLE Y Stores the current balance on the account.
ACCT_DESC VARCHAR(250) Y Free Text Description
ACCT_ID DOUBLE N Primary key and unique identifier of the Account Table
ACCT_STATUS_CD DOUBLE N Contains the current status of the account (in collections, review, active)
ACCT_SUB_TYPE_CD DOUBLE N Further defines the account type.
ACCT_TEMPL_ID DOUBLE N No Longer Used
ACCT_TYPE_CD DOUBLE N Patient, Cash, Revenue...
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.
ADJUSTMENT_BALANCE DOUBLE Y Total amount of adjustments posted to this account.
ADJ_BAL_DR_CR_FLAG DOUBLE Y Debit/Credit flag for the adjustment balance.
APPLIED_PAYMENT_BALANCE DOUBLE Y Total amount of payments posted to the account
BAD_DEBT_BALANCE DOUBLE N Bad debt balance on the account
BAD_DEBT_BAL_DR_CR_FLAG DOUBLE N debit/credit flag for bad_debt_balance field
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 Identifies the owning Billing Entity for the Account
CHARGE_BALANCE DOUBLE Y Total amount of charges posted to this account.
CHRG_BAL_DR_CR_FLAG DOUBLE Y Debit/Credit flag for the charge balance.
COL_LETTER_IND DOUBLE Y If 0 the account can be sent collection letters, otherwise the account can not be sent a collection letter.
CONSOLIDATION_IND DOUBLE Y No Longer Used
CREATED_DT_TM DATETIME Y Date and time the record was created.
CREATED_PRSNL_ID DOUBLE N Unique identifier of the person who created the record
DR_CR_FLAG DOUBLE Y Stores whether the account has a debit or credit balance
DUNNING_IND DOUBLE Y If 0 then this account can be sent dunning letters, otherwise the account can not be sent dunning letters.
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.
EXT_ACCT_ID_TXT CHAR(50) Y Allows the client to keep their original account id's separate from Cerner's Id's
EXT_ACCT_ID_TXT_KEY VARCHAR(250) Y A key field copy of the EXT_ACCT_ID_TXT that can be indexed for faster access
GLOBAL_OVERRIDE_IND DOUBLE N Indicator that all financial encounters related to this account are on consolidation override
HI_ACCT_BALANCE DOUBLE Y Records the highest balance that the account has reached
LAST_ADJUSTMENT_DT_TM DATETIME Y Date of last adjustment made against this encounter
LAST_CHARGE_DT_TM DATETIME Y Stores the last charge date and time
LAST_CLAIM_DT_TM DATETIME Y Date of last claim made against this encounter
LAST_PATIENT_PAY_DT_TM DATETIME Y The latest date/time of a patient payment
LAST_PAYMENT_DT_TM DATETIME Y Stores the last payment date and time
LAST_STMT_DT_TM DATETIME Y Date of the last Statement made against this encounter
PAYMENT_PLAN_IND DOUBLE Y Indicates whether a payment plan is being enforced
PENDING_ACCT_BAL DOUBLE Y Like the account balance except this will include all pending charges also.
PEND_DR_CR_FLAG DOUBLE Y Indicates whether the pending balance would be a debit or credit.
PRSNL_SEC_IND DOUBLE Y Indicates that the account has special security requirements that override the default Billing Entity and Account Template security settings. See Acct_Prsnl_Reltn for security levels.
SEND_COL_IND DOUBLE Y If 0 then the account can be sent to collections, else if 1 then the account can not be sent to collections.
STATUS_REASON_CD DOUBLE N Stores the reason for the account being in it's current status (non payment)
SUPPRESS_FLAG DOUBLE N Indicates suppression from statement
SUPPRESS_IND DOUBLE N Suppress this account from statements, this includes all encounters related
UNAPPLIED_PAYMENT_BALANCE DOUBLE Y Total amount of unapplied payments to the account - Not Used
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 - ACCOUNT


Child Column in ACCOUNT(FK) Parent Table Name Parent Column Name
Parents: ACCT_TEMPL_ID ACCT_TEMPLATE ACCT_TEMPL_ID
BILLING_ENTITY_ID BILLING_ENTITY BILLING_ENTITY_ID
CREATED_PRSNL_ID PRSNL PERSON_ID




Parent Column in ACCOUNT (PK) Child Table Name Child Column Name
Children: ACCT_ID ACCT_GROUP_RELTN ACCT_ID
ACCT_PRSNL_GROUP_R ACCT_ID
AT_ACCT_RELTN ACCT_ID
BATCH_TRANS_FILE GUAR_ACCT_ID
BE_GL_ALIAS_RELTN ACCT_ID
BILLING_ENTITY AR_ACCT_ID
BT_COND_CRIT_GRP_RELTN ACCT_ID
CBOS_PE_RELTN ACCT_ID
CORSP_LOG_RELTN ACCT_ID
DAILY_ACCT_BAL ACCT_ID
EXT_REQ_STATUS ACCOUNT_ID
GL_TRANS_LOG_OFFSET ACCOUNT_ID
GL_TRANS_QUALIFIER CLIENT_ACCOUNT_ID
PE_STATUS_REASON GUAR_ACCT_ID
PFT_AP_REFUND GUAR_ACCT_ID
PFT_BALANCE ACCT_ID
PFT_BENEFIT_ORDER ACCT_ID
PFT_BILL_SUMMARY ACCT_ID
PFT_CHARGE CR_ACCT_ID
PFT_CHARGE DR_ACCT_ID
PFT_ENCNTR ACCT_ID
PFT_QUEUE_ITEM ACCT_ID
PFT_QUEUE_ITEM_HIST ACCT_ID


ACCT_ACCT_RELTN



Column Section Top of Page


Table-level Detail

Description: Account Account Relation
Definition: Contains information about the relationship between accounts.
Table Type: ACTIVITY





Column Detail - ACCT_ACCT_RELTN


Column Name Type Null? Definition
ACCT_ACCT_RELTN_ID DOUBLE N Account Account Relation
ACCT_REASON_CD DOUBLE N Account Reason
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.
PRIMARY_ACCT_ID DOUBLE N Primary Account ID
RELATED_ACCT_ID DOUBLE N Related Account ID
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.


ACCT_BALANCE



Column Section Relationship Section Top of Page


Table-level Detail

Description: Acct_Balance
Definition: Account Balance
Table Type: ACTIVITY





Column Detail - ACCT_BALANCE


Column Name Type Null? Definition
ACCOUNT_SUB_TYPE_CD DOUBLE N Code value identifying the account subtype (e.g. Patient, Client etc.)
ACCOUNT_TYPE_CD DOUBLE N Code value identifying the type of account (e.g. A/R, Cash, Revenue)
ACCT_BALANCE DOUBLE Y Balance of an account.
ACCT_BALANCE_ID DOUBLE N Primary Key
ACCT_BAL_DR_CR_FLAG DOUBLE Y Flag indicating whether the account balance is debit or credit.
ACCT_ID DOUBLE N Foreign key to the account table.
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 Adjustments made to the account.
ADJ_DR_CR_FLAG DOUBLE Y Flag indicating the type of adjustment, 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 associated to an account.
CHRG_DR_CR_FLAG DOUBLE Y Indicates the type to charge, 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.
EXT_ACCT_ID_TXT CHAR(50) Y Extended account id from the account table. This is used defined.
PAYMENTS DOUBLE Y Payments associated to an account.
PERSON_ID DOUBLE N This is the value of the unique primary identifier of the person table. It is an internal system assigned number.
PMTS_DR_CR_FLAG DOUBLE Y Identifies the type of payment, debit or credit.
PREVIOUS_BALANCE DOUBLE Y Previous balance on an account.
PREVIOUS_DR_CR_FLAG DOUBLE Y Identifies the type of the previous balance, debit or credit.
RAW_ACCT_BALANCE DOUBLE Y Account balance from the account table.
RAW_ACCT_BALANCE_FLAG DOUBLE Y Raw Account Balance Flag
TRANSFER_AMOUNT DOUBLE Y Amount of a transfer that moved an amount from one account to another
TRANSFER_DR_CR_FLAG DOUBLE Y Debit/Credit flag for the transfer amount
UPDATE_IND DOUBLE Y Update Indicator
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_BALANCE


Child Column in ACCT_BALANCE(FK) Parent Table Name Parent Column Name
Parents: PERSON_ID PERSON PERSON_ID


ACCT_GROUP_RELTN



Column Section Relationship Section Top of Page


Table-level Detail

Description: Relates the Account table to the BT_Cond_Crit_Reltn table.
Definition: Account Group Relation
Table Type: REFERENCE





Column Detail - ACCT_GROUP_RELTN


Column Name Type Null? Definition
ACCT_GROUP_R_ID DOUBLE N Primary Key
ACCT_ID DOUBLE N Foreign Key to the Account table.
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.
BT_COND_CRIT_R_ID DOUBLE N Foreign Key to the BT_Cond_Crit_Reltn table.
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.
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_GROUP_RELTN


Child Column in ACCT_GROUP_RELTN(FK) Parent Table Name Parent Column Name
Parents: ACCT_ID ACCOUNT ACCT_ID


ACCT_PRSNL_GROUP_R



Column Section Relationship Section Top of Page


Table-level Detail

Description: Account Personnel Group Relation
Definition: Contains information about the relationship between an account and a personnel group.
Table Type: REFERENCE





Column Detail - ACCT_PRSNL_GROUP_R


Column Name Type Null? Definition
ACCT_ID DOUBLE N Account ID - ProFit
ACCT_PRSNL_GROUP_R_ID DOUBLE N Account Personnel Group Relation ID
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.
PFT_PRSNL_GROUP_ID DOUBLE N ProFit Personnel Group ID
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_PRSNL_GROUP_R


Child Column in ACCT_PRSNL_GROUP_R(FK) Parent Table Name Parent Column Name
Parents: ACCT_ID ACCOUNT ACCT_ID
PFT_PRSNL_GROUP_ID PFT_PRSNL_GROUP PFT_PRSNL_GROUP_ID