PSPTSF_ATT_PROP |
index back |
---|---|
PTSF Attchment Properties |
PeopleSoft Field Name | Field Type | Column Type | Description |
---|---|---|---|
![]() |
Character(65) | VARCHAR2(65) NOT NULL | Search Definition (see PSPTSF_SD). |
![]() |
Number(3,0) | SMALLINT NOT NULL | Sequence Number |
PTSF_ATT_TYPE | Character(1) | VARCHAR2(1) NOT NULL |
Attachment Type
D=Attachment URL I=Inline Attachment U=URL Id |
ATTACHMENT_URL | Character(30) | VARCHAR2(30) NOT NULL | Attachment URL |
PTSF_URLID_TYPE | Character(1) | VARCHAR2(1) NOT NULL |
Static
D=Dynamic S=Static |
URL_ID | Character(30) | VARCHAR2(30) NOT NULL | URL Identifier (see PSURLDEFN). |
QRYNAME | Character(30) | VARCHAR2(30) NOT NULL | Query Name |
QRYURLFIELD | Character(30) | VARCHAR2(30) NOT NULL | URLID Query Field |
FILEREFPATH | Character(128) | VARCHAR2(128) NOT NULL | File Reference Path |
QRYPATHFIELD | Character(30) | VARCHAR2(30) NOT NULL | File Path Query Field |
QRYFILEFIELD | Character(30) | VARCHAR2(30) NOT NULL | File Name Query Field |
index back | (c)David Kurtz 2020, www.go-faster.co.uk | PeopleTools 8.58 PTRef generated on 21-DEC-20 |