HRS_OI_VALMAP

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	HRS_VALUE_ID	Number(15,0)	DECIMAL(15) NOT NULL	Integration Value ID
2	HRS_OI_USE_TYPE	Character(2)	VARCHAR2(2) NOT NULL	Used to determine what type of Value is being stored for integration. The value may be associated with the Vendor, and go out with every message, or with a specific transaction. 10=Vendor 20=Vendor-Transaction
3	HRS_OBJECT_ID	Number(15,0)	DECIMAL(15) NOT NULL	Used where the type of object is variable, however since the ID standard in RS is 15 numbers this is an easily interchangable field.
4	HRS_VERSION	Number(15,0)	DECIMAL(15) NOT NULL	used as version for numerous integration objects
5	HRS_LABEL	Character(254)	VARCHAR2(254) NOT NULL	Label
6	HRS_TAGNAME	Character(30)	VARCHAR2(30) NOT NULL	The name passed with a Vendor Integration Value.
7	HRS_READONLY	Character(1)	VARCHAR2(1) NOT NULL	Specifies if a Vendor Value should be read only or editable by the user 1=readonly 2=editable
8	HRS_VALUE	Long Character	CLOB	Value