Tabela |
C8B |
Atestado de Saude Ocupacional |
Campo |
Tipo |
Tamanho |
Decimal |
Titulo |
Formato |
Validacao |
F3 |
Contexto |
Lista |
Condicao |
PYME |
C8B_FILIAL |
C |
2 |
0 |
Filial |
|
|
|
R |
|
|
S |
C8B_ID |
C |
6 |
0 |
ID |
@! |
|
|
R |
|
|
S |
C8B_VERSAO |
C |
14 |
0 |
Id. Ver. Reg |
@! |
|
|
R |
|
|
S |
C8B_FUNC |
C |
6 |
0 |
Id.Func. |
@! |
XFUNVldCmp("C9V",,,,2,) .And. XFUNVldUni("C8B",2,M->C8B_FUNC+DTOS(M->C8B_DTASO)) |
C9V |
R |
|
|
S |
C8B_DFUNC |
C |
220 |
0 |
Des.Func. |
@! |
|
|
V |
|
|
S |
C8B_DTASO |
D |
8 |
0 |
Dt.Aso |
|
XFUNVldUni("C8B",2,M->C8B_FUNC+DTOS(M->C8B_DTASO)) |
|
R |
|
|
S |
C8B_TPASO |
C |
1 |
0 |
Tp.Aso |
|
Pertence(" 012348") |
|
R |
0=Admissional;1=Periodico PCMSO;2=Ret. ao trabalho;3=Mudanca de funcao;4=Monit. pontual, nao enquadrado nos casos;8=Demissional |
|
S |
C8B_RESULT |
C |
1 |
0 |
Resul. Aso |
@! |
Pertence(" 12") |
|
R |
1=Apto;2=Inapto |
|
S |
C8B_CODMED |
C |
6 |
0 |
Cod. Medico |
@! |
XFUNVldCmp("CM7",1) |
CM7 |
R |
|
|
S |
C8B_DCODME |
C |
220 |
0 |
Des. Medico |
@! |
|
|
V |
|
|
S |
C8B_NISRES |
C |
11 |
0 |
NIS Resp. |
@! |
|
|
R |
|
|
S |
C8B_CRMRES |
C |
8 |
0 |
CRM Resp. |
@! |
|
|
R |
|
|
S |
C8B_CRMUF |
C |
6 |
0 |
UF CRM Resp |
@! |
XFUNVldCmp("C09",3) |
C09 |
R |
|
|
S |
C8B_DCRMU |
C |
220 |
0 |
Desc. UF |
@! |
|
|
V |
|
|
S |
C8B_VERANT |
C |
14 |
0 |
Ver Ant Reg |
@! |
|
|
R |
|
|
S |
C8B_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 |
C8B_PROTUL |
C |
44 |
0 |
Ult. Prot. |
@! |
|
|
R |
|
|
S |
C8B_PROTPN |
C |
44 |
0 |
Pnlt. Prot. |
@! |
|
|
R |
|
|
S |
C8B_EVENTO |
C |
1 |
0 |
Id. Evento |
@! |
Pertence("IAE") |
|
R |
I=Inclusao;A=Alteracao;E=Exclusao |
|
S |
C8B_ATIVO |
C |
1 |
0 |
Reg. Ativo? |
@! |
Pertence("12") |
|
R |
1=Sim;2=Nao |
|
S |
C8B_CODCNE |
C |
7 |
0 |
Cod. CNES |
@! |
|
|
R |
|
|
S |
C8B_CONTAT |
C |
100 |
0 |
Inf. Contato |
@! |
|
|
R |
|
|
S |
C8B_EMAIL |
C |
60 |
0 |
Email |
@! |
|
|
R |
|
|
S |
C8B_STASEC |
C |
1 |
0 |
Status Sec. |
|
|
|
R |
|
|
S |
C8B_XMLID |
C |
36 |
0 |
Id do XML. |
|
|
|
R |
|
|
S |
C8B_DINSIS |
D |
8 |
0 |
Dt Inc. Sist |
|
|
|
R |
|
|
S |
C8B_PROCID |
C |
6 |
0 |
Proc ID |
@! |
|
|
R |
|
|
S |
C8B_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 |
C8B_CPFRES |
C |
11 |
0 |
CPF |
@R 999.999.999-99 |
|
|
R |
|
|
S |
C8B_NOMRES |
C |
70 |
0 |
Nome |
@! |
|
|
R |
|
|
S |
C8B_NRCRM |
C |
8 |
0 |
Nr. CRM |
@! |
|
|
R |
|
|
S |
C8B_TPEXAM |
C |
1 |
0 |
Tp. Exam Ocu |
|
|
|
R |
0=Exame admissional;1=Exame periodico;2=Exame retorno trabalho;3=Exame mudanca funcao;4=Exame Monit. Pontual;9=Exame demissional |
|
S |