PC_3P_INTG_INFO

(SQL Table)
Index Back

3rd-Party Information Table

Table used to store information related to integration with 3rd-Party products such as Primavera P3e and Microsoft Project.

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
2 PROJECT_ID Character(15) VARCHAR2(15) NOT NULL Project Id ChartField
3 USERID Character(30) VARCHAR2(30) NOT NULL A user's ID
4 PC_3P_PROJ_ORIGIN Character(15) VARCHAR2(15) NOT NULL Project Origin

Default Value: PeopleSoft

5 PC_3P_LAST_INTG DateTime(26) TIMESTAMP Date and Time of last integration with 3rd-Party product.
6 PC_3P_DEF_CAL_ACT Character(1) VARCHAR2(1) NOT NULL Default calendar action
E=Error. No assignment.
P=Proceed. Overbooking okay.
7 PC_DEFAULT_ROLE Character(15) VARCHAR2(15) NOT NULL Project Role

Prompt Table: PROJ_ROLE

8 PC_DEFAULT_BUD_ID Character(15) VARCHAR2(15) NOT NULL Default Budget Item
9 ATTACHUSERFILE Character(64) VARCHAR2(64) NOT NULL Attached File