BUSINESS_UNITPROBLEM_GROUPPROBLEM_CDWM_PCR_BU_PRB(SQL View) |
Index Back |
|---|---|
PCR Problem ViewPCR Problem View -- prompt view with setid flattened to BU, passed via Web Service, and used to look up PCR Problems on mobile devices. |
| SELECT B.BUSINESS_UNIT , W.PROBLEM_GROUP , W.PROBLEM_CD , P.DESCR50 FROM PS_WM_PCR_PROBLEM W , PS_WM_PROBLEM P , PS_BUS_UNIT_TBL_WM B , PS_SET_CNTRL_REC S WHERE %Join(COMMON_KEYS, WM_PCR_PROBLEM W, WM_PROBLEM 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_GROUP PG WHERE %Join(COMMON_KEYS, WM_PCR_GROUP PG, WM_PCR_PROBLEM W) AND PG.EFF_STATUS = 'A') |
| # | 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 | DESCR50 | Character(50) | VARCHAR2(50) NOT NULL | Description of length 50 |