MC_TYPE_FIELD

index back

Mass Change Type Field


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
FIELDNAME Character(18) VARCHAR2(18) NOT NULL Field Name (see PSDBFIELD).

Prompt Table: MC_FIELD_VW

MC_FIELD_ACTION Character(3) VARCHAR2(3) NOT NULL Mass Change Field Action
APD=Append to end of default value
CNT=Count
FLD=Set to Field Value
MAX=Max Value
SUM=Sum Field
VAL=Set to Hard Coded Value
MC_FIELD_VALUE Character(250) VARCHAR2(250) NOT NULL Mass Change Field Value
index back (c)David Kurtz 2019, www.go-faster.co.uk PeopleTools 8.54
PTRef generated on 09-JUN-19