DIM_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 2019, www.go-faster.co.uk PeopleTools 8.54
PTRef generated on 09-JUN-19