SEC_RULE_FVALS(SQL Table) |
Index Back |
|---|
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  SEC_RULE |
Character(10) | VARCHAR2(10) NOT NULL | Security Rule |
| 2 | FIELDNAME |
Character(18) | VARCHAR2(18) NOT NULL |
Field Name (see PSDBFIELD).
Prompt Table: SEC_FIELDS_VW |
| 3 | SETID |
Character(5) | VARCHAR2(5) NOT NULL |
SetID
Prompt Table: SETID_TBL |
| 4 | BUSINESS_UNIT |
Character(5) | VARCHAR2(5) NOT NULL |
Business Unit
Prompt Table: SP_BU_PC_NONVW |
| 5 | TREE_NAME |
Character(18) | VARCHAR2(18) NOT NULL |
Tree Name
Prompt Table: %EDITTABLE2 |
| 6 | TREE_NODE |
Character(20) | VARCHAR2(20) NOT NULL |
Node name
Prompt Table: %EDITTABLE5 |
| 7 | SELECT_VALUE |
Character(30) | VARCHAR2(30) NOT NULL |
Select Value
Prompt Table: %EDITTABLE |
| 8 | TO_VALUE | Character(30) | VARCHAR2(30) NOT NULL |
To Value
Prompt Table: %EDITTABLE |
| 9 | SEQNBR | Number(5,0) | INTEGER NOT NULL | Sequence Number |
| 10 | SEC_RULE_CRITERIA | Character(3) | VARCHAR2(3) NOT NULL |
Field Criteria
RAN=Range TRE=Tree Node VAL=Detail Value WLD=Wild Card Default Value: VAL |
| 11 | TREE_EFFDT | Date(10) | DATE |
Effective date of the Tree
Prompt Table: %EDITTABLE3 |
| 12 | TREE_LEVEL | Character(10) | VARCHAR2(10) NOT NULL |
Tree Level Number
Prompt Table: %EDITTABLE4 |