PC_IM_ISSUE_VW

(SQL View)
 Index Back

Issues not yet resolved

This is a view of the Issue Management main table, selecting only rows which have not been resolved.

SELECT A.BUSINESS_UNIT , D.RELEASE , A.PROJECT_ID , A.PC_IM_ISSUE_ID , A.ACTIVITY_ID , A.PC_IM_USER_ID , A.DATE_ADDED , A.PC_IM_PRIORITY , B.PC_IM_PRIO_ICON , A.PC_IM_STATUS , A.PC_IM_TYPE , A.PC_IM_ASSIGNED_TO FROM PS_PC_IM_ISSUE_TBL A , PS_PC_IM_PRIO_TBL B , PS_PC_IM_RSLTN_TBL C , PS_SET_CNTRL_REC CNTRL , PS_PROJECT D WHERE CNTRL.RECNAME = 'PC_IM_PRIO_TBL' AND CNTRL.SETCNTRLVALUE = A.BUSINESS_UNIT AND B.SETID = CNTRL.SETID AND A.BUSINESS_UNIT = C.BUSINESS_UNIT AND A.PROJECT_ID = C.PROJECT_ID AND A.PC_IM_ISSUE_ID = C.PC_IM_ISSUE_ID AND C.PC_IM_ACT_RSLTN_DT IS NULL AND A.PC_IM_PRIORITY = B.PC_IM_PRIORITY AND A.BUSINESS_UNIT = D.BUSINESS_UNIT AND A.PROJECT_ID = D.PROJECT_ID AND EXISTS ( SELECT E.RELEASE FROM PS_PGM_RELEASE E WHERE D.BUSINESS_UNIT = E.BUSINESS_UNIT AND D.RELEASE = E.RELEASE AND E.RELEASE_STATUS_IND IN ( 'A','P' ) ) AND B.EFF_STATUS = 'A' AND B.EFFDT = ( SELECT MAX(D.EFFDT) FROM PS_PC_IM_PRIO_TBL D WHERE B.PC_IM_PRIORITY = D.PC_IM_PRIORITY AND D.EFFDT <= %CurrentDateIn)

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit

Prompt Table: SP_BU_PC_NONVW

2 RELEASE Character(15) VARCHAR2(15) NOT NULL Release - Carries Release Information driven by the BUSINESS_UNIT
3 PROJECT_ID Character(15) VARCHAR2(15) NOT NULL Project Id ChartField

Prompt Table: SP_PROJS_NONVW

4 PC_IM_ISSUE_ID Character(15) VARCHAR2(15) NOT NULL Issue ID
5 ACTIVITY_ID Character(15) VARCHAR2(15) NOT NULL Activity ID

Prompt Table: PROJ_ACT_VW

6 PC_IM_USER_ID Character(30) VARCHAR2(30) NOT NULL Entered By

Prompt Table: PC_IM_PERS_VW

7 DATE_ADDED Date(10) DATE NOT NULL Date Added
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: PC_IM_PERS_VW