SDES2 PATIENT SEARCH (4970)    REMOTE PROCEDURE (8994)

Name Value
NAME SDES2 PATIENT SEARCH
TAG SEARCH
ROUTINE SDES2PATSEARCH
RETURN VALUE TYPE ARRAY
AVAILABILITY RESTRICTED
APP PROXY ALLOWED Yes
DESCRIPTION
This RPC will return patients and their associated data based on search 
 criteria passed in by the user (PARTIAL NAME, DOB, SSN, FIRST INITIAL OF 
 LAST NAME+LAST4 OF SSN).
INPUT PARAMETER
  • SDCONTEXT
    PARAMETER TYPE:   LIST
    MAXIMUM DATA LENGTH:   32000
    REQUIRED:   YES
    SEQUENCE NUMBER:   1
    DESCRIPTION:   
    SDCONTEXT("ACHERON AUDIT ID") = Up to 40 Character unique ID number. 
                the calling application.
                Ex: 11d9dcc6-c6a2-4785-8031-8261576fca37
     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.
     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
    
  • PARAMS
    PARAMETER TYPE:   LIST
    MAXIMUM DATA LENGTH:   32000
    REQUIRED:   YES
    SEQUENCE NUMBER:   2
    DESCRIPTION:   
    PARAMS("SEARCHSTRING")= This is a free text input parameter that holds 
    the search criteria entered by the user. Minimum of 3 characters required.
     
    PARAMS("NUMOFRECORDS")= This is the number of records the user is 
    requesting be passed back. This number has an upper limit of 50. If it is
    not passed in, it will default to 10 records.
    
