PC_IM_ISU_CT_VW

(SQL View)

SELECT X.PC_IM_ASSIGNED_TO , Z.PC_IM_PRIO_ICON , COUNT(DISTINCT Z.PC_IM_PRIO_ICON) PC_IM_PRIO_LVL_CNT FROM PS_PC_IM_ISSUE_TBL X , PS_PC_IM_PRIO_TBL Z WHERE X.PC_IM_ASSIGNED_TO <> ' ' AND X.PC_IM_PRIORITY = Z.PC_IM_PRIORITY GROUP BY X.PC_IM_ASSIGNED_TO, Z.PC_IM_PRIO_ICON

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 PC_IM_ASSIGNED_TO Character(50) VARCHAR2(50) NOT NULL Assigned To

2 PC_IM_PRIO_ICON Character(1) VARCHAR2(1) NOT NULL Issue Priority Icon
0=Low Priority
1=Medium Priority
2=High Priority

3 PC_IM_PRIO_LVL_CNT Number(4,0) SMALLINT NOT NULL Priority Level Count

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	PC_IM_ASSIGNED_TO	Character(50)	VARCHAR2(50) NOT NULL	Assigned To
2	PC_IM_PRIO_ICON	Character(1)	VARCHAR2(1) NOT NULL	Issue Priority Icon 0=Low Priority 1=Medium Priority 2=High Priority
3	PC_IM_PRIO_LVL_CNT	Number(4,0)	SMALLINT NOT NULL	Priority Level Count