PC_SCH_3D_PRJ

(SQL Table)
Index Back

Scheduling Table for Projects

Project table for hold 3rd Party Scheduling product.

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).
2 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
3 PC_SCH_PRODUCT Character(3) VARCHAR2(3) NOT NULL Product code used by Projects to determine the third party scheduling product being integrated with.
4 PC_SCH_3D_PROJECT Character(40) VARCHAR2(40) NOT NULL Third Party Projects
5 FIELD_VALUE Character(30) VARCHAR2(30) NOT NULL Field Value
6 FIELD_VALUE_STR Character(30) VARCHAR2(30) NOT NULL An accounting template field designated to support the substitution of desired character field values du
7 FIELDVAL1 Character(30) VARCHAR2(30) NOT NULL Field Value 1
8 FIELDVAL2 Character(30) VARCHAR2(30) NOT NULL Field Value 2
9 FIELDVAL3 Character(30) VARCHAR2(30) NOT NULL Field Value 3
10 FIELDVAL4 Character(30) VARCHAR2(30) NOT NULL Field Value 3
11 FIELD_DESCR1 Character(30) VARCHAR2(30) NOT NULL Field Description
12 FIELD2 Character(50) VARCHAR2(50) NOT NULL Fieldname 2
13 FIELD3 Character(50) VARCHAR2(50) NOT NULL Fieldname 3
14 FIELD4 Character(50) VARCHAR2(50) NOT NULL Fieldname 1
15 FIELD_VALUE_DATE Date(10) DATE An accounting template field designated to support the substitution of desired dates during accounting b
16 PROJECT_ID_2 Character(15) VARCHAR2(15) NOT NULL Project
17 DESCR Character(30) VARCHAR2(30) NOT NULL Description
18 PC_FIELD_GEN1 Character(50) VARCHAR2(50) NOT NULL Generic Date
19 PC_FIELD_GEN2 Character(50) VARCHAR2(50) NOT NULL Generic Field