SETID_SEARCH_VW(SQL View) |
Index Back |
|---|---|
PTSF SetID SecuritySource view used in PTSF SetID security query |
| SELECT NON.SETID , 'A:ALL' FROM PS_SETID_TBL NON UNION ALL SELECT SEC.SETID , 'S:' %Concat SEC.SETID FROM PS_SETID_TBL SEC |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | SETID | Character(5) | VARCHAR2(5) NOT NULL | SetID |
| 2 | SETID_SECURITY_FS | Character(7) | VARCHAR2(7) NOT NULL | PTSF Query Security Attribute for SetID |