Mass
Case Query provides a means of retrieving status for large numbers
of cases at once. Up to 500 specific cases or 1000 cases that match
a search criteria can be returned at one time. A paging feature also
permits multi-transaction retrieval of any number of records that
match a search criteria.
- Send
a list of unique case numbers. The lender will then receive
case information for all requested cases.
- Send
an originator ID and a case number assignment date range. The
user will then receive case information for all cases for the
selected originator where the case number was assigned within
the date range.
- Send
an originator ID and an endorsement date range. The user will
then receive case information for all cases for the selected originator
where the endorsement report date is within the date range.
- Send
an originator ID and an NOR date range. The user will then receive
case information for all cases for the selected originator where
the case was NORed within the date range.
- Send
a sponsor ID and a case number assignment date range. The user
will then receive case information for all cases for the selected
sponsor where the case number was assigned within the date range.
- Send
a sponsor ID and an endorsement date range. The user will then
receive case information for all cases for the selected sponsor
where the endorsement report date is within the date range.
- Send
a sponsor ID and an NOR date range. The user will then receive
case information for all cases for the selected sponsor where
the case was NORed within the date range.
To run Mass Case Query against test data post your data to:
https://hwvauwd491.hud.gov/b2b/chums/f17mhfcxml.cfm
To run Mass Case Query against live data post your data to:
https://entp.hud.gov/b2b/chums/f17mhfcxml.cfm
Example
Input Files
A
search for specific case numbers takes this form:
<?xml version='1.0' standalone='yes' ?>
<MULTICASEDATA MISMOVersionID = '1.0'>
<PROCESSSTATUS>
<ProcessStatusRequestor>ATSB2B_DEV</ProcessStatusRequestor>
<InputRangeMagnitude>2</InputRangeMagnitude>
</PROCESSSTATUS>
<CASEDATA CASEDATAID = '1'>
<Application>
<AgencyCaseIdentifier>0611234567</AgencyCaseIdentifier>
</Application>
</CASEDATA>
<CASEDATA CASEDATAID = '2'>
<Application>
<AgencyCaseIdentifier>0617654321</AgencyCaseIdentifier>
</Application>
</CASEDATA>
<Key>
<KeyName>MassCaseQuerySearchType</KeyName>
<KeyValue>caseNumberList</KeyValue>
</Key>
</MULTICASEDATA>
All
other searches take the following form
Note: Both Originator and SponsorIDs are shown, but only
the one specified by the particular search is required.
<?xml version='1.0' standalone='yes'?>
<MULTICASEDATA MISMOVersionID= '1.0'>
<PROCESSSTATUS>
<ProcessStatusRequestor>ATSB2B_DEV</ProcessStatusRequestor>
<ProcessStatusCursorRecordID>0621934756</ProcessStatusCursorRecordID>
</PROCESSSTATUS>
<CASEDATA>
<FHAVA>
<FHAVAOriginatorIdentifier>9988776655</FHAVAOriginatorIdentifier>
<FHAVASponsorIdentifier>2987982734</FHAVASponsorIdentifier>
</FHAVA>
<Key>
<KeyName>MassCaseQuerySearchType</KeyName>
<KeyValue>OriginatorCaseAssignmentRange</KeyValue>
</Key>
<Key>
<KeyName>InitialCaseAssignmentDate</KeyName>
<KeyValue>20011230</KeyValue>
</Key>
<Key>
<KeyName>TerminalCaseAssignmentDate</KeyName>
<KeyValue>20020626</KeyValue>
</Key>
</CASEDATA>
</MULTICASEDATA>
End
of Input Fields for Mass Case Query
| Data
Item |
Valid
Entries |
Description |
<PROCESSSTATUS>
<ProcessStatusCursorRecordID> |
10
numeric characters |
(Optional
entry) Beginning record to select, used to retrieve multiple
sets of records when the search exceeds 1000 records. |
| <CASEDATA
CASEDATAID = 'value'> |
alphanumeric |
(Optional
entry) CASEDATAID values supplied on input will be returned
and matched to the contained AgencyCaseIdentifier values on
output. If these values are blank output records will be sequentially
numbered. |
<APPLICATION>
<AgencyCaseIdentifier> |
10
numeric characters |
(Optional
entry) Number identifying/ referencing the Federal Housing Administration
(FHA) case number. A maximum of 500 of these elements may be
present in a single query. AgencyCaseIdentifiers must be
unique in each query. |
| <Key><KeyName> |
Fixed
text |
(Required entry) One entry is required to specify the search
type. (MassCaseQuerySearchType)
All
searches except caseNumberList also require an initial and
terminal date key pair form the following list: InitialCaseAssignmentDate,
TerminalCaseAssignmentDate
InitialEndorsementDate, TerminalEndorsementDate
InitialNORDate, TerminalNORDate
|
| <Key><KeyValue> |
Fixed
text or Date |
(Required
entry) Values for MassCaseQuerySearchType are
caseNumberList, OriginatorCaseAssignmentRange, OriginatorNORRange,
OriginatorEndorsementRange, SponsorCaseAssignmentRange, SponsorNORRange,
SponsorEndorsementRange
Values for date range keys are dates in the form of yyyymmdd
|
<PROCESSSTATUS>
<ProcessStatusRequestor> |
Up
to 34 alphanumeric characters |
(Required
entry) Name of LOS sending request. |
Information
Returned:
Example
Output File
<?xml version = '1.0' standalone = 'yes'?>
<MULTICASEDATA MISMOVersionID="1.0">
<CASEDATA CASEDATAID="1">
<Application>
<AgencyCaseIdentifier>942447454</AgencyCaseIdentifier>
</Application>
<FHAVA>
<FHAVAOriginatorIdentifier>139600024</FHAVAOriginatorIdentifier>
<FHAVACaseNumberAssignedDate>19900815</FHAVACaseNumberAssignedDate>
<FHAVAAppraisalLoggedDate>19900823</FHAVAAppraisalLoggedDate>
<FHAVAMICReportedDate>19841228</FHAVAMICReportedDate>
<MORTGAGEINSURANCE MortgageInsurancePaid="0.00">
<MortgageInsurancePremiumDue>2903.16</MortgageInsurancePremiumDue>
<MortgageInsuranceReceived>0</MortgageInsuranceReceived>
</MORTGAGEINSURANCE>
</FHAVA>
<SubjectProperty>
<Address1>1129 WHIPSERING WINDS CT</Address1>
<City>APOPKA</City>
<State>FL</State>
<PostalCode>327030000</PostalCode>
</SubjectProperty>
<MORTGAGEINSURANCERESPONSE>
<MortgageInsuranceFHAVAnor FHAVAnorDate="19910703">
<MortgageInsuranceFHAVAnorMessage MortgageInsuranceFHAVAnorMessageID="1">NO UFMIP HAS BEEN CREDITED TO THIS CASE #. STATEMENT OF ACCOUNT IN</MortgageInsuranceFHAVAnorMessage>
<MortgageInsuranceFHAVAnorMessage MortgageInsuranceFHAVAnorMessageID="2">THIS FILE BELONGS TO DIFFERENT CASE #.</MortgageInsuranceFHAVAnorMessage>
</MortgageInsuranceFHAVAnor>
</MORTGAGEINSURANCERESPONSE>
<BORROWER BORROWERID="1">
<UnparsedName>DOE, JANE R</UnparsedName>
</BORROWER>
<PARTY PARTYID="K2MULR" PartyType="Appraiser" />
</CASEDATA>
<PROCESSSTATUS>
<ProcessStatusCode>Success</ProcessStatusCode>
<ProcessStatusMessage>Selected 1 case records. Returning 1</ProcessStatusMessage>
</PROCESSSTATUS>
</MULTICASEDATA>
End
of Output Fields for Mass Case Query
| Data
Item |
Description |
<APPLICATION>
<AgencyCaseIdentifier> |
Unique
identifier of an FHA loan. Up to 10 numeric characters. |
<APPLICATION><FHAVA>
<FHAVAOriginatorIdentifier> |
Originator
ID |
<APPLICATION><FHAVA>
<FHAVACaseNumberAssignedDate> |
date
case number generated |
<APPLICATION><fhava>
<FHAVAAppraisalLoggedDate> |
Date
appraisal logged |
<APPLICATION><FHAVA>
<FHAVAMICReportedDate> |
Date
of MIC (endorsement) |
| <MORTGAGEINSURANCE
MortgageInsurancePaid="0.00"> |
MIP
paid |
<APPLICATION><FHAVA><MORTGAGEINSURANCE>
<MortgageInsurancePremiumDue> |
MIP
due |
<APPLICATION><FHAVA><MORTGAGEINSURANCE>
<MortgageInsurancePremiumReceived> |
MIP
Received |
<SUBJECTPROPERTY>
<Address1> |
Street
Address |
<SUBJECTPROPERTY>
<City> |
Name
of city |
<SUBJECTPROPERTY>
<State> |
2
letter state code |
<SUBJECTPROPERTY>
<PostalCode> |
ZIP
code |
<MORTGAGEINSURANCERESPONSE><MortgageInsuranceFHAVAnor>
<MortgageInsuranceFHAVAnor FHAVAnorDate="19910703"> |
Date
of NOR |
<MORTGAGEINSURANCERESPONSE><MortgageInsuranceFHAVAnor>
<MortgageInsuranceFHAVAnorMessage MortgageInsuranceFHAVAnorMessageID="1"> |
Text
message regarding NOR (up to two) |
<BORROWER
BORROWERID='1'>
<UnparsedName> |
Name
of mortgagor(last,first,MI). Up to 22 characters. |
| <PARTY
PARTYID="K2MULR" PartyType="Appraiser"> |
Identifies
Appraiser by ID |
| <VALUATIONS><LocalAssessmentValue> |
Appraised
value |
<PROCESSSTATUS>
<ProcessStatusCode> |
Result
of the request. See below for values and meanings. |
<PROCESSSTATUS>
<ProcessStatusCursorRecordID> |
Record
id of next sequential record matching current criteria, used
to continue getting results 1000 records at a time. |
<PROCESSSTATUS>
<ProcessStatusMessage> |
Message
detailing errors. Up to 80 alphanumeric characters. |
<PROCESSSTATUS>
<ProcessStatusMessage sCode='1'> |
sCode
is used to uniquely identify each message. |
ProcessStatusCode
Values:
End
of ProcessStatusCode Values
| SuccessNoUpdatesAllowed |
This
indicates that the Mass Case Query request has been successfully
processed. |
| Error |
This
indicates that an error has occurred in processing the Mass
Case Query request. Please see the <ProcessStatusMessage>
for details. |
| Unavailable |
System
is down |
Comments or Questions? <SF
Administration>
|