EOWC_IN_DBD_MAP(SQL Table) |
Index Back |
|---|---|
Filter to Dashboard MapWorkcenter config table - Filter to Insight dashboard mapping table |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  PAGELET_CONFIG_ID |
Character(18) | VARCHAR2(18) NOT NULL | FSWC-Workcenter ID |
| 2 | FSPC_GROUP_ID |
Character(36) | VARCHAR2(36) NOT NULL | Group ID |
| 3 | FSPC_LINK_ID |
Character(36) | VARCHAR2(36) NOT NULL | Link ID |
| 4 | PTSF_SBO_NAME |
Character(65) | VARCHAR2(65) NOT NULL |
Search Definition (see PSPTSF_SD).
Prompt Table: PSPTSF_SD_VW |
| 5 | PTSF_SRCATTR_NAME |
Character(65) | VARCHAR2(65) NOT NULL |
Attribute Name (see PSPTSF_ATTRS).
Prompt Table: EOWC_SD_ATTR_VW |
| 6 | FILTER_ID |
Character(10) | VARCHAR2(10) NOT NULL |
Filter criteria identification
Prompt Table: FSFB_FLTRDEFN |
| 7 | FIELDNAME |
Character(18) | VARCHAR2(18) NOT NULL |
Field Name (see PSDBFIELD).
Prompt Table: EOWC_FLT_FLD_VW |
| 8 | RECNAME | Character(15) | VARCHAR2(15) NOT NULL |
Record (Table) Name (see PSRECDEFN).
Prompt Table: FSFBRECDEFN_VW3 |
| 9 | SETID_FIELD | Character(18) | VARCHAR2(18) NOT NULL |
SetID Field
Prompt Table: FSFB_RECFLD_VW |