SDES2 GET REQUESTS BY INST (4914)    REMOTE PROCEDURE (8994)

This RPC returns all open appointment requests (up to 200 per request 
type). If the station number is passed in, only records for that 
station/institution will be returned.
 
If the station number
parameter is passed in, it will only return records for the institution 
associated with that station number.

• SDCONTEXT
  PARAMETER TYPE:   LIST
  REQUIRED:   YES
  SEQUENCE NUMBER:   1
  DESCRIPTION:   

  SDCONTEXT("ACHERON AUDIT ID")
  SDCONTEXT("PATIENT ICN")
   - The ICN of the target patient from the calling application.
   - Up to 40 Character unique ID number. 
   - Ex: 11d9dcc6-c6a2-4785-8031-8261576fca37
  SDCONTEXT("USER DUZ")
   - The DUZ of the user taking action in the calling application.
  SDCONTEXT("USER SECID")
   - The SECID of the user taking action in the calling application.
  SDCONTEXT("PATIENT DFN")
   - The DFN/IEN of the target patient from the calling application.
  

• SDAPPTREQS
  PARAMETER TYPE:   LIST
  REQUIRED:   NO
  SEQUENCE NUMBER:   2
  DESCRIPTION:   

  SDAPPTREQS("STATION NUMBER") - (optional) - Station Number
  SDAPPTREQS("NUMBER")    - (optional) - the number of records to find for 
                                         each appointment request type
                                         (consult/procedure, appointment 
                                         request, and recall 1-200).
  

