MC_TYPE_RECORD

index back

Mass Change Type Record


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
MC_SEQ Number(3,0) SMALLINT NOT NULL Mass Change Sequence
RECNAME Character(15) VARCHAR2(15) NOT NULL Record (Table) Name (see PSRECDEFN).

Prompt Table: MC_RECNAME_VW

MC_RECORD_TYPE Character(1) VARCHAR2(1) NOT NULL SQL Action
B=Sub Select
D=Delete
I=Insert
M=Select Sum
S=Select
T=Select Distinct
U=Update
index back (c)David Kurtz 2019, www.go-faster.co.uk PeopleTools 8.54
PTRef generated on 09-JUN-19