| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
TIP_STAGE |
Character(7) |
VARCHAR2(7) NOT NULL |
Transactions In Progress
|
| 2 |
 BUSINESS_UNIT |
Character(5) |
VARCHAR2(5) NOT NULL |
Business Unit
Prompt Table:
SP_BU_PC_NONVW
|
| 3 |
PROJECT_ID |
Character(15) |
VARCHAR2(15) NOT NULL |
Project Id ChartField
Default Value: PROJ_ACTIVITY.PROJECT_ID
Prompt Table:
SP_PROJ_NONVW
|
| 4 |
ACTIVITY_ID |
Character(15) |
VARCHAR2(15) NOT NULL |
Activity ID
Default Value: PROJ_ACTIVITY.ACTIVITY_ID
Prompt Table:
PROJ_ACT_SRCH
|
| 5 |
RESOURCE_ID |
Character(40) |
VARCHAR2(40) NOT NULL |
Transaction ID
|
| 6 |
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.
|
| 7 |
PROJECT_MANAGER |
Character(11) |
VARCHAR2(11) NOT NULL |
Project Manager
Prompt Table:
PROJECT_TEAM_VW
|
| 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 |
EMPLOYEE_NAME |
Character(11) |
VARCHAR2(11) NOT NULL |
Employee
Prompt Table:
%EDITTABLE
|
| 10 |
RESOURCE_TYPE |
Character(5) |
VARCHAR2(5) NOT NULL |
Source Type
Prompt Table:
PROJ_RES_TYPE
|
| 11 |
RESOURCE_CATEGORY |
Character(5) |
VARCHAR2(5) NOT NULL |
Category
Prompt Table:
%EDITTABLE
|
| 12 |
RESOURCE_SUB_CAT |
Character(5) |
VARCHAR2(5) NOT NULL |
Subcategory
Prompt Table:
%EDITTABLE2
|
| 13 |
FROM_DATE |
Date(10) |
DATE |
From Date
|
| 14 |
THRU_DATE |
Date(10) |
DATE |
Through Date
|
| 15 |
DATE_RANGE_OPTN |
Character(1) |
VARCHAR2(1) NOT NULL |
Date Option
A=Accounting Date
E=All
T=Transaction Date
|
| 16 |
PROJECT_STATUS |
Character(1) |
VARCHAR2(1) NOT NULL |
Project Status
B=Budgeted
C=Closed
H=Hold
O=Open
P=Proposed
|
| 17 |
DAYS_INACT_RANGE |
Character(3) |
VARCHAR2(3) NOT NULL |
Days Inactive Range
-30=< 31
30=31 to 60
60=61 to 90
90+=> 90
A=All
|