DIMENSION_IDSEQUENCE_NBRPrompt Table: %EDITTABLE12
Prompt Table: NODE_DIM_VW
Prompt Table: TREE_LVL_VW
C=Calendar
L=Level Attribute Query
Q=Query
S=Operator Security
T=Tree
DATA_SRC_NUMDIM_DATA_SRC(SQL Table) |
Index Back |
|---|
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | DIMENSION_ID |
Character(30) | VARCHAR2(30) NOT NULL | Dimension/Measure/Attribute |
| 2 | SEQUENCE_NBR |
Number(2,0) | SMALLINT NOT NULL | Sequence Number |
| 3 | QRYNAME | Character(30) | VARCHAR2(30) NOT NULL |
Query Name
Prompt Table: %EDITTABLE12 |
| 4 | TREE_NODE | Character(20) | VARCHAR2(20) NOT NULL |
Node name
Prompt Table: NODE_DIM_VW |
| 5 | LEVELS_FROM_TOP | Number(3,0) | SMALLINT NOT NULL |
Levels From Top
Prompt Table: TREE_LVL_VW |
| 6 | DIM_DATA_SRC_TYPE | Character(1) | VARCHAR2(1) NOT NULL |
Dimension Data Source Type
C=Calendar L=Level Attribute Query Q=Query S=Operator Security T=Tree |
| 7 | DATA_SRC_NUM |
Number(4,0) | SMALLINT NOT NULL | Input Number |