PGM_PRJ_ISSUE

(SQL View)
Index Back

Project Issues View

Project Issues View for Manager Workbench for Program Management

SELECT ' ' ,' ' ,' ' ,%DateNull ,' ' ,' ' FROM PS_INSTALLATION

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 PC_IM_ISSUE_ID Character(15) VARCHAR2(15) NOT NULL Issue ID
2 ACTIVITY_ID Character(15) VARCHAR2(15) NOT NULL Activity ID
3 PC_IM_SUMMARY Character(100) VARCHAR2(100) NOT NULL Issue Summary
4 DATE_ADDED Date(10) DATE Date Added
5 PC_IM_STATUS Character(30) VARCHAR2(30) NOT NULL Issue Status
6 PC_IM_PRIO_ICON Character(1) VARCHAR2(1) NOT NULL Issue Priority Icon
0=Low Priority
1=Medium Priority
2=High Priority