SETID_SECTYPEPV_SECURITY_TYPESETIDCATALOG_TYPECATALOG_IDPV_CAT_SEC_L_VW(SQL View) |
Index Back |
|---|---|
Catalog Security LineRule Based Catalog - IntersectPolicy Implementation |
| SELECT A.SETID_SECTYPE , A.PV_SECURITY_TYPE , A.PV_VALUE , A.SETID , A.CATALOG_TYPE , A.CATALOG_ID FROM PS_PV_CAT_SEC_LINE A , PS_PV_CAT_SEC_HDR B WHERE A.SETID_SECTYPE=B.SETID_SECTYPE AND A.PV_SECURITY_TYPE = B.PV_SECURITY_TYPE AND A.PV_VALUE = B.PV_VALUE AND B.PV_ENABLED = 'Y' |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | SETID_SECTYPE |
Character(5) | VARCHAR2(5) NOT NULL | Security Type SetID |
| 2 | PV_SECURITY_TYPE |
Character(30) | VARCHAR2(30) NOT NULL | Security Type |
| 3 | PV_VALUE | Character(150) | VARCHAR2(150) NOT NULL | Value |
| 4 | SETID |
Character(5) | VARCHAR2(5) NOT NULL | SetID |
| 5 | CATALOG_TYPE |
Character(3) | VARCHAR2(3) NOT NULL | Catalog Type |
| 6 | CATALOG_ID |
Character(18) | VARCHAR2(18) NOT NULL | Catalog ID |