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') |
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | 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. |