CATEGORY_CODESECURE_FIELDLEVEL_NUMN=No
Y=Yes
Default Value: N
QUERY_SEC_HG_T1(SQL Table) |
Index Back |
|---|---|
Query Security H-Grid |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | CATEGORY_CODE |
Character(18) | VARCHAR2(18) NOT NULL | 01/29/01 rml CN#WV802-1.0 Created to use as search field in supplier's workbench |
| 2 | SECURE_FIELD |
Character(30) | VARCHAR2(30) NOT NULL | Secure Field |
| 3 | LEVEL_NUM |
Number(3,0) | SMALLINT NOT NULL | Level |
| 4 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
| 5 | SELECT_CB | Character(1) | VARCHAR2(1) NOT NULL |
Select Check Box
N=No Y=Yes Default Value: N |
| 6 | LEVEL1 | Number(5,0) | INTEGER NOT NULL | Level 1 |
| 7 | LEVEL2 | Number(5,0) | INTEGER NOT NULL | Level 2 |
| 8 | LEVEL3 | Number(5,0) | INTEGER NOT NULL | Level 3 |
| 9 | LEVEL4 | Number(5,0) | INTEGER NOT NULL | Level 4 |
| 10 | LEVEL5 | Number(5,0) | INTEGER NOT NULL | Level 5 |
| 11 | LEVEL6 | Number(5,0) | INTEGER NOT NULL | Level 6 |
| 12 | LEVEL7 | Number(5,0) | INTEGER NOT NULL | Level 7 |
| 13 | LEVEL8 | Number(5,0) | INTEGER NOT NULL | Level 8 |
| 14 | LEVEL9 | Number(5,0) | INTEGER NOT NULL | Level 9 |