CALC_MSG_B_VW

(SQL View)
Index Back

Batch Calc Messages View


select distinct business_unit, batch_id, emplid from PS_CALC_MESSAGES where batch_id <> ' '

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit

Default Value: OPR_DEF_TBL_CS.BUSINESS_UNIT

Prompt Table: SP_BU_SF_NONVW

2 BATCH_ID Character(12) VARCHAR2(12) NOT NULL Batch ID
3 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID