PeopleSoft Enterprise CRM 9.1 Industry Application Fundamentals PeopleBook

Working with Financial Accounts

This chapter provides overviews of financial accounts, integration with legacy systems, and discusses how to:

Set up account defaults.
View financial account information.
Modify financial accounts.

Understanding Financial Accounts

A financial account represents a holding by a customer of a product or service provided by financial services industries, including insurance, wealth management, and banks. The financial account function presents information from various legacy systems in a consistent interface. The financial account maps to the product, inheriting the terms and conditions from the product purchased by the customer.

The Financial Account record and its sub-records are created by the legacy administration systems. The Product order process functionality sends the completed application to the legacy system, the legacy system creates the account in their own area and then sends a message to CRM. The CRM system reads the inbound message and creates the account header record and the associated sub records inside its own system.

A financial account is held by a business contact. The business contact may be a person, company, partnership or an alternate capacity.

Each financial account record represents one financial services account. If a business contact has two checking accounts, there is one financial account instance in the financial services database for each.

A financial account is associated with the terms and conditions related to the product. Additional terms and conditions can be applicable to specific accounts.

Views of Financial Accounts

PeopleSoft delivers customer, agent, account manager, and application administrator permission groups for PeopleSoft Enterprise Banking Transactions, PeopleSoft Enterprise Bill Presentment and Account Management, PeopleSoft Enterprise Policy and Claims Presentment, and PeopleSoft Enterprise Client Management.

Customer

The self-service customer navigates to account detail records by way of the My Accounts pagelet.

My Accounts contains a listing of accounts for which the customer is the owner, authorized user, or beneficiary, or, in other words, has security matrix entry in his or her name. The account detail is read-only for the customer. No information can be changed on this page.

Agent

The financial services agent does not have permission to search the listing of account records held by customers. Agent access is strictly controlled. An agent can only view the details of an account held by a customer who is explicitly identified. Agents can view an account only when they identify the customer and navigate to the customer's 360-Degree View. Every entry of the agent to a particular customer's 360-Degree View is traced by access trace mechanism.

Account Manager and Administrator

The financial services account manager and the administrator has more authority to search for an existing account record.

There is a search page available to find an existing account record. The account detail is read-only. In addition, they can also see the accounts by navigating through the 360-Degree View as the agent does.

Financial Account Types

Financial account information is provided for a number of contract types that correspond to product types.

As PeopleSoft CRM applications are delivered, the following financial accounts are available:

Checking account.
Savings account.
Credit account.
Insurance policy.
Investment account.
Loan.

Understanding Integration with Legacy Systems

This section discusses integration requirements.

Two components must be configured for the integration to function correctly:

Integration Broker setup.
A legacy system can post the appropriate XML file to the uniform resource locator of the application messaging gateway. The PeopleSoft system then asynchronously subscribes to this data and loads it into the production tables. A legacy system can also choose to use a flat file to represent its data. An application engine process converts the flat file into an XML document that is in turn published to the application messaging gateway. The process run to perform this function automates the conversion of a flat file to an XML document and also the publishing process. For XML post, inbound data is validated during subscription. For flat files, data validation occurs during the publishing phase and again during the subscription phase.

The goal is to provide an integration framework to subscribe to inbound data from any legacy system. The two delivered methods of integration (XML and flat file) still go through the same enterprise integration point (EIP), which is the application messaging gateway.

Delivered XML Templates

PeopleSoft CRM delivers XML templates to perform the following:

Add and update financial accounts.
Set relationships.
Set security matrix data.
Set addresses for financial accounts.
Set financial account fees.

Note. The file contains all of the necessary data definition tags. . The message data should be changed appropriately according to what data is being loaded. Additional transactions should be added as needed.

Delivered Flat File Templates

PeopleSoft CRM delivers flat file templates to perform the following:

Add and update financial accounts. (RBF_FIN_ACCT_FULL_SYNC)

