# |
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
|