DIM_DATA_SRC

index back

PeopleSoft Field NameField TypeColumn TypeDescription
DIMENSION_IDCharacter(30)VARCHAR2(30) NOT NULLDimension/Measure/Attribute
SEQUENCE_NBRNumber(2,0)SMALLINT NOT NULLSequence Number
QRYNAMECharacter(30)VARCHAR2(30) NOT NULLQuery Name

Prompt Table: %EDITTABLE12

TREE_NODECharacter(20)VARCHAR2(20) NOT NULLNode name

Prompt Table: NODE_DIM_VW

LEVELS_FROM_TOPNumber(3,0)SMALLINT NOT NULLLevels From Top

Prompt Table: TREE_LVL_VW

DIM_DATA_SRC_TYPECharacter(1)VARCHAR2(1) NOT NULLDimension Data Source Type
C=Calendar
L=Level Attribute Query
Q=Query
S=Operator Security
T=Tree
DATA_SRC_NUMNumber(4,0)SMALLINT NOT NULLInput Number
index back(c)David Kurtz 2019, www.go-faster.co.ukPeopleTools 8.54
PTRef generated on 09-JUN-19