Note. This is a sample and the file should be modified accordingly.
Set relationships for the financial account. (RBF_FINACCT_RELATIONSHIPS)
Set security matrix data. (RBF_FINACCT_SECURITY and RBF_FINACCT_SECURITY_BYROLE)
Set addresses for financial accounts. (RBF_FINACCT_ADDRESS)
Set account fees. (RBF_FINACCT_FEES)

Delivered Flat File Processes

PeopleSoft CRM delivers the flat file process—RBF_FIN_ITG—which runs to load a flat file depending on the configuration.

Assumptions for XML Integration

Review the following assumptions for XML integration:

All messages must be active in Application Designer.
The transactions must be set up in Integration Broker through PeopleSoft Internet Architecture, and they must be active.
Financial account messages require the following fields in the header:
- CUST_ACCT_NBR
- SYSTEM_SOURCE_CD
- PROD_SETID
- PRODUCT_ID
- BO_ID_OWNER
- OWNER_BO_TYPE
- FIN_ACCOUNT_STATUS

Note. PROD_SETID, PRODUCT_ID, AND OWNER_BO_TYPE must be either valid prompt values or valid translate values that exist in the PeopleSoft system. Therefore, any legacy system would need to synchronize the list of possible values for these fields with the PeopleSoft system.

Legacy has to set the AUDIT_ACTN in the PSCAMA record in the XML file.

The value of A is Add (INSERT), C is Change (UPDATE), and D is Delete.
The message should contain the required fields of the parent and the child.
Cannot insert a child RBF_CHECK_ACCT) without a parent (that is, RBF_FIN_ACCOUNT).
If the account has a status of CLOSED, then the security message has to be sent by the legacy to delete the entries in the security matrix.

Financial account address message: CUST_ACCT_NBR and SYSTEM_SOURCE_CD has to be associated with the message.

Relationships message:

REL_TYPE_ID, ROLE_TYPE_ID are assumed to exist both in legacy and PeopleSoft CRM.
Legacy sends the ID values for relationship type to set the relationships.
In the relationship message, the first placeholder is the financial account information and the second placeholder is the business object with which the relationship is targeted.
OWNER_BO_TYPE should be sent by legacy, which is one of the following:
- ACC — Financial Account
- PER — Person
- COM — Company
- ALT — Alternate Capacity
- PAR — Partnership
When relationships end, a message has to be sent from legacy with an end date of the relationship.

Security message:

Legacy sends the XML file with the following fields:
- FIRST_NAME
- MIDDLE_NAME
- LAST_NAME
- TIN
- TIN_TYPE
- NATIONAL_ID
- COUNTRY_NM_FORMAT
- SYSTEM_SOURCE_CD
- CUST_ACCT_NBR
- SRTY_FUNCTION_CD
- APPROVAL_FLG (Y/N)
- SRTY_OPERATOR_CD
- SRTY_AMOUNT
- SRTY_ROLE_CD
  
  BO_IDs are determined from the PeopleSoft side and the security matrix is populated accordingly. If business object does not exist, the PeopleSoft CRM system creates a business object and sets up the security matrix accordingly.
To populate the security matrix by role, legacy sends the following information in the XML file.

Legacy has to know the SRTY_ROLE_CD, which exists in PeopleSoft CRM:
- FIRST_NAME
- MIDDLE_NAME
- LAST_NAME
- TIN
- NATIONAL_ID
- TIN_TYPE
- COUNTRY_NM_FORMAT
- SYSTEM_SOURCE_CD
- CUST_ACCT_NBR
- SRTY_ROLE_CD

Assumptions for File Integration

This process employs a mapping of fields in the flat file. Column headings are specified on the first line of the flat file. These column headings are mapped to actual PeopleSoft field names on the setup page. This mapping is saved and used when loading a flat file. In this way, order of the fields is irrelevant. Headings are used to determine which values correspond to which fields.

To set up the file upload:

