AV_INVLV_VW

(SQL View)
Index Back

Involvement Flag View

Use AV_INVLV_VW to determine if any involvement exist for the constitutent

SELECT DISTINCT EMPLID, 'Y' FROM PS_AV_INVLV_TBL

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
2 INVLV_FLG Character(1) VARCHAR2(1) NOT NULL Involvement

Y/N Table Edit