IT_SWGRP_VW

(SQL View)
 Index Back

ITAM: Non-SourceFromARM Groups

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

SELECT IT_GRP_ID , DESCR , GRP_OWNER_ID , ARM_SRC_FLG FROM %Table(IT_SWGRP) WHERE ARM_SRC_FLG <> 'Y'

  • Related Language Record: IT_SWGRP_LANG

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 IT_GRP_ID Character(11) VARCHAR2(11) NOT NULL Group Id
    2 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    3 GRP_OWNER_ID Character(11) VARCHAR2(11) NOT NULL Group Owner Id

    Prompt Table: PERSONAL_DATA

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

    Default Value: N