MC_TYPE_RECORD

index back

Mass Change Type Record


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
RECNAMECharacter(15)VARCHAR2(15) NOT NULLRecord (Table) Name (see PSRECDEFN).

Prompt Table: MC_RECNAME_VW

MC_RECORD_TYPECharacter(1)VARCHAR2(1) NOT NULLSQL 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.ukPeopleTools 8.54
PTRef generated on 09-JUN-19