PC_IM_PRIO_VW

(SQL View)
 Index Back

SELECT Y.PC_IM_ISSUE_COUNT , X.BUSINESS_UNIT , X.PROJECT_ID , Z.PC_IM_PRIO_ICON , COUNT(*) , V.PROJECT_TYPE FROM PS_PC_IM_ISSUE_TBL X , PS_PGM_ISS_CNT_VW Y , PS_PC_IM_PRIO_TBL Z , PS_PROJECT V , PS_SET_CNTRL_REC CNTRL , PS_PC_IM_RSLTN_TBL B WHERE Y.BUSINESS_UNIT = X.BUSINESS_UNIT AND Y.PROJECT_ID = X.PROJECT_ID AND X.PC_IM_PRIORITY = Z.PC_IM_PRIORITY AND CNTRL.RECNAME = 'PC_IM_PRIO_TBL' AND CNTRL.SETCNTRLVALUE = X.BUSINESS_UNIT AND Z.SETID = CNTRL.SETID AND Z.EFF_STATUS = 'A' AND Z.EFFDT = ( SELECT MAX(D.EFFDT) FROM PS_PC_IM_PRIO_TBL D WHERE Z.PC_IM_PRIORITY = D.PC_IM_PRIORITY AND D.EFFDT <= %CurrentDateIn) AND V.BUSINESS_UNIT = X.BUSINESS_UNIT AND V.PROJECT_ID = X.PROJECT_ID AND X.BUSINESS_UNIT = B.BUSINESS_UNIT AND X.PROJECT_ID = B.PROJECT_ID AND X.PC_IM_ISSUE_ID = B.PC_IM_ISSUE_ID AND B.PC_IM_ACT_RSLTN_DT IS NULL GROUP BY Y.PC_IM_ISSUE_COUNT, X.BUSINESS_UNIT, X.PROJECT_ID, Z.PC_IM_PRIO_ICON, V.PROJECT_TYPE

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 PC_IM_ISSUE_COUNT Number(4,0) SMALLINT NOT NULL Issue Count
2 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
3 PROJECT_ID Character(15) VARCHAR2(15) NOT NULL Project Id ChartField
4 PC_IM_PRIO_ICON Character(1) VARCHAR2(1) NOT NULL Issue Priority Icon
0=Low Priority
1=Medium Priority
2=High Priority
5 PC_IM_PRIO_LVL_CNT Number(4,0) SMALLINT NOT NULL Priority Level Count
6 PROJECT_TYPE Character(5) VARCHAR2(5) NOT NULL Project Type
A=Activity
G=Grant
H=Phase
P=Project
S=Segment