SCP_SEC_GRP_VW(SQL View) |
Index Back |
|---|---|
Content Security Group ViewContent Security Group View |
| SELECT DISTINCT(B.SCP_SECURITY_GROUP) , B.DESCR60 FROM PS_SCP_CONTENT_HDR A , PS_SCP_CONTSEC_GRP B WHERE B.SCP_SECURITY_GROUP = A.SCP_SECURITY_GROUP AND A.SCP_CONTENT_STATUS = 'P' |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | SCP_SECURITY_GROUP | Character(4) | VARCHAR2(4) NOT NULL | Content Security Group |
| 2 | DESCR60 | Character(60) | VARCHAR2(60) NOT NULL | Description |