TR_DASH_STATE3

(SQL Table)
Index Back

Position Impacts Header Record

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).
2 TR_DASH_GROUP Character(1) VARCHAR2(1) NOT NULL Dashboard Group
1=All Dashboards
2=Cash Position
3=Deal Management
4=Operational

Default Value: 1

3 TR_DASH_LIST Character(2) VARCHAR2(2) NOT NULL Dashboard list
01=Cash Position by Bank
02=Cash Position by Currency
03=Investment Mix
04=Debt Mix
05=Fixed vs. Floating rate Invest
06=Fixed vs. Floating rate Debt
07=Open Foreign Exchange Contract
08=Payments by Source
09=Payments by Status
1=Cash Position by Bank
10=Payments by Bank
11=Payments by Payment Method
12=Status of Bank Statement loads
14=Payments
15=CP By Bank
16=CP By BU
17=CP By Currency
18=CP By Source Set

Default Value: 1

4 DISPLAY_SOURCE Character(1) VARCHAR2(1) NOT NULL Display Summary

Y/N Table Edit

Default Value: Y

5 DISPLAY_CHART Character(1) VARCHAR2(1) NOT NULL Display Chart

Y/N Table Edit

Default Value: Y

6 DISPLAY_DRILL Character(1) VARCHAR2(1) NOT NULL Display Detail

Y/N Table Edit

Default Value: N

7 TR_CHART_TYPE Character(1) VARCHAR2(1) NOT NULL Chart Type
1=2D Bar
2=3D Bar

Default Value: 1

8 TR_CONTRACT_TYPE Character(1) VARCHAR2(1) NOT NULL Contract Type
B=Contract (Buy)
S=Contract (Sell)

Default Value: B