BUSINESS_UNITPROBLEM_GROUPPROBLEM_CDCAUSE_CDRESOLUTION_CDWM_PCR_BU_RES(SQL View) |
Index Back |
|---|---|
PCR Resolution ViewPCR Resolution View -- prompt view with setid flattened to BU, passed via Web Service, and used to look up PCR Resolutions on mobile devices. |
| SELECT B.BUSINESS_UNIT , W.PROBLEM_GROUP , W.PROBLEM_CD , W.CAUSE_CD , W.RESOLUTION_CD , P.DESCR50 FROM PS_WM_PCR_RESOLUTN W , PS_WM_RESOLUTION P , PS_BUS_UNIT_TBL_WM B , PS_SET_CNTRL_REC S WHERE %Join(COMMON_KEYS, WM_PCR_RESOLUTN W, WM_RESOLUTION P) AND P.EFF_STATUS = 'A' AND S.RECNAME = 'WM_PCR_GROUP' AND S.SETID = W.SETID AND S.SETCNTRLVALUE = B.BUSINESS_UNIT AND EXISTS ( SELECT 'X' FROM PS_WM_PCR_BU_CSE BB WHERE BB.BUSINESS_UNIT = B.BUSINESS_UNIT AND BB.PROBLEM_GROUP = W.PROBLEM_GROUP AND BB.PROBLEM_CD = W.PROBLEM_CD AND BB.CAUSE_CD = W.CAUSE_CD) |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | BUSINESS_UNIT |
Character(5) | VARCHAR2(5) NOT NULL | Business Unit |
| 2 | PROBLEM_GROUP |
Character(15) | VARCHAR2(15) NOT NULL | Problem Group |
| 3 | PROBLEM_CD |
Character(15) | VARCHAR2(15) NOT NULL | Problem code |
| 4 | CAUSE_CD |
Character(15) | VARCHAR2(15) NOT NULL | Cause Code |
| 5 | RESOLUTION_CD |
Character(15) | VARCHAR2(15) NOT NULL | Resolution code |
| 6 | DESCR50 | Character(50) | VARCHAR2(50) NOT NULL | Description of length 50 |