RBI_CHNG_POL_VW (SQL View)	Index Back
Review Change Policy Search Review Change Policy Search record for the review change policy request component

RBI_CHNG_POL_VW

(SQL View)

Review Change Policy Search

Review Change Policy Search record for the review change policy request component

SELECT A.TRANSACTION_NO ,B.CUST_ACCT_NBR , B.REGISTRATION_NAME , C.RBTACTION_NAME FROM PS_RBI_CHNG_POLICY A , PS_RBF_FIN_ACCOUNT B , PS_RBT_ACTION C WHERE A.FIN_ACCOUNT_ID = B.FIN_ACCOUNT_ID AND C.SETID = A.SETID AND C.RBTACTION_ID = A.MODIFICATION_TYPE

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 TRANSACTION_NO Character(15) VARCHAR2(15) NOT NULL Transaction table's primary key.

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

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

4 RBTACTION_NAME Character(30) VARCHAR2(30) NOT NULL Action Name

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	TRANSACTION_NO	Character(15)	VARCHAR2(15) NOT NULL	Transaction table's primary key.
2	CUST_ACCT_NBR	Character(20)	VARCHAR2(20) NOT NULL	This is the Customer defined Account Number for a financial account
3	REGISTRATION_NAME	Character(50)	VARCHAR2(50) NOT NULL	Registration Name --------> FSI Account
4	RBTACTION_NAME	Character(30)	VARCHAR2(30) NOT NULL	Action Name