| Tabela | |||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|
| GCZ | Guias de Atendimentos | ||||||||||
| Campo | Tipo | Tamanho | Decimal | Titulo | Formato | Validacao | F3 | Contexto | Lista | Condicao | PYME |
| GCZ_FILIAL | C | 2 | 0 | Filial | R | N | |||||
| GCZ_REGATE | C | 6 | 0 | Reg. Atendim | R | N | |||||
| GCZ_DATATE | D | 8 | 0 | Data Atendto | R | N | |||||
| GCZ_REGGER | C | 6 | 0 | Prontuario | @! | R | N | ||||
| GCZ_NOME | C | 45 | 0 | Nome Pacient | @! | R | N | ||||
| GCZ_MATRIC | C | 25 | 0 | Matricula | @! | V | S | ||||
| GCZ_CODTPG | C | 6 | 0 | Tipo de guia | @! | HS_VldM24(,14) | GCU | R | N | ||
| GCZ_DESTPG | C | 50 | 0 | Descricao | @! | V | N | ||||
| GCZ_CODCON | C | 3 | 0 | Cod Convenio | @! | R | N | ||||
| GCZ_CODPLA | C | 6 | 0 | Plano | @! | HS_VldM24(,13) | GCV | R | N | ||
| GCZ_DESPLA | C | 30 | 0 | Descricao | @! | V | N | ||||
| GCZ_SQCATP | C | 3 | 0 | Seq. Categ. | @! | HS_VldM24(,28) | R | N | |||
| GCZ_DSCATP | C | 30 | 0 | Desc. Categ. | @! | V | S | ||||
| GCZ_NRGUIA | C | 20 | 0 | Nro. Guia | @! | HS_VLDM24(,30) | R | !lNrGTissAt | N | ||
| GCZ_NRSEN1 | C | 20 | 0 | Senha 1 | @! | R | N | ||||
| GCZ_NRSEN2 | C | 20 | 0 | Senha 2 | @! | R | N | ||||
| GCZ_NRSEN3 | C | 20 | 0 | Senha 3 | @! | R | N | ||||
| GCZ_QTDIAS | N | 3 | 0 | Qtde. Dias | 999 | M->GCZ_QTDIAS > 0 | R | N | |||
| GCZ_CODCRM | C | 7 | 0 | CRM Solicit. | @! | HS_VldM24(,15) | MED | R | N | ||
| GCZ_NOMMED | C | 30 | 0 | Nome Medico | @! | V | N | ||||
| GCZ_GUIAPR | C | 20 | 0 | Guia Princip | @! | R | N | ||||
| GCZ_DATAUT | D | 8 | 0 | Data Autoriz | HS_VldM24(,25) | R | N | ||||
| GCZ_VALSEN | D | 8 | 0 | Valid. Senha | R | N | |||||
| GCZ_DTGUIA | D | 8 | 0 | Dt Emis Guia | R | N | |||||
| GCZ_DATSOL | D | 8 | 0 | Data Solicit | R | N | |||||
| GCZ_HORSOL | C | 5 | 0 | Hora Solicit | 99:99 | R | N | ||||
| GCZ_CIDSOL | C | 8 | 0 | CID Solicita | @! | HS_SeekRet('GAS','M->GCZ_CIDSOL',1) | GAS | R | N | ||
| GCZ_INDCLI | C | 254 | 0 | Ind. Clinica | @S100 | R | N | ||||
| GCZ_TEDVLR | N | 2 | 0 | Evol Doenca | 99 | HS_VLDTISS() | R | N | |||
| GCZ_TEDUND | C | 1 | 0 | Un Evol Doen | 9 | HS_VLDTISS() | R | A=Ano(s);M=Mes(es);D=Dia(s) | N | ||
| GCZ_IATISS | C | 1 | 0 | Ind Acidente | 9 | Vazio() .or. Pertence('012') | R | 0=Acidente ou doenca relacionada ao transito;1=Transito;2=Outros;9=Nao Acidente | N | ||
| GCZ_OBSTIS | C | 240 | 0 | Observacao | @S100 | R | N | ||||
| GCZ_IDMARC | C | 2 | 0 | Id. Marca | R | S | |||||
| GCZ_NRFATU | C | 9 | 0 | Nro Fatura | @! | R | N | ||||
| GCZ_DATFAT | D | 8 | 0 | Data | @D | R | N | ||||
| GCZ_HORFAT | C | 5 | 0 | Hora | 99:99 | R | N | ||||
| GCZ_NRLOTE | C | 6 | 0 | Numero Lote | @! | R | N | ||||
| GCZ_NREXTC | C | 10 | 0 | Ext.Convenio | R | S | |||||
| GCZ_FILFAT | C | 2 | 0 | Fil. Faturam | R | N | |||||
| GCZ_FILATE | C | 2 | 0 | Fil. Atendim | R | N | |||||
| GCZ_STATUS | C | 1 | 0 | Status | @! | R | 0=Contr de Contas;1=Faturamento;2=Faturado;3=Lote Atrib;4=Gerado Faturas;5=Assoc Extr.Conv.;6=Liquidado;7=Quitado;8=Reapr. SUS | N | |||
| GCZ_NMFFAT | C | 40 | 0 | Desc. Fiial | @! | V | N | ||||
| GCZ_NRPROT | C | 6 | 0 | Nro. Protoco | @! | R | N | ||||
| GCZ_DATSTA | D | 8 | 0 | Data | R | N | |||||
| GCZ_VALPAG | N | 10 | 2 | Pago Total | @E 9999,999.99 | HS_VlM381() | R | lG_Guia | N | ||
| GCZ_VALGLO | N | 10 | 2 | Glosa Total | @E 9999,999.99 | HS_VlM381() | R | lG_Guia | N | ||
| GCZ_VLPAGM | N | 10 | 2 | Pago Mat/Med | @E 9999,999.99 | HS_VlM381() | R | lG_Guia | N | ||
| GCZ_VLGLOM | N | 10 | 2 | Glosa Mat/Me | @E 9999,999.99 | HS_VlM381() | R | lG_Guia | N | ||
| GCZ_VLPAGT | N | 10 | 2 | Pago Tax/Dia | @E 9999,999.99 | HS_VlM381() | R | lG_Guia | N | ||
| GCZ_VLGLOT | N | 10 | 2 | Glosa Tax/Di | @E 9999,999.99 | HS_VlM381() | R | lG_Guia | N | ||
| GCZ_VLPAGP | N | 10 | 2 | Pago Pro/Hon | @E 9999,999.99 | HS_VlM381() | R | lG_Guia | N | ||
| GCZ_VLGLOP | N | 10 | 2 | Glosa Pro/Ho | @E 9999,999.99 | HS_VlM381() | R | lG_Guia | N | ||
| GCZ_VALREC | N | 10 | 2 | Recup. Total | @E 9999,999.99 | R | N | ||||
| GCZ_VALPER | N | 10 | 2 | Perda Total | @E 9999,999.99 | R | N | ||||
| GCZ_VLRECM | N | 10 | 2 | Rec. Mat/Med | @E 9999,999.99 | R | N | ||||
| GCZ_VLPERM | N | 10 | 2 | Perda Mat/Me | @E 9999,999.99 | R | N | ||||
| GCZ_VLRECT | N | 10 | 2 | Rec. Tax/Dia | @E 9999,999.99 | R | N | ||||
| GCZ_VLPERT | N | 10 | 2 | Perda Tax/Di | @E 9999,999.99 | R | N | ||||
| GCZ_VLRECP | N | 10 | 2 | Rec. Pro/Hon | @E 9999,999.99 | R | N | ||||
| GCZ_VLPERP | N | 10 | 2 | Perda Pro/Ho | @E 9999,999.99 | R | N | ||||
| GCZ_NUMORC | C | 6 | 0 | Num. Orcam. | @! | R | N | ||||
| GCZ_SERIE | C | 3 | 0 | Serie Nota | R | N | |||||
| GCZ_NRNOTA | C | 9 | 0 | Nota Fiscal | @! | R | N | ||||
| GCZ_VLGUIA | N | 10 | 2 | Vlr da Guia | @E 9,999,999.99 | R | N | ||||
| GCZ_NRSEQG | C | 6 | 0 | Nro.Seq.Guia | @! | R | N | ||||
| GCZ_NRRPT1 | C | 7 | 0 | Rel.Sol.Det. | R | N | |||||
| GCZ_DTRPT1 | D | 8 | 0 | Dt.Em.Sol.Dt | R | N | |||||
| GCZ_CANCEL | C | 1 | 0 | Cancelado? | @! | R | 0=Nao;1=Cancelado | N | |||
| GCZ_LOGARQ | C | 50 | 0 | Log | R | N | |||||
| GCZ_DTGERA | D | 8 | 0 | Dt.Geracao | @D | R | S | ||||
| GCZ_HRGERA | C | 5 | 0 | Hr.Geracao | 99:99 | R | S | ||||
| GCZ_USGERA | C | 25 | 0 | Usuario Gera | @! | R | S | ||||
| GCZ_ATENDI | C | 1 | 0 | Tipo Atendto | @! | R | 0=Internacao;1=Ambulatorio;2=Pronto Atendimento | N | |||
| GCZ_LOCATE | C | 2 | 0 | Setor Atend. | @! | R | N | ||||
| GCZ_CTAPAR | N | 2 | 0 | Cta Parcial | @E 99 | R | S | ||||
| GCZ_DCPARI | D | 8 | 0 | Dt.Parcial I | @D | R | !INCLUI .AND. M->GCZ_STATUS > "0" | S | |||
| GCZ_CMCAIH | C | 2 | 0 | Motivo Cobr. | HS_VldM24(,21) | GH8001 | R | N | |||
| GCZ_DCPARF | D | 8 | 0 | Dt.Parcial F | @D | R | !INCLUI .AND. M->GCZ_STATUS > "0" | S | |||
| GCZ_DMCAIH | C | 50 | 0 | Desc. Motivo | @! | V | N | ||||
| GCZ_IDGUIA | C | 1 | 0 | ID. Guia | R | 1=Inicial;5=Continuidade | N | ||||
| GCZ_AIHANT | C | 10 | 0 | AIH Anterior | @! | R | N | ||||
| GCZ_AIHPOS | C | 10 | 0 | AIH Post. | R | N | |||||
| GCZ_CDCBOR | C | 3 | 0 | Cod. Oficio | HS_VldM24(,22) | GH2001 | R | GCY->GCY_ACITRA == "1" | N | ||
| GCZ_DSCBOR | C | 50 | 0 | Descricao | V | N | |||||
| GCZ_CDCCNA | C | 3 | 0 | Cod. Nac Atv | HS_VldM24(,23) | GHB001 | R | GCY->GCY_ACITRA == "1" | N | ||
| GCZ_DESCNA | C | 50 | 0 | Desc Nac Atv | @! | V | N | ||||
| GCZ_TPVINC | C | 1 | 0 | Tipo Vinculo | R | 1=Autonomo;2=Desempregado;3=Aposentado;4=Nao segurado;5=Empregado;6=Empregador | GCY->GCY_ACITRA == "1" | N | |||
| GCZ_RNNVIV | N | 2 | 0 | Nasc. Vivo | 99 | Positivo() | R | HS_VldM24(,24) | N | ||
| GCZ_RNNOBI | N | 2 | 0 | Nasc. Mortos | 99 | Positivo() | R | HS_VldM24(,24) | N | ||
| GCZ_RNALTA | N | 2 | 0 | Nasc. Alta | 99 | Positivo() | R | HS_VldM24(,24) | N | ||
| GCZ_RNTRAN | N | 2 | 0 | Nasc. Transf | 99 | Positivo() | R | HS_VldM24(,24) | N | ||
| GCZ_RNOBIT | N | 2 | 0 | Obitos | 99 | Positivo() | R | HS_VldM24(,24) | N | ||
| GCZ_CPRAU1 | C | 10 | 0 | Proced. Aut1 | HS_VldM24(,26) | GA7 | R | N | |||
| GCZ_DPRAU1 | C | 50 | 0 | Desc Pr Aut1 | @! | V | N | ||||
| GCZ_CPRAU2 | C | 10 | 0 | Proced. Aut2 | HS_VldM24(,26) | GA7 | R | N | |||
| GCZ_DPRAU2 | C | 50 | 0 | Desc Pr Aut2 | @! | V | N | ||||
| GCZ_CPRAU3 | C | 10 | 0 | Proced. Aut3 | HS_VldM24(,26) | GA7 | R | N | |||
| GCZ_DPRAU3 | C | 50 | 0 | Desc Pr Aut3 | @! | V | N | ||||
| GCZ_CPRAU4 | C | 10 | 0 | Proced. Aut4 | HS_VldM24(,26) | GA7 | R | N | |||
| GCZ_DPRAU4 | C | 50 | 0 | Desc Pr Aut4 | @! | V | N | ||||
| GCZ_CPRAU5 | C | 10 | 0 | Proced. Aut5 | HS_VldM24(,26) | GA7 | R | N | |||
| GCZ_DPRAU5 | C | 50 | 0 | Desc Pr Aut5 | @! | V | N | ||||
| GCZ_DIASAC | N | 2 | 0 | Acomp. Dias | 99 | Positivo() | R | N | |||
| GCZ_DTADIA | D | 8 | 0 | Data Acomp. | R | N | |||||
| GCZ_CPFAUD | C | 11 | 0 | CPF Auditor | @R 999.999.999-99 | Vazio() .or. CGC(M->GCZ_CPFAUD) | R | N | |||
| GCZ_MESINI | N | 2 | 0 | Mes Inicial | 99 | Positivo() | R | N | |||
| GCZ_MESANT | N | 2 | 0 | Mes Anterior | 99 | Positivo() | R | N | |||
| GCZ_MESALT | N | 2 | 0 | Mes Alta | 99 | Positivo() | R | N | |||
| GCZ_IDAUTE | C | 1 | 0 | Aut. Espec. | Pertence("01") | R | 0=Nao;1=Sim | N | |||
| GCZ_CPFGES | C | 11 | 0 | CPF Gestor | @R 999.999.999-99 | Vazio() .or. CGC(M->GCZ_CPFGES) | R | N | |||
| GCZ_CODAUT | C | 1 | 0 | Cod. Autoriz | R | 1=Tempo Permanencia a Menor;2=Idade Menor;3=Idade Menor;4=Tempo de Permanecia e Idade | N | ||||
| GCZ_TPNOTA | C | 3 | 0 | Tipo | R | S | |||||
| GCZ_PRCTIT | C | 2 | 0 | Parcela Tit. | @! | R | N | ||||
| GCZ_NDGUIA | C | 8 | 0 | Nro Document | 99999999 | R | N | ||||
| GCZ_CODDES | C | 10 | 0 | Cod Serv/Pri | @! | HS_VldM24(,34) | GA7 | R | N | ||
| GCZ_DDESPE | C | 30 | 0 | Descricao | @! | V | N | ||||
| GCZ_CODPRT | C | 10 | 0 | Cod. Proprio | @! | R | N | ||||
| GCZ_TATISS | C | 2 | 0 | Tp. Atend. | @! | HS_VldM24(,35) | G08001 | R | N | ||
| GCZ_DTATIS | C | 30 | 0 | Desc Tp Aten | @! | V | N | ||||
| GCZ_TIPCON | C | 1 | 0 | Tipo Consult | @! | HS_VldM24(,36) | G12001 | R | N | ||
| GCZ_DTIPCO | C | 30 | 0 | Desc Tp Cons | @! | V | N | ||||
| GCZ_TPAPAC | C | 1 | 0 | Tipo APAC | @! | HS_VLDM24(,39) | R | 1=Inicial;2=ContinuažOo;3=?nica | N | ||
| GCZ_CMCPAC | C | 2 | 0 | Motiv. Cobr. | @! | HS_SeekRet('GH7','M->GCZ_CMCPAC',1,.F.,'GD7_DMCPAC') | GH7001 | R | N | ||
| GCZ_VGUIAI | D | 8 | 0 | Dt. Ini. Vld | HS_VLDM24(, 39) | R | N | ||||
| GCZ_VGUIAF | D | 8 | 0 | Dt. Vld. Fim | HS_VLDM24(, 39) | R | N | ||||
| GCZ_TDTISS | C | 1 | 0 | Tp. Doenca | Pertence('01') | R | 0=Aguda;1=Cronica | N | |||
| GCZ_ALTGUI | C | 1 | 0 | Alt. Nr. Gui | @! | Pertence('01') | R | 0=Nao;1=Sim | N | ||
| GCZ_NRORES | C | 6 | 0 | Nro Res. At. | @! | R | N | ||||
| GCZ_RNVPRE | N | 2 | 0 | RN Prematuro | 99 | Positivo() | R | N | |||
| GCZ_OBNEOP | N | 2 | 0 | Obt Neo Prec | 99 | Positivo() | R | N | |||
| GCZ_OBNEOT | N | 2 | 0 | Obt Neo Tard | 99 | Positivo() | R | N | |||
| GCZ_TPALTA | C | 2 | 0 | Tipo da Alta | @! | HS_SeekRet('GF4','M->GCZ_TPALTA',1,.f.,'GCZ_DESALT','GF4_DSTPAL') | GF4 | R | N | ||
| GCZ_DESALT | C | 30 | 0 | Desc Tp Alta | @! | HS_IniPadr('GF4', 1, GCZ->GCZ_TPALTA, 'GF4_DSTPAL') | V | N | |||
| GCZ_TIPAIH | C | 1 | 0 | Tp Atend AIH | @! | Pertence("123") | R | 1=AIH Principal;3=AIH de Continuacao;5=AIH Longa Permanencia | S | ||
| GCZ_NUMAIH | C | 13 | 0 | Numero AIH | @! | HS_VldM24(,46) | R | S | |||
| GCZ_MDPROC | C | 1 | 0 | Mud. Proc. | Pertence("01") | R | 0=Nao;1=Sim | S | |||
| GCZ_SISAIH | C | 11 | 0 | SISPRENAT | @! | R | S | ||||
| GCZ_CRMAUT | C | 7 | 0 | Med Autoriz | @! | HS_VldM24(,17) | MED | R | N | ||
| GCZ_MEDAUT | C | 30 | 0 | Nome Autoriz | @! | V | N | ||||
| GCZ_SEQSES | C | 5 | 0 | Seq. Sessao | @! | R | N | ||||
| GCZ_NRGGLO | C | 6 | 0 | Nr.Guia.Glo. | @! | R | N | ||||
| GCZ_GUIAOP | C | 20 | 0 | Nro Guia Ope | @! | R | S | ||||
| GCZ_DTSUGE | D | 8 | 0 | Dt. Sug. Int | R | S | |||||
| GCZ_USOOPM | C | 1 | 0 | Prev uso OPM | @! | R | N=Nao;S=Sim | S | |||
| GCZ_USOQUI | C | 1 | 0 | Prev. Quim. | @! | R | N=Nao;S=Sim | S | |||
| GCZ_DECOBT | C | 11 | 0 | Dec Obito | S | ||||||
| GCZ_IOBTRN | C | 1 | 0 | Ind Obito RN | N=Nao;S=Sim | S | |||||
| GCZ_CIDOBT | C | 4 | 0 | Motivo obito | S | ||||||
| GCZ_DECVIV | C | 11 | 0 | Dec Nas vivo | S | ||||||