tblPROGRAM - Program informtion

holds information on the program with which the center is associated

Core Fields

Note: Fields marked bold form the unique identifier for a record of the table.

Field name Format Description
PROGRAM character Program name
REGION

character:

  • AP = Asia-Pacific
  • CA = Central Africa
  • CN = Caribbean, Central and South America
  • EA = East Africa
  • EU = Europe
  • NA = North America
  • SA = Southern Africa
  • WA = West Africa
Region of operation

QA Checks

Table Crosstable Error Code Description Study specific Is HICDEP
AllTables CrossTable ATC001 any date in database after DEATH_D in tblLTFU Yes
AllTables CrossTable ATC002 any date in database after DROP_D in tblLTFU Yes
AllTables CrossTable ATC003 any date in database before BIRTH_D in tblBAS Yes
AllTables CrossTable ATC004 any date in database in the future Yes
AllTables CrossTable ATC005 patients submitted previously who have been missed out Yes
AllTables CrossTable ATC006 Any fields not coded as coding lists on table definition Yes