Baylor Database Data Definitions and Limits

 

Demographics

 

Data Entry Form Name

Field Name

Type

Length

Input Limits

Definition

Last Name

LNAM

Alpha

20

Open

Infant's last name

Given Name

MFRNAM

Alpha

10

Open

Infant's first name, sex and twin designation (e.g., “Mary T/A/G” or “Baby Boy A”).

Hospital

HOSPITAL

Alpha

1

T, B, M, W, C

"T"=TCH; "B"=Ben Taub; "M"=Methodist; "W"=Womens; "C"=Bayou City

The following codes exist in the database but are not available through data input:

“X” = Consolidated Transfer from Ben Taub to TCH; 

“Y” = Consolidated Transfer from Methodist to TCH.

Hospital #

HNUM

#

12

Open

Infant’s Medical Record Number at Baylor Affiliated Hospital of last admission.

Funding Source

FUNDING

Alpha

12

Open

Infant's insurance for hospital billing. See official list (to be developed).

Sex

SEX

Alpha

1

M, F, U

"M"=Male; "F"=Female; "U"=Uncertain

Race

RACE

Alpha

1

W,B,H,A,O

Race of Mother: "W"=White; "B"=Black; "H"=Hispanic; "A"=Asian; "O"=Other

(Note: TCH Codes as of 6/2003: 1=White; 2=Black; 4=Asian; 5=Hispanic; 6 or 8=Other)

 

 

Dates

 

Data Entry Form Name

Field Name

Type

Length

Limits

Definition

Birth Date

BDATE

Date

mm/dd/yyyy

>01/01/1985, 1/1/1901

Birth Date of infant.  “1/1/1901” if unknown.

Hospital Admission Date

HADATE

Date

mm/dd/yyyy

Open

 

First date infant admitted to hospital.  Readmission after discharge is a new record.  “1/1/1901” if unknown. 

First ICU Admission

ADATE

Date

mm/dd/yyyy

Open

First date in ICU even if there are multiple readmits in the same admission.  

“1/1/1901” if no ICU admission or unknown.

Last ICU Discharge

ICUDISC

Date

mm/dd/yyyy

Open

Last date in ICU even if there are multiple readmits in the same admission. 

“1/1/1901” if no ICU admission or unknown.

Hospital Discharge

DISDATE

Date

mm/dd/yyyy

Open

Date left hospital or died during current admission. “1/1/1901” if unknown.

 

Baylor College of Medicine - Neonatology Section

Best viewed in 1024 by 768 resolution. Page last modified: 6/26/03