GPBR_TER_ER_DTL(SQL Table) |
Index Back |
---|---|
GPBR_TER_ER_DTLTermination 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 |