SETID_SECTYPEPrompt Table: SP_SETID_NONVW
PV_SECURITY_TYPEPV_VALUEY/N Table Edit
Default Value: Y
N=No
Y=Yes
Y/N Table Edit
Default Value: N
PV_CAT_SEC_HDR(SQL Table) |
Index Back |
|---|---|
Catalog Security HeaderRule Based Catalog - IntersectPolicy implementation 07/17/2011 MRAD 12802673 Ensured that Catalog Security of Rolename doesnot throw up any invalid message. |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | SETID_SECTYPE |
Character(5) | VARCHAR2(5) NOT NULL |
Security Type SetID
Prompt Table: SP_SETID_NONVW |
| 2 | PV_SECURITY_TYPE |
Character(30) | VARCHAR2(30) NOT NULL | Security Type |
| 3 | PV_VALUE |
Character(150) | VARCHAR2(150) NOT NULL | Value |
| 4 | USE_ASSGN_CAT_ONLY | Character(1) | VARCHAR2(1) NOT NULL |
Use Only Assigned Catalogs
Y/N Table Edit Default Value: Y |
| 5 | PV_ENABLED | Character(1) | VARCHAR2(1) NOT NULL |
A flag indicates whether this row is enabled or not.
N=No Y=Yes Y/N Table Edit Default Value: N |