SDES GET APPTS BY PATIENT DFN3 (4710)    REMOTE PROCEDURE (8994)

Name Value
NAME SDES GET APPTS BY PATIENT DFN3
TAG GETAPPTBYPATDFN
ROUTINE SDESGETAPPTWRAP4
RETURN VALUE TYPE ARRAY
AVAILABILITY RESTRICTED
APP PROXY ALLOWED Yes
DESCRIPTION
This RPC retrieves and returns appointments from SDEC APPOINTMENT File
#409.84, HOSPITAL LOCATION File #44, and Appointment Multiple Patient File
#2 for a given patient DFN within a given date range in JSON format.
INPUT PARAMETER
  • DFN
    PARAMETER TYPE:   LITERAL
    MAXIMUM DATA LENGTH:   32000
    REQUIRED:   YES
    SEQUENCE NUMBER:   1
    DESCRIPTION:   
    Patient Data File Number (DFN) from Patient File #2.
    
  • SDBEGIN
    PARAMETER TYPE:   LITERAL
    MAXIMUM DATA LENGTH:   25
    REQUIRED:   YES
    SEQUENCE NUMBER:   2
    DESCRIPTION:   
    The beginning date/time in ISO 8601 Time Format to start for the search.
    
  • SDEND
    PARAMETER TYPE:   LITERAL
    MAXIMUM DATA LENGTH:   25
    REQUIRED:   YES
    SEQUENCE NUMBER:   3
    DESCRIPTION:   
    The ending date/time in ISO 8601 Time Format to start for the search.
    
  • EASTRCKNGNMBR
    PARAMETER TYPE:   LITERAL
    MAXIMUM DATA LENGTH:   40
    REQUIRED:   NO
    SEQUENCE NUMBER:   4
    DESCRIPTION:   
    Enterprise Appointment Scheduling (EAS) Tracking Number associated to an 
    appointment.
    
