| # |
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 |
PC_COPY_OPTION |
Character(4) |
VARCHAR2(4) NOT NULL |
Copy Options
ACTV=Copy Activity Only
BOTH=Copy Project & All Activities
PROJ=Copy Project Only
|
| 6 |
TEMPLATE_ID |
Character(30) |
VARCHAR2(30) NOT NULL |
Project Template
|
| 7 |
PROJECT_ID_TARGET |
Character(15) |
VARCHAR2(15) NOT NULL |
Project ID
|
| 8 |
COPY_ANALYSIS_GRP |
Character(5) |
VARCHAR2(5) NOT NULL |
Copy Analysis Group
|
| 9 |
PC_RES_COPY_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Allow Transactions Copy
N=No
Y=Yes
|
| 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 |
PC_RES_REC_NAME |
Character(20) |
VARCHAR2(20) NOT NULL |
Transaction Record (Table)
|
| 13 |
PC_TEMP_REC_NAME |
Character(20) |
VARCHAR2(20) NOT NULL |
Temporary Record (Table)
|
| 14 |
ACTIVITY_ID |
Character(15) |
VARCHAR2(15) NOT NULL |
Activity ID
|
| 15 |
ACT_TEMPLATE_ID |
Character(15) |
VARCHAR2(15) NOT NULL |
Activity Template
|
| 16 |
BUSINESS_UNIT |
Character(5) |
VARCHAR2(5) NOT NULL |
Business Unit
|
| 17 |
PC_CPY_UNIQUEID |
Character(15) |
VARCHAR2(15) NOT NULL |
Copy Unique ID
|
| 18 |
LAST_PROJECT_ID |
Number(15,0) |
DECIMAL(15) NOT NULL |
Last Project ID
|
| 19 |
PROJ_FLD_LENGTH |
Number(3,0) |
SMALLINT NOT NULL |
Project ID Field Length
|
| 20 |
IN_USE_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
Row in use flag
Default Value: N
|
| 21 |
LAST_ACTIVITY_ID |
Number(8,0) |
INTEGER NOT NULL |
Last Actvity ID
|
| 22 |
ACTV_FLD_LENGTH |
Number(3,0) |
SMALLINT NOT NULL |
Activity ID Field Length
|
| 23 |
WORK_CNT |
Number(10,0) |
DECIMAL(10) NOT NULL |
Count of Anything
|
| 24 |
WORK_FIELD |
Character(37) |
VARCHAR2(37) NOT NULL |
Work_field
|
| 25 |
WORK_CNT8 |
Number(8,0) |
INTEGER NOT NULL |
Count of Anything
|
| 26 |
RESOURCE_ID |
Character(40) |
VARCHAR2(40) NOT NULL |
Transaction ID
|
| 27 |
LAST_RESOURCE_ID |
Number(20,0) |
DECIMAL(20) NOT NULL |
Last Transaction ID
|
| 28 |
PC_REUSE_ACT_ID |
Character(1) |
VARCHAR2(1) NOT NULL |
Reuse Activity
N=No
Y=Yes
|
| 29 |
PC_RES_CAT_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Category
O=Optional
R=Required
|
| 30 |
PROCESS_INST_STG |
Number(10,0) |
DECIMAL(10) NOT NULL |
Stage Record Process Instance
|
| 31 |
WORK_CNT20 |
Number(20,0) |
DECIMAL(20) NOT NULL |
This field is a counter of 20 digits for general usage.
|
| 32 |
ACTIVITY_ID_2 |
Character(15) |
VARCHAR2(15) NOT NULL |
Activity ID
|
| 33 |
PC_WBS_PB |
Character(1) |
VARCHAR2(1) NOT NULL |
Work Breakdown Structure
N=No
Y=Yes
|
| 34 |
WBS_TREE_NAME |
Character(18) |
VARCHAR2(18) NOT NULL |
WBS Tree Name
|
| 35 |
WBS_TREE_EFFDT |
Date(10) |
DATE |
Effective date of a WBS Tree.
|
| 36 |
WHERE_CLAUSE |
Character(254) |
VARCHAR2(254) NOT NULL |
Where Clause
|
| 37 |
ALL_SELECTED_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
all selected
|
| 38 |
LEVEL_COUNT |
Number(3,0) |
SMALLINT NOT NULL |
Level Count
|
| 39 |
MAX_SEQ_NBR |
Number(15,0) |
DECIMAL(15) NOT NULL |
Maximum Sequence Number
|
| 40 |
WORK_CNT7 |
Number(10,0) |
DECIMAL(10) NOT NULL |
Work Count 7
|
| 41 |
WORK_CNT6 |
Number(10,0) |
DECIMAL(10) NOT NULL |
Work Count 6
|
| 42 |
WORK_CNT5 |
Number(10,0) |
DECIMAL(10) NOT NULL |
Work Count 5
|
| 43 |
LEVEL_NUM |
Number(3,0) |
SMALLINT NOT NULL |
Level
|
| 44 |
WBS_ID |
Character(100) |
VARCHAR2(100) NOT NULL |
WBS ID
|
| 45 |
LEVEL1 |
Number(5,0) |
INTEGER NOT NULL |
Level 1
|
| 46 |
LEVEL2 |
Number(5,0) |
INTEGER NOT NULL |
Level 2
|
| 47 |
LEVEL3 |
Number(5,0) |
INTEGER NOT NULL |
Level 3
|
| 48 |
LEVEL4 |
Number(5,0) |
INTEGER NOT NULL |
Level 4
|
| 49 |
LEVEL5 |
Number(5,0) |
INTEGER NOT NULL |
Level 5
|
| 50 |
LEVEL6 |
Number(5,0) |
INTEGER NOT NULL |
Level 6
|
| 51 |
LEVEL7 |
Number(5,0) |
INTEGER NOT NULL |
Level 7
|
| 52 |
LEVEL8 |
Number(5,0) |
INTEGER NOT NULL |
Level 8
|
| 53 |
LEVEL9 |
Number(5,0) |
INTEGER NOT NULL |
Level 9
|
| 54 |
LEVEL10 |
Number(5,0) |
INTEGER NOT NULL |
Level 10
|
| 55 |
LEVEL11 |
Number(5,0) |
INTEGER NOT NULL |
Level 11
|
| 56 |
LEVEL12 |
Number(5,0) |
INTEGER NOT NULL |
Level 12
|
| 57 |
LEVEL13 |
Number(5,0) |
INTEGER NOT NULL |
Level 13
|
| 58 |
LEVEL14 |
Number(5,0) |
INTEGER NOT NULL |
Level 14
|
| 59 |
LEVEL15 |
Number(5,0) |
INTEGER NOT NULL |
Level 15
|
| 60 |
LEVEL16 |
Number(5,0) |
INTEGER NOT NULL |
Level 16
|
| 61 |
LEVEL17 |
Number(5,0) |
INTEGER NOT NULL |
Level 17
|
| 62 |
LEVEL18 |
Number(5,0) |
INTEGER NOT NULL |
Level 18
|
| 63 |
LEVEL19 |
Number(5,0) |
INTEGER NOT NULL |
Level 19
|
| 64 |
LEVEL20 |
Number(5,0) |
INTEGER NOT NULL |
Level 20
|
| 65 |
LEVEL21 |
Number(5,0) |
INTEGER NOT NULL |
Level 21
|
| 66 |
LEVEL22 |
Number(5,0) |
INTEGER NOT NULL |
Level 22
|
| 67 |
LEVEL23 |
Number(5,0) |
INTEGER NOT NULL |
Level 23
|
| 68 |
LEVEL24 |
Number(5,0) |
INTEGER NOT NULL |
Level 24
|
| 69 |
LEVEL25 |
Number(5,0) |
INTEGER NOT NULL |
Level 25
|
| 70 |
LEVEL26 |
Number(5,0) |
INTEGER NOT NULL |
Level 26
|
| 71 |
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
|
| 72 |
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.
|
| 73 |
EFF_STATUS |
Character(1) |
VARCHAR2(1) NOT NULL |
Effective Status
A=Active
I=Inactive
|
| 74 |
ISTMPL_TARGET |
Character(1) |
VARCHAR2(1) NOT NULL |
Field which specify whether template is the target is project copy
N=No
Y=Yes
|
| 75 |
DUPLICATE_ACTION |
Character(1) |
VARCHAR2(1) NOT NULL |
Duplication actions
I=Ignore
N=Next Sequence ID
O=Overwrite
X=No Action
|
| 76 |
NEW_START_DATE |
Date(10) |
DATE |
Start Date
|
| 77 |
NEW_END_DATE |
Date(10) |
DATE |
Due Date
|
| 78 |
START_DATE |
Date(10) |
DATE |
Start Date for Gen Standing PO
|
| 79 |
END_DATE |
Date(10) |
DATE |
End Date
|
| 80 |
TEMP_DT |
Date(10) |
DATE |
Temp Date
|
| 81 |
PC_DURATION |
Number(11,2) |
DECIMAL(10,2) NOT NULL |
Duration
|
| 82 |
DURATION |
Number(5,0) |
INTEGER NOT NULL |
Recurrence Duration
|
| 83 |
PGM |
Character(1) |
VARCHAR2(1) NOT NULL |
Product field for Program Management
|
| 84 |
PROJECT_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Assign To Project
N=No
Y=Yes
Default Value: Y
|
| 85 |
ACTIVITIES_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Activities
N=No
Y=Yes
Default Value: Y
|
| 86 |
BUD_PLAN_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Budget Plan
N=No
Y=Yes
Default Value: Y
|
| 87 |
PROJ_RES_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Project Resource
N=No
Y=Yes
Default Value: Y
|
| 88 |
ACT_RES_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Activity Resource
N=No
Y=Yes
Default Value: Y
|
| 89 |
CALENDAR_TYPE |
Character(1) |
VARCHAR2(1) NOT NULL |
Type of Calendar
B=Budget Calendar
D=Detail Calendar
I=Summary Budget Period Calendar
P=Budget Period Calendar
S=Summary Calendar
T=Promo Mgmt Sales Calendar
|
| 90 |
SELECT_CLAUSE |
Character(254) |
VARCHAR2(254) NOT NULL |
Select Clause
|
| 91 |
SELECT_CLAUSE2 |
Character(254) |
VARCHAR2(254) NOT NULL |
Select Clause 2
|
| 92 |
UPDATE_CLAUSE |
Character(254) |
VARCHAR2(254) NOT NULL |
Meta SQL
|
| 93 |
UPDATE_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Update Flag
0=No Modification
1=Add
2=Change
3=Delete
|
| 94 |
CONSTRAINT_DT |
Date(10) |
DATE |
Constraint Date
|
| 95 |
CONSTRAINT_TYPE |
Character(4) |
VARCHAR2(4) NOT NULL |
Constraint Type
ALAP=As Late As Possible
ASAP=As Soon As Possible
ENET=End No Earlier Than
ENLT=End No Later Than
MEO=Must End On
MSO=Must Start On
SNET=Start No Earlier Than
SNLT=Start No Later Than
|
| 96 |
DEADLINE_DT |
Date(10) |
DATE |
Deadline Date
|
| 97 |
STARTING_DT |
Date(10) |
DATE |
Bills Added On or After
|
| 98 |
END_ACTUAL_DATE |
Date(10) |
DATE |
Actual End Date
|
| 99 |
PC_BUDGET_ID |
Number(3,0) |
SMALLINT NOT NULL |
Budget Plan ID
|
| 100 |
PC_DELV_ID |
Character(15) |
VARCHAR2(15) NOT NULL |
Unique identifier for an Activity Deliverable.
|
| 101 |
TEAM_MEMBER |
Character(30) |
VARCHAR2(30) NOT NULL |
Team Member
|
| 102 |
SCHED_NUM |
Number(5,0) |
INTEGER NOT NULL |
Team sequence number
|
| 103 |
WHICH_TMPL_ACTION |
Character(1) |
VARCHAR2(1) NOT NULL |
Which action , defines the kind of action carried
1=Import Template
2=Save Template
3=Create Template
|
| 104 |
DUPLICATE_TYPE |
Character(1) |
VARCHAR2(1) NOT NULL |
Duplicate Type
1=Project ID
2=Activity ID
3=Resource ID
4=Budget ID
5=Inactive Resource
6=Invalid Budget Calendar
|
| 105 |
PROBLEM_ID |
Character(15) |
VARCHAR2(15) NOT NULL |
Problem ID
|
| 106 |
DELTA |
Signed Number(7,0) |
DECIMAL(6) NOT NULL |
Stores the basis point change applied to a (or all) tenored market issues.
This field is used in tables:
DT_DR_DELTA_TBL
DT_SH_DELTA_TBL
DT_SHOCK_DEF
|
| 107 |
WHERE_CLAUSE_LONG |
Long Character(4000) |
CLOB |
Where Clause
|
| 108 |
PC_BUDGET_ID_TMP |
Number(3,0) |
SMALLINT NOT NULL |
Budget Plan ID
|
| 109 |
ROW_NUMBER_5 |
Number(5,0) |
INTEGER NOT NULL |
Row Number
|
| 110 |
COSTING_ACT_SW |
Character(1) |
VARCHAR2(1) NOT NULL |
Activity Costing Switch - determines whether an activity is available for charging. 'Y' = charging is allowed; 'N' = charging is not allowed.
|
| 111 |
DUP_CHK |
Character(1) |
VARCHAR2(1) NOT NULL |
Duplicate Check
|
| 112 |
PLAN_PROJROLE |
Character(15) |
VARCHAR2(15) NOT NULL |
Requirement Project Role
|
| 113 |
PC_BUD_TYPE |
Character(1) |
VARCHAR2(1) NOT NULL |
This field defines a Projects Budget as either Cost or Revenue Based.
C=Cost Budget
R=Revenue Budget
|
| 114 |
PROJECT_STATUS |
Character(1) |
VARCHAR2(1) NOT NULL |
Project Status
B=Budgeted
C=Closed
H=Hold
O=Open
P=Proposed
|
| 115 |
RECNAME_ALIAS |
Character(180) |
VARCHAR2(180) NOT NULL |
Record Name Alias
|
| 116 |
PC_ACT_OWNER |
Character(11) |
VARCHAR2(11) NOT NULL |
Activity Owner - The employee id of the individual who is responsible for the execution of an activity or a group of activities.
|
| 117 |
AVAIL_UNITS |
Number(6,0) |
INTEGER NOT NULL |
Availability Units
|
| 118 |
PROJECT_MANAGER |
Character(11) |
VARCHAR2(11) NOT NULL |
Project Manager
|
| 119 |
ACTIVITY_DATE |
Date(10) |
DATE |
Last Activity
|
| 120 |
ACT_SUMMARY_DT |
Date(10) |
DATE |
Summary Activity Date
|
| 121 |
WS_CHILD_NODE |
Character(20) |
VARCHAR2(20) NOT NULL |
Used in views requiring child tree node.
|
| 122 |
SUMMARY_ACT |
Character(1) |
VARCHAR2(1) NOT NULL |
Flag to indicate whether an activity is summary or detail.
N=Detail Activity
Y=Summary Activity
|
| 123 |
EFFDT |
Date(10) |
DATE |
Effective Date
Default Value: %date
|
| 124 |
EFFSEQ |
Number(3,0) |
SMALLINT NOT NULL |
Effective Sequence
|
| 125 |
LOCATION |
Character(10) |
VARCHAR2(10) NOT NULL |
Location Code
|
| 126 |
DUP_CONTACT_ID |
Character(15) |
VARCHAR2(15) NOT NULL |
Duplicate Contact
|
| 127 |
PC_HOURS_PER_DAY |
Number(2,0) |
SMALLINT NOT NULL |
Hours per Day
|
| 128 |
BUDGET_PERIOD |
Character(8) |
VARCHAR2(8) NOT NULL |
Budget Period
|
| 129 |
SETID |
Character(5) |
VARCHAR2(5) NOT NULL |
SetID
|
| 130 |
CALENDAR_ID |
Character(2) |
VARCHAR2(2) NOT NULL |
Calendar ID
|
| 131 |
BUDGET_PERIOD_2 |
Character(8) |
VARCHAR2(8) NOT NULL |
Budget Period
|
| 132 |
PC_BUDGET_ITEM |
Character(15) |
VARCHAR2(15) NOT NULL |
Project Budgeting: Budget Item
11/15/2004- FS - Added label COST_BUDGET_ITEM
|
| 133 |
SEQ_NBR |
Number(15,0) |
DECIMAL(15) NOT NULL |
Sequence Number
|
| 134 |
BUDGET_CATEGORY |
Character(15) |
VARCHAR2(15) NOT NULL |
BUDGET_CATEGORY
|
| 135 |
SEQ_NBR2 |
Number(15,0) |
DECIMAL(15) NOT NULL |
Used as a key to SHIP_INV_TMP in addition to the DEMAND_PHYS_INV.
|
| 136 |
BUDGET_PERIOD_MAP |
Character(8) |
VARCHAR2(8) NOT NULL |
Budget Period
|
| 137 |
BUDGET_PERIOD2 |
Character(8) |
VARCHAR2(8) NOT NULL |
Budget Period
|
| 138 |
ACCOUNTING_DT |
Date(10) |
DATE |
The accounting entry construction date for a given transaction (a generic field that crosses multiple
|
| 139 |
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.
|
| 140 |
COUNTER2 |
Signed Number(17,2) |
DECIMAL(15,2) NOT NULL |
Counter 2
|
| 141 |
LANG_REC_COPY |
Character(1) |
VARCHAR2(1) NOT NULL |
Flag to indicate copy language records
|
| 142 |
RELLANGRECNAME |
Character(15) |
VARCHAR2(15) NOT NULL |
Related Language Record Name
|
| 143 |
PC_DATE |
Character(1) |
VARCHAR2(1) NOT NULL |
Date
N=No
Y=Yes
|
| 144 |
SCHEDULE_TYPE |
Character(15) |
VARCHAR2(15) NOT NULL |
Phase Type
|
| 145 |
SCHEDULE_STATUS |
Character(1) |
VARCHAR2(1) NOT NULL |
Schedule Status
A=Actual Schedule
E=Estimated Schedule
|
| 146 |
NUM_ROWS |
Number(18,0) |
DECIMAL(18) NOT NULL |
Number of Rows
|