PC_TASKRSRC_VW (SQL View)	Index Back
Project RSRC Index view Index table used to cross reference Actual assignment values with Third party.

PC_TASKRSRC_VW

(SQL View)

Project RSRC Index view

Index table used to cross reference Actual assignment values with Third party.

SELECT PC_SCH_PRODUCT , PC_TASKRSRC_ID FROM PS_PC_TASKRSRC_IDX

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 PC_SCH_PRODUCT Character(3) VARCHAR2(3) NOT NULL Product code used by Projects to determine the third party scheduling product being integrated with.

2 PC_TASKRSRC_ID Character(10) VARCHAR2(10) NOT NULL Task Unique ID

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	PC_SCH_PRODUCT	Character(3)	VARCHAR2(3) NOT NULL	Product code used by Projects to determine the third party scheduling product being integrated with.
2	PC_TASKRSRC_ID	Character(10)	VARCHAR2(10) NOT NULL	Task Unique ID