OBJGROUPIDPSPTDEFSECGRP_V(SQL View) |
Index Back |
|---|---|
Distinct Definition Groups |
| SELECT DISTINCT OBJGROUPID FROM %Table(PSPTDEFSEC_GRP) UNION SELECT DISTINCT OBJGROUPID FROM %Table(PSPTDEFSEC_GRPS) UNION SELECT DISTINCT OBJGROUPID FROM %Table(PSPTDEFSECINRL) UNION SELECT DISTINCT OBJGROUPID FROM %Table(PSOPROBJ) UNION SELECT '*ALL DEFINITIONS*' FROM %Table(INSTALLATION) |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | OBJGROUPID |
Character(18) | VARCHAR2(18) NOT NULL | Definition Group |