Patient Information

PiMS stores one set of patient tables for each patient registered in PiMS. Patient information includes demographic information, guarantor, allergy, caregiver history, and insurance information for the patient. Each patient is assigned a unique corporate ID.

APTSTATS - Patient Information

Description of Join	Join to Table	Keys	Notes
Retrieve guarantor demographic information when patient is also a guarantor		'GUR' + APTSGUAR = AGUSGKEY
Retrieve guarantor information for the patient's designated guarantor	AGUSTATS	'GUR^^^' + AGPSDGUA = AGUSGKEY
Retrieve the patient's caregivers	APTGCGVR	APTSTATS.APTSPKEY = APTGCGVR.APTSPKEY
Retrieve the patient's accounts	AACSAKEY	APTSPKEY = AACSAKEY
	ATSCCOD	'P^' + SUBSTRING(APTSPKEY,01,06) + APTSSPHD = ATSCSKEY

Field Name	Data Type	Field Length	Description	Notes
APTSPKEY	char	18	Key To The Patient
APTSNAME	char	40	Patient Name	Format: Lastname, Firstname, Middle
APTSSPHD	char	4	Special Handling	Value from Special Handling Profile Type "P"
APTSGSSN	char	9	Patient Social Security Number
APTSADD2	char	30	Mailing Street Address - 2
APTSCITY>	char	30	Mailing City
APTSTATE	char	2	Mailing State
>APTS1ZIP	char>	5	Mailing Zip Code
APTS2ZIP	char	4	Mailing Zip Code - Extended
APTSPHON	char	10	Evening Phone Number
APTSBTDT	datetime	8	Patient Birthdate	Format: CCYYMMDD
APTSPSEX	char	1	Patient Sex
APTSMRST	char	1	Patient Marital Status
APTSRGDM	datetime	12	Registration Date And Time
APTSGUAR	Char	12	Guarantor ID	Guarantor ID for the patient
APTSDGUA	Char	12	Designated Guarantor ID	Guarantor ID who will be assigned to accounts
APTSIACT	char	1	Indicator - Active/Deactivated	Values: Y/N
APTSAMRF	char	12	Merged From Patient ID
APTSAMRT	char	12	Merged To Patient ID
APTSDPHO	char	10	Day Phone Number	Format: NNNNNNNNNN
APTSXDPH>	char	10	Day Phone Number – Extension

APTGCGVR - Patient Caregiver Information

Description of Join	Join to Table	Keys	Notes
Retrieve patient demographic information	APTSTATS	APTGCGVR.APTSPKEY = APTSTATS.APTSPKEY
Retrieve physician information	AUTNALTN, AUTHORIZ	AUTNSKEY = 'CRGV' AND APTGCODE = SUBSTRING(AUTNNNBR,01,08) AND AUTNUKEY = AUTHUKEY

Field Name	Data Type	Field Length	Description	Notes
APTSPKEY	char	18	Key To The Patient
APTGMKEY	char	12	Key To The Patient Caregiver	Caregiver Type
APTGYSDM	char	12	Date - System Generated
APTGYSTO	char	8	Workstation Operator
APTGCODE	char	8	Caregiver Code
APTGSTTP	char	10	Caregiver Staff Type

Sections

Personal tools

Patient Information

APTSTATS - Patient Information

APTGCGVR - Patient Caregiver Information

Document Actions