RBF_INVESTMENT

(SQL Table)
 Index Back

Investment Record

This is record is used to store FSI Investment Account data

  • Parent record: RBF_INVEST_ACCT

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 FIN_ACCOUNT_ID Character(20) VARCHAR2(20) NOT NULL Financial Account Number
    2 INVESTMNT_ACCT_TYP Character(3) VARCHAR2(3) NOT NULL investment account type
    401=401K
    BRK=Brokerage
    ESP=ESPP
    INV=Investment Management
    IRA=IRA
    MAR=Margin
    OPT=Option Account
    SEC=Securities Custody
    TRT=Trust
    3 CUSIP Character(20) VARCHAR2(20) NOT NULL CUSIp
    4 INV_DATE Date(10) DATE Date the shares were acquired
    5 STOCK_SYMBOL Character(10) VARCHAR2(10) NOT NULL This field is used to store the Stock Symbol
    6 QUANTITY Signed Number(17,4) DECIMAL(15,4) NOT NULL Qty Interface
    7 CURRENT_VALUE Signed Number(30,4) DECIMAL(28,4) NOT NULL Security current value
    8 TOTAL_CASH Signed Number(30,4) DECIMAL(28,4) NOT NULL Total cash in the account
    9 SECURITY_NAME Character(30) VARCHAR2(30) NOT NULL security name ----------fsi
    10 DIVIDEND_DATE Date(10) DATE Dividend Date
    11 DIVIDEND_PER_SHARE Signed Number(30,4) DECIMAL(28,4) NOT NULL Dividend per share
    12 DIVIDEND_AMT Signed Number(30,4) DECIMAL(28,4) NOT NULL Dividend Amount
    13 DIVIDEND_DESC Character(30) VARCHAR2(30) NOT NULL Dividend Description
    14 DIV_REINVESTMENT Character(1) VARCHAR2(1) NOT NULL Dividend Reinvestment Flag
    N=No
    Y=Yes
    15 LT_CAP_GAINLOSS_DT Date(10) DATE gain loss date
    16 LT_CAP_GAINLOS_AMT Signed Number(30,4) DECIMAL(28,4) NOT NULL gain loss amount
    17 LT_CAP_GAINLOS_DES Character(20) VARCHAR2(20) NOT NULL gain loss destination
    18 ST_CAP_GAINLOSS_DT Date(10) DATE Short Term Capital GainLoss Date
    19 ST_CAP_GAINLOS_AMT Signed Number(30,4) DECIMAL(28,4) NOT NULL Short Term Cap Gain/Loss
    20 ST_CAP_GAINLOS_DES Character(20) VARCHAR2(20) NOT NULL Short Term Capital Gain/Loss Descr
    21 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL This field stores the Currency Code value.

    Prompt Table: CURRENCY_CD_TBL

    22 ASSET_CATEG_ID Character(15) VARCHAR2(15) NOT NULL This field is the primary key for Asset category table

    Prompt Table: RBW_ASSET_CATEG

    23 ROW_ADDED_DTTM DateTime(26) TIMESTAMP This is a datetime field for record creation.
    24 ROW_ADDED_OPRID Character(30) VARCHAR2(30) NOT NULL ID of user who added the row.
    25 ROW_LASTMANT_DTTM DateTime(26) TIMESTAMP The date and time that the row was last updated.
    26 ROW_LASTMANT_OPRID Character(30) VARCHAR2(30) NOT NULL ID of user who last modified the row.
    27 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.
    28 SYNCDTTM DateTime(26) TIMESTAMP Synchronization Last Update Date Time