RBF_BILL_POL_VW (SQL View)	Index Back
List of policies Record returns a list of policies for a particular billing account

RBF_BILL_POL_VW

(SQL View)

List of policies

Record returns a list of policies for a particular billing account

SELECT A.RBTACCTID ,A.FIN_ACCOUNT_ID ,A.CUST_ACCT_NBR ,A.SYSTEM_SOURCE_CD ,A.REGISTRATION_NAME ,C.BO_NAME_DISPLAY FROM PS_RBF_FIN_ACCOUNT A , PS_RBT_ACCOUNT B , PS_BO_NAME C WHERE A.RBTACCTID = B.RBTACCTID AND A.BO_ID_OWNER = C.BO_ID AND C.PRIMARY_IND = 'Y'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 RBTACCTID Character(15) VARCHAR2(15) NOT NULL Unique service account indentifier

2 FIN_ACCOUNT_ID Character(20) VARCHAR2(20) NOT NULL Financial Account Number

3 CUST_ACCT_NBR Character(20) VARCHAR2(20) NOT NULL This is the Customer defined Account Number for a financial account

4 SYSTEM_SOURCE_CD Character(4) VARCHAR2(4) NOT NULL System Source Code
BSCS=BSCS

5 REGISTRATION_NAME Character(50) VARCHAR2(50) NOT NULL Registration Name --------> FSI Account

6 BO_NAME_DISPLAY Character(80) VARCHAR2(80) NOT NULL Full name of the Business Object

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	RBTACCTID	Character(15)	VARCHAR2(15) NOT NULL	Unique service account indentifier
2	FIN_ACCOUNT_ID	Character(20)	VARCHAR2(20) NOT NULL	Financial Account Number
3	CUST_ACCT_NBR	Character(20)	VARCHAR2(20) NOT NULL	This is the Customer defined Account Number for a financial account
4	SYSTEM_SOURCE_CD	Character(4)	VARCHAR2(4) NOT NULL	System Source Code BSCS=BSCS
5	REGISTRATION_NAME	Character(50)	VARCHAR2(50) NOT NULL	Registration Name --------> FSI Account
6	BO_NAME_DISPLAY	Character(80)	VARCHAR2(80) NOT NULL	Full name of the Business Object