{
    },
   "DispositionIEN": "",
   "DispositionReason": "",
   "DispositionedBy": "",
   "DispositionedDate": "",
   "DuplicateReason": "DUPLICATE REASON TEXT",
   "EASTrackingNumber": "",
   "EnrollmentPriorityGroup": "GROUP 3",
   "EnteredByIEN": 123456,
   "EnteredByName": "USER ,TEST G",
   "InstitutionIEN": "",
    {
   "InstitutionName": "",
   "InstitutionNumber": "",
   "LinkedApptClinic": "",
   "LinkedApptCreditStopCode": "",
   "LinkedApptEnteredBy": "",
   "LinkedApptInstitutionName": "",
   "LinkedApptInstitutionNumber": "",
   "LinkedApptStationNumber": "",
   "LinkedApptStatus": "",
   "LinkedApptStopCode": "",
     "PreRequisite": "PRE-REQ 534"
   "MRTC": [
    {
     "ChildRequestIEN": 264525,
     "ChildRequestSequenceNumber": 1,
     "LinkedAppointmentIEN": 298941,
     "PatientIndicatedDate": "2024-03-06"
    },
    {
     "ChildRequestIEN": 264526,
     "ChildRequestSequenceNumber": 2,
    },
     "LinkedAppointmentIEN": "",
     "PatientIndicatedDate": "2024-03-13"
    },
    {
     "ChildRequestIEN": 264527,
     "ChildRequestSequenceNumber": 3,
     "LinkedAppointmentIEN": "",
     "PatientIndicatedDate": "2024-03-20"
    }
   ],
    {
   "MRTCDaysBetweenAppts": "",
   "MRTCHowManyNeeded": "",
   "MRTCNeeded": "",
   "MRTCTotal": "",
   "ModalityCode": "",
   "ModalityName": "",
   "PIDChangeAllowed": "",
   "ParentRequestIEN": "",
   "PatientComment": [
    {
     "PreRequisite": "PRE-REQ 634"
     "Comment": "TESTING TESTING TESTING 123 "
    },
    {
     "Comment": "Patient preferred date range #1: Jul 25, 2022@10:00 to 
Jul 31, 2022@10:00 "
    },
    {
     "Comment": "Patient preferred date range #2: Aug 17, 2022@10:00 to 
Aug 31, 2022@10:00 "
    },
    }
    {
     "Comment": "Patient preferred date range #3: Sep 30, 2022@10:00 to 
Oct 01, 2022@10:00"
    }
   ],
   "PatientICN": "",
   "PatientIEN": 11221122,
   "PatientIndicatedDate": "",
   "PatientLast4": 4607,
   "PatientName": "PATIENT, TEST",
   ],
   "PatientPhone": 999-999-9999,
   "PatientStatus": "",
   "Priority": "",
   "ProviderIEN": "",
   "ProviderName": "",
   "ProviderSecID": "",
   "RecallAccessionNumber": "",
   "RecallAppointmentLength": 30,
   "RecallAppointmentType": "YEARLY EXAM",
   "RecallClinicSecondaryStopCodeAMIS": 117,
   "CPRSStatus": "",
   "RecallClinicSecondaryStopCodeIEN": 123,
   "RecallClinicSecondaryStopCodeName": "NURSING (2ND ONLY)",
   "RecallClinicStopCodeAMIS": 323,
   "RecallClinicStopCodeIEN": 296,
   "RecallClinicStopCodeName": "PRIMARY CARE\/MEDICINE",
   "RecallComment": "RTC IN 1 YEAR W LABS PER RTC ORDER\/\/CID=032918",
   "RecallDateReminderSent": "2018-01-28",
   "RecallEnteredBySecID": 1234,
   "RecallFastingNonFasting": "FASTING",
   "RecallGAFScore": "New GAF Required",
   "CPRSTimeSensitive": "",
   "RecallProviderIEN": 27,
   "RecallProviderIndicatedDate": "2018-03-29",
   "RecallProviderName": "TEST,PROVIDER A",
   "RecallProviderNewPersonIEN":123123,
   "RecallProviderSecID": "",
   "RecallSecondPrint": "",
   "RecallSimilarPatientData": "",
   "RequestComments": "",
   "RequestIEN": 206674,
   "RequestSubType": "",
 "Request": [
   "ChildRequestSequenceNumber": "",
   "ScheduledDateOfAppt": "",
   "SdecContactDateOfLastLetterSent": "",
   "SdecContactNumberOfCalls": "",
   "SdecContactNumberOfContacts": 0,
   "SdecContactNumberOfEmailContact": "",
   "SdecContactNumberOfLetters": "",
   "SdecContactNumberOfSecureMessage": "",
   "SdecContactNumberOfTextContact": "",
   "SensitiveRecord": 0,
   "ServiceConnectedPercentage": "",
   "ClinicIEN": "" ,
   "ServiceConnectedPriority": "",
   "Status": "",
   "Type": ""
  }
 ]
}
   "ClinicName": "",
   "ClinicSecondaryStopCodeAMIS": "",
   "ClinicSecondaryStopCodeIEN": "",
   "ClinicSecondaryStopCodeName": "",
   "ClinicStopCodeAMIS": "",
   "ClinicStopCodeIEN": "",
   "ClinicStopCodeName": "",
   "CommentMultiple": [
  {
    {
     "Comment": "This is an appt request comment 333333777"
    }
   ],
   "ConsultAssociatedStopCodes": [
    {
     "AmisStopCode": 116,
     "RestrictionType": "E",
     "StopCode": 379,
     "StopCodeName": "RESPIRATORY THERAPY"
   "ApptType": "",
    },
    {
     "AmisStopCode": 303,
     "RestrictionType": "E",
     "StopCode": 147,
     "StopCodeName": "CARDIOLOGY"
    },
    {
     "AmisStopCode": 107,
     "RestrictionType": "P",
   "ByPatientOrProvider": "",
     "StopCode": 114,
     "StopCodeName": "EKG"
    },
    {
     "AmisStopCode": 115,
     "RestrictionType": "E",
     "StopCode": 122,
     "StopCodeName": "ULTRASOUND (US)"
    }
   ],
   "CPRSOrderID": "",
   "ConsultCanEditPid": "",
   "ConsultClinicIndicatedDate": "",
   "ConsultCovidPriority": "",
   "ConsultDateReleasedFromCPRS": "",
   "ConsultProhibitedClinicFlag": "",
   "ConsultRequestType": "",
   "ConsultServiceRenderedAs": "",
   "ConsultToService": "",
   "ConsultUrgencyOrEarliestDate": "",
   "Contact": {
   "CPRSPreRequisites": [
    "Clinic": 5260,
    "ClinicStopCodeAMIS": 323,
    "ID": 2529,
    "MainSequence": 1,
    "Patient": 7201233,
    "PreferredDate": "2024-02-24",
    "RequestPointer": "12345;SDEC(409.85,",
    "RequestType": "A",
    "Service": ""
   },
    {
   "ContactAttempts": [
    {
     "Comments": "ONE CONTACT ATTEMPT FOR VSE 7306",
     "DateTimeEntered": "2024-02-23T11:43:23-0500",
     "DateTimeOfContact": "2024-02-23T11:42:58-0500",
     "EnteredByIEN": 12345,
     "EnteredByName": "USER, VSETEST",
     "EnteredBySecID": 456789,
     "LeftMessage": "NO",
     "Sequence": 1,
     "PreRequisite": "PRE-REQ 434"
     "Type": "TEXT"
    }
   ],
   "CreateDate": "",
   "CreditStopCodeAMIS": 117,
   "CreditStopCodeIEN": 123,
   "CreditStopCodeName": "NURSING (2ND ONLY)",
   "DateLinkedApptMade": "",
   "DateTimeEntered": "",
   "DisplayClinicAppt": "YES",