FS_MAP_FILT_GRP(SQL Table) |
Index Back |
|---|
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | Character(30) | VARCHAR2(30) NOT NULL | Map ID | |
| 2 | Character(220) | VARCHAR2(220) NOT NULL | Map Node | |
| 3 | FS_MAP_NODE_PRE | Character(254) | VARCHAR2(254) NOT NULL | Map Pre Node |
| 4 | FS_MAP_ANCHOR | Character(1) | VARCHAR2(1) NOT NULL |
Anchor
Y/N Table Edit |
| 5 | FS_MAP_LEVEL | Number(4,0) | SMALLINT NOT NULL | Level |
| 6 | FS_MAP_SEQ | Number(5,0) | INTEGER NOT NULL |
Sequence
Default Value: 1 |
| 7 | QRYADDCRITERIA | Character(1) | VARCHAR2(1) NOT NULL | Add Criteria to Query |
| 8 | QRYCRITADDGROUP | Character(1) | VARCHAR2(1) NOT NULL | Group Criteria |
| 9 | QRYOK | Character(1) | VARCHAR2(1) NOT NULL | OK |
| 10 | QRYCANCEL | Character(1) | VARCHAR2(1) NOT NULL | Cancel |