BO_CNCT_PRSN_VW

(SQL View)
 Index Back

BO ID and Person ID View

View to Fetch BO_ID_CONTACT and PERSON_ID

SELECT BO_ID , PERSON_ID , EMPLID , NAME ,NAME_AC , TITLE , FIRST_NAME , LAST_NAME , MIDDLE_NAME , SEX , CONTACT_FLAG ,BO_NAME_DISPLAY FROM PS_RB_PRSN_P_NM_VW

  • Related Language Record: BO_CNCT_PR_LN_V

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 BO_ID_CONTACT Number(31,0) DECIMAL(31) NOT NULL This field indicates the Business Object ID for the contact.
    2 PERSON_ID Character(15) VARCHAR2(15) NOT NULL Person ID
    3 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
    4 NAME Character(50) VARCHAR2(50) NOT NULL Name
    5 NAME_AC Character(50) VARCHAR2(50) NOT NULL Name (Alternate Character)
    6 TITLE Character(35) VARCHAR2(35) NOT NULL Title
    7 FIRST_NAME Character(30) VARCHAR2(30) NOT NULL First Name
    8 LAST_NAME Character(30) VARCHAR2(30) NOT NULL Last Name
    9 MIDDLE_NAME Character(30) VARCHAR2(30) NOT NULL Middle Name
    10 SEX Character(1) VARCHAR2(1) NOT NULL Gender of the person.
    F=Female
    M=Male
    U=Unknown
    11 CONTACT_FLAG Character(1) VARCHAR2(1) NOT NULL An attribute that describes the specific purpose of a given bank/counterparty contact person. It is also used to indicate whether a person has a Contact role.
    E=External Contact
    I=Internal Corporate Contact
    12 BO_NAME_DISPLAY Character(80) VARCHAR2(80) NOT NULL Full name of the Business Object