CAN_WCB_CU_VW

(SQL View)
Index Back

Canadian WCB Class View

WCB classification units of rate groups.

SELECT DISTINCT PROVINCE ,CAN_WCB_RATE_GROUP ,CAN_WCB_CU ,EFFDT FROM PS_CAN_WCB_CU

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 PROVINCE Character(6) VARCHAR2(6) NOT NULL Province
2 CAN_WCB_RATE_GROUP Character(3) VARCHAR2(3) NOT NULL WCB Rate Group.
3 CAN_WCB_CU Character(8) VARCHAR2(8) NOT NULL WCB Classification.
4 EFFDT Date(10) DATE Effective Date