WCB_SYSTEM_CAT

(SQL Table)

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 SYSTEM_CAT Character(4) VARCHAR2(4) NOT NULL System Category
ACEX=Incident Category Type Code
ERED=Near Miss/Dangerous Occurrance
INLO=Incident Location Type Code
ISSB=ISSv3 Basic Wage
ISSG=ISSv3 Gross Wage
ISSI=Investigator Type
ISSR=Room & Board Indicator
ISSS=Differential Premium Indicator
ISST=Tips & Gratuities
OCCA=Occupational Category
SEXT=Gender Code
WKRC=Worker Category
WSCH=Work Schedule

2 EFFDT Date(10) DATE Effective Date
Default Value: %date

3 DESCR Character(30) VARCHAR2(30) NOT NULL Description

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	SYSTEM_CAT	Character(4)	VARCHAR2(4) NOT NULL	System Category ACEX=Incident Category Type Code ERED=Near Miss/Dangerous Occurrance INLO=Incident Location Type Code ISSB=ISSv3 Basic Wage ISSG=ISSv3 Gross Wage ISSI=Investigator Type ISSR=Room & Board Indicator ISSS=Differential Premium Indicator ISST=Tips & Gratuities OCCA=Occupational Category SEXT=Gender Code WKRC=Worker Category WSCH=Work Schedule
2	EFFDT	Date(10)	DATE	Effective Date Default Value: %date
3	DESCR	Character(30)	VARCHAR2(30) NOT NULL	Description