IT_SWGRP_DTLVW (SQL View)	Index Back
Software Device Group Detail View with current Software Device Group Detail.

IT_SWGRP_DTLVW

(SQL View)

Software Device Group Detail

View with current Software Device Group Detail.

SELECT A.IT_GRP_ID , A.GRP_TYPE , A.GRP_VALUE , A.ARM_SRC_FLG , A.NBR_OF_CPU FROM PS_IT_SWGRP_DTL A WHERE A.EFF_STATUS = 'A' AND A.EFFDT = ( SELECT MAX(B.EFFDT) FROM PS_IT_SWGRP_DTL B WHERE A.IT_GRP_ID = B.IT_GRP_ID AND A.GRP_TYPE = B.GRP_TYPE AND A.GRP_VALUE = B.GRP_VALUE)

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

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

2 GRP_TYPE Character(1) VARCHAR2(1) NOT NULL ITAM - Software Device Group Type. Device Group or Machine.
D=Device
G=Device Group

3 GRP_VALUE Character(20) VARCHAR2(20) NOT NULL Member
Prompt Table: %EDITTABLE

4 ARM_SRC_FLG Character(1) VARCHAR2(1) NOT NULL Source Device Groups from ARM
N=No
Y=Yes
Default Value: N

5 NBR_OF_CPU Number(3,0) SMALLINT NOT NULL Used by ITAM. Servers and Desktops can have multiple CPUs. A separate Software License is needed for each CPU.

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	IT_GRP_ID	Character(11)	VARCHAR2(11) NOT NULL	Group Id
2	GRP_TYPE	Character(1)	VARCHAR2(1) NOT NULL	ITAM - Software Device Group Type. Device Group or Machine. D=Device G=Device Group
3	GRP_VALUE	Character(20)	VARCHAR2(20) NOT NULL	Member Prompt Table: %EDITTABLE
4	ARM_SRC_FLG	Character(1)	VARCHAR2(1) NOT NULL	Source Device Groups from ARM N=No Y=Yes Default Value: N
5	NBR_OF_CPU	Number(3,0)	SMALLINT NOT NULL	Used by ITAM. Servers and Desktops can have multiple CPUs. A separate Software License is needed for each CPU.