Tabela |
TMY |
Atestado Saude Ocupacional |
Campo |
Tipo |
Tamanho |
Decimal |
Titulo |
Formato |
Validacao |
F3 |
Contexto |
Lista |
Condicao |
PYME |
TMY_FILIAL |
C |
2 |
0 |
Filial |
|
|
|
|
|
|
N |
TMY_NUMASO |
C |
6 |
0 |
Numero ASO |
NNNNNN |
EXISTCHAV("TMY",M->TMY_NUMASO) |
|
|
|
|
N |
TMY_NUMFIC |
C |
9 |
0 |
Ficha Medica |
999999999 |
SitFunFicha(M->TMY_NUMFIC,.t.,.t.,.t.) .AND. ULTDATASO("SX3") .AND. RISCOSTRB() .AND. EXAMESTRB() |
TM0 |
|
|
LENUMFIC |
N |
TMY_NOMFIC |
C |
20 |
0 |
Nome |
@! |
|
|
V |
|
|
N |
TMY_EXAME |
C |
6 |
0 |
Exame |
@! |
EXISTCPO("TM4",M->TMY_EXAME) |
|
|
|
LEEXAME |
N |
TMY_DTPROG |
D |
8 |
0 |
Data Prog. |
|
RISCOSTRB() |
|
|
|
LEDTPROG |
N |
TMY_DTGERA |
D |
8 |
0 |
Data Geracao |
|
RISCOSTRB() |
|
|
|
|
N |
TMY_DTEMIS |
D |
8 |
0 |
Data Emissao |
|
|
|
|
|
LEDTEMIS |
N |
TMY_DTCANC |
D |
8 |
0 |
Data Cancel. |
|
|
|
|
|
LEDTCANC |
N |
TMY_QTDTRA |
N |
4 |
0 |
Dias Trat. |
@E 9999 |
|
|
R |
|
|
S |
TMY_INDPAR |
C |
1 |
0 |
Ind. Parec. |
@! |
PERTENCE("123") |
|
|
1=Apto;2=Inapto;3=Apto com Restricao |
|
N |
TMY_DESPAR |
C |
25 |
0 |
Desc. Parec. |
@! |
|
|
V |
|
|
N |
TMY_CODUSU |
C |
12 |
0 |
Medico Resp. |
@! |
MDT200VMED(M->TMY_CODUSU) |
MDTGEN |
|
|
LECODUSU |
N |
TMY_NOMUSU |
C |
20 |
0 |
Nome |
@! |
|
|
V |
|
|
N |
TMY_DESCRI |
C |
200 |
0 |
Descricao |
|
|
|
|
|
|
N |
TMY_NATEXA |
C |
1 |
0 |
Natureza |
@! |
PERTENCE("12345") |
|
|
1=Admissional;2=Periodico;3=Mudanca de Funcao;4=Retorno ao Trabalho;5=Demissional |
|
N |
TMY_DESNAT |
C |
20 |
0 |
Desc. Nat. |
@! |
|
|
V |
|
|
N |
TMY_NOVFUN |
C |
5 |
0 |
Nova Funcao |
@! |
MDT200NVF(1) |
MDTGEN |
R |
|
MDT200WHEN(2) |
N |
TMY_USERGI |
C |
17 |
0 |
Log de Inclu |
|
|
|
R |
|
|
N |
TMY_USERGA |
C |
17 |
0 |
Log de Alter |
|
|
|
R |
|
|
N |
TMY_NOVCC |
C |
9 |
0 |
Novo C.Custo |
@! |
MDT200NVF(3) |
MDTGEN |
R |
|
MDT200WHEN(4) |
S |
TMY_NOVTAR |
C |
6 |
0 |
Nova Tarefa |
@! |
MDT200NVF(5) |
MDTGEN |
R |
|
MDT200WHEN(6) |
S |
TMY_ALTURA |
C |
1 |
0 |
Trab. Altura |
@! |
|
|
R |
1=Sim;2=Nao |
|
N |
TMY_EMPFUT |
C |
2 |
0 |
Emp. Futura |
@! |
EXISTCPO('SM0',M->TMY_EMPFUT) .and. MDT200NVF(8) |
YM0 |
R |
|
MDT200WHEN(8) |
N |
TMY_FILFUT |
C |
2 |
0 |
Fil. Futura |
|
ExistCPO('SM0',M->TMY_EMPFUT+M->TMY_FILFUT) |
NGXM0 |
R |
|
MDT200WHEN(7) |
N |
TMY_CONFIN |
C |
1 |
0 |
Espaco Confi |
@! |
|
|
R |
1=Sim;2=Nao |
|
N |
TMY_TMC |
C |
1 |
0 |
Tra/Mov Carg |
@! |
|
|
R |
1=Sim;2=Nao |
|
N |
TMY_NOVDEP |
C |
9 |
0 |
Novo dep. |
@! |
MDT200NVF(9) |
MDTGEN |
R |
|
MDT200WHEN(10) |
N |
TMY_CNES |
C |
7 |
0 |
Cod. CNES |
@ 9999999 |
Empty(M->TMY_CNES) .Or. ExistCPO('TIL',M->TMY_CNES) |
TIL |
R |
|
|
N |
TMY_ELETRI |
C |
1 |
0 |
Trab. Eletr. |
@! |
Pertence('12') |
|
R |
1=Sim;2=Nao |
|
N |
TMY_ESTAB |
C |
80 |
0 |
Estabelecim. |
@! |
|
|
V |
|
|
N |
TMY_INDEXA |
C |
1 |
0 |
Ind. Exame |
@! |
Pertence("12") |
|
R |
1=Referencial;2=Sequencial |
|
N |