PSPTSF_GN_DCATR(SQL Table) | 
Index Back | 
|---|
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description | 
|---|---|---|---|---|
| 1 | Character(65) | VARCHAR2(65) NOT NULL | Search Definition (see PSPTSF_SD). | |
| 2 | Character(65) | VARCHAR2(65) NOT NULL | 
Search Attribute (see PSPTSF_ATTRS).
 Prompt Table: PSPTSF_ATTRS  | 
|
| 3 | RECNAME | Character(15) | VARCHAR2(15) NOT NULL | 
Record (Table) Name (see PSRECDEFN).
 Prompt Table: PTSF_SECREC_DVW  | 
| 4 | FIELDNAME | Character(18) | VARCHAR2(18) NOT NULL | 
Field Name (see PSDBFIELD).
 Prompt Table: PTSF_SECFLD_DVW  | 
| 5 | PTSF_DOCACL_PVLG | Character(1) | VARCHAR2(1) NOT NULL | 
PTSF Doc ACL Privilege
 1=Allow 2=Deny Default Value: 1  |