SDES2 SEARCH CLINIC SLOTS (5117)    REMOTE PROCEDURE (8994)

Name Value
NAME SDES2 SEARCH CLINIC SLOTS
TAG SEARCH
ROUTINE SDES2SEARCHSLOTS
RETURN VALUE TYPE ARRAY
AVAILABILITY RESTRICTED
INACTIVE ACTIVE
WORD WRAP ON FALSE
APP PROXY ALLOWED Yes
DESCRIPTION 
This RPC will identify consecutive, recurring slots in a clinic based on 
search criteria.
 
Can only be invoked by Acheron
INPUT PARAMETER
  • SDCONTEXT
    PARAMETER TYPE:   LIST
    MAXIMUM DATA LENGTH:   32000
    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.
  • SEARCH
    PARAMETER TYPE:   LIST
    MAXIMUM DATA LENGTH:   32000
    REQUIRED:   YES
    SEQUENCE NUMBER:   2
    DESCRIPTION:   
    Daily:
Weekly:
SEARCH("START DATE")="2024-12-09"
SEARCH("CLINIC IEN",1)=5592
SEARCH("CLINIC IEN",1)=4118
SEARCH("LENGTH")=30
SEARCH("AM OR PM")="AM"
SEARCH("NUMBER OF APPTS")=6
SEARCH("RECURRING EVERY")=3
SEARCH("FREQUENCY")="WEEKS"
SEARCH("WEEKDAY",1)="THURSDAY"
SEARCH("START DATE")="2024-12-10"
SEARCH("WEEKDAY",2)="TUESDAY"
 
