Appointments

PiMS stores an appointment entry for each appointment that was scheduled in PiMS. Appointment information includes the resource(s) and date/times such as cancel, reschedule, check in and check out, that show a history of the appointment. The date/times are used to determine the status of the appointment.APTRAPPT - Appointment Information

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

Field Name	Data Type	Field Length	Description	Notes
APTSPKEY	char	18	Key To The Patient
APTRAPDM	datetime	12	Appointment Date/Time
APTRAPDY	char	3	Appointment Day
APTRGRUP	char	8	Group ID	Defined in Scheduling Group profile
APTROPCD	char	8	Appointment Order Code - 1
APTROPMD	char	8	Appointment Order Code - 2
APTRACP1	char	8	Component ID - 1
APTRACP2	char	8	Component ID - 2
APTRACP3	char	8	Component ID - 3
APTRACP4	char	8	Component ID - 4
APTRACP5	char	8	Component ID - 5nh
APTRACP6	char	8	Component ID - 6
APTRACP7	char	8	Component ID - 7
APTRATMD	char	8	Attending MD
APTRATNM	char	40	Attending Md Name
APTRARNT	char	60	Appointment Reason
APTROVTX	char	60	Overbook Reason
APTRSCNT	char	60	Schedule Notes
APTRSCDM	datetime	12	Scheduled Date/Time
APTRCNDM	datetime	12	Cancellation Date/Time
APTRCNCD	char	8	Cancellation Reason Code
APTRCNTX	char	40	Cancellation Reason Description
APTRCODM	datetime	12	Check Out Date/Time
APTRCOTO	char	8	Check Out User ID
APTRCIDM	datetime	12	Check In Date/Time
APTRCITO	char	8	Check In User ID
APTRRSDM	datetime	12	Pending Rescheduled Date/Time
APTRRDDM	datetime	12	Actual Rescheduled Date/Time
APTRRDCD	char	8	Rescheduled Reason Code
APTRRSTX	char	40	Rescheduled Reason Description
APTRIWLK	char	1	Walk In Indicator	Y/N
APTROPDS	char	30	Order Description
APTRIWST	char	1	Waitlist For Appt	Y/N

Sections

Personal tools

Appointments

Document Actions