RG_TGRP_TPL_VW

(SQL View)
Index Back

Change Task Group Template.

Prompt View of Change Management Task Group Template Information.

SELECT A.TASK_GRP_TPL_ID , A.ACTIVE_FLG , A.APPLICATION_USAGE , A.DESCR , A.ROW_LASTMANT_DTTM , A.ROW_LASTMANT_OPRID FROM PS_RB_TGRP_TPL A WHERE APPLICATION_USAGE IN ('ALL', 'CHMG')

  • Related Language Record: RB_TGRP_TPL_LNG
  • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 TASK_GRP_TPL_ID Character(10) VARCHAR2(10) NOT NULL Task Group Template ID primary key
    2 ACTIVE_FLG Character(1) VARCHAR2(1) NOT NULL Event Status
    N=Inactive
    Y=Active
    3 APPLICATION_USAGE Character(4) VARCHAR2(4) NOT NULL Application Usage. Holds the info about the application.
    ALL=All Applications
    CHMG=Change Management
    EVNT=Marketing Events
    FLDS=Field Service
    HIED=Higher Education
    HLPD=HelpDesk
    HRHD=HR Helpdesk
    LEAD=Lead
    OPPY=Opportunity
    PIM=Personal Information Mgmt
    RSP=Strategic Planning
    SALS=Sales
    SUPP=Support
    4 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    5 ROW_LASTMANT_DTTM DateTime(26) TIMESTAMP The date and time that the row was last updated.
    6 ROW_LASTMANT_OPRID Character(30) VARCHAR2(30) NOT NULL ID of user who last modified the row.