PSPTSF_ATTRS

index back

PeopleSoft Field Name Field Type Column Type Description
PTSF_SRCATTR_NAME Character(65) VARCHAR2(65) NOT NULL Search Attribute
FIELDNAME Character(18) VARCHAR2(18) NOT NULL Field Name (see PSDBFIELD).
LABEL_ID Character(18) VARCHAR2(18) NOT NULL LABEL_ID identifies uniquness of DB Field Labels. This field is used in PSDBFLDLABL and PSDBFLDLABLLANG.

Prompt Table: WL_FLDLABEL_VW

PTSF_SRCATTR_TYPE Character(1) VARCHAR2(1) NOT NULL Data Type
D=DATE
M=Time
N=NUMBER
S=STRING
T=DateTime

Default: S

PTSF_ATTR_ID Number(4,0) SMALLINT NOT NULL Attribute ID
VERSION Number(10,0) DECIMAL(10) NOT NULL Version. Internal PeopleTools version for controlling caching of object. - Version/Table reference

Default: 10

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
index back (c)David Kurtz 2019, www.go-faster.co.uk PeopleTools 8.58
PTRef generated on 25-NOV-20