ERE_AGRMT_ESPVW

(SQL View)
 Index Back

ERE Agreed View ESP

This view shows if the ERE is with agreement or without agreement.

SELECT A.ERE_ID_ESP , A.ERE_STATUS_ESP FROM PS_ERE_DTA_DOC_ESP A WHERE ERE_STATUS_ESP IN ('15', '20')

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 ERE_ID_ESP Character(10) VARCHAR2(10) NOT NULL ERE ID
2 ERE_W_AGREEMNT_ESP Character(2) VARCHAR2(2) NOT NULL ERE with Agreement