BUS_UNIT_OPT_HR

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	SETID	Character(5)	VARCHAR2(5) NOT NULL	SetID Prompt Table: SET_VLD_HR_06
2	COMPANY	Character(3)	VARCHAR2(3) NOT NULL	Company Prompt Table: COMPANY_TBL
3	COUNTRY	Character(3)	VARCHAR2(3) NOT NULL	Country Prompt Table: COUNTRY_TBL
4	EXCHNG_TO_CURRENCY	Character(3)	VARCHAR2(3) NOT NULL	To Currency Prompt Table: CURRENCY_CD_TBL
5	MIN_STD_HRS	Number(7,2)	DECIMAL(6,2) NOT NULL	Minimum Standard Hours
6	MAX_STD_HRS	Number(7,2)	DECIMAL(6,2) NOT NULL	Maximum Standard Hours
7	STD_HRS_DEFAULT	Number(7,2)	DECIMAL(6,2) NOT NULL	Default Standard Hours Default Value: 40
8	STD_HRS_FREQUENCY	Character(5)	VARCHAR2(5) NOT NULL	Standard Work Period Default Value: W Prompt Table: STDHRS_FREQ_VW
9	CAN_CMA	Character(2)	VARCHAR2(2) NOT NULL	Canadian Census Metropol Area Default Value: 06
10	CAN_IND_SECTOR	Character(3)	VARCHAR2(3) NOT NULL	Canadian Industrial Sector Default Value: 451
11	IND_COMMITTEE_BEL	Character(3)	VARCHAR2(3) NOT NULL	The Joint Industrial Committee is used for Belgium to track the 'Paritair Comite' on company-, business unit- and department-level, Prompt Table: UNION_TBL
12	NACE_CD_BEL	Character(10)	VARCHAR2(10) NOT NULL	The NACE Code is used for a generic systematic classification of companies within the European community. Format: AB12,34567 A - Section B - Subsection 12 - Division 345 - Group 6 - Class 7 - Subclass