Map the flat file in the Setup component.
Provide the file map name.
Specify the delimiter.
Ensure that all records to be included in the flat file are mapped here in the setup page.

Select the record name (that is, RBF_FIN_ACCOUNT) from the prompt. Click the default fields button to automatically populate the grid with the fields of that record. Select the fields that you want to include as headings in your flat file. The flat file field name specified here must match the corresponding column heading that you will use in your flat file.
Add as many records and fields as is necessary.
Save the mapping.

To set up the flat file:

Ensure that the file being used matches the previously created file mapping.
Ensure that column headings of the file match the flat file field names specified in the mapping.

To run the file upload process:

Select the File Upload component.
Add a run control ID.
Enter the file name (direct or absolute path of the file—for example, c:\pt842\appserv\prcs\dbname\files\filename.txt).

The file must reside on the same computer as the process scheduler.
Select the file map name from the prompt.

This map should be the mapping of the file that you will be using.
Select Run and select the process RBF_FIN_ITG, and then click OK.
Validate in the process monitor that the process has a status of success.

The log file generated by this process is dumped into the root directory of the process scheduler (ps_cfg_home\appserv\prcs\dbname\files).

Setting Up Account Defaults

This section discusses how to set up account defaults.

Page Used to Set Up Account Defaults

Page Name	Definition Name	Navigation	Usage
FSI Options	RBF_OPTIONS	Set Up CRM, Product Related, Financial Services, FSI Options	Set up default values for a financial account.

Defining Account Defaults

Access the FSI Options page (Set Up CRM, Product Related, Financial Services, FSI Options).

See Setting Up Industry-Specific Functionality.

Viewing Financial Account Information

This section discusses how to view financial account information.

Pages Used to View Financial Account Information

Page Name	Definition Name	Navigation	Usage
Financial Account	RBF_FIN_ACCOUNT	Customer Accounts, Review Financial Accounts, Financial Account	View general account information. The Financial Account page varies depending on the type of account.
Financial Account - Relationships	RBF_ACCT_RELATIONS	Customer Accounts, Review Financial Accounts, Financial Account, Relationships	View all relationships that are associated with the account.
Financial Account - ATM Cards	RBF_ACCT_ATM_CARDS	Customer Accounts, Review Financial Accounts, Financial Account, ATM Cards	View all ATM cards that are associated with the account.
Financial Account - Terms and Conditions	RBF_ACCT_ATTR	Customer Accounts, Review Financial Accounts, Financial Account, Terms and Conditions	View the terms and conditions that are associated with the account.
Financial Account - Fees	RBF_FINACCT_FEES	Customer Accounts, Review Financial Accounts, Financial Account, Fees	View all account fees that are associated with the account.
Financial Account - Claims	RBI_CLAIM_HIST	Customer Accounts, Review Financial Accounts, Financial Account, Claims	View claims against insurance policies owned by the customer.
Financial Account - History	RBF_ACTADR_HIST	Customer Accounts, Review Financial Accounts, Financial Account, Address History	View the address and audit history that is associated with the account.
Financial Account - Cases	RBF_FIN_CASE_VW_PG	Customer Accounts, Review Financial Accounts, Financial Account, Cases	Tracks cases associated to the account.
Financial Account - Applications	RBF_FIN_RO_HISTORY	Customer Accounts, Review Financial Accounts, Financial Account, Applications	Tracks history of customer applications for products and services.

Viewing Financial Accounts

Access the Financial Account page (Customer Accounts, Review Financial Accounts, Financial Account).

Note. The view of the Financial Account page varies with the Account Type. For example, if the account is an Investment Account, only the Investment Account group box is displayed on the Financial Account page. The user will not see a group box for Insurance accounts, Credit accounts, and so on.

Account Information

