MC_FIELD_VW

index back

Mass Change Fields View


SELECT A.RECNAME , A.FIELDNUM , A.FIELDNAME , B.FIELDTYPE , B.LENGTH , A.DEFFIELDNAME , C.SQR_DATA_PREFIX , C.DATATYPE_DESCR4 FROM PSRECFIELDDB A , PSDBFIELD B , PS_MC_DATA_TBL C WHERE A.FIELDNAME = B.FIELDNAME AND B.FIELDTYPE = C.FIELDTYPE

PeopleSoft Field Name Field Type Column Type Description
RECNAME Character(15) VARCHAR2(15) NOT NULL Record (Table) Name (see PSRECDEFN).
FIELDNUM Number(4,0) SMALLINT NOT NULL Field Number
FIELDNAME Character(18) VARCHAR2(18) NOT NULL Field Name (see PSDBFIELD).
FIELDTYPE Number(2,0) SMALLINT NOT NULL Field Type (from PSST0101)
MC_FIELDLENGTH Number(2,0) SMALLINT NOT NULL Length
DEFFIELDNAME Character(18) VARCHAR2(18) NOT NULL Default Field Name
SQR_DATA_PREFIX Character(1) VARCHAR2(1) NOT NULL SQR Datatype Prefix
DATATYPE_DESCR4 Character(4) VARCHAR2(4) NOT NULL Datatype Description 4
index back (c)David Kurtz 2019, www.go-faster.co.uk PeopleTools 8.54
PTRef generated on 09-JUN-19