SCC_ADRTYP_AFLT (SQL View)	Index Back
Address Type AffiliationFilter 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_ADRTYP_AFLT

(SQL View)

Address Type AffiliationFilter

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 DISTINCT AD.EMPLID , AD.ADDRESS_TYPE , T.ORDER_BY_SEQ FROM PS_ADDRESSES AD , PS_ADDRESS_TYP_TBL T WHERE T.ADDRESS_TYPE = AD.ADDRESS_TYPE AND EXISTS ( SELECT 'X' FROM PS_SCC_AFL_PERSON AF , PS_SCC_AFL_ROUTING R WHERE AF.EMPLID = AD.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

2 ADDRESS_TYPE Character(4) VARCHAR2(4) NOT NULL Address Type
Prompt Table: ADDRESS_TYP_TBL

3 ORDER_BY_SEQ Number(2,0) SMALLINT NOT NULL Order by Sequence

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID
2	ADDRESS_TYPE	Character(4)	VARCHAR2(4) NOT NULL	Address Type Prompt Table: ADDRESS_TYP_TBL
3	ORDER_BY_SEQ	Number(2,0)	SMALLINT NOT NULL	Order by Sequence