RB_TASK_VW

(SQL View)

SELECT B.RC_TASK_ID , A.NESTED_BP_IND , B.RC_ASSIGNMENT_OPT , B.SETID , B.RC_ASSIGNED_TO FROM PS_RC_ACTIV_TASK A , PS_RC_TASK B WHERE A.RC_TASK_ID = B.RC_TASK_ID

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

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

2 NESTED_BP_IND Character(1) VARCHAR2(1) NOT NULL Sub Business Project
N=No
Y=Yes

3 RC_ASSIGNMENT_OPT Character(1) VARCHAR2(1) NOT NULL This determines which type of object will be assigned to a Business Project task. The translates for this field identify all the valid options.
C=Person
G=Role
P=Provider Group

4 SETID Character(5) VARCHAR2(5) NOT NULL This field is used to store the value of SetID on various setup tables.

5 RC_ASSIGNED_TO Character(30) VARCHAR2(30) NOT NULL This is a field to store assignment information.

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	RC_TASK_ID	Character(15)	VARCHAR2(15) NOT NULL	Task ID used for Business Process tracking.
2	NESTED_BP_IND	Character(1)	VARCHAR2(1) NOT NULL	Sub Business Project N=No Y=Yes
3	RC_ASSIGNMENT_OPT	Character(1)	VARCHAR2(1) NOT NULL	This determines which type of object will be assigned to a Business Project task. The translates for this field identify all the valid options. C=Person G=Role P=Provider Group
4	SETID	Character(5)	VARCHAR2(5) NOT NULL	This field is used to store the value of SetID on various setup tables.
5	RC_ASSIGNED_TO	Character(30)	VARCHAR2(30) NOT NULL	This is a field to store assignment information.