SCC_SM_ADR_TYPE

(SQL View)
Index Back

Address Types for Ext S/M

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

SELECT DISTINCT 'P' ,' ' , A.EMPLID , A.ADDRESS_TYPE FROM PS_ADDRESSES A , PS_ADDRESS_TYP_TBL B WHERE A.ADDRESS_TYPE = B.ADDRESS_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
4 ADDRESS_TYPE Character(4) VARCHAR2(4) NOT NULL Address Type