RBF_SRT_CACT_VW (SQL View)	Index Back
Sec Matrix account view Security matrix config search view for customer account number

RBF_SRT_CACT_VW

(SQL View)

Sec Matrix account view

Security matrix config search view for customer account number

SELECT CUST_ACCT_NBR ,SYSTEM_SOURCE_CD , FIN_ACCT_NICKNAME FROM PS_RBF_FIN_ACCOUNT

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

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

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

3 FIN_ACCT_NICKNAME Character(20) VARCHAR2(20) NOT NULL Accoutn nickname -------->FSI Account

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	CUST_ACCT_NBR	Character(20)	VARCHAR2(20) NOT NULL	This is the Customer defined Account Number for a financial account
2	SYSTEM_SOURCE_CD	Character(4)	VARCHAR2(4) NOT NULL	System Source Code BSCS=BSCS
3	FIN_ACCT_NICKNAME	Character(20)	VARCHAR2(20) NOT NULL	Accoutn nickname -------->FSI Account