WCB_CLS_SUB_VW

(SQL View)
 Index Back

SELECT CLASS_SUBCLASS FROM PS_WCB_EMPREL_OPN WHERE EFFDT = ( SELECT MAX(B.EFFDT) FROM PS_WCB_EMPREL_OPN B WHERE B.EFFDT <= %CurrentDateIn)

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 CLASS_SUBCLASS Number(6,0) INTEGER NOT NULL Class/Subclass