Entry to PR2_COMPONENT_MASTER Table

PR2_COMPONENT_MASTER is the table for storing all components which are used in RRF. You can enter either through backend which is explained here or through UI which is explained in the Component Registration section under RRF module in the OFS Analytical Applications Infrastructure User Guide.

An entry contains the following fields:

Table 4-2 Column name, type, and their description

Column Name	Type	Description	Null
V_PR2_COMPONENT_ID	VARCHAR2(30)	Represents component type in a Process or Run.	N
V_PR2_COMPONENT_PARENT_ID	VARCHAR2(30)	Indicates parentage which refers to V_PR2_COMPONENT_ID.	Y
V_COMPONENT_ID	VARCHAR2(30)	Existing ICC Component Id.	Y
V_PR2_COMPONENT_CLASS	VARCHAR2(100)	Fully qualified class path of the implementation class for this component.	N
V_TREE_IMAGE	VARCHAR2(100)	Name with relative path (with respect to web context) of the image which will be displayed in the component tree.	N
N_TREE_ORDER	NUMBER(9)	Display order of the component in the tree. The order is done upon the peers.	N
V_SEEDED_BY	VARCHAR2(8)	Differentiates user created and system created. The system created will have this field filled with an application name which cannot be edited from the front-end utility. The components created from front-end utility will not populate any value in this field which can be edited or deleted from front-end.	Y
V_CREATED_BY	VARCHAR2(30)	Stores the creator username.	N
D_CREATED_DATE	TIMESTAMP(6)	Stores created date and time.	N
V_LAST_MODIFIED_BY	VARCHAR2(30)	Stores the modifier username.	Y
D_LAST_MODIFIED_DATE	TIMESTAMP(6)	Stores modified date and time.	Y

Example:

insert into PR2_COMPONENT_MASTER (V_PR2_COMPONENT_ID, V_PR2_COMPONENT_PARENT_ID, V_COMPONENT_ID, V_PR2_COMPONENT_CLASS, V_TREE_IMAGE, N_TREE_ORDER, V_SEEDED_BY, V_CREATED_BY) values ('COMPTYP', null, 'Component Sample', 'com.sample.ComponentSample', 'sampleImages/sampleComp.gif', 0, 'SEEDEDBY', 'USER')