PC_JOB_ROLE_IDX (SQL Table)	Index Back
Job Role Index table This table is used to reference P3E Role ID using PeopleSoft's JobCode ID in the JobCode table.

PC_JOB_ROLE_IDX

(SQL Table)

Job Role Index table

This table is used to reference P3E Role ID using PeopleSoft's JobCode ID in the JobCode table.

# 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_ROLE_ID Character(20) VARCHAR2(20) NOT NULL Role ID

3 JOBCODE Character(6) VARCHAR2(6) NOT NULL Job Code

#	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_ROLE_ID	Character(20)	VARCHAR2(20) NOT NULL	Role ID
3	JOBCODE	Character(6)	VARCHAR2(6) NOT NULL	Job Code