HEDGE_TYPE_133CF=Cash Flow Hedge
FV=Fair Value Hedge
XAS=FX FV of Available-for-Sale
XCF=FX Cash Flow Hedge
XFC=FX FV of Firm Commitment
XNI=FX Hedge of Net Investment
TR_HDG_133_VW(SQL View) |
Index Back |
|---|---|
Treasury VAT dropdown list |
| SELECT %Substring(A.FIELDVALUE,1,3) ,A.XLATSHORTNAME ,A.XLATLONGNAME FROM PSXLATITEM A WHERE A.FIELDNAME='HEDGE_TYPE_133' AND A.EFFDT=( SELECT MAX(EFFDT) FROM PSXLATITEM WHERE FIELDNAME=A.FIELDNAME AND FIELDVALUE=A.FIELDVALUE AND EFFDT<=%CurrentDateIn) AND A.EFF_STATUS='A' |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | HEDGE_TYPE_133 |
Character(3) | VARCHAR2(3) NOT NULL |
Hedge type when FAS 133 is applied.
CF=Cash Flow Hedge FV=Fair Value Hedge XAS=FX FV of Available-for-Sale XCF=FX Cash Flow Hedge XFC=FX FV of Firm Commitment XNI=FX Hedge of Net Investment |
| 2 | XLATSHORTNAME | Character(10) | VARCHAR2(10) NOT NULL | Translate Value Short Name |
| 3 | XLATLONGNAME | Character(30) | VARCHAR2(30) NOT NULL | Translate Long Name |