SFA_ACTADYR_BND (SQL View)	Index Back
Bind record for STUDENT_AID Bind record used to activate an aid year for students using Population Select functionality. This view is essentially a stripped down version of PEOPLE_SRCH_FA.

SFA_ACTADYR_BND

(SQL View)

Bind record for STUDENT_AID

Bind record used to activate an aid year for students using Population Select functionality. This view is essentially a stripped down version of PEOPLE_SRCH_FA.

SELECT A.EMPLID , B.NAME FROM PS_HCR_PERSON_I A , PS_SCC_PRI_NAME_VW B WHERE A.EMPLID = B.EMPLID AND B.EFFDT = ( SELECT MAX(X.EFFDT) FROM PS_SCC_PRI_NAME_VW X WHERE X.EMPLID = B.EMPLID AND X.EFFDT <= %CurrentDateIn)

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
Prompt Table: PEOPLE_SRCH

2 NAME Character(50) VARCHAR2(50) NOT NULL Name

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