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 Name Field Type Column Type Description
FIELDNAME Character(18) VARCHAR2(18) NOT NULL Field Name (see PSDBFIELD).
FIELDTYPE Number(2,0) SMALLINT NOT NULL Field Type (from PSST0101)
LENGTH Number(5,0) INTEGER NOT NULL Length
BYTES Number(5,0) INTEGER NOT NULL Bytes for DB Sizing Calculation
index back (c)David Kurtz 2019, www.go-faster.co.uk PeopleTools 8.54
PTRef generated on 09-JUN-19