HRBP_PRTTYP_VW

(SQL View)
 Index Back

Business Partner Type View

Used as search view for BP Approval Definition Component

SELECT FIELDVALUE , XLATLONGNAME FROM PSXLATITEM B WHERE B.FIELDNAME = 'HRBP_PARTNER_TYPE' AND EFFDT = ( SELECT MAX(EFFDT) FROM PSXLATITEM C WHERE C.FIELDNAME = B.FIELDNAME AND C.FIELDVALUE = B.FIELDVALUE AND C.EFFDT <= %CurrentDateIn) AND EFF_STATUS = 'A'

  • Related Language Record: HRBP_PRTTYP_LVW

  • Parent Record Of HRBP_APPR_DEFN HRBP_DISP_DEFN

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 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
    2 DESCR Character(30) VARCHAR2(30) NOT NULL Description