Object Type	Table
Datasource	IPMA
Database	icsa

This table contains the email received from the IDT teams that details the requests for manual commanding for an instrument in a given revolution. This is known as Non-Standard Operations (or NSOs).

Use and Related Data

Each NSO request (email) is specific to a revolution and an instrument.

Population

Emails retrieved from CC and table manually populated.

Columns

Name	Datatype	Null

revno	int	No

inst	char(1)	No

recommendation	text	No

column revno

Revolution number.

column inst

The instrument for which the NSO applies.

column recommendation

The email containing the NSO recommendation (from an IDT).

Table Usage (MB)

Distribution of Table Space

Data	0.02	Data	1.33 %
Indexes	1.13	Indexes	96.67 %
Unused	0.02	Unused	2.00 %
Total	1.17	Number of Rows	421

Dependencies

Referencing Objects

Object Name Object Type

Referenced Objects

Object Name Object Type

DDL

CREATE TABLE dbo.nso_recommendations 
(
    revno          int     NOT NULL,
    inst           char(1) NOT NULL,
    recommendation text    NOT NULL
)
LOCK ALLPAGES
go