FACT_MAP_TBL

index back

PeopleSoft Field Name Field Type Column Type Description
DW_KEY Number(10,0) DECIMAL(10) NOT NULL Key
ELEMENT_TYPE Character(6) VARCHAR2(6) NOT NULL Element Type
A=Attribute
D=Dimension
M=Measure
DIMENSION_KEY Number(10,0) DECIMAL(10) NOT NULL Dimension Key
COLUMN_ID Character(30) VARCHAR2(30) NOT NULL Column Name
DESCR Character(30) VARCHAR2(30) NOT NULL Description
ROLLED_LEVEL Number(3,0) SMALLINT NOT NULL Rolled Level
index back (c)David Kurtz 2019, www.go-faster.co.uk PeopleTools 8.54
PTRef generated on 09-JUN-19