ESTAB_RISK_VW

(SQL View)
Index Back

Etablishment View (Risk Codes)

This view retrieves the risk code and the company for a given establishment

SELECT DISTINCT A.COMPANY , A.ESTABID , B.RISKCD FROM PS_ESTAB_TBL A ,PS_RISK_TBL B WHERE A.ESTABID = B.ESTABID AND B.EFFDT = ( SELECT MAX(C.EFFDT) FROM PS_RISK_TBL C WHERE C.ESTABID = A.ESTABID)

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 COMPANY Character(3) VARCHAR2(3) NOT NULL Company
2 ESTABID Character(12) VARCHAR2(12) NOT NULL Establishment ID
3 RISKCD Character(6) VARCHAR2(6) NOT NULL Risk Code