BUSINESS_UNITR_FIX_IDRQ_DF_FX_VW(SQL View) |
Index Back |
|---|---|
Defect Fix viewQuality application Defect fix view |
| SELECT A.BUSINESS_UNIT , A.R_FIX_ID , A.R_SUBJECT , B.DESCR , A.R_INTRODUCED_IN , A.R_1ST_FOUND_IN , A.R_FIXED_IN , A.R_FIX_VERIFIED_IN FROM PS_RQ_FIX A , PS_PROD_ITEM B WHERE A.R_PROD_RLSE_ID = B.PRODUCT_ID AND B.SETID = ( SELECT E.SETID FROM PS_SET_CNTRL_REC E WHERE E.SETCNTRLVALUE = A.BUSINESS_UNIT AND E.RECNAME = 'PROD_ITEM') |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | BUSINESS_UNIT |
Character(5) | VARCHAR2(5) NOT NULL | Business Unit |
| 2 | R_FIX_ID |
Character(15) | VARCHAR2(15) NOT NULL | Fix Identification |
| 3 | R_SUBJECT | Character(254) | VARCHAR2(254) NOT NULL | subject |
| 4 | PRODUCTDESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
| 5 | R_INTRODUCED_IN | Character(15) | VARCHAR2(15) NOT NULL | defines environment in which this defect was found |
| 6 | R_1ST_FOUND_IN | Character(15) | VARCHAR2(15) NOT NULL | defect problem found in 1st environment |
| 7 | R_FIXED_IN | Character(15) | VARCHAR2(15) NOT NULL | defines the environment in which this fix was done |
| 8 | R_FIX_VERIFIED_IN | Character(15) | VARCHAR2(15) NOT NULL | version of production used to verify the fix |