Account

PiMS stores one set of account tables for each financial encounter. The account information is used for billing and revenue classification. In the physician office, there is typically one account per visit.

Account information includes summary data regarding the financial status of the encounter. Balances such as billed balance forward, net balance forward, guarantor responsible amount are kept for each encounter. Additional information on the classification of the account such as financial class, account category and attending physician are stored in the account tables.

AACSTATS - Account Information

Description of Join	Join to Table	Keys	Notes
Retrieve patient demographics	APTSTATS	AACSPKEY = APTSPKEY
Retrieve guarantor demographics		AACSGKEY = AGUSGKEY
Retrieve additional account information	AACXEXTN	AACSAKEY = AACXXKEY
Retrieve additional account information - attending physician	AACUB82S	AACUB82S.AACSAKEY = AACSTATS.AACSAKEY
Retrieve additional information such as description for the special handling code	ATSCCOD	'A' + SUBSTRING(AACSAKEY,01,06) + AACSSPHD = ATSCSKEY
Retrieve additional information such as description for the financial class		AACSAFNC = ATFCFKEY
Retrieve additional information such as description for the account category	ATCTCAT	AACSACAT =ATCTCKEY
Retrieve additional information such as description for the primary payor classification	ATPYPYR	SUBSTRING(AACSPKEY,01,06) + AACSPYCB = ATPYPKEY
Retrieve additional information such as description for the primary insurance	ATTHIRD	AACSATID = ATTHTKEY

Field Name	Data Type	Field Leght	Description	Notes
AACSAKEY	char	18	Key
AACSBFNC	char	4	Financial Class	Defined in Financial Class profile
AACSACID	char	8	Collection Agency ID	Defined in Collection Agency profile
AACSIBDB	char	1	Indicator - Bad Debt	Y/N
AACSBPDT	datetime	8	Date – Account Billed
AACSZBDT	datetime	8	Date - Zero Balance Or Write-Off
AACSPDDM	datetime	12	Date/Time - Patient Discharge
AACSPRDM	datetime	12	Date/Time - Admitted
AACSABAM	numeric	10	Amount -Billed Balance Forward
AACSAJAM	numeric	10	Amount – Total Guar Adjustment
AACSTBAM	numeric	10	Amount - Third Party Billed Balance
AACSTPAM	numeric	10	Amount - Total Third Party Payments
AACSRGAM	numeric	10	Amount - Guarantor Resp.
AACSBDAM	numeric	10	Amount - Transferred To Bad Debt
AACSRCAM	numeric	10	Amount - Recovery Amount Bad Debt
AACSPKEY	char	18	Patient Database Key
AACSGKEY	char	18	Guarantor Database Key
AACSPSTA	char	2	Patient Status Exclude Cancelled Status
AACSGPAM	numeric	10	Amount - Total Guarantor Payment
AACSSPHD	char	4	Special Handling Field	Defined in Special Handling profile
AACSLPDT	datetime	8	Date - Last Payment
AACSTJAM	numeric	10	Amount – Third Party Adjustments
AACSBAAM	numeric	10	Amount - Bad Debt Adjustments
AACSGUPT	char	2	Guarantor Relationship To Patient	Defined in Patient Relationship profile
AACSACAT	char	2	Account Category	Defined in Account Category profile
AACSOPDT	datetime	8	Open Date Used For Rules
AACSCLDT	datetime	8	Close Date Used For Rules
AACSPYCB	char	4	Payor Classification	Defined in Payor Classification profile
AACSATID	char	4	Primary Third Party	Defined in Third Party profile

Description of Join	Join to Table		Notes
Retrieve additional account information	AACSTATS	AACXXKEY = AACSAKEY
Retrieve diagnosis and procedures	AVSDIAGP	AACXRVST = AVSVVKEY
Retrieve additional information such as description for the primary payor classification	ATPYPYR	SUBSTRING(AACXXKEY,01,06) + AACXPYC1 = ATPYPKEY
Retrieve additional information such as description for the secondary payor classification	ATPYPYR	SUBSTRING(AACXXKEY,01,06) + AACXPYC2 = ATPYPKEY
Retrieve additional information such as description for the additional payor classification	ATPYPYR	SUBSTRING(AACXXKEY,01,06) + AACXPYC3 = ATPYPKEY
Retrieve additional information such as description for the additional payor classification	ATPYPYR	SUBSTRING(AACXXKEY,01,06) + AACXPYC4 = ATPYPKEY
Retrieve additional information such as description for the additional payor classification	ATPYPYR	SUBSTRING(AACXXKEY,01,06) + AACXPYC5 = ATPYPKEY

Field Name	Data Type	Field Lenght	Description	Notes
AACXXKEY	char	18	Key
AACXICLH	char	1	Ind - Claim Hold
AACXHCDT	datetime	8	Date - Hold At Claim Level
AACXHCRS	char	8	Held - Reason Code
AACXPYG1	char	4	Payor Group 1
AACXPYG2	char	4	Payor Group 2
AACXPYG3	char	4	Payor Group 3
AACXPYG4	char	4	Payor Group 4
AACXPYG5	char	4	Payor Group 5
AACXAAAM	numeric	10	Net Balance Forwarded Amount
AACXANAM	numeric	10	Unbilled Charges Amount
AACXAMAM	numeric	10	Billed Charges Amount
AACXRVST	binary	14	Ruling Visit

ACUB82S - UB92 Information

Description of Join<	Join to Table		Notes>
Retrieve additional account information	AACSAKEY	AACSTATS.AACSAKEY = AACUB82S.AACSAKEY
Retrieve additional account information	AACXEXTN>	AACSAKEY = AACXXKEY

Field Name	Data Type	Field Length	Description	Notes
AACSAKEY	char	18	Key To The Account
AACUCAPH	char	8	Attending Physician Code

Sections

Personal tools

Account

AACSTATS - Account Information

ACUB82S - UB92 Information

Document Actions