RCF_FIN_ACCT_VW

(SQL View)
 Index Back

Financial Account

Call Center owned view of the financial account record.

SELECT A.FIN_ACCOUNT_ID , A.BO_ID , A.PROD_SETID , A.PRODUCT_ID , A.FIN_ACCOUNT_TYPE , A.REGISTRATION_NAME , A.FIN_ACCT_NICKNAME , A.BO_ID_OWNER , A.OWNER_BO_TYPE , A.CM_ID , A.REGISTRATION_TYPE , A.FIN_ACCOUNT_STATUS , A.BEGIN_DATE , A.END_DATE , A.CURRENCY_CD , A.COUNTRY , A.NATIONAL_ID_TYPE , A.TIN_TYPE , A.TIN , A.LAST_STATEMENT_DT , A.LAST_REFRESH_DTTM , A.LONG_LINK , A.BILL_PAY_ENABLED , A.ACNT_ID , A.RBTACCTID , A.CUST_ACCT_NBR , A.SYSTEM_SOURCE_CD , A.AGENCY_BO_ID , A.WHERE_HELD , A.YTD_FEE , A.FEE_BASIS , A.LAST_YEAR_FEE , A.BO_ID_PARTNER , A.ROLE_TYPE_ID_PART , A.BO_ID_PART_CONT , A.ROLE_TYPE_ID_PARTC , A.CONFIG_CODE , %subrec(RB_audit_sbr, A) 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 BO_ID Signed Number(32,0) DECIMAL(31) NOT NULL Business Object ID
3 PROD_SETID Character(5) VARCHAR2(5) NOT NULL Product SET ID

Default Value: OPR_DEF_TBL_RB.SETID

Prompt Table: SP_SETID_NONVW

4 PRODUCT_ID Character(18) VARCHAR2(18) NOT NULL Product ID

Prompt Table: RBF_ACCT_PRD_VW
Set Control Field: PROD_SETID

5 FIN_ACCOUNT_TYPE Character(3) VARCHAR2(3) NOT NULL Account type
CHK=Checking
CRE=Credit
INV=Investment
LON=Loan
POL=Insurance
SAV=Savings
6 REGISTRATION_NAME Character(50) VARCHAR2(50) NOT NULL Registration Name --------> FSI Account
7 FIN_ACCT_NICKNAME Character(20) VARCHAR2(20) NOT NULL Accoutn nickname -------->FSI Account
8 BO_ID_OWNER Number(31,0) DECIMAL(31) NOT NULL Financial Account Business Object ID

Prompt Table: BO

9 OWNER_BO_TYPE Character(3) VARCHAR2(3) NOT NULL owner of the bo type
ALT=Alternate Capacity
COM=Company
PAR=Partnership
PER=Person
10 CM_ID Number(31,0) DECIMAL(31) NOT NULL Contact Method ID
11 REGISTRATION_TYPE Character(3) VARCHAR2(3) NOT NULL registration type
BEN=Named Beneficiary
COM=Community Property
COR=Corporation
CUS=Custodial Account for Minor
IND=Individual
JOI=Joint w Right of Survivorship
OTH=Other
PAR=Partnership or LLC
SOL=Sole Proprietorship
TEN=Tenants in Common
TRU=Trust
12 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
13 BEGIN_DATE Date(10) DATE Begin Date
14 END_DATE Date(10) DATE End date field to store an end date.
15 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL This field stores the Currency Code value.

Prompt Table: CURRENCY_CD_TBL

16 COUNTRY Character(3) VARCHAR2(3) NOT NULL Country
17 NATIONAL_ID_TYPE Character(6) VARCHAR2(6) NOT NULL National ID Type

Prompt Table: NID_TYPE1_VW

18 TIN_TYPE Character(1) VARCHAR2(1) NOT NULL Tin Type
F=Federal Employer ID
S=Social Security Number
19 TIN Character(20) VARCHAR2(20) NOT NULL TIN
20 LAST_STATEMENT_DT Date(10) DATE last_statement date ----fsi
21 LAST_REFRESH_DTTM DateTime(26) TIMESTAMP last refresh datetime
22 LONG_LINK Long Character(2000) VARCHAR2(2000) long character field for account
23 BILL_PAY_ENABLED Character(1) VARCHAR2(1) NOT NULL Bill Payment enabled flag
N=No
Y=Yes
24 ACNT_ID Character(18) VARCHAR2(18) NOT NULL Contract ID
25 RBTACCTID Character(15) VARCHAR2(15) NOT NULL Unique service account indentifier

Prompt Table: RBT_ACCOUNT

26 CUST_ACCT_NBR Character(20) VARCHAR2(20) NOT NULL This is the Customer defined Account Number for a financial account
27 SYSTEM_SOURCE_CD Character(4) VARCHAR2(4) NOT NULL System Source Code
BSCS=BSCS
28 AGENCY_BO_ID Number(31,0) DECIMAL(31) NOT NULL Agency BO ID
29 WHERE_HELD Character(50) VARCHAR2(50) NOT NULL Institution at which a certain asset is held
30 YTD_FEE Number(29,4) DECIMAL(28,4) NOT NULL Fees charged to a Client this year
31 FEE_BASIS Character(4) VARCHAR2(4) NOT NULL Time period by which fees are charged, such as monthly or annually
ANNU=Annually
MONT=Monthly
32 LAST_YEAR_FEE Number(29,4) DECIMAL(28,4) NOT NULL Fees charged to a Client during the last year
33 BO_ID_PARTNER Signed Number(32,0) DECIMAL(31) NOT NULL Business Object ID of Partner Company.

Prompt Table: BO

34 ROLE_TYPE_ID_PART Number(12,0) DECIMAL(12) NOT NULL Stores ROLE_TYPE_ID for the partner
35 BO_ID_PART_CONT Signed Number(32,0) DECIMAL(31) NOT NULL This is the business object identifier for the partner contact.

Prompt Table: BO

36 ROLE_TYPE_ID_PARTC Number(12,0) DECIMAL(12) NOT NULL Stores ROLE_TYPE_ID for the partner contact
37 CONFIG_CODE Character(50) VARCHAR2(50) NOT NULL Product Configurator
38 ROW_ADDED_DTTM DateTime(26) TIMESTAMP This is a datetime field for record creation.
39 ROW_ADDED_OPRID Character(30) VARCHAR2(30) NOT NULL ID of user who added the row.
40 ROW_LASTMANT_DTTM DateTime(26) TIMESTAMP The date and time that the row was last updated.
41 ROW_LASTMANT_OPRID Character(30) VARCHAR2(30) NOT NULL ID of user who last modified the row.
42 SYNCID Number(10,0) DECIMAL(10) NOT NULL The Synchronization ID field stores a value generated by the sync processor. The value is used to identify the type of object that the sync processor is about to handle.
43 SYNCDTTM DateTime(26) TIMESTAMP Synchronization Last Update Date Time