Title Class - quandis/qbo3-Documentation GitHub Wiki

The Mortgage module's Title table is based on the MISMO data dictionary standard.

Title properties

Column Type Required Description
Active string
ActiveStatus string
ActiveWorkflow string
AgencyCaseIdentifier string
AssignedDate dateTime
AssignedOrganizationID integer
AssignedPersonID integer
AssociationTypeDescription string
AttachmentID integer
BaseLoanAmount double
Batch integer
BecamePastStandard string
BorrowerRequestedLoanAmount double
CanDelete string
CanInsert string
CanUpdate string
ClientID integer
ClientPersonID integer
Closed string
ClosedReason string
ClosingAgentOrderNumberIdentifier string
ClosingDate dateTime
ClosingDocumentReceivedDate dateTime
CommittmentNumber string
CostLedgerID integer
CreatedDate dateTime
CreatedPersonID integer
CurrentDecisionID integer
DateClosed dateTime
DateDue dateTime
DateOpened dateTime
DecisionStep string
DecisionTemplate string
DisbursementDate dateTime
Entity string
EntityParent string
EstimatedCashOutAmount double
ExcludePendingSteps string
Extranet string
FinalStatus string
Form string
GSETitleMannerHeldDescription string
InDecisionID string
InImportFileID string
InsuranceAmount double
InsuredID integer
LegalValidationDate dateTime
LenderCaseIdentifier string
LenderLoanIdentifier string
LienDescription string
LinkedFrom string
LinkedTo string
LitigationDelays string
LoanEstimatedClosingDate dateTime
LoanScheduledClosingDate dateTime
LoanState string
MERSOriginalMortgageeOfRecordIndicator string
MERSRegistrationDate dateTime
MERSRegistrationIndicator string
MERSRegistrationStatusType string
MERSTaxNumberIdentifier string
MetaXml string Deprecated
MISMOVersionID integer
MortgageModificationIndicator string
NonCompliant string
NoteDate dateTime
NotLinkedFrom string
NotLinkedTo string
Object string
ObjectID integer
OfficeID integer
Open string
OpenAsOf string
OpenedReason string
OriginalLoanAmount double
OtherDelays string
OwnershipType string
OwnershipTypeDescription string
PastStandardInflow string
PastStandardOutflow string
PolicyEffectiveDate dateTime
PolicyWitnessClauseDescription string
PotentialLoss double
Priority integer
Process string
ProcessID integer
ProcessSiblingList string
ProcessTemplateID integer
ProcessType string
PropertyID integer
PropertyLeaseholdExpirationDate dateTime
PropertyRightsTypeOtherDescription string
PropertyState string
PropertyUsageTypeOtherDescription string
ReceivedDate dateTime
RefinanceCashOutDeterminationType string
RelationshipTitleTypeOtherDescription string
RequestActionType string
RequestCoverageAmount double
RequestedClosingDate dateTime
RequestProductCategoryType string
RequestProductName string
RequestProductNameDescription string
RequestProductType string
RequestProductTypeDescription string
ReviewedDate dateTime
ServiceActualCompletionDate dateTime
ServiceActualPriceAmount double
ServiceCancellationPriceAmount double
ServiceEstimatedCompletionDate dateTime
ServiceEstimatedOffHoldDate dateTime
ServiceEstimatedPriceAmount double
ServiceRequestedCompletionDueDate dateTime
ServiceRequestedPriceAmount double
ServicerID string
Sibling string
SiblingID integer
SourceXml string Deprecated
State string
Status string
Step string
StepExists string
Tags string
TimeSpan string
Title string yes Label for the table.
TitleClearanceGradeIdentifier string
TitleHeldByID integer
TitleID integer yes Identity column and primary key for the table.
UnreadNotifications string
UpdatedDate dateTime
UpdatedPersonID integer
VendorID integer
VendorOrderIdentifier string
VendorPersonID integer
VendorTransactionIdentifier string
VestingValidationDate dateTime
ViewAsRole string
Worklist string

Related modules

