RECFIELD

index back

Internal - Used for DB Sizing

Internal - Used for DB Sizing
SELECT F.RECNAME , F.FIELDNAME , 'N' , ' ' , COUNT(K.FIELDNAME)+1 FROM PSRECFIELDALL F LEFT OUTER JOIN PSKEYDEFN K ON K.RECNAME = F.RECNAME AND F.FIELDNAME = K.FIELDNAME GROUP BY F.RECNAME , F.FIELDNAME

PeopleSoft Field Name Field Type Column Type Description
RECNAME Character(15) VARCHAR2(15) NOT NULL Record (Table) Name (see PSRECDEFN).
FIELDNAME Character(18) VARCHAR2(18) NOT NULL Field Name (see PSDBFIELD).
SUBRECORD Character(1) VARCHAR2(1) NOT NULL Sub Record
FLAG Character(1) VARCHAR2(1) NOT NULL Flag
OCCURSCOUNT1 Number(2,0) SMALLINT NOT NULL Occurs Count First Level
index back (c)David Kurtz 2019, www.go-faster.co.uk PeopleTools 8.54
PTRef generated on 09-JUN-19