PSFILEREDEFN

index back

PeopleSoft Field NameField TypeColumn TypeDescription
FILEREFNAMECharacter(30)VARCHAR2(30) NOT NULLFile Reference Name
FILEREFTYPECODECharacter(30)VARCHAR2(30) NOT NULLFile Reference Type Code (see PSTYPECODEDEFN).
FILEREFPATHANDFILECharacter(254)VARCHAR2(254) NOT NULLPath and File Name
FILEREFBINARYNumber(1,0)SMALLINT NOT NULLFile Reference Binary
DBPLATFORMNumber(4,0)SMALLINT NOT NULLDatabase Platform
OSPLATFORMNumber(4,0)SMALLINT NOT NULLOperating System Platform
PSSERVERNumber(4,0)SMALLINT NOT NULLPeopleSoft Server
DIR_SECURITYNumber(4,0)SMALLINT NOT NULLTarget Directory Security
CATEMPLATETEXTCharacter(20)VARCHAR2(20) NOT NULLChange assistant template text
VERSIONNumber(10,0)DECIMAL(10) NOT NULLVersion. Internal PeopleTools version for controlling caching of object. - Version/Table reference
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.
OBJECTOWNERIDCharacter(4)VARCHAR2(4) NOT NULLObject owner identifier translate values
DESCRLONGLong CharacterCLOBLong Description
index back(c)David Kurtz 2019, www.go-faster.co.ukPeopleTools 8.54
PTRef generated on 09-JUN-19