TITLE | VALUE | |
---|---|---|
NAME | SDES2 GET REQUESTS BY INST | |
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. Can only be invoked by Acheron | |
TAG | GETREQUESTS | |
ROUTINE | SDES2GREQSINST | |
INPUT PARAMETERS | SEQUENCE NUMBER | 1 |
INPUT PARAMETER | SDCONTEXT | |
DESCRIPTION | SDCONTEXT("ACHERON AUDIT ID") - 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. SDCONTEXT("PATIENT ICN") - The ICN of the target patient from the calling application. | |
PARAMETER TYPE | LIST | |
REQUIRED | YES | |
MAXIMUM DATA LENGTH | ||
INPUT PARAMETERS | SEQUENCE NUMBER | 2 |
INPUT PARAMETER | SDAPPTREQS | |
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). | |
PARAMETER TYPE | LIST | |
REQUIRED | NO | |
MAXIMUM DATA LENGTH | ||
RETURN VALUE TYPE | ARRAY | |
RETURN PARAMETER DESCRIPTION | { "Request": [ { "ApptType": "", "ByPatientOrProvider": "", "CPRSOrderID": "", "CPRSPreRequisites": [ { "PreRequisite": "PRE-REQ 434" }, { "PreRequisite": "PRE-REQ 534" }, { "PreRequisite": "PRE-REQ 634" } ], "CPRSStatus": "", "CPRSTimeSensitive": "", "ChildRequestSequenceNumber": "", "ClinicIEN": "" , "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" }, { "AmisStopCode": 303, "RestrictionType": "E", "StopCode": 147, "StopCodeName": "CARDIOLOGY" }, { "AmisStopCode": 107, "RestrictionType": "P", "StopCode": 114, "StopCodeName": "EKG" }, { "AmisStopCode": 115, "RestrictionType": "E", "StopCode": 122, "StopCodeName": "ULTRASOUND (US)" } ], "ConsultCanEditPid": "", "ConsultClinicIndicatedDate": "", "ConsultCovidPriority": "", "ConsultDateReleasedFromCPRS": "", "ConsultProhibitedClinicFlag": "", "ConsultRequestType": "", "ConsultServiceRenderedAs": "", "ConsultToService": "", "ConsultUrgencyOrEarliestDate": "", "Contact": { "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, "Type": "TEXT" } ], "CreateDate": "", "CreditStopCodeAMIS": 117, "CreditStopCodeIEN": 123, "CreditStopCodeName": "NURSING (2ND ONLY)", "DateLinkedApptMade": "", "DateTimeEntered": "", "DisplayClinicAppt": "YES", "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": "", "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": [ { "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, "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", "RecallProviderIEN": 27, "RecallProviderIndicatedDate": "2018-03-29", "RecallProviderName": "TEST,PROVIDER A", "RecallProviderNewPersonIEN":123123, "RecallProviderSecID": "", "RecallSecondPrint": "", "RecallSimilarPatientData": "", "RequestComments": "", "RequestIEN": 206674, "RequestSubType": "", "ScheduledDateOfAppt": "", "SdecContactDateOfLastLetterSent": "", "SdecContactNumberOfCalls": "", "SdecContactNumberOfContacts": 0, "SdecContactNumberOfEmailContact": "", "SdecContactNumberOfLetters": "", "SdecContactNumberOfSecureMessage": "", "SdecContactNumberOfTextContact": "", "SensitiveRecord": 0, "ServiceConnectedPercentage": "", "ServiceConnectedPriority": "", "Status": "", "Type": "" } ] } | |
AVAILABILITY | RESTRICTED | |
INACTIVE | ||
CLIENT MANAGER | ||
WORD WRAP ON | FALSE | |
VERSION | ||
SUPPRESS RDV USER SETUP | ||
APP PROXY ALLOWED | Yes |