ANALYSIS_DB_IDQRYNAMEPrompt Table: QUERY_DIM_VW
Prompt Table: QRY_FLD_HDNG_VW
Prompt Table: QRY_FLD_HDNG_VW
Prompt Table: QRY_FLD_HDNG_VW
Prompt Table: QRY_FLD_HDNG_VW
Prompt Table: QRY_FLD_HDNG_VW
Default Value: US$
ANL_DB_QRY_ESS(SQL Table) |
Index Back |
|---|
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | ANALYSIS_DB_ID |
Character(15) | VARCHAR2(15) NOT NULL | Cube Instance ID |
| 2 | QRYNAME |
Character(30) | VARCHAR2(30) NOT NULL |
Query Name
Prompt Table: QUERY_DIM_VW |
| 3 | RATE_CUBE_TIME | Character(30) | VARCHAR2(30) NOT NULL |
Rate Cube Time Dimension Field
Prompt Table: QRY_FLD_HDNG_VW |
| 4 | RATE_CUBE_CURR_NAM | Character(30) | VARCHAR2(30) NOT NULL |
Rate Country Name Dim Field
Prompt Table: QRY_FLD_HDNG_VW |
| 5 | RATE_CUBE_CURR_CAT | Character(30) | VARCHAR2(30) NOT NULL |
Rate Account Dim Field
Prompt Table: QRY_FLD_HDNG_VW |
| 6 | RATE_CUBE_CURR_TYP | Character(30) | VARCHAR2(30) NOT NULL |
Rate Currency Type
Prompt Table: QRY_FLD_HDNG_VW |
| 7 | RATE_CUBE_CURR_AMT | Character(30) | VARCHAR2(30) NOT NULL |
Rate Cube Curr Amount Field
Prompt Table: QRY_FLD_HDNG_VW |
| 8 | RATE_CURR_DEF_NAME | Character(30) | VARCHAR2(30) NOT NULL |
Default Currency Name
Default Value: US$ |
| 9 | RATE_CURR_DEF_CAT | Character(30) | VARCHAR2(30) NOT NULL | Default Currency Category |