BO_NAME_VW

(SQL View)
 Index Back

Business Object Name

Business Object Name. It lists out all the names. Mainly used in Mobile.

SELECT BO_ID , SEQ_NBR , NAME_TYPE , PRIMARY_IND , BO_NAME , BO_NAME_AC , BO_NAME_SHORT , SOURCE_IND , BO_NAME_UPPER , BO_NAME_DISPLAY , BO_NAME_DISP_UPPER ,%subrec(NAMEGBL_SBR,A) , ROW_LASTMANT_OPRID , ROW_LASTMANT_DTTM FROM PS_BO_NAME A

  • Parent record: BO

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 BO_ID Signed Number(32,0) DECIMAL(31) NOT NULL Business Object ID
    2 SEQ_NBR Number(15,0) DECIMAL(15) NOT NULL Sequence Number
    3 NAME_TYPE Character(15) VARCHAR2(15) NOT NULL Business Object Name Type

    Prompt Table: BO_PER_NM_TYP_V

    4 PRIMARY_IND Character(1) VARCHAR2(1) NOT NULL Flag that indicates whether or not it is Primary
    N=No
    Y=Yes
    5 BO_NAME Character(50) VARCHAR2(50) NOT NULL Name Description of Business Object

    Default Value: BO_NAME.NAME

    6 BO_NAME_AC Character(50) VARCHAR2(50) NOT NULL Name Description of Business Object
    7 BO_NAME_SHORT Character(10) VARCHAR2(10) NOT NULL Short Name of Business Object
    8 SOURCE_IND Character(4) VARCHAR2(4) NOT NULL EIP Source Indicator
    CRM=CRM
    EBS=EBIZ Suite
    EXT=External
    HRMS=HCM
    SCM=SCM

    Default Value: CRM

    9 BO_NAME_UPPER Character(50) VARCHAR2(50) NOT NULL Name Description of Business Object
    10 BO_NAME_DISPLAY Character(80) VARCHAR2(80) NOT NULL Full name of the Business Object
    11 BO_NAME_DISP_UPPER Character(80) VARCHAR2(80) NOT NULL Full name of the Business Object in Upper
    12 COUNTRY_NM_FORMAT Character(3) VARCHAR2(3) NOT NULL This is the country name format field.

    Prompt Table: COUNTRY_TBL

    13 NAME Character(50) VARCHAR2(50) NOT NULL Name
    14 NAME_AC Character(50) VARCHAR2(50) NOT NULL Name (Alternate Character)
    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 LAST_NAME_SRCH Character(30) VARCHAR2(30) NOT NULL Last Name
    22 FIRST_NAME_SRCH Character(30) VARCHAR2(30) NOT NULL First Name
    23 LAST_NAME Character(30) VARCHAR2(30) NOT NULL Last Name
    24 FIRST_NAME Character(30) VARCHAR2(30) NOT NULL First Name
    25 MIDDLE_NAME Character(30) VARCHAR2(30) NOT NULL Middle Name
    26 SECOND_LAST_NAME Character(30) VARCHAR2(30) NOT NULL Second Last Name
    27 SECOND_LAST_SRCH Character(30) VARCHAR2(30) NOT NULL Second Name
    28 PREF_FIRST_NAME Character(30) VARCHAR2(30) NOT NULL PREF_FIRST_NAME field is used to identify the employees preferred first name
    29 ROW_LASTMANT_OPRID Character(30) VARCHAR2(30) NOT NULL ID of user who last modified the row.
    30 ROW_LASTMANT_DTTM DateTime(26) TIMESTAMP The date and time that the row was last updated.