RG_TGRP_TSK_VW (SQL View)	Index Back
Task Group Task View View tasks of a task group for assignment processing

RG_TGRP_TSK_VW

(SQL View)

Task Group Task View

View tasks of a task group for assignment processing

SELECT G.TASK_GRP_ID , G.TASK_ID , T.TASK_TYPE , T.PERSON_ID_OWNER FROM PS_RB_TGRP_TSK G , PS_RB_TSK T WHERE G.TASK_ID = T.TASK_ID

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 TASK_GRP_ID Number(10,0) DECIMAL(10) NOT NULL Task Group ID. Key for Task Group. Used by Task Management.

2 TASK_ID Number(15,0) DECIMAL(15) NOT NULL TaskIID field. Key for RB_TSK record. Used by Task Management.

3 TASK_TYPE Character(18) VARCHAR2(18) NOT NULL Copied from Resouce Management (8.1). Added new label id for "Task Type"

4 PERSON_ID_OWNER Character(15) VARCHAR2(15) NOT NULL Contact Identifier for Treasury Contacts

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	TASK_GRP_ID	Number(10,0)	DECIMAL(10) NOT NULL	Task Group ID. Key for Task Group. Used by Task Management.
2	TASK_ID	Number(15,0)	DECIMAL(15) NOT NULL	TaskIID field. Key for RB_TSK record. Used by Task Management.
3	TASK_TYPE	Character(18)	VARCHAR2(18) NOT NULL	Copied from Resouce Management (8.1). Added new label id for "Task Type"
4	PERSON_ID_OWNER	Character(15)	VARCHAR2(15) NOT NULL	Contact Identifier for Treasury Contacts