TR_DASH_STATE

(SQL Table)
Index Back

Treasury Dashboard user state

# 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_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
3 DISPLAY_SOURCE Character(1) VARCHAR2(1) NOT NULL Display Summary

Y/N Table Edit

Default Value: Y

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

Y/N Table Edit

Default Value: Y

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

Y/N Table Edit

Default Value: N