PSFMTDEFN

index back

Format Definition Table


PeopleSoft Field Name Field Type Column Type Description
FORMATFAMILY Character(15) VARCHAR2(15) NOT NULL Format Family Name
FORMATTYPE Number(3,0) SMALLINT NOT NULL Format Definition Type
DESCR Character(30) VARCHAR2(30) NOT NULL Description
FMTOPTIONS Number(5,0) INTEGER NOT NULL Format Options
ITEMCOUNT Number(4,0) SMALLINT NOT NULL Item Count
VERSION Number(10,0) DECIMAL(10) NOT NULL Version. Internal PeopleTools version for controlling caching of object. - Version/Table reference
PUNCCHARSET Character(30) VARCHAR2(30) NOT NULL Punctuation Character Set
DISPLAYLEN Number(10,0) DECIMAL(10) NOT NULL Maximum Display Length
LASTUPDDTTM DateTime(26) TIMESTAMP Specifies the date and time of the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.
LASTUPDOPRID Character(30) VARCHAR2(30) NOT NULL Specifies the User ID which made the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.
index back (c)David Kurtz 2019, www.go-faster.co.uk PeopleTools 8.54
PTRef generated on 09-JUN-19