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

Name Value
NAME SDES GET APPTS BY PATIENT DFN3
TAG BYPATDFN
ROUTINE SDESGETAPPTRPCS
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
 Example one: Cancelled appointment
     "AppointmentTypeSubCategory": "",
    "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",
     "AutoRebookedApptDateTime": "",
    "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
     "CancelDateTime": "2023-12-06T14:17:06-0500",
N",
       "OPQRSTABCDEFGHIJKLMNOPQRST",
       
"ABCDEFGHIJKLMNOPQRSTABCDEFGHIJKLMNOPQRSTABCDEFGHIJKLMNOPQRSTABCDEFGHIJKLM
N",
       "OPQRSTABCDEFGHIJKLMNOPQRST",
       
"ABCDEFGHIJKLMNOPQRSTABCDEFGHIJKLMNOPQRSTABCDEFGHIJKLMNOPQRSTABCDEFGHIJKLM
N",
       "OPQRSTABCDEFGHIJKLMNOPQRST",
     "CancellationReason": "PANDEMIC",
       
"ABCDEFGHIJKLMNOPQRSTABCDEFGHIJKLMNOPQRSTABCDEFGHIJKLMNOPQRSTABCDEFGHIJKLM
N",
       "OPQRSTABCDEFGHIJKLMNOPQRST",
       
