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.
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.
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 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.
This section discusses integration requirements.
Two components must be configured for the integration to function correctly:
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.
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.
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)
PeopleSoft CRM delivers the flat file process—RBF_FIN_ITG—which runs to load a flat file depending on the configuration.
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
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_home\appserv\prcs\dbname\files).
This section discusses how to set up account defaults.
Page Name |
Object Name |
Navigation |
Usage |
RBF_OPTIONS |
Set Up CRM, Product Related, Financial Services, FSI Options |
Set up default values for a financial account. |
See Setting Up Industry-Specific Functionality.
This section discusses how to view financial account information.
Page Name |
Object Name |
Navigation |
Usage |
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. |
|
RBF_ACCT_RELATIONS |
Customer Accounts, Review Financial Account, Financial Account, Relationships |
View all relationships that are associated with the account. |
|
RBF_ACCT_ATM_CARDS |
Customer Accounts, Review Financial Account, Financial Account, ATM Cards |
View all ATM cards that are associated with the account. |
|
RBF_ACCT_ATTR |
Customer Accounts, Review Financial Account, Financial Account, Terms and Conditions |
View the terms and conditions that are associated with the account. |
|
RBF_FINACCT_FEES |
Customer Accounts, Review Financial Account, Financial Account, Fees |
View all account fees that are associated with the account. |
|
Financial Account - Claims |
RBI_CLAIM_HIST |
Customer Accounts, Review Financial Account, Financial Account, Claims |
View claims against insurance policies owned by the customer. |
RBF_ACTADR_HIST |
Customer Accounts, Review Financial Account, Financial Account, Address History |
View the address and audit history that is associated with the account. |
|
RBF_FIN_CASE_VW_PG |
Customer Accounts, Review Financial Accounts, Financial Account, Cases |
Tracks cases associated to the account. |
|
RBF_FIN_RO_HISTORY |
Customer Accounts, Review Financial Accounts, Financial Account, Applications |
Tracks history of customer applications for products and services. |
Access the Financial Account page.
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.
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 Dateand 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. |
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. |
View Insurance Account information on the Financial Account page.
All fields are defined in the PeopleSoft Policy and Claims Presentment PeopleBook.
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. |
View Credit Account information on the Financial Account page.
See PeopleSoft Enterprise Banking Transactions 9 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. |
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 Preface.
Access the Financial Accounts - Relationships page.
See Viewing and Maintaining Relationships and Roles.
Access the Financial Account - ATM Cards page.
See Getting Started with PeopleSoft Enterprise Banking Transactions.
Access the Financial Account - Terms and Conditions page.
Displays the services and features that are included in the contract, and on what terms and conditions.
Access the Financial Account - Fees page.
The Fees page lists the Transaction Type that was performed on the account, and the cost of doing so.
Access the Financial Account - Cases page.
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.
Access the Financial Account - Applications page.
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.
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.
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.
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. |
Page Name |
Object 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. |
Access the Modify Account: Account Fee page.
Transaction Type |
Select the type of transaction to be modified. |
Account Fee |
Enter the new account fee. |
Access the Modify Account: Account Relationships page.
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. |
Access the Modify Account: Credit Card Parameters page.
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. |
Access the Modify Account: Currency page.
Currency Code |
Enter the new base currency code for the account. Each account must be changed independently. |
Access the Modify Account: Product page.
Replacement Product |
Select a replacement product for the current account. Options of the replacement product appear by default from the Product Relationship component. |
Access the Modify Account: Status page.
Status |
Select the status of the account. Delivered values are Closed, Hold, Inactive, Open, Pending Close, and Pending Open. |
Access the Modify Account: TIN Type and Number page.
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. |
Access the Reverse Transaction Fee page.
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.