| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 BUSINESS_UNIT |
Character(5) |
VARCHAR2(5) NOT NULL |
Business Unit
Default Value: OPR_DEF_TBL_PC.BUSINESS_UNIT
Prompt Table:
SP_BU_PC_NONVW
|
| 2 |
PROJECT_ID |
Character(15) |
VARCHAR2(15) NOT NULL |
Project Id ChartField
Default Value: OPR_DEF_TBL_PC.PROJECT_ID
Prompt Table:
SP_PROJS_NONVW
|
| 3 |
PC_IM_ISSUE_ID |
Character(15) |
VARCHAR2(15) NOT NULL |
Issue ID
Default Value: NEXT
|
| 4 |
ACTIVITY_ID |
Character(15) |
VARCHAR2(15) NOT NULL |
Activity ID
Prompt Table:
PC_ACTIVITY_ALL
|
| 5 |
PC_IM_USER_ID |
Character(30) |
VARCHAR2(30) NOT NULL |
Entered By
Prompt Table:
PC_IM_PERS_VW
|
| 6 |
PC_IM_NAME |
Character(50) |
VARCHAR2(50) NOT NULL |
Name
|
| 7 |
DATE_ADDED |
Date(10) |
DATE NOT NULL |
Date Added
Default Value: %Date
|
| 8 |
PC_IM_PRIORITY |
Character(30) |
VARCHAR2(30) NOT NULL |
Issue Priority
Prompt Table:
PC_IM_PRIO_TBL
|
| 9 |
PC_IM_PRIO_ICON |
Character(1) |
VARCHAR2(1) NOT NULL |
Issue Priority Level
0=Low Priority
1=Medium Priority
2=High Priority
Prompt Table:
PC_IM_ICON_TBL
|
| 10 |
PC_IM_STATUS |
Character(30) |
VARCHAR2(30) NOT NULL |
Issue Status
Prompt Table:
PC_IM_STUS_TBL
|
| 11 |
PC_IM_TYPE |
Character(30) |
VARCHAR2(30) NOT NULL |
Issue Type
Prompt Table:
PC_IM_TYPE_TBL
|
| 12 |
PC_IM_ASSIGNED_TO |
Character(50) |
VARCHAR2(50) NOT NULL |
Assigned To
Prompt Table:
%EDITTABLE
|
| 13 |
PC_IM_ASGND_TO_NM |
Character(50) |
VARCHAR2(50) NOT NULL |
Assigned To
|
| 14 |
EMAIL_ADDR |
Character(70) |
VARCHAR2(70) NOT NULL |
Email Address
|
| 15 |
PC_IM_SUMMARY |
Character(100) |
VARCHAR2(100) NOT NULL |
Issue Summary
|
| 16 |
ISSUE_SUBMIT |
Character(1) |
VARCHAR2(1) NOT NULL |
Flag to indicate whether an Issue has been submitted or not.
N=Not Submitted
Y=Submitted
Default Value: N
|
| 17 |
PC_IM_ISSUE_DESCR |
Long Character |
CLOB NOT NULL |
Issue Description
|
| 18 |
ISSUE_OWNER_USERID |
Character(30) |
VARCHAR2(30) NOT NULL |
This field is used to store the issue owner
|
| 19 |
ISSUE_USER1 |
Character(15) |
VARCHAR2(15) NOT NULL |
Additional User field for issue management
|
| 20 |
ISSUE_USER2 |
Character(15) |
VARCHAR2(15) NOT NULL |
Additional User field for issue management
|
| 21 |
ISSUE_USER3 |
Character(15) |
VARCHAR2(15) NOT NULL |
Additional User field for issue management
|
| 22 |
ISSUE_USER4 |
Character(15) |
VARCHAR2(15) NOT NULL |
Additional User field for issue management
|
| 23 |
ISSUE_USER5 |
Character(15) |
VARCHAR2(15) NOT NULL |
Additional User field for issue management
|
| 24 |
ISSUE_USER6 |
Character(15) |
VARCHAR2(15) NOT NULL |
Additional User field for issue management
|
| 25 |
ISSUE_USERAMT1 |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Additional User field for issue management
|
| 26 |
ISSUE_USERAMT2 |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Additional User field for issue management
|
| 27 |
ISSUE_USER_DT1 |
Date(10) |
DATE |
Additional User field for issue management
|
| 28 |
ISSUE_USER_DT2 |
Date(10) |
DATE |
Additional User field for issue management
|
| 29 |
PC_USER_CURRENCY |
Character(3) |
VARCHAR2(3) NOT NULL |
User Currency
Default Value: PROJECT.CURRENCY_CD
Prompt Table:
CURRENCY_CD_TBL
|
| 30 |
FMS_DTTM_STAMP |
DateTime(26) |
TIMESTAMP |
Specifies the date and time of the original entry.
|
| 31 |
FMS_OPRID |
Character(30) |
VARCHAR2(30) NOT NULL |
Specifies the User ID which made the original entry.
|
| 32 |
FMS_LASTUPDDTTM |
DateTime(26) |
TIMESTAMP |
Specifies the date and time of the last update to an entry.
|
| 33 |
FMS_LASTUPDOPRID |
Character(30) |
VARCHAR2(30) NOT NULL |
Specifies the User ID which made the last update to an entry.
|