PSPTMATVWDEFN

index back

Materialized View MetaData

Materialized View MetaData

PeopleSoft Field Name Field Type Column Type Description
RECNAME Character(15) VARCHAR2(15) NOT NULL Record (Table) Name (see PSRECDEFN).
PTMAT_MATSTAT Number(2,0) SMALLINT NOT NULL Materialized View
PTMAT_REFMODE Number(4,0) SMALLINT NOT NULL Materialized View
PTMAT_REFMETH Number(4,0) SMALLINT NOT NULL Materialized View
PTMAT_BLDMODE Number(4,0) SMALLINT NOT NULL Materialized View
PTMAT_REFRESHSTAT Number(2,0) SMALLINT NOT NULL Materialized View
PTMAT_LASTREFRESH DateTime(26) TIMESTAMP Materialized View
PTMAT_STALENESS Character(15) VARCHAR2(15) NOT NULL Materialized View
index back (c)David Kurtz 2019, www.go-faster.co.uk PeopleTools 8.54
PTRef generated on 09-JUN-19