PTRTDB_SVG

index back

SELECT ATTACHSYSFILENAME ,FILE_SEQ ,VERSION ,FILE_SIZE ,LASTUPDDTTM ,LASTUPDOPRID ,FILE_DATA FROM PS_PTRTDB

PeopleSoft Field Name Field Type Column Type Description
ATTACHSYSFILENAME Character(128) VARCHAR2(128) NOT NULL Unique Sys Filename
FILE_SEQ Number(9,0) DECIMAL(9) NOT NULL File Sequence Number
VERSION Number(10,0) DECIMAL(10) NOT NULL Version. Internal PeopleTools version for controlling caching of object. - Version/Table reference
FILE_SIZE Number(10,0) DECIMAL(10) NOT NULL Physical File Size
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.
PTFILE_DATA_SVG Image / Attachment CLOB PTFILE_DATA_SVG
index back (c)David Kurtz 2019, www.go-faster.co.uk PeopleTools 8.54
PTRef generated on 09-JUN-19