RC_EBSEMPLID_VW

(SQL View)
 Index Back

EBS Employee Number

This is a view that retrieves the EBS Employee Numbers from the cross reference table.

SELECT EOTF_MAP_NAME , EOTF_DOMAIN_NAME , EOTF_COMMONELEMENT , EOTF_ELEMENT005 FROM PS_EOTF_XREF_DATA WHERE EOTF_DOMAIN_NAME = 'EBS' AND EOTF_ELEMENT005 <> ' '

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 EOTF_MAP_NAME Character(150) VARCHAR2(150) NOT NULL Map Name
2 EOTF_DOMAIN_NAME Character(30) VARCHAR2(30) NOT NULL Domain Name
3 EOTF_COMMONELEMENT Character(36) VARCHAR2(36) NOT NULL Common Element
4 EBS_EMPLID Character(30) VARCHAR2(30) NOT NULL EBS Employee Number used in the EBS - HR HelpDesk integration.