SCC_PERPHN_AFLT (SQL View)	Index Back
Phone 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_PERPHN_AFLT

(SQL View)

Phone 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.PHONE_TYPE ,%subrec(PHONE_SBR,A) , A.EXTENSION , A.PREF_PHONE_FLAG FROM PS_HCR_PER_PHONE_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

2 PHONE_TYPE Character(4) VARCHAR2(4) NOT NULL Phone Type
BUSN=Business
CAMP=Campus
CELL=Mobile
DORM=Dormitory
FAX=FAX
HOME=Home
MAIN=Main
OTR=Other
PGR1=Pager 1
PGR2=Pager 2
TELX=Telex
WORK=Work

3 COUNTRY_CODE Character(3) VARCHAR2(3) NOT NULL Country Code

4 PHONE Character(24) VARCHAR2(24) NOT NULL Telephone

5 EXTENSION Character(6) VARCHAR2(6) NOT NULL Phone number extension

6 PREF_PHONE_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
2	PHONE_TYPE	Character(4)	VARCHAR2(4) NOT NULL	Phone Type BUSN=Business CAMP=Campus CELL=Mobile DORM=Dormitory FAX=FAX HOME=Home MAIN=Main OTR=Other PGR1=Pager 1 PGR2=Pager 2 TELX=Telex WORK=Work
3	COUNTRY_CODE	Character(3)	VARCHAR2(3) NOT NULL	Country Code
4	PHONE	Character(24)	VARCHAR2(24) NOT NULL	Telephone
5	EXTENSION	Character(6)	VARCHAR2(6) NOT NULL	Phone number extension
6	PREF_PHONE_FLAG	Character(1)	VARCHAR2(1) NOT NULL	Preferred