RB_WRKR_P_NM_VW

(SQL View)
 Index Back

Worker Primary Name

This view returns the primary name for a worker.

SELECT A.PERSON_ID , A.BO_ID , A.SUPERVISOR_ID , B.FIRST_NAME , B.LAST_NAME , B.MIDDLE_NAME , B.NAME , B.BO_NAME , B.BO_NAME_DISPLAY , B.BO_NAME_DISP_UPPER , B.NAME_AC , B.LAST_NAME_SRCH , B.FIRST_NAME_SRCH , B.PREF_FIRST_NAME , B.NAME_INITIALS , B.NAME_PREFIX , B.NAME_SUFFIX , B.NAME_ROYAL_PREFIX , B.NAME_ROYAL_SUFFIX , B.NAME_TITLE , B.SECOND_LAST_NAME FROM PS_RB_WORKER A , PS_BO_NAME B WHERE A.BO_ID = B.BO_ID AND B.PRIMARY_IND = 'Y'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 PERSON_ID Character(15) VARCHAR2(15) NOT NULL Person ID
2 BO_ID Signed Number(32,0) DECIMAL(31) NOT NULL Business Object ID
3 SUPERVISOR_ID Character(15) VARCHAR2(15) NOT NULL ID of a worker's supervisor.
4 FIRST_NAME Character(30) VARCHAR2(30) NOT NULL First Name
5 LAST_NAME Character(30) VARCHAR2(30) NOT NULL Last Name
6 MIDDLE_NAME Character(30) VARCHAR2(30) NOT NULL Middle Name
7 NAME Character(50) VARCHAR2(50) NOT NULL Name
8 BO_NAME Character(50) VARCHAR2(50) NOT NULL Name Description of Business Object
9 BO_NAME_DISPLAY Character(80) VARCHAR2(80) NOT NULL Full name of the Business Object
10 BO_NAME_DISP_UPPER Character(80) VARCHAR2(80) NOT NULL Full name of the Business Object in Upper
11 NAME_AC Character(50) VARCHAR2(50) NOT NULL Name (Alternate Character)
12 LAST_NAME_SRCH Character(30) VARCHAR2(30) NOT NULL Last Name
13 FIRST_NAME_SRCH Character(30) VARCHAR2(30) NOT NULL First Name
14 PREF_FIRST_NAME Character(30) VARCHAR2(30) NOT NULL PREF_FIRST_NAME field is used to identify the employees preferred first name
15 NAME_INITIALS Character(6) VARCHAR2(6) NOT NULL Name Initials
16 NAME_PREFIX Character(4) VARCHAR2(4) NOT NULL Name Prefix
17 NAME_SUFFIX Character(15) VARCHAR2(15) NOT NULL Name Suffix
18 NAME_ROYAL_PREFIX Character(15) VARCHAR2(15) NOT NULL Name Royal Prefix
19 NAME_ROYAL_SUFFIX Character(15) VARCHAR2(15) NOT NULL Name Royal Suffix
20 NAME_TITLE Character(30) VARCHAR2(30) NOT NULL Title
21 SECOND_LAST_NAME Character(30) VARCHAR2(30) NOT NULL Second Last Name