PSFMTDEFN

index back

Format Definition Table


PeopleSoft Field NameField TypeColumn TypeDescription
FORMATFAMILYCharacter(15)VARCHAR2(15) NOT NULLFormat Family Name
FORMATTYPENumber(3,0)SMALLINT NOT NULLFormat Definition Type
DESCRCharacter(30)VARCHAR2(30) NOT NULLDescription
FMTOPTIONSNumber(5,0)INTEGER NOT NULLFormat Options
ITEMCOUNTNumber(4,0)SMALLINT NOT NULLItem Count
VERSIONNumber(10,0)DECIMAL(10) NOT NULLVersion. Internal PeopleTools version for controlling caching of object. - Version/Table reference
PUNCCHARSETCharacter(30)VARCHAR2(30) NOT NULLPunctuation Character Set
DISPLAYLENNumber(10,0)DECIMAL(10) NOT NULLMaximum Display Length
LASTUPDDTTMDateTime(26)TIMESTAMPSpecifies 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.
LASTUPDOPRIDCharacter(30)VARCHAR2(30) NOT NULLSpecifies 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.ukPeopleTools 8.54
PTRef generated on 09-JUN-19