PTSF_INDEX_NAMESEQNUMD=Attachment URL
I=Inline Attachment
U=URL Id
D=Dynamic
S=Static
PTSF_INDEXATT(SQL Table) |
Index Back |
|---|
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | PTSF_INDEX_NAME |
Character(65) | VARCHAR2(65) NOT NULL | Index Name |
| 2 | SEQNUM |
Number(3,0) | SMALLINT NOT NULL | Sequence Number |
| 3 | QRYNAME | Character(30) | VARCHAR2(30) NOT NULL | Query Name |
| 4 | PTSF_ATT_TYPE | Character(1) | VARCHAR2(1) NOT NULL |
Attachment Type
D=Attachment URL I=Inline Attachment U=URL Id |
| 5 | PTSF_URLID_TYPE | Character(1) | VARCHAR2(1) NOT NULL |
URL Id Type
D=Dynamic S=Static |
| 6 | PTSF_URLSOURCE | Long Character(1000) | VARCHAR2(1000) | URL Source |