GPBR_TER_CD_TBL(SQL Table) |
Index Back |
|---|---|
eSocial Termination codeeSocial Termination code |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | Character(1) | VARCHAR2(1) NOT NULL |
eSocial : Employee Category.
0=Employee 1=Non-Employee Default Value: 0 |
|
| 2 | Character(2) | VARCHAR2(2) NOT NULL | eSocial:Termination Legal Code. | |
| 3 | 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 |