| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 BUSINESS_UNIT |
Character(5) |
VARCHAR2(5) NOT NULL |
Business Unit
|
| 2 |
PROJECT_ID |
Character(15) |
VARCHAR2(15) NOT NULL |
Project Id ChartField
|
| 3 |
PROCESS_INSTANCE |
Number(10,0) |
DECIMAL(10) NOT NULL |
Process Instance
|
| 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
|
| 6 |
IN_USE_SW |
Character(1) |
VARCHAR2(1) NOT NULL |
Table in use switch
|
| 7 |
INTEGRATION_TMPL |
Character(15) |
VARCHAR2(15) NOT NULL |
Integration
|
| 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
|
| 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.
|
| 14 |
TEMPLATE_ID |
Character(30) |
VARCHAR2(30) NOT NULL |
Project Template
|
| 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
|
| 16 |
AFUDC_PROJ_SW |
Character(1) |
VARCHAR2(1) NOT NULL |
Allow Interest Calculation
|
| 17 |
TARGET_PROJ_SW |
Character(1) |
VARCHAR2(1) NOT NULL |
Allocation Target
|
| 18 |
SALES_TAX_PROJ_SW |
Character(1) |
VARCHAR2(1) NOT NULL |
Allow Sales Tax Calculation
|
| 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
|
| 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.
|
| 24 |
CUR_EFFDT_TYPE |
Character(1) |
VARCHAR2(1) NOT NULL |
Currency Eff. Date Default
A=Accounting Date
C=Current Date
T=Transaction Date
|
| 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
|
| 27 |
WBS_TREE_NAME |
Character(18) |
VARCHAR2(18) NOT NULL |
WBS Tree Name
|
| 28 |
PROJECT_USER1 |
Character(10) |
VARCHAR2(10) NOT NULL |
Project User 1
|
| 29 |
PROJECT_USER2 |
Character(10) |
VARCHAR2(10) NOT NULL |
Project User 2
|
| 30 |
PROJECT_USER3 |
Character(10) |
VARCHAR2(10) NOT NULL |
Project User 3
|
| 31 |
PROJECT_USER4 |
Character(10) |
VARCHAR2(10) NOT NULL |
Project User 4
|
| 32 |
PROJECT_USER5 |
Character(10) |
VARCHAR2(10) NOT NULL |
Project User 5
|
| 33 |
PROJECT_USER_DT1 |
Date(10) |
DATE |
Date 1
|
| 34 |
PROJECT_USER_DT2 |
Date(10) |
DATE |
Date 2
|
| 35 |
PC_USER_CURRENCY |
Character(3) |
VARCHAR2(3) NOT NULL |
User Currency
|
| 36 |
PROJECT_USERAMT1 |
Signed Number(17,2) |
DECIMAL(15,2) NOT NULL |
Amount 1
|
| 37 |
PROJECT_USERAMT2 |
Signed Number(17,2) |
DECIMAL(15,2) NOT NULL |
Amount 2
|
| 38 |
PROJECT_USERAMT3 |
Signed Number(17,2) |
DECIMAL(15,2) NOT NULL |
Amount 3
|
| 39 |
AN_GRP_ACTV_BUD |
Character(5) |
VARCHAR2(5) NOT NULL |
Budget Analysis Group
|
| 40 |
AN_GRP_TOT_COSTS |
Character(5) |
VARCHAR2(5) NOT NULL |
Cost Analysis Group
|
| 41 |
SET_OVERRIDE |
Character(5) |
VARCHAR2(5) NOT NULL |
FS_08 SetID
|
| 42 |
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.
|
| 43 |
PC_MSP_USR1 |
Character(10) |
VARCHAR2(10) NOT NULL |
Microsoft User Define1
|
| 44 |
PC_MSP_USR2 |
Character(10) |
VARCHAR2(10) NOT NULL |
Microsoft User Define2
|
| 45 |
PC_MSP_PROJ_ID |
Character(22) |
VARCHAR2(22) NOT NULL |
Unique MSP Project ID
|
| 46 |
PC_REV_ACTIVITY |
Character(15) |
VARCHAR2(15) NOT NULL |
Revenue Activity
|
| 47 |
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
|
| 48 |
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
|
| 49 |
TOLERANCE |
Signed Number(13,8) |
DECIMAL(11,8) NOT NULL |
Tolerance Percent
|
| 50 |
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.
|
| 51 |
PC_SCH_PRODUCT |
Character(3) |
VARCHAR2(3) NOT NULL |
Product code used by Projects to determine the third party scheduling product being integrated with.
|
| 52 |
PC_SCH_FIELD1 |
Character(40) |
VARCHAR2(40) NOT NULL |
Generic field used for Projects Third Party Schedule Integration.
|
| 53 |
PC_SCH_FIELD2 |
Character(40) |
VARCHAR2(40) NOT NULL |
Generic field used for Projects Third Party Schedule Integration.
|
| 54 |
PC_SCH_FIELD3 |
Character(40) |
VARCHAR2(40) NOT NULL |
Generic field used for Projects Third Party Schedule Integration.
|
| 55 |
PC_SCH_FIELD4 |
Character(40) |
VARCHAR2(40) NOT NULL |
Generic field used for Projects Third Party Schedule Integration.
|
| 56 |
PC_SCH_FIELD5 |
Character(40) |
VARCHAR2(40) NOT NULL |
Generic field used for Projects Third Party Schedule Integration.
|
| 57 |
PC_SCH_FIELD6 |
Character(40) |
VARCHAR2(40) NOT NULL |
Generic field used for Projects Third Party Schedule Integration.
|
| 58 |
PC_SCH_FIELD7 |
Character(40) |
VARCHAR2(40) NOT NULL |
Generic field used for Projects Third Party Schedule Integration.
|
| 59 |
PC_SCH_FIELD8 |
Character(100) |
VARCHAR2(100) NOT NULL |
Generic field used for Projects Third Party Schedule Integration.
|
| 60 |
PC_INDENT_LEVEL |
Number(3,0) |
SMALLINT NOT NULL |
Tree Indent Level
|
| 61 |
PROJ_GRANT_STATUS |
Character(1) |
VARCHAR2(1) NOT NULL |
Status
A=Approved
C=Completed
I=In Progress
P=Proposed
|
| 62 |
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
|
| 63 |
GM_PRIMARY_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
This field is used to indicate a Project as a Primary Project
|
| 64 |
PC_TEMPLATE_ID |
Character(15) |
VARCHAR2(15) NOT NULL |
Rate Template ID
|
| 65 |
PC_FND_DIST_SW |
Character(1) |
VARCHAR2(1) NOT NULL |
This field is used to indicate the use of Funds Distribution functionality.
|
| 66 |
SUMMARY_PRJ |
Character(1) |
VARCHAR2(1) NOT NULL |
An indicator to determine whether project is summary or detail.
N=Detail Project
Y=Program
|