RBF_ALT_ACCT_VW

(SQL View)
 Index Back

Alt Cap Accounts tab

View is used to display Alt Cap Accounts

SELECT c.ALT_CAP_ID , a.FIN_ACCOUNT_ID ,a.CUST_ACCT_NBR , a.FIN_ACCOUNT_TYPE , a.FIN_ACCT_NICKNAME , a.FIN_ACCOUNT_STATUS FROM PS_RBF_ALT_CAP c , PS_RBF_FIN_ACCOUNT a WHERE c.BO_ID = a.BO_ID_OWNER

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 ALT_CAP_ID Character(15) VARCHAR2(15) NOT NULL Alternate Capacity ID
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 FIN_ACCOUNT_TYPE Character(3) VARCHAR2(3) NOT NULL Account type
CHK=Checking
CRE=Credit
INV=Investment
LON=Loan
POL=Insurance
SAV=Savings
5 FIN_ACCT_NICKNAME Character(20) VARCHAR2(20) NOT NULL Accoutn nickname -------->FSI Account
6 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