SCC_PERSON_I (SQL View)	Index Back
CS Person Interface View Interface View based on HCR_PERSON_I ,Used by Constituent Management Service

SCC_PERSON_I

(SQL View)

CS Person Interface View

Interface View based on HCR_PERSON_I ,Used by Constituent Management Service

SELECT EMPLID , BIRTHDATE , DT_OF_DEATH , ' ' , 0 FROM PS_HCR_PERSON_I

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

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

2 BIRTHDATE Date(10) DATE Date of Birth

3 DT_OF_DEATH Date(10) DATE Date of Death

4 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

5 SCC_SCORE Number(3,0) SMALLINT NOT NULL The score returned by the external search/match process to weight the weight the relevancy of the data returned

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID Default Value: NEW
2	BIRTHDATE	Date(10)	DATE	Date of Birth
3	DT_OF_DEATH	Date(10)	DATE	Date of Death
4	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
5	SCC_SCORE	Number(3,0)	SMALLINT NOT NULL	The score returned by the external search/match process to weight the weight the relevancy of the data returned