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
PTMAT_OVERRIDE Number(4,0) SMALLINT NOT NULL Materialized View Override Field

Default: 1

index back (c)David Kurtz 2020, www.go-faster.co.uk PeopleTools 8.58
PTRef generated on 21-DEC-20