MC_TYPE_RECFLD

index back

Mass Change Type Recfield Vw


SELECT a.mc_type_id , a.mc_stmnt_seq , a.mc_seq , a.recname , b.fieldname , c.fieldtype FROM ps_mc_type_record a , psrecfielddb b , psdbfield c WHERE a.recname = b.recname AND b.fieldname = c.fieldname

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).
FIELDNAMECharacter(18)VARCHAR2(18) NOT NULLField Name (see PSDBFIELD).

Prompt Table: MC_FIELD_VW

FIELDTYPENumber(2,0)SMALLINT NOT NULLField Type (from PSST0101)
index back(c)David Kurtz 2019, www.go-faster.co.ukPeopleTools 8.54
PTRef generated on 09-JUN-19