sorry put in the older version of table

CNO CHAR (100) NOT NULL,

OPICSCNO CHAR (100) NULL,

MOODYSRATE CHAR (10) NOT NULL,

SNPRATE CHAR (10) NOT NULL,

FITCHRATE CHAR (10) NOT NULL,

MOODYSIRB numeric (4) NULL,

SPIRB numeric (4) NULL,

FITCHIRB numeric (4) NULL,

MOODYSWATCH bit DEFAULT 0 NOT NULL,

SPWATCH bit DEFAULT 0 NOT NULL,

FITCHWATCH bit DEFAULT 0 NOT NULL,

MIDRATEAGENCY CHAR (10) NULL,

MIDRATING CHAR (10) NULL,

MIDIRB numeric NULL,

NEGWATCH bit DEFAULT 0 NOT NULL,