PeopleSoft 9.0 Cash Management |
Table Name | HDG_HEDGE |
Table Description |
HDG_HEDGE |
Columns |
Name | Datatype | Is PK | Is FK |
BUSINESS_UNIT | CHAR(5) | Yes | Yes |
HEDGE_ID | CHAR(12) | Yes | No |
HEDGE_STATUS | CHAR(1) | No | No |
HEDGE_TYPE | CHAR(3) | No | No |
HEDGE_TYPE_133 | CHAR(3) | No | Yes |
DESCR60 | CHAR(60) | No | No |
HEDGED_RISK_OTHER | CHAR(1) | No | No |
HEDGED_RISK_NAME | CHAR(15) | No | No |
DESCR254 | CHAR(254) | No | No |
RSK_COMMENTS | CHAR(254) | No | No |
INCEPTION_DT | PSDATE | No | No |
INCEPTION_OPRID | CHAR(30) | No | No |
HEDGE_STRATEGY_CD | CHAR(10) | No | Yes |
HEDGED_RISK_OVERAL | CHAR(1) | No | No |
HEDGED_RISK_IR | CHAR(1) | No | No |
HEDGED_RISK_FX | CHAR(1) | No | No |
HEDGED_RISK_CREDIT | CHAR(1) | No | No |
HEDGE_EF_ASES_CD | CHAR(3) | No | No |
HEDGE_EF_ASES_P_CD | CHAR(3) | No | No |
HEDGE_INEF_MTHD | CHAR(3) | No | No |
HEDGE_SHORTCUT | CHAR(1) | No | No |
HEDGE_EF_ASES_OFST | CHAR(2) | No | No |
DISCONTINUE_DT | PSDATE | No | No |
DISCONTINUE_OPRID | CHAR(30) | No | No |
EVENT_TRACKING_ID | DECIMAL(10) | No | No |
NOTES_1000 | TEXT | No | No |
Index |
Name | Type | Unique | Member |
PS_HDG_HEDGE | PK | Yes |
![]() |
PS0HDG_HEDGE | IE1 | No |
![]() |
PS1HDG_HEDGE | IE6 | No |
![]() |
PS2HDG_HEDGE | IE7 | No |
![]() |
PS3HDG_HEDGE | IE8 | No |
![]() |
Member(s) of "PS_HDG_HEDGE" Index |
BUSINESS_UNIT |
HEDGE_ID |
Member(s) of "PS0HDG_HEDGE" Index |
HEDGE_STATUS |
BUSINESS_UNIT |
HEDGE_ID |
Member(s) of "PS1HDG_HEDGE" Index |
HEDGE_TYPE |
BUSINESS_UNIT |
HEDGE_ID |
Member(s) of "PS2HDG_HEDGE" Index |
HEDGE_TYPE_133 |
BUSINESS_UNIT |
HEDGE_ID |
Member(s) of "PS3HDG_HEDGE" Index |
DESCR60 |
BUSINESS_UNIT |
HEDGE_ID |
Published April 30, 2007 |