RBF_FNACT_CI_VW

(SQL View)
 Index Back

RBF_FNACT_CI_VW -- For CI

This view: RBF_FACNT_CI_VW is based on record: RBF_FIN_ACCOUNT. As delivered, this view does not contain any PeopleCode and is used in Component Interface (CI) components only. Whenever the structure of the underlying record changes, this view must be modified accordingly.

SELECT A.FIN_ACCOUNT_ID , A.FIN_ACCOUNT_TYPE , A.FIN_ACCT_NICKNAME , A.FIN_ACCOUNT_STATUS FROM PS_RBF_FIN_ACCOUNT A

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 FIN_ACCOUNT_ID Character(20) VARCHAR2(20) NOT NULL Financial Account Number
2 FIN_ACCOUNT_TYPE Character(3) VARCHAR2(3) NOT NULL Account type
CHK=Checking
CRE=Credit
INV=Investment
LON=Loan
POL=Insurance
SAV=Savings
3 FIN_ACCT_NICKNAME Character(20) VARCHAR2(20) NOT NULL Accoutn nickname -------->FSI Account
4 FIN_ACCOUNT_STATUS Character(3) VARCHAR2(3) NOT NULL Financial account status
CLO=Closed
HLD=Hold
INA=Inactive
OPE=Open
PC=Pending Close
PO=Pending Open