SCC_PEREML_AFLT (SQL View)	Index Back
Email Affiliation Filtered Filter persons based on whether their affiliation is in the affiliation routing table. This is to enable content based routing for the full sync.

SCC_PEREML_AFLT

(SQL View)

Email Affiliation Filtered

Filter persons based on whether their affiliation is in the affiliation routing table. This is to enable content based routing for the full sync.

SELECT A.EMPLID ,A.E_ADDR_TYPE ,A.EMAIL_ADDR ,A.PREF_EMAIL_FLAG FROM PS_HCR_PER_EMAIL_I A WHERE EXISTS ( SELECT 'X' FROM PS_SCC_AFL_PERSON AF , PS_SCC_AFL_ROUTING R WHERE AF.EMPLID = A.EMPLID AND R.INSTITUTION = AF.INSTITUTION AND R.SCC_AFL_CODE = AF.SCC_AFL_CODE )

Parent record: SCC_PERSON_AFLT

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
Default Value: NEW
Prompt Table: PERSON_NAME

2 E_ADDR_TYPE Character(4) VARCHAR2(4) NOT NULL Email Address Type. Note: Dorm long name has been updated as Dormitory as part of PI26 updates. And, the owner id of the field is updated to CC from HR.
BUSN=Business
CAMP=Campus
DORM=Dormitory
HOME=Home
OTHR=Other

3 EMAIL_ADDR Character(70) VARCHAR2(70) NOT NULL Email Address

4 PREF_EMAIL_FLAG Character(1) VARCHAR2(1) NOT NULL Preferred

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID Default Value: NEW Prompt Table: PERSON_NAME
2	E_ADDR_TYPE	Character(4)	VARCHAR2(4) NOT NULL	Email Address Type. Note: Dorm long name has been updated as Dormitory as part of PI26 updates. And, the owner id of the field is updated to CC from HR. BUSN=Business CAMP=Campus DORM=Dormitory HOME=Home OTHR=Other
3	EMAIL_ADDR	Character(70)	VARCHAR2(70) NOT NULL	Email Address
4	PREF_EMAIL_FLAG	Character(1)	VARCHAR2(1) NOT NULL	Preferred