SCC_NAMTYP_AFLT (SQL View)	Index Back
Name Types Affiliation Filter 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_NAMTYP_AFLT

(SQL View)

Name Types Affiliation Filter

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 N.EMPLID ,N.NAME_TYPE ,T.ORDER_BY_SEQ FROM PS_NAMES N , PS_NAME_TYPE_TBL T WHERE T.NAME_TYPE = N.NAME_TYPE AND EXISTS ( SELECT 'X' FROM PS_SCC_AFL_PERSON AF , PS_SCC_AFL_ROUTING R WHERE AF.EMPLID = N.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
Prompt Table: PERSON

2 NAME_TYPE Character(3) VARCHAR2(3) NOT NULL Type of Name
Prompt Table: NAME_TYPE_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 Prompt Table: PERSON
2	NAME_TYPE	Character(3)	VARCHAR2(3) NOT NULL	Type of Name Prompt Table: NAME_TYPE_TBL
3	ORDER_BY_SEQ	Number(2,0)	SMALLINT NOT NULL	Order by Sequence