GPBR_TER_ER_DTL

(SQL Table)
Index Back

GPBR_TER_ER_DTL

Termination Earnings Codes

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 GPBR_RPT_PROC_TYPE Character(3) VARCHAR2(3) NOT NULL Process Report Type
001=Homolognet Termination
002=Homolognet Payroll
003=Homolognet Absences
004=eSocial Termination
2 EFFDT Date(10) DATE NOT NULL Effective Date

Default Value: %date

3 GPBR_ELEM_CODE Character(6) VARCHAR2(6) NOT NULL Report Code

Prompt Table: GPBR_RPT_CD_TBL

4 GPBR_ELEM_VALUE Character(1) VARCHAR2(1) NOT NULL Report Code use Value

Y/N Table Edit

Default Value: N

5 GPBR_ELEM_UNITS Character(1) VARCHAR2(1) NOT NULL Report Code use Units

Y/N Table Edit

Default Value: N

6 GPBR_ELEM_PERCENT Character(1) VARCHAR2(1) NOT NULL Report Code use Percent

Y/N Table Edit

Default Value: N

7 GPBR_ELEM_CALC_B Character(1) VARCHAR2(1) NOT NULL Report Code use Base Calculation

Y/N Table Edit

Default Value: N

8 GPBR_ELEM_PROD Character(1) VARCHAR2(1) NOT NULL Report Code is Production

Y/N Table Edit

Default Value: N

9 GPBR_ELEM_SOURCE Character(1) VARCHAR2(1) NOT NULL Description source of Production Report Code
1=Element Name
2=User Field

Default Value: 1

10 GPBR_ELEM_USR_FLD Character(1) VARCHAR2(1) NOT NULL Report Code Description, User Field Number
0=Not Applicable
1=User Field 1
2=User Field 2
3=User Field 3
4=User Field 4
5=User Field 5
6=User Field 6

Default Value: 0

11 GPBR_ELEM_TAX_INT Character(3) VARCHAR2(3) NOT NULL Report Code Tax Integration