/TMF/HD_NTRAB - eSocial - Vinculo de trabalho

eSocial - Vinculo de trabalho information is stored in SAP table /TMF/HD_NTRAB.
It is part of development package /TMF/ESO_EN in software component FIN-TMF. This development package consists of objects that can be grouped under "Tax Management Framework Brazil: eSocial EN objects".

Fields for table /TMF/HD_NTRAB

Field Name
Description
Is Key
Data Element
Data Type
Length
Check Table
.INCLUDEX/TMF/MS_APP_KEY_FIELDS0
MANDTClientXMANDTCLNT6T000
ID_EVENTOEvent IDX/TMF/M_ID_EVENTOCHAR72
RECORD_IDRecord IDX/TMF/M_RECORD_IDCHAR8
NM_TRABNome do Trabalhador/TMF/H_NM_TRABCHAR140
SEXOSexo/TMF/H_SEXOCHAR2
RACA_CORRa�a e Cor do Trabalhador/TMF/H_RACA_CORCHAR2
EST_CIVMarital status/TMF/H_EST_CIVCHAR2
GRAU_INSTREducation degree/TMF/H_GRAU_INSTRCHAR4
NM_SOCSocial name for transsexual person/TMF/H_NM_SOCCHAR140
IND_PRI_EMPRIndicador de Primeiro Emprego/TMF/H_IND_PRI_EMPRCHAR2
DT_NASCTODate of birth/TMF/H_DT_NASCTODATS16
COD_MUNIC_NASCTOCode of the birth municipality/TMF/H_COD_MUNIC_NASCTOCHAR14
UF_NASCTOUF do Nascimento/TMF/H_UF_NASCTOCHAR4
PAIS_NASCTOPa�s de Nascimento/TMF/H_PAIS_NASCTOCHAR6
PAIS_NACPa�s de Nacionalidade/TMF/H_PAIS_NACCHAR6
NM_MAENome da M�e/TMF/H_NM_MAECHAR140
NM_PAINome do Pai/TMF/H_NM_PAICHAR140
NR_CTPSCTPS: No.carteira de trabalho e Previd�ncia Social trabalho/TMF/H_NR_CTPSCHAR22
SERIE_CTPSCTPS: Serie/TMF/H_SERIE_CTPSCHAR10
UF_CTPSCTPS: Estado/TMF/H_UF_CTPSCHAR4
NR_RICRIC: N�mero do Documento Nacional de Identidade - DNI./TMF/H_NR_RICCHAR28
ORGAO_EMISSOR_RICRIC: �rg�o e UF de emiss�o/TMF/H_ORGAO_EMISSOR_RICCHAR40
DT_EXPED_RICRIC: dispatch date/TMF/H_DT_EXPED_RICDATS16
NR_RGRG: N�mero do RG/TMF/H_NR_RGCHAR28
ORGAO_EMISSOR_RGRG: �rg�o e UF de emiss�o/TMF/H_ORGAO_EMISSOR_RGCHAR40
DT_EXPED_RGRG: dispatch date/TMF/H_DT_EXPED_RGDATS16
NR_RNERNE: N�mero no Registro Nacional de Estrangeiros/TMF/H_NR_RNECHAR28
ORGAO_EMISSOR_RNERNE: �rg�o e UF de emiss�o/TMF/H_ORGAO_EMISSOR_RNECHAR40
DT_EXPED_RNERNE: dispatch date/TMF/H_DT_EXPED_RNEDATS16
NR_OCOC: N�mero de Inscr. na Organiza��o de Classe/TMF/H_NR_OCCHAR28
ORGAO_EMISSOR_OCOC: �rg�o e UF de emiss�o/TMF/H_ORGAO_EMISSOR_OCCHAR40
DT_EXPED_OCOC: dispatch date/TMF/H_DT_EXPED_OCDATS16
DT_VALID_OCOC: validity date/TMF/H_DT_VALID_OCDATS16
NR_REG_CNHCNH: N�mero da Carteira Nacional de Habilita��o/TMF/H_NR_REG_CNHCHAR24
DT_EXPED_CNHCNH: dispatch date/TMF/H_DT_EXPED_CNHDATS16
UF_CNHCNH: Estado/TMF/H_UF_CNHCHAR4
DT_VALID_CNHCNH: validity date/TMF/H_DT_VALID_CNHDATS16
DT_PRI_HABCNH: first license date/TMF/H_DT_PRI_HABDATS16
CATEGORIA_CNHCNH category/TMF/H_CATEGORIA_CNHCHAR4
.INCLUDE/TMF/HS_ADDRESS_STRUCT0
TP_LOGRADTipo de Logradouro/TMF/H_TP_LOGRADCHAR8
DSC_LOGRADAddress description/TMF/H_DSC_LOGRADCHAR160
NR_LOGRADN�mero do logradouro/TMF/H_NR_LOGRADCHAR20
COMPLEMENTOAddress complement/TMF/H_COMPLEMENTOCHAR60
BAIRRODistrict/TMF/H_BAIRROCHAR120
CEPPostal code/TMF/H_CEPCHAR16
COD_MUNICCode of the federative entities municipality/TMF/H_COD_MUNICCHAR14
UFEstado/TMF/H_UFCHAR4
.INCLUDE/TMF/HS_ADDRESS_FOREIGN_STRUCT0
PAIS_RESIDC�digo do pa�s de resid�ncia/TMF/H_PAIS_RESIDCHAR6
NM_CIDNome da Cidade/TMF/H_NM_CIDCHAR100
COD_POSTALPostal code/TMF/H_COD_POSTALCHAR24
DT_CHEGADAArrival date/TMF/H_DT_CHEGADADATS16
CLASS_TRAB_ESTRANGClassification of foreign employee condition in Brazil/TMF/H_CLASS_TRAB_ESTRANGCHAR4
CASADO_BRBrazilian spouse/TMF/H_CASADO_BRCHAR2
FILHOS_BRBrazilian children/TMF/H_FILHOS_BRCHAR2
DEF_FISICAPhysical disability indicator/TMF/H_DEF_FISICACHAR2
DEF_VISUALVisual disability indicator/TMF/H_DEF_VISUALCHAR2
DEF_AUDITIVAAuditory disability indicator/TMF/H_DEF_AUDITIVACHAR2
DEF_MENTALMental disability indicator/TMF/H_DEF_MENTALCHAR2
DEF_INTELECTUALIntellectual disability indicator/TMF/H_DEF_INTELECTUALCHAR2
REAB_READAPIndicador de Reabilita��o/TMF/H_REAB_READAPCHAR2
INFO_COTAQuota for licensed disabled people or beneficiaries/TMF/H_INFO_COTACHAR2
OBS_DEFICIENCIAObserva��o sobre Defici�ncia/TMF/H_OBS_DEFICIENCIACHAR510
TRAB_APOSENTIndicador de Aposentadoria do Trabalhador/TMF/H_TRAB_APOSENTCHAR2
FONE_PRINCTelephone number/TMF/H_FONE_PRINCCHAR26
FONE_ALTERNATAlternative telephone number/TMF/H_FONE_ALTERNATCHAR26
EMAIL_PRINCEmail/TMF/H_EMAIL_PRINCCHAR120
EMAIL_ALTERNATEmail (alternative)/TMF/H_EMAIL_ALTERNATCHAR120
MATRICULA[OBSOLETE] Matr�cula do trabalhadorCHAR60
TP_REG_TRABTipo de Regime Trabalhista/TMF/H_TP_REG_TRABCHAR2
TP_REG_PREVTipo de Regime Previdenci�rio/TMF/H_TP_REG_PREVCHAR2
NR_REC_INF_PRELIMN�mero do recibo Admiss�o/TMF/H_NR_REC_INF_PRELIMCHAR80
DT_ADMAdmission date/TMF/H_DT_ADMISSAODATS16
TP_ADMISSAOTipo de Admiss�o/TMF/H_TP_ADMISSAOCHAR2
IND_ADMISSAOAdmission indicative/TMF/H_IND_ADMISSAOCHAR2
TP_REG_JORIdentifica o regime de jornada do empregado/TMF/H_TP_REG_JORCHAR2
NAT_ATIVIDADENatureza da atividade/TMF/H_NAT_ATIVIDADECHAR2
DT_BASEBase date/TMF/H_DT_BASECHAR4
CNPJ_SIND_CATEG_PROFCNPJ of the representative union of the category/TMF/H_CNPJ_SIND_CATEG_PROFCHAR28
OPC_FGTSOp��o pelo FGTS/TMF/H_OPC_FGTSCHAR2
DT_OPC_FGTSOption date by FGTS/TMF/H_DT_OPC_FGTSDATS16
MTV_CONTRAT[OBSOLETE] Motivo da Contrata��o do trabalhador tempor�rioCHAR2
HIP_LEGLegal hypothesis for hiring temporary employee/TMF/H_HIP_LOG_TEMPCHAR2
JUST_CONTRLegal hypothesis for hiring temporary employee description/TMF/H_JUST_CONTR_TEMPCHAR1998
TP_INCL_CONTRInclusion contract type/TMF/H_TP_INCL_CONTR_TEMPCHAR2
TP_INSC_TOMADORTipo Inscri��o do tomador de servi�os tempor�rio/TMF/H_TP_INSC_TOMADORCHAR2
NR_INSC_TOMADORN�mero Inscri��o do Tomador de Servi�o tempor�rio/TMF/H_NR_INSC_TOMADORCHAR30
TP_INSC_ESTAB_VINCRegistration type of contractor services/TMF/H_TP_INSC_EST_VINCCHAR2
NR_INSC_ESTAB_VINCRegistration number of contractor services/TMF/H_NR_INSC_EST_VINCCHAR30
TP_INSC_APRENRegistration type of apprendice employer/TMF/H_TP_INSC_APRENCHAR2
NR_INSC_APRENRegistration number of apprendice employer/TMF/H_NR_INSC_APRENCHAR30
CPF_TRAB_SUBST[OBSOLETE] CPF do trabalhador substitu�doCHAR22
MATRIC_TRAB_SUBST[OBSOLETE] Matr�cula do Trabalhador Substitu�doCHAR60
IND_PROVIMIndicador de Provimento/TMF/H_IND_PROVIMCHAR2
TP_PROVTipo de Provimento/TMF/H_TP_PROVCHAR4
DT_NOMEACAONomination date/TMF/H_DT_NOMEACAODATS16
DT_POSSEPossession date/TMF/H_DT_POSSEDATS16
DT_EXERCICIOEntry activity date by server/TMF/H_DT_EXERCICIODATS16
TP_PLAN_RPPlan type of separation of mass of people/TMF/H_TP_PLAN_RPCHAR2
NR_PROC_JUD_ESTN�mero do processo judicial/TMF/H_NR_PROC_JUDCHAR42
COD_CARGOJob code/TMF/H_COD_CARGOCHAR60
COD_FUNCAORole code/TMF/H_COD_FUNCAOCHAR60
COD_CATEGCategory code/TMF/H_COD_CATEGCHAR6
COD_CARREIRACarreer code/TMF/H_COD_CARREIRACHAR60
DT_INGR_CARRDate of carreer admission/TMF/H_DT_INGR_CARRDATS16
VR_SAL_FXSal�rio base do trabalhador, correspondente � parte fixa/TMF/H_VR_SAL_FXDEC8
UND_SAL_FIXOUnidade de pagamento da parte fixa da remunera��o/TMF/H_UND_SAL_FIXOCHAR2
DSC_SAL_VARVariable salary description/TMF/H_DSC_SAL_VARCHAR510
TP_CONTRTipo de Contrato de Trabalho/TMF/H_TP_CONTRCHAR2
DT_TERMEnd date of the employment contract/TMF/H_DT_TERMDATS16
TP_INSC_TRABTipo de inscri��o (Local de Trabalho)/TMF/H_TP_INSC_TRABCHAR2
NR_INSC_TRABN�mero de Inscri��o do Local de Trabalho/TMF/H_NR_INSC_TRABCHAR30
DESC_COMPWorkplace complementary description/TMF/H_DESC_COMPCHAR160
TP_LOGRAD_TRABTipo de Logradouro (Local de Trabalho)/TMF/H_TP_LOGRAD_TRABCHAR8
DSC_LOGRAD_TRABAddress (Workplace)/TMF/H_DSC_LOGRAD_TRABCHAR160
NR_LOGRAD_TRABN�mero do logradouro (Local de Trabalho)/TMF/H_NR_LOGRAD_TRABCHAR20
COMPLEMENTO_TRABAddress complement (workplace)/TMF/H_COMPLEMENTO_TRABCHAR60
BAIRRO_TRABDistrict (Workplace)/TMF/H_BAIRRO_TRABCHAR120
CEP_TRABPost code (Workplace)/TMF/H_CEP_TRABCHAR16
COD_MUNIC_TRABCode of the Federative Entities Municipality (Workplace)/TMF/H_COD_MUNIC_TRABCHAR14
UF_TRABEstado (Local de Trabalho)/TMF/H_UF_TRABCHAR4
QTD_HRS_SEMQuantidade m�dia de horas relativas � jornada semanal do/TMF/H_QTD_HRS_SEMDEC3
TP_JORNADATipo da Jornada/TMF/H_TP_JORNADACHAR2
DSC_TP_JORNJourney type description/TMF/H_DSC_TP_JORNCHAR200
TMP_PARCHalf-time employment contract/TMF/H_TMP_PARCCHAR2
CNPJ_SIND_TRAB[OBSOLETE] CNPJ do Sindicado do trabalhadorCHAR28
NR_PROC_JUDN�mero do processo judicial/TMF/H_NR_PROC_JUDCHAR42
CNPJ_EMPREG_ANTPrevious employer CPF/CNPJ/TMF/H_CNPJ_EMPREGADOR_ANTERIOCHAR28
MATRIC_ANTMatricula do trabalhador no emprego anterior/TMF/H_MATRIC_ANTCHAR60
DT_INI_VINCULOEmployment relationship start date (previous employment)/TMF/H_DT_INI_VINCULODATS16
OBS_SUCESSAO_VINCObserva��o V�nculo empresa anterior/TMF/H_OBS_SUCESSAO_VINCCHAR510
DT_ALTERACAOChange date/TMF/H_DT_ALTERACAODATS16
DT_ASO_ADM[OBSOLETE] Data do Atestado de Sa�de Ocupacional (Admiss�o)DATS16
NR_CRM[OBSOLETE] CRM do M�dicoCHAR16
UF_CRM[OBSOLETE] UF do CRM do M�dicoCHAR4
DT_INI_AFASTAbsence start date/TMF/H_DT_INI_AFASTDATS16
DT_DESLIGMove-out date/TMF/H_DT_DESLIGDATS16
COD_MOT_AFASTTemporary leave reason code/TMF/H_COD_MOT_AFASTCHAR4
DT_EFEffective date of law/TMF/H_DT_EFDATS16
DSC_ALTChange description/TMF/H_DSC_ALTCHAR300
MTV_ALTERReason for changing position or function/TMF/H_MTV_ALTERCHAR2
JUST_PRORRJustification extension of the temporary contract/TMF/H_JUST_PRORRSTRG8
CAD_INIEvent refers to initial registration or admission/TMF/H_CAD_INICHAR2
CLAU_ASSEGInsurance clause/TMF/H_CLAU_ASSEGCHAR2
TP_INSC_APREND[OBSOLETE] Registration type of Employer of ApprenticeCHAR2
NR_INSC_APREND[OBSOLETE] Registration number of Employer of ApprenticeCHAR30
DT_TRANSFDate of transfer/TMF/H_DT_TRANSFDATS16
CPF_SUBSTITUIDO_TDCPF Replaced/TMF/H_CPF_SUBSTITUIDOCHAR22
MATRIC_ANT_TDTD: Worker's Enrollment on previous employment/TMF/H_MATRIC_ANT_TDCHAR60
DT_TRANSF_TDTD: Date of transfer Domestic/TMF/H_DT_TRANSF_TDDATS16
Privacy Policy