PTSF_SBO_NAMESEQNUMD=Attachment URL
I=Inline Attachment
U=URL Id
D=Dynamic
S=Static
PSPTSF_ATT_PROP(SQL Table) |
Index Back |
|---|---|
PTSF Attchment Properties |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | PTSF_SBO_NAME |
Character(65) | VARCHAR2(65) NOT NULL | Search Definition (see PSPTSF_SD). |
| 2 | SEQNUM |
Number(3,0) | SMALLINT NOT NULL | Sequence Number |
| 3 | PTSF_ATT_TYPE | Character(1) | VARCHAR2(1) NOT NULL |
Attachment Type
D=Attachment URL I=Inline Attachment U=URL Id |
| 4 | ATTACHMENT_URL | Character(30) | VARCHAR2(30) NOT NULL | Attachment URL |
| 5 | PTSF_URLID_TYPE | Character(1) | VARCHAR2(1) NOT NULL |
Static
D=Dynamic S=Static |
| 6 | URL_ID | Character(30) | VARCHAR2(30) NOT NULL | URL Identifier (see PSURLDEFN). |
| 7 | QRYNAME | Character(30) | VARCHAR2(30) NOT NULL | Query Name |
| 8 | QRYURLFIELD | Character(30) | VARCHAR2(30) NOT NULL | URLID Query Field |
| 9 | FILEREFPATH | Character(128) | VARCHAR2(128) NOT NULL | File Reference Path |
| 10 | QRYPATHFIELD | Character(30) | VARCHAR2(30) NOT NULL | File Path Query Field |
| 11 | QRYFILEFIELD | Character(30) | VARCHAR2(30) NOT NULL | File Name Query Field |