Monthly:
SEARCH("START DATE")="2024-12-09"
SEARCH("CLINIC IEN",1)=5592
SEARCH("LENGTH")=30
SEARCH("AM OR PM")="PM"
SEARCH("NUMBER OF APPTS")=6
SEARCH("RECURRING EVERY")=4
SEARCH("OCCURRING EVERY")=2
SEARCH("CLINIC IEN",1)=2164
SEARCH("FREQUENCY")="MONTHS"
SEARCH("WEEKDAY",1)="TUESDAY"
SEARCH("WEEKDAY",2)="THURSDAY"
SEARCH("LENGTH")=90
SEARCH("AM OR PM")="PM"
SEARCH("NUMBER OF APPTS")=2
SEARCH("RECURRING EVERY")=2
SEARCH("FREQUENCY")="DAILY"
RETURN PARAMETER DESCRIPTION 
{
            "2024-12-11T08:00-0500",
            "2024-12-17T10:00-0500",
            "2024-12-20T10:00-0500",
            "2024-12-23T10:00-0500",
            "2024-12-26T10:00-0500",
            "2024-12-29T10:00-0500"
          ]
        },
        {
          "apptDateTime": [
            "2024-12-11T10:15-0500",
            "2024-12-14T08:00-0500",
            "2024-12-14T10:15-0500",
            "2024-12-17T10:15-0500",
            "2024-12-20T10:15-0500",
            "2024-12-23T10:15-0500",
            "2024-12-26T10:15-0500",
            "2024-12-29T10:15-0500"
          ]
        }
      ]
    },
            "2024-12-17T08:00-0500",
    {
      "clinicIen": 5652,
      "clinicName": "SRAVCLN1",
      "defaultProvider": "BECKSTRAND,WILL J",
      "result": [
        {
          "apptDateTime": [
            "2024-12-11T08:00-0500",
            "2024-12-14T08:00-0500",
            "2024-12-17T08:00-0500",
            "2024-12-20T08:00-0500",
            "2024-12-20T08:00-0500",
            "2024-12-23T08:00-0500",
            "2024-12-26T08:00-0500",
            "2024-12-29T08:00-0500"
          ]
        },
        {
          "apptDateTime": [
            "2024-12-11T08:30-0500",
            "2024-12-14T08:30-0500",
            "2024-12-23T08:00-0500",
            "2024-12-17T08:30-0500",
            "2024-12-20T08:30-0500",
            "2024-12-23T08:30-0500",
            "2024-12-26T08:30-0500",
            "2024-12-29T08:30-0500"
          ]
        },
        {
          "apptDateTime": [
            "2024-12-11T09:00-0500",
            "2024-12-26T08:00-0500",
            "2024-12-14T09:00-0500",
            "2024-12-17T09:00-0500",
            "2024-12-20T09:00-0500",
            "2024-12-23T09:00-0500",
            "2024-12-26T09:00-0500",
            "2024-12-29T09:00-0500"
          ]
        },
        {
          "apptDateTime": [
            "2024-12-29T08:00-0500"
            "2024-12-11T09:30-0500",
            "2024-12-14T09:30-0500",
            "2024-12-17T09:30-0500",
            "2024-12-20T09:30-0500",
            "2024-12-23T09:30-0500",
            "2024-12-26T09:30-0500",
            "2024-12-29T09:30-0500"
          ]
        },
        {
          ]
          "apptDateTime": [
            "2024-12-11T10:00-0500",
            "2024-12-14T10:00-0500",
            "2024-12-17T10:00-0500",
            "2024-12-20T10:00-0500",
            "2024-12-23T10:00-0500",
            "2024-12-26T10:00-0500",
            "2024-12-29T10:00-0500"
          ]
        },
        },
        {
          "apptDateTime": [
            "2024-12-11T10:30-0500",
            "2024-12-14T10:30-0500",
            "2024-12-17T10:30-0500",
            "2024-12-20T10:30-0500",
            "2024-12-23T10:30-0500",
            "2024-12-26T10:30-0500",
            "2024-12-29T10:30-0500"
          ]
        {
        },
        {
          "apptDateTime": [
            "2024-12-11T11:00-0500",
            "2024-12-14T11:00-0500",
            "2024-12-17T11:00-0500",
            "2024-12-20T11:00-0500",
            "2024-12-23T11:00-0500",
            "2024-12-26T11:00-0500",
            "2024-12-29T11:00-0500"
  "slotSearch": [
          "apptDateTime": [
          ]
        },
        {
          "apptDateTime": [
            "2024-12-11T11:30-0500",
            "2024-12-14T11:30-0500",
            "2024-12-17T11:30-0500",
            "2024-12-20T11:30-0500",
            "2024-12-23T11:30-0500",
            "2024-12-26T11:30-0500",
            "2024-12-11T08:15-0500",
            "2024-12-29T11:30-0500"
          ]
        },
        {
          "apptDateTime": [
            "2024-12-14T08:00-0500",
            "2024-12-17T08:00-0500",
            "2024-12-20T08:00-0500",
            "2024-12-23T08:00-0500",
            "2024-12-26T08:00-0500",
            "2024-12-14T08:15-0500",
            "2024-12-29T08:00-0500",
            "2025-01-04T08:00-0500"
          ]
        },
        {
          "apptDateTime": [
            "2024-12-14T08:30-0500",
            "2024-12-17T08:30-0500",
            "2024-12-20T08:30-0500",
            "2024-12-23T08:30-0500",
            "2024-12-17T08:15-0500",
            "2024-12-26T08:30-0500",
            "2024-12-29T08:30-0500",
            "2025-01-04T08:30-0500"
          ]
        }
      ]
    }
  ]
}
            "2024-12-20T08:15-0500",
            "2024-12-23T08:15-0500",
            "2024-12-26T08:15-0500",
            "2024-12-29T08:15-0500"
          ]
        },
    {
        {
          "apptDateTime": [
            "2024-12-11T08:30-0500",
            "2024-12-14T08:30-0500",
            "2024-12-17T08:30-0500",
            "2024-12-20T08:30-0500",
            "2024-12-23T08:30-0500",
            "2024-12-26T08:30-0500",
            "2024-12-29T08:30-0500"
          ]
      "clinicIen": 5592,
        },
        {
          "apptDateTime": [
            "2024-12-11T08:45-0500",
            "2024-12-14T08:45-0500",
            "2024-12-17T08:45-0500",
            "2024-12-20T08:45-0500",
            "2024-12-23T08:45-0500",
            "2024-12-26T08:45-0500",
            "2024-12-29T08:45-0500"
      "clinicName": "BRANDOTEST",
          ]
        },
        {
          "apptDateTime": [
            "2024-12-11T09:00-0500",
            "2024-12-14T09:00-0500",
            "2024-12-17T09:00-0500",
            "2024-12-20T09:00-0500",
            "2024-12-23T09:00-0500",
            "2024-12-26T09:00-0500",
      "defaultProvider": "BUTLER,BRANDON L",
            "2024-12-29T09:00-0500"
          ]
        },
        {
          "apptDateTime": [
            "2024-12-11T09:15-0500",
            "2024-12-14T09:15-0500",
            "2024-12-17T09:15-0500",
            "2024-12-20T09:15-0500",
            "2024-12-23T09:15-0500",
      "result": [
            "2024-12-26T09:15-0500",
            "2024-12-29T09:15-0500"
          ]
        },
        {
          "apptDateTime": [
            "2024-12-11T09:30-0500",
            "2024-12-14T09:30-0500",
            "2024-12-17T09:30-0500",
            "2024-12-20T09:30-0500",
        {
            "2024-12-23T09:30-0500",
            "2024-12-26T09:30-0500",
            "2024-12-29T09:30-0500"
          ]
        },
        {
          "apptDateTime": [
            "2024-12-11T09:45-0500",
            "2024-12-14T09:45-0500",
            "2024-12-17T09:45-0500",
          "apptDateTime": [
            "2024-12-20T09:45-0500",
            "2024-12-23T09:45-0500",
            "2024-12-26T09:45-0500",
            "2024-12-29T09:45-0500"
          ]
        },
        {
          "apptDateTime": [
            "2024-12-11T10:00-0500",
            "2024-12-14T10:00-0500",