FSO table definitions
The Financial Services Operations (FSO) product provides multiple tables that you can leverage within your custom FSO applications. This section identifies the most frequently used of these tables and defines the fields contained within them.
- Consumer [csm_consumer] table
- Credit Card [sn_bom_credit_card] table
- Credit Card Service [sn_bom_credit_card_service] table
- Inbound Document [sn_bom_document_inbound_document] table
- Loan Service Case [sn_bom_loan_service] table
- Mortgage [sn_bom_mortgage] table
- Payment Inquiry Case [sn_bom_payment_inquiry] table
- Personal Checking Account [sn_bom_checking_account] table
- Personal Loan [sn_bom_personal_loan] table
Consumer [csm_consumer] table
| Parameter | Description |
|---|---|
| active | Flag that indicates whether the consumer is active.Possible values: - true: Consumer active - false: Consumer de-activated Data type: Boolean Default: true |
| business\_phone | Business phone number of the consumer.Data type: String Maximum length: 40 |
| city | City in which the consumer resides.Data type: String Maximum length: 100 |
| country | Country in which the consumer resides.Data type: String Maximum length: 40 |
| date\_format | Format in which to display dates.Valid values: - dd-mm-yyyy - dd/mm/yyyy - dd.mm.yyyy - mm-dd-yyyy - yyyy-mm-dd Data type: String Maximum length: 40 Default: blank \(system date format\) |
| Email address of the consumer.Data type: String Maximum length: 100 | |
| fax | Fax number of the consumer.Data type: String Maximum length: 40 |
| first\_name | Consumer first name.Data type: String Maximum length: 50 |
| gender | Gender of the consumer.Data type: String Maximum length: 40 |
| home\_phone | Home phone number of the consumer.Data type: String Maximum length: 40 |
| household | Sys\_id of the record that describes the household characteristics.Data type: String Table: Household \[csm\_household\] |
| last\_name | Consumer last name.Data type: String Maximum length: 50 |
| middle\_name | Consumer middle name.Data type: String Maximum length: 50 |
| mobile\_phone | Consumer mobile phone number.Data type: String Maximum length: 40 |
| name | Consumer full name; first\_name+middle\_name+last\_name.Data type: String Maximum length: 152 |
| notes | Notes on consumer.Data type: String Maximum length: 4,000 |
| notification | Indicates whether the consumer should receive notifications.Valid values: - 1: Disabled - 2: Enabled Data type: Number \(Integer\) Maximum length: 40 Default: 2 |
| number | Unique number associated with the consumer.Data type: String Maximum length: 40 |
| photo | Photo of the consumer.Data type: Image |
| preferred\_language | Consumer primary language.Data type: String Maximum length: 3 |
| prefix | Consumer name prefix such as, Dr., Mr., Mrs., or Ms.Data type: String Maximum length: 40 |
| primary | Flag that indicates whether this is the primary consumer.Possible values: - true: Primary consumer - false: Not primary consumer Data type: Boolean Default: false |
| state | State in which the consumer resides.Data type: String Maximum length: 100 |
| street | Consumer street address.Data type: String Maximum length: 255 |
| suffix | Consumer name suffix such as Jr., Sr., or II.Data type: String |
| sys\_created\_by | User that created the consumer record.Data type: String Maximum length: 40 |
| sys\_created\_on | Date and time the consumer record was originally created.Data type: String |
| sys\_domain | ServiceNow domain in which the consumer information resides.Data type: String |
| sys\_id | Unique identifier for the consumer.Data type: String |
| sys\_mod\_count | Number of times that the associated consumer information has been modified.Data type: Number \(Integer\) |
| sys\_updated\_by | User that last updated the consumer information.Data type: String Maximum length: 40 |
| sys\_updated\_on | Date and time when the consumer information was last updated.Data type: String |
| time\_format | Format in which to display time.Valid values: - hh.mm.ss a: hh.mm.ss \(12 hour\) - hh:mm:ss a: hh:mm:ss \(12 hour\) - HH.mm.ss: hh.mm.ss \(24 hour\) - HH:mm:ss: hh:mm:ss \(24 hour\) Data type: String Maximum length: 40 Default: blank \(system time format\) |
| time\_zone | Consumer time zone, such as Canada/Central or US/Eastern.Data type: String Maximum length: 40 |
| title | Consumer business title such as Manager, Software Developer, or Contractor.Data type: String Maximum length: 60 |
| user | Sys\_id of the consumer user. Data type: String Table: Consumer User \[csm\_consumer\_user\] |
| zip | Consumer zip code. Data type: String Maximum length: 40 |
Credit Card [sn_bom_credit_card] table
| Parameter | Description |
|---|---|
| account | Sys\_id of the account record associated with the case. Located in the Account \[customer\_account\] table. Data type: String |
| account\_number | Customer's account number. By default, this is the display value for the record.Data type: String Maximum length: 40 |
| accrued\_interest | Amount of accrued interest on the credit card as of the date it is being viewed.Data type: Number \(Currency\) Maximum length: 20 |
| active | Flag that indicates whether the account is active.Possible values: - true: Account is currently active. - false: Account is inactive. Data type: Boolean Default: true |
| address | Customer address.Data type: String Maximum length: 4,000 |
| application\_id | Unique identifier of the application submitted when applying for the credit card.Data type: String Maximum length: 255 |
| apr\_card | Annual percentage rate for the credit card transactions.Data type: Number \(Integer\) Maximum length: 40 |
| apr\_cash | Annual percentage rate for cash advances.Data type: Number \(Integer\) Maximum length: 40 |
| balance | Total amount charged on the credit card.Data type: Number \(Currency\) Maximum length: 20 |
| base\_currency | Sys\_id of the base currency used by the credit card. Located in the Currency \[fx\_currency\] table.Data type: String \(Reference\) |
| billing\_cycle | Billing cycle for which statements should be generated, such as 30-days, 60-days, and so on.Data type: String Maximum length: 255 |
| bill\_due\_date | Date on which the next payment is due.Data type: String \(Date\) Maximum length: 40 |
| cash\_advance\_limit | Maximum cash advance amount for the credit card.Data type: Number \(Currency\) Maximum length: 20 |
| closure\_date | Date that the credit card account was closed.Data type: String \(Date\) Maximum length: 40 |
| consumer | Sys\_id of the associated consumer record. Located in the Consumer \[csm\_consumer\] table.Data type: String \(Reference\) |
| credit\_facility\_id | Unique identifier of the credit facility that is responsible for this credit card account.Data type: String Maximum length: 255 |
| customer\_class | Free-form classification of customers, such as Premier, Standard, or VIP.Data type: String Maximum length: 40 |
| document\_id | Unique identifier of the documents associated with this credit card account in an external document management system.Data type: String Maximum length: 255 |
| embossed\_name\_primary\_applicant | Name of the primary applicant that is embossed on the credit card.Data type: String Maximum length: 255 |
| embossed\_name\_secondary\_applicant | Name of the secondary applicant that is embossed on the credit card.Data type: String Maximum length: 255 |
| end\_date | Date on which the credit card account will end.Data type: String \(Date\) Maximum length: 40 |
| expire\_date | Date on which the associated credit card expires.Data type: String \(Date\) Maximum length: 40 |
| external\_id | Unique identifier used to cross-reference this credit card account to a record in an external system, such as a credit card insurance ID.Data type: String Maximum length: 255 |
| grace\_period | Number of days that a customer has after the bill_due_date to send in a payment without penalties.Data type: Number (Integer) Maximum length: 40 |
| issue\_date | Date on which the credit card was issued.Data type: String \(Date\) Maximum length: 40 |
| is\_lending\_insured | Flag that indicates whether the account is insured.Possible values: - true: Account is insured. - false: Account is not insured. Data type: Boolean |
| max\_credit\_limit | Maximum amount that the customer is allowed to charge.Data type: Number \(Currency\) Maximum length: 20 |
| name | Full name of the primary holder of the credit card account.Data type: String Maximum length: 255 |
| number | Case number.Data type: String Maximum length: 40 |
| open\_date | Date when the credit card account was first opened.Data type: String \(Date\) Maximum length: 40 |
| parent\_sold\_product | Sys\_id of the parent product associated with this entity. Located in the Sold Product \[sn\_install\_base\_sold\_product\] table.Data type: String \(Reference\) |
| product | Sys\_id of the of the credit card account fumber for the customer. Located in the Product Model \[cmdb\_model\] table.Data type: String \(Reference\) |
| requested\_credit\_limit | Credit limit requested by the customer.Data type: Number \(Currency\) Maximum length: 20 |
| request\_channel | Type of communications channel \(digital or banker assisted\) the customer used to make the credit limit request.Data type: String Maximum length: 40 |
| risk\_rating | Risk associated with the credit card account.Data type: Number \(Integer\) Maximum length: 40 |
| secondary\_consumer | Sys\_id of the secondary customer's account. Located in the Consumer \[csm\_consumer\] table.Data type: String |
| sourced\_channel | Source of the customer's business, such as broker or customer referral.Data type: String Maximum length: 40 |
| start\_date | Date on which the of the credit card.Data type: String \(Date\) Maximum length: 40 |
| statement\_frequency | Frequency of statements sent to the customer, such as monthly, quarterly, bi-annually, or annually.Data type: String Maximum length: 40 |
| statement\_generation\_date | Date on which the latest statement was generated.Data type: String \(Date\) Maximum length: 40 |
| statement\_generation\_day | Day of the month on which to generate the statement, such as 10 for the 10th of the month.Data type: String Maximum length: 40 |
| statement\_mode | Method in which the statement is delivered to the customer, such as physical or online.Data type: String Maximum length: 40 |
| status | Current status of the account, such as issued, active, blocked, closed, cancelled, and so on.Data type: String Maximum length: 40 |
| sys\_class\_name | Table that contains the case record.Data type: String Maximum length: 80 |
| sys\_created\_by | Person that initially opened the case.Data type: String Maximum length: 40 |
| sys\_created\_on | Date and time when the case was initially created.Data type: String \(Date\) Maximum length: 40 |
| sys\_domain | Domain associated with the case.Data type: String Maximum length: 32 Default: global |
| sys\_id | Unique identifier of the credit card record.Data type: String |
| sys\_mod\_count | Number of updates to the case since it was initially created.Data type: Number \(Integer\) Maximum length: 40 |
| sys\_updated\_by | Person that last updated the case.Data type: String Maximum length: 40 |
| sys\_updated\_on | Date and time when the case was last updated.Data type: String \(Date\) Maximum length: 40 |
Credit Card Service [sn_bom_credit_card_service]
| Element | Description |
|---|---|
| account | Sys\_id of the account record associated with the case. Data type: String Table: Account \[customer\_account\] |
| active | Flag that indicates whether the case is open and active.Possible values: - true: Case is active - false: Case is closed Data type: Boolean Default: true |
| active\_account\_escalation | Sys\_id of the active account escalation record associated with the case.Data type: String Table: Escalation \[sn\_customerservice\_escalation\] |
| active\_escalation | Sys\_id of the active escalation record associated with the case.Data type: String Table: Escalation \[sn\_customerservice\_escalation\] |
| activity\_due | Date for which the associated case is expected to be completed.Data type: String \(Date\) Maximum length: 40 |
| additional\_assignee\_list | List of the sys\_ids of the additional persons \(other than primary assignee\) that have been assigned to the account.Data type: Array Maximum length: 4,000 Table: User \[sys\_user\] |
| approval | String that describes the type of approval required.Possible values: - approved - cancelled - duplicate - not requested - not required - rejected - requested Data type: String Maximum length: 40 Default: not requested |
| approval\_history | List of all approvals associated with the case.Data type: String \(Journal\) Maximum length: 4,000 |
| approval\_set | Date and time that the associated action was approved.Data type: String \(Date\) Maximum length: 40 |
| asset | Sys\_id of the asset record associated with the case.Data type: String Table: Asset \[alm\_asset\] |
| assigned\_on | Date and time that the case was assigned to the person identified in the assigned_to parameter.Data type: String (Date) Maximum length: 40 |
| assigned\_to | Sys\_id of the person assigned to the case. Table: User \[sys\_user\] Data type: String |
| assignment\_group | Sys\_id of the customer service agent group assigned to the case. Located in the Group \[sys\_user\_group\] table.Data type: String |
| auto\_close | Flag that indicates whether the case was automatically closed.Possible values: - true: Case was auto closed - false: Case wasn't auto closed Data type: Boolean Default: false |
| business\_duration | Length in calendar work hours, work days, and work weeks that it took to complete the case.Data type: String \(Duration\) Maximum length: 40 |
| business\_service | Sys\_id of the service record associated with the case.Data type: String Table: Service \[cmdb\_ci\_service\] |
| calendar\_duration | Length in calendar hours, days, and weeks that it took to complete the case.Data type: String \(Duration\) Maximum length: 40 |
| case | Case short description and case number.Data type: String Maximum length: 300 |
| case\_report | Sys\_id of the associated case report.Data type: String Table: Case Report \[sn\_customerservice\_case\_report\] |
| category | Case category.Possible values: - 0: Question - 1: Issue - 2: Feature Data type: Number \(Integer\) Maximum length: 40 Default: 1 |
| cause | Details about the cause of the problem.Data type: String Maximum length: 4,000 |
| caused\_by | Sys\_id of the change request that caused the case to be created.Data type: String Table: Change Request \[change\_request\] |
| change | Sys\_id of the change request that caused the case to be created.Data type: String Table: Change Request \[change\_request\] |
| closed\_at | Date and time that the case was closed.Data type: String Maximum length: 40 |
| closed\_by | Sys\_id of the user that closed the case. Located in the User \[sys\_user\] table.Data type: String |
| close\_notes | Notes made when the case was closed.Data type: String Maximum length: 4,000 |
| cmdb\_ci | Sys\_id of the configuration item associated with the case.Data type: String Table: Configuration Item \[cmdb\_ci\] |
| comments | Additional comments about the case.Data type: String \(Journal Input\) Maximum length: 4,000 |
| comments\_and\_work\_notes | Comments and work notes entered for the case.Data type: String \(Journal List\) Maximum length: 4,000 |
| company | Sys\_id of the company associated with the case.Data type: String Table: Company \[core\_company\] |
| consumer | Business-to-consumer cases only. Sys\_id of the person to contact with regards to this case. Located in the Consumer \[csm\_consumer\] table.Data type: String |
| contact | Business-to-business based cases only. Sys\_id of the person to contact regarding this case.Data type: String Table: Contact \[customer\_contact\] |
| contact\_local\_time | Contact local time.Data type: String Maximum length: 70 |
| contact\_time\_zone | Time zone of the contact associated with the case.Data type: String Maximum length: 40 |
| contact\_type | Method in which the case was initially reported.Possible values: - chat - email - phone - social - web Data type: String Maximum length: 40 |
| contract | Sys\_id of the contract associated with the case.Data type: String Table: Contract \[ast\_contract\] |
| correlation\_display | Display value for the correlation ID.Data type: String Maximum length: 100 |
| correlation\_id | Correlation identifier.Data type: String Maximum length: 100 |
| delivery\_plan | Sys\_id of the parent execution plan for this case. Located in the Execution Plan \[sc\_cat\_item\_delivery\_plan\] table.Data type: String |
| delivery\_task | Sys\_id of the execution plan task. Data type: String Table: Execution Plan Task \[sc\_cat\_item\_delivery\_task\] |
| description | Detailed description of the problem associated with the case. Data type: String Maximum length: 4,000 |
| due\_date | Date that the case is due to be closed.Data type: String \(Date\) Maximum length: 40 |
| duration | Duration of the credit card account. Returned as a numeric value.Data type: String Maximum length: 40 |
| end\_date | Date when the credit card account ends.Data type: String \(Date\) Maximum length: 40 |
| entitlement | Sys\_id of the entitlement record associated with the case. Entitlements define the type of support that a customer receives as well as the supported communication channels. An entitlement can be associated with a product, an asset, an account, or a contract.Data type: String Table: Entitlement \[service\_entitlement\] |
| escalation | Current escalation level.Possible values: - 0: Normal - 1: Moderate - 2: High - 3: Overdue Data type: Number \(Integer\) Maximum length: 40 Default: 0 |
| expected\_start | Date and time when work is scheduled to begin on the case.Data type: String \(Date\) Maximum length: 40 |
| first\_response\_time | Date and time when the first action was taken on the case.Data type: String |
| follow\_the\_sun | Flag that indicates whether the case should be handed-off for global follow-up.If a customer enters additional comments on a Priority 1 - Critical or a Priority 2 - High case, or if the case is escalated, the flag is automatically set to true. Possible values: - true: Case should be handed-off for global follow-up - false: Case shouldn't be handed-off for global follow-up Data type: Boolean Default: false |
| follow\_up | Date and time of the next follow up action.Data type: String \(Date\) Maximum length: 40 |
| group\_list | List of sys\_ids of the group records associated with the case.Data type: Array \(List\) Maximum length: 4,000 Table: Group \[sys\_user\_group\] |
| impact | Impact on customer.Possible values: - 1: High - 2: Medium - 3: Low Data type: Number \(Integer\) Maximum length: 40 Default: 3 |
| initiated\_as\_request | Flag that indicates if this inquiry was initiated as a request by the customer.Possible values: - true: Inquiry initiated by customer. - false: Inquiry wasn't initiated by customer. Data type: Boolean Default: false |
| knowledge | Flag that indicates if there is a knowledge base article available for the specified issue.Possible values: - true: Knowledge base article is available for this issue - false: Knowledge base article isn't available for this issue Data type: Boolean Default: false |
| location | Sys\_id of the record describing the company location.Data type: String Table: Location \[cmn\_location\] |
| made\_sla | Flag that indicates whether the case was resolved in alignment with the associated service level agreement.Possible values: - true: Case was resolved in alignment with the SLA. - false: Case was not resolved according to the SLA. Data type: Boolean Default: true |
| notes\_to\_comments | Flag that indicates whether to add the resolution notes to the comments.Possible values: - true: Resolutions notes, when added, are also added to the comments - false: Resolution notes in comments aren't required Data type: Boolean |
| notify | Method to use to notify contact/consumer.Possible values: - 1: Do not notify - 2: Send email - 3: Telephone Data type: Number \(Integer\) Default: 1 |
| number | Case number.Data type: String Maximum length: 40 |
| opened\_at | Date and time that the case was opened.Data type: String \(Date\) Maximum length: 40 |
| opened\_by | Sys\_id of the person that initially opened the case.Data type: String Table: User \[sys\_user\] |
| order | Defines some ordering/sequencing, whose usage depends upon the specific use cases.Data type: Number \(Integer\) Maximum length: 40 |
| parent | Sys\_id of the parent case to which this case \(child\) is associated. Located in the Task \[task\] table.Data type: String |
| partner | Sys\_id of the partner associated with the case.Data type: String Table: Account \[customer\_account\] |
| partner\_contact | Sys\_id of the partner contact associated with the case.Data type: String Table: Contact \[customer\_contact\] |
| priority | Priority of the case. Possible values: - 1: Critical - 2: High - 3: Moderate - 4: Low Data type: Number \(Integer\) Maximum length: 40 Default: 4 |
| proactive | Flag that indicates whether the inquiry is being proactively monitored.Possible values: - true: Being proactively monitored. - false: Not being monitored. Data type: Boolean Default:false |
| problem | Sys\_id of the issue that the customer is encountering.Data type: String Table: Problem \[problem\] |
| product | Sys\_id of the product model of the asset associated to the case. Located in the Product Model \[cmdb\_model\] table. A model is a specific version or configuration of an asset \(for example, Apple Mac Book Pro\).Data type: String |
| reassignment\_count | Number of times that the case was reassigned to a person that is responsible for moving the case forward.Data type: Number \(Integer\) Maximum length: 40 Default: 0 |
| rejection\_goto | Sys\_id of the task to execute if the case is rejected.Data type: String Table: Task \[task\] |
| req\_limit\_amount | Credit limit requested by the customer.Data type: Number \(Currency\) Maximum length: 20 |
| resolution\_code | Resolution state for the case, such as "Solved - Fixed by Support/Guidance provided". Data type: String Maximum length: 40 |
| resolved\_at | Date and time that the case was resolved.Data type: String |
| resolved\_by | Sys\_id of the person that resolved the case.Data type: String Table: User \[sys\_user\] |
| route\_reason | Reason that the case was routed to a different assignee.Data type: Number \(Integer\) Maximum length: 40 |
| service\_definition | Sys\_id of the definition of service associated with this account. Located in the Service Definition \[sn\_bom\_service\_definition\] table.Data type: String |
| service\_offering | Sys\_id of the service offering associated with the payment inquiry. Service offerings uniquely define the level of service in terms of availability, scope, pricing, and packaging options.Data type: String Table: Service Offering \[service\_offering\] |
| short\_description | Concise description of the case. Data type: String Maximum length: 160 |
| skills | Sys\_ids of the skills needed to complete the case.Data type: String Maximum length: 4,000 Table: Skill \[cmn\_skill\] |
| sla\_due | Date/time at which the case must be closed based on the associated service level agreement.Data type: String Maximum length: 40 |
| sn\_app\_cs\_social\_social\_profile | Sys\_id of the social media profile associated with the case.Data type: String Table: Social Profile \[sn\_app\_cs\_social\_social\_profile\] |
| sold\_product | Sys\_id of the credit card account of the customer. Located in the Sold Product \[sn\_install\_base\_sold\_product\] table.Data type: String |
| stage | Stage of the case, such as Closed Complete, Closed Rejected, Document Check, Authorization, and so on.Data type: String Maximum length: 40 |
| start\_date | Start date of the credit card.Data type: String \(Date\) Maximum length: 40 |
| state | Current state of the case. Possible values: - 1: New - 2: Open - 3: Awaiting Info - 4: Resolved - 5: Closed Data type: Number \(Integer\) Maximum length: 40 Default: 1 |
| subcategory | Case subcategory.Possible values: 0: QuestionData type: Number \(Integer\) Default: 0 |
| support\_manager | Sys\_id of the CSM manager assigned to the case.Data type: String Table: User \[sys\_user\] |
| sync\_driver | Flag that indicates whether there's driver synchronization.Possible values: - true: Driver is synchronized - false: Driver isn't synchronized Data type: Boolean |
| sys\_class\_name | Table that contains the case record.Data type: String Maximum length: 80 |
| sys\_created\_by | Person that initially opened the case.Data type: String Maximum length: 40 |
| sys\_created\_on | Date and time when the case was initially created.Data type: String \(Date\) Maximum length: 40 |
| sys\_domain | Domain associated with the case.Data type: String Maximum length: 32 Default: global |
| sys\_domain\_path | Domain path.Data type: String Maximum length: 255 Default: / |
| sys\_id | Unique identifier for the case.Data type: String Maximum length: 32 |
| sys\_mod\_count | Number of updates to the case since it was initially created.Data type: Number \(Integer\) Maximum length: 40 |
| sys\_updated\_by | Person that last updated the case.Data type: String Maximum length: 40 |
| sys\_updated\_on | Date and time when the case was last updated.Data type: String \(Date\) Maximum length: 40 |
| task\_effective\_number | Identifying number. If the task has a Universal Request associated with it, it's the UR number. Otherwise, it's the current task number. Data type: String Maximum length: 40 |
| time\_worked | Total amount of time worked on the case.Data type: String \(Timer\) Maximum length: 40 |
| universal\_request | Sys\_id of a universal task that this inquiry is part of.Data type: String Table: Task \[task\] |
| upon\_approval | Action to take if the case is approved.Possible values: - do\_nothing - proceed Data type: String Maximum length: 40 Default: proceed |
| upon\_reject | Action to take if the case is rejected.Possible values: - cancel - goto Data type: String Maximum length: 40 Default: cancel |
| urgency | Urgency of the case.Possible values: - 1: High - 2: Medium - 3: Low Data type: Number \(Integer\) Maximum length: 40 Default: 3 |
| user\_input | Additional user input.Data type: String \(User Input\) Maximum length: 4,000 |
| variables | Name-value pairs of variables associated with the case.Data type: String \(Variables\) Maximum length: 40 |
| watch\_list | List of sys\_ids of the users who receive notifications about this case when additional comments are added or if the state of a case is changed to Resolved or Closed. Located in the User \[sys\_user\] table. Data type: Array \(List\) Maximum length: 4,000 |
| wf\_activity | Sys\_id of the workflow activity record associated with the case.Data type: String Table: Workflow Activity \[wf\_activity\] |
| work\_end | Date and time work ended on the case.Data type: String \(Date\) Maximum length: 40 |
| work\_notes | Information about how to resolve the case, or steps taken to resolve it.Data type: String \(Journal Input\) Maximum length: 4,000 |
| work\_notes\_list | List of sys\_ids of the internal users who receive notifications about this case when work notes are added. Located in the User \[sys\_user\] table. Data type: Array \(List\) Maximum length: 4,000 |
| work\_start | Date and time that work started on the case.Data type: String \(Date\) Maximum length: 40 |
Inbound Document [sn_bom_document_inbound_document]
| Element | Description |
|---|---|
| account | Sys\_id of the account record associated with the document. Located in the Account \[customer\_account\] table. Data type: String |
| active | Flag that indicates whether the document is active.Possible values: - true: Document is active - false: Document is inactive Data type: Boolean Default: true |
| case | Sys\_id of the case associated with the document. Located in the Case \[sn\_customerservice\_case\] table.Data type: String |
| category | Sys\_id of the category associated with the document, such as proof of address or proof of income. Located in the Category \[sn\_bom\_document\_category\] table.Data type: String |
| customer | Sys\_id of the person to contact with regards to this document. Located in the Consumer \[csm\_consumer\] table.Data type: String |
| customer\_document | Sys\_id of the document that is stored against the customer/account ID. Located in the Customer Document \[sn\_bom\_document\_customer\_document\] table.Data type: String |
| deferred\_to | Date until the document submission can be deferred.Data type: String Maximum length: 40 |
| definition\_category | Sys\_id of the definition category, which defines the relationship between the document definition and the document category. Located in the Definition Category \[sn\_bom\_document\_definition\_has\_category\] table.Data type: String |
| doc\_type | Sys_id of the type of document. For example, if the document category is Address Proof, the doc_type could be utility bill or driver's license. Located in the Type [sn_bom_document_type] table.Data type: String |
| mandatory | Flag that indicates whether the associated document is mandatory to submit the loan request.Possible values: - true: Mandatory - false: Optional Data type: Boolean |
| name | Name of the document, such as paystub or passport.Data type: String Maximum length: 120 |
| status | Current status of the document.Possible values: - cancelled - deferment requested - deferment approved - deferment rejected - exception requested - exception approved - not submitted - exception rejected - submitted - verified Data type: String Maximum length: 20 |
| sys\_class\_name | Table that contains the case record.Data type: String Maximum length: 80 |
| sys\_created\_by | Person that initially opened the case.Data type: String Maximum length: 40 |
| sys\_created\_on | Date and time when the case was initially created.Data type: String \(Date\) Maximum length: 40 |
| sys\_domain | Domain associated with the case.Data type: String Maximum length: 32 Default: global |
| sys\_id | Unique identifier for the case.Data type: String Maximum length: 32 |
| sys\_mod\_count | Number of updates to the case since it was initially created.Data type: Number \(Integer\) Maximum length: 40 |
| sys\_updated\_by | Person that last updated the case.Data type: String Maximum length: 40 |
| sys\_updated\_on | Date and time when the case was last updated.Data type: String \(Date\) Maximum length: 40 |
Loan Service Case [sn_bom_loan_service]
| Element | Description |
|---|---|
| account | Sys\_id of the account record associated with the case. Data type: String Table: Account \[customer\_account\] |
| account\_number | Customer's account number.Data type: String Maximum length: 40 |
| active | Flag that indicates whether the case is open and active.Possible values: - true: Case is active - false: Case is closed Data type: Boolean Default: true |
| active\_account\_escalation | Sys\_id of the active account escalation record associated with the case.Data type: String Table: Escalation \[sn\_customerservice\_escalation\] |
| active\_escalation | Sys\_id of the active escalation record associated with the case.Data type: String Table: Escalation \[sn\_customerservice\_escalation\] |
| activity\_due | Date for which the associated case is expected to be completed.Data type: String \(Date\) Maximum length: 40 |
| additional\_assignee\_list | List of the sys\_ids of the additional persons \(other than primary assignee\) that have been assigned to the account.Data type: Array Maximum length: 4,000 Table: User \[sys\_user\] |
| amount\_paid | Total amount paid on the loan.Data type: Number \(Currency\) Maximum length: 20 |
| approval | String that describes the type of approval required.Possible values: - approved - cancelled - duplicate - not requested - not required - rejected - requested Data type: String Maximum length: 40 Default: not requested |
| approval\_history | List of all approvals associated with the case.Data type: String \(Journal\) Maximum length: 4,000 |
| approval\_set | Date and time that the associated action was approved.Data type: String \(Date\) Maximum length: 40 |
| asset | Sys\_id of the asset record associated with the case.Data type: String Table: Asset \[alm\_asset\] |
| assigned\_on | Date and time that the case was assigned to the person identified in the assigned_to parameter.Data type: String (Date) Maximum length: 40 |
| assigned\_to | Sys\_id of the person assigned to the case. Table: User \[sys\_user\] Data type: String |
| assignment\_group | Sys\_id of the customer service agent group assigned to the case. Located in the Group \[sys\_user\_group\] table.Data type: String |
| auto\_close | Flag that indicates whether the case was automatically closed.Possible values: - true: Case was auto closed - false: Case wasn't auto closed Data type: Boolean Default: false |
| bankruptcy\_date | Date on which the associated customer declared bankruptcy.Data type: String \(Date\) Maximum length: 40 |
| business\_duration | Length in calendar work hours, work days, and work weeks that it took to complete the case.Data type: String \(Duration\) Maximum length: 40 |
| business\_service | Sys\_id of the service record associated with the case.Data type: String Table: Service \[cmdb\_ci\_service\] |
| calendar\_duration | Length in calendar hours, days, and weeks that it took to complete the case.Data type: String \(Duration\) Maximum length: 40 |
| case | Case short description and case number.Data type: String Maximum length: 300 |
| case\_report | Sys\_id of the associated case report.Data type: String Table: Case Report \[sn\_customerservice\_case\_report\] |
| category | Case category.Possible values: - 0: Question - 1: Issue - 2: Feature Data type: Number \(Integer\) Maximum length: 40 Default: 1 |
| cause | Details about the cause of the problem.Data type: String Maximum length: 4,000 |
| caused\_by | Sys\_id of the change request that caused the case to be created.Data type: String Table: Change Request \[change\_request\] |
| change | Sys\_id of the change request that caused the case to be created.Data type: String Table: Change Request \[change\_request\] |
| check\_number | Number of the customer check used to make a loan payment.Data type: String Maximum length: 255 |
| closed\_at | Date and time that the case was closed.Data type: String Maximum length: 40 |
| closed\_by | Sys\_id of the user that closed the case. Located in the User \[sys\_user\] table.Data type: String |
| close\_notes | Notes made when the case was closed.Data type: String Maximum length: 4,000 |
| cmdb\_ci | Sys\_id of the configuration item associated with the case.Data type: String Table: Configuration Item \[cmdb\_ci\] |
| comments | Additional comments about the case.Data type: String \(Journal Input\) Maximum length: 4,000 |
| comments\_and\_work\_notes | Comments and work notes entered for the case.Data type: String \(Journal List\) Maximum length: 4,000 |
| company | Sys\_id of the company associated with the case.Data type: String Table: Company \[core\_company\] |
| consumer | Business-to-consumer cases only. Sys\_id of the person to contact with regards to this case. Located in the Consumer \[csm\_consumer\] table.Data type: String |
| contact | Business-to-business based cases only. Sys\_id of the person to contact regarding this case.Data type: String Table: Contact \[customer\_contact\] |
| contact\_local\_time | Contact local time.Data type: String Maximum length: 70 |
| contact\_time\_zone | Time zone of the contact associated with the case.Data type: String Maximum length: 40 |
| contact\_type | Method in which the case was initially reported.Possible values: - chat - email - phone - social - web Data type: String Maximum length: 40 |
| contract | Sys\_id of the contract associated with the case.Data type: String Table: Contract \[ast\_contract\] |
| corrective\_action | Action the customer is taking to correct the current loan infraction, such as making a payment or remedial package.Data type: String Maximum length: 40 |
| correlation\_display | Display value for the correlation ID.Data type: String Maximum length: 100 |
| correlation\_id | Unique identifier for content pulled from an external system. Used in tracking continued updates for the content as part of integration.Data type: String Maximum length: 100 |
| credit\_service | Sys\_id of the associated credit service case. Located in the Credit Service Case \[sn\_bom\_credit\_asmt\_loan\_service\] table.Data type: String Maximum length: 40 |
| debit\_account | Sys\_id of an associated savings account. Located in the Deposit Account \[sn\_bom\_deposit\_account\] table.Data type: String Maximum length: 40 |
| debit\_general\_ledger\_account | General ledger account where funds are parked if the mode of payment is either cash or check.Data type: String Maximum length: 255 |
| deferment\_option | Payment deferment option, such as stop repayments, interest payments only, and smaller repayments.Data type: String Maximum length: 40 |
| deferment\_period | Length of time for the selected deferment option, such as, 30 days, 60 days, 90 days, and so on.Data type: String Maximum length: 40 |
| deferment\_reason | Reason the deferment is being put in place, such as, financial difficulties, change in employment, medical condition, and others.Data type: String Maximum length: 40 |
| delivery\_plan | Sys\_id of the parent execution plan for this case. Located in the Execution Plan \[sc\_cat\_item\_delivery\_plan\] table.Data type: String |
| delivery\_task | Sys\_id of the execution plan task. Data type: String Table: Execution Plan Task \[sc\_cat\_item\_delivery\_task\] |
| description | Detailed description of the problem associated with the case. Data type: String Maximum length: 4,000 |
| due\_date | Date that the case is due to be closed.Data type: String \(Date\) Maximum length: 40 |
| end\_date | End date of the loan or an associated activity such as a deferment period.Data type: String \(Date\) Maximum length: 40 |
| entitlement | Sys\_id of the entitlement record associated with the case. Entitlements define the type of support that a customer receives as well as the supported communication channels. An entitlement can be associated with a product, an asset, an account, or a contract.Data type: String Table: Entitlement \[service\_entitlement\] |
| escalation | Current escalation level.Possible values: - 0: Normal - 1: Moderate - 2: High - 3: Overdue Data type: Number \(Integer\) Maximum length: 40 Default: 0 |
| expected\_start | Date and time when work is scheduled to begin on the case.Data type: String \(Date\) Maximum length: 40 |
| fee\_amount | Amount of the fee that has been applied to the associated account.Data type: String \(Currency\) Maximum length: 20 |
| fee\_treatment | Treatment of the fee identified in fee_amount, such as waive or collect.Data type: String Maximum length: 40 |
| fee\_write\_off\_amount | Amount of fees that have been written off for this account.Data type: String \(Currency\) Maximum length: 20 |
| first\_response\_time | Date and time when the first action was taken on the case.Data type: String |
| follow\_the\_sun | Flag that indicates whether the case should be handed-off for global follow-up.If a customer enters additional comments on a Priority 1 - Critical or a Priority 2 - High case, or if the case is escalated, the flag is automatically set to true. Possible values: - true: Case should be handed-off for global follow-up - false: Case shouldn't be handed-off for global follow-up Data type: Boolean Default: false |
| follow\_up | Date and time of the next follow up action.Data type: String \(Date\) Maximum length: 40 |
| fund\_source | Source of the funds for this loan.Data type: String Maximum length: 255 |
| group\_list | List of sys\_ids of the group records associated with the case.Data type: Array \(List\) Maximum length: 4,000 Table: Group \[sys\_user\_group\] |
| impact | Impact on customer.Possible values: - 1: High - 2: Medium - 3: Low Data type: Number \(Integer\) Maximum length: 40 Default: 3 |
| initiated\_as\_request | Flag that indicates if this inquiry was initiated as a request by the customer.Possible values: - true: Inquiry initiated by customer. - false: Inquiry wasn't initiated by customer. Data type: Boolean Default: false |
| interest\_outstanding | Amount of interest that has yet to be paid on this loan.Data type: String \(Currency\) Maximum length: 20 |
| interest\_write\_off\_amount | Amount of interest that has been written off on this loanData type: String \(Currency\) Maximum length: 20 |
| judgement\_date | Date that the legal judgement was decided on this loan.Data type: String \(Date\) Maximum length: 40 |
| knowledge | Flag that indicates if there is a knowledge base article available for the specified issue.Possible values: - true: Knowledge base article is available for this issue - false: Knowledge base article isn't available for this issue Data type: Boolean Default: false |
| last\_repayment\_amount | Amount of the last payment made on this loan.Data type: String \(Currency\) Maximum length: 20 |
| last\_repayment\_date | Date of the most recent payment made on this loan.Data type: String \(Date\) Maximum length: 40 |
| loan\_amount | Amount of the loan that the customer is seeking forgiveness on.Data type: String \(Currency\) Maximum length: 20 |
| loan\_forgiveness\_reason | Reason for the loan being forgiven, such as financial difficulties, change in employment, medical condition, or others. Data type: String Maximum length: 40 |
| loan\_transaction | Sys\_id of the loan forgiveness transaction associated with this loan. Located in the Transaction \[sn\_bom\_loan\_transaction\] table.Data type: String |
| location | Sys\_id of the record describing the company location.Data type: String Table: Location \[cmn\_location\] |
| made\_sla | Flag that indicates whether the case was resolved in alignment with the associated service level agreement.Possible values: - true: Case was resolved in alignment with the SLA. - false: Case was not resolved according to the SLA. Data type: Boolean Default: true |
| mode\_of\_payment | Method used to make the most recent payment, such as cash, check, debit, customer's own bank account, or debit account held by another bank.Data type: String Maximum length: 40 |
| notes\_to\_comments | Flag that indicates whether to add the resolution notes to the comments.Possible values: - true: Resolutions notes, when added, are also added to the comments - false: Resolution notes in comments aren't required Data type: Boolean |
| notify | Method to use to notify contact/consumer.Possible values: - 1: Do not notify - 2: Send email - 3: Telephone Data type: Number \(Integer\) Default: 1 |
| number | Case number.Data type: String Maximum length: 40 |
| opened\_at | Date and time that the case was opened.Data type: String \(Date\) Maximum length: 40 |
| opened\_by | Sys\_id of the person that initially opened the case.Data type: String Table: User \[sys\_user\] |
| order | Defines some ordering/sequencing, whose usage depends upon the specific use cases.Data type: Number \(Integer\) Maximum length: 40 |
| other\_charges | Amount of any other charges applied to the loan.Data type: String \(Currency\) Maximum length: 20 |
| other\_charges\_write\_off\_amount | Amount of other charges that have been written-off for this loan.Data type: String \(Currency\) Maximum length: 20 |
| outstanding\_fee | Amount of any outstanding fees charged to this loan.Data type: String \(Currency\) Maximum length: 20 |
| parent | Sys\_id of the parent case to which this case \(child\) is associated. Located in the Task \[task\] table.Data type: String |
| partner | Sys\_id of the partner associated with the case.Data type: String Table: Account \[customer\_account\] |
| partner\_contact | Sys\_id of the partner contact associated with the case.Data type: String Table: Contact \[customer\_contact\] |
| payment\_details | Sys\_id of the payment details associated with this loan. Located in the Transaction \[sn\_bom\_loan\_transaction\] table.Data type: String |
| payment\_status | Status of the payment that is currently due, such as paid or unpaid. Data type: String Maximum length: 40 |
| prepayment\_amount | Amount to be prepaid on this loan.Data type: String \(Currency\) Maximum length: 20 |
| principal\_outstanding | Total amount of principal currently outstanding on the loan.Data type: String \(Currency\) Maximum length: 20 |
| principal\_write\_off\_amount | Total amount of principal that has been written-off for this loan.Data type: String \(Currency\) Maximum length: 20 |
| priority | Priority of the case. Possible values: - 1: Critical - 2: High - 3: Moderate - 4: Low Data type: Number \(Integer\) Maximum length: 40 Default: 4 |
| proactive | Flag that indicates whether the inquiry is being proactively monitored.Possible values: - true: Being proactively monitored. - false: Not being monitored. Data type: Boolean Default:false |
| problem | Sys\_id of the issue that the customer is encountering. Located in the Problem \[problem\] table.Data type: String |
| product | Sys\_id of the product model of the asset associated to the case. Located in the Product Model \[cmdb\_model\] table. A model is a specific version or configuration of an asset \(for example, Apple Mac Book Pro\).Data type: String |
| reassignment\_count | Number of times that the case was reassigned to a person that is responsible for moving the case forward.Data type: Number \(Integer\) Maximum length: 40 Default: 0 |
| rejection\_goto | Sys\_id of the task to execute if the case is rejected.Data type: String Table: Task \[task\] |
| remainder\_loan\_treatment | How to handle the outstanding loan balance after a prepayment amount is applied, such as change installment, change loan term, or no change.Data type: String |
| remarks | Customer remarks based on account activity.Data type: String Maximum length: 2,000 |
| remedial\_service | Sys\_id of the company being used for remedial services for this loan. Located in the Service \[cmdb\_ci\_service\] table.Data type: String |
| repayment\_amount | Total amount that has been repaid on the loan.Data type: String \(Currency\) Maximum length: 20 |
| repayment\_amount\_due | Total loan amount outstanding.Data type: String \(Currency\) Maximum length: 20 |
| repayment\_due\_date | Date on which the next payment is due.Data type: String \(Date\) Maximum length: 40 |
| report\_to\_credit\_bureau | Flag that indicates whether the loan status has to be reported to the credit bureaus.Possible values: - true: Has to be reported. - false: Does not have to be reported. Data type: Boolean |
| resolution\_code | Resolution state for the case, such as "Solved - Fixed by Support/Guidance provided". Data type: String Maximum length: 40 |
| resolved\_at | Date and time that the case was resolved.Data type: String |
| resolved\_by | Sys\_id of the person that resolved the case.Data type: String Table: User \[sys\_user\] |
| route\_reason | Reason that the case was routed to a different assignee.Data type: Number \(Integer\) Maximum length: 40 |
| routing\_number | Routing number of the check used to make a payment on the loan.Data type: String Maximum length: 255 |
| service\_definition | Sys\_id of the definition of service associated with this account. Located in the Service Definition \[sn\_bom\_service\_definition\] table.Data type: String |
| service\_offering | Sys\_id of the service offering associated with the payment inquiry. Service offerings uniquely define the level of service in terms of availability, scope, pricing, and packaging options.Data type: String Table: Service Offering \[service\_offering\] |
| short\_description | Concise description of the case. Data type: String Maximum length: 160 |
| skills | Sys\_ids of the skills needed to complete the case.Data type: String Maximum length: 4,000 Table: Skill \[cmn\_skill\] |
| sla\_due | Date/time at which the case must be closed based on the associated service level agreement.Data type: String Maximum length: 40 |
| sn\_app\_cs\_social\_social\_profile | Sys\_id of the social media profile associated with the case.Data type: String Table: Social Profile \[sn\_app\_cs\_social\_social\_profile\] |
| sold\_product | Sys\_id of the customer loan account. Located in the Sold Product \[sn\_install\_base\_sold\_product\] table.Data type: String |
| stage | Stage of the inquiry, such as Closed Complete, Closed Rejected, Document Check, Authorization, and so on.Data type: String Maximum length: 40 |
| start\_date | Start date of the personal loan.Data type: String \(Date\) Maximum length: 40 |
| state | Current state of the case. Possible values: - 1: New - 2: Open - 3: Awaiting Info - 4: Resolved - 5: Closed Data type: Number \(Integer\) Maximum length: 40 Default: 1 |
| subcategory | Case subcategory.Possible values: 0: QuestionData type: Number \(Integer\) Default: 0 |
| support\_manager | Sys\_id of the CSM manager assigned to the case.Data type: String Table: User \[sys\_user\] |
| sync\_driver | Flag that indicates whether there's driver synchronization.Possible values: - true: Driver is synchronized - false: Driver isn't synchronized Data type: Boolean |
| sys\_class\_name | Table that contains the case record.Data type: String Maximum length: 80 |
| sys\_created\_by | Person that initially opened the case.Data type: String Maximum length: 40 |
| sys\_created\_on | Date and time when the case was initially created.Data type: String \(Date\) Maximum length: 40 |
| sys\_domain | Domain associated with the case.Data type: String Maximum length: 32 Default: global |
| sys\_domain\_path | Domain path.Data type: String Maximum length: 255 Default: / |
| sys\_id | Unique identifier for the case.Data type: String Maximum length: 32 |
| sys\_mod\_count | Number of updates to the case since it was initially created.Data type: Number \(Integer\) Maximum length: 40 |
| sys\_updated\_by | Person that last updated the case.Data type: String Maximum length: 40 |
| sys\_updated\_on | Date and time when the case was last updated.Data type: String \(Date\) Maximum length: 40 |
| task\_effective\_number | Identifying number. If the task has a Universal Request associated with it, it's the UR number. Otherwise, it's the current task number. Data type: String Maximum length: 40 |
| time\_worked | Total amount of time worked on the case.Data type: String \(Timer\) Maximum length: 40 |
| total\_outstanding\_amount | Total amount of the loan, including principal, interest, any fees or dues on the loan.Data type: String \(Currency\) Maximum length: 20 |
| total\_write\_off\_amount | Total amount that has been written-off for this loan.Data type: String \(Currency\) Maximum length: 20 |
| universal\_request | Sys\_id of a universal task that this inquiry is part of.Data type: String Table: Task \[task\] |
| upon\_approval | Action to take if the case is approved.Possible values: - do\_nothing - proceed Data type: String Maximum length: 40 Default: proceed |
| upon\_reject | Action to take if the case is rejected.Possible values: - cancel - goto Data type: String Maximum length: 40 Default: cancel |
| urgency | Urgency of the case.Possible values: - 1: High - 2: Medium - 3: Low Data type: Number \(Integer\) Maximum length: 40 Default: 3 |
| user\_input | Additional user input.Data type: String \(User Input\) Maximum length: 4,000 |
| variables | Name-value pairs of variables associated with the case.Data type: String \(Variables\) Maximum length: 40 |
| watch\_list | List of sys\_ids of the users who receive notifications about this case when additional comments are added or if the state of a case is changed to Resolved or Closed. Located in the User \[sys\_user\] table. Data type: Array \(List\) Maximum length: 4,000 |
| wf\_activity | Sys\_id of the workflow activity record associated with the case.Data type: String Table: Workflow Activity \[wf\_activity\] |
| work\_end | Date and time work ended on the case.Data type: String \(Date\) Maximum length: 40 |
| work\_notes | Information about how to resolve the case, or steps taken to resolve it.Data type: String \(Journal Input\) Maximum length: 4,000 |
| work\_notes\_list | List of sys\_ids of the internal users who receive notifications about this case when work notes are added. Located in the User \[sys\_user\] table. Data type: Array \(List\) Maximum length: 4,000 |
| work\_start | Date and time that work started on the case.Data type: String \(Date\) Maximum length: 40 |
| write\_off\_option | Type of write-off of the loan, such as full write-off or partial write-off. Data type: String Maximum length: 40 |
Mortgage [sn_bom_mortgage] table
| Parameter | Description |
|---|---|
| account | Sys\_id of the account record associated with the case. Located in the Account \[customer\_account\] table. Data type: String |
| account\_number | Customer's account number. By default, this is the display value for the record.Data type: String Maximum length: 40 |
| accrued\_interest | Amount of accrued interest of the mortgage as of the date it is being viewed.Data type: Number \(Currency\) Maximum length: 20 |
| active | Flag that indicates whether the account is active.Possible values: - true: Account is currently active. - false: Account is inactive. Data type: Boolean Default: true |
| amount | Sanctioned mortgage amount.Data type: Number \(Currency\) Maximum length: 20 |
| application\_id | Unique identifier of the application submitted when applying for the mortgage.Data type: String Maximum length: 255 |
| apr | Annual percentage rate for the mortgage.Data type: Number \(Integer\) Maximum length: 40 |
| balance | Balance outstanding on the mortgage.Data type: Number \(Currency\) Maximum length: 20 |
| base\_currency | Sys\_id of the base currency used by the credit card. Located in the Currency \[fx\_currency\] table.Data type: String \(Reference\) |
| closure\_date | Date that the mortgage account was closed.Data type: String \(Date\) Maximum length: 40 |
| consumer | Sys\_id of the primary consumer record associated with the mortgage. Located in the Consumer \[csm\_consumer\] table.Data type: String \(Reference\) |
| cosigner | Sys\_id of the cosigner consumer record associated with the mortgage. Located in the Consumer \[csm\_consumer\] table.Data type: String \(Reference\) |
| credit\_facility\_id | Unique identifier of the facility linked to the mortgage.Data type: String Maximum length: 255 |
| customer\_class | Free-form classification of customer, such as Premier, Standard, or VIP.Data type: String Maximum length: 40 |
| days\_past\_due | Number of days that the current mortgage payment is past due.Data type: Number \(Integer\) Maximum length: 40 |
| delinquency\_status | Flag that indicates whether the account is currently delinquent.Possible values: - Yes - No Data type: String Maximum length: 40 |
| disbursed\_amount | Total amount of money that has been borrowed by the associated customer.Data type: Number \(Currency\) Maximum length: 20 |
| document\_id | Unique identifier of the documents associated with this mortgage in an external document management system.Data type: String Maximum length: 255 |
| end\_date | Date or the mortgage end.Data type: String \(Date\) Maximum length: 40 |
| external\_id | Unique identifier used to cross-reference this mortgage account to a record in an external system, such as a mortgage insurance ID.Data type: String Maximum length: 255 |
| federal\_backed\_load | Flag that indicates whether the associated mortgage is federally backed.Possible values: - Yes: Federally backed - No: Not federally backed Data type: String Maximum length: 40 |
| grace\_period\_for\_repayment | Number of days that a customer has after the due date to send in a payment without penalties.Data type: Number \(Integer\) Maximum length: 40 |
| guarantor | Sys\_id of the person that is guaranteeing the mortgage. Located in the Consumer \[csm\_consumer\] table.Data type: String \(Reference\) |
| interest\_rate | Current interest rate of the mortgage.Data type: Number \(Floating-point\) Maximum length: 40 |
| interest\_type | Type of interest associated with the mortgage, such as fixed or floating.Data type: String Maximum length: 40 |
| is\_lending\_insured | Flag that indicates whether the account is insured.Possible values: - true: Account is insured. - false: Account is not insured. Data type: Boolean |
| last\_payment\_amount | Amount of the most recent payment made by the customer.Data type: Number \(Currency\) Maximum length: 20 |
| last\_payment\_date | Date of the most recent payment made by the customer.Data type: String \(Date\) Maximum length: 40 |
| last\_reviewed\_on | Date the mortgage was last reviewed.Data type: String \(Date\) Maximum length: 40 |
| loan\_classification | Classification of the mortgage, such as standard, sub-standard, doubtful, or loss assets.Data type: String Maximum length: 40 |
| maturity\_date | Date on which the mortgage becomes due.Data type: String \(Date\) Maximum length: 40 |
| moratorium\_end\_date | End date of any imposed moratorium \(suspension of payment.\)Data type: String \(Date\) Maximum length: 40 |
| moratorium\_period | Period for which the customer has a suspension of mortgage repayment, such as 6 months, 1 year, 2 years, and so on.Data type: String Maximum length: 40 |
| moratorium\_start\_date | Date on which the customer suspended payments on the mortgage.Data type: String \(Date\) Maximum length: 40 |
| name | Full name of the primary person responsible for the mortgage.Data type: String Maximum length: 255 |
| next\_review\_on | Date on which the mortgage is to be reviewed.Data type: String \(Date\) Maximum length: 40 |
| no\_of\_installments | Number of payments due on the mortgage.Data type: Number \(Integer\) Maximum length: 40 |
| no\_of\_installment\_deferrals\_made | Number of times the customer deferred their payment on the mortgage.Data type: Number \(Integer\) Maximum length: 40 |
| number | Case number.Data type: String Maximum length: 40 |
| open\_date | Date when the mortgage account was first opened.Data type: String \(Date\) Maximum length: 40 |
| parent\_sold\_product | Sys\_id of the parent product associated with this entity. Located in the Sold Product \[sn\_install\_base\_sold\_product\] table.Data type: String \(Reference\) |
| pending\_installments | Number of payments remaining on the mortgage.Data type: Number \(Integer\) Maximum length: 40 |
| prepayment\_allowed | Flag that indicates whether the mortgage allows prepayments.Possible values: - Yes: Prepayments allowed - No: Prepayments not allowed Data type: String Maximum length: 40 |
| principal\_balance | Amount of the remaining mortgage principal.Data type: Number \(Currency\) Maximum length: 20 |
| product | Sys\_id of the product model of the mortgage. Located in the Product Model \[cmdb\_model\] table.Data type: String \(Reference\) |
| purpose | How the funds of the mortgage will be used by the customer, such as working capital or equipment purchase.Data type: String Maximum length: 40 |
| request\_channel | Type of communications channel \(digital or banker assisted\) the customer used to make the credit limit request.Data type: String Maximum length: 40 |
| risk\_rating | Risk associated with the credit card account.Data type: Number \(Integer\) Maximum length: 40 |
| rollover\_mode | Method in which a customer can extend the mortgage, such as auto rollover or manual rollover.Data type: String Maximum length: 40 |
| rollover\_possible | Flag that indicates whether the amount due on the mortgage can be rolled over in the future. Possible values: - Yes: Rollover possible - No: Not eligible for rollover Data type: String Maximum length: 40 |
| secondary\_consumer | Sys\_id of the secondary customer's account. Located in the Consumer \[csm\_consumer\] table.Data type: String |
| sourced\_channel | Source of the customer's business, such as broker or customer referral.Data type: String Maximum length: 40 |
| start\_date | Start date of the mortgage.Data type: String \(Date\) Maximum length: 40 |
| statement\_frequency | Frequency of statements sent to the customer, such as monthly, quarterly, bi-annually, or annually.Data type: String Maximum length: 40 |
| statement\_mode | Method in which the statement is delivered to the customer, such as physical or online.Data type: String Maximum length: 40 |
| status | Current status of the account, such as issued, active, blocked, closed, cancelled, and so on.Data type: String Maximum length: 40 |
| sys\_class\_name | Table that contains the case record.Data type: String Maximum length: 80 |
| sys\_created\_by | Name of the entity that created this record.Data type: String Maximum length: 40 |
| sys\_created\_on | Date and time that the record was originally created.Data type: String \(Date\) Maximum length: 40 |
| sys\_domain | Unique identifier of the domain associated with the record.Data type: String Maximum length: 32 Default: global |
| sys\_id | Unique identifier of the credit card record.Data type: String |
| sys\_mod\_count | Number of times the record has been updated.Data type: Number \(Integer\) Maximum length: 40 |
| sys\_updated\_by | Name of the entity that last updated this record.Data type: String Maximum length: 40 |
| sys\_updated\_on | Date and time that the record was last updated.Data type: String \(Date\) Maximum length: 40 |
| term | Number of terms associated with the mortgage.Data type: Number \(Integer\) Maximum length: 40 |
Payment Inquiry Case [sn_bom_payment_inquiry]
| Element | Description |
|---|---|
| account | Sys\_id of the account record associated with the case. Located in the Account \[customer\_account\] table. Data type: String |
| active | Flag that indicates whether the case is open and active.Possible values: - true: Case is active - false: Case is closed Data type: Boolean Default: true |
| active\_account\_escalation | Sys\_id of the active account escalation record associated with the case.Data type: String Table: Escalation \[sn\_customerservice\_escalation\] |
| active\_escalation | Sys\_id of the active escalation record associated with the case.Data type: String Table: Escalation \[sn\_customerservice\_escalation\] |
| activity\_due | Date for which the associated case is expected to be completed.Data type: String \(Date\) Maximum length: 40 |
| additional\_assignee\_list | List of the sys\_ids of the additional persons \(other than primary assignee\) that have been assigned to the account.Data type: Array Maximum length: 4,000 Table: User \[sys\_user\] |
| approval | String that describes the type of approval required.Possible values: - approved - cancelled - duplicate - not requested - not required - rejected - requested Data type: String Maximum length: 40 Default: not requested |
| approval\_history | List of all approvals associated with the case.Data type: String \(Journal\) Maximum length: 4,000 |
| approval\_set | Date and time that the associated action was approved.Data type: String \(Date\) Maximum length: 40 |
| asset | Sys\_id of the asset record associated with the case. Located in the Asset \[alm\_asset\] table.Data type: String |
| assigned\_on | Date and time that the case was assigned to the person identified in the assigned_to parameter.Data type: String (Date) Maximum length: 40 |
| assigned\_to | Sys\_id of the person assigned to the case. Table: User \[sys\_user\] Data type: String |
| assignment\_group | Sys\_id of the customer service agent group assigned to the case. Located in the Group \[sys\_user\_group\] table.Data type: String |
| auto\_close | Flag that indicates whether the case was automatically closed.Possible values: - true: Case was auto closed - false: Case was not auto closed Data type: Boolean Default: false |
| business\_duration | Length in calendar work hours, work days, and work weeks that it took to complete the case.Data type: String \(Duration\) Maximum length: 40 |
| business\_service | Sys\_id of the service record associated with the case.Data type: String Table: Service \[cmdb\_ci\_service\] |
| calendar\_duration | Length in calendar hours, days, and weeks that it took to complete the case.Data type: String \(Duration\) Maximum length: 40 |
| case | Case short description and case number.Data type: String Maximum length: 300 |
| case\_report | Sys\_id of the associated case report.Data type: String Table: Case Report \[sn\_customerservice\_case\_report\] |
| category | Case category.Possible values: - 0: Question - 1: Issue - 2: Feature Data type: Number \(Integer\) Default: 1 |
| cause | Details about the cause of the problem.Data type: String Maximum length: 4,000 |
| caused\_by | Sys\_id of the change request that caused the case to be created. Located in the Change Request \[change\_request\] table.Data type: String |
| change | Sys\_id of the change request that caused the case to be created.Data type: String Table: Change Request \[change\_request\] |
| closed\_at | Date and time that the case was closed.Data type: String Maximum length: 40 |
| closed\_by | Sys\_id of the user that closed the case. Located in the User \[sys\_user\] table.Data type: String |
| close\_notes | Notes made when the case was closed.Data type: String Maximum length: 4,000 |
| cmdb\_ci | Sys\_id of the configuration item associated with the case.Data type: String Table: Configuration Item \[cmdb\_ci\] |
| comments | Additional comments about the case.Data type: String \(Journal Input\) Maximum length: 4,000 |
| comments\_and\_work\_notes | Comments and work notes entered for the case.Data type: String \(Journal List\) Maximum length: 4,000 |
| company | Sys\_id of the company associated with the case.Data type: String Table: Company \[core\_company\] |
| consumer | Business-to-consumer cases only. Sys\_id of the person to contact with regards to this case. Located in the Consumer \[csm\_consumer\] table.Data type: String |
| contact | Business-to-business based cases only. Sys\_id of the person to contact regarding this case. Located in the Contact \[customer\_contact\] table.Data type: String |
| contact\_local\_time | Contact local time.Data type: String Maximum length: 70 |
| contact\_time\_zone | Time zone of the contact associated with the case.Data type: String Maximum length: 40 |
| contact\_type | Method in which the case was initially reported.Possible values: - chat - email - phone - social - web Data type: String Maximum length: 40 |
| contract | Sys\_id of the contract associated with the case.Data type: String Table: Contract \[ast\_contract\] |
| correct\_account | Account number to which the payment should have been sent.Data type: String Maximum length: 250 |
| correct\_beneficiary | Corrected name of the beneficiary to whom the payment should have been sent.Data type: String Maximum length: 250 |
| correct\_routing | Corrected routing number of the account to apply the payment to.Data type: String Maximum length: 250 |
| correlation\_display | Display value for the correlation ID.Data type: String Maximum length: 100 |
| correlation\_id | Unique identifier for content pulled from an external system. Used in tracking continued updates for the content as part of integration.Data type: String Maximum length: 100 |
| customer\_reason | Reason that the customer is making the payment inquiry, such as wrong account number, wrong sort code, incorrect amount, recurring payment not cancelled and such.Data type: String Maximum length: 40 |
| delivery\_plan | Sys\_id of the parent execution plan for this case. Located in the Execution Plan \[sc\_cat\_item\_delivery\_plan\] table.Data type: String |
| delivery\_task | Sys\_id of the execution plan task. Data type: String Table: Execution Plan Task \[sc\_cat\_item\_delivery\_task\] |
| description | Detailed description of the problem associated with the case. Data type: String Maximum length: 4,000 |
| due\_date | Date that the case is due to be closed.Data type: String \(Date\) Maximum length: 40 |
| entitlement | Sys\_id of the entitlement record associated with the case. Entitlements define the type of support that a customer receives as well as the supported communication channels. An entitlement can be associated with a product, an asset, an account, or a contract.Data type: String Table: Entitlement \[service\_entitlement\] |
| error\_type | Type of error that was made, such as customer error or bank error.Data type: String Maximum length: 40 |
| escalation | Current escalation level.Possible values: - 0: Normal - 1: Moderate - 2: High - 3: Overdue Data type: Number \(Integer\) Maximum length: 40 Default: 0 |
| expected\_start | Date and time when work is scheduled to begin on the case.Data type: String \(Date\) Maximum length: 40 |
| external\_id | Unique identifier used to cross-reference this payment inquiry to a record in an external system.Data type: String Maximum length: 255 |
| first\_response\_time | Date and time when the first action was taken on the case.Data type: String \(Date\) Maximum length: 40 |
| follow\_the\_sun | Flag that indicates whether the case should be handed-off for global follow-up.If a customer enters additional comments on a Priority 1 - Critical or a Priority 2 - High case, or if the case is escalated, the flag is automatically set to true. Possible values: - true: Case should be handed-off for global follow-up - false: Case shouldn't be handed-off for global follow-up Data type: Boolean Default: false |
| follow\_up | Date and time of the next follow up action.Data type: String \(Date\) Maximum length: 40 |
| group\_list | List of sys\_ids of the group records associated with the case.Data type: Array \(List\) Maximum length: 4,000 Table: Group \[sys\_user\_group\] |
| impact | Impact on customer.Possible values: - 1: High - 2: Medium - 3: Low Data type: Number \(Integer\) Maximum length: 40 Default: 3 |
| initiated\_as\_request | Flag that indicates if this inquiry was initiated as a request by the customer.Possible values: - true: Inquiry initiated by customer. - false: Inquiry wasn't initiated by customer. Data type: Boolean Default: false |
| is\_attempted\_recovery | Flag that indicates whether the customer tried to get misappropriated funds returned to them by reaching out to the beneficiary to whom the funds were incorrectly credited. Possible values: - true: Recovery attempt - false: Not a recovery attempt Data type: Boolean |
| is\_international | Flag that indicates whether this inquiry was made for an international payment transaction.Possible values: - true: International account - false: Domestic account Data type: Boolean |
| is\_recurring | Flag that indicates whether this inquiry was for a recurring payment.Possible values: - true: Recurring payment - false: Manual payment Data type: Boolean |
| is\_valid\_claim | Flag that indicates whether this is a valid inquiry claim.Possible values: - true: Valid claim - false: Invalid claim Data type: Boolean |
| knowledge | Flag that indicates if there is a knowledge base article available for the specified issue.Possible values: - true: Knowledge base article is available for this issue - false: Knowledge base article isn't available for this issue Data type: Boolean Default: false |
| location | Sys\_id of the record describing the company location.Data type: String Table: Location \[cmn\_location\] |
| made\_sla | Flag that indicates whether the case was resolved in alignment with the associated service level agreement.Possible values: - true: Case was resolved in alignment with the SLA. - false: Case was not resolved according to the SLA. Data type: Boolean Default: true |
| notes\_to\_comments | Flag that indicates whether to add the resolution notes to the comments.Possible values: - true: Resolutions notes, when added, are also added to the comments - false: Resolution notes in comments are not required Data type: Boolean |
| notify | Method to use to notify contact/consumer.Possible values: - 1: Do not notify - 2: Send email - 3: Telephone Data type: Number \(Integer\) Default: 1 |
| number | Case number.Data type: String Maximum length: 40 |
| opened\_at | Date and time that the case was opened.Data type: String \(Date\) Maximum length: 40 |
| opened\_by | Sys\_id of the person that initially opened the case. Located in the User \[sys\_user\] table.Data type: String |
| order | Defines some ordering/sequencing, whose usage depends upon the specific use cases.Data type: Number \(Integer\) Maximum length: 40 |
| other\_reason | Information entered in the Other Reason text box.Data type: String Maximum length: 4,000 |
| parent | Sys\_id of the parent case to which this case \(child\) is associated. Located in the Task \[task\] table.Data type: String |
| partner | Sys\_id of the partner associated with the case.Data type: String Table: Account \[customer\_account\] |
| partner\_contact | Sys\_id of the partner contact associated with the case.Data type: String Table: Contact \[customer\_contact\] |
| payment\_processor | Processor used to handle the associated payment, such as BACS, CHAP, Wire, and SWIFT.Data type: String Maximum length: 40 |
| priority | Priority of the case. Possible values: - 1: Critical - 2: High - 3: Moderate - 4: Low Data type: Number \(Integer\) Maximum length: 40 Default: 4 |
| proactive | Flag that indicates whether the inquiry is being proactively monitored.Possible values: - true: Being proactively monitored. - false: Not being monitored. Data type: Boolean Default:false |
| problem | Sys\_id of the issue that the customer is encountering.Data type: String Table: Problem \[problem\] |
| product | Sys\_id of the product model of the asset associated to the case. Located in the Product Model \[cmdb\_model\] table. A model is a specific version or configuration of an asset \(for example, Apple Mac Book Pro\).Data type: String |
| reassignment\_count | Number of times that the case was reassigned to a person that is responsible for moving the case forward.Data type: Number \(Integer\) Maximum length: 40 Default: 0 |
| receiving\_account | Sys\_id of the account record to which funds were erroneously credited. Located in the Account \[customer\_account\] table.Data type: String |
| receiving\_contact | Business-to-business based cases only. Sys\_id of the contact associated with the account receiving. Located in the Contact \[customer\_contact\] table.Data type: String |
| receiving\_customer | Business-to-consumer cases only. Sys\_id of the person associated with the receiving account. Located in the Consumer \[csm\_consumer\] table.Data type: String |
| receiving\_financial\_account | Sys\_id of the financial account to which funds were erroneously sent. Located in the Financial Account \[sn\_bom\_financial\_account\] table.Data type: String |
| receiving\_transactions | List of sys\_ids of transactions in the financial account to which the funds were erroneously sent. Located in the Financial Transaction \[sn\_bom\_transaction\] table.Data type: String Maximum length: 40,000 |
| recipient\_bank | Sys\_id of the bank that incorrectly received funds. Located in the Financial Institution \[sn\_bom\_financial\_institution\] table.Data type: String |
| recipient\_type | Type of recipient, such as internal \(bank customer\) or external \(not a bank customer\), who incorrectly received funds. Data type: String Maximum length: 40 |
| rejection\_goto | Sys\_id of the task to execute if the case is rejected. Located in the Task \[task\] table.Data type: String |
| remitter\_bank | Sys\_id of the bank that incorrectly remitted the funds. Located in the Financial Institution \[sn\_bom\_financial\_institution\] table.Data type: String |
| resolution\_code | Resolution state for the case, such as "Solved - Fixed by Support/Guidance provided". Data type: String Maximum length: 40 |
| resolved\_at | Date and time that the case was resolved.Data type: String \(Date\) Maximum length: 40 |
| resolved\_by | Sys\_id of the person that resolved the case. Located in the User \[sys\_user\] table.Data type: String |
| route\_reason | Reason that the case was routed to a different assignee.Data type: Number \(Integer\) Maximum length: 40 |
| sender\_transactions | List of sys\_ids of the transactions from the senders's financial account that were remitted incorrectly. Located in the Financial Transaction \[sn\_bom\_transaction\] table.Data type: String \(List\) Maximum length: 40,000 |
| sent\_to\_account | Account number to which the funds were erroneously sent.Data type: String Maximum length: 250 |
| sent\_to\_beneficiary | Name of the beneficiary to whom the funds were erroneously sent.Data type: String Maximum length: 250 |
| sent\_to\_routing | Routing number or sort code of the bank to which the funds were erroneously sent.Data type: String Maximum length: 250 |
| service\_definition | Sys\_id of the definition of service associated with this account. Located in the Service Definition \[sn\_bom\_service\_definition\] table.Data type: String |
| service\_offering | Sys\_id of the service offering associated with the payment inquiry. Service offerings uniquely define the level of service in terms of availability, scope, pricing, and packaging options.Data type: String Table: Service Offering \[service\_offering\] |
| short\_description | Concise description of the case. Data type: String Maximum length: 160 |
| skills | Sys\_ids of the skills needed to complete the case.Data type: String Maximum length: 4,000 Table: Skill \[cmn\_skill\] |
| sla\_due | Date/time at which the case must be closed based on the associated service level agreement.Data type: String Maximum length: 40 |
| sn\_app\_cs\_social\_social\_profile | Sys\_id of the social media profile associated with the case.Data type: String Table: Social Profile \[sn\_app\_cs\_social\_social\_profile\] |
| sold\_product | Sys\_id of the financial account of the customer from where the payment was sent in error. Located in the Sold Product \[sn\_install\_base\_sold\_product\] table.Data type: String |
| stage | Stage of the inquiry, such as Closed Complete, Closed Rejected, Document Check, Authorization, and so on.Data type: String Maximum length: 40 |
| state | Current state of the case. Possible values: - 1: New - 2: Open - 3: Awaiting Info - 4: Resolved - 5: Closed Data type: Number \(Integer\) Maximum length: 40 Default: 1 |
| subcategory | Case subcategory.Possible values: 0: QuestionData type: Number \(Integer\) Default: 0 |
| support\_manager | Sys\_id of the CSM manager assigned to the case.Data type: String Table: User \[sys\_user\] |
| sync\_driver | Flag that indicates whether there's driver synchronization.Possible values: - true: Driver is synchronized - false: Driver isn't synchronized Data type: Boolean |
| sys\_class\_name | Table that contains the case record.Data type: String Maximum length: 80 |
| sys\_created\_by | Person that initially opened the case.Data type: String Maximum length: 40 |
| sys\_created\_on | Date and time when the case was initially created.Data type: String \(Date\) Maximum length: 40 |
| sys\_domain | Domain associated with the case.Data type: String Maximum length: 32 Default: global |
| sys\_domain\_path | Domain path.Data type: String Maximum length: 255 Default: / |
| sys\_id | Unique identifier for the case.Data type: String Maximum length: 32 |
| sys\_mod\_count | Number of updates to the case since it was initially created.Data type: Number \(Integer\) Maximum length: 40 |
| sys\_updated\_by | Person that last updated the case.Data type: String Maximum length: 40 |
| sys\_updated\_on | Date and time when the case was last updated.Data type: String \(Date\) Maximum length: 40 |
| task\_effective\_number | Identifying number. If the task has a Universal Request associated with it, it's the UR number. Otherwise, it's the current task number. Data type: String Maximum length: 40 |
| time\_worked | Total amount of time worked on the case.Data type: String \(Timer\) Maximum length: 40 |
| total\_amount | Total currency amount of the payments that were made in error under this inquiry case.Data type: String \(Currency\) Maximum length: 20 |
| transaction\_id | Unique transaction identifier for this payment inquiry.Data type: String Maximum length: 150 |
| universal\_request | Sys\_id of a universal task that this inquiry is part of.Data type: String Table: Task \[task\] |
| upon\_approval | Action to take if the case is approved.Possible values: - do\_nothing - proceed Data type: String Maximum length: 40 Default: proceed |
| upon\_reject | Action to take if the case is rejected.Possible values: - cancel - goto Data type: String Maximum length: 40 Default: cancel |
| urgency | Urgency of the case.Possible values: - 1: High - 2: Medium - 3: Low Data type: Number \(Integer\) Maximum length: 40 Default: 3 |
| user\_input | Additional user input.Data type: String \(User Input\) Maximum length: 4,000 |
| variables | Name-value pairs of variables associated with the case.Data type: String \(Variables\) Maximum length: 40 |
| watch\_list | List of sys\_ids of the users who receive notifications about this case when additional comments are added or if the state of a case is changed to Resolved or Closed. Located in the User \[sys\_user\] table. Data type: Array \(List\) Maximum length: 4,000 |
| wf\_activity | Sys\_id of the workflow activity record associated with the case.Data type: String Table: Workflow Activity \[wf\_activity\] |
| work\_end | Date and time work ended on the case.Data type: String \(Date\) Maximum length: 40 |
| work\_notes | Information about how to resolve the case, or steps taken to resolve it.Data type: String \(Journal Input\) Maximum length: 4,000 |
| work\_notes\_list | List of sys\_ids of the internal users who receive notifications about this case when work notes are added. Located in the User \[sys\_user\] table. Data type: Array \(List\) Maximum length: 4,000 |
| work\_start | Date and time that work started on the case.Data type: String \(Date\) Maximum length: 40 |
Personal Checking Account [sn_bom_checking_account] table
| Parameter | Description |
|---|---|
| account | Sys\_id of the account record associated with the case. Located in the Account \[customer\_account\] table. Data type: String |
| account\_number | Customer's account number. By default, this is the display value for the record.Data type: String Maximum length: 40 |
| accrued\_interest | Amount of accrued interest as of the date it is being viewed.Data type: Number \(Currency\) Maximum length: 20 |
| active | Flag that indicates whether the account is active.Possible values: - true: Account is currently active. - false: Account is inactive. Data type: Boolean Default: true |
| application\_id | Unique identifier of the application submitted when applying for the checking account.Data type: String Maximum length: 255 |
| balance | Amount currently in the checking account.Data type: Number \(Currency\) Maximum length: 20 |
| base\_currency | Sys\_id of the base currency used by the credit card. Located in the Currency \[fx\_currency\] table.Data type: String \(Reference\) |
| closure\_date | Date that the checking account account was closed.Data type: String \(Date\) Maximum length: 40 |
| consumer | Business-to-consumer cases only. Sys\_id of the person to contact with regards to this case. Located in the Consumer \[csm\_consumer\] table.Data type: String |
| customer\_class | Free-form classification of customer, such as Premier, Standard, or VIP.Data type: String Maximum length: 40 |
| end\_date | Date the checking account ends.Data type: String \(Date\) Maximum length: 40 |
| external\_id | Unique identifier used to cross-reference this credit card account to a record in an external system, such as a credit card insurance ID.Data type: String Maximum length: 255 |
| interest\_credit\_account | Sys\_id of the deposit account associated with this checking account. Located in the Deposit Account \[sn\_bom\_deposit\_account\] table.Data type: String |
| interest\_rate\_apy | Annual percentage yield for the checking account.Data type: Number \(Integer\) Maximum length: 40 |
| interest\_rate\_end\_date | End date of the current interest rate.Data type: String \(Date\) Maximum length: 40 |
| interest\_rate\_start\_date | Start date of the current interest rate.Data type: String \(Date\) Maximum length: 40 |
| name | Full name of the primary person associated with the checking account.Data type: String Maximum length: 255 |
| number | Case number.Data type: String Maximum length: 40 |
| open\_date | Date when the checking account was first opened.Data type: String \(Date\) Maximum length: 40 |
| other\_margin | Preferential discounts that are applicable to a category of customers, such as minors or senior citizens.Data type: String Maximum length: 40 |
| parent\_sold\_product | Sys\_id of the parent product associated with this entity. Located in the Sold Product \[sn\_install\_base\_sold\_product\] table.Data type: String \(Reference\) |
| product | Sys\_id of the of the customer checking account. Located in the Product Model \[cmdb\_model\] table.Data type: String \(Reference\) |
| request\_channel | Type of communications channel \(digital or banker assisted\) the customer used to make the credit limit request.Data type: String Maximum length: 40 |
| secondary\_consumer | Sys\_id of the secondary customer's account. Located in the Consumer \[csm\_consumer\] table.Data type: String |
| sourced\_channel | Source of the customer's business, such as broker or customer referral.Data type: String Maximum length: 40 |
| start\_date | Date when the checking account was opened.Data type: String \(Date\) Maximum length: 40 |
| statement\_frequency | Frequency of statements sent to the customer, such as monthly, quarterly, bi-annually, or annually.Data type: String Maximum length: 40 |
| statement\_mode | Method in which the statement is delivered to the customer, such as physical or online.Data type: String Maximum length: 40 |
| status | Current status of the account, such as active, blocked, closed, cancelled, and so on.Data type: String Maximum length: 40 |
| sys\_class\_name | Table that contains the case record.Data type: String Maximum length: 80 |
| sys\_created\_by | Person that initially opened the case.Data type: String Maximum length: 40 |
| sys\_created\_on | Date and time when the case was initially created.Data type: String \(Date\) Maximum length: 40 |
| sys\_domain | Domain associated with the case.Data type: String Maximum length: 32 Default: global |
| sys\_id | Unique identifier of the credit card record.Data type: String |
| sys\_mod\_count | Number of updates to the case since it was initially created.Data type: Number \(Integer\) Maximum length: 40 |
| sys\_updated\_by | Person that last updated the case.Data type: String Maximum length: 40 |
| sys\_updated\_on | Date and time when the case was last updated.Data type: String \(Date\) Maximum length: 40 |
Personal Loan [sn_bom_personal_loan] table
| Parameter | Description |
|---|---|
| account | Sys\_id of the account record associated with the case. Data type: String Table: Account \[customer\_account\] |
| account\_number | Customer's account number. By default, this is the display value for the record.Data type: String Maximum length: 40 |
| accrued\_interest | Amount of accrued interest as of the date it is being viewed.Data type: Number \(Currency\) Maximum length: 20 |
| active | Flag that indicates whether the account is active.Possible values: - true: Account is currently active. - false: Account is inactive. Data type: Boolean Default: true |
| amount | Sanctioned loan amount.Data type: Number \(Currency\) Maximum length: 20 |
| application\_id | Unique identifier of the application submitted when applying for the personal loan.Data type: String Maximum length: 255 |
| apr | Annual percentage rate for the personal loan.Data type: Number \(Integer\) Maximum length: 40 |
| balance | Outstanding balance on the loan.Data type: Number \(Currency\) Maximum length: 20 |
| base\_currency | Sys\_id of the base currency used by the loan. Located in the Currency \[fx\_currency\] table.Data type: String \(Reference\) |
| closure\_date | Date that the personal loan account was closed.Data type: String \(Date\) Maximum length: 40 |
| consumer | Sys\_id of the primary consumer record associated with the loan. Located in the Consumer \[csm\_consumer\] table.Data type: String \(Reference\) |
| cosigner | Sys\_id of the cosigner consumer record associated with the loan. Located in the Consumer \[csm\_consumer\] table.Data type: String \(Reference\) |
| credit\_facility\_id | Unique identifier of the credit facility linked to the loan.Data type: String Maximum length: 255 |
| customer\_class | Free-form classification of customers, such as Premier, Standard, or VIP.Data type: String Maximum length: 40 |
| days\_past\_due | Number of days that the current loan payment is past due.Data type: Number \(Integer\) Maximum length: 40 |
| delinquency\_status | Flag that indicates whether the account is currently delinquent.Possible values: - Yes: Account is delinquent - No: Account is not delinquent Data type: String Maximum length: 40 |
| disbursed\_amout | Total amount of money that has been borrowed by the associated customer.Data type: Number \(Currency\) Maximum length: 20 |
| document\_id | Unique identifier of the documents associated with this mortgage in an external document management system.Data type: String Maximum length: 255 |
| end\_date | End date of the personal loan.Data type: String \(Date\) Maximum length: 40 |
| external\_id | Unique identifier used to cross-reference this loan account to a record in an external system.Data type: String Maximum length: 255 |
| federal\_backed\_load | Flag that indicates whether the associated loan is federally backed.Possible values: - Yes: Federally backed loan - No: Not a federally backed loan Data type: String Maximum length: 40 |
| grace\_period\_for repayment | Number of days that a customer has after the due date to send in a payment without penalties.Data type: Number \(Integer\) Maximum length: 40 |
| guarantor | Sys\_id of the person that is guaranteeing the loan. Located in the Consumer \[csm\_consumer\] table.Data type: String \(Reference\) |
| interest\_rate | Current interest rate of the loan.Data type: Number \(Floating-point\) Maximum length: 40 |
| interest\_type | Type of interest associated with the loan, such as fixed or floating.Data type: String Maximum length: 40 |
| is\_lending\_insured | Flag that indicates whether the account is insured.Possible values: - true: Account is insured. - false: Account isn't insured. Data type: Boolean |
| last\_payment\_amount | Amount of the most recent payment made on the loan.Data type: Number \(Currency\) Maximum length: 20 |
| last\_payment\_date | Date of the most recent payment made on the loan.Data type: String \(Date\) Maximum length: 40 |
| last\_reviewed\_on | Date the loan was last reviewed.Data type: String \(Date\) Maximum length: 40 |
| loan\_classification | Classification of the loan, such as standard, sub-standard, doubtful, or loss assets.Data type: String Maximum length: 40 |
| maturity\_date | Date on which the loan becomes due.Data type: String \(Date\) Maximum length: 40 |
| moratorium\_end\_date | End date of any imposed moratorium \(suspension of payment.\)Data type: String \(Date\) Maximum length: 40 |
| moratorium\_period | Period for which the customer has a suspension of loan repayment, such as 6 months, 1 year, 2 years, and so on.Data type: String Maximum length: 40 |
| moratorium\_start\_date | Date on which the customer suspended payments on the loan.Data type: String \(Date\) Maximum length: 40 |
| name | Full name of the primary person responsible for the loan.Data type: String Maximum length: 255 |
| next\_review\_on | Date on which the loan is to be reviewed.Data type: String \(Date\) Maximum length: 40 |
| no\_of\_installments | Number of payments due on the loan.Data type: Number \(Integer\) Maximum length: 40 |
| no\_of\_installment\_deferrals\_made | Number of times the customer deferred their payment on the loan.Data type: Number \(Integer\) Maximum length: 40 |
| number | Case number.Data type: String Maximum length: 40 |
| open\_date | Date when the personal loan account was first opened.Data type: String \(Date\) Maximum length: 40 |
| parent\_sold\_product | Sys\_id of the parent product associated with this entity. Located in the Sold Product \[sn\_install\_base\_sold\_product\] table.Data type: String \(Reference\) |
| pending\_installments | Number of payments remaining on the loan.Data type: Number \(Integer\) Maximum length: 40 |
| prepayment\_allowed | Flag that indicates whether the loan allows prepayments.Possible values: - Yes: Prepayments allowed - No: Prepayments not allowed Data type: String Maximum length: 40 |
| principal\_balance | Amount of the remaining loan principal.Data type: Number \(Currency\) Maximum length: 20 |
| product | Sys\_id of the product model of the asset associated to the case. Located in the Product Model \[cmdb\_model\] table.Data type: String \(Reference\) |
| purpose | How the funds of the loan will be used by the customer, such as working capital or equipment purchase.Data type: String Maximum length: 40 |
| request\_channel | Type of communications channel \(digital or banker assisted\) the customer used to make the credit limit request.Data type: String Maximum length: 40 |
| risk\_rating | Risk associated with this loan account.Data type: Number \(Integer\) Maximum length: 40 |
| rollover\_mode | Method in which a customer can extend the loan, such as auto rollover or manual rollover.Data type: String Maximum length: 40 |
| rollover\_possible | Flag that indicates whether the balance due on the loan can be rolled over in the future.Possible values: - Yes: Rollover is available - No: Rollover isn't available Data type: String Maximum length: 40 |
| secondary\_consumer | Sys\_id of the secondary customer's account. Located in the Consumer \[csm\_consumer\] table.Data type: String |
| sourced\_channel | Source of the customer's business, such as broker or customer referral.Data type: String Maximum length: 40 |
| start\_date | Start date of the personal loan.Data type: String \(Date\) Maximum length: 40 |
| statement\_frequency | Frequency of statements sent to the customer, such as monthly, quarterly, bi-annually, or annually.Data type: String Maximum length: 40 |
| statement\_mode | Method in which the statement is delivered to the customer, such as physical or online.Data type: String Maximum length: 40 |
| status | Current status of the account, such as issued, active, blocked, closed, cancelled, and so on.Data type: String Maximum length: 40 |
| sys\_class\_name | Table that contains the case record.Data type: String Maximum length: 80 |
| sys\_created\_by | Name of the entity that created this record.Data type: String Maximum length: 40 |
| sys\_created\_on | Date and time that the record was originally created.Data type: String \(Date\) Maximum length: 40 |
| sys\_domain | Unique identifier of the domain associated with the record.Data type: String Maximum length: 32 Default: global |
| sys\_id | Unique identifier of the personal loan record.Data type: String |
| sys\_mod\_count | Number of times the record has been updated.Data type: Number \(Integer\) Maximum length: 40 |
| sys\_updated\_by | Name of the entity that last updated this record.Data type: String Maximum length: 40 |
| sys\_updated\_on | Date and time that the record was last updated.Data type: String \(Date\) Maximum length: 40 |
| term | Number of terms associated with the loan.Data type: Number \(Integer\) Maximum length: 40 |