HDG_ASSESS_REQ

(SQL Table)
Index Back

Treasury - Hedge Run Cntl Tbl

  • Parent record: PRCSRUNCNTL
  • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit

    Default Value: OPR_DEF_TBL_FS.BUSINESS_UNIT

    Prompt Table: SP_BU_GL_NONVW

    2 HEDGE_ID Character(12) VARCHAR2(12) NOT NULL Hedge ID identifies the designation of Hedging Deals (Instruments) as being the Hedge of Hedged Items

    Prompt Table: HDG_HEDGE

    3 ASSESSMENT_DTTIME DateTime(26) TIMESTAMP NOT NULL Current date and time

    Default Value: %datetime

    4 ASSESSMENT_DT Date(10) DATE NOT NULL Assessment Date Type

    Default Value: %date

    5 BEGIN_DT Date(10) DATE NOT NULL Begin Date
    6 END_DT Date(10) DATE NOT NULL End Date
    7 FROM_YEAR Number(4,0) SMALLINT NOT NULL From Year
    8 FROM_PERIOD Number(3,0) SMALLINT NOT NULL From Period
    9 TO_YEAR Number(4,0) SMALLINT NOT NULL To Year
    10 TO_PERIOD Number(3,0) SMALLINT NOT NULL To Period
    11 CALENDAR_SETID Character(5) VARCHAR2(5) NOT NULL Calendar SetID
    12 CALENDAR_ID Character(2) VARCHAR2(2) NOT NULL Calendar ID

    Prompt Table: CAL_DEFN_TBL