Title Class
The Mortgage module's Title table is based on the MISMO data dictionary standard.
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 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 |
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 theTitle.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>aangle@quandis.com</CreatedPerson>
<UpdatedPerson>aangle@quandis.com</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>aangle@quandis.com</CreatedPerson>
<UpdatedPerson>aangle@quandis.com</UpdatedPerson>
<RecordCount>5</RecordCount>
</TitleItem>
</TitleCollection>
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.
The delete method will delete all records where ID={comma-delimited list of identifiers}
criteria.
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>
Getting Started
- End Users
- Power Users
- Release Notes
Developer Guide
- Installation
- Installation - AWS
- Patterns
- Extensions
- Routes
- MetaData
- Behaviors
- Javascript
- Custom UI
- Module Designer
- Testing
Core API
- Overview
- Accounting
- Contacts
- Documents
- Import
- Messages
- Processes
- Scoring
- Tasks
- Workflow
- Security
- Rules
- Queuing
- Configuration
Mortgage API
- Overview
- Loans
- Properties
- Borrowers
- Auctions
- Bankruptcy
- BidsAtSale
- CashForKeys
- Closings
- Deficiency
- Eviction
- Foreclosure
- Litigation
- Offers
- Public Records
- REOs
- Title
- Valuations
Plugins
Core Modules
- Overview
- Accounting
- Application
- Attachment
- Contact
- Decision
- Import
- Logging
- Message
- Process
- Report
- Score
- Security
Fintech Modules