IT_GRP_PRMPT_VW (SQL View)	Index Back
ITAM: Non-SourceFromARM Groups View of all Software Device Groups that are physically defined (non-SourceFromARM).

IT_GRP_PRMPT_VW

(SQL View)

ITAM: Non-SourceFromARM Groups

View of all Software Device Groups that are physically defined (non-SourceFromARM).

SELECT A.IT_GRP_ID , A.GRP_OWNER_ID , B.NAME , B.EMAIL_ADDR , B.PHONE FROM %Table(IT_SWGRP) A , %Table(IT_EMPL_INFO) B WHERE A.ARM_SRC_FLG <> 'Y' AND A.GRP_OWNER_ID = B.EMPLID

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 IT_GRP_ID Character(11) VARCHAR2(11) NOT NULL Group Id

2 GRP_OWNER_ID Character(11) VARCHAR2(11) NOT NULL Group Owner Id
Prompt Table: PERSONAL_DATA

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

4 EMAIL_ADDR Character(70) VARCHAR2(70) NOT NULL Email Address

5 PHONE Character(24) VARCHAR2(24) NOT NULL Telephone

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	IT_GRP_ID	Character(11)	VARCHAR2(11) NOT NULL	Group Id
2	GRP_OWNER_ID	Character(11)	VARCHAR2(11) NOT NULL	Group Owner Id Prompt Table: PERSONAL_DATA
3	NAME	Character(50)	VARCHAR2(50) NOT NULL	Name
4	EMAIL_ADDR	Character(70)	VARCHAR2(70) NOT NULL	Email Address
5	PHONE	Character(24)	VARCHAR2(24) NOT NULL	Telephone