QS_UPG_CLIM_KY (SQL Table)	Index Back
MAP:Old CLIM_ID to New CLIM_ID During the upgrade from Release 7.5 to Release 8.0, this record was populated with the keys from the release 7.5 record/s AND the corresponding NEW keys in the 8.0 record/s. Though this record was used as a component of the upgrade, it van be used by the customer as a resource for identifying their changed data. RRE 1/18/2000

QS_UPG_CLIM_KY

(SQL Table)

MAP:Old CLIM_ID to New CLIM_ID

During the upgrade from Release 7.5 to Release 8.0, this record was populated with the keys from the release 7.5 record/s AND the corresponding NEW keys in the 8.0 record/s. Though this record was used as a component of the upgrade, it van be used by the customer as a resource for identifying their changed data. RRE 1/18/2000

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

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

2 STREAM_ID Number(8,0) INTEGER NOT NULL Stream ID- hierarchial structure plus characteristic. (or Stream Root ID plus characteristic).

3 OLD_CLIM_ID Character(30) VARCHAR2(30) NOT NULL Object used for Contorl Limits storage,calculation, and/or display

4 CLIM_ID Character(30) VARCHAR2(30) NOT NULL Object used for Contorl Limits storage,calculation, and/or display

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit
2	STREAM_ID	Number(8,0)	INTEGER NOT NULL	Stream ID- hierarchial structure plus characteristic. (or Stream Root ID plus characteristic).
3	OLD_CLIM_ID	Character(30)	VARCHAR2(30) NOT NULL	Object used for Contorl Limits storage,calculation, and/or display
4	CLIM_ID	Character(30)	VARCHAR2(30) NOT NULL	Object used for Contorl Limits storage,calculation, and/or display