DecisionDelay Class - quandis/qbo3-Documentation GitHub Wiki
The Decision module's DecisionDelay table is based on the MISMO data dictionary standard.
| Column | Type | Required | Description |
|---|---|---|---|
| Active | string | ||
| ActiveDelay | string | ||
| ActiveStatus | string | ||
| ActualCompletion | dateTime | ||
| ActualStart | dateTime | ||
| AssignedCollectionID | integer | ||
| AssignedOrganizationID | integer | ||
| AssignedPersonID | integer | ||
| Batch | integer | ||
| CanDelete | string | ||
| CanInsert | string | ||
| CanUpdate | string | ||
| CreatedDate | dateTime | ||
| CreatedPersonID | integer | ||
| DecisionDelay | string | yes | Label for the table. |
| DecisionDelayID | integer | yes | Identity column and primary key for the table. |
| DecisionDelayTemplateID | integer | ||
| DecisionDelayType | string | Enumerated values; set by power user in ObjectType table. | |
| DecisionID | integer | ||
| Duration | integer | ||
| DurationScale | boolean | ||
| EstimatedCompletion | dateTime | ||
| EstimatedStart | dateTime | ||
| Extranet | string | ||
| FinalStatus | string | ||
| Form | string | ||
| ImportFormID | integer | ||
| InDecisionID | string | ||
| InImportFileID | string | ||
| LinkedFrom | string | ||
| LinkedTo | string | ||
| LoanState | string | ||
| NotLinkedFrom | string | ||
| NotLinkedTo | string | ||
| ProcessSibling | string | ||
| ProjectedCompletion | dateTime | ||
| ProjectedStart | dateTime | ||
| ReasonDetail | string | ||
| ReasonType | string | ||
| RemovedDelay | string | ||
| ServicerID | string | ||
| State | string | ||
| Status | string | ||
| Tags | string | ||
| UnreadNotifications | string | ||
| UpdatedDate | dateTime | ||
| UpdatedPersonID | integer | ||
| ViewAsRole | string | ||
| Worklist | string |
| Related Objects | Module | Relationship |
|---|---|---|
| Access | Child | |
| AssignedCollection | qbo.Contact.CollectionObject | Foreign Key |
| AssignedOrganization | qbo.Contact.OrganizationObject | Foreign Key |
| AssignedPerson | qbo.Security.PersonObject | Foreign Key |
| Attachments | Attachment | Child |
| Collections | CollectionMember | Child |
| ConfigurationEntryCollection | ConfigurationEntry | Child |
| Contacts | Contact | Child |
| Decision | qbo.Decision.DecisionObject | Foreign Key |
| DecisionDelayTemplate | qbo.Decision.DecisionDelayTemplateObject | Foreign Key |
| Decisions | Decision | Child |
| Forms | ImportForm | Child |
| ImportForm | qbo.Decision.ImportFormObject | Foreign Key |
| Labels | CollectionMember | Child |
| Ledgers | Ledger | Child |
| Messages | Message | Child |
| Regions | Geography | Child |
| Scores | Score | Child |
| SearchIndexes | SearchIndex | Child |
| 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 theDecisionDelay.Search.xslttemplate. - DisplaySize: determines the maximum number of rows returned. Default is 25.
DisplaySize=0will 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:
DecisionDelay.ashx/Search?DecisionDelay=ABC123 - Response:
<DecisionDelayCollection>
<DecisionDelayItem>
<DecisionDelayID>44</DecisionDelayID>
<DecisionDelay>Account Current</DecisionDelay>
<DecisionID>308</DecisionID>
<DecisionDelayTemplateID>26</DecisionDelayTemplateID>
<DecisionDelayType>
</DecisionDelayType>
<DurationScale>
</DurationScale>
<Duration>
</Duration>
<ReasonType>
</ReasonType>
<ReasonDetail>
</ReasonDetail>
<AssignedOrganizationID>
</AssignedOrganizationID>
<AssignedCollectionID>
</AssignedCollectionID>
<AssignedPersonID>
</AssignedPersonID>
<EstimatedStart>
</EstimatedStart>
<ProjectedStart>
</ProjectedStart>
<ActualStart>2013-04-11T00:00:00-07:00</ActualStart>
<EstimatedCompletion>
</EstimatedCompletion>
<ProjectedCompletion>2013-04-27T00:00:00-07:00</ProjectedCompletion>
<ActualCompletion>2013-10-08T00:00:00-07:00</ActualCompletion>
<ImportFormID>
</ImportFormID>
<Status>
</Status>
<CreatedPersonID>1</CreatedPersonID>
<CreatedDate>2013-04-11T10:42:31.42-07:00</CreatedDate>
<UpdatedPersonID>481</UpdatedPersonID>
<UpdatedDate>2013-10-08T14:26:58.167-07:00</UpdatedDate>
<Decision>Freddie CA Non Judicial Foreclosure</Decision>
<DecisionDelayTemplate>Account Current</DecisionDelayTemplate>
<AssignedOrganization>
</AssignedOrganization>
<AssignedCollection>
</AssignedCollection>
<AssignedPerson>
</AssignedPerson>
<ImportForm>
</ImportForm>
<CreatedPerson>DEPRECATED - Administrator</CreatedPerson>
<UpdatedPerson>[email protected]</UpdatedPerson>
<RecordCount>500</RecordCount>
</DecisionDelayItem>
<DecisionDelayItem>
<DecisionDelayID>58</DecisionDelayID>
<DecisionDelay>Account Current</DecisionDelay>
<DecisionID>317</DecisionID>
<DecisionDelayTemplateID>26</DecisionDelayTemplateID>
<DecisionDelayType>
</DecisionDelayType>
<DurationScale>
</DurationScale>
<Duration>
</Duration>
<ReasonType>
</ReasonType>
<ReasonDetail>
</ReasonDetail>
<AssignedOrganizationID>
</AssignedOrganizationID>
<AssignedCollectionID>
</AssignedCollectionID>
<AssignedPersonID>
</AssignedPersonID>
<EstimatedStart>
</EstimatedStart>
<ProjectedStart>
</ProjectedStart>
<ActualStart>2013-04-16T00:00:00-07:00</ActualStart>
<EstimatedCompletion>
</EstimatedCompletion>
<ProjectedCompletion>2013-04-18T00:00:00-07:00</ProjectedCompletion>
<ActualCompletion>2013-05-29T00:00:00-07:00</ActualCompletion>
<ImportFormID>
</ImportFormID>
<Status>
</Status>
<CreatedPersonID>9</CreatedPersonID>
<CreatedDate>2013-04-16T13:45:35.017-07:00</CreatedDate>
<UpdatedPersonID>481</UpdatedPersonID>
<UpdatedDate>2013-05-30T16:02:52.667-07:00</UpdatedDate>
<Decision>Freddie NY Judicial Foreclosure</Decision>
<DecisionDelayTemplate>Account Current</DecisionDelayTemplate>
<AssignedOrganization>
</AssignedOrganization>
<AssignedCollection>
</AssignedCollection>
<AssignedPerson>
</AssignedPerson>
<ImportForm>
</ImportForm>
<CreatedPerson>[email protected]</CreatedPerson>
<UpdatedPerson>[email protected]</UpdatedPerson>
<RecordCount>500</RecordCount>
</DecisionDelayItem>
</DecisionDelayCollection>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:
DecisionDelay.ashx/ListWhere?DecisionDelayID=1,2,3 - Response:
<DecisionDelayCollection>
<DecisionDelayItem>
<DecisionDelayID>44</DecisionDelayID>
<DecisionDelay>Account Current</DecisionDelay>
</DecisionDelayItem>
<DecisionDelayItem>
<DecisionDelayID>58</DecisionDelayID>
<DecisionDelay>Account Current</DecisionDelay>
</DecisionDelayItem>
</DecisionDelayCollection>