HIER_MAP_TBL

index back

PeopleSoft Field Name Field Type Column Type Description
DW_KEY Number(10,0) DECIMAL(10) NOT NULL Key

Default: HIER_CTRL_TBL.DW_KEY

HIERARCHY_KEY Number(10,0) DECIMAL(10) NOT NULL Dimension Key
COLUMN_ID Character(30) VARCHAR2(30) NOT NULL Column Name
COLUMN_TYPE Number(4,0) SMALLINT NOT NULL Column Type
DESCR Character(30) VARCHAR2(30) NOT NULL Description
LEVELS Number(3,0) SMALLINT NOT NULL Number of Levels
DIM_LEVEL_NAME Character(30) VARCHAR2(30) NOT NULL Dim Level Name
index back (c)David Kurtz 2019, www.go-faster.co.uk PeopleTools 8.54
PTRef generated on 09-JUN-19