RC_EBSEMPNAM_VW

(SQL View)
 Index Back

prompt table for emplid field

This view is used as prompt table for several call center records.

SELECT A.EBS_EMPLID , %Substring(C.BO_NAME_DISPLAY,1,50) , C.NAME_PREFIX , C.FIRST_NAME , C.MIDDLE_NAME , C.LAST_NAME , C.NAME_SUFFIX , A.BO_ID FROM PS_RC_EBSWORKER_VW A , PS_RD_PERSON B , PS_RD_PERSON_NAME C WHERE A.BO_ID = B.BO_ID AND B.PERSON_ID = C.PERSON_ID AND C.PRIMARY_IND = 'Y'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 EBS_EMPLID Character(30) VARCHAR2(30) NOT NULL EBS Employee Number used in the EBS - HR HelpDesk integration.
2 NAME Character(50) VARCHAR2(50) NOT NULL Name
3 NAME_PREFIX Character(4) VARCHAR2(4) NOT NULL Name Prefix
4 FIRST_NAME Character(30) VARCHAR2(30) NOT NULL First Name
5 MIDDLE_NAME Character(30) VARCHAR2(30) NOT NULL Middle Name
6 LAST_NAME Character(30) VARCHAR2(30) NOT NULL Last Name
7 NAME_SUFFIX Character(15) VARCHAR2(15) NOT NULL Name Suffix
8 BO_ID Signed Number(32,0) DECIMAL(31) NOT NULL Business Object ID