SDES2 GET APPTS BY CLINIC LIST

TITLEVALUE
NAMESDES2 GET APPTS BY CLINIC LIST
DESCRIPTIONThis RPC returns back all the appointments for the clinics passed in for
today.
TAGBYCLINICLIST
ROUTINESDES2GETAPPTRPCS
INPUT PARAMETERSSEQUENCE NUMBER1
INPUT PARAMETERSDCONTEXT
DESCRIPTIONSDCONTEXT("ACHERON AUDIT ID") = Up to 40 Character unique ID number.
Ex: 11d9dcc6-c6a2-4785-8031-8261576fca37
SDCONTEXT("USER DUZ") = The DUZ of the user taking action on the
calling application.
SDCONTEXT("USER SECID") = The SECID of the user taking action in the
calling application.
SDCONTEXT("PATIENT DFN")= The name of the patient taking action on the
calling application.
SDCONTEXT("PATIENT ICN")= The ICN of the patient taking action on the
calling application.
PARAMETER TYPELIST
REQUIREDYES
MAXIMUM DATA LENGTH32000
INPUT PARAMETERSSEQUENCE NUMBER2
INPUT PARAMETERSDINPUT
DESCRIPTIONSDINPUT("ClinicIEN",clinic ien)="" ; where clinic ien is a numeric value
PARAMETER TYPELIST
REQUIREDYES
MAXIMUM DATA LENGTH32000
RETURN VALUE TYPEARRAY
RETURN PARAMETER DESCRIPTION Example one: Cancelled appointment
{
"Appointment": [
{
"AppointmentCancelled": "CANCELLED",
"AppointmentDateTime": "2023-12-06T08:00-0500",
"AppointmentIEN": 298114,
"AppointmentType": "REGULAR",
"AppointmentTypeIEN": 9,
"AppointmentTypeSubCategory": "",
"AutoRebookedApptDateTime": "",
"CancelDateTime": "2023-12-06T14:17:06-0500",
"CancellationReason": "PANDEMIC",
"CancellationRemarks": "",
"CancelledByUser": {
"ID": 520881841,
"Name": "TEST,USR",
"SecId": 1060245260
},
"CheckIn": "",
"CheckInEntered": "",
"CheckInSteps": [
""
],
"CheckInUser": "",
"CheckOut": "",
"CheckOutEntered": "",
"CheckOutUser": "",
"Clinic": {
"ClinicIEN": 2147,
"CreditStopCodeAMIS": 179,
"CreditStopCodeName": "RT CLIN VID CARE HOME",
"DisplayClinicAppt": "YES",
"Division": "CHEYENNE VAMROC",
"ECheckinAllowed": "YES",
"IsOverbook": 0,
"Name": "CHY CARDIOLOGY",
"PatientFriendlyName": "CHY CARDIOLOGY",
"PbspID": "",
"PhysicalLocation": "ARROWHEAD BLD A1-16 OR 17",
"PreCheckinAllowed": "YES",
"ProhibitedClinic": 0,
"StationNumber": 442,
"StopCodeAMIS": 303,
"StopCodeName": "CARDIOLOGY",
"Telephone": "(307)778-7550",
"TelephoneExtension": 1234,
"TimeZone": "EASTERN",
"TimeZoneDetails": [
{
"Offset": "-0500",
"TimeFrame": "STANDARD",
"TimeZoneCode": "EST"
},
{
"Offset": "-0400",
"TimeFrame": "DAYLIGHT SAVINGS",
"TimeZoneCode": "EDT"
}
],
"TimeZoneException": "",
"VeteranSelfCancel": "NO"
},
"CollateralVisit": "",
"ConsultLink": "",
"CurrentStatus": "CANCELLED BY CLINIC",
"DataEntryClerk": "TEST,USR",
"DateAppointmentMade": "2023-12-06T14:12:13-0500",
"DesiredDateOfAppointment": "2023-12-06",
"DuplicateApptSameDay": "",
"EASTrackingNumber": "",
"EkgDateTime": "",
"EncounterConversionStatus": "",
"EncounterFormsAsAddOns": "",
"EncounterFormsPrinted": "",
"EndTime": "2023-12-06T08:30-0500",
"FollowUpVisit": "NO",
"InpatientFlag": 0,
"LabDateTime": "",
"LengthOfAppt": 30,
"MRTCFlag": 1,
"NextAvaApptIndicator": "'NEXT AVA.' APPT. INDICATED BY USER &
CALCULATION",
"NoShowCancelDateTime": "2023-12-06T14:17:06-0500",
"NoShowCancelledBy": "TEST,USR",
"Note": "TEST NOTE",
"NoteAuditing": [
{
"DateNoteAdded": "2024-10-16",
"Note": "TEST NOTE",
"NoteAddedByDUZ": 123456789,
"NoteAddedByName": "TEST,USER ONE"
},
],
"NumberOfCollateralSeen": "",
"OriginatingRequestType": "APPT",
"OtherTests": "",
"OtherTravel": " ",
"OutpatientEncounter": "",
"OverLaidAppointmentData": "NO",
"OverbookFlag": "",
"ParentRecordRequest": "",
"Patient": {
"CurrentEligibilityCode": "SERVICE CONNECTED 50% to 100%",
"DFN": 7209450,
"DateOfBirth": "1990-06-06",
"DateOfBirthInternal": 2900606,
"DateOfDeath": "",
"DemographicsNeedUpdate": 1,
"Eligibility": "SERVICE CONNECTED 50% to 100%",
"EligibilityIEN": 1,
"EligibilityOfVisit": "SERVICE CONNECTED 50% to 100%",
"EnrollmentCode": "",
"EnrollmentDate": "",
"FugitiveFelonFlag": "NO",
"Gender": "MALE",
"ICN": "4420062499V538982",
"LastRegistrationDate": "2023-09-01T15:13:57-0400",
"LocalFlag": [
{
"AssignedDate": "2014-12-03T14:50:22-0500",
"Category": "II (LOCAL)",
"Name": "AT RISK PATIENT",
"Narrative": [
"This is a test account. The actual record text was removed Feb
14, 2018.",

"ABCDEFGHIJKLMNOPQRSTABCDEFGHIJKLMNOPQRSTABCDEFGHIJKLMNOPQRSTABCDEFGHIJKLM
N",
"OPQRSTABCDEFGHIJKLMNOPQRST",

"ABCDEFGHIJKLMNOPQRSTABCDEFGHIJKLMNOPQRSTABCDEFGHIJKLMNOPQRSTABCDEFGHIJKLM
N",
"OPQRSTABCDEFGHIJKLMNOPQRST",

"ABCDEFGHIJKLMNOPQRSTABCDEFGHIJKLMNOPQRSTABCDEFGHIJKLMNOPQRSTABCDEFGHIJKLM
N",
"OPQRSTABCDEFGHIJKLMNOPQRST",

"ABCDEFGHIJKLMNOPQRSTABCDEFGHIJKLMNOPQRSTABCDEFGHIJKLMNOPQRSTABCDEFGHIJKLM
N",
"OPQRSTABCDEFGHIJKLMNOPQRST",

"ABCDEFGHIJKLMNOPQRSTABCDEFGHIJKLMNOPQRSTABCDEFGHIJKLMNOPQRSTABCDEFGHIJKLM
N",
"OPQRSTABCDEFGHIJKLMNOPQRST",
" ",
"END OF TEXT"
],
"OriginatingSiteID": 442,
"OriginatingSiteName": "CHEYENNE VA MEDICAL",
"OwnerSiteID": 442,
"OwnerSiteName": "CHEYENNE VA MEDICAL",
"ReviewDate": "2023-12-13",
"Type": "OTHER"
}
],
"Name": "VSE,LOCAL FLAG",
"NationalFlag": [
""
],
"NeedInsuranceVerification": 1,
"OriginalRegistrationDate": "2011-03-22T10:49:09-0400",
"SSN": "0690P",
"SensitivePatientRestrictedRecord": 0,
"SensitivePatientType": 0,
"Street": "C/O P MAI (136B)"
},
"PatientComments": [
""
],
"PriorXRayResults": "",
"Provider": {
"ID": 1824,
"Name": "PROVIDER,TEST J",
"SecId": 1034217513
},
"PurposeOfVisit": "SCHEDULED VISIT",
"RealAppointment": 0,
"RequestIEN": 263452,
"RequestType": "APPT",
"Resource": {
"ClinicIEN": 2147,
"Name": "CHY CARDIOLOGY"
},
"ResourceIEN": 1058,
"RoutingSlipPrintDate": "",
"RoutingSlipPrinted": "",
"SchedulerName": "",
"SchedulingApplication": "",
"SchedulingRequestType": "MULTIPLE APPT. BOOKING",
"SpecialSurveyDisposition": "",
"StartTimeFM": 3231206.08,
"Status": "CANCELLED BY CLINIC",
"StatusCancelDateTime": "2023-12-06T14:17:06-0500",
"VVSApptID": "",
"VeteranVideoCallURL": "",
"Walkin": "",
"WardLocation": "",
"XRAY": "",
"XrayDateTime": ""
}
]
}
Example two with check-in steps:
{
"Appointment": [
{
"AppointmentCancelled": "",
"AppointmentDateTime": "2022-11-14T10:00-0500",
"AppointmentIEN": 294806,
"AppointmentType": "REGULAR",
"AppointmentTypeIEN": 9,
"AppointmentTypeSubCategory": "",
"AutoRebookedApptDateTime": "",
"CancelDateTime": "",
"CancellationReason": "",
"CancellationRemarks": "",
"CancelledByUser": [
""
],
"CheckIn": "2022-11-14T14:21:41-0500",
"CheckInEntered": "2022-11-14T14:21:41-0500",
"CheckInSteps": [
{
"DateTime": "2022-11-14T14:16:28-0500",
"IEN": 1,
"Status": "PRE-CHECK-IN STARTED"
},
{
"DateTime": "2022-11-14T14:16:53-0500",
"IEN": 2,
"Status": "PRE-CHECK-IN COMPLETE"
},
{
"DateTime": "2022-11-14T14:19:38-0500",
"IEN": 3,
"Status": "CHECK-IN STARTED"
},
{
"DateTime": "2022-11-14T14:21:02-0500",

"IEN": 4,
"Status": "CHECK-IN COMPLETE"
},
{
"DateTime": "2022-11-14T14:21:22-0500",
"IEN": 5,
"Status": "E-CHECK-IN STARTED"
},
{
"DateTime": "2022-11-14T14:21:41-0500",
"IEN": 6,
"Status": "E-CHECK-IN COMPLETE"
}
],
"CheckInUser": "TEST,NEDIME",
"CheckOut": "2022-11-14T14:22-0500",
"CheckOutEntered": "2022-11-14T14:23:19-0500",
"CheckOutUser": "TEST,FELIX JR",
"Clinic": {
"ClinicIEN": 3753,
"CreditStopCodeAMIS": 179,
"CreditStopCodeName": "RT CLIN VID CARE HOME",
"DisplayClinicAppt": "YES",
"Division": "CHEYENNE VAMROC",
"ECheckinAllowed": "YES",
"IsOverbook": 1,
"Name": "CHY ACUTE CARE 1",
"PatientFriendlyName": "CHY ACUTE CARE THOMPSON",
"PbspID": "RANDY TEST PBSP",
"PhysicalLocation": "ARROWHEAD BLDG LOBBY",
"PreCheckinAllowed": "YES",
"ProhibitedClinic": 0,
"StationNumber": 442,
"StopCodeAMIS": 323,
"StopCodeName": "PRIMARY CARE/MEDICINE",
"Telephone": "(307)778-7550",
"TelephoneExtension": 1234,
"TimeZone": "EASTERN",
"TimeZoneDetails": [
{
"Offset": "-0500",
"TimeFrame": "STANDARD",
"TimeZoneCode": "EST"
},
{
"Offset": "-0400",
"TimeFrame": "DAYLIGHT SAVINGS",
"TimeZoneCode": "EDT"
}
],
"TimeZoneException": "",
"VeteranSelfCancel": "NO"
},
"CollateralVisit": "",
"ConsultLink": "",
"CurrentStatus": "INPATIENT/ACT REQ",
"DataEntryClerk": "CALIS,NEDIME",
"DateAppointmentMade": "2022-11-14T13:34:28-0500",
"DesiredDateOfAppointment": "2022-11-14",
"DuplicateApptSameDay": "",
"EASTrackingNumber": "",
"EkgDateTime": "",
"EncounterConversionStatus": "",
"EncounterFormsAsAddOns": "",
"EncounterFormsPrinted": "",
"EndTime": "2022-11-14T10:30-0500",
"FollowUpVisit": "YES",
"InpatientFlag": 1,
"LabDateTime": "",
"LengthOfAppt": 30,
"MRTCFlag": 1,
"NextAvaApptIndicator": "'NEXT AVA.' APPT. INDICATED BY USER",
"NoShowCancelDateTime": "",
"NoShowCancelledBy": "",
"Note": "TEST NOTE",
"NoteAuditing": [
{
"DateNoteAdded": "2024-10-16",
"Note": "TEST NOTE",
"NoteAddedByDUZ": 123456789,
"NoteAddedByName": "TEST,USER ONE"
},
],
"NumberOfCollateralSeen": "",
"OriginatingRequestType": "APPT",
"OtherTests": "",
"OtherTravel": " ",
"OutpatientEncounter": "2022-11-14T10:00-0500",
"OverLaidAppointmentData": "NO",
"OverbookFlag": "O",
"ParentRecordRequest": "",
"Patient": {
"CurrentEligibilityCode": "",
"DFN": 44354,
"DateOfBirth": "1951-05-27",
"DateOfBirthInternal": 2510527,
"DateOfDeath": "",
"DemographicsNeedUpdate": 1,
"Eligibility": "",
"EligibilityIEN": "",
"EligibilityOfVisit": "",
"EnrollmentCode": "",
"EnrollmentDate": "",
"FugitiveFelonFlag": "YES",
"Gender": "MALE",
"ICN": "4420062490V261831",
"LastRegistrationDate": "2022-09-26T16:23:58-0400",
"LocalFlag": [
""
],
"Name": "VSE,FUGITIVE FELON",
"NationalFlag": [
{
"AssignedDate": "2003-11-13T07:41:27-0500",
"Category": "I (NATIONAL)",
"Name": "BEHAVIORAL",
"Narrative": [
"This is a test account. The actual record text was removed Feb
14, 2018."
],
"OriginatingSiteID": 629,
"OriginatingSiteName": "SE LOUISIANA VETERANS HCS",
"OwnerSiteID": 671,
"OwnerSiteName": "AUDIE L. MURPHY MEMORIAL HOSP",
"ReviewDate": "",
"Type": "BEHAVIORAL"
}
],
"NeedInsuranceVerification": 1,
"OriginalRegistrationDate": "2022-09-26T16:23:58-0400",
"SSN": "2751P",
"SensitivePatientRestrictedRecord": 1,
"SensitivePatientType": 1,
"Street": "10000 MAIN"
},
"PatientComments": [
""
],
"PriorXRayResults": "",
"Provider": {
"ID": 520664036,
"Name": "TEST,GREGORIO D",
"SecId": ""
},
"PurposeOfVisit": "SCHEDULED VISIT",
"RealAppointment": 0,
"RequestIEN": 257996,
"RequestType": "APPT",
"Resource": {
"ClinicIEN": 3753,
"Name": "CHY ACUTE CARE 1"
},
"ResourceIEN": 2062,
"RoutingSlipPrintDate": "",
"RoutingSlipPrinted": "",
"SchedulerName": "",
"SchedulingApplication": "",
"SchedulingRequestType": "'NEXT AVAILABLE' APPT.",
"SpecialSurveyDisposition": "",
"StartTimeFM": 3221114.1,
"Status": "INPATIENT/ACT REQ",
"StatusCancelDateTime": "",
"VVSApptID": "",
"VeteranVideoCallURL": "",
"Walkin": "",
"WardLocation": "",
"XRAY": "",
"XrayDateTime": ""
}
]
}
AVAILABILITYRESTRICTED
INACTIVE
CLIENT MANAGER
WORD WRAP ON
VERSION
SUPPRESS RDV USER SETUP
APP PROXY ALLOWEDYes