RETURN PARAMETER DESCRIPTION
 
            "DateOfBirth": "1947-11-15",
            {
                "SecondaryEligibilityCode": "ALLIED VETERAN",
                "SecondaryEligibilityCodeType": "NON-VETERAN"
            },
            {
                "SecondaryEligibilityCode": "HUMANITARIAN EMERGENCY",
                "SecondaryEligibilityCodeType": "NON-VETERAN"
            },
            {
                "SecondaryEligibilityCode": "COLLATERAL OF VET.",
            "DateOfDeath": "2023-02-23",
                "SecondaryEligibilityCodeType": "NON-VETERAN"
            },
            {
                "SecondaryEligibilityCode": "TRICARE",
                "SecondaryEligibilityCodeType": "NON-VETERAN"
            }
        ],
        "EnrollmentSubGroup": "",
        "Flag": [
            {
            "DemographicsNeedUpdate": 0,
                ,CLAY M
                "ApprovedBy": "GLAD",
                "AssignedDate": "2016-11-07T11":53:37-0500,
                "Category": "I (NATIONAL)",
                "FlagName": "HIGH RISK FOR SUICIDE",
                "Narrative": [This is a test account.  The actual record 
text was removed Feb 14, 2018.]
                "OriginatingSiteID": 442,
                "OriginatingSiteName": "CHEYENNE VA MEDICAL",
                "OwnerSiteID": 442,
            "DemographicsUpdated": "2023-09-27",
                "OwnerSiteName": "CHEYENNE VA MEDICAL",
                "ReviewDate": "2018-04-25",
                "Type": "CLINICAL"
            }
        ],
        "FugitiveFelon": "",
        "Gender": "FEMALE",
        "GenderIdentity": "Prefer not to answer",
        "ICNNumber": "1002001927V385494",
        "Last4SSN": 8697,
            "Eligibility": [
        "MentalHealthProvider": "VSETEST,PROVIDERONE",
        "Name": "CHAPPLE,M",
        ,MORGAN J
        "NewGAFRequired": "No new GAF required",
        "PatientType": "NSC VETERAN",
        "PreferredName": "BATMAN",
        "PrimaryCarePractitioner": "MCGAW,ELLIOTT D",
        "PriorityGroup": "GROUP 4",
        "RatedDisabilities": "",
        "SensitivePatientRestrictedRecord": 1,
                {
        "ServiceConnected": "YES (50%)",
        "ServiceConnectedCondition": [
            {
                "Condition": "STUBBED HIS TOE"
            },
            {
                "Condition": "TRIPPED ON LAUNDRY"
            },
            {
                "Condition": "CUT HIMSELF SHAVING"
                    "PrimaryEligibilityCode": "SERVICE CONNECTED 50% to 
            },
            {
                "Condition": "HIT FUNNYBONE"
            },
            {
                "Condition": "ATE TOO MUCH MEXICAN FOOD"
            }
        ],
        "Ward": "C MEDICINE"
        }
100%",
    ]
 }
}
         }
     ]
  }
                    "PrimaryEligibilityCodeType": "VETERAN"
                },
 
                {
                    "SecondaryEligibilityCode": "ALLIED VETERAN",
                    "SecondaryEligibilityCodeType": "NON-VETERAN"
                },
                {
                    "SecondaryEligibilityCode": "HUMANITARIAN EMERGENCY",
                    "SecondaryEligibilityCodeType": "NON-VETERAN"
                },
                {
                    "SecondaryEligibilityCode": "COLLATERAL OF VET.",
fails.
                    "SecondaryEligibilityCodeType": "NON-VETERAN"
                },
                {
                    "SecondaryEligibilityCode": "TRICARE",
                    "SecondaryEligibilityCodeType": "NON-VETERAN"
                }
            ],
            "EnrollmentSubGroup": "",
            "Flag": [
                {
 
                    ,CLAY M
                    "ApprovedBy": "GLAD",
                    "AssignedDate": "2016-11-07T11":53:37-0500,
                    "Category": "I (NATIONAL)",
                    "FlagName": "HIGH RISK FOR SUICIDE",
                    "Narrative": [This is a test account.  The actual 
record text was removed Feb 14, 2018.]
                    "OriginatingSiteID": 442,
                    "OriginatingSiteName": "CHEYENNE VA MEDICAL",
                    "OwnerSiteID": 442,
 
                    "OwnerSiteName": "CHEYENNE VA MEDICAL",
                    "ReviewDate": "2018-04-25",
                    "Type": "CLINICAL"
                }
            ],
            "FugitiveFelon": "",
            "Gender": "FEMALE",
            "GenderIdentity": "Prefer not to answer",
            "ICNNumber": "1002001927V385494",
            "Last4SSN": 8697,
 {
            "MentalHealthProvider": "VSETEST,PROVIDERONE",
            "Name": "CHAPPLE,M",
            ,MORGAN J
            "NewGAFRequired": "No new GAF required",
            "PatientType": "NSC VETERAN",
            "PreferredName": "BATMAN",
            "PrimaryCarePractitioner": "MCGAW,ELLIOTT D",
            "PriorityGroup": "GROUP 4",
            "RatedDisabilities": "",
            "SensitivePatientRestrictedRecord": 1,
    "Patient": [
            "ServiceConnected": "YES (50%)",
            "ServiceConnectedCondition": [
                {
                    "Condition": "STUBBED HIS TOE"
                },
                {
                    "Condition": "TRIPPED ON LAUNDRY"
                },
                {
                    "Condition": "CUT HIMSELF SHAVING"
        {
                },
                {
                    "Condition": "HIT FUNNYBONE"
                },
                {
                    "Condition": "ATE TOO MUCH MEXICAN FOOD"
                }
            ],
            "Ward": "C MEDICINE"
            }
            "DFN": 38281,
        "DFN": 38281,
        "DateOfBirth": "1947-11-15",
        "DateOfDeath": "2023-02-23",
        "DemographicsNeedUpdate": 0,
        "DemographicsUpdated": "2023-09-27",
        "Eligibility": [
            {
                "PrimaryEligibilityCode": "SERVICE CONNECTED 50% to 100%",
                "PrimaryEligibilityCodeType": "VETERAN"
            },