Charges
PiMS stores a set of charge tables for each detail charge posted in PiMS regardless of billing status. Charges are posted to the account. A negative charge amount indicates a reversal or corrected charge.
An entry for the charge is also kept in the revenue transaction file, ADRVDTAR.
ADPTCHGS - Charges
|
Description of Join |
Join to Table |
Keys |
Notes |
|
Retrieve additional charge information |
ADPXEXTN |
ADPTCHGS.ADPSDKEY = ADPXEXTN.ADPSDKEY AND ADPTDKEY=ADPXXKEY> |
|
|
Retrieve account information |
AACSTATS |
SUBSTRING(ADPSDKEY,01,06) + SUBSTRING(ADPSDKEY,19,12) = AACSAKEY |
|
|
Retrieve patient information |
APTSTATS |
'PAT' + SUBSTRING(ADPSDKEY,07,12) = APTSPKEY |
|
Field Name< |
Field Length< |
Description |
Notes |
|
|
ADPSDKEY |
char |
30 |
Key To Patient Charges Root Segment |
Account Number |
|
ADPTDKEY |
31 |
Key To Charges Database |
||
|
ADPTPTKY |
char |
18 |
Patient Key |
|
|
ADPTSVDT |
datetime |
8 |
Date Of Service |
|
|
ADPTRCTR |
char |
8 |
Revenue Center< |
Defined in Department profile , type=C |
|
ADPTCSTA |
char |
1 |
Charges Status |
Billed, Unbilled, AltBilled B-U-A |
|
ADPTRFNC |
char |
4 |
Revenue Financial Class |
|
|
ADPTPODT |
datetime |
8< |
Charge Post Date |
|
|
ADPTQNTY |
numeric |
5 |
Quantity |
< |
|
ADPTANAM |
numeric |
10 |
Charge Amount |
< |
|
ADPTDESC |
char |
30 |
Description |
|
|
ADPTBCHN |
char |
20 |
Charge Batch ID |
|
|
ADPTBKAM |
numeric |
10 |
Amount - Booked |
Fee Schedule |
|
ADPTBLAM |
numeric |
10 |
Amount - Billed |
Fee Schedule |
|
ADPTAJAM |
numeric |
10 |
Amount - Adjustment |
|
|
ADPTRVDT |
datetime |
8 |
Revenue Date |
ADPXEXTN - Charges Extension
|
Description of Join |
Join to Table |
Keys |
Notes |
|
Retrieve additional charge information |
ADPTCHGS |
ADPTCHGS.ADPSDKEY = ADPXEXTN.ADPSDKEY AND ADPXXKEY=ADPTDKEY |
|
|
Retrieve account information |
AACSTATS |
SUBSTRING(ADPSDKEY,01,06) + SUBSTRING(ADPSDKEY,19,12) = AACSAKEY |
|
|
Retrieve patient information |
APTSTATS |
'PAT' + SUBSTRING(ADPSDKEY,07,12) = APTSPKEY |
|
Field Name |
Data Type |
Field Length |
Description |
Notes |
|
ADPSDKEY |
char |
30 |
Key To Patient Charges Root Segment |
|
|
ADPXXKEY |
binary |
31 |
Segment Key |
|
|
ADPXCDAM |
numeric |
10 |
CDM Price |
|
|
ADPXOPAM |
numeric |
10 |
Override Price |
|
|
ADPX01CD |
char |
8 |
HCPCS Code |
|
|
ADPX02CD |
char |
8 |
CPT4 Code |
|
|
ADPXMODF |
char |
6> |
Modifier |
