| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 PROCESS_INSTANCE |
Number(10,0) |
DECIMAL(10) NOT NULL |
Process Instance
|
| 2 |
RUN_CNTL_ID |
Character(30) |
VARCHAR2(30) NOT NULL |
Run Control ID
|
| 3 |
OPRID |
Character(30) |
VARCHAR2(30) NOT NULL |
A user's ID (see PSOPRDEFN).
|
| 4 |
REQUEST_NBR |
Number(4,0) |
SMALLINT NOT NULL |
Request Number
|
| 5 |
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.
|
| 6 |
PC_DEL_OPTION |
Character(3) |
VARCHAR2(3) NOT NULL |
Used in the Project Delete Utility to determine level of deletion: Project, Activity or Resource
ACT=Activity Level Deletion
PRJ=Project Level Deletion
RES=Transaction Level Deletion
|
| 7 |
PC_DEL_ANLGRP |
Character(5) |
VARCHAR2(5) NOT NULL |
The analysis group from which resource rows will be deleted.
|
| 8 |
PC_DEL_ANTYP |
Character(3) |
VARCHAR2(3) NOT NULL |
Analysis Type selected for the Project Deletion Process
|
| 9 |
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.
|
| 10 |
PC_PROJ_REC_NAME |
Character(20) |
VARCHAR2(20) NOT NULL |
Project Record (Table)
|
| 11 |
PC_ACT_REC_NAME |
Character(20) |
VARCHAR2(20) NOT NULL |
Activity Record (Table)
|
| 12 |
BUSINESS_UNIT |
Character(5) |
VARCHAR2(5) NOT NULL |
Business Unit
|
| 13 |
PROJECT_ID |
Character(15) |
VARCHAR2(15) NOT NULL |
Project Id ChartField
|
| 14 |
DESCR |
Character(30) |
VARCHAR2(30) NOT NULL |
Description
|
| 15 |
ACTIVITY_ID |
Character(15) |
VARCHAR2(15) NOT NULL |
Activity ID
|
| 16 |
PC_DEL_ACT_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
Flag to determine whether to delete an activity when using the Project Delete Utility at the activity level.
N=Do Not Delete Activity
Y=Delete Activity
|
| 17 |
WORK_CNT |
Number(10,0) |
DECIMAL(10) NOT NULL |
Count of Anything
|
| 18 |
WORK_FIELD |
Character(37) |
VARCHAR2(37) NOT NULL |
Work_field
|
| 19 |
TREE_NAME |
Character(18) |
VARCHAR2(18) NOT NULL |
Tree Name
|
| 20 |
TREE_EFFDT |
Date(10) |
DATE |
Effective date of the Tree
|
| 21 |
WBS_TREE_NAME |
Character(18) |
VARCHAR2(18) NOT NULL |
WBS Tree Name
|
| 22 |
WBS_TREE_EFFDT |
Date(10) |
DATE |
Effective date of a WBS Tree.
|
| 23 |
PC_DEL_SQL_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
This field will indicate which FROM / WHERE clause to use during the Project Delete Process. Y=use analysis group, N=don't use analysis group, P=project only -- do not use activity id.
A=Activity Level Delete
P=Project level
R=Res Delete with Analysis Group
S=Res Del w/ Anal Grp & Sys Src
T=Res Delete with Analysis Type
U=Res Del w/ Anal Type & Sys Src
|
| 24 |
PC_DEL_TREE_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
This is a flag to indicate whether deletion of project tree nodes are allowed or not during the Project Delete process.
N=Proj Tree Delete Not Allowed
Y=Allow Project Tree Delete
|
| 25 |
PC_DEL_SEC_LST_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
This is a flag to indicate whether rows should be deleted from the security project list tables during the Project Delete process.
N=Sec Proj List Del Not Allowed
Y=Allow Sec Proj List Delete
|
| 26 |
PC_DEL_RES_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
This flag will indicate whether it is allowable to delete a Project or Activities if there are resource rows associated with the object(s) being deleted? If set, deleting a Project or Activity will also delete the associated resource rows. If not set, the delete request will not be allowed until the resources have been deleted.
N=No PRJ/ACT delete w/Resources
Y=Allow PRJ/ACT delete w/Resrces
|
| 27 |
RETURN_CD |
Character(1) |
VARCHAR2(1) NOT NULL |
Return Code
0=Return OK
1=Return error
|
| 28 |
PC_PROJ_CNT |
Number(7,0) |
INTEGER NOT NULL |
Number of projects
|
| 29 |
PC_ACT_CNT |
Number(7,0) |
INTEGER NOT NULL |
Number of activities
|
| 30 |
PC_RES_CNT |
Number(7,0) |
INTEGER NOT NULL |
Number of resource rows
|
| 31 |
PC_SEC_CNT |
Number(7,0) |
INTEGER NOT NULL |
Number of project security rows
|
| 32 |
PC_CHC_COUNT |
Number(15,0) |
DECIMAL(15) NOT NULL |
Count of Changes
|
| 33 |
MESSAGE_TEXT |
Character(100) |
VARCHAR2(100) NOT NULL |
Message Text This field refers to the Text for a particular Message Number in the Message Catalog.
|
| 34 |
LEVEL_NUM |
Number(3,0) |
SMALLINT NOT NULL |
Level
|
| 35 |
LEVEL1 |
Number(5,0) |
INTEGER NOT NULL |
Level 1
|
| 36 |
LEVEL2 |
Number(5,0) |
INTEGER NOT NULL |
Level 2
|
| 37 |
LEVEL3 |
Number(5,0) |
INTEGER NOT NULL |
Level 3
|
| 38 |
LEVEL4 |
Number(5,0) |
INTEGER NOT NULL |
Level 4
|
| 39 |
LEVEL5 |
Number(5,0) |
INTEGER NOT NULL |
Level 5
|
| 40 |
LEVEL6 |
Number(5,0) |
INTEGER NOT NULL |
Level 6
|
| 41 |
LEVEL7 |
Number(5,0) |
INTEGER NOT NULL |
Level 7
|
| 42 |
LEVEL8 |
Number(5,0) |
INTEGER NOT NULL |
Level 8
|
| 43 |
LEVEL9 |
Number(5,0) |
INTEGER NOT NULL |
Level 9
|
| 44 |
LEVEL10 |
Number(5,0) |
INTEGER NOT NULL |
Level 10
|
| 45 |
LEVEL11 |
Number(5,0) |
INTEGER NOT NULL |
Level 11
|
| 46 |
LEVEL12 |
Number(5,0) |
INTEGER NOT NULL |
Level 12
|
| 47 |
LEVEL13 |
Number(5,0) |
INTEGER NOT NULL |
Level 13
|
| 48 |
LEVEL14 |
Number(5,0) |
INTEGER NOT NULL |
Level 14
|
| 49 |
LEVEL15 |
Number(5,0) |
INTEGER NOT NULL |
Level 15
|
| 50 |
LEVEL16 |
Number(5,0) |
INTEGER NOT NULL |
Level 16
|
| 51 |
LEVEL17 |
Number(5,0) |
INTEGER NOT NULL |
Level 17
|
| 52 |
LEVEL18 |
Number(5,0) |
INTEGER NOT NULL |
Level 18
|
| 53 |
LEVEL19 |
Number(5,0) |
INTEGER NOT NULL |
Level 19
|
| 54 |
LEVEL20 |
Number(5,0) |
INTEGER NOT NULL |
Level 20
|
| 55 |
LEVEL21 |
Number(5,0) |
INTEGER NOT NULL |
Level 21
|
| 56 |
LEVEL22 |
Number(5,0) |
INTEGER NOT NULL |
Level 22
|
| 57 |
LEVEL23 |
Number(5,0) |
INTEGER NOT NULL |
Level 23
|
| 58 |
LEVEL24 |
Number(5,0) |
INTEGER NOT NULL |
Level 24
|
| 59 |
LEVEL25 |
Number(5,0) |
INTEGER NOT NULL |
Level 25
|
| 60 |
LEVEL26 |
Number(5,0) |
INTEGER NOT NULL |
Level 26
|
| 61 |
WORK_CNT1 |
Number(10,0) |
DECIMAL(10) NOT NULL |
Work Count 1
|
| 62 |
WORK_CNT2 |
Number(10,0) |
DECIMAL(10) NOT NULL |
Work Count 2
|
| 63 |
WORK_CNT3 |
Number(10,0) |
DECIMAL(10) NOT NULL |
Work Count 3
|
| 64 |
WORK_CNT4 |
Number(10,0) |
DECIMAL(10) NOT NULL |
Work Count 4
|
| 65 |
WORK_CNT5 |
Number(10,0) |
DECIMAL(10) NOT NULL |
Work Count 5
|
| 66 |
WORK_CNT6 |
Number(10,0) |
DECIMAL(10) NOT NULL |
Work Count 6
|
| 67 |
WORK_CNT7 |
Number(10,0) |
DECIMAL(10) NOT NULL |
Work Count 7
|
| 68 |
WORK_CNT8 |
Number(8,0) |
INTEGER NOT NULL |
Count of Anything
|
| 69 |
WORK_CNT9 |
Number(8,0) |
INTEGER NOT NULL |
Count of Anything
|
| 70 |
WORK_CNT10 |
Number(8,0) |
INTEGER NOT NULL |
Count of Anything
|
| 71 |
WORK_CNT11 |
Number(8,0) |
INTEGER NOT NULL |
Count of Anything
|
| 72 |
WORK_CNT12 |
Number(8,0) |
INTEGER NOT NULL |
Count of Anything
|
| 73 |
WORK_CNT13 |
Number(8,0) |
INTEGER NOT NULL |
Count of Anything
|
| 74 |
WORK_CNT14 |
Number(8,0) |
INTEGER NOT NULL |
Count of Anything
|
| 75 |
WORK_CNT15 |
Number(8,0) |
INTEGER NOT NULL |
Count of Anything
|
| 76 |
WORK_CNT16 |
Number(8,0) |
INTEGER NOT NULL |
Count of Anything
|
| 77 |
WORK_CNT17 |
Number(8,0) |
INTEGER NOT NULL |
Count of Anything
|
| 78 |
WORK_CNT18 |
Number(8,0) |
INTEGER NOT NULL |
Count of Anything
|
| 79 |
WORK_CNT19 |
Number(8,0) |
INTEGER NOT NULL |
Count of Anything
|
| 80 |
WORK_CNT20 |
Number(20,0) |
DECIMAL(20) NOT NULL |
This field is a counter of 20 digits for general usage.
|
| 81 |
WORK_CNT21 |
Number(8,0) |
INTEGER NOT NULL |
Count of Anything
|
| 82 |
WORK_CNT22 |
Number(8,0) |
INTEGER NOT NULL |
Count of Anything
|
| 83 |
WORK_CNT23 |
Number(8,0) |
INTEGER NOT NULL |
Count of Anything
|
| 84 |
WORK_CNT24 |
Number(8,0) |
INTEGER NOT NULL |
Count of Anything
|
| 85 |
WORK_CNT25 |
Number(8,0) |
INTEGER NOT NULL |
Count of Anything
|
| 86 |
WORK_CNT26 |
Number(8,0) |
INTEGER NOT NULL |
Count of Anything
|
| 87 |
WBS_ID |
Character(100) |
VARCHAR2(100) NOT NULL |
WBS ID
|
| 88 |
ROW_NUMBER_5 |
Number(5,0) |
INTEGER NOT NULL |
Row Number
|
| 89 |
UPDATE_CLAUSE |
Character(254) |
VARCHAR2(254) NOT NULL |
Meta SQL
|