System Source Code	Legacy data. One translate value, BSCS, is delivered.
Billing Account	The billing account that is associated to the financial account.
Account Owner	The name of the account owner or primary name that is defined for the account.
Status	The current status of the account. Values are: Open, Closed, Inactive, Pending Open, Pending Closed, or Hold.
Partner Name	The name of the partner associated with the customer.
Partner Contact	The contact for the partner.
Description	The description of the account.
Begin Date and End Date	The date that the account was opened. and the date that the account was closed, if applicable.
Account Type	The type of account. Values are: Checking, Savings, Credit, Insurance, or Investment.
Last Statement Date	The date that the most recent statement was calculated and issued.
Registration Type	The account registration type. Under Personal accounts, the values are: Individual, Joint with rights of survivorship, Tenants in common, Community property, Named beneficiary, Custodial account for minor, or Trust. Under Business accounts, the values are: Corporation, Partnership, or LLC.
TIN Type (Tax Identification Number Type)	The taxpayer identification type. Values are: SSN, EIN, or ITIN.
Registration Name	The name that is given to the account by the bank when registering the account.
Tax ID	The taxpayer identification number of the account holder.
New Nickname	The nickname that is given to the account by the owner.
Currency Code	The code of the currency in which the account is held.
Last Refresh	The date and time that this record was last refreshed by the legacy system.
Bill Pay Enabled	Determines whether the Billing Account component is enabled for the account.
YTD Revenue (Year to Date Revenue)	The amount the financial institution has earned from the account year-to-date.
Revenue Basis	The basis for the revenue, either Annual or Monthly.
Last Year's Revenue	The amount the financial institution earned from the account in the previous year.
Where Held	A Wealth Management field indicating the bank where the account is held.
Address	Address for the account holder.
Asset Type 1, Asset Type 2, and Asset Type 3	If assets are a part of the account, this lists the type of asset. These values are used primarily in PeopleSoft Enterprise Client Management.

Investment Account

Access Investment Account information on the Financial Account page.

Investment Account Type	The investment account type. Values are: Brokerage, Margin, Securities Custody, Investment Management, Trust, 401(k), Option Account, ESPP, or IRA.
Market Value	The current market value of all the investments that are in the account.

The fields in the Investment Account group box display information about each holding in the investment account.

CUSIP (Committee on Uniform Securities and Identification Procedures)	A number that uniquely identifies a given security. For example, the CUSIP number for Oracle common stock is 68389X105. CUSIP is an acronym for the Committee on Uniform Securities and Identification Procedures, the standards body that created and maintains the classification system. Foreign securities have a similar number called the CINS number.
Acquired Date	The date that the investment was acquired.
Symbol	The stock symbol for the security.
Security Name	The name of the security.
Quantity	The number of investment units held.
Current Value	The current value of the investment.
Asset Type 1, Asset Type 2, and Asset Type 3	Define the type of asset.

Insurance Account

View Insurance Account information on the Financial Account page.

All fields are defined in the PeopleSoft Policy and Claims Presentment PeopleBook.

See Working with Policies.

Checking Account

View Checking Account information on the Financial Account page.

Checking Type	The checking account type. Values are: Regular, Interest Bearing, Private Banking, Business, Student, or ATM Checking.
Account Balance	The available balance for the account showing funds that are available for withdrawal.
Average Balance	The average balance over the most recent accounting period.
Interest Rate	The interest rate if the account pays interest on funds on deposit.
Current Balance	The current balance, which includes deposits that have not yet been cleared.
Last Deposit Amount	The amount of the last deposit.
Last Deposit Date	The date of the last deposit.
Number of Overdrafts	The number of overdrafts that are in the most recent accounting period.
Days in Overdraft	The number of days that the account has been overdrawn in the current accounting period.
Account Fees	Cumulative total of account fees that have been charged to the account.

Credit Account

View Credit Account information on the Financial Account page.

See PeopleSoft Enterprise Banking Transactions 9.1 Preface.

