IT_SWG_OWNER_VW

(SQL View)
Index Back

Software Device Group Owners

View of distinct Software Device Group Owners. Join with PERSONAL_DATA to retrieve associated NAME.

SELECT DISTINCT A.GRP_OWNER_ID , B.NAME FROM PS_IT_SWGRP A , PS_PERSONAL_DATA B WHERE A.GRP_OWNER_ID = B.EMPLID

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 GRP_OWNER_ID Character(11) VARCHAR2(11) NOT NULL Group Owner Id

Prompt Table: PERSONAL_DATA

2 NAME Character(50) VARCHAR2(50) NOT NULL Name