Name | Value |
---|---|
NAME | SDES2 GET REQUESTS BY INST |
TAG | GETREQUESTS |
ROUTINE | SDES2GREQSINST |
RETURN VALUE TYPE | ARRAY |
AVAILABILITY | RESTRICTED |
WORD WRAP ON | FALSE |
APP PROXY ALLOWED | Yes |
DESCRIPTION | 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. |
INPUT PARAMETER |
|
RETURN PARAMETER DESCRIPTION | { }, "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", |