PSPTMATVWDEFN

index back

Materialized View MetaData

Materialized View MetaData

PeopleSoft Field NameField TypeColumn TypeDescription
RECNAMECharacter(15)VARCHAR2(15) NOT NULLRecord (Table) Name (see PSRECDEFN).
PTMAT_MATSTATNumber(2,0)SMALLINT NOT NULLMaterialized View
PTMAT_REFMODENumber(4,0)SMALLINT NOT NULLMaterialized View
PTMAT_REFMETHNumber(4,0)SMALLINT NOT NULLMaterialized View
PTMAT_BLDMODENumber(4,0)SMALLINT NOT NULLMaterialized View
PTMAT_REFRESHSTATNumber(2,0)SMALLINT NOT NULLMaterialized View
PTMAT_LASTREFRESHDateTime(26)TIMESTAMPMaterialized View
PTMAT_STALENESSCharacter(15)VARCHAR2(15) NOT NULLMaterialized View
index back(c)David Kurtz 2019, www.go-faster.co.ukPeopleTools 8.54
PTRef generated on 09-JUN-19