Related Objects Module Relationship
Access Child
AssignedOrganization qbo.Contact.OrganizationObject Foreign Key
AssignedPerson qbo.Security.PersonObject Foreign Key
Attachment qbo.Attachment.AttachmentObject Foreign Key
Attachments Attachment Child
Client qbo.Contact.OrganizationObject Foreign Key
ClientPerson qbo.Security.PersonObject Foreign Key
Collections CollectionMember Child
ConfigurationEntryCollection ConfigurationEntry Child
Contacts Contact Child
CostLedger qbo.Accounting.LedgerObject Foreign Key
CurrentDecision qbo.Decision.DecisionObject Foreign Key
Decisions Decision Child
Delays DecisionDelay Child
Forms ImportForm Child
Insured qbo.Contact.ContactObject Foreign Key
Labels CollectionMember Child
Ledgers Ledger Child
Messages Message Child
Office qbo.Contact.ContactObject Foreign Key
ProcessTemplate qbo.Process.ProcessTemplateObject Foreign Key
Property qbo.Mortgage.PropertyObject Foreign Key
Regions Geography Child
Scores Score Child
SearchIndexes SearchIndex Child
TitleHeldBy qbo.Contact.ContactObject Foreign Key
Vendor qbo.Contact.OrganizationObject Foreign Key
VendorPerson qbo.Security.PersonObject Foreign Key
Worklists SmartWorklistMember Child

Method signatures

Mortgage/Title.ashx/Search?{Parameters}

The search method will return all records matching the {Parameters} criteria. For searches, {Parameters} may include any property listed in the table above. The following standard optional parameters also apply:

  • Output: determines the formatting of the returned data. Valid values are Xml, Json, JsonP. If omitted, XHTML is returns based on the Title.Search.xslt template.
  • DisplaySize: determines the maximum number of rows returned. Default is 25. DisplaySize=0 will return all matching rows.
  • RecordStart: the starting record to return; defaults to 0. Used for pagination.
  • OrderBy: a series of properties to order by.
  • Request: Title.ashx/Search?Title=ABC123
  • Response:
