Tabela |
GM8 |
Agenda Ambulatorial |
Campo |
Tipo |
Tamanho |
Decimal |
Titulo |
Formato |
Validacao |
F3 |
Contexto |
Lista |
Condicao |
PYME |
GM8_FILIAL |
C |
2 |
0 |
Filial |
|
|
|
|
|
|
S |
GM8_DATAGE |
D |
8 |
0 |
Data Agenda |
|
|
|
R |
|
|
S |
GM8_HORAGE |
C |
5 |
0 |
Hora Agenda |
99:99 |
HSPM29VLDHOR() |
|
R |
|
|
S |
GM8_FILAGE |
C |
2 |
0 |
Filial Agend |
|
HSPM29ConsFil() |
SM0 |
R |
|
|
S |
GM8_REGGER |
C |
6 |
0 |
Prontuario |
@! |
HSPM29ConsFil() |
GH1 |
R |
|
|
S |
GM8_NOMPAC |
C |
45 |
0 |
Nome Pacien. |
@! |
HSPM29ConsFil() |
GH4 |
R |
|
Empty(M->GM8_REGGER) |
S |
GM8_MATRIC |
C |
25 |
0 |
Matricula |
@! |
HSPM29ConsFil() |
|
R |
|
|
S |
GM8_TELPAC |
C |
13 |
0 |
Fone Pacien. |
@R (99)99999-9999 |
|
GF1 |
R |
|
|
S |
GM8_CODPLA |
C |
6 |
0 |
Cod. Plano |
@! |
HSPM29ConsFil() |
GCM |
R |
|
|
S |
GM8_DESPLA |
C |
30 |
0 |
Desc Plano |
@! |
|
|
V |
|
|
S |
GM8_SQCATP |
C |
3 |
0 |
Seq. Categ. |
@! |
Vazio() .Or. HSPM29ConsFil() |
GFV001 |
R |
|
Empty(M->GM8_REGGER) |
N |
GM8_DSCATP |
C |
30 |
0 |
Desc. Categ. |
@! |
|
|
V |
|
|
N |
GM8_INTERV |
N |
3 |
0 |
Intervalo |
999 |
|
|
R |
|
|
N |
GM8_NUMSES |
N |
2 |
0 |
Num Sessoes |
99 |
|
|
R |
|
|
N |
GM8_PROTOC |
C |
30 |
0 |
Protocolo |
@! |
|
GM8002 |
R |
|
|
N |
GM8_DURACA |
C |
5 |
0 |
Duracao |
99:99 |
|
|
R |
|
|
N |
GM8_CODLOC |
C |
2 |
0 |
Cod. Setor |
@! |
|
|
R |
|
|
S |
GM8_CODPRO |
C |
10 |
0 |
Cod. Proced. |
@! |
HSPM29ConsFil() |
GA7 |
R |
|
|
S |
GM8_DESPRO |
C |
30 |
0 |
Desc Proced. |
@! |
|
|
V |
|
|
S |
GM8_CODCRM |
C |
7 |
0 |
Profissional |
@! |
HSPM29ConsFil() |
GM8 |
R |
|
|
S |
GM8_NOMCRM |
C |
40 |
0 |
Nome Profis. |
@! |
|
|
V |
|
|
S |
GM8_CODSAL |
C |
6 |
0 |
Cod. Sala |
@! |
HS_SEEKRET('GF3', 'M->GM8_CODSAL', 1, .F., 'GM8_NOMSAL', 'GF3_DESCRI') |
GF3 |
R |
|
|
S |
GM8_NOMSAL |
C |
40 |
0 |
Desc. Sala |
@! |
|
|
V |
|
|
S |
GM8_STATUS |
C |
1 |
0 |
Situacao |
@! |
|
|
R |
0=liberado;1=Ocupado;2=Bloqueado;3=Atendido;4=Ocupado/Bloqueado;5=Confirmado;6=Retorno;7=Conferencia;8=Transferido |
|
S |
GM8_LOCDES |
C |
30 |
0 |
Desc. Setor |
@! |
|
|
V |
|
|
S |
GM8_CODDIS |
C |
10 |
0 |
Cod. Disp. |
@! |
|
|
R |
|
|
S |
GM8_DESDIS |
C |
30 |
0 |
Desc Disponi |
@! |
|
|
V |
|
|
S |
GM8_HORINI |
C |
5 |
0 |
Hora Inicial |
99:99 |
|
|
V |
|
|
S |
GM8_HORFIN |
C |
5 |
0 |
Hora Final |
99:99 |
|
|
V |
|
|
S |
GM8_LOCAGE |
C |
2 |
0 |
Local Agend. |
|
|
|
R |
|
|
S |
GM8_CODCON |
C |
3 |
0 |
Cod. Conv. |
@! |
|
|
R |
|
|
S |
GM8_DATCAD |
D |
8 |
0 |
Data Cad. |
|
|
|
R |
|
|
S |
GM8_HORCAD |
C |
5 |
0 |
Hora Cad. |
@! |
|
|
R |
|
|
S |
GM8_CODUSU |
C |
25 |
0 |
Usuario |
@! |
|
|
R |
|
|
S |
GM8_OBSERV |
M |
10 |
0 |
Observacao |
|
|
|
|
|
|
N |
GM8_ORICAN |
C |
1 |
0 |
Origem Canc. |
@9 |
Pertence("012") .And. HSPM29OriCan() |
|
|
0=Medico;1=Paciente;2=Empresa |
|
S |
GM8_MOTIVO |
C |
6 |
0 |
Motivo |
|
HSPM29MotDes() |
GM7 |
R |
|
|
N |
GM8_DESMOT |
C |
40 |
0 |
Desc Motivo |
@! |
|
|
V |
|
|
N |
GM8_REGATE |
C |
6 |
0 |
Atendimento |
@! |
|
|
R |
|
|
N |
GM8_DESCAN |
C |
40 |
0 |
Descricao |
@! |
|
|
V |
|
|
S |
GM8_TIPAGE |
C |
1 |
0 |
Tipo |
|
|
|
R |
0=Agenda;1=Encaixe |
|
S |
GM8_CODSOL |
C |
6 |
0 |
Cod Solicit. |
@! |
|
|
R |
|
|
S |
GM8_DESCFM |
C |
70 |
0 |
Confirm. com |
@! |
|
|
R |
|
|
S |
GM8_DATCFM |
D |
8 |
0 |
Data Conf. |
|
|
|
R |
|
|
S |
GM8_HORCFM |
C |
5 |
0 |
Hora Conf. |
@! |
|
|
R |
|
|
S |
GM8_USUCFM |
C |
25 |
0 |
Usuario Conf |
@! |
|
|
R |
|
|
S |
GM8_OK |
C |
2 |
0 |
OK |
|
|
|
R |
|
|
S |
GM8_CODAGE |
C |
12 |
0 |
Cod. Age. |
@! |
|
|
R |
|
|
S |
GM8_EXCTRA |
L |
1 |
0 |
Exc. Transf. |
|
|
|
R |
|
|
N |
GM8_LOGARQ |
C |
50 |
0 |
Log. Arq. |
@! |
|
|
R |
|
|
S |
GM8_LOCORI |
C |
2 |
0 |
Setor Origem |
@! |
|
|
R |
|
|
N |
GM8_CODREC |
C |
6 |
0 |
Cod Recurso |
@! |
|
|
R |
|
|
N |
GM8_AGDPRC |
C |
12 |
0 |
Cod Age Prin |
@! |
|
|
R |
|
|
N |
GM8_IDMARC |
C |
2 |
0 |
Id. Marca |
|
|
|
R |
|
|
N |
GM8_SEQAGE |
C |
12 |
0 |
Seq. Age. |
@! |
|
|
R |
|
|
N |
GM8_SEQQTD |
C |
5 |
0 |
Seq. Sessao |
@! |
|
|
R |
|
|
N |
GM8_NSQFAT |
C |
6 |
0 |
Nro.Seq.Fat. |
@! |
|
|
R |
|
|
N |
GM8_SOLICI |
C |
6 |
0 |
Cod Sol APAC |
@! |
|
|
R |
|
|
N |
GM8_MTVCLI |
C |
6 |
0 |
Codigo Motiv |
@! |
|
|
R |
|
|
N |
GM8_DSMCLI |
C |
40 |
0 |
Descr Motiv |
@! |
|
|
V |
|
|
N |
GM8_USRFOR |
C |
25 |
0 |
Usuar. Forc |
@! |
|
|
R |
|
|
N |
GM8_NUMORC |
C |
6 |
0 |
Num Orc Fat |
@! |
|
|
R |
|
|
N |
GM8_ITEORC |
C |
2 |
0 |
Item Orcam |
|
|
|
R |
|
|
N |
GM8_ORIPAC |
C |
6 |
0 |
Origem |
@! |
IIf(FUNNAME() == 'HSPAHM54',HSPM54ConsFil(),) |
GD0 |
R |
|
|
N |
GM8_DORIPA |
C |
30 |
0 |
Descricao |
@! |
|
|
V |
|
|
N |
GM8_SOLMAT |
C |
6 |
0 |
Solic. mater |
999999 |
|
|
R |
|
|
N |
GM8_PROMO |
C |
1 |
0 |
Promocao? |
@! |
Pertence('01') |
|
R |
0=Nao;1=Sim |
|
S |
GM8_PROGRA |
C |
6 |
0 |
Cod Programa |
@! |
|
|
R |
|
|
S |
GM8_EVENTO |
C |
6 |
0 |
Cod. Evento |
@! |
|
|
R |
|
|
S |
GM8_DSEVEN |
C |
40 |
0 |
Descr Evento |
@! |
|
|
V |
|
|
S |
GM8_SOLGKB |
C |
6 |
0 |
Cod Sol Sess |
@! |
|
|
R |
|
|
N |