G_Schedule

TABLE G_Schedule

Primary Key: Schedule_ID int NOT NULL

Session_MID int NOT NULL

Session_LID int NOT NULL

Session_Name varchar(200) NOT NULL

Participant_ID int

Group_ID int

Schedule_Name varchar(200) NOT NULL

Restrict_Times bit NOT NULL

Schedule_Starts datetime

Schedule_Stops datetime

Restrict_Attempts bit NOT NULL

Max_Attempts int

Use_Conditions bit NOT NULL

Monitored smallint

Restrict_R_Access_Part bit NOT NULL

Restrict_R_Access_Admin bit NOT NULL

R_Access_Part_From datetime

R_Access_Part_To datetime

R_Access_Admin_From datetime

R_Access_Admin_To datetime

Test_Center_ID int

Group_Tree_ID int

Min_Days_Between_Attempts int

Time_Limit_Override bit

Time_Limit int

Lang varchar(10) NOT NULL

Participant_Lang bit NOT NULL

TABLE G_Schedule_Details

The basic Schedule table is not relegated to a view but is extended by creating an extension table keyed on the same identifier.

Primary Key: Schedule_ID int NOT NULL

Web_Delivery bit NOT NULL

Offline_Delivery bit NOT NULL

APack_File varchar(100)

Resume_Allowed smallint

RRA_ResultID int

RRA_Enabled bit

ResultFilterID int