MC_TYPE_FIELD

index back

Mass Change Type Field


PeopleSoft Field NameField TypeColumn TypeDescription
MC_TYPE_IDCharacter(30)VARCHAR2(30) NOT NULLMass Change Type ID
MC_STMNT_SEQNumber(3,0)SMALLINT NOT NULLMass Change Statement Sequence
MC_SEQNumber(3,0)SMALLINT NOT NULLMass Change Sequence
FIELDNAMECharacter(18)VARCHAR2(18) NOT NULLField Name (see PSDBFIELD).

Prompt Table: MC_FIELD_VW

MC_FIELD_ACTIONCharacter(3)VARCHAR2(3) NOT NULLMass 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_VALUECharacter(250)VARCHAR2(250) NOT NULLMass Change Field Value
index back(c)David Kurtz 2019, www.go-faster.co.ukPeopleTools 8.54
PTRef generated on 09-JUN-19