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.

GPBR_BAT_HST_VW

(SQL View)

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

#	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