SD VSE REPORT RPC (3618)    REMOTE PROCEDURE (8994)

Name Value
NAME SD VSE REPORT RPC
TAG REPORT
ROUTINE SDECXML
RETURN VALUE TYPE GLOBAL ARRAY
AVAILABILITY PUBLIC
WORD WRAP ON FALSE
VERSION 1
DESCRIPTION
Returns Scheduling appointment and encounter report data in XML format. 
The report data will be exclusive to one of three report types:
    Mental Health
    Primary Care
    Specialty Care
The returned data will be aggregated for the requested date range.
INPUT PARAMETER
  • SDRPTLST
    PARAMETER TYPE:   LITERAL
    MAXIMUM DATA LENGTH:   1
    REQUIRED:   YES
    SEQUENCE NUMBER:   1
    DESCRIPTION:   
     This parameter is the type of VSE Scheduling Report being run. 
      Currently, the choices are as follows:
       "M" (Mental Health)
       "P" (Primary Care)
       "S" (Specialty Care)
      Only one type of report may be run at at ime.
    
  • SDBEGRNG
    PARAMETER TYPE:   LITERAL
    MAXIMUM DATA LENGTH:   12
    REQUIRED:   YES
    SEQUENCE NUMBER:   2
    DESCRIPTION:   
      This parameter is the beginning date of the desired aggregated report data.
      The date should be in internal FileMan format.  
      Example: 3141115 = Nov 15, 2014
          3140901 = Sep 01, 2014.
     Time is accepted but ignored.
    
  • SDENDRNG
    PARAMETER TYPE:   LITERAL
    MAXIMUM DATA LENGTH:   12
    REQUIRED:   YES
    SEQUENCE NUMBER:   3
    DESCRIPTION:   
     This is the ending date of the date range for the desired report.
     The date should be in internal FileMan format.
     Example: 3140901 = Sep 01,2014
              3141115 = Nov 15, 2014
     Time is accepted but ignored.
    
RETURN PARAMETER DESCRIPTION
 Clinic Appointment and Encounter Data for previous 12 months is returned 
           <Division Name="All">
            <Rg Rg="All">
               <Rs Rn="All">
                <Rc Pr="All" Mn="Encounters" Vt="Actual" Vl="133"/>
               </Rs>
             </Rg>
            </Division>
          <Division Name="DIV1 VAMROC">
            <Rg Rg="All">
               <Rs Rn="All">
 in XML format.
                   <Rc Pr="All" Mn="Encounters" Vt="Actual" Vl="100"/>
                </Rs>
               <Rs Rn="CLIN 1">
                   <Rc Pr="All" Mn="Encounters" Vt="Actual" Vl="4"/>
             </Rs>
               <Rs Rn="CLIN 2">
                   <Rc Pr="All" Mn="Encounters" Vt="Actual" Vl="8"/>
             </Rs>
            </Rg>
          </Division>
  
          <Division Name="DIV 2">
            <Rg Rg="All">
               <Rs Rn="All">
                   <Rc Pr="All" Mn="Encounters" Vt="Actual" Vl="21"/>
                </Rs>
            </Rg>
          </Division>
        </Date>
      </DateAggregate>
    </ReportType>
 Example:
  </VAFacility>
<?xml version="1.0" encoding="UTF-8"?>
 <VAFacility Name="CHEYENNE VAMC" ID="442">
   <ReportType ReportType="Specialty Care">
      <DateAggregate DateAgg="Date">
        <Date ActivityDate="10/01/2011" DateName="11/04/2010">