RQ_DEF_CHG_LNK (SQL View)	Index Back
Defect Change Link View Defect Change Linked View for Quality application

RQ_DEF_CHG_LNK

(SQL View)

Defect Change Link View

Defect Change Linked View for Quality application

SELECT A.RELATED_BU , A.OBJECT_SHOWN , A.SEQNO + 200 , 0 , A.BUSINESS_UNIT , A.CHANGE_REQUEST_ID , B.PERSON_ID , %DatePart(A.ROW_ADDED_DTTM) , 'CHG' , 'RG_CHANGE_REQST' , C.SYNCID , A.ROW_ADDED_DTTM , A.ROW_ADDED_OPRID FROM PS_RG_CHANGE_ROBJ A , PSOPRALIAS B , PS_RG_CHANGE_REQST C WHERE A.ROW_ADDED_OPRID = B.OPRID AND B.OPRALIASTYPE = 'PER' AND A.SEQNO <> 0 AND A.CHANGE_REQUEST_ID = C.CHANGE_REQUEST_ID AND A.BUSINESS_UNIT = C.BUSINESS_UNIT AND A.OBJECT_TYPE = 'DEF'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
Prompt Table: SP_BU_RQ_NONVW

2 R_DEFECT_ID Character(15) VARCHAR2(15) NOT NULL Quality Defect Identification key unique by business unit

3 SEQNUM Number(3,0) SMALLINT NOT NULL Sequence Number

4 CASE_ID Number(15,0) DECIMAL(15) NOT NULL Case ID. This is a unique ID assigned to a case when it is saved. Unique ID is ensured by getting the next value from the auto-numbering table and updating the table.
Prompt Table: RQ_CASE_VW

5 BUSINESS_UNIT_RC Character(5) VARCHAR2(5) NOT NULL Business Unit field for Case identified in Quality

6 RELATED_OBJ_ID Character(15) VARCHAR2(15) NOT NULL Related Object Id used to relate to a Defect

7 R_REPORTED_BY Character(15) VARCHAR2(15) NOT NULL First Reported By .... FK to PERSONAL_DATA
Prompt Table: RQ_EMPL_PRSN_VW

8 R_DATE_REPORTED Date(10) DATE Reported date

9 TYPE Character(4) VARCHAR2(4) NOT NULL Association Types

10 RECORDNAME Character(15) VARCHAR2(15) NOT NULL Record Name
01=MASTER_ITEM_EC
02=INV_ITEMS_EC
03=BU_ITM_INV_EC
04=BU_ITM_WTVL_EC
05=ITEM_VENDOR_EC
06=ITM_VNDR_LOC_EC
07=ITM_VNDR_UOM_EC
08=ITM_VND_UMPR_EC
09=INV_ITM_UOM_EC
10=PUR_ITM_ATTR_EC
11=MANUFACTURER_EC
12=ITEM_MFG_EC
13=EN_REVISION_EC

11 SYNCID Number(10,0) DECIMAL(10) NOT NULL The Synchronization ID field stores a value generated by the sync processor. The value is used to identify the type of object that the sync processor is about to handle.

12 ROW_ADDED_DTTM DateTime(26) TIMESTAMP This is a datetime field for record creation.

13 ROW_ADDED_OPRID Character(30) VARCHAR2(30) NOT NULL ID of user who added the row.

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit Prompt Table: SP_BU_RQ_NONVW
2	R_DEFECT_ID	Character(15)	VARCHAR2(15) NOT NULL	Quality Defect Identification key unique by business unit
3	SEQNUM	Number(3,0)	SMALLINT NOT NULL	Sequence Number
4	CASE_ID	Number(15,0)	DECIMAL(15) NOT NULL	Case ID. This is a unique ID assigned to a case when it is saved. Unique ID is ensured by getting the next value from the auto-numbering table and updating the table. Prompt Table: RQ_CASE_VW
5	BUSINESS_UNIT_RC	Character(5)	VARCHAR2(5) NOT NULL	Business Unit field for Case identified in Quality
6	RELATED_OBJ_ID	Character(15)	VARCHAR2(15) NOT NULL	Related Object Id used to relate to a Defect
7	R_REPORTED_BY	Character(15)	VARCHAR2(15) NOT NULL	First Reported By .... FK to PERSONAL_DATA Prompt Table: RQ_EMPL_PRSN_VW
8	R_DATE_REPORTED	Date(10)	DATE	Reported date
9	TYPE	Character(4)	VARCHAR2(4) NOT NULL	Association Types
10	RECORDNAME	Character(15)	VARCHAR2(15) NOT NULL	Record Name 01=MASTER_ITEM_EC 02=INV_ITEMS_EC 03=BU_ITM_INV_EC 04=BU_ITM_WTVL_EC 05=ITEM_VENDOR_EC 06=ITM_VNDR_LOC_EC 07=ITM_VNDR_UOM_EC 08=ITM_VND_UMPR_EC 09=INV_ITM_UOM_EC 10=PUR_ITM_ATTR_EC 11=MANUFACTURER_EC 12=ITEM_MFG_EC 13=EN_REVISION_EC
11	SYNCID	Number(10,0)	DECIMAL(10) NOT NULL	The Synchronization ID field stores a value generated by the sync processor. The value is used to identify the type of object that the sync processor is about to handle.
12	ROW_ADDED_DTTM	DateTime(26)	TIMESTAMP	This is a datetime field for record creation.
13	ROW_ADDED_OPRID	Character(30)	VARCHAR2(30) NOT NULL	ID of user who added the row.