RBF_ARRA_ALT_VW

(SQL View)
 Index Back

Business Object Name

Business Object Name

SELECT A.BO_ID , A.ALT_CAP_ID , B.BO_NAME ,B.BO_NAME_DISPLAY , A.TIN_TYPE , A.TIN , A.LEGAL_FORM , C.CUST_STATUS , C.SEGMENT FROM PS_RBF_ALT_CAP A , PS_BO_NAME B , PS_BC C WHERE A.BO_ID = B.BO_ID AND A.BO_ID= C.BO_ID AND B.BO_ID= C.BO_ID AND B.PRIMARY_IND = 'Y'

  • Parent record: BO

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 BUS_CONTACT_ID Number(31,0) DECIMAL(31) NOT NULL Business Contact Id
    2 ALT_CAP_ID Character(15) VARCHAR2(15) NOT NULL Alternate Capacity ID
    3 BO_NAME 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 TIN_TYPE Character(1) VARCHAR2(1) NOT NULL Tin Type
    F=Federal Employer ID
    S=Social Security Number
    6 TIN Character(20) VARCHAR2(20) NOT NULL TIN
    7 LEGAL_FORM Character(30) VARCHAR2(30) NOT NULL legal form
    8 CUST_STATUS Character(1) VARCHAR2(1) NOT NULL Customer Status Indicator. BC.CUST_STATUS
    A=Active
    I=Inactive
    9 SEGMENT Character(4) VARCHAR2(4) NOT NULL Segment code for customer data