Daily Transactions
PIMS stores a transaction record for all financial activity in the daily transaction table. Charges, payments and adjustments can be selected and used for reporting. Refer to the transaction type, ADRVTTYP for specific details on selecting charges, payments and adjustments.
Revenue date is calculated based on the close of the month and indicates which month the revenue, payments and adjustments were posted to the General Ledger system.
ADRVDTAR - Daily Transactions
|
Description of Join |
Join to Table |
Keys |
Notes |
|
Retrieve patient demographic information |
APTSTATS |
'PAT^^^' + ADRVPMRN = APTSPKEY |
|
|
Retrievel account information |
AACSTATS |
ADRVAKEY = AACSAKEY |
|
|
Retrieve additional account information |
AACXEXTN |
ADRVAKEY = AACXXKEY |
|
|
Retrieve additional physician information for the attending MD |
AUTNALTN, AUTHORIZ |
AUTNSKEY = 'CRGV' AND ADRVATMD = SUBSTRING(AUTNNNBR,01,08) AND AUTNUKEY = AUTHUKEY |
|
|
Retrieve additional information such as description for the special handling code |
ATSCCOD |
'A ' ^^^ + SUBSTRING(ADRVAKEY,01,06) + AACSSPHD = ATSCSKEY |
|
|
Retrieve additional information such as description for the financial class |
ATFCLAS |
ADRVAFNC = ATFCFKEY |
|
|
Retrieve additional information such as description for the account category |
ATCTCAT |
ADRVACAT = ATCTCKEY |
|
|
Retrieve additional information such as description for the primary payor classification |
ATPYPYR |
SUBSTRING(ADRAKEY,01,06) + ADRVPYCB = ATPYPKEY |
|
|
Retrieve additional information such as description for the primary insurance |
ATTHIRD |
ADRVATID = ATTHTKEY |
|
|
Retrieve additional information such as description for the general ledger code |
ATGLCOD |
ADRVGLCD + SUBSTRING(ADRVAKEY,01,06) = ATGLGKEY |
|
|
Retrieve additional information from the charge description master |
AHCDMAST |
'C' + SUBSTRING(ADRVAKEY,01,06) +ADRVSVCD = AHCDHKEY AND ADRVTTYP = 'CH' |
|
|
Retrieve billing information from the charge description master |
AHCBHIST> |
'C' + SUBSTRING(ADRVAKEY,01,06) +ADRVSVCD = AHCDHKEY ANDADRVSVDT >= CONVERT(CHAR, SUBSTRING(AHCBHKEY,01,08)) ANDCONVERT(CHAR, ADRVSVDT) < = SUBSTRING(AHCBHKEY,09,08) |
|
Field Name |
Data Type |
Field Length |
Description |
Notes |
|
ADRVDKEY |
binary |
26 |
Key - Daily Transaction Audit |
|
|
ADRVIBDB |
char |
1 |
Indicator - Bad Debt |
> |
|
ADRVAFNC |
char |
4 |
Financial Class |
|
|
ADRVPODT |
datetime |
8 |
Date - Posting |
|
|
ADRVSVDT |
datetime |
8 |
Date - Service |
|
|
ADRVSVCD |
char |
12 |
Service Code/Transaction Code |
Shared field per transaction type |
|
ADRVQNTY |
numeric |
4 |
Quantity |
|
|
ADRVANAM |
numeric |
10 |
Amount - Transaction |
Charge Reversal (-); Debit Adjustment (-); Payment Reversal (-) |
|
ADRVRCTR |
char |
8 |
Revenue Center |
|
|
ADRVPYCB |
char |
4 |
Payor Classification |
|
|
ADRVATID |
char |
4 |
Third Party |
|
|
ADRVTTYP |
char |
2 |
Transaction Type |
CH=Charges, PP=Payment, PA=Adjustment |
|
ADRVACAT |
char |
2 |
||
|
ADRVPMRN |
char |
12 |
Patient ID |
|
|
ADRVBCHN |
char |
20 |
Batch ID |
|
|
char |
1 |
Ind – Billed/Unbilled For Patient / Adjustment |
||
|
ADRVIWOF |
char |
1 |
Ind - Write Off |
|
|
ADRVIBDW |
char |
1 |
Ind - Bad Debt Write Off |
|
|
ADRVIBDR |
char |
1 |
Ind - Bad Debt Reversal |
|
|
ADRVRVDM |
datetime |
12 |
Date And Time - Revenue |
Date Posted to GL |
|
ADRVGLCD |
char |
17 |
General Ledger Code |
|
|
ADRVBKAM |
numeric |
10 |
Amount - Booked |
Charge Description Master |
|
ADRVBLAM |
numeric |
10 |
Amount - Billed |
Fee Schedule |
|
ADRVAJAM |
numeric |
10 |
Amount - Adjustment |
|
|
ADRVIEXT |
char |
1 |
Ind - Extract |
|
|
ADRVAKEY |
char |
18 |
Account Key |
|
|
ADRVEXDM |
datetime |
12 |
Extract Date/Time |
|
|
ADRVCAPH |
char |
8 |
Attending MD |
