| ID |
(identity) |
| CREATED_BY |
(reference to EMPLOYEE) |
| UPDATED_BY |
(reference to EMPLOYEE) |
| APPROVED_BY |
(reference to EMPLOYEE) |
| DATE_CREATE |
(date/time created) |
| DATE_UPDATE |
(date/time updated) |
| DATE_START |
(date/time start) |
| DATE_DISPLAY |
(date/time display) |
| DATE_STOP |
(date/time stop) |
| STATUS_DELETED |
(status: deleted) |
| STATUS_CLOSED |
(status: closed) |
| STATUS_PLANNED |
(status: planned) |
| STATUS_APPROVE |
(status: approve) |
| STATUS_COMPLETED |
(status: completed) |
| ORGUNIT_TYPE |
(reference to ORGUNIT.TYPE) |
| ORGUNIT_CODE |
(reference to ORGUNIT.CODE) |
| PATIENT_ID |
(reference to parent table PATIENT) |
| BESOEGBARN_ID |
(reference to parent table BESOEGBARN) |
| dateBarnetsCprNrBesoegB |
Barnets CPR nummer ved besøg |
| dateULTerminBesoegB |
Dato før termin besøg |
| dateEstimeretTerminBesoegB |
Estimeret dato for termin |
| dateTvaerFoerBesoegB |
dato for besøg |
| FORLOEB_ID |
(reference to parent table FORLOEB) |
| dateUsikkerTerminBesoegB |
Usikkerhed ved dato for terminsbesøg |
| dateBarnetsFoedselsdagBesoegB |
Barnets fødselsdag |
| intGAUTerminBesoegB |
GAU |
| intGADTerminBesoegB |
GAD |
| intKronAlderAarLaegeVedFoedselTvearSekMB |
Integer for år |
| intKronAlderMaanedLaegeVedFoedselTvearSekMB |
mdr. |
| intKronAlderDageLaegeVedFoedselTvearSekMB |
dg. |
| intKorrigAlderMaanedLaegeVedFoedselTvearSekMB |
mdr. |
| intKorrigAlderDageLaegeVedFoedselTvearSekMB |
dg. |
| idx |
IDX forløbende nummer - benyttes ikke |