SAC_IDX_FIELDS(SQL Table) |
Index Back |
|---|---|
Index Fields |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  INDEXNAME |
Character(30) | VARCHAR2(30) NOT NULL | Search Index Name |
| 2 | DOSET_NAME |
Character(30) | VARCHAR2(30) NOT NULL |
Data Object Set Name
Prompt Table: SAC_IDX_DOS_HDR |
| 3 | EOEW_SRCDONAME |
Character(30) | VARCHAR2(30) NOT NULL |
Source Data Object
Prompt Table:
SAC_IDX_DOS_LN
|
| 4 | INDEXFIELD |
Character(18) | VARCHAR2(18) NOT NULL | Index Field Name |
| 5 | FIELDNAME | Character(18) | VARCHAR2(18) NOT NULL |
Field Name (see PSDBFIELD).
Prompt Table:
SAC_IDX_SFLD_VW
|
| 6 | FIELDNUM | Number(4,0) | SMALLINT NOT NULL | Field Number |
| 7 | INDEX_FIELDTYPE | Character(2) | VARCHAR2(2) NOT NULL |
Field Type
A=Field & Zone F=Field FD=Field - Date FF=Field - Decimal FN=Field - Number T=Attachment Z=Zone |
| 8 | MULTIPLE_FLG | Character(1) | VARCHAR2(1) NOT NULL |
Allow Multiple Values per Attr
Y/N Table Edit |
| 9 | INDEXKEY_FLG | Character(1) | VARCHAR2(1) NOT NULL |
Index Key?
Y/N Table Edit |
| 10 | PRIORITY | Number(3,0) | SMALLINT NOT NULL | Priority |
| 11 | TRANSLATE_FLG | Character(1) | VARCHAR2(1) NOT NULL |
Translate?
Y/N Table Edit |
| 12 | SAC_ATTACH_TYPE | Character(1) | VARCHAR2(1) NOT NULL |
Attachment Type
A=SCM Framework B=FTP Server C=Network Server D=Database N=None Default Value: N |
| 13 | PNLGRPNAME | Character(18) | VARCHAR2(18) NOT NULL |
Component Name
Prompt Table: PV_ATT_COMP_VW |