HR_OWS_CONVERT (SQL Table)	Index Back
OWS Conversion table Used in OWS/Clairvia upgrade conversion from 9.1 to 9.2, this stores if OWS is installed (installation.installed_ows) and Clairvia is installed (install_integr.installed_flag)which were seperate tables in 9.1 and moves them into a shared table in 9.2 (only one integration OWS or Clairvia can be active)

HR_OWS_CONVERT

(SQL Table)

OWS Conversion table

Used in OWS/Clairvia upgrade conversion from 9.1 to 9.2, this stores if OWS is installed (installation.installed_ows) and Clairvia is installed (install_integr.installed_flag)which were seperate tables in 9.1 and moves them into a shared table in 9.2 (only one integration OWS or Clairvia can be active)

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 INSTALLED_OWS Character(1) VARCHAR2(1) NOT NULL Oracle Workforce Scheduling
Default Value: N

2 INSTALLED_FLAG Character(1) VARCHAR2(1) NOT NULL Product Installed Flag
Default Value: N

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	INSTALLED_OWS	Character(1)	VARCHAR2(1) NOT NULL	Oracle Workforce Scheduling Default Value: N
2	INSTALLED_FLAG	Character(1)	VARCHAR2(1) NOT NULL	Product Installed Flag Default Value: N