PTSF_SBO_NAMEPTSF_SRCATTR_NAMEPrompt Table: PSPTSF_ATTRS
Prompt Table:
QRY_FLD_VW
Set Control Field: QRYNAME
1=Allow
2=Deny
Default Value: 1
PSPTSF_SD_DCATR(SQL Table) |
Index Back |
|---|
| # | 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_SRCATTR_NAME |
Character(65) | VARCHAR2(65) NOT NULL |
Search Attribute (see PSPTSF_ATTRS).
Prompt Table: PSPTSF_ATTRS |
| 3 | QRYNAME | Character(30) | VARCHAR2(30) NOT NULL | Query Name |
| 4 | QRYFLDNAME | Character(30) | VARCHAR2(30) NOT NULL |
Source Field
Prompt Table:
QRY_FLD_VW
|
| 5 | PTSF_DOCACL_PVLG | Character(1) | VARCHAR2(1) NOT NULL |
PTSF Doc ACL Privilege
1=Allow 2=Deny Default Value: 1 |