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

Prompt Table: MC_FIELD_VW

FIELDTYPE Number(2,0) SMALLINT NOT NULL Field Type (from PSST0101)
index back (c)David Kurtz 2020, www.go-faster.co.uk PeopleTools 8.58
PTRef generated on 21-DEC-20