BUSINESS_UNITPROBLEM_GROUPPROBLEM_CDCAUSE_CDWM_PCR_BU_CSE(SQL View) |
Index Back |
|---|---|
PCR Cause ViewPCR Cause View -- prompt view with setid flattened to BU, passed via Web Service, and used to look up PCR Causes on mobile devices. |
| SELECT B.BUSINESS_UNIT , W.PROBLEM_GROUP , W.PROBLEM_CD , W.CAUSE_CD , P.DESCR50 FROM PS_WM_PCR_CAUSE W , PS_WM_CAUSE P , PS_BUS_UNIT_TBL_WM B , PS_SET_CNTRL_REC S WHERE %Join(COMMON_KEYS, WM_PCR_CAUSE W, WM_CAUSE 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_PRB BB WHERE BB.BUSINESS_UNIT = B.BUSINESS_UNIT AND BB.PROBLEM_GROUP = W.PROBLEM_GROUP AND BB.PROBLEM_CD = W.PROBLEM_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 | DESCR50 | Character(50) | VARCHAR2(50) NOT NULL | Description of length 50 |