RC_TSK_STATUS_V (SQL View)	Index Back
Task Status View This view is used as a filler to link up tasks to an instance to a Business Project. It basically just returns all the nodes for a Business Project.

RC_TSK_STATUS_V

(SQL View)

Task Status View

This view is used as a filler to link up tasks to an instance to a Business Project. It basically just returns all the nodes for a Business Project.

SELECT DISTINCT A.BUS_PROC_INSTANCE , A.ACTIVITY_INSTANCE , B.RC_ACTIVITY_ID , B.RC_ACTIVITY_STATUS FROM PS_RC_TASK_STATUS A , PS_RC_ACTIV_STATUS B WHERE B.BUS_PROC_INSTANCE = A.BUS_PROC_INSTANCE AND B.ACTIVITY_INSTANCE = A.ACTIVITY_INSTANCE

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 BUS_PROC_INSTANCE Number(18,0) DECIMAL(18) NOT NULL Business Project Instance. This is the Business Project instance of a business project.

2 ACTIVITY_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Activity Instance

3 RC_ACTIVITY_ID Character(15) VARCHAR2(15) NOT NULL Activity ID used in Business Process tracking.

4 RC_ACTIVITY_STATUS Character(1) VARCHAR2(1) NOT NULL This field contains the status of a phase/activity within a Business Project.
C=Complete
L=Cancelled
N=Not Started
P=In Process

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	BUS_PROC_INSTANCE	Number(18,0)	DECIMAL(18) NOT NULL	Business Project Instance. This is the Business Project instance of a business project.
2	ACTIVITY_INSTANCE	Number(10,0)	DECIMAL(10) NOT NULL	Activity Instance
3	RC_ACTIVITY_ID	Character(15)	VARCHAR2(15) NOT NULL	Activity ID used in Business Process tracking.
4	RC_ACTIVITY_STATUS	Character(1)	VARCHAR2(1) NOT NULL	This field contains the status of a phase/activity within a Business Project. C=Complete L=Cancelled N=Not Started P=In Process