Tabela |
C9V |
Dados do Trabalhador |
Campo |
Tipo |
Tamanho |
Decimal |
Titulo |
Formato |
Validacao |
F3 |
Contexto |
Lista |
Condicao |
PYME |
C9V_FILIAL |
C |
2 |
0 |
Filial |
|
|
|
R |
|
|
S |
C9V_ID |
C |
6 |
0 |
ID |
@! |
|
|
R |
|
|
S |
C9V_VERSAO |
C |
14 |
0 |
Id. Ver. Reg |
@! |
|
|
R |
|
|
S |
C9V_CPF |
C |
11 |
0 |
CPF |
@R 999.999.999-99 |
xFunVldPJF(,1,.F.) .And. XFUNVld(12) |
|
R |
|
INCLUI |
S |
C9V_NOME |
C |
70 |
0 |
Nome |
@! |
|
|
R |
|
|
S |
C9V_SEXO |
C |
1 |
0 |
Sexo |
@! |
Pertence(" MF") |
|
R |
M=Masculino;F=Feminino |
|
S |
C9V_RCCOR |
C |
1 |
0 |
Raca/Cor |
@! |
Pertence(" 123456") |
|
R |
1=Branca;2=Negra;3=Parda;4=Amarela;5=Indigena;6=Nao Informado |
|
S |
C9V_ESTCIV |
C |
1 |
0 |
Estado Civil |
@! |
Pertence(" 12345") |
|
R |
1=Solteiro;2=Casado;3=Divorciado;4=Separado;5=Viuvo |
|
S |
C9V_GRINST |
C |
6 |
0 |
Id Grau Inst |
@! |
xFunVldCmp("CMH",,,,2,.T.) |
CMH |
R |
|
|
S |
C9V_DGRINS |
C |
220 |
0 |
Des Grau Ins |
@! |
|
|
V |
|
|
S |
C9V_DTNASC |
D |
8 |
0 |
Dt. Nasc. |
|
|
|
R |
|
|
S |
C9V_CODPAI |
C |
6 |
0 |
Id Pais Nasc |
@! |
xFunVldCmp("C08",3) |
C08 |
R |
|
|
S |
C9V_DCODPA |
C |
220 |
0 |
Des Pais Nas |
@! |
|
|
V |
|
|
S |
C9V_CODUF |
C |
6 |
0 |
Id. UF Nasc. |
@! |
xFunVldCmp("C09",3) |
C09 |
R |
|
|
S |
C9V_DCODUF |
C |
220 |
0 |
Descr UF Nas |
@! |
|
|
V |
|
|
S |
C9V_CODMUN |
C |
6 |
0 |
Id. Mun. Nas |
@! |
xFunVldCmp("C07",3) |
C07 |
R |
|
|
S |
C9V_DCODMU |
C |
220 |
0 |
Des Mun Nasc |
@! |
|
|
V |
|
|
S |
C9V_PAINAC |
C |
6 |
0 |
Id. Pais Nac |
@! |
xFunVldCmp("C08",3) |
C08 |
R |
|
|
S |
C9V_DPAINA |
C |
220 |
0 |
Des Pais Nac |
@! |
|
|
V |
|
|
S |
C9V_NOMMAE |
C |
70 |
0 |
Nome Mae |
@! |
|
|
R |
|
|
S |
C9V_NOMPAI |
C |
70 |
0 |
Nome Pai |
@! |
|
|
R |
|
|
S |
C9V_NIS |
C |
11 |
0 |
NIS |
@! |
|
|
R |
|
|
S |
C9V_NRCTPS |
C |
11 |
0 |
Num. CTPS |
@! |
|
|
R |
|
|
S |
C9V_SERCTP |
C |
5 |
0 |
Serie CTPS |
@! |
|
|
R |
|
|
S |
C9V_UFCTPS |
C |
6 |
0 |
Id. UF CTPS |
@! |
xFunVldCmp("C09",3) |
C09 |
R |
|
|
S |
C9V_DUFCTP |
C |
220 |
0 |
Desc UF CTPS |
@! |
|
|
V |
|
|
S |
C9V_NRRIC |
C |
14 |
0 |
Num. RIC |
@! |
|
|
R |
|
|
S |
C9V_OREMRI |
C |
20 |
0 |
Org Emis RIC |
@! |
|
|
R |
|
|
S |
C9V_DTEXRI |
D |
8 |
0 |
Dt. Exp. RIC |
|
|
|
R |
|
|
S |
C9V_NRRG |
C |
14 |
0 |
Num. RG |
@! |
|
|
R |
|
|
S |
C9V_OREMRG |
C |
20 |
0 |
Org Emis RG |
@! |
|
|
R |
|
|
S |
C9V_DTEMRG |
D |
8 |
0 |
Dt. Exp. RG |
|
|
|
R |
|
|
S |
C9V_NRRNE |
C |
14 |
0 |
Num. RNE |
@! |
|
|
R |
|
|
S |
C9V_OREMRN |
C |
20 |
0 |
Org Emis RNE |
@! |
|
|
R |
|
|
S |
C9V_DTEMRN |
D |
8 |
0 |
Dt. Exp. RNE |
|
|
|
R |
|
|
S |
C9V_NUMOC |
C |
14 |
0 |
Num. OC |
@! |
|
|
R |
|
|
S |
C9V_OREMOC |
C |
20 |
0 |
Org Emis OC |
@! |
|
|
R |
|
|
S |
C9V_DTEXOC |
D |
8 |
0 |
Dt. Exp. OC |
|
|
|
R |
|
|
S |
C9V_DTVLOC |
D |
8 |
0 |
Dt. Val. OC |
|
|
|
R |
|
|
S |
C9V_NRCNH |
C |
12 |
0 |
Num. CNH |
@! |
|
|
R |
|
|
S |
C9V_OREMCN |
C |
20 |
0 |
Org Emis CNH |
@! |
|
|
R |
|
|
S |
C9V_DTEXCN |
D |
8 |
0 |
Dt. Exp. CNH |
|
|
|
R |
|
|
S |
C9V_DTVLCN |
D |
8 |
0 |
Dt. Val. CNH |
|
|
|
R |
|
|
S |
C9V_PAIS |
C |
6 |
0 |
Id Pais End |
@! |
xFunVldCmp("C08",3) |
C08 |
R |
|
|
S |
C9V_DPAIS |
C |
220 |
0 |
Des Pais End |
@! |
|
|
V |
|
|
S |
C9V_UF |
C |
6 |
0 |
Id. UF End. |
@! |
xFunVldCmp("C09",3) |
C09 |
R |
|
|
S |
C9V_DUF |
C |
220 |
0 |
Descr UF End |
@! |
|
|
V |
|
|
S |
C9V_MUN |
C |
6 |
0 |
Id. Mun. End |
@! |
xFunVldCmp("C07",3) |
C07 |
R |
|
|
S |
C9V_DMUN |
C |
220 |
0 |
Des Mun End |
@! |
|
|
V |
|
|
S |
C9V_NOMCID |
C |
50 |
0 |
Nome Cid Ext |
@! |
|
|
R |
|
|
S |
C9V_TPLOGR |
C |
6 |
0 |
Id. Tp. Log. |
@! |
xFunVldCmp("C06",3) |
C06 |
R |
|
|
S |
C9V_DTPLOG |
C |
220 |
0 |
Des Tp Log |
@! |
|
|
V |
|
|
S |
C9V_LOGRAD |
C |
100 |
0 |
Descr. Logr. |
@! |
|
|
R |
|
|
S |
C9V_NRLOG |
C |
10 |
0 |
Numero Log. |
@! |
|
|
R |
|
|
S |
C9V_COMLOG |
C |
30 |
0 |
Comp. Log. |
@! |
|
|
R |
|
|
S |
C9V_BAIRRO |
C |
90 |
0 |
Bairro |
@! |
|
|
R |
|
|
S |
C9V_CEP |
C |
10 |
0 |
CEP |
@! |
|
|
R |
|
|
S |
C9V_DTCHEG |
D |
8 |
0 |
Dt. Chegada |
|
|
|
R |
|
|
S |
C9V_DTNATU |
D |
8 |
0 |
Dt. Natural. |
|
|
|
R |
|
|
S |
C9V_CASBRA |
C |
1 |
0 |
Cas. Brasil? |
@! |
Pertence(" 12") |
|
R |
1=Sim;2=Nao |
|
S |
C9V_FILBRA |
C |
1 |
0 |
Fil. Brasil? |
@! |
Pertence(" 12") |
|
R |
1=Sim;2=Nao |
|
S |
C9V_DEFFIS |
C |
1 |
0 |
Def.Fisica ? |
@! |
Pertence(" 12") |
|
R |
1=Sim;2=Nao |
|
S |
C9V_DEFVIS |
C |
1 |
0 |
Def. Visual? |
@! |
Pertence(" 12") |
|
R |
1=Sim;2=Nao |
|
S |
C9V_DEFAUD |
C |
1 |
0 |
Def. Audit? |
@! |
Pertence(" 12") |
|
R |
1=Sim;2=Nao |
|
S |
C9V_DEFMEN |
C |
1 |
0 |
Def. Mental? |
@! |
Pertence(" 12") |
|
R |
1=Sim;2=Nao |
|
S |
C9V_DEFINT |
C |
1 |
0 |
Def.Intelec? |
@! |
Pertence(" 12") |
|
R |
1=Sim;2=Nao |
|
S |
C9V_REABIL |
C |
1 |
0 |
Func. Reab? |
@! |
Pertence(" 12") |
|
R |
1=Sim;2=Nao |
|
S |
C9V_OBSDEF |
M |
255 |
0 |
Obs Info Def |
@! |
|
|
R |
|
|
S |
C9V_APOSEN |
C |
1 |
0 |
Aposentado? |
@! |
Pertence(" 12") |
|
R |
1=Sim;2=Nao |
|
S |
C9V_DDDFPR |
C |
3 |
0 |
DDD Fone Pri |
@R 999 |
|
|
R |
|
|
S |
C9V_FONPRC |
C |
10 |
0 |
Fone Princ. |
@R 9999999999 |
|
|
R |
|
|
S |
C9V_DDDFAL |
C |
3 |
0 |
DDD Fone Alt |
@R 999 |
|
|
R |
|
|
S |
C9V_FONALT |
C |
10 |
0 |
Fone Altern. |
@R 9999999999 |
|
|
R |
|
|
S |
C9V_EMAILP |
C |
60 |
0 |
Email Prin. |
@! |
|
|
R |
|
|
S |
C9V_EMAILA |
C |
60 |
0 |
Email Altern |
@! |
|
|
R |
|
|
S |
C9V_DTALT |
D |
8 |
0 |
Dt. Alterac. |
|
XFUNVldUni("C9V",5,FWFLDGET("C9V_CPF")+DTOS(M->C9V_DTALT)) |
|
R |
|
|
S |
C9V_NOMEVE |
C |
5 |
0 |
Nome Evento |
@! |
|
|
R |
|
|
S |
C9V_VERANT |
C |
14 |
0 |
Ver Ant Reg |
@! |
|
|
R |
|
|
S |
C9V_STATUS |
C |
1 |
0 |
Status Reg. |
@! |
Pertence(" 012349") |
|
R |
0=Reg.Valido;1=Reg.Invalido;2=Reg.Transmitido;3=Reg.Transmitido com inconsistencia;4=Reg.Transmitido valido;9=Em Processamento |
|
S |
C9V_PROTUL |
C |
44 |
0 |
Ult. Prot. |
@! |
|
|
R |
|
|
S |
C9V_PROTPN |
C |
44 |
0 |
Pnlt. Prot. |
@! |
|
|
R |
|
|
S |
C9V_EVENTO |
C |
1 |
0 |
Id. Evento |
@! |
Pertence("IAE") |
|
R |
I=Inclusao;A=Alteracao;E=Exclusao |
|
S |
C9V_ATIVO |
C |
1 |
0 |
Reg. Ativo? |
@! |
Pertence("12") |
|
R |
1=Sim;2=Nao |
|
S |
C9V_UFCNH |
C |
6 |
0 |
UF CNH |
@! |
xFunVldCmp("C09",3) |
C09 |
R |
|
|
S |
C9V_DUFCN |
C |
220 |
0 |
Desc. UF CNH |
@! |
|
|
V |
|
|
S |
C9V_DTPCNH |
D |
8 |
0 |
Primeira CNH |
|
|
|
R |
|
|
S |
C9V_CATCNH |
C |
1 |
0 |
Categ. CNH |
@! |
Pertence(" 123456789") |
|
R |
1=A;2=B;3=C;4=D;5=E;6=AB;7=AC;8=AD;9=AE |
|
S |
C9V_CCTRAE |
C |
6 |
0 |
Cond. Trab. |
@! |
xFunVldCmp("T13",1) |
T13 |
R |
|
|
S |
C9V_DCONTE |
C |
220 |
0 |
Desc. Cond T |
@! |
|
|
V |
|
|
S |
C9V_DESEVE |
C |
1 |
0 |
Des. Evento |
@! |
Pertence("123") |
|
R |
1=S-2100 - Carga Inicial;2=S-2200 - Admissao Trabalhador;3=S-2300 - Trab. Sem Vinculo |
|
S |
C9V_MATRIC |
C |
30 |
0 |
Matricula |
@! |
XFUNVld(12) |
|
R |
|
|
S |
C9V_PRIEMP |
C |
1 |
0 |
Pri.Emp.Trab |
@! |
Pertence(" 12") |
|
R |
1=Sim;2=Nao |
|
S |
C9V_NOMSOC |
C |
70 |
0 |
Nome Social |
@! |
|
|
R |
|
|
S |
C9V_INFCOT |
C |
1 |
0 |
Cota Defici. |
@! |
Pertence(" 12") |
|
R |
1=Sim;2=Nao |
|
S |
C9V_CATCI |
C |
6 |
0 |
Id. Categ. |
@! |
xFunVldCmp("C87",,,,2,.F.) |
C87 |
R |
|
|
S |
C9V_CADINI |
C |
1 |
0 |
Cad. Inicial |
@! |
Pertence(" 12") |
|
R |
1=Sim (Cadastramento Inicial);2=Nao (Admissao) |
|
S |
C9V_DCATCI |
C |
220 |
0 |
Descr. Categ |
@! |
|
|
V |
|
|
S |
C9V_XMLID |
C |
36 |
0 |
Id do XML. |
|
|
|
R |
|
|
S |
C9V_IDTRAN |
C |
220 |
0 |
Id Transf |
@! |
|
|
R |
|
|
S |
C9V_DTINIV |
D |
8 |
0 |
Dt. Ini Vinc |
|
|
|
R |
|
|
S |
C9V_STASEC |
C |
1 |
0 |
Status Secun |
|
|
|
R |
|
|
S |
C9V_DINSIS |
D |
8 |
0 |
Dt Inc. Sist |
|
|
|
R |
|
|
S |
C9V_LOGOPE |
C |
1 |
0 |
Log Operacao |
@! |
|
|
R |
1=Incl.Integr;2=Incl.Manual;3=Incl.Integr+Alt.Integr;4=Incl.Integr+Alt.Manual;5=Incl.Manual+Alt.Integr;6=Incl.Manual+Alt.Manual |
|
S |
C9V_DTTRAN |
D |
8 |
0 |
Dt.Transf. |
|
|
|
R |
|
|
S |