<TitleCollection>
  <TitleItem>
    <TitleID>1</TitleID>
    <Title>12345</Title>
    <PropertyID>1205497</PropertyID>
    <ProcessID>73563</ProcessID>
    <CommittmentNumber>
    </CommittmentNumber>
    <ReceivedDate>
    </ReceivedDate>
    <ReviewedDate>
    </ReviewedDate>
    <SourceXml>
    </SourceXml>
    <MetaXml>
    </MetaXml>
    <InsuredID>
    </InsuredID>
    <RequestedClosingDate>
    </RequestedClosingDate>
    <AssociationTypeDescription>
    </AssociationTypeDescription>
    <OwnershipTypeDescription>
    </OwnershipTypeDescription>
    <RequestCoverageAmount>
    </RequestCoverageAmount>
    <RequestProductNameDescription>
    </RequestProductNameDescription>
    <RequestProductName>
    </RequestProductName>
    <RequestProductTypeDescription>
    </RequestProductTypeDescription>
    <RequestProductType>
    </RequestProductType>
    <RequestProductCategoryType>
    </RequestProductCategoryType>
    <RequestActionType>
    </RequestActionType>
    <OwnershipType>
    </OwnershipType>
    <MISMOVersionID>
    </MISMOVersionID>
    <OfficeID>
    </OfficeID>
    <VendorOrderIdentifier>
    </VendorOrderIdentifier>
    <VendorTransactionIdentifier>
    </VendorTransactionIdentifier>
    <ServiceRequestedPriceAmount>
    </ServiceRequestedPriceAmount>
    <ServiceRequestedCompletionDueDate>
    </ServiceRequestedCompletionDueDate>
    <AgencyCaseIdentifier>
    </AgencyCaseIdentifier>
    <BaseLoanAmount>
    </BaseLoanAmount>
    <BorrowerRequestedLoanAmount>
    </BorrowerRequestedLoanAmount>
    <LenderCaseIdentifier>
    </LenderCaseIdentifier>
    <LoanEstimatedClosingDate>
    </LoanEstimatedClosingDate>
    <GSETitleMannerHeldDescription>
    </GSETitleMannerHeldDescription>
    <InsuranceAmount>
    </InsuranceAmount>
    <PolicyEffectiveDate>
    </PolicyEffectiveDate>
    <PolicyWitnessClauseDescription>
    </PolicyWitnessClauseDescription>
    <VestingValidationDate>
    </VestingValidationDate>
    <AttachmentID>
    </AttachmentID>
    <LegalValidationDate>
    </LegalValidationDate>
    <RelationshipTitleTypeOtherDescription>
    </RelationshipTitleTypeOtherDescription>
    <TitleHeldByID>
    </TitleHeldByID>
    <LienDescription>
    </LienDescription>
    <ClosingAgentOrderNumberIdentifier>
    </ClosingAgentOrderNumberIdentifier>
    <ClosingDocumentReceivedDate>
    </ClosingDocumentReceivedDate>
    <DisbursementDate>
    </DisbursementDate>
    <ClosingDate>
    </ClosingDate>
    <PropertyLeaseholdExpirationDate>
    </PropertyLeaseholdExpirationDate>
    <PropertyRightsTypeOtherDescription>
    </PropertyRightsTypeOtherDescription>
    <PropertyUsageTypeOtherDescription>
    </PropertyUsageTypeOtherDescription>
    <EstimatedCashOutAmount>
    </EstimatedCashOutAmount>
    <RefinanceCashOutDeterminationType>
    </RefinanceCashOutDeterminationType>
    <MortgageModificationIndicator>
    </MortgageModificationIndicator>
    <MERSOriginalMortgageeOfRecordIndicator>
    </MERSOriginalMortgageeOfRecordIndicator>
    <MERSRegistrationDate>
    </MERSRegistrationDate>
    <MERSRegistrationIndicator>
    </MERSRegistrationIndicator>
    <MERSRegistrationStatusType>
    </MERSRegistrationStatusType>
    <MERSTaxNumberIdentifier>
    </MERSTaxNumberIdentifier>
    <LenderLoanIdentifier>
    </LenderLoanIdentifier>
    <OriginalLoanAmount>
    </OriginalLoanAmount>
    <NoteDate>
    </NoteDate>
    <ServiceEstimatedPriceAmount>
    </ServiceEstimatedPriceAmount>
    <ServiceActualPriceAmount>
    </ServiceActualPriceAmount>
    <ServiceEstimatedCompletionDate>
    </ServiceEstimatedCompletionDate>
    <ServiceActualCompletionDate>
    </ServiceActualCompletionDate>
    <ServiceEstimatedOffHoldDate>
    </ServiceEstimatedOffHoldDate>
    <ServiceCancellationPriceAmount>
    </ServiceCancellationPriceAmount>
    <TitleClearanceGradeIdentifier>
    </TitleClearanceGradeIdentifier>
    <LoanScheduledClosingDate>
    </LoanScheduledClosingDate>
    <AssignedDate>
    </AssignedDate>
    <PotentialLoss>
    </PotentialLoss>
    <Process>12345</Process>
    <ProcessTemplateID>
    </ProcessTemplateID>
    <Sibling>Title</Sibling>
    <SiblingID>1</SiblingID>
    <ProcessType>
    </ProcessType>
    <Priority>
    </Priority>
    <AssignedOrganizationID>
    </AssignedOrganizationID>
    <AssignedPersonID>
    </AssignedPersonID>
    <VendorID>
    </VendorID>
    <VendorPersonID>
    </VendorPersonID>
    <DateOpened>2018-04-02T00:00:00-07:00</DateOpened>
    <OpenedReason>
    </OpenedReason>
    <DateClosed>2018-05-01T00:00:00-07:00</DateClosed>
    <ClosedReason>
    </ClosedReason>
    <DateDue>
    </DateDue>
    <CostLedgerID>
    </CostLedgerID>
    <CurrentDecisionID>
    </CurrentDecisionID>
    <ClientID>
    </ClientID>
    <ClientPersonID>
    </ClientPersonID>
    <Object>Property</Object>
    <ObjectID>1205497</ObjectID>
    <Status>
    </Status>
    <CreatedPersonID>2770</CreatedPersonID>
    <CreatedDate>2018-05-15T10:13:21.32-07:00</CreatedDate>
    <UpdatedPersonID>2770</UpdatedPersonID>
    <UpdatedDate>2018-05-15T10:13:21.96-07:00</UpdatedDate>
    <Address>123 Test</Address>
    <City>Test City</City>
    <State>CA</State>
    <PostalCode>92618</PostalCode>
    <Property>123 Test</Property>
    <Insured>
    </Insured>
    <Office>
    </Office>
    <Attachment>
    </Attachment>
    <TitleHeldBy>
    </TitleHeldBy>
    <ProcessTemplate>
    </ProcessTemplate>
    <AssignedOrganization>
    </AssignedOrganization>
    <AssignedPerson>
    </AssignedPerson>
    <Vendor>
    </Vendor>
    <VendorPerson>
    </VendorPerson>
    <CostLedger>
    </CostLedger>
    <CurrentDecision>
    </CurrentDecision>
    <Client>
    </Client>
    <ClientPerson>
    </ClientPerson>
    <CreatedPerson>[email protected]</CreatedPerson>
    <UpdatedPerson>[email protected]</UpdatedPerson>
    <RecordCount>5</RecordCount>
  </TitleItem>
  <TitleItem>
    <TitleID>6</TitleID>
    <Title>SpecTestjig31478</Title>
    <PropertyID>
    </PropertyID>
    <ProcessID>73573</ProcessID>
    <CommittmentNumber>
    </CommittmentNumber>
    <ReceivedDate>
    </ReceivedDate>
    <ReviewedDate>
    </ReviewedDate>
    <SourceXml>
    </SourceXml>
    <MetaXml>
    </MetaXml>
    <InsuredID>
    </InsuredID>
    <RequestedClosingDate>
    </RequestedClosingDate>
    <AssociationTypeDescription>
    </AssociationTypeDescription>
    <OwnershipTypeDescription>
    </OwnershipTypeDescription>
    <RequestCoverageAmount>
    </RequestCoverageAmount>
    <RequestProductNameDescription>
    </RequestProductNameDescription>
    <RequestProductName>
    </RequestProductName>
    <RequestProductTypeDescription>
    </RequestProductTypeDescription>
    <RequestProductType>
    </RequestProductType>
    <RequestProductCategoryType>
    </RequestProductCategoryType>
    <RequestActionType>
    </RequestActionType>
    <OwnershipType>
    </OwnershipType>
    <MISMOVersionID>
    </MISMOVersionID>
    <OfficeID>
    </OfficeID>
    <VendorOrderIdentifier>
    </VendorOrderIdentifier>
    <VendorTransactionIdentifier>
    </VendorTransactionIdentifier>
    <ServiceRequestedPriceAmount>
    </ServiceRequestedPriceAmount>
    <ServiceRequestedCompletionDueDate>
    </ServiceRequestedCompletionDueDate>
    <AgencyCaseIdentifier>
    </AgencyCaseIdentifier>
    <BaseLoanAmount>
    </BaseLoanAmount>
    <BorrowerRequestedLoanAmount>
    </BorrowerRequestedLoanAmount>
    <LenderCaseIdentifier>
    </LenderCaseIdentifier>
    <LoanEstimatedClosingDate>
    </LoanEstimatedClosingDate>
    <GSETitleMannerHeldDescription>
    </GSETitleMannerHeldDescription>
    <InsuranceAmount>
    </InsuranceAmount>
    <PolicyEffectiveDate>
    </PolicyEffectiveDate>
    <PolicyWitnessClauseDescription>
    </PolicyWitnessClauseDescription>
    <VestingValidationDate>
    </VestingValidationDate>
    <AttachmentID>
    </AttachmentID>
    <LegalValidationDate>
    </LegalValidationDate>
    <RelationshipTitleTypeOtherDescription>
    </RelationshipTitleTypeOtherDescription>
    <TitleHeldByID>
    </TitleHeldByID>
    <LienDescription>
    </LienDescription>
    <ClosingAgentOrderNumberIdentifier>
    </ClosingAgentOrderNumberIdentifier>
    <ClosingDocumentReceivedDate>
    </ClosingDocumentReceivedDate>
    <DisbursementDate>
    </DisbursementDate>
    <ClosingDate>
    </ClosingDate>
    <PropertyLeaseholdExpirationDate>
    </PropertyLeaseholdExpirationDate>
    <PropertyRightsTypeOtherDescription>
    </PropertyRightsTypeOtherDescription>
    <PropertyUsageTypeOtherDescription>
    </PropertyUsageTypeOtherDescription>
    <EstimatedCashOutAmount>
    </EstimatedCashOutAmount>
    <RefinanceCashOutDeterminationType>
    </RefinanceCashOutDeterminationType>
    <MortgageModificationIndicator>
    </MortgageModificationIndicator>
    <MERSOriginalMortgageeOfRecordIndicator>
    </MERSOriginalMortgageeOfRecordIndicator>
    <MERSRegistrationDate>
    </MERSRegistrationDate>
    <MERSRegistrationIndicator>
    </MERSRegistrationIndicator>
    <MERSRegistrationStatusType>
    </MERSRegistrationStatusType>
    <MERSTaxNumberIdentifier>
    </MERSTaxNumberIdentifier>
    <LenderLoanIdentifier>
    </LenderLoanIdentifier>
    <OriginalLoanAmount>
    </OriginalLoanAmount>
    <NoteDate>
    </NoteDate>
    <ServiceEstimatedPriceAmount>
    </ServiceEstimatedPriceAmount>
    <ServiceActualPriceAmount>
    </ServiceActualPriceAmount>
    <ServiceEstimatedCompletionDate>
    </ServiceEstimatedCompletionDate>
    <ServiceActualCompletionDate>
    </ServiceActualCompletionDate>
    <ServiceEstimatedOffHoldDate>
    </ServiceEstimatedOffHoldDate>
    <ServiceCancellationPriceAmount>
    </ServiceCancellationPriceAmount>
    <TitleClearanceGradeIdentifier>
    </TitleClearanceGradeIdentifier>
    <LoanScheduledClosingDate>
    </LoanScheduledClosingDate>
    <AssignedDate>
    </AssignedDate>
    <PotentialLoss>
    </PotentialLoss>
    <Process>SpecTestjig31478</Process>
    <ProcessTemplateID>141</ProcessTemplateID>
    <Sibling>Title</Sibling>
    <SiblingID>6</SiblingID>
    <ProcessType>
    </ProcessType>
    <Priority>
    </Priority>
    <AssignedOrganizationID>12268</AssignedOrganizationID>
    <AssignedPersonID>
    </AssignedPersonID>
    <VendorID>
    </VendorID>
    <VendorPersonID>
    </VendorPersonID>
    <DateOpened>
    </DateOpened>
    <OpenedReason>
    </OpenedReason>
    <DateClosed>2018-06-15T00:00:00-07:00</DateClosed>
    <ClosedReason>SpecTestjig3147a</ClosedReason>
    <DateDue>
    </DateDue>
    <CostLedgerID>
    </CostLedgerID>
    <CurrentDecisionID>
    </CurrentDecisionID>
    <ClientID>
    </ClientID>
    <ClientPersonID>
    </ClientPersonID>
    <Object>Property</Object>
    <ObjectID>
    </ObjectID>
    <Status>
    </Status>
    <CreatedPersonID>2770</CreatedPersonID>
    <CreatedDate>2018-06-15T07:42:43.473-07:00</CreatedDate>
    <UpdatedPersonID>2770</UpdatedPersonID>
    <UpdatedDate>2018-06-15T07:42:44.597-07:00</UpdatedDate>
    <Address>
                  </Address>
    <City>
    </City>
    <State>
    </State>
    <PostalCode>
    </PostalCode>
    <Property>
    </Property>
    <Insured>
    </Insured>
    <Office>
    </Office>
    <Attachment>
    </Attachment>
    <TitleHeldBy>
    </TitleHeldBy>
    <ProcessTemplate>Title</ProcessTemplate>
    <AssignedOrganization>SpecTestjig31474</AssignedOrganization>
    <AssignedPerson>
    </AssignedPerson>
    <Vendor>
    </Vendor>
    <VendorPerson>
    </VendorPerson>
    <CostLedger>
    </CostLedger>
    <CurrentDecision>
    </CurrentDecision>
    <Client>
    </Client>
    <ClientPerson>
    </ClientPerson>
    <CreatedPerson>[email protected]</CreatedPerson>
    <UpdatedPerson>[email protected]</UpdatedPerson>
    <RecordCount>5</RecordCount>
  </TitleItem>
