ANALYSIS_MODEL_IDDefault Value: ANL_MOD_DAT_SRC.ANALYSIS_MODEL_ID
QRYNAMEDefault Value: ANL_MOD_DAT_SRC.QRYNAME
Prompt Table: QRY_FLD_HDNG_VW
Prompt Table: ANL_MOD_DIM
Default Value: 1
ANL_MOD_DIM_FLD(SQL Table) |
Index Back |
|---|
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | ANALYSIS_MODEL_ID |
Character(15) | VARCHAR2(15) NOT NULL |
Cube Definition ID
Default Value: ANL_MOD_DAT_SRC.ANALYSIS_MODEL_ID |
| 2 | QRYNAME |
Character(30) | VARCHAR2(30) NOT NULL |
Query Name
Default Value: ANL_MOD_DAT_SRC.QRYNAME |
| 3 | QRYFLDNAME | Character(30) | VARCHAR2(30) NOT NULL |
Source Field
Prompt Table: QRY_FLD_HDNG_VW |
| 4 | DIMENSION_ID | Character(30) | VARCHAR2(30) NOT NULL |
Dimension/Measure/Attribute
Prompt Table: ANL_MOD_DIM |
| 5 | COMPONENT_NBR | Number(3,0) | SMALLINT NOT NULL |
Component Number
Default Value: 1 |