SCC_SM_EMAIL_I (SQL View)	Index Back
Email fields for Ext S/M Email address fields used to define the External Search/Match response message

SCC_SM_EMAIL_I

(SQL View)

Email fields for Ext S/M

Email address fields used to define the External Search/Match response message

SELECT 'P' ,' ' , A.EMPLID ,A.E_ADDR_TYPE ,A.EMAIL_ADDR ,A.PREF_EMAIL_FLAG FROM PS_HCR_PER_EMAIL_I A

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 SM_TYPE Character(1) VARCHAR2(1) NOT NULL Search Match Type: This field identifies the domain of core data to be searched.
A=Applicant
O=Organization
P=Person

2 SCC_UID Character(100) VARCHAR2(100) NOT NULL Universal Hub ID

3 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
Default Value: NEW

4 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

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

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

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	SM_TYPE	Character(1)	VARCHAR2(1) NOT NULL	Search Match Type: This field identifies the domain of core data to be searched. A=Applicant O=Organization P=Person
2	SCC_UID	Character(100)	VARCHAR2(100) NOT NULL	Universal Hub ID
3	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID Default Value: NEW
4	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
5	EMAIL_ADDR	Character(70)	VARCHAR2(70) NOT NULL	Email Address
6	PREF_EMAIL_FLAG	Character(1)	VARCHAR2(1) NOT NULL	Preferred