SDES GET APPTS BY CLIN IEN 3 (4709)    REMOTE PROCEDURE (8994)

Name Value
NAME SDES GET APPTS BY CLIN IEN 3
TAG BYCLINIEN
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 clinic within a given date range in JSON format.
INPUT PARAMETER
  • CLINICIEN
    PARAMETER TYPE:   LITERAL
    MAXIMUM DATA LENGTH:   20
    REQUIRED:   YES
    SEQUENCE NUMBER:   1
    DESCRIPTION:   
    The Internal Entry Number (IEN) from HOSPITAL LOCATION FILE #44.
    
  • 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": "",