HDG_ASSESS_REQ(SQL Table) |
Index Back |
---|---|
Treasury - Hedge Run Cntl Tbl |
# | 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 |