LATE_MSG_EMP_VW

(SQL View)
 Index Back

Late Fees Msg View (emplID)


select distinct a.business_unit, a.batch_id, a.emplid from PS_LATE_FEE_EMPLID a, ps_late_fee_empmsg b where a.business_unit = b.business_unit and a.batch_id = b.batch_id and a.emplid = b.emplid

  • Parent record: CANC_MSG_BAT_VW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
    2 BATCH_ID Character(12) VARCHAR2(12) NOT NULL Batch ID
    3 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID

    Prompt Table: PEOPLE_SRCH