Consulta Padrao: BHYPLS - Corpo Clinico



Consulta Padrao(SXB): BHYPLS - Corpo Clinico
XB_ALIASXB_TIPOXB_SEQXB_COLUNAXB_DESCRIXB_CONTEM
BHYPLS101DBCorpo ClinicoBC1
BHYPLS20102UF + Numero + Sigla
BHYPLS20103Nome do Profissional
BHYPLS40102UF + Numero + SiglaBC1->BC1_ESTCR+"-"+AllTrim(BC1->BC1_NUMCR)+"-"+BC1->BC1_SIGLCR
BHYPLS40103NomeBC1->BC1_NOMPRF
BHYPLS50101BC1->BC1_NUMCR
BHYPLS60101BC1->(BC1_CODIGO+BC1_CODINT+BC1_CODLOC+BC1_CODESP) == M->BD5_CODRDA+M->BD5_OPERDA+SUBS(M->BD5_CODLOC,1,3)+M->BD5_CODESP