FACT_MAP_TBL

index back

PeopleSoft Field NameField TypeColumn TypeDescription
DW_KEYNumber(10,0)DECIMAL(10) NOT NULLKey
ELEMENT_TYPECharacter(6)VARCHAR2(6) NOT NULLElement Type
A=Attribute
D=Dimension
M=Measure
DIMENSION_KEYNumber(10,0)DECIMAL(10) NOT NULLDimension Key
COLUMN_IDCharacter(30)VARCHAR2(30) NOT NULLColumn Name
DESCRCharacter(30)VARCHAR2(30) NOT NULLDescription
ROLLED_LEVELNumber(3,0)SMALLINT NOT NULLRolled Level
index back(c)David Kurtz 2019, www.go-faster.co.ukPeopleTools 8.54
PTRef generated on 09-JUN-19