RG_CHG_TGRP_VW (SQL View)	Index Back
View Tasks of Change Request Change Request view of all Tasks associated

RG_CHG_TGRP_VW

(SQL View)

View Tasks of Change Request

Change Request view of all Tasks associated

SELECT TL.CHANGE_REQUEST_ID , TL.BUSINESS_UNIT , TL.RG_CHANGE_STATE , TL.TASK_GRP_ID , %Substring(%NUMTOCHAR(TL.TASK_GRP_ID),1,10) FROM PS_RG_CHG_PHS_TSK TL

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 CHANGE_REQUEST_ID Character(15) VARCHAR2(15) NOT NULL change request identification is key to change request

2 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit

3 RG_CHANGE_STATE Character(4) VARCHAR2(4) NOT NULL Change request change State / Phase
CANC=Canceled
COMP=Complete
DEV=Development
HOLD=On Hold
IMPL=Implementation
PEND=Change Pending
POST=Postmortem Review
PROP=Proposed
REJ=Rejected
RETN=Return for More Information
REVW=Review
Prompt Table: RG_UD_REQ_STATE

4 TASK_GRP_ID Number(10,0) DECIMAL(10) NOT NULL Task Group ID. Key for Task Group. Used by Task Management.
Prompt Table: RB_TGRP

5 DESCR Character(30) VARCHAR2(30) NOT NULL Description

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	CHANGE_REQUEST_ID	Character(15)	VARCHAR2(15) NOT NULL	change request identification is key to change request
2	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit
3	RG_CHANGE_STATE	Character(4)	VARCHAR2(4) NOT NULL	Change request change State / Phase CANC=Canceled COMP=Complete DEV=Development HOLD=On Hold IMPL=Implementation PEND=Change Pending POST=Postmortem Review PROP=Proposed REJ=Rejected RETN=Return for More Information REVW=Review Prompt Table: RG_UD_REQ_STATE
4	TASK_GRP_ID	Number(10,0)	DECIMAL(10) NOT NULL	Task Group ID. Key for Task Group. Used by Task Management. Prompt Table: RB_TGRP
5	DESCR	Character(30)	VARCHAR2(30) NOT NULL	Description