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