Credit Account Type	The credit account type. Values are: Credit Card, Personal Unsecured Loan, Auto Loan, Mortgage Loan, Home Equity Loan, or Small Business Loan.
Last Statement Balance	The outstanding balance when the last statement was calculated and issued.
Minimum Payment Due	The minimum payment due as shown on the last statement.
Payment Due Date	The payment due date.
Cash Advance	The amount that is used as a cash advance.
Cash Advance Limit	The cash advance limit that is available on a credit card.
Total Limit	The total limit that is available on a credit card.
Last Payment Amount	The amount of the last payment that was made on the account.
Last Payment Date	The date that the last payment was made on the account.
Number of Days Past Due	The number of days that the account payment was past due in the current accounting period.
Amount Past Due	The amount of the past due payment in the current accounting period.
New Balance	The current balance reflecting all charges and payments.

Savings Account

View Savings Account information on the Financial Account page.

Savings Account Type	The savings account type. Values are: Regular/Money Market, Passbook, or Certificate of Deposit.
Account Balance	The available balance for the account showing funds that are available for withdrawal.
Average Balance	The average balance over the most recent accounting period.
Interest Rate	The interest rate paid on funds that are on deposit.
Current Balance	The current balance, which includes deposits that have not yet been cleared.
Last Deposit Date	The date of the last deposit.
Number of Overdrafts	The number of overdrafts in the most recent accounting period.
Days in Overdraft	The number of days that the account has been overdrawn in the current accounting period.
Account Fees	The fees that are charged to the account in the current accounting period.

See PeopleSoft Enterprise Banking Transactions 9.1 Preface.

Working with Relationships

Access the Financial Accounts - Relationships page (Customer Accounts, Review Financial Accounts, Financial Account, Relationships).

See Viewing and Maintaining Relationships and Roles.

Working with ATM Cards

Access the Financial Account - ATM Cards page (Customer Accounts, Review Financial Accounts, Financial Account, ATM Cards).

See Getting Started with PeopleSoft Enterprise Banking Transactions.

Viewing Terms and Conditions

Access the Financial Account - Terms and Conditions page (Customer Accounts, Review Financial Accounts, Financial Account, Terms and Conditions).

Displays the services and features that are included in the contract, and on what terms and conditions.

Viewing Fees

Access the Financial Account - Fees page (Customer Accounts, Review Financial Accounts, Financial Account, Fees).

The Fees page lists the Transaction Type that was performed on the account, and the cost of doing so.

Working with Cases

Access the Financial Account - Cases page (Customer Accounts, Review Financial Accounts, Financial Account, Cases).

The Cases page provides a summary of all cases associated with the account. To access the Case page and case details, select a specific case.

See Managing Cases.

Working with Applications

Access the Financial Account - Applications page (Customer Accounts, Review Financial Accounts, Financial Account, Applications).

To view a product application, select an application number from the Applications column.

See Getting Started with PeopleSoft Enterprise Banking Transactions, Getting Started with PeopleSoft Enterprise Policy and Claims Presentment.

Modifying Financial Accounts

This section provides an overview of account modification and discusses:

Modifying account fees.
Modifying account relationships.
Modifying credit card parameters
Modifying currency.
Modifying product.
Modifying status.
Modifying TIN type and number.

Understanding Account Modifications

PeopleSoft CRM delivers account modification functionality for financial services organization. These account features can be modified:

Account fee
Account relationships
Credit card parameters
Currency
Product
Status.
TIN type and number.

Each account modification request creates an case with the type of Modify Account. A business project is instantiated and associated with the case. The agent works through the phases and tasks in the business project and can close the case after the business project is closed. At the end of the business project a message is published to the legacy system reporting the changes requested. After the legacy system completes the modification request , then the system send a new and separate account creation message to reflect the changes in the CRM system.

Common Elements Used in this Section

Modification Type	Displays the modification type you chose to access the page.
Account Number	Select the account that is to be modified.
Transaction Status	Status of the transaction will be Open until the business project is complete. When the actual modification has taken place and the message is received from the legacy system, the transaction status is changed to Closed.

Pages Used to Modify Accounts

