GPCH_ER_TRF_FCT

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	TARIFF_GER	Character(2)	VARCHAR2(2) NOT NULL	Tariff 01=Metal Processing 02=Banking 03=Building and Civil Engineering 04=Clothing Industry 05=Chemical Industry 06=Printing Industry 07=Retail Trade 08=Fossil Oil and Gas Extraction 09=Glass Industry 10=Wholesale and Foreign Trade 11=Wood Processing 12=Rubber Processing 13=Ceramics 14=Agriculture 15=Leather Processing 16=Public Sector 17=Paper Industry 18=Paper Processing 19=Sawing Industry 20=German Seaports 21=Hard-Coal Mining 22=Textile Industry 23=Insurance 24=Housing Industry 25=Periodical Publishers 26=Newspaper Publishers 27=Tobacco Industry
2	TARIFF_AREA_GER	Character(3)	VARCHAR2(3) NOT NULL	Tariff Area
3	EFFDT	Date(10)	DATE NOT NULL	Effective Date Default Value: %date
4	EFF_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Effective Status A=Active I=Inactive Default Value: A
5	GPCH_ER_DD_PER_MM	Number(5,2)	DECIMAL(4,2) NOT NULL	Days per Month
6	GPCH_ER_BASE_MMSTD	Number(2,0)	SMALLINT NOT NULL	Regular Monthly Pay
7	GPCH_ER_DD_PER_WK	Number(1,0)	SMALLINT NOT NULL	Work Days per Week
8	GPCH_ER_WK_PER_MM	Number(5,3)	DECIMAL(4,3) NOT NULL	Weeks per Month
9	GPCH_ER_BASE_MMVAR	Number(2,0)	SMALLINT NOT NULL	Variable Monthly Pay
10	GPCH_ER_STD_MM_HRS	Number(6,2)	DECIMAL(5,2) NOT NULL	Standard Monthly Hours
11	GPCH_ER_HRS_DD	Signed Number(6,2)	DECIMAL(4,2) NOT NULL	Hours per Day
12	GPCH_ER_HRS_WEEK	Number(6,2)	DECIMAL(5,2) NOT NULL	Hours per Week
13	GPCH_ER_HRS_YEAR	Number(7,2)	DECIMAL(6,2) NOT NULL	Hours per Year
14	GPCH_ER_DAYS_YEAR	Number(6,2)	DECIMAL(5,2) NOT NULL	Days per Year