RG_CHANGE_PROD (SQL Table)	Index Back
Change Affected Products Product(s) that are affected by a change request.

RG_CHANGE_PROD

(SQL Table)

Change Affected Products

Product(s) that are affected by a change request.

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 CHANGE_REQUEST_ID Character(15) VARCHAR2(15) NOT NULL change request identification is key to change request

2 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit

3 SEQNO Number(5,0) INTEGER NOT NULL Sequence Number

4 SETID_PRODUCT Character(5) VARCHAR2(5) NOT NULL Product SetID

5 PRODUCT_ID Character(18) VARCHAR2(18) NOT NULL Product ID
Prompt Table: %EDITTABLE10
Set Control Field: BUSINESS_UNIT

6 PRODUCT_GROUP Character(10) VARCHAR2(10) NOT NULL PRoduct Group
Prompt Table: RG_PROD_GRP_VW
Set Control Field: BUSINESS_UNIT

7 SETID_PROD_GRP Character(5) VARCHAR2(5) NOT NULL Product Group setid field

8 INST_PROD_ID Character(20) VARCHAR2(20) NOT NULL This field is used to represent the installed product ID (key field)

9 ASSETTAG Character(40) VARCHAR2(40) NOT NULL Asset Tag

10 ASSET_OWNER Character(1) VARCHAR2(1) NOT NULL This field is used by the Installed Product component for product type `Asset� to determine the Owner of the Asset. There are four allowable types: 1) Department, which designates an asset owned by department; 2) Employee, which designates an asset owned by employee, 3) Location, which designates an asset owned by location and 4) None, which designates an asset is created with out any employee/department/location.
D=Department
E=Employee
L=Location
N=None

11 DEPTID Character(15) VARCHAR2(15) NOT NULL Department

12 LOCATION Character(15) VARCHAR2(15) NOT NULL This field stores the Location Code.

13 BO_ID_PPROD_OWNER Number(31,0) DECIMAL(31) NOT NULL This field is used to designate the Business Object ID for the previous owner of a Change Request.

14 ROLE_TYPE_ID_PPROD Number(12,0) DECIMAL(12) NOT NULL Previous Product Role Type ID

15 BO_ID_NPROD_OWNER Number(31,0) DECIMAL(31) NOT NULL This field is used to designate the Business Object ID for the previous owner of a Change Request.

16 ROLE_TYPE_ID_NPROD Number(12,0) DECIMAL(12) NOT NULL Next Product Role Type ID

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

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

19 ROW_LASTMANT_DTTM DateTime(26) TIMESTAMP The date and time that the row was last updated.

20 ROW_LASTMANT_OPRID Character(30) VARCHAR2(30) NOT NULL ID of user who last modified the row.

21 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.

22 SYNCDTTM DateTime(26) TIMESTAMP Synchronization Last Update Date Time

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	CHANGE_REQUEST_ID	Character(15)	VARCHAR2(15) NOT NULL	change request identification is key to change request
2	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit
3	SEQNO	Number(5,0)	INTEGER NOT NULL	Sequence Number
4	SETID_PRODUCT	Character(5)	VARCHAR2(5) NOT NULL	Product SetID
5	PRODUCT_ID	Character(18)	VARCHAR2(18) NOT NULL	Product ID Prompt Table: %EDITTABLE10 Set Control Field: BUSINESS_UNIT
6	PRODUCT_GROUP	Character(10)	VARCHAR2(10) NOT NULL	PRoduct Group Prompt Table: RG_PROD_GRP_VW Set Control Field: BUSINESS_UNIT
7	SETID_PROD_GRP	Character(5)	VARCHAR2(5) NOT NULL	Product Group setid field
8	INST_PROD_ID	Character(20)	VARCHAR2(20) NOT NULL	This field is used to represent the installed product ID (key field)
9	ASSETTAG	Character(40)	VARCHAR2(40) NOT NULL	Asset Tag
10	ASSET_OWNER	Character(1)	VARCHAR2(1) NOT NULL	This field is used by the Installed Product component for product type `Asset� to determine the Owner of the Asset. There are four allowable types: 1) Department, which designates an asset owned by department; 2) Employee, which designates an asset owned by employee, 3) Location, which designates an asset owned by location and 4) None, which designates an asset is created with out any employee/department/location. D=Department E=Employee L=Location N=None
11	DEPTID	Character(15)	VARCHAR2(15) NOT NULL	Department
12	LOCATION	Character(15)	VARCHAR2(15) NOT NULL	This field stores the Location Code.
13	BO_ID_PPROD_OWNER	Number(31,0)	DECIMAL(31) NOT NULL	This field is used to designate the Business Object ID for the previous owner of a Change Request.
14	ROLE_TYPE_ID_PPROD	Number(12,0)	DECIMAL(12) NOT NULL	Previous Product Role Type ID
15	BO_ID_NPROD_OWNER	Number(31,0)	DECIMAL(31) NOT NULL	This field is used to designate the Business Object ID for the previous owner of a Change Request.
16	ROLE_TYPE_ID_NPROD	Number(12,0)	DECIMAL(12) NOT NULL	Next Product Role Type ID
17	ROW_ADDED_DTTM	DateTime(26)	TIMESTAMP	This is a datetime field for record creation.
18	ROW_ADDED_OPRID	Character(30)	VARCHAR2(30) NOT NULL	ID of user who added the row.
19	ROW_LASTMANT_DTTM	DateTime(26)	TIMESTAMP	The date and time that the row was last updated.
20	ROW_LASTMANT_OPRID	Character(30)	VARCHAR2(30) NOT NULL	ID of user who last modified the row.
21	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.
22	SYNCDTTM	DateTime(26)	TIMESTAMP	Synchronization Last Update Date Time