T7BR_UNINEE - Application record - unemployment insurance
Application record - unemployment insurance information is stored in SAP table T7BR_UNINEE.
It is part of development package PB37 in software component PA-PA-BR. This development package consists of objects that can be grouped under "HR master data: Brazil".
It is part of development package PB37 in software component PA-PA-BR. This development package consists of objects that can be grouped under "HR master data: Brazil".
Fields for table T7BR_UNINEE
Field Name | Description | Is Key | Data Element | Data Type | Length | Check Table |
---|---|---|---|---|---|---|
.INCLUDE | X | HRPADBR_EFD_S_APP_KEY_FIELDS | 0 | |||
MANDT | Client | X | MANDT | CLNT | 6 | T000 |
EVENT_ID | Event identifier | X | HRPADBR_EFD_EVENT_ID | NUMC | 40 | T7BREFD_EVENT |
RECORD_ID | Record code | X | HRPADBR_EFD_RECORD_ID | NUMC | 18 | |
.INCLUDE | HRPADBR_EFD_S_APP_OTHER_FIELDS | 0 | ||||
PARENT_ID | Parent record code | HRPADBR_EFD_PARENT_ID | NUMC | 18 | ||
RECORD_TYPE | Record type | HRPADBR_UNIN_RECORD_TYPE | CHAR | 4 | ||
CPF | Registration number in the CPF | PBR_NUM_CPF | NUMC | 22 | ||
NAME | Employee name | HRPADBR_UNIN_EE_NAME | CHAR | 80 | ||
ADDRESS | Employee address | HRPADBR_UNIN_ADDRESS | CHAR | 80 | ||
ADDRESS_COMPL | Address affix | HRPADBR_UNIN_ADDRESS_COMPL | CHAR | 32 | ||
UF | State | HRPADBR_UNIN_STATE | CHAR | 4 | ||
DDD | DDD | HRPADBR_UNIN_DDD | NUMC | 4 | ||
PHONE | Telephone no. | HRPADBR_UNIN_PHONE | NUMC | 16 | ||
MOTHER_NAME | Mother's name | HRPADBR_UNIN_MOTHER_NAME | CHAR | 80 | ||
PIS | PIS | HRPADBR_UNIN_PIS | CHAR | 22 | ||
CTPS_NR | Obsolete | NUMC | 16 | |||
CTPS_SERIE | Obsolete | NUMC | 10 | |||
CTPS_UF | WCSW state | HRPADBR_UNIN_CTPS_UF | CHAR | 4 | ||
CBO | Brazilian Job Occupation Code | PBR_CBO6 | NUMC | 12 | ||
HIRING_DATE | Hiring date | PBR_DATA | CHAR | 16 | ||
FIRING_DATE | Dismissal date | PBR_DATD | CHAR | 16 | ||
GENDER | Gender Key | GESCH | CHAR | 2 | ||
SCHOOL_GRADE | Education level | PBR_FASAR | CHAR | 4 | ||
BIRTH_DATE | Birth date | PBR_DATNA | CHAR | 16 | ||
WORKED_HOURS | Working hours | HRPADBR_UNIN_WORKED_HOURS | NUMC | 4 | ||
ANTEPEN_SALARY | Third-last salary | HRPADBR_UNIN_ANTEPEN_SALARY | NUMC | 20 | ||
PENULT_SALARY | Penultimate salary | HRPADBR_UNIN_PENULT_SALARY | NUMC | 20 | ||
LAST_SALARY | Last salary | HRPADBR_UNIN_LAST_SALARY | NUMC | 20 | ||
WORKED_MONTHS | Number of worked months | HRPADBR_UNIN_WORKED_MONTHS | NUMC | 4 | ||
LAST_6_SALARIES | Receipt of the last 6 salaries | HRPADBR_UNIN_LAST_6_SAL | NUMC | 2 | ||
PAID_NOTICE | Tipe of notice period | PBR_PREA1 | CHAR | 2 | ||
BANK_CODE | Bank code | HRPADBR_UNIN_BANK_CODE | NUMC | 6 | ||
BANK_AGENCY | Branch bank code | HRPADBR_UNIN_BANK_AGENCY | NUMC | 8 | ||
VC_AGENCY | Bank branch check digit | HRPADBR_UNIN_BANK_VC | NUMC | 2 | ||
CTPS_NUM | WCSW number | HRPADBR_CTPS_NUMBER | CHAR | 16 | ||
CTPS_SER | WCSW series | HRPADBR_CTPS_SERIE | CHAR | 10 |