Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.


Panel


Panel
borderColorblue
bgColor#B3D4FF
borderWidth1
borderStylesolid

GL Account Mapping to HOSPITAL_CHARGE_ADMIN


Excerpt

HOSPITAL_CHARGE_ADMIN is the database table that contains all financial transactions, for all hospital accounts.  The following table contains the mapping of financial accounts, and account types, to the transaction TYPES TYPEs in the HOSPITAL_CHARGE_ADMIN table.  It also contains information on how the transactions affect account balances by increasing or decreasing the balance, and whether the transaction is considered to be a credit or debit.  HOSPITAL_CHARGE_ADMIN contains foreign key references to many ancillary tables that are also listed.



Info

Refer to the 'Inventory and Accounting Definitions' page for the definition of terms found in the table below.


Panel


Panel
borderColorblue
bgColor#B3D4FF
borderWidth1
borderStylesolid

Mapping


FINANCIAL
REPORT
ACCOUNT
GROUP
ACCOUNT TYPETYPE

CHARGE_ADMIN::ADJUSTMENT
CHARGE
ADMIN
SIGN
EFFECT
ON ACCT
DR / CRANCILLARY TABLESEXAMPLES


Balance SheetAssetA/RA_R_PAYMENT(+)DecreaseCRCHARGE_ADMIN
ORDERARTRANSACTIONS




Income StatementExpenseDiscountsADJUSTMENT::OPEN_ORDER(-)IncreaseDRADJUSTMENT
ORDER_ITEM_MODIFIER
ADJUSTMENT_ITEMS
Discounts such as: LDA/RDA, Behavior, Promotional, Instructional, Packages, Clinical Research, Wellness Packages, Employee/Student,

Credit Adjustments such as: Administrative, Returned Items, Charged-In-Error.



Income StatementRevenuePrice IncreaseADJUSTMENT::INVOICE_PRICE_INCREASE(+)IncreaseCRADJUSTMENT
CHARGE_ADMIN
System-generated adjustment that results from the 'Subtotal' of a charge on an order being manually increased by the User.


Income StatementRevenuePrice DecreaseADJUSTMENT::INVOICE_PRICE_DECREASE(-)DecreaseDRADJUSTMENT
CHARGE_ADMIN
System-generated adjustment that results from the 'Subtotal' of a charge on an order being manually decreased by the User.


Income StatementRevenueInterest Charges AssessedADJUSTMENT::INTEREST(+)IncreaseCRCHARGE_ADMIN
ADJUSTMENT
Interest:
CHARGE_ADMIN::TYPE = ADJUSTMENT
CHARGE_ADMIN +----> ADJUSTMENT +---
---> ADJ_TYPE::ADJUSTMENT_TYPE = INTEREST



Income StatementRevenueInterest Charges ReversalADJUSTMENT::INTEREST(-)DecreaseDRCHARGE_ADMIN
ADJUSTMENT
Interest Reversal (unpaid):
CHARGE_ADMIN::TYPE = ADJUSTMENT



Income StatementRevenueInterest Charges ReversalCREDIT_MEMO(-)DecreaseDRCHARGE_ADMINInterest Reversal (paid):
CHARGE_ADMIN::TYPE = CREDIT_MEMO
(if interest that has been paid is reversed, resulting in a credit memo).



Income StatementRevenueLate Fee ReversalADJUSTMENT::LATE_FEE(-)DecreaseDRCHARGE_ADMIN
ADJUSTMENT
Late Fee Reversal:
CHARGE_ADMIN::TYPE = ADJUSTMENT



Income StatementExpenseClient Discount
Volume Discount
ADJUSTMENT::PRODUCT(-)IncreaseDRCHARGE_ADMIN
ADJUSTMENT
ORDER_ITEM_MODIFIER
System-generated adjustments that are created when a product is added to the order. These adjustments depend on the product setup, and hospital setup.

Client Discount Adjustment - resulting from a price set multiplier less than 1.00.

Volume Discount Adjustment - resulting from a sufficient dollar volume and associations with a volume discount.

Product Debit Adjustment Reversal - resulting from the reversal of a PRODUCT debit adjustment.



