| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 BUSINESS_UNIT |
Character(5) |
VARCHAR2(5) NOT NULL |
Business Unit
Default Value: OPR_DEF_TBL_PC.BUSINESS_UNIT
Prompt Table:
SP_BU_PC_NONVW
|
| 2 |
PROJECT_ID |
Character(15) |
VARCHAR2(15) NOT NULL |
Project Id ChartField
Prompt Table:
PROJECT_VW
|
| 3 |
LAST_ACTIVITY_ID |
Number(8,0) |
INTEGER NOT NULL |
Last Actvity ID
|
| 4 |
EFF_STATUS |
Character(1) |
VARCHAR2(1) NOT NULL |
Effective Status
A=Active
I=Inactive
Default Value: A
|
| 5 |
IN_USE_SW |
Character(1) |
VARCHAR2(1) NOT NULL |
Table in use switch
Default Value: N
|
| 6 |
INTEGRATION_TMPL |
Character(15) |
VARCHAR2(15) NOT NULL |
Integration
Default Value: OPR_DEF_TBL_PC.INTEGRATION_TMPL
Prompt Table:
PC_INT_TMPL
|
| 7 |
DESCR |
Character(30) |
VARCHAR2(30) NOT NULL |
Description
|
| 8 |
PROJECT_TYPE |
Character(5) |
VARCHAR2(5) NOT NULL |
Project Type
A=Activity
G=Grant
H=Phase
P=Project
S=Segment
Prompt Table:
PROJ_TYPE_TBL
|
| 9 |
BUSINESS_UNIT_AM |
Character(5) |
VARCHAR2(5) NOT NULL |
AM Business Unit
Default Value: PC_INT_TMPL.BUSINESS_UNIT_AM
Prompt Table:
SP_BU_AM_NONVW
|
| 10 |
ASSET_ID |
Character(12) |
VARCHAR2(12) NOT NULL |
Asset Identification
Prompt Table:
PROJ_ASSET_VW
|
| 11 |
PROFILE_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Asset Profile ID
Prompt Table:
PROFILE_PCAM_VW
|
| 12 |
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: PPC
|
| 13 |
TEMPLATE_ID |
Character(30) |
VARCHAR2(30) NOT NULL |
Project Template
Default Value: OPR_DEF_TBL_PC.TEMPLATE_ID
Prompt Table:
PROJECT_TMPL_VW
|
| 14 |
TEMPLATE_SW |
Character(1) |
VARCHAR2(1) NOT NULL |
Allows the user to indicate whether a given bank transfer transaction should be designated as a
Y/N Table Edit
Default Value: N
|
| 15 |
AFUDC_PROJ_SW |
Character(1) |
VARCHAR2(1) NOT NULL |
Allow Interest Calculation
Y/N Table Edit
Default Value: N
|
| 16 |
TARGET_PROJ_SW |
Character(1) |
VARCHAR2(1) NOT NULL |
Allocation Target
Y/N Table Edit
Default Value: N
|
| 17 |
SALES_TAX_PROJ_SW |
Character(1) |
VARCHAR2(1) NOT NULL |
Allow Sales Tax Calculation
Y/N Table Edit
Default Value: N
|
| 18 |
DOCKET_NUMBER |
Character(15) |
VARCHAR2(15) NOT NULL |
Docket Number
|
| 19 |
PROJECT_FUNCTION |
Character(10) |
VARCHAR2(10) NOT NULL |
Project Function
|
| 20 |
LAST_CRITERIA_ID |
Number(8,0) |
INTEGER NOT NULL |
Last Criteria ID
|
| 21 |
CURRENCY_CD |
Character(3) |
VARCHAR2(3) NOT NULL |
Currency Code
Default Value: BUS_UNIT_TBL_PC.CURRENCY_CD
Prompt Table:
CURRENCY_CD_TBL
|
| 22 |
RT_TYPE |
Character(5) |
VARCHAR2(5) NOT NULL |
Defines a category of market rates for currency conversion. Some examples of rate types are commercial, average, floating, and historical.
Default Value: BUS_UNIT_TBL_PC.RT_TYPE
Prompt Table:
RT_TYPE_TBL
|
| 23 |
CUR_EFFDT_TYPE |
Character(1) |
VARCHAR2(1) NOT NULL |
Currency Eff. Date Default
A=Accounting Date
C=Current Date
T=Transaction Date
Default Value: BUS_UNIT_TBL_PC.CUR_EFFDT_TYPE
|
| 24 |
PERCENT_COMPLETE |
Number(6,2) |
DECIMAL(5,2) NOT NULL |
% Complete
|
| 25 |
PC_ACT_OPTION |
Character(1) |
VARCHAR2(1) NOT NULL |
Standard Activities
F=FreeForm Activity ID's
P=Activity ID's by Project Type
Default Value: F
|
| 26 |
PROJECT_USER1 |
Character(10) |
VARCHAR2(10) NOT NULL |
Project User 1
|
| 27 |
PROJECT_USER2 |
Character(10) |
VARCHAR2(10) NOT NULL |
Project User 2
|
| 28 |
PROJECT_USER3 |
Character(10) |
VARCHAR2(10) NOT NULL |
Project User 3
|
| 29 |
PROJECT_USER4 |
Character(10) |
VARCHAR2(10) NOT NULL |
Project User 4
|
| 30 |
PROJECT_USER5 |
Character(10) |
VARCHAR2(10) NOT NULL |
Project User 5
|
| 31 |
PROJECT_USER_DT1 |
Date(10) |
DATE |
Date 1
|
| 32 |
PROJECT_USER_DT2 |
Date(10) |
DATE |
Date 2
|
| 33 |
PC_USER_CURRENCY |
Character(3) |
VARCHAR2(3) NOT NULL |
User Currency
Prompt Table:
CURRENCY_CD_TBL
|
| 34 |
PROJECT_USERAMT1 |
Signed Number(17,2) |
DECIMAL(15,2) NOT NULL |
Amount 1
|
| 35 |
PROJECT_USERAMT2 |
Signed Number(17,2) |
DECIMAL(15,2) NOT NULL |
Amount 2
|
| 36 |
PROJECT_USERAMT3 |
Signed Number(17,2) |
DECIMAL(15,2) NOT NULL |
Amount 3
|
| 37 |
AN_GRP_ACTV_BUD |
Character(5) |
VARCHAR2(5) NOT NULL |
Budget Analysis Group
Default Value: INSTALLATION_PC.AN_GRP_ACTV_BUD
Prompt Table:
SP_AN_GRP_NONVW
|
| 38 |
AN_GRP_TOT_COSTS |
Character(5) |
VARCHAR2(5) NOT NULL |
Cost Analysis Group
Default Value: INSTALLATION_PC.AN_GRP_TOT_COSTS
Prompt Table:
SP_AN_GRP_NONVW
|
| 39 |
SET_OVERRIDE |
Character(5) |
VARCHAR2(5) NOT NULL |
FS_08 SetID
Prompt Table:
SP_SETID_NONVW
|
| 40 |
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.
|
| 41 |
PC_MSP_USR1 |
Character(10) |
VARCHAR2(10) NOT NULL |
Microsoft User Define1
Default Value: BUS_UNIT_OPT_PC.HOLIDAY_LIST_ID
Prompt Table:
BUS_CAL_HOL_VW
|
| 42 |
PC_MSP_USR2 |
Character(10) |
VARCHAR2(10) NOT NULL |
Microsoft User Define2
|
| 43 |
PC_MSP_PROJ_ID |
Character(22) |
VARCHAR2(22) NOT NULL |
Unique MSP Project ID
|
| 44 |
PC_REV_ACTIVITY |
Character(15) |
VARCHAR2(15) NOT NULL |
Revenue Activity
Prompt Table:
PROJ_ACTIVITY
|
| 45 |
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
Default Value: N
|
| 46 |
ENFORCE_TYPE |
Character(1) |
VARCHAR2(1) NOT NULL |
Enforce project and activity team based prompt.
B=Project and Activity Team
N=Do Not Enforce
P=Project Team Only
R=Project Resource Pools Only
S=Project Activity Resource Pool
X=Decide at the Project Level
Default Value: N
|
| 47 |
TOLERANCE |
Signed Number(13,8) |
DECIMAL(11,8) NOT NULL |
Tolerance Percent
Default Value: INSTALLATION_PC.TOLERANCE
|
| 48 |
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.
Prompt Table:
PC_RATE_PLAN
|
| 49 |
PC_SCH_PRODUCT |
Character(3) |
VARCHAR2(3) NOT NULL |
Product code used by Projects to determine the third party scheduling product being integrated with.
Prompt Table:
PC_SCH_PRODUCT
|
| 50 |
PC_SCH_FIELD1 |
Character(40) |
VARCHAR2(40) NOT NULL |
Generic field used for Projects Third Party Schedule Integration.
|
| 51 |
PC_SCH_FIELD2 |
Character(40) |
VARCHAR2(40) NOT NULL |
Generic field used for Projects Third Party Schedule Integration.
|
| 52 |
PC_SCH_FIELD3 |
Character(40) |
VARCHAR2(40) NOT NULL |
Generic field used for Projects Third Party Schedule Integration.
|
| 53 |
PC_SCH_FIELD4 |
Character(40) |
VARCHAR2(40) NOT NULL |
Generic field used for Projects Third Party Schedule Integration.
|
| 54 |
PC_SCH_FIELD5 |
Character(40) |
VARCHAR2(40) NOT NULL |
Generic field used for Projects Third Party Schedule Integration.
|
| 55 |
PC_SCH_FIELD6 |
Character(40) |
VARCHAR2(40) NOT NULL |
Generic field used for Projects Third Party Schedule Integration.
|
| 56 |
PC_SCH_FIELD7 |
Character(40) |
VARCHAR2(40) NOT NULL |
Generic field used for Projects Third Party Schedule Integration.
|
| 57 |
PC_SCH_FIELD8 |
Character(100) |
VARCHAR2(100) NOT NULL |
Generic field used for Projects Third Party Schedule Integration.
|
| 58 |
PC_INDENT_LEVEL |
Number(3,0) |
SMALLINT NOT NULL |
Tree Indent Level
|
| 59 |
PROJ_GRANT_STATUS |
Character(1) |
VARCHAR2(1) NOT NULL |
Status
A=Approved
C=Completed
I=In Progress
P=Proposed
|
| 60 |
GRANT_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Grants Management
Used for designating whether or not an object is for Grants or for Projects.
N=Projects Object
Y=Grants Object
|
| 61 |
GM_PRIMARY_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
This field is used to indicate a Project as a Primary Project
Y/N Table Edit
|
| 62 |
PC_TEMPLATE_ID |
Character(15) |
VARCHAR2(15) NOT NULL |
Rate Template ID
Prompt Table:
PC_RATE_VW2
|
| 63 |
PC_FND_DIST_SW |
Character(1) |
VARCHAR2(1) NOT NULL |
This field is used to indicate the use of Funds Distribution functionality.
Y/N Table Edit
Default Value: N
|
| 64 |
START_DT |
Date(10) |
DATE NOT NULL |
Start Date
Default Value: %Date
|
| 65 |
END_DT |
Date(10) |
DATE NOT NULL |
End Date
Default Value: %Date
|
| 66 |
BASELINE_START_DT |
Date(10) |
DATE |
Baseline Start Date
|
| 67 |
BASELINE_FINISH_DT |
Date(10) |
DATE |
Baseline Finish Date
|
| 68 |
EARLY_START_DT |
Date(10) |
DATE |
Early Start Date
|
| 69 |
EARLY_FINISH_DT |
Date(10) |
DATE |
Early Finish Date
|
| 70 |
ACTUAL_START_DT |
Date(10) |
DATE |
Actual Start Date
|
| 71 |
ACTUAL_FINISH_DT |
Date(10) |
DATE |
Actual Finish Date
|
| 72 |
LATE_START_DT |
Date(10) |
DATE |
Late Start Date
|
| 73 |
LATE_FINISH_DT |
Date(10) |
DATE |
Late Finish Date
|
| 74 |
PC_DURATION |
Number(11,2) |
DECIMAL(10,2) NOT NULL |
Duration
|
| 75 |
PC_DURATION_DAYS |
Number(8,0) |
INTEGER NOT NULL |
Duration in Days
|
| 76 |
SUMMARY_PRJ |
Character(1) |
VARCHAR2(1) NOT NULL |
An indicator to determine whether project is summary or detail.
N=Detail Project
Y=Program
Default Value: N
|
| 77 |
PC_CHC_SW |
Character(1) |
VARCHAR2(1) NOT NULL |
Enable Change Control
Y/N Table Edit
|
| 78 |
PC_CHC_TEMPLATE |
Character(30) |
VARCHAR2(30) NOT NULL |
Change Control Template
Default Value: BUS_UNIT_OPT_PC.PC_CHC_TEMPLATE
Prompt Table:
PC_CHC_CFG
|
| 79 |
PC_CALCULATE_SW |
Character(1) |
VARCHAR2(1) NOT NULL |
Project-level switch to allow auto-calculation to be turned off if enabled at the BU level.
D=Delay Calculations Until Save
M=Manual
R=Realtime Calculations
Default Value: BUS_UNIT_OPT_PC.PC_CALCULATE_SW
|
| 80 |
PC_PRJ_DEF_CALC_MT |
Character(1) |
VARCHAR2(1) NOT NULL |
Calculate The
D=Duration
E=End Date
S=Start Date
Default Value: BUS_UNIT_OPT_PC.PC_PRJ_DEF_CALC_MT
|
| 81 |
PC_ACT_DEF_CALC_MT |
Character(1) |
VARCHAR2(1) NOT NULL |
Activity Calculation Method
D=Duration
E=End Date
S=Start Date
Default Value: BUS_UNIT_OPT_PC.PC_ACT_DEF_CALC_MT
|
| 82 |
PC_HOURS_PER_DAY |
Number(2,0) |
SMALLINT NOT NULL |
Hours per Day
Default Value: BUS_UNIT_OPT_PC.PC_HOURS_PER_DAY
|
| 83 |
PC_CALC_METHOD |
Character(1) |
VARCHAR2(1) NOT NULL |
Calculation Method
A=Budget Amount
D=Duration
F=Forecast Amount
H=Forecast Hours
M=Manual
U=Budget Hours
Default Value: BUS_UNIT_OPT_PC.PC_CALC_METHOD
|
| 84 |
PC_SUM_METHOD |
Character(1) |
VARCHAR2(1) NOT NULL |
Summary Method
N=None
S=Straight-Line
W=Weighted
Default Value: BUS_UNIT_OPT_PC.PC_SUM_METHOD
|
| 85 |
PM_AUTO_REVIEW |
Character(1) |
VARCHAR2(1) NOT NULL |
Auto Review for Billing
N=Not Reviewed
Y=Reviewed
Default Value: PROJ_TYPE_TBL.PM_AUTO_REVIEW
|
| 86 |
FORECAST_AUT_APP |
Character(1) |
VARCHAR2(1) NOT NULL |
Automatic Forecast Approval
N=No
Y=Yes
Default Value: N
|
| 87 |
FORECAST_LEVEL |
Character(1) |
VARCHAR2(1) NOT NULL |
Forecast Level
A=Project/Activity
P=Project
Default Value: A
|
| 88 |
FORECAST_RATE |
Character(1) |
VARCHAR2(1) NOT NULL |
Standard Rate
E=Resource
J=Job Code
R=Role
Default Value: R
|
| 89 |
FORECAST_SRC |
Character(1) |
VARCHAR2(1) NOT NULL |
Forecast Source
F=PeopleSoft Forecast Collection
M=3rd Party Microsoft Project
P=3rd Party Primavera
Default Value: F
|