GPBR_BAT_HST_VW

(SQL View)
Index Back

Override eSocial evt hist txn

Prompt record used to override transactions previoulsy imported into driver tables for historical data of eSocial events.

SELECT COMPANY , GPBR_EVENT_CD , GPBR_BATCH_CODE , GPBR_LOAD_STATUS FROM PS_GPBR_EH_S1070_H WHERE GPBR_LOAD_STATUS <> 'F'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 COMPANY Character(3) VARCHAR2(3) NOT NULL Company
2 GPBR_EVENT_CD Character(6) VARCHAR2(6) NOT NULL eSocial - Event Code
3 GPBR_BATCH_CODE Character(15) VARCHAR2(15) NOT NULL Batch Code for Vacation Credit
4 GPBR_LOAD_STATUS Character(1) VARCHAR2(1) NOT NULL Import Load Status
F=Finalized
I=Invalid
V=Valid