CLASSIDTREE_NAMEPrompt Table: TREE_ACCGRP_VW
ACCESS_GROUPPrompt Table: TREE_ACCESS_VW
Y/N Table Edit
Y/N Table Edit
PSPTSCRTY_ADS_A(SQL Table) |
Index Back |
|---|---|
ADS Access Group Security |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | CLASSID |
Character(30) | VARCHAR2(30) NOT NULL | The name of the class (see PSCLASSDEFN). |
| 2 | TREE_NAME |
Character(18) | VARCHAR2(18) NOT NULL |
Tree Name
Prompt Table: TREE_ACCGRP_VW |
| 3 | ACCESS_GROUP |
Character(20) | VARCHAR2(20) NOT NULL |
Access Group
Prompt Table: TREE_ACCESS_VW |
| 4 | READ_ADS_AGRP | Character(1) | VARCHAR2(1) NOT NULL |
Read
Y/N Table Edit |
| 5 | WRITE_ADS_AGRP | Character(1) | VARCHAR2(1) NOT NULL |
Write
Y/N Table Edit |