RC_TSK_DUEDT_VW (SQL View)	Index Back
Task Due Date View Returns the due date for a specified business project task.

RC_TSK_DUEDT_VW

(SQL View)

Task Due Date View

Returns the due date for a specified business project task.

SELECT BUS_PROC_INSTANCE , ACTIVITY_INSTANCE , NESTED_BP_IND , RC_TASK_ID , DUE_DTTM FROM PS_RC_TASK_STATUS

# 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 NESTED_BP_IND Character(1) VARCHAR2(1) NOT NULL Sub Business Project
N=No
Y=Yes

4 RC_TASK_ID Character(15) VARCHAR2(15) NOT NULL Task ID used for Business Process tracking.

5 DUE_DTTM DateTime(26) TIMESTAMP Designates the date and time the task is due to be completed.

#	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	NESTED_BP_IND	Character(1)	VARCHAR2(1) NOT NULL	Sub Business Project N=No Y=Yes
4	RC_TASK_ID	Character(15)	VARCHAR2(15) NOT NULL	Task ID used for Business Process tracking.
5	DUE_DTTM	DateTime(26)	TIMESTAMP	Designates the date and time the task is due to be completed.