SFA_XANTAD_BIND

(SQL View)
Index Back

Pop Select Exp Ant Aid Bind

Required Fields "Bind" record for Expire Anticiapted Aid Population Selection Context. It's a view to PS_ANTICIPATED_AID.

SELECT DISTINCT A.EMPLID , B.NAME FROM PS_ANTICIPATED_AID A , PS_HCR_PERSON_NM_I B WHERE A.EMPLID = B.EMPLID

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