</TitleCollection>

Mortgage/Title.ashx/Save?{Parameters}

The save method will return all records matching the {Parameters} criteria. {Parameters} may include any property listed in the table above along with child classes.

  • Output: determines the formatting of the returned data. Valid values are Xml, Json, JsonP.
  • Response: included in the response is {Table}ID; this is the primary key of the {Table} row created
  • With the same Save method, you can also save data to related tables. By using a {Parent}_{Column} pattern, you can update the parent table's data in the same call.
  • Child records may also be updated using a {Child}_{Index}_{Column} pattern.
  • For child records that are templated, you may use the template name in lieu of an index.

Mortgage/Title.ashx/Delete?ID={Where.IdList}

The delete method will delete all records where ID={comma-delimited list of identifiers} criteria.

Mortgage/Title.ashx/ListWhere?{Parameters}

The ListWhere method will return all records matching the {Parameters} criteria. {Parameters} may include any property listed in the table.

  • Output: determines the formatting of the returned data. Valid values are Xml, Json, JsonP.
  • Response: 2 columns are returned - {Table}ID and {Table} columns.
  • Request: Title.ashx/ListWhere?TitleID=1,2,3
  • Response:
<TitleCollection>
  <TitleItem>
    <TitleID>1</TitleID>
    <Title>12345</Title>
  </TitleItem>
  <TitleItem>
    <TitleID>2</TitleID>
    <Title>Title Test</Title>
  </TitleItem>
</TitleCollection>
⚠️ **GitHub.com Fallback** ⚠️