TR_FEEPOS_VW

(SQL View)
 Index Back

Facility Fee Position View

Position change due to Treasury Deal

SELECT BUSINESS_UNIT , TR_SOURCE_CD , TR_SOURCE_ID , TRANSACTION_LINE , SEQ_NBR , TRANSACTION_LEG , PERIOD_START_DT , 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 FROM PS_TRX_POSITION_TR

  • Parent record: TRX_DETAIL_TR

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
    2 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

    3 TR_SOURCE_ID Character(12) VARCHAR2(12) NOT NULL An internal work field that represents a unique identifier for records depicting a given treasury po
    4 TRANSACTION_LINE Number(3,0) SMALLINT NOT NULL The separate and distinct base instrument type components of a given deal transaction.
    5 FEE_SEQ_NUM Number(15,0) DECIMAL(15) NOT NULL Represents the sequential numbering of detail fee transactions within a given facility.
    6 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
    7 PERIOD_START_DT Date(10) DATE Represents the date commencement point for a given time set utilized in cash worksheet processing.

    Default Value: %date

    8 PERIOD_END_DT Date(10) DATE Represents the date termination point for a given time set utilized in cash worksheet processing.
    9 PD_INT_START_DT Date(10) DATE Represents the commencement date for calculating accrued interest for a given deal transa
    10 ASSET_LIABILITY Character(1) VARCHAR2(1) NOT NULL Whether the deal transaction leg represents an asset or a liability
    A=Asset
    L=Liability
    11 POSITION_CURRENCY Character(3) VARCHAR2(3) NOT NULL The transaction currency of a given position or exposure.
    12 PRINCIPAL_BALANCE Signed Number(28,3) DECIMAL(26,3) NOT NULL The notional principal balance of a given deal transaction at commencement.
    13 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
    14 START_INT_ACCRUAL Signed Number(28,3) DECIMAL(26,3) NOT NULL The initial start amount for a deal transaction's next interest accrual.
    15 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.
    16 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
    17 ANCHOR_CURRENCY Character(3) VARCHAR2(3) NOT NULL The base currency of the business unit that generates a given deal transaction.
    18 ANCHOR_AMOUNT Signed Number(28,3) DECIMAL(26,3) NOT NULL Principal amount of a given deal transaction denominated in the anchor currency.
    19 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
    20 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
    21 FORWARD_RATE_MULT Number(16,8) DECIMAL(15,8) NOT NULL An internal convention utilized for determing whether a currency exchange forward rate is
    22 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
    23 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
    24 TRANSACTION_RATE Number(16,8) DECIMAL(15,8) NOT NULL The applicable interest rate for a given deal transaction.
    25 RATE_RESET_DT Date(10) DATE The date that an interest rate quoted in the market is captured for purposes of calculating interest