ITERATOR_IDNODE_TYPE_WCSSOURCE_ID1=Node Detail
2=Attribute
Y/N Table Edit
Y/N Table Edit
BLK=Black
BLUE=Blue
GREE=Green
RED=Red
Y/N Table Edit
WCS_ITER_D_TBL(SQL Table) |
Index Back |
|---|---|
WCS Iterator DetailWCS Iterator Detail |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | ITERATOR_ID |
Character(20) | VARCHAR2(20) NOT NULL | Tree View |
| 2 | NODE_TYPE_WCS |
Character(20) | VARCHAR2(20) NOT NULL | Node Type |
| 3 | SOURCE_ID |
Character(30) | VARCHAR2(30) NOT NULL | This is used to identify a defined input source for a Configurable Matrix. A Source is a named item with data type attributes and resolution rules. The resolution rules tell the Source how, given an orientation, the Source should dynamically determine it's own value for use in a Matrix lookup. |
| 4 | COLUMNNUM | Number(3,0) | SMALLINT NOT NULL | Column Number |
| 5 | ITERATOR_DISP_TYPE | Character(1) | VARCHAR2(1) NOT NULL |
Display Type
1=Node Detail 2=Attribute |
| 6 | HTML_PRE | Character(50) | VARCHAR2(50) NOT NULL | Pre-attribute HTML |
| 7 | HTML_POST | Character(50) | VARCHAR2(50) NOT NULL | Post-Attribute HTML |
| 8 | ACTIVE_FLG | Character(1) | VARCHAR2(1) NOT NULL |
Inactive Flag
Y/N Table Edit |
| 9 | SHOW_LABEL_FLG | Character(1) | VARCHAR2(1) NOT NULL |
Show Symbols
Y/N Table Edit |
| 10 | WCS_BASIC_COLOR | Character(4) | VARCHAR2(4) NOT NULL |
WCS_BASIC_COLOR
BLK=Black BLUE=Blue GREE=Green RED=Red |
| 11 | WCS_BOLD_FLG | Character(1) | VARCHAR2(1) NOT NULL |
WCS Bold Flag
Y/N Table Edit |