RBI_INSPOL_VW (SQL View)	Index Back
Policy View This view is used to populate the drop down for the account number field on the Change Policy component

RBI_INSPOL_VW

(SQL View)

Policy View

This view is used to populate the drop down for the account number field on the Change Policy component

SELECT DISTINCT BUS_CONTACT_ID , FIN_ACCOUNT_ID , rtrim(CUST_ACCT_NBR) %Concat ' (' %Concat rtrim(FIN_ACCT_NICKNAME) %Concat ')' FROM PS_RBF_SRTY_MATRIX a , PS_RBF_FIN_ACCOUNT b WHERE a.ACCOUNT_REF_ID = b.BO_ID AND a.SRTY_FUNCTION_CD IN ('ALL','CPOL') AND a.APPROVAL_FLG = 'Y' AND b.FIN_ACCOUNT_STATUS = 'OPE' AND b.FIN_ACCOUNT_TYPE = 'POL'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 BO_ID Signed Number(32,0) DECIMAL(31) NOT NULL Business Object ID

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

3 NAME_DISPLAY Character(50) VARCHAR2(50) NOT NULL Business Name Display. BO_NAME.NAME_DISPLAY

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	BO_ID	Signed Number(32,0)	DECIMAL(31) NOT NULL	Business Object ID
2	FIN_ACCOUNT_ID	Character(20)	VARCHAR2(20) NOT NULL	Financial Account Number
3	NAME_DISPLAY	Character(50)	VARCHAR2(50) NOT NULL	Business Name Display. BO_NAME.NAME_DISPLAY