/TMF/HDSNTRAB - eSocial - Vinculo de trabalho - Staging
eSocial - Vinculo de trabalho - Staging information is stored in SAP table /TMF/HDSNTRAB.
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".
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/HDSNTRAB
Field Name | Description | Is Key | Data Element | Data Type | Length | Check Table |
|---|---|---|---|---|---|---|
| .INCLUDE | X | /TMF/MS_APP_KEY_FIELDS | 0 | |||
| MANDT | Client | X | MANDT | CLNT | 6 | T000 |
| ID_EVENTO | Event ID | X | /TMF/M_ID_EVENTO | CHAR | 72 | |
| RECORD_ID | Record ID | X | /TMF/M_RECORD_ID | CHAR | 8 | |
| NM_TRAB | Nome do Trabalhador | /TMF/H_NM_TRAB | CHAR | 140 | ||
| SEXO | Sexo | /TMF/H_SEXO | CHAR | 2 | ||
| RACA_COR | Ra�a e Cor do Trabalhador | /TMF/H_RACA_COR | CHAR | 2 | ||
| EST_CIV | Marital status | /TMF/H_EST_CIV | CHAR | 2 | ||
| GRAU_INSTR | Education degree | /TMF/H_GRAU_INSTR | CHAR | 4 | ||
| NM_SOC | Social name for transsexual person | /TMF/H_NM_SOC | CHAR | 140 | ||
| IND_PRI_EMPR | Indicador de Primeiro Emprego | /TMF/H_IND_PRI_EMPR | CHAR | 2 | ||
| DT_NASCTO | Date of birth | /TMF/H_DT_NASCTO | DATS | 16 | ||
| COD_MUNIC_NASCTO | Code of the birth municipality | /TMF/H_COD_MUNIC_NASCTO | CHAR | 14 | ||
| UF_NASCTO | UF do Nascimento | /TMF/H_UF_NASCTO | CHAR | 4 | ||
| PAIS_NASCTO | Pa�s de Nascimento | /TMF/H_PAIS_NASCTO | CHAR | 6 | ||
| PAIS_NAC | Pa�s de Nacionalidade | /TMF/H_PAIS_NAC | CHAR | 6 | ||
| NM_MAE | Nome da M�e | /TMF/H_NM_MAE | CHAR | 140 | ||
| NM_PAI | Nome do Pai | /TMF/H_NM_PAI | CHAR | 140 | ||
| NR_CTPS | CTPS: No.carteira de trabalho e Previd�ncia Social trabalho | /TMF/H_NR_CTPS | CHAR | 22 | ||
| SERIE_CTPS | CTPS: Serie | /TMF/H_SERIE_CTPS | CHAR | 10 | ||
| UF_CTPS | CTPS: Estado | /TMF/H_UF_CTPS | CHAR | 4 | ||
| NR_RIC | RIC: N�mero do Documento Nacional de Identidade - DNI. | /TMF/H_NR_RIC | CHAR | 28 | ||
| ORGAO_EMISSOR_RIC | RIC: �rg�o e UF de emiss�o | /TMF/H_ORGAO_EMISSOR_RIC | CHAR | 40 | ||
| DT_EXPED_RIC | RIC: dispatch date | /TMF/H_DT_EXPED_RIC | DATS | 16 | ||
| NR_RG | RG: N�mero do RG | /TMF/H_NR_RG | CHAR | 28 | ||
| ORGAO_EMISSOR_RG | RG: �rg�o e UF de emiss�o | /TMF/H_ORGAO_EMISSOR_RG | CHAR | 40 | ||
| DT_EXPED_RG | RG: dispatch date | /TMF/H_DT_EXPED_RG | DATS | 16 | ||
| NR_RNE | RNE: N�mero no Registro Nacional de Estrangeiros | /TMF/H_NR_RNE | CHAR | 28 | ||
| ORGAO_EMISSOR_RNE | RNE: �rg�o e UF de emiss�o | /TMF/H_ORGAO_EMISSOR_RNE | CHAR | 40 | ||
| DT_EXPED_RNE | RNE: dispatch date | /TMF/H_DT_EXPED_RNE | DATS | 16 | ||
| NR_OC | OC: N�mero de Inscr. na Organiza��o de Classe | /TMF/H_NR_OC | CHAR | 28 | ||
| ORGAO_EMISSOR_OC | OC: �rg�o e UF de emiss�o | /TMF/H_ORGAO_EMISSOR_OC | CHAR | 40 | ||
| DT_EXPED_OC | OC: dispatch date | /TMF/H_DT_EXPED_OC | DATS | 16 | ||
| DT_VALID_OC | OC: validity date | /TMF/H_DT_VALID_OC | DATS | 16 | ||
| NR_REG_CNH | CNH: N�mero da Carteira Nacional de Habilita��o | /TMF/H_NR_REG_CNH | CHAR | 24 | ||
| DT_EXPED_CNH | CNH: dispatch date | /TMF/H_DT_EXPED_CNH | DATS | 16 | ||
| UF_CNH | CNH: Estado | /TMF/H_UF_CNH | CHAR | 4 | ||
| DT_VALID_CNH | CNH: validity date | /TMF/H_DT_VALID_CNH | DATS | 16 | ||
| DT_PRI_HAB | CNH: first license date | /TMF/H_DT_PRI_HAB | DATS | 16 | ||
| CATEGORIA_CNH | CNH category | /TMF/H_CATEGORIA_CNH | CHAR | 4 | ||
| .INCLUDE | /TMF/HS_ADDRESS_STRUCT | 0 | ||||
| TP_LOGRAD | Tipo de Logradouro | /TMF/H_TP_LOGRAD | CHAR | 8 | ||
| DSC_LOGRAD | Address description | /TMF/H_DSC_LOGRAD | CHAR | 160 | ||
| NR_LOGRAD | N�mero do logradouro | /TMF/H_NR_LOGRAD | CHAR | 20 | ||
| COMPLEMENTO | Address complement | /TMF/H_COMPLEMENTO | CHAR | 60 | ||
| BAIRRO | District | /TMF/H_BAIRRO | CHAR | 120 | ||
| CEP | Postal code | /TMF/H_CEP | CHAR | 16 | ||
| COD_MUNIC | Code of the federative entities municipality | /TMF/H_COD_MUNIC | CHAR | 14 | ||
| UF | Estado | /TMF/H_UF | CHAR | 4 | ||
| .INCLUDE | /TMF/HS_ADDRESS_FOREIGN_STRUCT | 0 | ||||
| PAIS_RESID | C�digo do pa�s de resid�ncia | /TMF/H_PAIS_RESID | CHAR | 6 | ||
| NM_CID | Nome da Cidade | /TMF/H_NM_CID | CHAR | 100 | ||
| COD_POSTAL | Postal code | /TMF/H_COD_POSTAL | CHAR | 24 | ||
| DT_CHEGADA | Arrival date | /TMF/H_DT_CHEGADA | DATS | 16 | ||
| CLASS_TRAB_ESTRANG | Classification of foreign employee condition in Brazil | /TMF/H_CLASS_TRAB_ESTRANG | CHAR | 4 | ||
| CASADO_BR | Brazilian spouse | /TMF/H_CASADO_BR | CHAR | 2 | ||
| FILHOS_BR | Brazilian children | /TMF/H_FILHOS_BR | CHAR | 2 | ||
| DEF_FISICA | Physical disability indicator | /TMF/H_DEF_FISICA | CHAR | 2 | ||
| DEF_VISUAL | Visual disability indicator | /TMF/H_DEF_VISUAL | CHAR | 2 | ||
| DEF_AUDITIVA | Auditory disability indicator | /TMF/H_DEF_AUDITIVA | CHAR | 2 | ||
| DEF_MENTAL | Mental disability indicator | /TMF/H_DEF_MENTAL | CHAR | 2 | ||
| DEF_INTELECTUAL | Intellectual disability indicator | /TMF/H_DEF_INTELECTUAL | CHAR | 2 | ||
| REAB_READAP | Indicador de Reabilita��o | /TMF/H_REAB_READAP | CHAR | 2 | ||
| INFO_COTA | Quota for licensed disabled people or beneficiaries | /TMF/H_INFO_COTA | CHAR | 2 | ||
| OBS_DEFICIENCIA | Observa��o sobre Defici�ncia | /TMF/H_OBS_DEFICIENCIA | CHAR | 510 | ||
| TRAB_APOSENT | Indicador de Aposentadoria do Trabalhador | /TMF/H_TRAB_APOSENT | CHAR | 2 | ||
| FONE_PRINC | Telephone number | /TMF/H_FONE_PRINC | CHAR | 26 | ||
| FONE_ALTERNAT | Alternative telephone number | /TMF/H_FONE_ALTERNAT | CHAR | 26 | ||
| EMAIL_PRINC | /TMF/H_EMAIL_PRINC | CHAR | 120 | |||
| EMAIL_ALTERNAT | Email (alternative) | /TMF/H_EMAIL_ALTERNAT | CHAR | 120 | ||
| MATRICULA | [OBSOLETE] Matr�cula do trabalhador | CHAR | 60 | |||
| TP_REG_TRAB | Tipo de Regime Trabalhista | /TMF/H_TP_REG_TRAB | CHAR | 2 | ||
| TP_REG_PREV | Tipo de Regime Previdenci�rio | /TMF/H_TP_REG_PREV | CHAR | 2 | ||
| NR_REC_INF_PRELIM | N�mero do recibo Admiss�o | /TMF/H_NR_REC_INF_PRELIM | CHAR | 80 | ||
| DT_ADM | Admission date | /TMF/H_DT_ADMISSAO | DATS | 16 | ||
| TP_ADMISSAO | Tipo de Admiss�o | /TMF/H_TP_ADMISSAO | CHAR | 2 | ||
| IND_ADMISSAO | Admission indicative | /TMF/H_IND_ADMISSAO | CHAR | 2 | ||
| TP_REG_JOR | Identifica o regime de jornada do empregado | /TMF/H_TP_REG_JOR | CHAR | 2 | ||
| NAT_ATIVIDADE | Natureza da atividade | /TMF/H_NAT_ATIVIDADE | CHAR | 2 | ||
| DT_BASE | Base date | /TMF/H_DT_BASE | CHAR | 4 | ||
| CNPJ_SIND_CATEG_PROF | CNPJ of the representative union of the category | /TMF/H_CNPJ_SIND_CATEG_PROF | CHAR | 28 | ||
| OPC_FGTS | Op��o pelo FGTS | /TMF/H_OPC_FGTS | CHAR | 2 | ||
| DT_OPC_FGTS | Option date by FGTS | /TMF/H_DT_OPC_FGTS | DATS | 16 | ||
| MTV_CONTRAT | [OBSOLETE] Motivo da Contrata��o do trabalhador tempor�rio | CHAR | 2 | |||
| HIP_LEG | Legal hypothesis for hiring temporary employee | /TMF/H_HIP_LOG_TEMP | CHAR | 2 | ||
| JUST_CONTR | Legal hypothesis for hiring temporary employee description | /TMF/H_JUST_CONTR_TEMP | CHAR | 1998 | ||
| TP_INCL_CONTR | Inclusion contract type | /TMF/H_TP_INCL_CONTR_TEMP | CHAR | 2 | ||
| TP_INSC_TOMADOR | Tipo Inscri��o do tomador de servi�os tempor�rio | /TMF/H_TP_INSC_TOMADOR | CHAR | 2 | ||
| NR_INSC_TOMADOR | N�mero Inscri��o do Tomador de Servi�o tempor�rio | /TMF/H_NR_INSC_TOMADOR | CHAR | 30 | ||
| TP_INSC_ESTAB_VINC | Registration type of contractor services | /TMF/H_TP_INSC_EST_VINC | CHAR | 2 | ||
| NR_INSC_ESTAB_VINC | Registration number of contractor services | /TMF/H_NR_INSC_EST_VINC | CHAR | 30 | ||
| TP_INSC_APREN | Registration type of apprendice employer | /TMF/H_TP_INSC_APREN | CHAR | 2 | ||
| NR_INSC_APREN | Registration number of apprendice employer | /TMF/H_NR_INSC_APREN | CHAR | 30 | ||
| CPF_TRAB_SUBST | [OBSOLETE] CPF do trabalhador substitu�do | CHAR | 22 | |||
| MATRIC_TRAB_SUBST | [OBSOLETE] Matr�cula do Trabalhador Substitu�do | CHAR | 60 | |||
| IND_PROVIM | Indicador de Provimento | /TMF/H_IND_PROVIM | CHAR | 2 | ||
| TP_PROV | Tipo de Provimento | /TMF/H_TP_PROV | CHAR | 4 | ||
| DT_NOMEACAO | Nomination date | /TMF/H_DT_NOMEACAO | DATS | 16 | ||
| DT_POSSE | Possession date | /TMF/H_DT_POSSE | DATS | 16 | ||
| DT_EXERCICIO | Entry activity date by server | /TMF/H_DT_EXERCICIO | DATS | 16 | ||
| TP_PLAN_RP | Plan type of separation of mass of people | /TMF/H_TP_PLAN_RP | CHAR | 2 | ||
| NR_PROC_JUD_EST | N�mero do processo judicial | /TMF/H_NR_PROC_JUD | CHAR | 42 | ||
| COD_CARGO | Job code | /TMF/H_COD_CARGO | CHAR | 60 | ||
| COD_FUNCAO | Role code | /TMF/H_COD_FUNCAO | CHAR | 60 | ||
| COD_CATEG | Category code | /TMF/H_COD_CATEG | CHAR | 6 | ||
| COD_CARREIRA | Carreer code | /TMF/H_COD_CARREIRA | CHAR | 60 | ||
| DT_INGR_CARR | Date of carreer admission | /TMF/H_DT_INGR_CARR | DATS | 16 | ||
| VR_SAL_FX | Sal�rio base do trabalhador, correspondente � parte fixa | /TMF/H_VR_SAL_FX | DEC | 8 | ||
| UND_SAL_FIXO | Unidade de pagamento da parte fixa da remunera��o | /TMF/H_UND_SAL_FIXO | CHAR | 2 | ||
| DSC_SAL_VAR | Variable salary description | /TMF/H_DSC_SAL_VAR | CHAR | 510 | ||
| TP_CONTR | Tipo de Contrato de Trabalho | /TMF/H_TP_CONTR | CHAR | 2 | ||
| DT_TERM | End date of the employment contract | /TMF/H_DT_TERM | DATS | 16 | ||
| TP_INSC_TRAB | Tipo de inscri��o (Local de Trabalho) | /TMF/H_TP_INSC_TRAB | CHAR | 2 | ||
| NR_INSC_TRAB | N�mero de Inscri��o do Local de Trabalho | /TMF/H_NR_INSC_TRAB | CHAR | 30 | ||
| DESC_COMP | Workplace complementary description | /TMF/H_DESC_COMP | CHAR | 160 | ||
| TP_LOGRAD_TRAB | Tipo de Logradouro (Local de Trabalho) | /TMF/H_TP_LOGRAD_TRAB | CHAR | 8 | ||
| DSC_LOGRAD_TRAB | Address (Workplace) | /TMF/H_DSC_LOGRAD_TRAB | CHAR | 160 | ||
| NR_LOGRAD_TRAB | N�mero do logradouro (Local de Trabalho) | /TMF/H_NR_LOGRAD_TRAB | CHAR | 20 | ||
| COMPLEMENTO_TRAB | Address complement (workplace) | /TMF/H_COMPLEMENTO_TRAB | CHAR | 60 | ||
| BAIRRO_TRAB | District (Workplace) | /TMF/H_BAIRRO_TRAB | CHAR | 120 | ||
| CEP_TRAB | Post code (Workplace) | /TMF/H_CEP_TRAB | CHAR | 16 | ||
| COD_MUNIC_TRAB | Code of the Federative Entities Municipality (Workplace) | /TMF/H_COD_MUNIC_TRAB | CHAR | 14 | ||
| UF_TRAB | Estado (Local de Trabalho) | /TMF/H_UF_TRAB | CHAR | 4 | ||
| QTD_HRS_SEM | Quantidade m�dia de horas relativas � jornada semanal do | /TMF/H_QTD_HRS_SEM | DEC | 3 | ||
| TP_JORNADA | Tipo da Jornada | /TMF/H_TP_JORNADA | CHAR | 2 | ||
| DSC_TP_JORN | Journey type description | /TMF/H_DSC_TP_JORN | CHAR | 200 | ||
| TMP_PARC | Half-time employment contract | /TMF/H_TMP_PARC | CHAR | 2 | ||
| CNPJ_SIND_TRAB | [OBSOLETE] CNPJ do Sindicado do trabalhador | CHAR | 28 | |||
| NR_PROC_JUD | N�mero do processo judicial | /TMF/H_NR_PROC_JUD | CHAR | 42 | ||
| CNPJ_EMPREG_ANT | Previous employer CPF/CNPJ | /TMF/H_CNPJ_EMPREGADOR_ANTERIO | CHAR | 28 | ||
| MATRIC_ANT | Matricula do trabalhador no emprego anterior | /TMF/H_MATRIC_ANT | CHAR | 60 | ||
| DT_INI_VINCULO | Employment relationship start date (previous employment) | /TMF/H_DT_INI_VINCULO | DATS | 16 | ||
| OBS_SUCESSAO_VINC | Observa��o V�nculo empresa anterior | /TMF/H_OBS_SUCESSAO_VINC | CHAR | 510 | ||
| DT_ALTERACAO | Change date | /TMF/H_DT_ALTERACAO | DATS | 16 | ||
| DT_ASO_ADM | [OBSOLETE] Data do Atestado de Sa�de Ocupacional (Admiss�o) | DATS | 16 | |||
| NR_CRM | [OBSOLETE] CRM do M�dico | CHAR | 16 | |||
| UF_CRM | [OBSOLETE] UF do CRM do M�dico | CHAR | 4 | |||
| DT_INI_AFAST | Absence start date | /TMF/H_DT_INI_AFAST | DATS | 16 | ||
| DT_DESLIG | Move-out date | /TMF/H_DT_DESLIG | DATS | 16 | ||
| COD_MOT_AFAST | Temporary leave reason code | /TMF/H_COD_MOT_AFAST | CHAR | 4 | ||
| DT_EF | Effective date of law | /TMF/H_DT_EF | DATS | 16 | ||
| DSC_ALT | Change description | /TMF/H_DSC_ALT | CHAR | 300 | ||
| MTV_ALTER | Reason for changing position or function | /TMF/H_MTV_ALTER | CHAR | 2 | ||
| JUST_PRORR | Justification extension of the temporary contract | /TMF/H_JUST_PRORR | STRG | 8 | ||
| CAD_INI | Event refers to initial registration or admission | /TMF/H_CAD_INI | CHAR | 2 | ||
| CLAU_ASSEG | Insurance clause | /TMF/H_CLAU_ASSEG | CHAR | 2 | ||
| TP_INSC_APREND | [OBSOLETE] Registration type of Employer of Apprentice | CHAR | 2 | |||
| NR_INSC_APREND | [OBSOLETE] Registration number of Employer of Apprentice | CHAR | 30 | |||
| DT_TRANSF | Date of transfer | /TMF/H_DT_TRANSF | DATS | 16 | ||
| CPF_SUBSTITUIDO_TD | CPF Replaced | /TMF/H_CPF_SUBSTITUIDO | CHAR | 22 | ||
| MATRIC_ANT_TD | TD: Worker's Enrollment on previous employment | /TMF/H_MATRIC_ANT_TD | CHAR | 60 | ||
| DT_TRANSF_TD | TD: Date of transfer Domestic | /TMF/H_DT_TRANSF_TD | DATS | 16 |