RETURN PARAMETER DESCRIPTION
{
   "AutoRebookedApptDateTime": "",
   },
 "PatientComments": "",  
 "PreCheckinAllowed": "",
 "PriorXRayResults": "",
   "Provider": {
    "ID": 520881799,
    "Name": "PROVIDER,CHAD E",
    "SecId": 1013556228
   },
   "PurposeOfVisit": "SCHEDULED VISIT",
   "CancelDateTime": "2023-02-21T22:10:14-0500",
   "RealAppointment": 0,
   "RequestIEN": 259592,
   "RequestType": "APPT",
   "Resource": {
    "ClinicIEN": 3753,
    "Name": "CHY ACUTE CARE 1"
   },
   "ResourceIEN": 2062,
   "RoutingSlipPrintDate": "",
   "RoutingSlipPrinted": "",
   "CancellationReason": "OTHER",
   "SchedulerName": "",
   "SchedulingApplication": "",
   "SchedulingRequestType": "'NEXT AVAILABLE' APPT.",
   "SpecialSurveyDisposition": "",
   "StartTimeFM": 3230327.09,
   "Status": "CANCELLED BY CLINIC",
   "StatusCancelDateTime": "2023-02-21T22:10:14-0500",
   "VVSApptID": "",
   "VeteranVideoCallURL": "",
   "Walkin": "NO",
   "CancellationRemarks": "TESTING MRTC CANCEL",
   "WardLocation": "",
   "XRAY": "",
   "XrayDateTime": ""
  }
 ]
}
   "CancellationReason": "",
   "CancellationRemarks": "",
   "CheckIn": "",
   "CheckInEntered": "",
   "CancelledByUser": {
   "CheckInSteps": [
    ""
   ],
   "CheckInUser": "",
   "CheckOut": "",
   "CheckOutEntered": "",
   "CheckOutUser": "",
   "Clinic": {
    "ClinicIEN": 5263,
    "Division": "CHEYENNE VAMROC",
    "ID": 520881776,
    "IsOverbook": 0,
    "Name": "ZZBWF TEST CLINIC1",
    "PatientFriendlyName": "",
    "PhysicalLocation": "ARROW",
    "StationNumber": 442,
    "Telephone": "(800)222-2222",
    "TelephoneExtension": "x1234",
    "TimeZone": "EASTERN",
    "TimeZoneDetails": [
     {
    "Name": "TEST,TEST A",
      "Offset": "-0500",
      "TimeFrame": "STANDARD",
      "TimeZoneCode": "EST"
     },
     {
      "Offset": "-0400",
      "TimeFrame": "DAYLIGHT SAVINGS",
      "TimeZoneCode": "EDT"
     }
    ],
    "SecId": 1044590326
    "TimeZoneException": ""
   },
   "CollateralVisit": "",
   "ConsultLink": "",
   "CurrentStatus": "NO ACTION TAKEN/TODAY",
   "DataEntryClerk": "USER,TEST A",
   "DateAppointmentMade": "2022-11-29T13:26:30-0500",
   "DesiredDateOfAppointment": "2022-11-29",
   "DuplicateApptSameDay": "",
   "EASTrackingNumber": "",
   },
   "EkgDateTime": "",
   "EncounterConversionStatus": "",
   "EncounterFormsAsAddOns": "",
   "EncounterFormsPrinted": "",
   "EndTime": "2022-11-29T09:30-0500",
   "FollowUpVisit": "NO",
   "LabDateTime": "",
   "LengthOfAppt": 30,
   "NextAvaApptIndicator": "'NEXT AVA.' APPT. INDICATED BY USER",
   "NoShowCancelDateTime": "",
   "CheckIn": "",
   "NoShowCancelledBy": "",
   "Note": [
    "NOSHOW UNIT TEST APPOINTMENT - DO NOT MODIFY."
   ],
   "NumberOfCollateralSeen": "",
   "OtherTests": "NOSHOW UNIT TEST APPOINTMENT - DO NOT MODIFY.",
   "OtherTravel": "  NOSHOW UNIT TEST APPOINTMENT - DO NOT MODIFY.",
   "OutpatientEncounter": "2022-11-29T09:00-0500",
   "OverLaidAppointmentData": "NO",
   "OverbookFlag": "",
 "Appointment": [
   "CheckInEntered": "",
   "ParentRecordRequest": "",
   "Patient": {
    "CurrentEligibilityCode": "NSC",
    "DFN": 31795,
    "EligibilityIEN": 5,
    "EnrollmentCode": "",
    "EnrollmentDate": "",
    "ICN": "XXXXXXXXXXXXXXXXXXXXX",
    "Name": "VSEUNITTEST,PATIENT",
    "SSN": 0000,
   "CheckInSteps": [
    "Street": "100000000000 MAIN STREET"
   },
   "PriorXRayResults": "",
   "Provider": [
    ""
   ],
   "PurposeOfVisit": "SCHEDULED VISIT",
   "RealAppointment": 1,
   "Resource": {
    "ClinicIEN": 5263,
    ""
    "Name": "ZZBWF TEST CLINIC1"
   },
   "ResourceIEN": 3634,
   "RoutingSlipPrintDate": "",
   "RoutingSlipPrinted": "",
   "SchedulerName": "",
   "SchedulingApplication": "",
   "SchedulingRequestType": "'NEXT AVAILABLE' APPT.",
   "SpecialSurveyDisposition": "",
   "StartTimeFM": 3221129.09,
   ],
   "Status": "NO ACTION TAKEN/TODAY",
   "StatusCancelDateTime": "",
   "VVSApptID": "",
   "VeteranVideoCallURL": "",
   "WardLocation": "",
   "XRAY": "",
   "XrayDateTime": ""
  }
 ]
}
   "CheckInUser": "",
   "CheckOut": "",
   "CheckOutEntered": "",
   "CheckOutUser": "",
   "Clinic": {
    "ClinicIEN": 3753,
  {
    "Division": "CHEYENNE VAMROC",
    "IsOverbook": 0,
    "Name": "CHY ACUTE CARE 1",
    "PatientFriendlyName": "CHY ACUTE CARE THOMPSON",
    "PhysicalLocation": "ARROWHEAD BLDG LOBBY",
    "StationNumber": 442,
    "Telephone": "(307)778-7550",
    "TelephoneExtension": "x1234",
    "DisplayClinicAppt": "YES",      
    "StopCodeAMIS": 323
   "AppointmentCancelled": "CANCELLED",
    "StopCodeName": "PRIMARY CARE",  
    "CreditStopCodeAMIS": 710,    
    "CreditStopCodeName": "IMMUNIZATION"    
    "TimeZone": "EASTERN",
    "TimeZoneDetails": [
     {
      "Offset": "-0500",
      "TimeFrame": "STANDARD",
      "TimeZoneCode": "EST"
     },
   "AppointmentDateTime": "2023-03-27T09:00-0400",
     {
      "Offset": "-0400",
      "TimeFrame": "DAYLIGHT SAVINGS",
      "TimeZoneCode": "EDT"
     }
    ],
    "TimeZoneException": ""
   },
 
 
   "AppointmentIEN": 295722,
   "CollateralVisit": "",
   "ConsultLink": "",
   "CurrentStatus": "CANCELLED BY CLINIC",
   "DataEntryClerk": "TEST,TEST A",
   "DateAppointmentMade": "2023-02-21",
   "DesiredDateOfAppointment": "2023-03-16",
   "DuplicateApptSameDay": "",
   "EASTrackingNumber": "",
   "ECheckinAllowed": "",  
   "EkgDateTime": "",
   "AppointmentType": "REGULAR",
   "EncounterConversionStatus": "",
   "EncounterFormsAsAddOns": "",
   "EncounterFormsPrinted": "",
   "EndTime": "2023-03-27T09:30-0400",
   "FollowUpVisit": "NO",
   "LabDateTime": "",
   "LengthOfAppt": 30,
   "NextAvaApptIndicator": "'NEXT AVA.' APPT. INDICATED BY USER",
   "NoShowCancelDateTime": "2023-02-21T22:10:14-0500",
   "NoShowCancelledBy": "TEST,TEST A",
   "AppointmentTypeIEN": 9,
   "Note": "",
   "NumberOfCollateralSeen": "",
   "OriginatingRequestType": "APPT",
   "OtherTests": "TEST",
   "OtherTravel": "  TEST",
   "OutpatientEncounter": "",
   "OverLaidAppointmentData": "NO",
   "OverbookFlag": "",
   "ParentRecordRequest": "",
   "Patient": {
   "AppointmentTypeSubCategory": "",
    "CurrentEligibilityCode": "SC LESS THAN 50%",
    "DFN": 7242560,
    "EligibilityIEN": 3,
    "EligibilityOfVisit": "AID & ATTENDANCE",
    "EnrollmentCode": "",
    "EnrollmentDate": "",
    "ICN": "4420062172V859025",
    "Name": "GEORGE,TEST",
    "SSN": 9812,
    "Street": "923 SMITHY STREET"