GPBR_TER_CD_TBL(SQL Table) |
Index Back |
---|---|
eSocial Termination codeeSocial Termination code |
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | GPBR_EMPL_CATEGRY | Character(1) | VARCHAR2(1) NOT NULL |
eSocial : Employee Category.
0=Employee 1=Non-Employee Default Value: 0 |
2 | GPBR_TERM_CODE | Character(2) | VARCHAR2(2) NOT NULL | eSocial:Termination Legal Code. |
3 | EFFDT | Date(10) | DATE NOT NULL |
Effective Date
Default Value: %date |
4 | EFF_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Effective Status
A=Active I=Inactive Default Value: A |
5 | DESCR50 | Character(50) | VARCHAR2(50) NOT NULL | Description of length 50 |
6 | DESCRLONG | Long Character | CLOB | Long Description |
7 | GPBR_TER_PROCESS | Character(1) | VARCHAR2(1) NOT NULL |
eSocial: Termination Process Calculation Indicator.
0=Do not Require Calculation 1=Requires Calculation Default Value: 1 |