PGM_UNRESLD_ISS

(SQL View)
 Index Back

View to get unresolved issues

This view gets all the issues without an actual resolution date along with their respective owner's user id's

SELECT A.BUSINESS_UNIT ,A.PROJECT_ID ,A.PC_IM_ISSUE_ID ,A.ISSUE_OWNER_USERID FROM PS_PC_IM_ISSUE_TBL A ,PS_PC_IM_RSLTN_TBL B WHERE A.BUSINESS_UNIT = B.BUSINESS_UNIT AND A.PROJECT_ID = B.PROJECT_ID AND A.PC_IM_ISSUE_ID = B.PC_IM_ISSUE_ID AND B.PC_IM_ACT_RSLTN_DT IS NULL

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
2 PROJECT_ID Character(15) VARCHAR2(15) NOT NULL Project Id ChartField
3 PC_IM_ISSUE_ID Character(15) VARCHAR2(15) NOT NULL Issue ID
4 ISSUE_OWNER_USERID Character(30) VARCHAR2(30) NOT NULL This field is used to store the issue owner