GPBR_RC_EVT_HST

(SQL Table)
Index Back

Run Control BATCH PI

Process Automated Earning / Deduction

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).

Default Value: PRCSRUNCNTL.OPRID

2 RUN_CNTL_ID Character(30) VARCHAR2(30) NOT NULL Run Control ID
3 COMPANY Character(3) VARCHAR2(3) NOT NULL Company

Prompt Table: GPBR_CMP_FLG_VW

4 GPBR_EVENT_CD Character(6) VARCHAR2(6) NOT NULL eSocial - Event Code

Prompt Table: GPBR_EVT_HST_VW

5 FILENAME Character(80) VARCHAR2(80) NOT NULL File Name
6 GPBR_BATCH_CODE Character(15) VARCHAR2(15) NOT NULL Batch Code for Vacation Credit

Prompt Table: GPBR_BAT_HST_VW

7 GPBR_ACTION_TYPE Character(1) VARCHAR2(1) NOT NULL Action Type in processing historical data of eSocial events.
A=Add
D=Delete
O=Override

Default Value: A

8 GPBR_PROC_OPT Character(1) VARCHAR2(1) NOT NULL Processing option for historical data of eSocial events.
F=Finalize
P=Process Data

Default Value: P

9 RUN_FINAL_IND Character(1) VARCHAR2(1) NOT NULL Finalize Entire Run

Default Value: N

10 GPBR_ATTACH_FILE Character(1) VARCHAR2(1) NOT NULL Load eSocial event historical data attachment.