BO_NAME_CNTC_VW

(SQL View)
 Index Back

Primary Name View

Retrieving Primary Business Object Name

SELECT BO_ID , BO_NAME , BO_NAME_AC , BO_NAME_DISPLAY , BO_NAME_UPPER , BO_NAME_DISP_UPPER , LAST_NAME_SRCH , FIRST_NAME_SRCH , LAST_NAME , FIRST_NAME , NAME_AC FROM PS_BO_NAME WHERE PRIMARY_IND = 'Y'

  • Parent record: BO

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 BO_ID_CNTCT Number(31,0) DECIMAL(31) NOT NULL This field represents the business object ID for a Contact
    2 BO_NAME Character(50) VARCHAR2(50) NOT NULL Name Description of Business Object
    3 BO_NAME_AC Character(50) VARCHAR2(50) NOT NULL Name Description of Business Object
    4 BO_NAME_DISPLAY Character(80) VARCHAR2(80) NOT NULL Full name of the Business Object
    5 BO_NAME_UPPER Character(50) VARCHAR2(50) NOT NULL Name Description of Business Object
    6 BO_NAME_DISP_UPPER Character(80) VARCHAR2(80) NOT NULL Full name of the Business Object in Upper
    7 LAST_NAME_SRCH Character(30) VARCHAR2(30) NOT NULL Last Name
    8 FIRST_NAME_SRCH Character(30) VARCHAR2(30) NOT NULL First Name
    9 LAST_NAME Character(30) VARCHAR2(30) NOT NULL Last Name
    10 FIRST_NAME Character(30) VARCHAR2(30) NOT NULL First Name
    11 NAME_AC Character(50) VARCHAR2(50) NOT NULL Name (Alternate Character)