"ABCDEFGHIJKLMNOPQRSTABCDEFGHIJKLMNOPQRSTABCDEFGHIJKLMNOPQRSTABCDEFGHIJKLM
N",
       "OPQRSTABCDEFGHIJKLMNOPQRST",
       " ",
       "END OF TEXT"
     "CancellationRemarks": "",
      ],
      "OriginatingSiteID": 442,
      "OriginatingSiteName": "CHEYENNE VA MEDICAL",
      "OwnerSiteID": 442,
      "OwnerSiteName": "CHEYENNE VA MEDICAL",
      "ReviewDate": "2023-12-13",
      "Type": "OTHER"
     }
    ],
    "Name": "VSE,LOCAL FLAG",
     "CancelledByUser": {
    "NationalFlag": [
     ""
    ],
    "NeedInsuranceVerification": 1,
    "OriginalRegistrationDate": "2011-03-22T10:49:09-0400",
    "SSN": "0690P",
    "SensitivePatientRestrictedRecord": 0,
    "SensitivePatientType": 0,
    "Street": "C/O P MAI (136B)"
   },
      "ID": 520881841,
     "PatientComments": [
      ""
     ],
     "PriorXRayResults": "",
     "Provider": {
      "ID": 1824,
      "Name": "PROVIDER,TEST J",
      "SecId": 1034217513
     },
     "PurposeOfVisit": "SCHEDULED VISIT",
      "Name": "TEST,USR",
     "RealAppointment": 0,
     "RequestIEN": 263452,
     "RequestType": "APPT",
     "Resource": {
      "ClinicIEN": 2147,
      "Name": "CHY CARDIOLOGY"
     },
     "ResourceIEN": 1058,
     "RoutingSlipPrintDate": "",
     "RoutingSlipPrinted": "",
      "SecId": 1060245260
     "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": [
    {
  {
     "CheckIn": "",
     "AppointmentCancelled": "",
     "AppointmentDateTime": "2022-11-14T10:00-0500",
     "AppointmentIEN": 294806,
     "AppointmentType": "REGULAR",
     "AppointmentTypeIEN": 9,
     "AppointmentTypeSubCategory": "",
     "AutoRebookedApptDateTime": "",
     "CancelDateTime": "",
     "CancellationReason": "",
     "CancellationRemarks": "",
     "CheckInEntered": "",
     "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"
     "CheckInSteps": [
      },
      {
       "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",
     "CheckInUser": "",
     "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,
     "CheckOut": "",
      "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",
     "CheckOutEntered": "",
      "TelephoneExtension": 1234,
      "TimeZone": "EASTERN",
      "TimeZoneDetails": [
       {
        "Offset": "-0500",
        "TimeFrame": "STANDARD",
        "TimeZoneCode": "EST"
       },
       {
        "Offset": "-0400",
     "CheckOutUser": "",
        "TimeFrame": "DAYLIGHT SAVINGS",
        "TimeZoneCode": "EDT"
       }
      ],
      "TimeZoneException": ""
     },
     "CollateralVisit": "",
     "ConsultLink": "",
     "CurrentStatus": "INPATIENT/ACT REQ",
     "DataEntryClerk": "CALIS,NEDIME",
     "Clinic": {
     "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",
   "Appointment": [
      "ClinicIEN": 2147,
     "InpatientFlag": 1,
     "LabDateTime": "",
     "LengthOfAppt": 30,
     "MRTCFlag": 1,
     "NextAvaApptIndicator": "'NEXT AVA.' APPT. INDICATED BY USER",
     "NoShowCancelDateTime": "",
     "NoShowCancelledBy": "",
     "Note": "",
     "NumberOfCollateralSeen": "",
     "OriginatingRequestType": "APPT",
      "CreditStopCodeAMIS": 179,
     "OtherTests": "",
     "OtherTravel": "  ",
     "OutpatientEncounter": "2022-11-14T10:00-0500",
     "OverLaidAppointmentData": "NO",
     "OverbookFlag": "O",
     "ParentRecordRequest": "",
  "Patient": {
    "CurrentEligibilityCode": "",
    "DFN": 44354,
    "DateOfBirth": "1951-05-27",
      "CreditStopCodeName": "RT CLIN VID CARE HOME",
    "DateOfBirthInternal": 2510527,
    "DateOfDeath": "",
    "DemographicsNeedUpdate": 1,
    "Eligibility": "",
    "EligibilityIEN": "",
    "EligibilityOfVisit": "",
    "EnrollmentCode": "",
    "EnrollmentDate": "",
    "FugitiveFelonFlag": "YES",
    "Gender": "MALE",
      "DisplayClinicAppt": "YES",
    "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)",
      "Division": "CHEYENNE VAMROC",
      "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": "",
      "ECheckinAllowed": "YES",
      "Type": "BEHAVIORAL"
     }
    ],
    "NeedInsuranceVerification": 1,
    "OriginalRegistrationDate": "2022-09-26T16:23:58-0400",
    "SSN": "2751P",
    "SensitivePatientRestrictedRecord": 1,
    "SensitivePatientType": 1,
    "Street": "10000 MAIN"
   },
      "IsOverbook": 0,
     "PatientComments": [
      ""
     ],
     "PriorXRayResults": "",
     "Provider": {
      "ID": 520664036,
      "Name": "TEST,GREGORIO D",
      "SecId": ""
     },
     "PurposeOfVisit": "SCHEDULED VISIT",
      "Name": "CHY CARDIOLOGY",
     "RealAppointment": 0,
     "RequestIEN": 257996,
     "RequestType": "APPT",
     "Resource": {
      "ClinicIEN": 3753,
      "Name": "CHY ACUTE CARE 1"
     },
     "ResourceIEN": 2062,
     "RoutingSlipPrintDate": "",
     "RoutingSlipPrinted": "",
      "PatientFriendlyName": "CHY CARDIOLOGY",
     "SchedulerName": "",
     "SchedulingApplication": "",
     "SchedulingRequestType": "'NEXT AVAILABLE' APPT.",
     "SpecialSurveyDisposition": "",
     "StartTimeFM": 3221114.1,
     "Status": "INPATIENT/ACT REQ",
     "StatusCancelDateTime": "",
     "VVSApptID": "",
     "VeteranVideoCallURL": "",
     "Walkin": "",
      "PbspID": "",
     "WardLocation": "",
     "XRAY": "",
     "XrayDateTime": ""
    }
   ]
  }
    {
      "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": [
     "AppointmentCancelled": "CANCELLED",
       {
        "Offset": "-0500",
        "TimeFrame": "STANDARD",
        "TimeZoneCode": "EST"
       },
       {
        "Offset": "-0400",
        "TimeFrame": "DAYLIGHT SAVINGS",
        "TimeZoneCode": "EDT"
       }
     "AppointmentDateTime": "2023-12-06T08:00-0500",
      ],
      "TimeZoneException": ""
     },
     "CollateralVisit": "",
     "ConsultLink": "",
     "CurrentStatus": "CANCELLED BY CLINIC",
     "DataEntryClerk": "TEST,USR",
     "DateAppointmentMade": "2023-12-06T14:12:13-0500",
     "DesiredDateOfAppointment": "2023-12-06",
     "DuplicateApptSameDay": "",
     "AppointmentIEN": 298114,
     "EASTrackingNumber": "",
     "EkgDateTime": "",
     "EncounterConversionStatus": "",
     "EncounterFormsAsAddOns": "",
     "EncounterFormsPrinted": "",
     "EndTime": "2023-12-06T08:30-0500",
     "FollowUpVisit": "NO",
     "InpatientFlag": 0,
     "LabDateTime": "",
     "LengthOfAppt": 30,
     "AppointmentType": "REGULAR",
     "MRTCFlag": 1,
     "NextAvaApptIndicator": "'NEXT AVA.' APPT. INDICATED BY USER & 
CALCULATION",
     "NoShowCancelDateTime": "2023-12-06T14:17:06-0500",
     "NoShowCancelledBy": "TEST,USR",
     "Note": "",
     "NumberOfCollateralSeen": "",
     "OriginatingRequestType": "APPT",
     "OtherTests": "",
     "OtherTravel": "  ",
     "AppointmentTypeIEN": 9,
     "OutpatientEncounter": "",
     "OverLaidAppointmentData": "NO",
     "OverbookFlag": "",
     "ParentRecordRequest": "",
     "Patient": {
    "CurrentEligibilityCode": "SERVICE CONNECTED 50% to 100%",
    "DFN": 7209450,
    "DateOfBirth": "1990-06-06",
    "DateOfBirthInternal": 2900606,
    "DateOfDeath": "",