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 |