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_NAMEHRS_ADD_PRM_STG(SQL View) |
Index Back |
|---|---|
Web or File Surce ParametersHRS Staging Table to store Web or File Surce Parameters identfied by sequence number and Parameter name |
| SELECT P.PTSF_SBO_NAME , P.PTSF_SOURCE_TYPE , P.PTSF_SEQ_NO , P.PTSF_PARAM_NAME , P.PTSF_PARAM_VALUE FROM PSPTSF_ADD_PRMS P WHERE P.PTSF_PARAM_NAME = 'INDEX_ONLY_LAST_DAYS' AND P.PTSF_SBO_NAME = 'HC_HRS_APP_INDEX' |
| # | 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 | PTPG_FACET_NUMSRT2 | Signed Number(11,0) | DECIMAL(10) NOT NULL | Number Value |