HRBP_BP_SRCH

(SQL View)
 Index Back

Business Partner Search

Search view for existing business partner teams.

SELECT A.HRMH_MATRIX_ID , A.DESCR , B.HRBP_PARTNER_TYPE , X.XLATLONGNAME FROM PS_HRMH_MATRX_DEFN A , PS_HRBP_CONFIG_TBL B , PSXLATITEM X WHERE A.EFFDT = ( SELECT MAX(A1.EFFDT) FROM PS_HRMH_MATRX_DEFN A1 WHERE A1.HRMH_MATRIX_ID = A.HRMH_MATRIX_ID AND A1.EFFDT <= %CurrentDateIn ) AND B.HRMH_MATRIX_ID = A.HRMH_MATRIX_ID AND X.FIELDNAME = 'HRBP_PARTNER_TYPE' AND X.FIELDVALUE = B.HRBP_PARTNER_TYPE AND X.EFFDT = ( SELECT MAX(X1.EFFDT) FROM PSXLATITEM X1 WHERE X1.FIELDNAME = X.FIELDNAME AND X1.FIELDVALUE = X.FIELDVALUE AND X1.EFFDT <= %CurrentDateIn )

  • Related Language Record: HRBP_BP_SRCHL

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 HRMH_MATRIX_ID Character(15) VARCHAR2(15) NOT NULL Matrix Identifier

    Prompt Table: HRBP_MTRX_NONBP

    2 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    3 HRBP_PARTNER_TYPE Character(4) VARCHAR2(4) NOT NULL Business Partner Type
    ABS=Absence Management
    BEN=Benefits
    HR=Human Resources
    OT=Other
    PAY=Payroll
    TL=Time and Labor
    4 HRBP_TYPE_DESCR Character(30) VARCHAR2(30) NOT NULL Business Partner Type Description