MC_TEM_CRIT_VW

index back

Mass Change Tem Criteria View


select distinct mc_type_id, mc_stmnt_seq, recname from ps_mc_type_record where mc_record_type in ('D','U','S','B','T','M')

PeopleSoft Field Name Field Type Column Type Description
MC_TYPE_ID Character(30) VARCHAR2(30) NOT NULL Mass Change Type ID
MC_STMNT_SEQ Number(3,0) SMALLINT NOT NULL Mass Change Statement Sequence
RECNAME Character(15) VARCHAR2(15) NOT NULL Record (Table) Name (see PSRECDEFN).
index back (c)David Kurtz 2019, www.go-faster.co.uk PeopleTools 8.54
PTRef generated on 09-JUN-19