FCLTY_FEEPOS_VW

(SQL View)
 Index Back

Facility Fee Position View

Position change due to Treasury Deal

SELECT TR_SOURCE_ID , TRANSACTION_LINE , SEQ_NBR , TRANSACTION_LEG , PERIOD_START_DT , BUSINESS_UNIT , PERIOD_END_DT , PD_INT_START_DT , ASSET_LIABILITY , POSITION_CURRENCY , PRINCIPAL_BALANCE , PERIOD_INT_ACCRUAL , START_INT_ACCRUAL , DISCOUNT_AMT , START_DISCOUNT_AMT , ANCHOR_CURRENCY , ANCHOR_AMOUNT , SPOT_RATE_MULT , SPOT_RATE_DIV , FORWARD_RATE_MULT , FORWARD_RATE_DIV , RESET_RATE_SET , TRANSACTION_RATE , RATE_RESET_DT , TR_SOURCE_CD FROM PS_TRX_POSITION_TR WHERE TR_SOURCE_CD = 'F'

  • Parent record: TRX_DETAIL_TR

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 FCLTY_ID Character(12) VARCHAR2(12) NOT NULL A unique key identifier that represents a given counterparty facility.
    2 TRANSACTION_LINE Number(3,0) SMALLINT NOT NULL The separate and distinct base instrument type components of a given deal transaction.
    3 FEE_SEQ_NUM Number(15,0) DECIMAL(15) NOT NULL Represents the sequential numbering of detail fee transactions within a given facility.
    4 TRANSACTION_LEG Number(1,0) SMALLINT NOT NULL The separate and distinct business positions of a given deal transaction line.
    1=Pay Leg
    2=Receive Leg
    5 PERIOD_START_DT Date(10) DATE Represents the date commencement point for a given time set utilized in cash worksheet processing.

    Default Value: %date

    6 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
    7 PERIOD_END_DT Date(10) DATE Represents the date termination point for a given time set utilized in cash worksheet processing.
    8 PD_INT_START_DT Date(10) DATE Represents the commencement date for calculating accrued interest for a given deal transa
    9 ASSET_LIABILITY Character(1) VARCHAR2(1) NOT NULL Whether the deal transaction leg represents an asset or a liability
    A=Asset
    L=Liability
    10 POSITION_CURRENCY Character(3) VARCHAR2(3) NOT NULL The transaction currency of a given position or exposure.
    11 PRINCIPAL_BALANCE Signed Number(28,3) DECIMAL(26,3) NOT NULL The notional principal balance of a given deal transaction at commencement.
    12 PERIOD_INT_ACCRUAL Signed Number(28,3) DECIMAL(26,3) NOT NULL Represents the amount of accrued interest attributable to an interest period for a given
    13 START_INT_ACCRUAL Signed Number(28,3) DECIMAL(26,3) NOT NULL The initial start amount for a deal transaction's next interest accrual.
    14 DISCOUNT_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Represents the discount amount deducted from the par price of a given deal transaction such as a bond.
    15 START_DISCOUNT_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Internal field utilized to determine the appropriate accrual accounting amount for a giv
    16 ANCHOR_CURRENCY Character(3) VARCHAR2(3) NOT NULL The base currency of the business unit that generates a given deal transaction.
    17 ANCHOR_AMOUNT Signed Number(28,3) DECIMAL(26,3) NOT NULL Principal amount of a given deal transaction denominated in the anchor currency.
    18 SPOT_RATE_MULT Number(16,8) DECIMAL(15,8) NOT NULL An internal convention utilized for determing whether a currency exchange spot rate is stored ei
    19 SPOT_RATE_DIV Number(16,8) DECIMAL(15,8) NOT NULL An internal convention utilized for determing whether a currency exchange spot rate is stored either
    20 FORWARD_RATE_MULT Number(16,8) DECIMAL(15,8) NOT NULL An internal convention utilized for determing whether a currency exchange forward rate is
    21 FORWARD_RATE_DIV Number(16,8) DECIMAL(15,8) NOT NULL An internal convention utilized for determing whether a currency exchange forward rate is stor
    22 RESET_RATE_SET Character(1) VARCHAR2(1) NOT NULL Allows the user to indicate that a floating rate for a particular cash flow has been ascertained and e
    N=Rate Not Set
    Y=Reset Rate Set
    23 TRANSACTION_RATE Number(16,8) DECIMAL(15,8) NOT NULL The applicable interest rate for a given deal transaction.
    24 RATE_RESET_DT Date(10) DATE The date that an interest rate quoted in the market is captured for purposes of calculating interest
    25 TR_SOURCE_CD Character(1) VARCHAR2(1) NOT NULL Note: Changes to Translate Values must also be made to TRA_SOURCE_CD and SOURCE_TYPE. These 3 fields must be kept in sync. Values that are inactive are for use in TR Accounting only
    B=BSP
    D=Deals
    E=Deal Fees
    F=Facility Fees
    H=Hedges
    I=Interest
    M=Deal: Estimated Maturity Accr
    N=Netted Deal
    O=Other
    P=Investment Pools
    R=EFT Fees
    S=Securities
    T=LC Fees
    W=EFT Requests
    X=Bank Transfers

    Default Value: F