TR_DASH_CP_CFG(SQL Table) |
Index Back |
|---|---|
Dashboard Configuration |
| # | 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 | SETID | Character(5) | VARCHAR2(5) NOT NULL |
SetID
Default Value: OPR_DEF_TBL_FS.SETID Prompt Table: CSH_FCST_VW_SID |
| 3 | WORKSHEET_ID | Character(20) | VARCHAR2(20) NOT NULL |
Cash Flows Worksheet ID
Prompt Table: WRKSHT_DEFN_VW |
| 4 | GROUP_BY_FIELD | Character(3) | VARCHAR2(3) NOT NULL |
Group By Field categorizes worksheet summary lines into various views. Example you can view the results by Business Unit, Bank Account and Currency (as delivered). We also provide generic fields for user defined values.
BAC=Bank Account BNK=Bank BU=Business Unit CUR=Currency GP1=Group By Field 1 GP2=Group By Field 2 GP3=Group By Field 3 GP4=Group By Field 4 GP5=Group By Field 5 GP6=Group By Field 6 GP7=Group By Field 7 WKS=Worksheet |
| 5 | SOURCE_SET | Character(20) | VARCHAR2(20) NOT NULL |
A field name describing a group od position sources.
Prompt Table: CSH_FCST_SS_VW |
| 6 | BUSINESS_UNIT | Character(5) | VARCHAR2(5) NOT NULL |
Business Unit
Prompt Table: SP_BU_FS_NONVW |
| 7 | BANK_CD | Character(5) | VARCHAR2(5) NOT NULL |
Bank Code
Prompt Table: BANK_CD_TBL |
| 8 | POSITION_CURRENCY | Character(3) | VARCHAR2(3) NOT NULL |
The transaction currency of a given position or exposure.
Prompt Table: POS_CURR_VW |
| 9 | CURRENCY_CD | Character(3) | VARCHAR2(3) NOT NULL |
Currency Code
Prompt Table: CURRENCY_CD_TBL |
| 10 | FROM_DATE | Date(10) | DATE | From Date |
| 11 | TO_DATE | Date(10) | DATE | To Date |
| 12 | COMPLETE | Character(1) | VARCHAR2(1) NOT NULL |
Yes/No field
N=No Y=Yes Default Value: N |