Page Name	Definition Name	Navigation	Usage
Modify Account	RBF_MODIF_ACCT	Customer Accounts, Modify Account, Modify Financial Account	Select the change to be made to the account. The system displays a unique page for each account modification type.
Modify Account - Account Fee	RBF_MODIF_ACCT	On the Modify Financial Account page, select the Account Fee modification type	Use this page to change the account fee on a specific account for a particular type of transaction.
Modify Account - Account Relationships	RBF_MODIF_ACCT	On the Modify Financial Account page, select the Account Relationships modification type	Use this page to change the relationship on an account.
Modify Account - Credit Card Parameters	RBF_MODIF_ACCT	On the Modify Financial Account page, select the Credit Card Parameters modification type	Use this page to change the limits on a credit card.
Modify Account - Currency	RBF_MODIF_ACCT	On the Modify Financial Account page, select the Currency modification type	Use this page to change the base currency of an account.
Modify Account - Product	RBF_MODIF_ACCT	On the Modify Financial Account page, select the Product modification type	Use this page to replace the current account product with a new product.
Modify Account - Status	RBF_MODIF_ACCT	On the Modify Financial Account page, select the Status modification type	Use this page to change the status of the account.
Modify Account - TIN Type and Number	RBF_MODIF_ACCT	On the Modify Financial Account page, select the TIN Type and Number modification type	Use this page to change the TIN type or number.
Reverse Transaction Fee	RBF_FEE_REVERSAL	On the 360-Degree View page, select Reverse Transaction Fee from the Go To drop-down list box. Click Go.	Use this page to reverse transaction fees that have been charged and paid.

Modifying Account Fees

Access the Modify Account: Account Fee page (Customer Accounts, Modify Account, Modify Financial Account, select the Account Fee modification type).

Transaction Type	Select the type of transaction to be modified.
Account Fee	Enter the new account fee.

Modifying Account Relationships

Access the Modify Account: Account Relationships page (Customer Accounts, Modify Account, Modify Financial Account, select the Account Relationships modification type).

Action	Select Add or Delete to change the account relationship.
Customer	Select the name of the customer to be added to or deleted from the relationship.
Relationship Type	Select the type of relationship that is being modified. Relationship types are established in the Customer Data Model component.

Modifying Credit Card Parameters

Access the Modify Account: Credit Card Parameters page (Customer Accounts, Modify Account, Modify Financial Account, select the Credit Card Parameters modification type).

Total Limit	Enter the new total chargeable limit on the credit card.
Cash Advance Limit	Enter the new total cash advance limit that is available on the credit card.

Modifying the Currency

Access the Modify Account: Currency page (Customer Accounts, Modify Account, Modify Financial Account, select the Currency modification type).

Currency Code

Enter the new base currency code for the account. Each account must be changed independently.

Modifying the Product

Access the Modify Account: Product page (Customer Accounts, Modify Account, Modify Financial Account, select the Product modification type).

Replacement Product

Select a replacement product for the current account. Options of the replacement product appear by default from the Product Relationship component.

Modifying the Status

Access the Modify Account: Status page (Customer Accounts, Modify Account, Modify Financial Account, select the Status modification type).

Status

Select the status of the account. Delivered values are Closed, Hold, Inactive, Open, Pending Close, and Pending Open.

Modifying the TIN Type and Number

Access the Modify Account: TIN Type and Number page (Customer Accounts, Modify Account, Modify Financial Account, select the TIN Type and Number modification type).

TIN Type	Select the new TIN type.
Tax ID	Enter the new tax ID.
Reason Code	Select a reason code for the change.
Reason	Enter a reason for the change.

Reversing Transaction Fees

Access the Reverse Transaction Fee page (on the 360-Degree View page, select Reverse Transaction Fee from the Go To drop-down list box and click Go.).

The agent can use the Reverse Transaction Fee page to reverse out fees that have already been charged and paid. All fields on this page are required.