Income StatementRevenueMinimum Price
Product Markup
ADJUSTMENT::PRODUCT(+)IncreaseCRCHARGE_ADMIN
ADJUSTMENT
ORDER_ITEM_MODIFIER
System-generated adjustments that are created when a product is added to the order. These adjustments depend on the product setup, and hospital setup.

Client Markup Adjustment - resulting from a price set multiplier greater than 1.00.

Minimum Price Adjustment - resulting from a 'Minimum Price' that is greater than the product pricing basis, plus markup, minus discounts.

Product Markup Adjustment - resulting from a 'Markup' multiplier greater than 1.00

Product Credit Adjustment Reversal - resulting from the reversal of a PRODUCT credit adjustment.



Income StatementRevenueSales of products and servicesCHARGE(+)IncreaseCRORDER_ITEM
CHARGE_ADMIN
Results from a product (or service) being added to an order. The transaction is added to CHARGE_ADMIN, from ORDER_ITEMS when the order is closed.

Amount = product's pricing basis x markup x quantity.



Balance SheetLiabilityClient Credit
Credit Memo
CREDIT_MEMO(+)IncreaseCRCHARGE_ADMIN
CREDIT_MEMO




Balance SheetLiabilityApplication of a client credit or credit memoCREDIT_MEMO_APPLIED(-)DecreaseDRCHARGE_ADMIN
CREDIT_MEMO




Balance SheetAssetDebit MemoDEBIT_MEMO(+)IncreaseDRCHARGE_ADMIN
DEBIT_MEMO




Income StatementRevenueLate Fees AssessedDEBIT_MEMO::LATE_FEE(+)IncreaseCRCHARGE_ADMIN
DEBIT_MEMO
ADJUSTMENT
Late Fees:
CHARGE_ADMIN::TYPE = DEBIT_MEMO
CHARGE_ADMIN +---> DEBIT_MEMO +---> ADJUSTMENT +--
---> ADJ_TYPE::ADJUSTMENT_TYPE = LATE_FEE



Balance SheetLiabilityClient DepositN/AN/AIncreaseCRCLIENT_DEPOSIT



Balance SheetLiability
DEPOSIT_APPLIED(-)DecreaseDRCHARGE_ADMIN
CLIENT_DEPOSIT




Income StatementRevenueService FeeMODIFIER(+)IncreaseCRORDER_ITEM_MODIFIER



Balance SheetLiabilityPrepaid SalesPACKAGE(+)IncreaseCRCLIENT_PATIENT_PKG
CLIENT_PKG_ITEM




Balance SheetLiabilityPrepayments applied to charges and A/RPREPAID_APPLIED(-)DecreaseDRCLIENT_PATIENT_PKG
CLIENT_PKG_ITEM




Balance SheetAssetCash, A/RPREPAID(-)IncreaseDRPAYMENT
DEBIT_MEMO
ORDERAR_TRANS




Balance SheetLiabilityTaxes DueTAX(+)IncreaseCR







TAX_ADJUSTMENT







Balance SheetLiabilityTax Exemption CreditTAX_EXEMPTION(-)DecreaseDRCHARGE_ADMIN
ADJUSTMENT




Balance SheetLiabilityTax Exemption Reversal (Debit)TAX_EXEMPTION(+)IncreaseCRCHARGE_ADMIN
ADJUSTMENT







ADJUSTMENT::PAYMENT



Corrections to payments that have been posted; such as: Wrong payment type, Returned Check, Incorrect Payment Amount.





ADJUSTMENT::REFUND










ADJUSTMENT::REFUND_REVERSAL










ADJUSTMENT::CLIENT_CREDIT










ADJUSTMENT::DEPOSIT










ADJUSTMENT::CREDIT_MEMO










ADJUSTMENT::DEBIT_MEMO










ADJUSTMENT::WRITE_OFF










ADJUSTMENT::WRITE_OFF_REVERSAL










ADJUSTMENT::ASAQ










ADJUSTMENT::ASAQ_UNREPORTED










ADJUSTMENT::TAX_EXEMPTION_CR










ADJUSTMENT::TAX_EXEMPTION_DR










ADJUSTMENT::PACKAGE











Insert excerpt
UG:Setup & Admin Guides
UG:Setup & Admin Guides
nopaneltrue

Info

To see commonly used terms in VetView Hospital, please visit our Hospital Glossary of Terms.


Panel
titleContents

Table of Contents