PSFILEREDEFN

index back

PeopleSoft Field Name Field Type Column Type Description
FILEREFNAME Character(30) VARCHAR2(30) NOT NULL File Reference Name
FILEREFTYPECODE Character(30) VARCHAR2(30) NOT NULL File Reference Type Code (see PSTYPECODEDEFN).
FILEREFPATHANDFILE Character(254) VARCHAR2(254) NOT NULL Path and File Name
FILEREFBINARY Number(1,0) SMALLINT NOT NULL File Reference Binary
DBPLATFORM Number(4,0) SMALLINT NOT NULL Database Platform
OSPLATFORM Number(4,0) SMALLINT NOT NULL Operating System Platform
PSSERVER Number(4,0) SMALLINT NOT NULL PeopleSoft Server
DIR_SECURITY Number(4,0) SMALLINT NOT NULL Target Directory Security
CATEMPLATETEXT Character(20) VARCHAR2(20) NOT NULL Change assistant template text
VERSION Number(10,0) DECIMAL(10) NOT NULL Version. Internal PeopleTools version for controlling caching of object. - Version/Table reference
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.
OBJECTOWNERID Character(4) VARCHAR2(4) NOT NULL Object owner identifier translate values
DESCRLONG Long Character CLOB Long Description
index back (c)David Kurtz 2019, www.go-faster.co.uk PeopleTools 8.54
PTRef generated on 09-JUN-19