| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 BUSINESS_UNIT |
Character(5) |
VARCHAR2(5) NOT NULL |
Business Unit
Prompt Table:
SP_BU_PC_NONVW
|
| 2 |
PROJECT_ID |
Character(15) |
VARCHAR2(15) NOT NULL |
Project Id ChartField
Prompt Table:
SP_PROJ_NONVW
|
| 3 |
PC_CPY_UNIQUEID |
Character(15) |
VARCHAR2(15) NOT NULL |
Copy Unique ID
|
| 4 |
LAST_ACTIVITY_ID |
Number(8,0) |
INTEGER NOT NULL |
Last Actvity ID
|
| 5 |
EFF_STATUS |
Character(1) |
VARCHAR2(1) NOT NULL |
Effective Status
A=Active
I=Inactive
Default Value: A
|
| 6 |
IN_USE_SW |
Character(1) |
VARCHAR2(1) NOT NULL |
Table in use switch
|
| 7 |
INTEGRATION_TMPL |
Character(15) |
VARCHAR2(15) NOT NULL |
Integration
Default Value: OPR_DEF_TBL_PC.INTEGRATION_TMPL
|
| 8 |
DESCR |
Character(30) |
VARCHAR2(30) NOT NULL |
Description
|
| 9 |
PROJECT_TYPE |
Character(5) |
VARCHAR2(5) NOT NULL |
Project Type
A=Activity
G=Grant
H=Phase
P=Project
S=Segment
|
| 10 |
BUSINESS_UNIT_AM |
Character(5) |
VARCHAR2(5) NOT NULL |
AM Business Unit
Default Value: PC_INT_TMPL.BUSINESS_UNIT_AM
|
| 11 |
ASSET_ID |
Character(12) |
VARCHAR2(12) NOT NULL |
Asset Identification
|
| 12 |
PROFILE_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Asset Profile ID
|
| 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: PPC
|
| 14 |
TEMPLATE_ID |
Character(30) |
VARCHAR2(30) NOT NULL |
Project Template
Default Value: OPR_DEF_TBL_PC.TEMPLATE_ID
|
| 15 |
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
|
| 16 |
AFUDC_PROJ_SW |
Character(1) |
VARCHAR2(1) NOT NULL |
Allow Interest Calculation
Y/N Table Edit
Default Value: N
|
| 17 |
TARGET_PROJ_SW |
Character(1) |
VARCHAR2(1) NOT NULL |
Allocation Target
Y/N Table Edit
Default Value: N
|
| 18 |
SALES_TAX_PROJ_SW |
Character(1) |
VARCHAR2(1) NOT NULL |
Allow Sales Tax Calculation
Y/N Table Edit
Default Value: N
|
| 19 |
DOCKET_NUMBER |
Character(15) |
VARCHAR2(15) NOT NULL |
Docket Number
|
| 20 |
PROJECT_FUNCTION |
Character(10) |
VARCHAR2(10) NOT NULL |
Project Function
|
| 21 |
LAST_CRITERIA_ID |
Number(8,0) |
INTEGER NOT NULL |
Last Criteria ID
|
| 22 |
CURRENCY_CD |
Character(3) |
VARCHAR2(3) NOT NULL |
Currency Code
Default Value: BUS_UNIT_TBL_PC.CURRENCY_CD
|
| 23 |
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
|
| 24 |
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
|
| 25 |
PERCENT_COMPLETE |
Number(6,2) |
DECIMAL(5,2) NOT NULL |
% Complete
|
| 26 |
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
|
| 27 |
PROJECT_USER1 |
Character(10) |
VARCHAR2(10) NOT NULL |
Project User 1
|
| 28 |
PROJECT_USER2 |
Character(10) |
VARCHAR2(10) NOT NULL |
Project User 2
|
| 29 |
PROJECT_USER3 |
Character(10) |
VARCHAR2(10) NOT NULL |
Project User 3
|
| 30 |
PROJECT_USER4 |
Character(10) |
VARCHAR2(10) NOT NULL |
Project User 4
|
| 31 |
PROJECT_USER5 |
Character(10) |
VARCHAR2(10) NOT NULL |
Project User 5
|
| 32 |
PROJECT_USER_DT1 |
Date(10) |
DATE |
Date 1
|
| 33 |
PROJECT_USER_DT2 |
Date(10) |
DATE |
Date 2
|
| 34 |
PC_USER_CURRENCY |
Character(3) |
VARCHAR2(3) NOT NULL |
User Currency
|
| 35 |
PROJECT_USERAMT1 |
Signed Number(17,2) |
DECIMAL(15,2) NOT NULL |
Amount 1
|
| 36 |
PROJECT_USERAMT2 |
Signed Number(17,2) |
DECIMAL(15,2) NOT NULL |
Amount 2
|
| 37 |
PROJECT_USERAMT3 |
Signed Number(17,2) |
DECIMAL(15,2) NOT NULL |
Amount 3
|
| 38 |
AN_GRP_ACTV_BUD |
Character(5) |
VARCHAR2(5) NOT NULL |
Budget Analysis Group
Default Value: INSTALLATION_PC.AN_GRP_ACTV_BUD
|
| 39 |
AN_GRP_TOT_COSTS |
Character(5) |
VARCHAR2(5) NOT NULL |
Cost Analysis Group
Default Value: INSTALLATION_PC.AN_GRP_TOT_COSTS
|
| 40 |
SET_OVERRIDE |
Character(5) |
VARCHAR2(5) NOT NULL |
FS_08 SetID
Default Value: PROJECT.BUSINESS_UNIT
|
| 41 |
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.
|
| 42 |
PC_MSP_USR1 |
Character(10) |
VARCHAR2(10) NOT NULL |
Microsoft User Define1
|
| 43 |
PC_MSP_USR2 |
Character(10) |
VARCHAR2(10) NOT NULL |
Microsoft User Define2
|
| 44 |
PC_MSP_PROJ_ID |
Character(22) |
VARCHAR2(22) NOT NULL |
Unique MSP Project ID
|
| 45 |
PC_REV_ACTIVITY |
Character(15) |
VARCHAR2(15) NOT NULL |
Revenue Activity
|
| 46 |
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
|
| 47 |
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
|
| 48 |
TOLERANCE |
Signed Number(13,8) |
DECIMAL(11,8) NOT NULL |
Tolerance Percent
|
| 49 |
PROJ_GRANT_STATUS |
Character(1) |
VARCHAR2(1) NOT NULL |
Status
A=Approved
C=Completed
I=In Progress
P=Proposed
|
| 50 |
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
|
| 51 |
GM_PRIMARY_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
This field is used to indicate a Project as a Primary Project
|
| 52 |
PC_TEMPLATE_ID |
Character(15) |
VARCHAR2(15) NOT NULL |
Rate Template ID
|
| 53 |
PC_FND_DIST_SW |
Character(1) |
VARCHAR2(1) NOT NULL |
This field is used to indicate the use of Funds Distribution functionality.
|
| 54 |
START_DT |
Date(10) |
DATE |
Start Date
|
| 55 |
END_DT |
Date(10) |
DATE |
End Date
|
| 56 |
BASELINE_START_DT |
Date(10) |
DATE |
Baseline Start Date
|
| 57 |
BASELINE_FINISH_DT |
Date(10) |
DATE |
Baseline Finish Date
|
| 58 |
EARLY_START_DT |
Date(10) |
DATE |
Early Start Date
|
| 59 |
EARLY_FINISH_DT |
Date(10) |
DATE |
Early Finish Date
|
| 60 |
ACTUAL_START_DT |
Date(10) |
DATE |
Actual Start Date
|
| 61 |
ACTUAL_FINISH_DT |
Date(10) |
DATE |
Actual Finish Date
|
| 62 |
LATE_START_DT |
Date(10) |
DATE |
Late Start Date
|
| 63 |
LATE_FINISH_DT |
Date(10) |
DATE |
Late Finish Date
|
| 64 |
PC_DURATION |
Number(11,2) |
DECIMAL(10,2) NOT NULL |
Duration
|
| 65 |
SUMMARY_PRJ |
Character(1) |
VARCHAR2(1) NOT NULL |
An indicator to determine whether project is summary or detail.
N=Detail Project
Y=Program
|
| 66 |
PC_CHC_SW |
Character(1) |
VARCHAR2(1) NOT NULL |
Enable Change Control
|
| 67 |
PC_CHC_TEMPLATE |
Character(30) |
VARCHAR2(30) NOT NULL |
Change Control Template
|
| 68 |
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
|
| 69 |
PC_PRJ_DEF_CALC_MT |
Character(1) |
VARCHAR2(1) NOT NULL |
Calculate The
D=Duration
E=End Date
S=Start Date
|
| 70 |
PC_ACT_DEF_CALC_MT |
Character(1) |
VARCHAR2(1) NOT NULL |
Activity Calculation Method
D=Duration
E=End Date
S=Start Date
|
| 71 |
PC_HOURS_PER_DAY |
Number(2,0) |
SMALLINT NOT NULL |
Hours per Day
|
| 72 |
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
|
| 73 |
PC_SUM_METHOD |
Character(1) |
VARCHAR2(1) NOT NULL |
Summary Method
N=None
S=Straight-Line
W=Weighted
|
| 74 |
PM_AUTO_REVIEW |
Character(1) |
VARCHAR2(1) NOT NULL |
Auto Review for Billing
N=Not Reviewed
Y=Reviewed
|
| 75 |
PM_AUTO_POP |
Character(1) |
VARCHAR2(1) NOT NULL |
Auto review for POP
N=No
Y=Yes
|
| 76 |
FORECAST_AUT_APP |
Character(1) |
VARCHAR2(1) NOT NULL |
Automatic Forecast Approval
N=No
Y=Yes
|
| 77 |
FORECAST_LEVEL |
Character(1) |
VARCHAR2(1) NOT NULL |
Forecast Level
A=Project/Activity
P=Project
|
| 78 |
FORECAST_RATE |
Character(1) |
VARCHAR2(1) NOT NULL |
Standard Rate
E=Resource
J=Job Code
R=Role
|
| 79 |
FORECAST_SRC |
Character(1) |
VARCHAR2(1) NOT NULL |
Forecast Source
F=PeopleSoft Forecast Collection
M=3rd Party Microsoft Project
P=3rd Party Primavera
|
| 80 |
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
|
| 81 |
HOLIDAY_LIST_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
This is used to identify what holiday calendar to use. This is the access
field for all financials groups.
|
| 82 |
FMS_DTTM_STAMP |
DateTime(26) |
TIMESTAMP |
Specifies the date and time of the original entry.
|
| 83 |
FMS_OPRID |
Character(30) |
VARCHAR2(30) NOT NULL |
Specifies the User ID which made the original entry.
|
| 84 |
FMS_LASTUPDDTTM |
DateTime(26) |
TIMESTAMP |
Specifies the date and time of the last update to an entry.
|
| 85 |
FMS_LASTUPDOPRID |
Character(30) |
VARCHAR2(30) NOT NULL |
Specifies the User ID which made the last update to an entry.
|
| 86 |
CONSTRAINT_DT_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Always Honor Constraint Dates
Default Value: Y
|
| 87 |
CHARGING_LEVEL |
Character(1) |
VARCHAR2(1) NOT NULL |
Project Charging Level - identifies which level of the WBS activities are available for charging.
'D' indicates the detail level, which means all detail activities are available for charging.
'1' indicates level 1 of the WBS is available for charging.
'2' indicates level 2 of the WBS is available for charging.
'3' indicates level 3 of the WBS is available for charging.
1=Costing Level 1
2=Costing Level 2
3=Costing Level 3
D=Detail
Default Value: BUS_UNIT_OPT_PC.CHARGING_LEVEL
|
| 88 |
CHARGING_LEVEL_TR |
Character(1) |
VARCHAR2(1) NOT NULL |
Time Report Charging Level - identifies which level of the WBS activities are available for charging on time reports enter in Expenses.
'D' indicates the detail level, which means all detail activities are available for charging.
'1' indicates level 1 of the WBS is available for charging.
'2' indicates level 2 of the WBS is available for charging.
'3' indicates level 3 of the WBS is available for charging.
1=Costing Level 1
2=Costing Level 2
3=Costing Level 3
D=Detail
Default Value: BUS_UNIT_OPT_PC.CHARGING_LEVEL_TR
|
| 89 |
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.
|
| 90 |
BUDGET_APPROVER |
Character(11) |
VARCHAR2(11) NOT NULL |
Budget Approver - the employee id of the individual who will be responsible for approving budget changes for a given project.
|
| 91 |
SCEN_ADJUST_PCT_TM |
Signed Number(7,2) |
DECIMAL(5,2) NOT NULL |
Scenario Adjustment % for Time
06/09/2004 PR_FS_B005
Added Label - LABOR_ADJUST
|
| 92 |
SCEN_ADJUST_PCT_EX |
Signed Number(7,2) |
DECIMAL(5,2) NOT NULL |
Scenario Adjustment % for Expense
06/09/2004 PR_FS_B005
Added Label NON_LABOR_ADJUST
|
| 93 |
TEMPLATE_TYPES |
Character(1) |
VARCHAR2(1) NOT NULL |
Template Types - used to identify whether a project template is public or private.
R=Private
U=Public
|
| 94 |
PROJ_TMPL_FILTER |
Character(30) |
VARCHAR2(30) NOT NULL |
Template Filter - identifies who is able to view/update a project template. If this field is set to '1', the template is public. If the template is private, this field will contain the operator id of the person who created the template.
|
| 95 |
FNA_REQUESTED |
Character(1) |
VARCHAR2(1) NOT NULL |
Used for Grants type projects only. A flag to indicate whether FNA is requested.
|
| 96 |
MANAGED_BY_WO |
Character(1) |
VARCHAR2(1) NOT NULL |
Indicates whether a project is Work Order Managed.
N=No
Y=Yes
Y/N Table Edit
Default Value: N
|
| 97 |
RELEASE |
Character(15) |
VARCHAR2(15) NOT NULL |
Release - Carries Release Information driven by the BUSINESS_UNIT
|
| 98 |
CATEGORY_IND |
Character(10) |
VARCHAR2(10) NOT NULL |
An additional attribute of the project, program, or project request for further classification. This field is user-defined. Examples of usage include "Strategic", "Operational", "Tactical", etc.
|
| 99 |
APPLICATION_AREA |
Character(10) |
VARCHAR2(10) NOT NULL |
The general area in which an application belongs. Examples: "Financials", "Human Resources", etc.
|
| 100 |
APPLICATION |
Character(10) |
VARCHAR2(10) NOT NULL |
Usually refers to a software application, such as "Payables", "Projects", "Purchasing", etc. An application needs to be defined under an application area.
|
| 101 |
RATE_SELECT |
Character(1) |
VARCHAR2(1) NOT NULL |
This will determine selection of 1) Rate Set and 2) Rate Plan in Project Type, Project and Activity.
1=Rate Set
2=Rate Plan
|
| 102 |
PC_REV_BUD_AN_GRP |
Character(5) |
VARCHAR2(5) NOT NULL |
Revenue budget analysis group
|
| 103 |
AN_GRP_TOT_REV |
Character(5) |
VARCHAR2(5) NOT NULL |
Cost Analysis Group
|
| 104 |
AN_GRP_EAC |
Character(5) |
VARCHAR2(5) NOT NULL |
Analysis group representing the Estimate at Completion (a.k.a. Forecast).
|
| 105 |
RETAIN_HISTORY |
Character(1) |
VARCHAR2(1) NOT NULL |
Indicator to determine how often history is retained.
D=Daily
M=Monthly
Q=Quarterly
W=Weekly
|
| 106 |
AN_GRP_FREV |
Character(5) |
VARCHAR2(5) NOT NULL |
Forecast Revenue analysis group - contains all the analysis types that make up Forecast Revenue.
|
| 107 |
ANLTC_ACT_COST |
Character(5) |
VARCHAR2(5) NOT NULL |
Actual Cost analysis group for profitability reporting - contains all the analysis types that make up Actual Cost.
|
| 108 |
ANLTC_ACT_REV |
Character(5) |
VARCHAR2(5) NOT NULL |
Actual Revenue analysis group for profitability reporting - contains all the analysis types that make up Actual Revenue.
|
| 109 |
ANLTC_FC_COST |
Character(5) |
VARCHAR2(5) NOT NULL |
Forecast Cost analysis group for profitability reporting - contains all the analysis types that make up Forecast Cost.
|
| 110 |
ANLTC_FC_REV |
Character(5) |
VARCHAR2(5) NOT NULL |
Forecast Revenue analysis group for profitability reporting - contains all the analysis types that make up Forecast Revenue.
|
| 111 |
ONE_TARGET_SW |
Character(1) |
VARCHAR2(1) NOT NULL |
Group target definitions
N=No
Y=Yes
Y/N Table Edit
Default Value: BUS_UNIT_OPT_PC.ONE_TARGET_SW
|
| 112 |
P6_INCL_INTGRTN |
Character(1) |
VARCHAR2(1) NOT NULL |
Include In Integration
Y/N Table Edit
|
| 113 |
P6_TEMPLATE_ID |
Character(30) |
VARCHAR2(30) NOT NULL |
P6 Synchronization Template Id
|