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 NameField TypeColumn TypeDescription
RECNAMECharacter(15)VARCHAR2(15) NOT NULLRecord (Table) Name (see PSRECDEFN).
FIELDNAMECharacter(18)VARCHAR2(18) NOT NULLField Name (see PSDBFIELD).
SUBRECORDCharacter(1)VARCHAR2(1) NOT NULLSub Record
FLAGCharacter(1)VARCHAR2(1) NOT NULLFlag
OCCURSCOUNT1Number(2,0)SMALLINT NOT NULLOccurs Count First Level
index back(c)David Kurtz 2019, www.go-faster.co.ukPeopleTools 8.54
PTRef generated on 09-JUN-19