Logic that Builds the Finder File of EDW_PERS_ID:
Note that year, coa/campus, and coll_cd are hard coded in.  

#1 Paid from College Account
SELECT 	
	DISTINCT EDW.V_EMPEE_PERS_HIST_1.EDW_PERS_ID
FROM
	EDW.T_ORG_CD_HIST, 
	EDW.V_PAYR_ACCTG_DETL, 
	EDW.V_EMPEE_PERS_HIST_1
WHERE
	EDW.T_ORG_CD_HIST.ORG_CD = EDW.V_PAYR_ACCTG_DETL.ORG_CD AND 
	EDW.V_PAYR_ACCTG_DETL.EDW_PERS_ID = EDW.V_EMPEE_PERS_HIST_1.EDW_PERS_ID AND 
	(EDW.V_PAYR_ACCTG_DETL.PAYR_YR >= '2004') AND 
	(EDW.T_ORG_CD_HIST.COLL_LEVEL_3_CD = 'KN') AND 
	(EDW.T_ORG_CD_HIST.ORG_CD_CUR_INFO_IND = 'Y') AND 
	(EDW.V_EMPEE_PERS_HIST_1.PERS_CUR_INFO_IND = 'Y') AND
	(NOT EXISTS
		(SELECT *                     
		FROM EDU_FINDERFILE
		WHERE EDU_FINDERFILE.EDW_PERS_ID = V_PAYR_ACCTG_DETL.EDW_PERS_ID)) 
		
#2  Actively employed by College.
SELECT 	
	DISTINCT EDW.V_EMPEE_PERS_HIST_1.EDW_PERS_ID
FROM	
	V_EMPEE_HIST_1, 
	EDW.V_EMPEE_PERS_HIST_1, 
	EDW.T_JOB_HIST, 
	EDW.T_JOB_LBR_DISTR, 
	V_JOB_DETL_HIST_1
WHERE	
	V_EMPEE_HIST_1.EDW_PERS_ID = EDW.V_EMPEE_PERS_HIST_1.EDW_PERS_ID AND 
	V_EMPEE_HIST_1.EDW_PERS_ID = EDW.T_JOB_HIST.EDW_PERS_ID AND 
	EDW.T_JOB_HIST.EDW_PERS_ID = EDW.T_JOB_LBR_DISTR.EDW_PERS_ID AND 
	EDW.T_JOB_HIST.POSN_NBR = EDW.T_JOB_LBR_DISTR.POSN_NBR AND 
	EDW.T_JOB_HIST.JOB_SUFFIX = EDW.T_JOB_LBR_DISTR.JOB_SUFFIX AND 
	EDW.T_JOB_HIST.EDW_PERS_ID = V_JOB_DETL_HIST_1.EDW_PERS_ID AND 
	EDW.T_JOB_HIST.POSN_NBR = V_JOB_DETL_HIST_1.POSN_NBR AND 
	EDW.T_JOB_HIST.JOB_SUFFIX = V_JOB_DETL_HIST_1.JOB_SUFFIX AND 
	(EDW.V_EMPEE_PERS_HIST_1.PERS_CUR_INFO_IND = 'Y') AND 
	(V_EMPEE_HIST_1.EMPEE_CUR_INFO_IND = 'Y') AND 
	(V_JOB_DETL_HIST_1.JOB_DETL_COLL_CD  = 'KN') AND 
	(EDW.T_JOB_HIST.JOB_CUR_INFO_IND = 'Y') AND 
	(V_JOB_DETL_HIST_1.JOB_DETL_CUR_INFO_IND = 'Y') AND 
	(V_JOB_DETL_HIST_1.JOB_DETL_STATUS_DESC = 'Active') AND 
	(V_JOB_DETL_HIST_1.JOB_DETL_DATA_STATUS_DESC = 'Current') AND 
	(EDW.T_JOB_LBR_DISTR.COA_CD = '1') AND 
	(EDW.T_JOB_LBR_DISTR.JOB_LBR_DISTR_DATA_STATUS_DESC = 'Current')

#3  Student in our College this term or future term
SELECT 
	DISTINCT V_PERS_HIST_PRR_FULL_LTD.EDW_PERS_ID
FROM       
	V_PERS_HIST_PRR_FULL_LTD, 
	T_STUDENT_TERM, 
	T_TERM_CD
WHERE  
   	V_PERS_HIST_PRR_FULL_LTD.EDW_PERS_ID = T_STUDENT_TERM.EDW_PERS_ID  AND 
 	T_STUDENT_TERM.TERM_CD = T_TERM_CD.TERM_CD  AND
	T_STUDENT_TERM.COLL_CD = 'KN' AND 
	T_STUDENT_TERM.CAMPUS_CD = '100' AND
	T_TERM_CD.TERM_END_DT > SYSDATE AND 
	V_PERS_HIST_PRR_FULL_LTD.PERS_CUR_INFO_IND = 'Y' AND 
	(NOT EXISTS
		(SELECT     *
		FROM EDU_FINDERFILE
		WHERE EDU_FINDERFILE.EDW_PERS_ID = PERS_HIST_PRR_FULL_LTD.EDW_PERS_ID)

#4 Is PCard cardholder
SELECT 
	DISTINCT PCARD_CARDHOLDER_EDW_PERS_ID
FROM	T_PCARD_TRAN_DETL INNER JOIN
	T_ORG_CD_HIST ON T_PCARD_TRAN_DETL.COA_CD = T_ORG_CD_HIST.COA_CD AND 
	T_PCARD_TRAN_DETL.ORG_CD = T_ORG_CD_HIST.ORG_CD
WHERE	T_ORG_CD_HIST.COLL_LEVEL_3_CD = 'KN' AND 
	(NOT EXISTS
		(SELECT   *               
		FROM  EDU_FINDERFILE                            
		WHERE EDU_FINDERFILE.EDW_PERS_ID =  PCARD_CARDHOLDER_EDW_PERS_ID))