PTSF_SBO_NAMEPTSF_SOURCE_TYPEA=Activity Guide
C=Connected Query
F=File Source
Q=Query
R=External Data Source
W=Web Source
Default Value: Q
PTSF_SEQ_NODefault Value: 1
PTSF_PARAM_NAMEPSPTSF_ADD_PRMS(SQL Table) |
Index Back |
|---|---|
Web or File Surce ParametersWeb or File Surce Parameters identfied by sequence number and Parameter name |
| # | 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 | PTSF_SOURCE_TYPE |
Character(1) | VARCHAR2(1) NOT NULL |
Source Type
A=Activity Guide C=Connected Query F=File Source Q=Query R=External Data Source W=Web Source Default Value: Q |
| 3 | PTSF_SEQ_NO |
Number(3,0) | SMALLINT NOT NULL |
Sequence Number
Default Value: 1 |
| 4 | PTSF_PARAM_NAME |
Character(30) | VARCHAR2(30) NOT NULL | Parameter Name |
| 5 | PTSF_PARAM_VALUE | Long Character(1000) | VARCHAR2(1000) | Parameter Value |