DBFIELD

index back

Internal - Used for DB Sizing

Internal - Used for DB Sizing
SELECT FIELDNAME , FIELDTYPE , LENGTH , CASE WHEN FIELDTYPE = 0 THEN LENGTH WHEN FIELDTYPE = 1 THEN 0 WHEN FIELDTYPE = 2 THEN floor(LENGTH/2)+1 WHEN FIELDTYPE = 3 THEN floor(LENGTH/2)+1 WHEN FIELDTYPE = 4 THEN 7 WHEN FIELDTYPE = 5 THEN 7 WHEN FIELDTYPE = 6 THEN 7 WHEN FIELDTYPE = 8 THEN 0 WHEN FIELDTYPE = 9 THEN 0 END BYTES FROM psdbfield WHERE FIELDTYPE <> 7

PeopleSoft Field NameField TypeColumn TypeDescription
FIELDNAMECharacter(18)VARCHAR2(18) NOT NULLField Name (see PSDBFIELD).
FIELDTYPENumber(2,0)SMALLINT NOT NULLField Type (from PSST0101)
LENGTHNumber(5,0)INTEGER NOT NULLLength
BYTESNumber(5,0)INTEGER NOT NULLBytes for DB Sizing Calculation
index back(c)David Kurtz 2019, www.go-faster.co.ukPeopleTools 8.54
PTRef generated on 09-JUN-19