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 |
index back |
|---|
| PeopleSoft Field Name | Field Type | Column Type | Description |
|---|---|---|---|
| DIMENSION_ID |
Character(30) | VARCHAR2(30) NOT NULL | Dimension/Measure/Attribute |
| SEQUENCE_NBR |
Number(2,0) | SMALLINT NOT NULL | Sequence Number |
| QRYNAME | Character(30) | VARCHAR2(30) NOT NULL |
Query Name
Prompt Table: %EDITTABLE12 |
| TREE_NODE | Character(20) | VARCHAR2(20) NOT NULL |
Node name
Prompt Table: NODE_DIM_VW |
| LEVELS_FROM_TOP | Number(3,0) | SMALLINT NOT NULL |
Levels From Top
Prompt Table: TREE_LVL_VW |
| 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 |
| DATA_SRC_NUM |
Number(4,0) | SMALLINT NOT NULL | Input Number |
| index back | (c)David Kurtz 2020, www.go-faster.co.uk | PeopleTools 8.58 PTRef generated on 21-DEC-20 |