PSPTSF_ATTRS

index back

PeopleSoft Field NameField TypeColumn TypeDescription
PTSF_SRCATTR_NAMECharacter(65)VARCHAR2(65) NOT NULLSearch Attribute
FIELDNAMECharacter(18)VARCHAR2(18) NOT NULLField Name (see PSDBFIELD).
LABEL_IDCharacter(18)VARCHAR2(18) NOT NULLLABEL_ID identifies uniquness of DB Field Labels. This field is used in PSDBFLDLABL and PSDBFLDLABLLANG.

Prompt Table: WL_FLDLABEL_VW

PTSF_SRCATTR_TYPECharacter(1)VARCHAR2(1) NOT NULLData Type
D=DATE
N=NUMBER
S=STRING

Default: S

PTSF_ATTR_IDNumber(4,0)SMALLINT NOT NULLAttribute ID
VERSIONNumber(10,0)DECIMAL(10) NOT NULLVersion. Internal PeopleTools version for controlling caching of object. - Version/Table reference

Default: 10

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
index back(c)David Kurtz 2019, www.go-faster.co.ukPeopleTools 8.54
PTRef generated on 09-JUN-19