| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 INTFC_ID |
Number(8,0) |
INTEGER NOT NULL |
Interface ID
|
| 2 |
INTFC_LINE_NUM |
Number(8,0) |
INTEGER NOT NULL |
Interface Line Number
|
| 3 |
BUSINESS_UNIT |
Character(5) |
VARCHAR2(5) NOT NULL |
Business Unit
Prompt Table:
SP_BU_PC_NONVW
|
| 4 |
PROJECT_ID |
Character(15) |
VARCHAR2(15) NOT NULL |
Project Id ChartField
|
| 5 |
ACTIVITY_ID |
Character(15) |
VARCHAR2(15) NOT NULL |
Activity ID
|
| 6 |
INTFC_TYPE |
Character(3) |
VARCHAR2(3) NOT NULL |
Trans Load Type
|
| 7 |
INTFC_STATUS |
Character(3) |
VARCHAR2(3) NOT NULL |
Interface Status
CON=Consolidated
DON=Mass Changes Generated
ERR=Error
NEW=Mass Changes Not Generated
REP=Replaced by Other Records (AP)
UNI=Unitized
Default Value: NEW
|
| 8 |
LOAD_STATUS |
Character(3) |
VARCHAR2(3) NOT NULL |
/* -> JMZ. PSOFT. 11-OCT-2002 */
New Status were added : HLD and INP for Asset Management.
/* <- JMZ. PSOFT. 11-OCT-2002 */
CON=Consolidated
DON=Loaded
ERR=Errored
EXC=Excluded
HLD=On Hold
INP=In Process
NEW=Pending
PGI=PO Grp Incomplete
REP=Replaced
UNI=Unitized
Default Value: NEW
|
| 9 |
ORIG_INTFC_ID |
Number(8,0) |
INTEGER NOT NULL |
Original Interface ID
|
| 10 |
ORIG_LINE_NUM |
Number(8,0) |
INTEGER NOT NULL |
Original Interface Line Number
|
| 11 |
ACTIVITY_DESCR |
Character(30) |
VARCHAR2(30) NOT NULL |
Activity Description
|
| 12 |
ACTIVITY_TYPE |
Character(5) |
VARCHAR2(5) NOT NULL |
Activity Type
A=Activity Type
E=Entry Type
G=Group Type/Origin
O=Activity Type/Origin
R=Entry Type/Reason
Prompt Table:
PROJ_ACT_TBL
|
| 13 |
SYSTEM_SOURCE |
Character(3) |
VARCHAR2(3) NOT NULL |
Identifies the application or source system that generated a journal entry.
Release 8.80 - 11/14/2002 - RVlasic - Removed GDM (JrnlGen - Deduction Management) from Translate Values.
SUJ---Included a label as Product.
Release 8.9 - 05/11/2005 - RVlasic - Added PRV (Variance Pricing) and PKK (KK Budget Journal) and deleted GLK for Project Costing per Brian Cohen.
Default Value: BPC
|
| 14 |
PERCENT_COMPLETE |
Number(6,2) |
DECIMAL(5,2) NOT NULL |
% Complete
|
| 15 |
EARLY_START_DT |
Date(10) |
DATE |
Early Start Date
|
| 16 |
LATE_START_DT |
Date(10) |
DATE |
Late Start Date
|
| 17 |
ACTUAL_START_DT |
Date(10) |
DATE |
Actual Start Date
|
| 18 |
EARLY_FINISH_DT |
Date(10) |
DATE |
Early Finish Date
|
| 19 |
LATE_FINISH_DT |
Date(10) |
DATE |
Late Finish Date
|
| 20 |
ACTUAL_FINISH_DT |
Date(10) |
DATE |
Actual Finish Date
|
| 21 |
BASELINE_FINISH_DT |
Date(10) |
DATE |
Baseline Finish Date
|
| 22 |
BASELINE_START_DT |
Date(10) |
DATE |
Baseline Start Date
|
| 23 |
BCWP |
Number(3,0) |
SMALLINT NOT NULL |
BCWP - Worked Performed
|
| 24 |
BCWS |
Number(3,0) |
SMALLINT NOT NULL |
BCWS Work Scheduled
|
| 25 |
ACT_TYPE_SCH |
Character(5) |
VARCHAR2(5) NOT NULL |
Schedule Activity Type
Prompt Table:
PC_ACT_TYPE_SCH
|
| 26 |
DTTM_STAMP |
DateTime(26) |
TIMESTAMP |
Specifies the date and time of the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.
|
| 27 |
DRAWING_NAME |
Character(8) |
VARCHAR2(8) NOT NULL |
Drawing Name
|
| 28 |
ACTIVITY_USER1 |
Character(10) |
VARCHAR2(10) NOT NULL |
User 1
|
| 29 |
ACTIVITY_USER2 |
Character(10) |
VARCHAR2(10) NOT NULL |
User 2
|
| 30 |
ACTIVITY_USER3 |
Character(10) |
VARCHAR2(10) NOT NULL |
User 3
|
| 31 |
ACTIVITY_USER4 |
Character(10) |
VARCHAR2(10) NOT NULL |
User 4
|
| 32 |
ACTIVITY_USER5 |
Character(10) |
VARCHAR2(10) NOT NULL |
User 5
|
| 33 |
PC_ACT_USER_DT1 |
Date(10) |
DATE |
Date 1
|
| 34 |
PC_ACT_USER_DT2 |
Date(10) |
DATE |
Date 2
|
| 35 |
PC_USER_CURRENCY |
Character(3) |
VARCHAR2(3) NOT NULL |
User Currency
Prompt Table:
CURRENCY_CD_TBL
|
| 36 |
PC_ACT_USERAMT1 |
Signed Number(17,2) |
DECIMAL(15,2) NOT NULL |
Amount 1
|
| 37 |
PC_ACT_USERAMT2 |
Signed Number(17,2) |
DECIMAL(15,2) NOT NULL |
Amount 2
|
| 38 |
PC_ACT_USERAMT3 |
Signed Number(17,2) |
DECIMAL(15,2) NOT NULL |
Amount 3
|
| 39 |
SETID |
Character(5) |
VARCHAR2(5) NOT NULL |
SetID
Prompt Table:
SETID_TBL
|
| 40 |
OPRID |
Character(30) |
VARCHAR2(30) NOT NULL |
A user's ID (see PSOPRDEFN).
|
| 41 |
PROCESS_INSTANCE |
Number(10,0) |
DECIMAL(10) NOT NULL |
Process Instance
|
| 42 |
DESCR254 |
Character(254) |
VARCHAR2(254) NOT NULL |
Description of length 254
|
| 43 |
ACT_LOC_EFFDT |
Date(10) |
DATE |
Activity Location Effdt
Default Value: %date
|
| 44 |
EFFSEQ |
Number(3,0) |
SMALLINT NOT NULL |
Effective Sequence
Default Value: 1
|
| 45 |
LOCATION |
Character(10) |
VARCHAR2(10) NOT NULL |
Location Code
Default Value: LOCATION_TBL.LOCATION
Prompt Table:
LOCATION_TBL
|
| 46 |
LOCATION_FRACTION |
Number(4,2) |
DECIMAL(3,2) NOT NULL |
Fraction of Cost at Location
Default Value: 1
|
| 47 |
ACTIVITY_STATUS |
Character(1) |
VARCHAR2(1) NOT NULL |
Activity Status
Prompt Table:
PROJ_STATUS_TBL
|
| 48 |
ACT_STATUS_EFFDT |
Date(10) |
DATE |
Activity Status Effective Date
Default Value: %date
|
| 49 |
START_DT_2 |
Date(10) |
DATE |
Start Date
|
| 50 |
END_DT_2 |
Date(10) |
DATE |
End Date
|
| 51 |
START_DT |
Date(10) |
DATE NOT NULL |
Start Date
Default Value: %Date
|
| 52 |
END_DT |
Date(10) |
DATE NOT NULL |
End Date
Default Value: %Date
|
| 53 |
ACTIVITY_PRIORITY |
Number(3,0) |
SMALLINT NOT NULL |
Activity Priority
|
| 54 |
ACT_PCT_COMPLETE |
Number(6,2) |
DECIMAL(5,2) NOT NULL |
Percent Complete
|
| 55 |
QUALITY_DTTM |
DateTime(26) |
TIMESTAMP |
Quality Date
|
| 56 |
QUALITY_TYPE |
Character(3) |
VARCHAR2(3) NOT NULL |
Quality Type
Prompt Table:
PROJ_QUAL_TBL
|
| 57 |
QUALITY_RATING |
Number(3,0) |
SMALLINT NOT NULL |
Quality Rating
|
| 58 |
QUALITY_WEIGHT |
Number(3,0) |
SMALLINT NOT NULL |
Quality Weighting
|
| 59 |
QUALITY_MEMBER |
Character(11) |
VARCHAR2(11) NOT NULL |
Quality Team Member
Prompt Table:
PROJ_TEAM_VW
|
| 60 |
COUNTRY |
Character(3) |
VARCHAR2(3) NOT NULL |
Country
Prompt Table:
COUNTRY_TBL
|
| 61 |
ADDRESS1 |
Character(55) |
VARCHAR2(55) NOT NULL |
Address 1
|
| 62 |
ADDRESS2 |
Character(55) |
VARCHAR2(55) NOT NULL |
Address 2
|
| 63 |
ADDRESS3 |
Character(55) |
VARCHAR2(55) NOT NULL |
Address 3
|
| 64 |
ADDRESS4 |
Character(55) |
VARCHAR2(55) NOT NULL |
Address 4
|
| 65 |
CITY |
Character(30) |
VARCHAR2(30) NOT NULL |
City
|
| 66 |
NUM1 |
Character(6) |
VARCHAR2(6) NOT NULL |
Number 1
|
| 67 |
NUM2 |
Character(6) |
VARCHAR2(6) NOT NULL |
Number 2
|
| 68 |
HOUSE_TYPE |
Character(2) |
VARCHAR2(2) NOT NULL |
House Type
AB=House Boat
WW=Trailer
|
| 69 |
ADDR_FIELD1 |
Character(2) |
VARCHAR2(2) NOT NULL |
Address Field 1
|
| 70 |
ADDR_FIELD2 |
Character(4) |
VARCHAR2(4) NOT NULL |
Address Field 2
|
| 71 |
ADDR_FIELD3 |
Character(4) |
VARCHAR2(4) NOT NULL |
Address Field 3
|
| 72 |
COUNTY |
Character(30) |
VARCHAR2(30) NOT NULL |
County
|
| 73 |
STATE |
Character(6) |
VARCHAR2(6) NOT NULL |
State
Prompt Table:
%EDIT_STATE
|
| 74 |
POSTAL |
Character(12) |
VARCHAR2(12) NOT NULL |
Postal
|
| 75 |
GEO_CODE |
Character(11) |
VARCHAR2(11) NOT NULL |
Geo Code
|
| 76 |
IN_CITY_LIMIT |
Character(1) |
VARCHAR2(1) NOT NULL |
In City Limit
Y/N Table Edit
|
| 77 |
RATE_PLAN |
Character(15) |
VARCHAR2(15) NOT NULL |
Rate Plan - A Rate Plan will allow rate sets to be stacked on top of each other so that the output from one rate set can be used to create additional output from the next rate set. Rate Plans will replace existing Burden Plans in release 8.9. A Rate Plan could be tied to Project Type, Project, Activity or Contract line.
|
| 78 |
PC_MILESTONE_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Milestone Activity
N=No
Y=Yes
Y/N Table Edit
|
| 79 |
AFUDC_ACT_SW |
Character(1) |
VARCHAR2(1) NOT NULL |
Allow AFUDC Calculation
Y/N Table Edit
|
| 80 |
ACT_TEMPLATE_SW |
Character(1) |
VARCHAR2(1) NOT NULL |
Use Activity as Template
Y/N Table Edit
|
| 81 |
PC_SCH_FIELD1 |
Character(40) |
VARCHAR2(40) NOT NULL |
Generic field used for Projects Third Party Schedule Integration.
|
| 82 |
PC_SCH_FIELD2 |
Character(40) |
VARCHAR2(40) NOT NULL |
Generic field used for Projects Third Party Schedule Integration.
|
| 83 |
PC_SCH_FIELD3 |
Character(40) |
VARCHAR2(40) NOT NULL |
Generic field used for Projects Third Party Schedule Integration.
|
| 84 |
PC_SCH_FIELD4 |
Character(40) |
VARCHAR2(40) NOT NULL |
Generic field used for Projects Third Party Schedule Integration.
|
| 85 |
PC_SCH_FIELD5 |
Character(40) |
VARCHAR2(40) NOT NULL |
Generic field used for Projects Third Party Schedule Integration.
|
| 86 |
PC_SCH_FIELD6 |
Character(40) |
VARCHAR2(40) NOT NULL |
Generic field used for Projects Third Party Schedule Integration.
|
| 87 |
PC_SCH_FIELD7 |
Character(40) |
VARCHAR2(40) NOT NULL |
Generic field used for Projects Third Party Schedule Integration.
|
| 88 |
SUMMARY_ACT |
Character(1) |
VARCHAR2(1) NOT NULL |
Flag to indicate whether an activity is summary or detail.
N=Detail Activity
Y=Summary Activity
Default Value: N
|
| 89 |
PC_DURATION |
Number(11,2) |
DECIMAL(10,2) NOT NULL |
Duration
|
| 90 |
ENFORCE |
Character(1) |
VARCHAR2(1) NOT NULL |
Enforce project team based prompt. Besides the defined translate values, this field is updated with a value of 'N' when team is not enforced in any of the products.
E=Expenses
N=No
T=Time&Labor
Y=Exp and TL
|
| 91 |
PC_CHC_ACT_SW |
Character(1) |
VARCHAR2(1) NOT NULL |
Enable Change Control
Default Value: PROJECT.PC_CHC_SW
|
| 92 |
PGM_SCHED_METHOD |
Character(1) |
VARCHAR2(1) NOT NULL |
The method to be used for Project Scheduling. Valid methods are: Fixed Units, Fixed Duration, and Fixed Work
D=Fixed Duration
U=Fixed Units
W=Fixed Work
Default Value: PROJECT.PGM_SCHED_METHOD
|
| 93 |
WBS_ID |
Character(100) |
VARCHAR2(100) NOT NULL |
WBS ID
|
| 94 |
LEVEL1 |
Number(5,0) |
INTEGER NOT NULL |
Level 1
|
| 95 |
LEVEL2 |
Number(5,0) |
INTEGER NOT NULL |
Level 2
|
| 96 |
LEVEL3 |
Number(5,0) |
INTEGER NOT NULL |
Level 3
|
| 97 |
LEVEL4 |
Number(5,0) |
INTEGER NOT NULL |
Level 4
|
| 98 |
LEVEL5 |
Number(5,0) |
INTEGER NOT NULL |
Level 5
|
| 99 |
LEVEL6 |
Number(5,0) |
INTEGER NOT NULL |
Level 6
|
| 100 |
LEVEL7 |
Number(5,0) |
INTEGER NOT NULL |
Level 7
|
| 101 |
LEVEL8 |
Number(5,0) |
INTEGER NOT NULL |
Level 8
|
| 102 |
LEVEL9 |
Number(5,0) |
INTEGER NOT NULL |
Level 9
|
| 103 |
LEVEL10 |
Number(5,0) |
INTEGER NOT NULL |
Level 10
|
| 104 |
LEVEL11 |
Number(5,0) |
INTEGER NOT NULL |
Level 11
|
| 105 |
LEVEL12 |
Number(5,0) |
INTEGER NOT NULL |
Level 12
|
| 106 |
LEVEL13 |
Number(5,0) |
INTEGER NOT NULL |
Level 13
|
| 107 |
LEVEL14 |
Number(5,0) |
INTEGER NOT NULL |
Level 14
|
| 108 |
LEVEL15 |
Number(5,0) |
INTEGER NOT NULL |
Level 15
|
| 109 |
LEVEL16 |
Number(5,0) |
INTEGER NOT NULL |
Level 16
|
| 110 |
LEVEL17 |
Number(5,0) |
INTEGER NOT NULL |
Level 17
|
| 111 |
LEVEL18 |
Number(5,0) |
INTEGER NOT NULL |
Level 18
|
| 112 |
LEVEL19 |
Number(5,0) |
INTEGER NOT NULL |
Level 19
|
| 113 |
LEVEL20 |
Number(5,0) |
INTEGER NOT NULL |
Level 20
|
| 114 |
LEVEL21 |
Number(5,0) |
INTEGER NOT NULL |
Level 21
|
| 115 |
LEVEL22 |
Number(5,0) |
INTEGER NOT NULL |
Level 22
|
| 116 |
LEVEL23 |
Number(5,0) |
INTEGER NOT NULL |
Level 23
|
| 117 |
LEVEL24 |
Number(5,0) |
INTEGER NOT NULL |
Level 24
|
| 118 |
LEVEL25 |
Number(5,0) |
INTEGER NOT NULL |
Level 25
|
| 119 |
LEVEL26 |
Number(5,0) |
INTEGER NOT NULL |
Level 26
|
| 120 |
LEVEL_NUM |
Number(3,0) |
SMALLINT NOT NULL |
Level
|
| 121 |
ROW_NUMBER_5 |
Number(5,0) |
INTEGER NOT NULL |
Row Number
|
| 122 |
DEADLINE_DT |
Date(10) |
DATE |
Deadline Date
|
| 123 |
CONSTRAINT_DT |
Date(10) |
DATE |
Constraint Date
|
| 124 |
CONSTRAINT_TYPE |
Character(4) |
VARCHAR2(4) NOT NULL |
Constraint Type
ALAP=As Late As Possible
ASAP=As Soon As Possible
ENET=End No Earlier Than
ENLT=End No Later Than
MEO=Must End On
MSO=Must Start On
SNET=Start No Earlier Than
SNLT=Start No Later Than
|
| 125 |
COSTING_ACT_SW |
Character(1) |
VARCHAR2(1) NOT NULL |
Activity Costing Switch - determines whether an activity is available for charging. 'Y' = charging is allowed; 'N' = charging is not allowed.
|
| 126 |
PC_ACT_OWNER |
Character(11) |
VARCHAR2(11) NOT NULL |
Activity Owner - The employee id of the individual who is responsible for the execution of an activity or a group of activities.
Prompt Table:
PC_TEAM_PROM_VW
|
| 127 |
CURRENCY_CD |
Character(3) |
VARCHAR2(3) NOT NULL |
Currency Code
Default Value: PROJECT.CURRENCY_CD
|
| 128 |
PC_ACT_DEF_CALC_MT |
Character(1) |
VARCHAR2(1) NOT NULL |
Activity Calculation Method
D=Duration
E=End Date
S=Start Date
Default Value: PROJECT.PC_ACT_DEF_CALC_MT
|
| 129 |
PARTICIPATING |
Character(1) |
VARCHAR2(1) NOT NULL |
Participating
Y/N Table Edit
Default Value: Y
|
| 130 |
PROJECT_OBJECTID |
Number(10,0) |
DECIMAL(10) NOT NULL |
A unique ID that is the Project key to a corresponding table in an external system such as Primavera.
|
| 131 |
ACTIVITY_OBJECTID |
Number(10,0) |
DECIMAL(10) NOT NULL |
A unique ID that is the Activity key to a corresponding table in an external system such as Primavera.
|
| 132 |
NEW_NEXTID |
Character(1) |
VARCHAR2(1) NOT NULL |
Indicator that a new "next" ID was assigned.
|
| 133 |
ERR_REASON |
Character(3) |
VARCHAR2(3) NOT NULL |
Reason code for error
ACT=Activity Error
DUP=Duplicate
EDT=Invalid Field Value
PRJ=Project Error
REQ=Required Field Missing
SUM=Resource at Summary Activity
|
| 134 |
P6_WBS_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
A flag, when set to Y(es) indicates that an activity originated from a Primavera WBS.
N=Activity
Y=Work Breakdown Structure
|
| 135 |
P6_ACTIVITY_GUID |
Character(36) |
VARCHAR2(36) NOT NULL |
P6 ACTIVITY GUID
|