HIER_MAP_TBL

index back

PeopleSoft Field NameField TypeColumn TypeDescription
DW_KEYNumber(10,0)DECIMAL(10) NOT NULLKey

Default: HIER_CTRL_TBL.DW_KEY

HIERARCHY_KEYNumber(10,0)DECIMAL(10) NOT NULLDimension Key
COLUMN_IDCharacter(30)VARCHAR2(30) NOT NULLColumn Name
COLUMN_TYPENumber(4,0)SMALLINT NOT NULLColumn Type
DESCRCharacter(30)VARCHAR2(30) NOT NULLDescription
LEVELSNumber(3,0)SMALLINT NOT NULLNumber of Levels
DIM_LEVEL_NAMECharacter(30)VARCHAR2(30) NOT NULLDim Level Name
index back(c)David Kurtz 2019, www.go-faster.co.ukPeopleTools 8.54
PTRef generated on 09-JUN-19