SCC_SM_NAME_TYP (SQL View)	Index Back
Name type fields for Ext S/M Name type fields used to define the External Search/Match response message

SCC_SM_NAME_TYP

(SQL View)

Name type fields for Ext S/M

Name type fields used to define the External Search/Match response message

SELECT DISTINCT 'P' ,' ' ,A.EMPLID ,A.NAME_TYPE FROM PS_NAMES A , PS_NAME_TYPE_TBL B WHERE A.NAME_TYPE = B.NAME_TYPE

# 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 NAME_TYPE Character(3) VARCHAR2(3) NOT NULL Type of Name

#	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	NAME_TYPE	Character(3)	VARCHAR2(3) NOT NULL	Type of Name