SDES PATIENT SEARCH (4790)    REMOTE PROCEDURE (8994)

Name Value
NAME SDES PATIENT SEARCH
TAG SEARCH
ROUTINE SDESPATSEARCH
RETURN VALUE TYPE ARRAY
AVAILABILITY RESTRICTED
INACTIVE ACTIVE
WORD WRAP ON FALSE
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
  • SEARCHSTRING
    PARAMETER TYPE:   LITERAL
    MAXIMUM DATA LENGTH:   32000
    REQUIRED:   NO
    SEQUENCE NUMBER:   1
    DESCRIPTION:   
    This is a free text input parameter that holds the search criteria 
    entered by the user.
    
  • NUMOFRECORDS
    PARAMETER TYPE:   LITERAL
    MAXIMUM DATA LENGTH:   32000
    REQUIRED:   YES
    SEQUENCE NUMBER:   2
    DESCRIPTION:   
    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 a value of 10.
    
RETURN PARAMETER DESCRIPTION
{
                {
            },
            {
                "SecondaryEligibilityCode": "TRICARE",
                "SecondaryEligibilityCodeType": "NON-VETERAN"
            }
        ],
        "Flag": [
            {
                "AssignedDate": "2016-11-07T11":53:37-0500,
                "Category": "I (NATIONAL)",
                    "PrimaryEligibilityCode": "SERVICE CONNECTED 50% to 
                "FlagName": "HIGH RISK FOR SUICIDE",
                "Narrative": [This is a test account.  The actual record 
text wa
s removed Feb 14, 2018.]
                "OriginatingSiteID": "442",
                "OriginatingSiteName": "CHEYENNE VA MEDICAL",
                "OwnerSiteID": "442",
                "OwnerSiteName": "CHEYENNE VA MEDICAL",
                "ReviewDate": "2018-04-25",
                "Type": "CLINICAL"
100%",
            }
        ],
        "FugitiveFelon": "",
        "Gender": "FEMALE",
        "GenderIdentity": "Does not wish to disclose",
        "ICNNumber": "1002001927V385494",
        "Last4SSN": "",
        "MentalHealthProvider": "VSETEST,PROVIDERONE",
        "Name": "CHAPPLE,M",
        ,MORGAN J
                    "PrimaryEligibilityCodeType": "VETERAN"
        "PatientType": "NSC VETERAN",
        "PreferredName": "BATMAN",
        "PrimaryCarePractitioner": "MCGAW,ELLIOTT D",
        "RatedDisabilities": [
            {
                "CurrentEffectiveDate": "",
                "DisabilityPercent": "",
                "ExtremityAffected": "",
                "OriginalEffectiveDate": "",
                "RatedDisability": "",
                },
                "ServiceConnected": ""
            }
        ],
        "SensitivePatientRestrictedRecord": "1",
        "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"
                    "SecondaryEligibilityCode": "ALLIED VETERAN",
            }
        ],
        "Ward": "C MEDICINE"
        }
    ]
 }
                    "SecondaryEligibilityCodeType": "NON-VETERAN"
                },
                {
    "Patient": [
                    "SecondaryEligibilityCode": "HUMANITARIAN EMERGENCY",
                    "SecondaryEligibilityCodeType": "NON-VETERAN"
                },
                {
                    "SecondaryEligibilityCode": "COLLATERAL OF VET.",
                    "SecondaryEligibilityCodeType": "NON-VETERAN"
                },
                {
                    "SecondaryEligibilityCode": "TRICARE",
                    "SecondaryEligibilityCodeType": "NON-VETERAN"
        {
                }
            ],
            "Flag": [
                {
                    "AssignedDate": "2016-11-07T11":53:37-0500,
                    "Category": "I (NATIONAL)",
                    "FlagName": "HIGH RISK FOR SUICIDE",
                    "Narrative": [This is a test account.  The actual 
record tex
t was removed Feb 14, 2018.]
            "DFN": "38281",
                    "OriginatingSiteID": "442",
                    "OriginatingSiteName": "CHEYENNE VA MEDICAL",
                    "OwnerSiteID": "442",
                    "OwnerSiteName": "CHEYENNE VA MEDICAL",
                    "ReviewDate": "2018-04-25",
                    "Type": "CLINICAL"
                }
            ],
            "FugitiveFelon": "",
            "Gender": "FEMALE",
            "DateOfBirth": "1947-11-15",
            "GenderIdentity": "Does not wish to disclose",
            "ICNNumber": "1002001927V385494",
            "MentalHealthProvider": "VSETEST,PROVIDERONE",
            "Name": "CHAPPLE,M",
            ,MORGAN J
            "PatientType": "NSC VETERAN",
            "PreferredName": "BATMAN",
            "PrimaryCarePractitioner": "MCGAW,ELLIOTT D",
            "SensitivePatientRestrictedRecord": "1",
            "ServiceConnected": "YES (50%)",
            "DateOfDeath": "2023-02-23",
            "ServiceConnectedCondition": [
                {
                    "Condition": "STUBBED HIS TOE"
                },
                {
                    "Condition": "TRIPPED ON LAUNDRY"
                },
                {
                    "Condition": "CUT HIMSELF SHAVING"
                },
            "DemographicsNeedUpdate": "1",
                {
                    "Condition": "HIT FUNNYBONE"
                },
                {
                    "Condition": "ATE TOO MUCH MEXICAN FOOD"
                }
            ],
            "Ward": "C MEDICINE"
            }
        "DFN": "38281",
            "DemographicsUpdated": "2018-01-18",
        "DateOfBirth": "1947-11-15",
        "DateOfDeath": "2023-02-23",
        "DemographicsNeedUpdate": "1",
        "DemographicsUpdated": "2018-01-18",
        "Eligibility": [
            {
                "PrimaryEligibilityCode": "SERVICE CONNECTED 50% to 100%",
                "PrimaryEligibilityCodeType": "VETERAN"
            },
            {
            "Eligibility": [
                "SecondaryEligibilityCode": "ALLIED VETERAN",
                "SecondaryEligibilityCodeType": "NON-VETERAN"
            },
            {
                "SecondaryEligibilityCode": "HUMANITARIAN EMERGENCY",
                "SecondaryEligibilityCodeType": "NON-VETERAN"
            },
            {
                "SecondaryEligibilityCode": "COLLATERAL OF VET.",
                "SecondaryEligibilityCodeType": "NON-VETERAN"