This is an HTML version of an attachment to the Freedom of Information request 'ACOBA appointments database information'.
Table: CSAPPLICANT       Page: 1 
         Columns
         Name     Type     Size
         ApplicantID      Long Integer     4
         AllowZeroLength:         False
         Attributes:      Fixed Size
         CollatingOrder:          General
         ColumnHidden:    False
         ColumnOrder:     Default
         ColumnWidth:     Default
         DataUpdatable:   False
         DecimalPlaces:   Auto
         Description:     ID number of Applicant (autogenerated for new entries)
         DisplayControl:          Text Box
         OrdinalPosition:         0
         Required:        True
         SourceField:     ApplicantID
         SourceTable:     CSAPPLICANT
         Surname  Text     30
         AllowZeroLength:         False
         Attributes:      Variable Length
         CollatingOrder:          General
         ColumnHidden:    False
         ColumnOrder:     Default
         ColumnWidth:     Default
         DataUpdatable:   False
         Description:     Surname of Applicant (up to 30 characters)
         DisplayControl:          Text Box
         OrdinalPosition:         1
         Required:        True
         SourceField:     Surname
         SourceTable:     CSAPPLICANT
         Initials         Text     30
         AllowZeroLength:         False
         Attributes:      Variable Length
         CollatingOrder:          General
         ColumnHidden:    False
         ColumnOrder:     Default
         ColumnWidth:     Default
         DataUpdatable:   False
         Description:     *** Initials of Applicant (up to 30 characters) *** This field doubles as
         Forename
         DisplayControl:          Text Box
         OrdinalPosition:         2
         Required:        False


Table: CSAPPLICANT       Page: 2
         SourceField:     Initials
         SourceTable:     CSAPPLICANT
         Title    Text     15
         AllowZeroLength:         False
         Attributes:      Variable Length
         CollatingOrder:          General
         ColumnHidden:    False
         ColumnOrder:     Default
         ColumnWidth:     Default
         DataUpdatable:   False
         Description:     Title of Applicant (up to 15 characters)
         DisplayControl:          Text Box
         OrdinalPosition:         3
         Required:        False
         SourceField:     Title
         SourceTable:     CSAPPLICANT
         Honours  Text     15
         AllowZeroLength:         False
         Attributes:      Variable Length
         CollatingOrder:          General
         ColumnHidden:    False
         ColumnOrder:     Default
         ColumnWidth:     Default
         DataUpdatable:   False
         Description:     Honours awarded to Applicant (up to 15 characters)
         DisplayControl:          Text Box
         OrdinalPosition:         4
         Required:        False
         SourceField:     Honours
         SourceTable:     CSAPPLICANT
         DateOfBirth      Date/Time        8
         AllowZeroLength:         False
         Attributes:      Fixed Size
         CollatingOrder:          General
         ColumnHidden:    False
         ColumnOrder:     Default
         ColumnWidth:     Default
         DataUpdatable:   False
         Description:     Date of Birth of Applicant
         OrdinalPosition:         5
         Required:        False
         SourceField:     DateOfBirth
         SourceTable:     CSAPPLICANT
         DepartmentID     Long Integer     4
         AllowZeroLength:         False
         Attributes:      Fixed Size
         CollatingOrder:          General
         ColumnHidden:    False
         ColumnOrder:     Default
         ColumnWidth:     Default
         DataUpdatable:   False
         DecimalPlaces:   Auto


Table: CSAPPLICANT       Page: 3
         Description:     Government Department worked for - cross-reference to control table
         DisplayControl:          Text Box
         OrdinalPosition:         6
         Required:        False
         SourceField:     DepartmentID
         SourceTable:     CSAPPLICANT
         RankID   Long Integer     4
         AllowZeroLength:         False
         Attributes:      Fixed Size
         CollatingOrder:          General
         ColumnHidden:    False
         ColumnOrder:     Default
         ColumnWidth:     Default
         DataUpdatable:   False
         DecimalPlaces:   Auto
         Description:     HM Forces Rank of Applicant (if applicable) - cross-reference to control
         table
         DisplayControl:          Text Box
         OrdinalPosition:         7
         Required:        False
         SourceField:     RankID
         SourceTable:     CSAPPLICANT
         SpecialAdviser   Yes/No   1
         AllowZeroLength:         False
         Attributes:      Fixed Size
         CollatingOrder:          General
         ColumnHidden:    False
         ColumnOrder:     Default
         ColumnWidth:     Default
         DataUpdatable:   False
         Description:     Is/was the Applicant a Special Adviser?
         DisplayControl:          106
         Format:          Yes/No
         OrdinalPosition:         8
         Required:        False
         SourceField:     SpecialAdviser
         SourceTable:     CSAPPLICANT
         StatutoryOfficeHolder    Yes/No   1
         AllowZeroLength:         False
         Attributes:      Fixed Size
         CollatingOrder:          General
         ColumnHidden:    False
         ColumnOrder:     Default
         ColumnWidth:     Default
         DataUpdatable:   False
         Description:     Is/was the Applicant a Statutory Office Holder?
         DisplayControl:          106
         Format:          Yes/No
         OrdinalPosition:         9
         Required:        False
         SourceField:     StatutoryOfficeHolder
         SourceTable:     CSAPPLICANT


Table: CSAPPLICANT       Page: 4
         GradeCategoryID  Long Integer     4
         AllowZeroLength:         False
         Attributes:      Fixed Size
         CollatingOrder:          General
         ColumnHidden:    False
         ColumnOrder:     Default
         ColumnWidth:     Default
         DataUpdatable:   False
         DecimalPlaces:   Auto
         Description:     Grade Category of Applicant (if applicable) - cross-reference to control
         table
         DisplayControl:          Text Box
         OrdinalPosition:         10
         Required:        False
         SourceField:     GradeCategoryID
         SourceTable:     CSAPPLICANT
         PostTitle        Text     50
         AllowZeroLength:         False
         Attributes:      Variable Length
         CollatingOrder:          General
         ColumnHidden:    False
         ColumnOrder:     Default
         ColumnWidth:     Default
         DataUpdatable:   False
         Description:     Title of Post held by Applicant as a Crown Servant
         DisplayControl:          Text Box
         OrdinalPosition:         11
         Required:        False
         SourceField:     PostTitle
         SourceTable:     CSAPPLICANT
         ReasonForLeavingID       Long Integer     4
         AllowZeroLength:         False
         Attributes:      Fixed Size
         CollatingOrder:          General
         ColumnHidden:    False
         ColumnOrder:     Default
         ColumnWidth:     Default
         DataUpdatable:   False
         DecimalPlaces:   Auto
         Description:     Reason for leaving Crown servant post - cross-reference to control table
         DisplayControl:          Text Box
         OrdinalPosition:         12
         Required:        False
         SourceField:     ReasonForLeavingID
         SourceTable:     CSAPPLICANT
         JESPmin  Integer  2
         AllowZeroLength:         False
         Attributes:      Fixed Size
         CollatingOrder:          General
         ColumnHidden:    False


Table: CSAPPLICANT       Page: 5
         ColumnOrder:     Default
         ColumnWidth:     Default
         DataUpdatable:   False
         DecimalPlaces:   Auto
         Description:     JESP score - minimum (numeric in range 7 to 28)
         DisplayControl:          Text Box
         OrdinalPosition:         13
         Required:        False
         SourceField:     JESPmin
         SourceTable:     CSAPPLICANT
         ValidationRule:          Between 7 And 28 Or Is Null
         ValidationText:          If present, JESP values must be between 7 and 28
         JESPmax  Integer  2
         AllowZeroLength:         False
         Attributes:      Fixed Size
         CollatingOrder:          General
         ColumnHidden:    False
         ColumnOrder:     Default
         ColumnWidth:     Default
         DataUpdatable:   False
         DecimalPlaces:   Auto
         Description:     JESP score - maximum (numeric in range 7 to 28)
         DisplayControl:          Text Box
         OrdinalPosition:         14
         Required:        False
         SourceField:     JESPmax
         SourceTable:     CSAPPLICANT
         ValidationRule:          Between 7 And 28 Or Is Null
         ValidationText:          If present, JESP values must be between 7 and 28
         JEGSmin  Integer  2
         AllowZeroLength:         False
         Attributes:      Fixed Size
         CollatingOrder:          General
         ColumnHidden:    False
         ColumnOrder:     Default
         ColumnWidth:     Default
         DataUpdatable:   False
         DecimalPlaces:   Auto
         Description:     JEGS score - minimum (numeric in range 0 to 720)
         DisplayControl:          Text Box
         OrdinalPosition:         15
         Required:        False
         SourceField:     JEGSmin
         SourceTable:     CSAPPLICANT
         ValidationRule:          Between 0 And 720 Or Is Null
         ValidationText:          If present, JEGS values must be between 0 and 720
         JEGSmax  Integer  2
         AllowZeroLength:         False
         Attributes:      Fixed Size
         CollatingOrder:          General
         ColumnHidden:    False
         ColumnOrder:     Default
         ColumnWidth:     Default


Table: CSAPPLICANT       Page: 6
         DataUpdatable:   False
         DecimalPlaces:   Auto
         Description:     JEGS score - maximum (numeric in range 0 to 720)
         DisplayControl:          Text Box
         OrdinalPosition:         16
         Required:        False
         SourceField:     JEGSmax
         SourceTable:     CSAPPLICANT
         ValidationRule:          Between 0 And 720 Or Is Null
         ValidationText:          If present, JEGS values must be between 0 and 720
         LastDayInPost    Date/Time        8
         AllowZeroLength:         False
         Attributes:      Fixed Size
         CollatingOrder:          General
         ColumnHidden:    False
         ColumnOrder:     Default
         ColumnWidth:     Default
         DataUpdatable:   False
         Description:     Last day in post (date)
         OrdinalPosition:         17
         Required:        False
         SourceField:     LastDayInPost
         SourceTable:     CSAPPLICANT
         LastDayOfService         Date/Time        8
         AllowZeroLength:         False
         Attributes:      Fixed Size
         CollatingOrder:          General
         ColumnHidden:    False
         ColumnOrder:     Default
         ColumnWidth:     Default
         DataUpdatable:   False
         Description:     Last day of service (date)
         OrdinalPosition:         18
         Required:        False
         SourceField:     LastDayOfService
         SourceTable:     CSAPPLICANT
         apname   Text     255
         AllowZeroLength:         False
         Attributes:      Variable Length
         CollatingOrder:          General
         ColumnHidden:    False
         ColumnOrder:     Default
         ColumnWidth:     Default
         DataUpdatable:   False
         Description:     THIS FIELD IS FROM THE OLD SYSTEM
         DisplayControl:          Text Box
         OrdinalPosition:         19
         Required:        False
         SourceField:     apname
         SourceTable:     CSAPPLICANT
         apgrade  Text     255
         AllowZeroLength:         False


Table: CSAPPLICANT       Page: 7
         Attributes:      Variable Length
         CollatingOrder:          General
         ColumnHidden:    False
         ColumnOrder:     Default
         ColumnWidth:     Default
         DataUpdatable:   False
         Description:     THIS FIELD IS FROM THE OLD SYSTEM
         DisplayControl:          Text Box
         OrdinalPosition:         20
         Required:        False
         SourceField:     apgrade
         SourceTable:     CSAPPLICANT
         apgrade_desc     Text     255
         AllowZeroLength:         False
         Attributes:      Variable Length
         CollatingOrder:          General
         ColumnHidden:    False
         ColumnOrder:     Default
         ColumnWidth:     Default
         DataUpdatable:   False
         Description:     THIS FIELD IS FROM THE OLD SYSTEM
         DisplayControl:          Text Box
         OrdinalPosition:         21
         Required:        False
         SourceField:     apgrade_desc
         SourceTable:     CSAPPLICANT
         paperRecord      Yes/No   1
         AllowZeroLength:         False
         Attributes:      Fixed Size
         CollatingOrder:          General
         ColumnHidden:    False
         ColumnOrder:     Default
         ColumnWidth:     Default
         DataUpdatable:   False
         Description:     Paper Record exists for this applicant
         DisplayControl:          106
         Format:          Yes/No
         OrdinalPosition:         22
         Required:        False
         SourceField:     paperRecord
         SourceTable:     CSAPPLICANT
         Relationships
         GovernmentDepartmentCSAPPLICANT
         GovernmentDepartmen      CSAPPLICANT
         DepartmentID     1        ¥         DepartmentID
         Attributes:      Enforced, Right Join
         RelationshipType:        One-To-Many


Table: CSAPPLICANT       Page: 8
         GradeCategoryCSAPPLICANT
         GradeCategory    CSAPPLICANT
         GradeCategoryID  1        ¥         GradeCategoryID
         Attributes:      Enforced, Right Join
         RelationshipType:        One-To-Many
         RankCSAPPLICANT
         Rank     CSAPPLICANT
         RankID   1        ¥         RankID
         Attributes:      Enforced, Right Join
         RelationshipType:        One-To-Many
         CSAPPLICANTCSAPPLICATION
         CSAPPLICANT      CSAPPLICATION
         ApplicantID      1        ¥         ApplicantID
         Attributes:      Enforced, Cascade Updates, Cascade Deletes
         RelationshipType:        One-To-Many
         CSReasonForLeavingCSAPPLICANT
         CSReasonForLeaving       CSAPPLICANT
         CSReasonForLeavingID     1        ¥         ReasonForLeavingID
         Attributes:      Enforced, Right Join
         RelationshipType:        One-To-Many
         Table Indexes
         Name     Number of Fields
         367393E9-5BA6-4E6B-91CB-         1
         Clustered:       False
         DistinctCount:   102
         Foreign:         True
         IgnoreNulls:     False
         Name:    367393E9-5BA6-4E6B-91CB-C53B87343C0D
         Primary:         False
         Required:        False
         Unique:          False


Table: CSAPPLICANT       Page: 9
         Fields:
         DepartmentID     Ascending
         67F37F08-6FA3-45DF-9C52-         1
         Clustered:       False
         DistinctCount:   7
         Foreign:         True
         IgnoreNulls:     False
         Name:    67F37F08-6FA3-45DF-9C52-B520F1CE4916
         Primary:         False
         Required:        False
         Unique:          False
         Fields:
         GradeCategoryID  Ascending
         69AC7617-1FCB-4577-AD0F-         1
         Clustered:       False
         DistinctCount:   29
         Foreign:         True
         IgnoreNulls:     False
         Name:    69AC7617-1FCB-4577-AD0F-00B15B43E873
         Primary:         False
         Required:        False
         Unique:          False
         Fields:
         RankID   Ascending
         D4B41D32-98D4-49E6-B98A-         1
         Clustered:       False
         DistinctCount:   12
         Foreign:         True
         IgnoreNulls:     False
         Name:    D4B41D32-98D4-49E6-B98A-9C5E5525E4A7
         Primary:         False
         Required:        False
         Unique:          False
         Fields:
         ReasonForLeavingID       Ascending
         Department       1
         Clustered:       False
         DistinctCount:   102
         Foreign:         False
         IgnoreNulls:     False
         Name:    Department
         Primary:         False
         Required:        False
         Unique:          False
         Fields:
         DepartmentID     Ascending
         GradeCategory    1
         Clustered:       False
         DistinctCount:   7
         Foreign:         False
         IgnoreNulls:     False
         Name:    GradeCategory
         Primary:         False


Table: CSAPPLICANT       Page: 10
         Required:        False
         Unique:          False
         Fields:
         GradeCategoryID  Ascending
         PrimaryKey       1
         Clustered:       False
         DistinctCount:   2180
         Foreign:         False
         IgnoreNulls:     False
         Name:    PrimaryKey
         Primary:         True
         Required:        True
         Unique:          True
         Fields:
         ApplicantID      Ascending
         Rank     1
         Clustered:       False
         DistinctCount:   29
         Foreign:         False
         IgnoreNulls:     False
         Name:    Rank
         Primary:         False
         Required:        False
         Unique:          False
         Fields:
         RankID   Ascending
         ReasonForLeaving         1
         Clustered:       False
         DistinctCount:   12
         Foreign:         False
         IgnoreNulls:     False
         Name:    ReasonForLeaving
         Primary:         False
         Required:        False
         Unique:          False
         Fields:
         ReasonForLeavingID       Ascending
         User Permissions
         admin
         Group Permissions
         Admins
         Users    Delete, Read Permissions, Set Permissions, Change Owner, Read Definition, Write
         Definition, Read Data, Insert Data, Update Data, Delete Data


Table: CSAPPLICATION     Page: 11        
         Columns
         Name     Type     Size
         recordID         Long Integer     4
         AllowZeroLength:         False
         Attributes:      Fixed Size, Auto-Increment
         CollatingOrder:          General
         ColumnHidden:    False
         ColumnOrder:     Default
         ColumnWidth:     Default
         DataUpdatable:   False
         OrdinalPosition:         0
         Required:        False
         SourceField:     recordID
         SourceTable:     CSAPPLICATION
         ApplicantID      Long Integer     4
         AllowZeroLength:         False
         Attributes:      Fixed Size
         CollatingOrder:          General
         ColumnHidden:    False
         ColumnOrder:     Default
         ColumnWidth:     Default
         DataUpdatable:   False
         DecimalPlaces:   Auto
         Description:     Cross-reference to CSAPPLICANTS table
         DisplayControl:          Text Box
         OrdinalPosition:         1
         Required:        False
         SourceField:     ApplicantID
         SourceTable:     CSAPPLICATION
         ApplicationID    Byte     1
         AllowZeroLength:         False
         Attributes:      Fixed Size
         CollatingOrder:          General
         ColumnHidden:    False
         ColumnOrder:     Default
         ColumnWidth:     Default
         DataUpdatable:   False
         DecimalPlaces:   Auto
         Description:     Starts at 1 for each Applicant
         DisplayControl:          Text Box
         OrdinalPosition:         2
         Required:        False
         SourceField:     ApplicationID
         SourceTable:     CSAPPLICATION


Table: CSAPPLICATION     Page: 12
         DateReceived     Date/Time        8
         AllowZeroLength:         False
         Attributes:      Fixed Size
         CollatingOrder:          General
         ColumnHidden:    False
         ColumnOrder:     Default
         ColumnWidth:     1470
         DataUpdatable:   False
         Description:     Date Application Received in division
         OrdinalPosition:         3
         Required:        True
         SourceField:     DateReceived
         SourceTable:     CSAPPLICATION
         DateReferredG7_5         Date/Time        8
         AllowZeroLength:         False
         Attributes:      Fixed Size
         CollatingOrder:          General
         ColumnHidden:    False
         ColumnOrder:     Default
         ColumnWidth:     1830
         DataUpdatable:   False
         Description:     Date Application referred to G7/5 for decision
         OrdinalPosition:         4
         Required:        False
         SourceField:     DateReferredG7_5
         SourceTable:     CSAPPLICATION
         DateReferredB2   Date/Time        8
         AllowZeroLength:         False
         Attributes:      Fixed Size
         CollatingOrder:          General
         ColumnHidden:    False
         ColumnOrder:     Default
         ColumnWidth:     Default
         DataUpdatable:   False
         Description:     Date Application referred to B2
         Format:          dd/mmm/yyyy
         OrdinalPosition:         5
         Required:        False
         SourceField:     DateReferredB2
         SourceTable:     CSAPPLICATION
         DateReferredHOCS         Date/Time        8
         AllowZeroLength:         False
         Attributes:      Fixed Size
         CollatingOrder:          General
         ColumnHidden:    False
         ColumnOrder:     Default
         ColumnWidth:     1965
         DataUpdatable:   False
         Description:     Date Application referred to Head of Civil Service for decision
         OrdinalPosition:         6
         Required:        False
         SourceField:     DateReferredHOCS
         SourceTable:     CSAPPLICATION


Table: CSAPPLICATION     Page: 13
         Queried  Yes/No   1
         AllowZeroLength:         False
         Attributes:      Fixed Size
         CollatingOrder:          General
         ColumnHidden:    False
         ColumnOrder:     Default
         ColumnWidth:     Default
         DataUpdatable:   False
         Description:     Has this application bee queried
         DisplayControl:          106
         Format:          Yes/No
         OrdinalPosition:         7
         Required:        False
         SourceField:     Queried
         SourceTable:     CSAPPLICATION
         ReferredToACOBA  Text     3
         AllowZeroLength:         False
         Attributes:      Variable Length
         CollatingOrder:          General
         ColumnHidden:    False
         ColumnOrder:     Default
         ColumnWidth:     1905
         DataUpdatable:   False
         Description:     Was this application referred to ACOBA? (Yes, No or Null)
         DisplayControl:          Text Box
         OrdinalPosition:         8
         Required:        False
         SourceField:     ReferredToACOBA
         SourceTable:     CSAPPLICATION
         ValidationRule:          "Yes" Or "No" Or Is Null
         ValidationText:          Referred To ACOBA must be Yes, No or Null
         DateReferredACOBA        Date/Time        8
         AllowZeroLength:         False
         Attributes:      Fixed Size
         CollatingOrder:          General
         ColumnHidden:    False
         ColumnOrder:     Default
         ColumnWidth:     2100
         DataUpdatable:   False
         Description:     Date Application referred to ACOBA for advice
         OrdinalPosition:         9
         Required:        False
         SourceField:     DateReferredACOBA
         SourceTable:     CSAPPLICATION
         AppointmentAccepted      Text     1
         AllowZeroLength:         False
         Attributes:      Variable Length
         CollatingOrder:          General
         ColumnHidden:    False
         ColumnOrder:     Default
         ColumnWidth:     2250
         DataUpdatable:   False
         Description:     Appointment Taken Up? - "Y", "N" or "U" (not known)


Table: CSAPPLICATION     Page: 14
         DisplayControl:          Text Box
         OrdinalPosition:         10
         Required:        False
         SourceField:     AppointmentAccepted
         SourceTable:     CSAPPLICATION
         ValidationRule:          "Y" Or "N" Or "U" Or Is Null
         ValidationText:          Appointment Accepted must be "Y", "N" or "U"
         DateTakenUp      Date/Time        8
         AllowZeroLength:         False
         Attributes:      Fixed Size
         CollatingOrder:          General
         ColumnHidden:    False
         ColumnOrder:     Default
         ColumnWidth:     Default
         DataUpdatable:   False
         Description:     Date appointment taken up
         OrdinalPosition:         11
         Required:        False
         SourceField:     DateTakenUp
         SourceTable:     CSAPPLICATION
         AnnouncementMade         Text     1
         AllowZeroLength:         False
         Attributes:      Variable Length
         CollatingOrder:          General
         ColumnHidden:    False
         ColumnOrder:     Default
         ColumnWidth:     2115
         DataUpdatable:   False
         Description:     Announcement made? - "Y", "N" or "U" (not known)
         DisplayControl:          Text Box
         OrdinalPosition:         12
         Required:        False
         SourceField:     AnnouncementMade
         SourceTable:     CSAPPLICATION
         ValidationRule:          "Y" Or "N" Or "U" Or Is Null
         ValidationText:          Announcement must be "Y", "N" or "U"
         _DateToDepartmentOLD     Date/Time        8
         AllowZeroLength:         False
         Attributes:      Fixed Size
         CollatingOrder:          General
         ColumnHidden:    False
         ColumnOrder:     Default
         ColumnWidth:     Default
         DataUpdatable:   False
         Description:     ***** DUE TO BE REMOVED ********
         OrdinalPosition:         13
         Required:        False
         SourceField:     _DateToDepartmentOLD
         SourceTable:     CSAPPLICATION
         DateReferredPM   Date/Time        8
         AllowZeroLength:         False
         Attributes:      Fixed Size


Table: CSAPPLICATION     Page: 15
         CollatingOrder:          General
         ColumnHidden:    False
         ColumnOrder:     Default
         ColumnWidth:     1710
         DataUpdatable:   False
         Description:     Date Application referred to Prime Minister for decision
         OrdinalPosition:         14
         Required:        False
         SourceField:     DateReferredPM
         SourceTable:     CSAPPLICATION
         DateCompleted    Date/Time        8
         AllowZeroLength:         False
         Attributes:      Fixed Size
         CollatingOrder:          General
         ColumnHidden:    False
         ColumnOrder:     Default
         ColumnWidth:     1620
         DataUpdatable:   False
         Description:     Date action completed/department notified
         OrdinalPosition:         15
         Required:        False
         SourceField:     DateCompleted
         SourceTable:     CSAPPLICATION
         _WorkingDaysToCompleteOLD        Integer  2
         AllowZeroLength:         False
         Attributes:      Fixed Size
         CollatingOrder:          General
         ColumnHidden:    False
         ColumnOrder:     Default
         ColumnWidth:     1380
         DataUpdatable:   False
         DecimalPlaces:   Auto
         Description:     Estimated number of working days to compete the Application
         DisplayControl:          Text Box
         OrdinalPosition:         16
         Required:        False
         SourceField:     _WorkingDaysToCompleteOLD
         SourceTable:     CSAPPLICATION
         IndependentConsultant    Yes/No   1
         AllowZeroLength:         False
         Attributes:      Fixed Size
         CollatingOrder:          General
         ColumnHidden:    False
         ColumnOrder:     Default
         ColumnWidth:     2355
         DataUpdatable:   False
         Description:     Independent Consultant (Yes/No)
         DisplayControl:          106
         Format:          Yes/No
         OrdinalPosition:         17
         Required:        False
         SourceField:     IndependentConsultant
         SourceTable:     CSAPPLICATION


Table: CSAPPLICATION     Page: 16
         NewEmployerName  Text     60
         AllowZeroLength:         False
         Attributes:      Variable Length
         CollatingOrder:          General
         ColumnHidden:    False
         ColumnOrder:     Default
         ColumnWidth:     2025
         DataUpdatable:   False
         Description:     New Employer or Client name
         DisplayControl:          Text Box
         OrdinalPosition:         18
         Required:        True
         SourceField:     NewEmployerName
         SourceTable:     CSAPPLICATION
         NatureOfBusinessID       Long Integer     4
         AllowZeroLength:         False
         Attributes:      Fixed Size
         CollatingOrder:          General
         ColumnHidden:    False
         ColumnOrder:     Default
         ColumnWidth:     2010
         DataUpdatable:   False
         DecimalPlaces:   Auto
         Description:     Nature of Business of New Employer or Client- cross-reference to control
         table
         DisplayControl:          Text Box
         OrdinalPosition:         19
         Required:        False
         SourceField:     NatureOfBusinessID
         SourceTable:     CSAPPLICATION
         NatureOfJobID    Long Integer     4
         AllowZeroLength:         False
         Attributes:      Fixed Size
         CollatingOrder:          General
         ColumnHidden:    False
         ColumnOrder:     Default
         ColumnWidth:     1530
         DataUpdatable:   False
         DecimalPlaces:   Auto
         Description:     Nature of new Job - cross-reference to control table
         DisplayControl:          Text Box
         OrdinalPosition:         20
         Required:        False
         SourceField:     NatureOfJobID
         SourceTable:     CSAPPLICATION
         AmbassadorVisiting       Text     3
         AllowZeroLength:         False
         Attributes:      Variable Length
         CollatingOrder:          General
         ColumnHidden:    False
         ColumnOrder:     Default
         ColumnWidth:     2025


Table: CSAPPLICATION     Page: 17
         DataUpdatable:   False
         Description:     Ambassador, visiting/working in country of last posting? (Yes/No)
         DisplayControl:          Text Box
         OrdinalPosition:         21
         Required:        False
         SourceField:     AmbassadorVisiting
         SourceTable:     CSAPPLICATION
         ValidationRule:          "Yes" Or "No" Or Is Null
         AmbassadorAdvice         Text     3
         AllowZeroLength:         False
         Attributes:      Variable Length
         CollatingOrder:          General
         ColumnHidden:    False
         ColumnOrder:     Default
         ColumnWidth:     1965
         DataUpdatable:   False
         Description:     Ambassador, providing advice/analysis on country of last posting?
         (Yes/No)
         DisplayControl:          Text Box
         OrdinalPosition:         22
         Required:        False
         SourceField:     AmbassadorAdvice
         SourceTable:     CSAPPLICATION
         ValidationRule:          "Yes" Or "No" Or Is Null
         Paid     Text     3
         AllowZeroLength:         False
         Attributes:      Variable Length
         CollatingOrder:          General
         ColumnHidden:    False
         ColumnOrder:     Default
         ColumnWidth:     585
         DataUpdatable:   False
         Description:     Whether Paid or not - Yes/No/IC (IC=Independent Consultant)
         DisplayControl:          Text Box
         OrdinalPosition:         23
         Required:        False
         SourceField:     Paid
         SourceTable:     CSAPPLICATION
         ValidationText:          Paid must be Yes, No or IC
         Hours    Text     2
         AllowZeroLength:         False
         Attributes:      Variable Length
         CollatingOrder:          General
         ColumnHidden:    False
         ColumnOrder:     Default
         ColumnWidth:     690
         DataUpdatable:   False
         Description:     Hours ("FT" or "PT)
         DisplayControl:          Text Box
         OrdinalPosition:         24
         Required:        False
         SourceField:     Hours


Table: CSAPPLICATION     Page: 18
         SourceTable:     CSAPPLICATION
         ValidationRule:          "FT" Or "PT" Or Is Null
         ValidationText:          Hours must be FT or PT
         DirectContact    Yes/No   1
         AllowZeroLength:         False
         Attributes:      Fixed Size
         CollatingOrder:          General
         ColumnHidden:    False
         ColumnOrder:     Default
         ColumnWidth:     1425
         DataUpdatable:   False
         Description:     Direct Contractual Contact
         DisplayControl:          106
         Format:          Yes/No
         OrdinalPosition:         25
         Required:        False
         SourceField:     DirectContact
         SourceTable:     CSAPPLICATION
         IndirectContact  Text     3
         AllowZeroLength:         False
         Attributes:      Variable Length
         CollatingOrder:          General
         ColumnHidden:    False
         ColumnOrder:     Default
         ColumnWidth:     1590
         DataUpdatable:   False
         Description:     Indirect Contractual Contact - Yes/No or Null
         DisplayControl:          Text Box
         OrdinalPosition:         26
         Required:        False
         SourceField:     IndirectContact
         SourceTable:     CSAPPLICATION
         NumberOfContracts        Byte     1
         AllowZeroLength:         False
         Attributes:      Fixed Size
         CollatingOrder:          General
         ColumnHidden:    False
         ColumnOrder:     Default
         ColumnWidth:     1995
         DataUpdatable:   False
         DecimalPlaces:   Auto
         Description:     Number of Contracts
         DisplayControl:          Text Box
         OrdinalPosition:         27
         Required:        False
         SourceField:     NumberOfContracts
         SourceTable:     CSAPPLICATION
         econvalue        Text     50
         AllowZeroLength:         False
         Attributes:      Variable Length
         CollatingOrder:          General
         ColumnHidden:    False


Table: CSAPPLICATION     Page: 19
         ColumnOrder:     Default
         ColumnWidth:     Default
         DataUpdatable:   False
         Description:     THIS FIELD IS FROM THE OLD SYSTEM
         DisplayControl:          Text Box
         OrdinalPosition:         28
         Required:        False
         SourceField:     econvalue
         SourceTable:     CSAPPLICATION
         ContractValue    Double   8
         AllowZeroLength:         False
         Attributes:      Fixed Size
         CollatingOrder:          General
         ColumnHidden:    False
         ColumnOrder:     Default
         ColumnWidth:     1500
         DataUpdatable:   False
         DecimalPlaces:   Auto
         Description:     Total value of Contract(s) in £
         DisplayControl:          Text Box
         OrdinalPosition:         29
         Required:        False
         SourceField:     ContractValue
         SourceTable:     CSAPPLICATION
         NonContractualContact    Text     3
         AllowZeroLength:         False
         Attributes:      Variable Length
         CollatingOrder:          General
         ColumnHidden:    False
         ColumnOrder:     Default
         ColumnWidth:     2340
         DataUpdatable:   False
         Description:     Non-contractual Contact - Yes/No or Null
         DisplayControl:          Text Box
         OrdinalPosition:         30
         Required:        False
         SourceField:     NonContractualContact
         SourceTable:     CSAPPLICATION
         RegulatoryContact        Yes/No   1
         AllowZeroLength:         False
         Attributes:      Fixed Size
         CollatingOrder:          General
         ColumnHidden:    False
         ColumnOrder:     Default
         ColumnWidth:     1905
         DataUpdatable:   False
         Description:     Regulatory Contract? (Yes/No)
         DisplayControl:          106
         Format:          Yes/No
         OrdinalPosition:         31
         Required:        False
         SourceField:     RegulatoryContact
         SourceTable:     CSAPPLICATION


Table: CSAPPLICATION     Page: 20
         PrivatisationInvolvement         Yes/No   1
         AllowZeroLength:         False
         Attributes:      Fixed Size
         CollatingOrder:          General
         ColumnHidden:    False
         ColumnOrder:     Default
         ColumnWidth:     2505
         DataUpdatable:   False
         Description:     Privatisation Involvement? (Yes/No)
         DisplayControl:          106
         Format:          Yes/No
         OrdinalPosition:         32
         Required:        False
         SourceField:     PrivatisationInvolvement
         SourceTable:     CSAPPLICATION
         AccessToSecrets  Text     3
         AllowZeroLength:         False
         Attributes:      Variable Length
         CollatingOrder:          General
         ColumnHidden:    False
         ColumnOrder:     Default
         ColumnWidth:     1740
         DataUpdatable:   False
         Description:     Access to Trade Secrets? (Yes/No/Null)
         DisplayControl:          Text Box
         OrdinalPosition:         33
         Required:        False
         SourceField:     AccessToSecrets
         SourceTable:     CSAPPLICATION
         ConcernRewards   Yes/No   1
         AllowZeroLength:         False
         Attributes:      Fixed Size
         CollatingOrder:          General
         ColumnHidden:    False
         ColumnOrder:     Default
         ColumnWidth:     1770
         DataUpdatable:   False
         Description:     Cause for Concern - Rewards? (Yes/No)
         DisplayControl:          106
         Format:          Yes/No
         OrdinalPosition:         34
         Required:        False
         SourceField:     ConcernRewards
         SourceTable:     CSAPPLICATION
         ConcernSecrets   Yes/No   1
         AllowZeroLength:         False
         Attributes:      Fixed Size
         CollatingOrder:          General
         ColumnHidden:    False
         ColumnOrder:     Default
         ColumnWidth:     Default
         DataUpdatable:   False
         Description:     Cause for Concern - Trade Secrets? (Yes/No)


Table: CSAPPLICATION     Page: 21
         DisplayControl:          106
         Format:          Yes/No
         OrdinalPosition:         35
         Required:        False
         SourceField:     ConcernSecrets
         SourceTable:     CSAPPLICATION
         ConcernPolicy    Yes/No   1
         AllowZeroLength:         False
         Attributes:      Fixed Size
         CollatingOrder:          General
         ColumnHidden:    False
         ColumnOrder:     Default
         ColumnWidth:     Default
         DataUpdatable:   False
         Description:     Cause for Concern - Impending Policy? (Yes/No)
         DisplayControl:          106
         Format:          Yes/No
         OrdinalPosition:         36
         Required:        False
         SourceField:     ConcernPolicy
         SourceTable:     CSAPPLICATION
         ConcernPerception        Yes/No   1
         AllowZeroLength:         False
         Attributes:      Fixed Size
         CollatingOrder:          General
         ColumnHidden:    False
         ColumnOrder:     Default
         ColumnWidth:     Default
         DataUpdatable:   False
         Description:     Cause for Concern - Public Perception? (Yes/No)
         DisplayControl:          106
         Format:          Yes/No
         OrdinalPosition:         37
         Required:        False
         SourceField:     ConcernPerception
         SourceTable:     CSAPPLICATION
         ConcernOther     Yes/No   1
         AllowZeroLength:         False
         Attributes:      Fixed Size
         CollatingOrder:          General
         ColumnHidden:    False
         ColumnOrder:     Default
         ColumnWidth:     Default
         DataUpdatable:   False
         Description:     Cause for Concern - Other? (Yes/No)
         DisplayControl:          106
         Format:          Yes/No
         OrdinalPosition:         38
         Required:        False
         SourceField:     ConcernOther
         SourceTable:     CSAPPLICATION
         Comments         Memo     -


Table: CSAPPLICATION     Page: 22
         AllowZeroLength:         False
         Attributes:      Variable Length
         CollatingOrder:          General
         ColumnHidden:    False
         ColumnOrder:     Default
         ColumnWidth:     Default
         DataUpdatable:   False
         Description:     Comments by Office/HOHCS/ACOBA/PM - up to 64,000 characters
         OrdinalPosition:         39
         Required:        False
         SourceField:     Comments
         SourceTable:     CSAPPLICATION
         ApprovedUnconditionally  Text     3
         AllowZeroLength:         False
         Attributes:      Variable Length
         CollatingOrder:          General
         ColumnHidden:    False
         ColumnOrder:     Default
         ColumnWidth:     2550
         DataUpdatable:   False
         Description:     Application Approved Unconditionally?(inc. where automatic waiting
         period, if relevant, was waived or has expired)
         DisplayControl:          Text Box
         OrdinalPosition:         40
         Required:        False
         SourceField:     ApprovedUnconditionally
         SourceTable:     CSAPPLICATION
         AutoWaitApplies  Yes/No   1
         AllowZeroLength:         False
         Attributes:      Fixed Size
         CollatingOrder:          General
         ColumnHidden:    False
         ColumnOrder:     Default
         ColumnWidth:     1725
         DataUpdatable:   False
         Description:     Does the automatic waiting period apply to this Grade/Rank?
         DisplayControl:          106
         Format:          Yes/No
         OrdinalPosition:         41
         Required:        False
         SourceField:     AutoWaitApplies
         SourceTable:     CSAPPLICATION
         AutoWaitAction   Text     1
         AllowZeroLength:         False
         Attributes:      Variable Length
         CollatingOrder:          General
         ColumnHidden:    False
         ColumnOrder:     Default
         ColumnWidth:     Default
         DataUpdatable:   False
         Description:     Automatic waiting period: (A)pplied, (E)xpired, (L)engthened, (W)aived


Table: CSAPPLICATION     Page: 23
         DisplayControl:          Text Box
         OrdinalPosition:         42
         Required:        False
         SourceField:     AutoWaitAction
         SourceTable:     CSAPPLICATION
         ValidationRule:          "A" Or "E" Or "L" Or "W" Or Is Null
         ValidationText:          If present, Auto Wait must be A, E, L or W
         WaitingPeriodApplied     Yes/No   1
         AllowZeroLength:         False
         Attributes:      Fixed Size
         CollatingOrder:          General
         ColumnHidden:    False
         ColumnOrder:     Default
         ColumnWidth:     2250
         DataUpdatable:   False
         Description:     Waiting period applied? (including automatic waiting period, if relevant,
         applied)
         DisplayControl:          106
         Format:          Yes/No
         OrdinalPosition:         43
         Required:        False
         SourceField:     WaitingPeriodApplied
         SourceTable:     CSAPPLICATION
         WaitingPeriodLength      Byte     1
         AllowZeroLength:         False
         Attributes:      Fixed Size
         CollatingOrder:          General
         ColumnHidden:    False
         ColumnOrder:     Default
         ColumnWidth:     Default
         DataUpdatable:   False
         DecimalPlaces:   Auto
         Description:     Length of Waiting Period in months (including automatic waiting period, if
         relevant) (0 to 24 or 99 if dependent on other factors)
         DisplayControl:          Text Box
         OrdinalPosition:         44
         Required:        False
         SourceField:     WaitingPeriodLength
         SourceTable:     CSAPPLICATION
         ValidationRule:          Between 0 And 24 Or 99 Or Is Null
         ValidationText:          Waiting Period Length must be between 0 and 24 or 99 months
         BehaviouralConditionsApplied     Yes/No   1
         AllowZeroLength:         False
         Attributes:      Fixed Size
         CollatingOrder:          General
         ColumnHidden:    False
         ColumnOrder:     Default
         ColumnWidth:     3045
         DataUpdatable:   False
         Description:     Behavioural Conditions applied? (Yes/No)
         DisplayControl:          106


Table: CSAPPLICATION     Page: 24
         Format:          Yes/No
         OrdinalPosition:         45
         Required:        False
         SourceField:     BehaviouralConditionsApplied
         SourceTable:     CSAPPLICATION
         BehaviouralConditionNature       Memo     -
         AllowZeroLength:         True
         Attributes:      Variable Length
         CollatingOrder:          General
         ColumnHidden:    False
         ColumnOrder:     Default
         ColumnWidth:     Default
         DataUpdatable:   False
         Description:     Nature of Behavioural Condition applied - up to 255 characters
         OrdinalPosition:         46
         Required:        False
         SourceField:     BehaviouralConditionNature
         SourceTable:     CSAPPLICATION
         BehaviouralConditionLength       Byte     1
         AllowZeroLength:         False
         Attributes:      Fixed Size
         CollatingOrder:          General
         ColumnHidden:    False
         ColumnOrder:     Default
         ColumnWidth:     Default
         DataUpdatable:   False
         DecimalPlaces:   Auto
         Description:     Length of Behavioural Condition in months (0 to 24 or 99 if dependent on
         other factors)
         DisplayControl:          Text Box
         OrdinalPosition:         47
         Required:        False
         SourceField:     BehaviouralConditionLength
         SourceTable:     CSAPPLICATION
         ValidationRule:          Between 0 And 24 Or 99 Or Is Null
         ValidationText:          Behavioural Condition Length must be between 0 and 24 or 99 months
         ApplicationUnsuitable    Yes/No   1
         AllowZeroLength:         False
         Attributes:      Fixed Size
         CollatingOrder:          General
         ColumnHidden:    False
         ColumnOrder:     Default
         ColumnWidth:     Default
         DataUpdatable:   False
         Description:     Application considered Unsuitable (Yes/No)
         DisplayControl:          106
         Format:          Yes/No
         OrdinalPosition:         48
         Required:        False
         SourceField:     ApplicationUnsuitable
         SourceTable:     CSAPPLICATION


Table: CSAPPLICATION     Page: 25
         InternalQuarantine       Text     3
         AllowZeroLength:         False
         Attributes:      Variable Length
         CollatingOrder:          General
         ColumnHidden:    False
         ColumnOrder:     Default
         ColumnWidth:     Default
         DataUpdatable:   False
         Description:     Internal Quarantine? (Yes/No)
         DisplayControl:          Text Box
         OrdinalPosition:         49
         Required:        False
         SourceField:     InternalQuarantine
         SourceTable:     CSAPPLICATION
         ValidationRule:          "Yes" Or "No" Or Is Null
         QuarantineLength         Byte     1
         AllowZeroLength:         False
         Attributes:      Fixed Size
         CollatingOrder:          General
         ColumnHidden:    False
         ColumnOrder:     Default
         ColumnWidth:     Default
         DataUpdatable:   False
         DecimalPlaces:   Auto
         Description:     Length of Internal Quarantine in months
         DisplayControl:          Text Box
         OrdinalPosition:         50
         Required:        False
         SourceField:     QuarantineLength
         SourceTable:     CSAPPLICATION
         ValidationRule:          Between 0 And 24 Or Is Null
         ValidationText:          Length of Internal Quarantine must be between 0 and 24 months
         Precedents       Text     50
         AllowZeroLength:         False
         Attributes:      Variable Length
         CollatingOrder:          General
         ColumnHidden:    False
         ColumnOrder:     Default
         ColumnWidth:     Default
         DataUpdatable:   False
         Description:     Precedents used for this application (Applicant ID numbers, free text)
         DisplayControl:          Text Box
         OrdinalPosition:         51
         Required:        False
         SourceField:     Precedents
         SourceTable:     CSAPPLICATION
         FollowUp         Text     3
         AllowZeroLength:         False
         Attributes:      Variable Length
         CollatingOrder:          General
         ColumnHidden:    False
         ColumnOrder:     Default
         ColumnWidth:     Default


Table: CSAPPLICATION     Page: 26
         DataUpdatable:   False
         Description:     Outcome to be followed up by department? (Yes/No)
         DisplayControl:          Text Box
         OrdinalPosition:         52
         Required:        False
         SourceField:     FollowUp
         SourceTable:     CSAPPLICATION
         ValidationRule:          "Yes" Or "No" Or Is Null
         OpsRecommendationFollowed        Yes/No   1
         AllowZeroLength:         False
         Attributes:      Fixed Size
         CollatingOrder:          General
         ColumnHidden:    False
         ColumnOrder:     Default
         ColumnWidth:     Default
         DataUpdatable:   False
         Description:     OPS Recommendation followed? (Yes/No)
         DisplayControl:          106
         Format:          Yes/No
         OrdinalPosition:         53
         Required:        False
         SourceField:     OpsRecommendationFollowed
         SourceTable:     CSAPPLICATION
         PMAgrees         Text     3
         AllowZeroLength:         False
         Attributes:      Variable Length
         CollatingOrder:          General
         ColumnHidden:    False
         ColumnOrder:     Default
         ColumnWidth:     Default
         DataUpdatable:   False
         Description:     PM's/S of S decision is the same as ACOBA's advice? (Yes/No)
         DisplayControl:          Text Box
         OrdinalPosition:         54
         Required:        False
         SourceField:     PMAgrees
         SourceTable:     CSAPPLICATION
         ValidationRule:          "Yes" Or "No" Or Is Null
         PMAgreesReason   Text     255
         AllowZeroLength:         False
         Attributes:      Variable Length
         CollatingOrder:          General
         ColumnHidden:    False
         ColumnOrder:     Default
         ColumnWidth:     Default
         DataUpdatable:   False
         Description:     If PM/S of S does not agree, why - up to 255 characters
         DisplayControl:          Text Box
         OrdinalPosition:         55
         Required:        False
         SourceField:     PMAgreesReason
         SourceTable:     CSAPPLICATION


Table: CSAPPLICATION     Page: 27
         ExpectedStart    Date/Time        8
         AllowZeroLength:         False
         Attributes:      Fixed Size
         CollatingOrder:          General
         ColumnHidden:    False
         ColumnOrder:     Default
         ColumnWidth:     Default
         DataUpdatable:   False
         Description:     Date appointment expected to start
         OrdinalPosition:         56
         Required:        False
         SourceField:     ExpectedStart
         SourceTable:     CSAPPLICATION
         _OLDreportComment1       Memo     -
         AllowZeroLength:         False
         Attributes:      Variable Length
         CollatingOrder:          General
         ColumnHidden:    False
         ColumnOrder:     Default
         ColumnWidth:     Default
         DataUpdatable:   False
         Description:     *** No Longer Used *** Comments for end of year reports
         OrdinalPosition:         57
         Required:        False
         SourceField:     _OLDreportComment1
         SourceTable:     CSAPPLICATION
         Relationships
         NatureOfBusinessCSAPPLICATION
         NatureOfBusiness         CSAPPLICATION
         NatureOfBusinessID       1        ¥         NatureOfBusinessID
         Attributes:      Enforced, Right Join
         RelationshipType:        One-To-Many
         NatureOfJobCSAPPLICATION
         NatureOfJob      CSAPPLICATION
         NatureOfJobID    1        ¥         NatureOfJobID
         Attributes:      Enforced, Right Join
         RelationshipType:        One-To-Many


Table: CSAPPLICATION     Page: 28
         CSAPPLICANTCSAPPLICATION
         CSAPPLICANT      CSAPPLICATION
         ApplicantID      1        ¥         ApplicantID
         Attributes:      Enforced, Cascade Updates, Cascade Deletes
         RelationshipType:        One-To-Many
         Table Indexes
         Name     Number of Fields
         0CC647FC-6DA3-497E-9BE6-         1
         Clustered:       False
         DistinctCount:   22
         Foreign:         True
         IgnoreNulls:     False
         Name:    0CC647FC-6DA3-497E-9BE6-47E305E90337
         Primary:         False
         Required:        False
         Unique:          False
         Fields:
         NatureOfBusinessID       Ascending
         3174F0F2-9662-4C50-A751-         1
         Clustered:       False
         DistinctCount:   312
         Foreign:         True
         IgnoreNulls:     False
         Name:    3174F0F2-9662-4C50-A751-9EB8664CD33B
         Primary:         False
         Required:        False
         Unique:          False
         Fields:
         NatureOfJobID    Ascending
         92D131CE-2A68-487A-BF04-         1
         Clustered:       False
         DistinctCount:   2179
         Foreign:         True
         IgnoreNulls:     False
         Name:    92D131CE-2A68-487A-BF04-2A7ECCA3E336
         Primary:         False
         Required:        False
         Unique:          False
         Fields:
         ApplicantID      Ascending
         Application      2
         Clustered:       False
         DistinctCount:   4098
         Foreign:         False
         IgnoreNulls:     False
         Name:    Application
         Primary:         False


Table: CSAPPLICATION     Page: 29
         Required:        False
         Unique:          True
         Fields:
         ApplicantID      Ascending
         ApplicationID    Ascending
         NatureOfBusiness         1
         Clustered:       False
         DistinctCount:   22
         Foreign:         False
         IgnoreNulls:     False
         Name:    NatureOfBusiness
         Primary:         False
         Required:        False
         Unique:          False
         Fields:
         NatureOfBusinessID       Ascending
         NatureOfJob      1
         Clustered:       False
         DistinctCount:   312
         Foreign:         False
         IgnoreNulls:     False
         Name:    NatureOfJob
         Primary:         False
         Required:        False
         Unique:          False
         Fields:
         NatureOfJobID    Ascending
         NumberOfContracts        1
         Clustered:       False
         DistinctCount:   12
         Foreign:         False
         IgnoreNulls:     False
         Name:    NumberOfContracts
         Primary:         False
         Required:        False
         Unique:          False
         Fields:
         NumberOfContracts        Ascending
         Paid     1
         Clustered:       False
         DistinctCount:   5
         Foreign:         False
         IgnoreNulls:     False
         Name:    Paid
         Primary:         False
         Required:        False
         Unique:          False
         Fields:
         Paid     Ascending
         PrimaryKey       1
         Clustered:       False
         DistinctCount:   4098
         Foreign:         False


Table: CSAPPLICATION     Page: 30
         IgnoreNulls:     False
         Name:    PrimaryKey
         Primary:         True
         Required:        True
         Unique:          True
         Fields:
         recordID         Ascending
         User Permissions
         admin
         Group Permissions
         Admins
         Users    Delete, Read Permissions, Set Permissions, Change Owner, Read Definition, Write
         Definition, Read Data, Insert Data, Update Data, Delete Data


Table: CSQueryDefinition         Page: 31
         Columns
         Name     Type     Size
         QueryID  Long Integer     4
         AllowZeroLength:         False
         Attributes:      Fixed Size, Auto-Increment
         CollatingOrder:          General
         ColumnHidden:    False
         ColumnOrder:     1
         ColumnWidth:     Default
         DataUpdatable:   False
         OrdinalPosition:         0
         Required:        False
         SourceField:     QueryID
         SourceTable:     CSQueryDefinition
         UserQuery        Yes/No   1
         AllowZeroLength:         False
         Attributes:      Fixed Size
         CollatingOrder:          General
         ColumnHidden:    False
         ColumnOrder:     Default
         ColumnWidth:     Default
         DataUpdatable:   False
         DisplayControl:          106
         Format:          Yes/No
         OrdinalPosition:         1
         Required:        False
         SourceField:     UserQuery
         SourceTable:     CSQueryDefinition
         QueryName        Text     64
         AllowZeroLength:         False
         Attributes:      Variable Length
         CollatingOrder:          General
         ColumnHidden:    False
         ColumnOrder:     Default
         ColumnWidth:     3465
         DataUpdatable:   False
         Description:     (ONLY if UserQuery = True) Name of Query exactly as saved in the
         database
         DisplayControl:          Text Box
         OrdinalPosition:         2
         Required:        False
         SourceField:     QueryName
         SourceTable:     CSQueryDefinition


Table: CSQueryDefinition         Page: 32
         QueryFileName    Text     50
         AllowZeroLength:         False
         Attributes:      Variable Length
         CollatingOrder:          General
         ColumnHidden:    False
         ColumnOrder:     Default
         ColumnWidth:     Default
         DataUpdatable:   False
         DisplayControl:          Text Box
         OrdinalPosition:         3
         Required:        False
         SourceField:     QueryFileName
         SourceTable:     CSQueryDefinition
         QueryField       Text     255
         AllowZeroLength:         False
         Attributes:      Variable Length
         CollatingOrder:          General
         ColumnHidden:    False
         ColumnOrder:     Default
         ColumnWidth:     2700
         DataUpdatable:   False
         DisplayControl:          Text Box
         OrdinalPosition:         4
         Required:        False
         SourceField:     QueryField
         SourceTable:     CSQueryDefinition
         QueryFunction    Text     255
         AllowZeroLength:         False
         Attributes:      Variable Length
         CollatingOrder:          General
         ColumnHidden:    False
         ColumnOrder:     Default
         ColumnWidth:     Default
         DataUpdatable:   False
         DisplayControl:          Text Box
         OrdinalPosition:         5
         Required:        False
         SourceField:     QueryFunction
         SourceTable:     CSQueryDefinition
         Parameter1       Text     255
         AllowZeroLength:         False
         Attributes:      Variable Length
         CollatingOrder:          General
         ColumnHidden:    False
         ColumnOrder:     Default
         ColumnWidth:     2250
         DataUpdatable:   False
         Description:     Fieldname of first parameter in this query (* indicates optional use of
         wildcard before/after parameter value)
         DisplayControl:          Text Box
         OrdinalPosition:         6
         Required:        False
         SourceField:     Parameter1


Table: CSQueryDefinition         Page: 33
         SourceTable:     CSQueryDefinition
         Parameter2       Text     255
         AllowZeroLength:         False
         Attributes:      Variable Length
         CollatingOrder:          General
         ColumnHidden:    False
         ColumnOrder:     Default
         ColumnWidth:     2070
         DataUpdatable:   False
         Description:     Fieldname of second parameter in this query (* indicates optional use of
         wildcard before/after parameter value)
         DisplayControl:          Text Box
         OrdinalPosition:         7
         Required:        False
         SourceField:     Parameter2
         SourceTable:     CSQueryDefinition
         Table Indexes
         Name     Number of Fields
         PrimaryKey       1
         Clustered:       False
         DistinctCount:   75
         Foreign:         False
         IgnoreNulls:     False
         Name:    PrimaryKey
         Primary:         True
         Required:        True
         Unique:          True
         Fields:
         QueryID  Ascending
         QueryName        1
         Clustered:       False
         DistinctCount:   75
         Foreign:         False
         IgnoreNulls:     False
         Name:    QueryName
         Primary:         False
         Required:        False
         Unique:          True
         Fields:
         QueryName        Ascending
         User Permissions
         admin
         Group Permissions
         Admins


Table: CSQueryDefinition         Page: 34
         Users    Delete, Read Permissions, Set Permissions, Change Owner, Read Definition, Write
         Definition, Read Data, Insert Data, Update Data, Delete Data


Table: CSQueryFields     Page: 35
         Columns
         Name     Type     Size
         fieldName        Text     64
         AllowZeroLength:         False
         Attributes:      Variable Length
         CollatingOrder:          General
         ColumnHidden:    False
         ColumnOrder:     Default
         ColumnWidth:     2700
         DataUpdatable:   False
         DisplayControl:          Text Box
         OrdinalPosition:         0
         Required:        False
         SourceField:     fieldName
         SourceTable:     CSQueryFields
         fieldType        Text     20
         AllowZeroLength:         False
         Attributes:      Variable Length
         CollatingOrder:          General
         ColumnHidden:    False
         ColumnOrder:     Default
         ColumnWidth:     Default
         DataUpdatable:   False
         DisplayControl:          Text Box
         OrdinalPosition:         1
         Required:        False
         SourceField:     fieldType
         SourceTable:     CSQueryFields
         fieldSize        Text     50
         AllowZeroLength:         False
         Attributes:      Variable Length
         CollatingOrder:          General
         ColumnHidden:    False
         ColumnOrder:     Default
         ColumnWidth:     Default
         DataUpdatable:   False
         DisplayControl:          Text Box
         OrdinalPosition:         2
         Required:        False
         SourceField:     fieldSize
         SourceTable:     CSQueryFields
         fieldDescription         Text     128
         AllowZeroLength:         False


Table: CSQueryFields     Page: 36
         Attributes:      Variable Length
         CollatingOrder:          General
         ColumnHidden:    False
         ColumnOrder:     Default
         ColumnWidth:     1635
         DataUpdatable:   False
         DisplayControl:          Text Box
         OrdinalPosition:         3
         Required:        False
         SourceField:     fieldDescription
         SourceTable:     CSQueryFields
         fieldIncluded    Yes/No   1
         AllowZeroLength:         False
         Attributes:      Fixed Size
         CollatingOrder:          General
         ColumnHidden:    False
         ColumnOrder:     Default
         ColumnWidth:     Default
         DataUpdatable:   False
         DisplayControl:          106
         Format:          Yes/No
         OrdinalPosition:         4
         Required:        False
         SourceField:     fieldIncluded
         SourceTable:     CSQueryFields
         highLight        Yes/No   1
         AllowZeroLength:         False
         Attributes:      Fixed Size
         CollatingOrder:          General
         ColumnHidden:    False
         ColumnOrder:     Default
         ColumnWidth:     Default
         DataUpdatable:   False
         DisplayControl:          106
         Format:          Yes/No
         OrdinalPosition:         5
         Required:        False
         SourceField:     highLight
         SourceTable:     CSQueryFields
         Table Indexes
         Name     Number of Fields
         PrimaryKey       1
         Clustered:       False
         DistinctCount:   100
         Foreign:         False
         IgnoreNulls:     False
         Name:    PrimaryKey
         Primary:         True
         Required:        True
         Unique:          True


Table: CSQueryFields     Page: 37
         Fields:
         fieldName        Ascending
         User Permissions
         admin
         Group Permissions
         Admins
         Users    Delete, Read Permissions, Set Permissions, Change Owner, Read Definition, Write
         Definition, Read Data, Insert Data, Update Data, Delete Data


Table: CSQueryLog        Page: 38
         Columns
         Name     Type     Size
         searchID         Long Integer     4
         AllowZeroLength:         False
         Attributes:      Fixed Size
         CollatingOrder:          General
         ColumnHidden:    False
         ColumnOrder:     Default
         ColumnWidth:     Default
         DataUpdatable:   False
         DecimalPlaces:   Auto
         Description:     Index of the saved search
         DisplayControl:          Text Box
         OrdinalPosition:         0
         Required:        False
         SourceField:     searchID
         SourceTable:     CSQueryLog
         QuerySequence    Byte     1
         AllowZeroLength:         False
         Attributes:      Fixed Size
         CollatingOrder:          General
         ColumnHidden:    False
         ColumnOrder:     Default
         ColumnWidth:     1680
         DataUpdatable:   False
         DecimalPlaces:   Auto
         Description:     Sequence No of the query in this search (always starts at 1)
         DisplayControl:          Text Box
         OrdinalPosition:         1
         Required:        False
         SourceField:     QuerySequence
         SourceTable:     CSQueryLog
         QueryID  Long Integer     4
         AllowZeroLength:         False
         Attributes:      Fixed Size
         CollatingOrder:          General
         ColumnHidden:    False
         ColumnOrder:     Default
         ColumnWidth:     Default
         DataUpdatable:   False
         DecimalPlaces:   Auto
         Description:     ID of the Query (cross-reference to CSQueryDefinition control table)
         DisplayControl:          Text Box
         OrdinalPosition:         2


Table: CSQueryLog        Page: 39
         Required:        False
         SourceField:     QueryID
         SourceTable:     CSQueryLog
         Parameter1       Text     255
         AllowZeroLength:         False
         Attributes:      Variable Length
         CollatingOrder:          General
         ColumnHidden:    False
         ColumnOrder:     Default
         ColumnWidth:     2400
         DataUpdatable:   False
         Description:     Value of first parameter in the query (or "<<none>>" if no first
         parameter)
         DisplayControl:          Text Box
         OrdinalPosition:         3
         Required:        False
         SourceField:     Parameter1
         SourceTable:     CSQueryLog
         Parameter2       Text     255
         AllowZeroLength:         False
         Attributes:      Variable Length
         CollatingOrder:          General
         ColumnHidden:    False
         ColumnOrder:     Default
         ColumnWidth:     2235
         DataUpdatable:   False
         Description:     Value of second parameter in the query (or "<<none>>" if no second
         parameter)
         DisplayControl:          Text Box
         OrdinalPosition:         4
         Required:        False
         SourceField:     Parameter2
         SourceTable:     CSQueryLog
         RecordCount      Long Integer     4
         AllowZeroLength:         False
         Attributes:      Fixed Size
         CollatingOrder:          General
         ColumnHidden:    False
         ColumnOrder:     Default
         ColumnWidth:     Default
         DataUpdatable:   False
         DecimalPlaces:   Auto
         Description:     Number of records returned when this query was run
         DisplayControl:          Text Box
         OrdinalPosition:         5
         Required:        False
         SourceField:     RecordCount
         SourceTable:     CSQueryLog
         UserName         Text     20
         AllowZeroLength:         False


Table: CSQueryLog        Page: 40
         Attributes:      Variable Length
         CollatingOrder:          General
         ColumnHidden:    False
         ColumnOrder:     Default
         ColumnWidth:     Default
         DataUpdatable:   False
         Description:     Name of the User who ran or is running the search
         DisplayControl:          Text Box
         OrdinalPosition:         6
         Required:        False
         SourceField:     UserName
         SourceTable:     CSQueryLog
         Table Indexes
         Name     Number of Fields
         QueryID  1
         Clustered:       False
         DistinctCount:   6
         Foreign:         False
         IgnoreNulls:     False
         Name:    QueryID
         Primary:         False
         Required:        False
         Unique:          False
         Fields:
         QueryID  Ascending
         searchID         1
         Clustered:       False
         DistinctCount:   1
         Foreign:         False
         IgnoreNulls:     False
         Name:    searchID
         Primary:         False
         Required:        False
         Unique:          False
         Fields:
         searchID         Ascending
         User Permissions
         admin
         Group Permissions
         Admins
         Users    Delete, Read Permissions, Set Permissions, Change Owner, Read Definition, Write
         Definition, Read Data, Insert Data, Update Data, Delete Data


Table: CSQueryResult     Page: 41
         Columns
         Name     Type     Size
         TimeStamp        Date/Time        8
         AllowZeroLength:         False
         Attributes:      Variable Length
         CollatingOrder:          General
         ColumnHidden:    False
         ColumnOrder:     Default
         ColumnWidth:     Default
         DataUpdatable:   False
         OrdinalPosition:         0
         Required:        False
         SourceField:     TimeStamp
         SourceTable:     CSQueryResult
         UserName         Text     255
         AllowZeroLength:         False
         Attributes:      Variable Length
         CollatingOrder:          General
         ColumnHidden:    False
         ColumnOrder:     Default
         ColumnWidth:     Default
         DataUpdatable:   False
         DisplayControl:          Text Box
         OrdinalPosition:         1
         Required:        False
         SourceField:     UserName
         SourceTable:     CSQueryResult
         QuerySequence    Long Integer     4
         AllowZeroLength:         False
         Attributes:      Variable Length
         CollatingOrder:          General
         ColumnHidden:    False
         ColumnOrder:     Default
         ColumnWidth:     Default
         DataUpdatable:   False
         DecimalPlaces:   Auto
         DisplayControl:          Text Box
         OrdinalPosition:         2
         Required:        False
         SourceField:     QuerySequence
         SourceTable:     CSQueryResult
         recordID         Long Integer     4
         AllowZeroLength:         False


Table: CSQueryResult     Page: 42
         Attributes:      Fixed Size
         CollatingOrder:          General
         ColumnHidden:    False
         ColumnOrder:     Default
         ColumnWidth:     Default
         DataUpdatable:   False
         DecimalPlaces:   Auto
         DisplayControl:          Text Box
         OrdinalPosition:         3
         Required:        False
         SourceField:     recordID
         SourceTable:     CSQueryResult
         applicantId      Long Integer     4
         AllowZeroLength:         False
         Attributes:      Fixed Size
         CollatingOrder:          General
         ColumnHidden:    False
         ColumnOrder:     Default
         ColumnWidth:     Default
         DataUpdatable:   False
         DecimalPlaces:   Auto
         DisplayControl:          Text Box
         OrdinalPosition:         4
         Required:        False
         SourceField:     applicantId
         SourceTable:     CSQueryResult
         Table Indexes
         Name     Number of Fields
         applicantId      1
         Clustered:       False
         DistinctCount:   2211
         Foreign:         False
         IgnoreNulls:     False
         Name:    applicantId
         Primary:         False
         Required:        False
         Unique:          False
         Fields:
         applicantId      Ascending
         recordID         1
         Clustered:       False
         DistinctCount:   4147
         Foreign:         False
         IgnoreNulls:     False
         Name:    recordID
         Primary:         False
         Required:        False
         Unique:          False
         Fields:
         recordID         Ascending


Table: CSQueryResult     Page: 43
         admin
         Group Permissions
         Admins
         Users    Delete, Read Permissions, Set Permissions, Change Owner, Read Definition, Write
         Definition, Read Data, Insert Data, Update Data, Delete Data


Table: CSReasonForLeaving        Page: 44
         Columns
         Name     Type     Size
         CSReasonForLeavingID     Long Integer     4
         AllowZeroLength:         False
         Attributes:      Fixed Size, Auto-Increment
         CollatingOrder:          General
         ColumnHidden:    False
         ColumnOrder:     Default
         ColumnWidth:     2130
         DataUpdatable:   False
         OrdinalPosition:         0
         Required:        False
         SourceField:     CSReasonForLeavingID
         SourceTable:     CSReasonForLeaving
         CSReasonForLeavingAbbrev         Text     5
         AllowZeroLength:         False
         Attributes:      Variable Length
         CollatingOrder:          General
         ColumnHidden:    False
         ColumnOrder:     Default
         ColumnWidth:     2610
         DataUpdatable:   False
         Description:     Abbreviated Crown Servants Reason For Leaving (up to 5 characters)
         DisplayControl:          Text Box
         OrdinalPosition:         1
         Required:        False
         SourceField:     CSReasonForLeavingAbbrev
         SourceTable:     CSReasonForLeaving
         CSReasonForLeavingDescription    Text     255
         AllowZeroLength:         False
         Attributes:      Variable Length
         CollatingOrder:          General
         ColumnHidden:    False
         ColumnOrder:     Default
         ColumnWidth:     4020
         DataUpdatable:   False
         Description:     Crown Servants Reason For Leaving Description (up to 255 characters)
         DisplayControl:          Text Box
         OrdinalPosition:         2
         Required:        False
         SourceField:     CSReasonForLeavingDescription
         SourceTable:     CSReasonForLeaving
         CSActiveFlag     Yes/No   1


Table: CSReasonForLeaving        Page: 45
         AllowZeroLength:         False
         Attributes:      Fixed Size
         CollatingOrder:          General
         ColumnHidden:    False
         ColumnOrder:     Default
         ColumnWidth:     2520
         DataUpdatable:   False
         Description:     Is this Crown Servants Reason For Leaving a current one available for
         new Applicants? (Yes/No)
         DisplayControl:          106
         Format:          Yes/No
         OrdinalPosition:         3
         Required:        False
         SourceField:     CSActiveFlag
         SourceTable:     CSReasonForLeaving
         Relationships
         CSReasonForLeavingCSAPPLICANT
         CSReasonForLeaving       CSAPPLICANT
         CSReasonForLeavingID     1        ¥         ReasonForLeavingID
         Attributes:      Enforced, Right Join
         RelationshipType:        One-To-Many
         Table Indexes
         Name     Number of Fields
         PrimaryKey       1
         Clustered:       False
         DistinctCount:   12
         Foreign:         False
         IgnoreNulls:     False
         Name:    PrimaryKey
         Primary:         True
         Required:        True
         Unique:          True
         Fields:
         CSReasonForLeavingID     Ascending
         User Permissions
         admin
         Group Permissions
         Admins


Table: CSReasonForLeaving        Page: 46
         Users    Delete, Read Permissions, Set Permissions, Change Owner, Read Definition, Write
         Definition, Read Data, Insert Data, Update Data, Delete Data


Table: CSReportComments  Page: 47
         Columns
         Name     Type     Size
         RecordID         Long Integer     4
         AllowZeroLength:         False
         Attributes:      Fixed Size
         CollatingOrder:          General
         ColumnHidden:    False
         ColumnOrder:     Default
         ColumnWidth:     Default
         DataUpdatable:   False
         DecimalPlaces:   Auto
         DisplayControl:          Text Box
         OrdinalPosition:         0
         Required:        False
         SourceField:     RecordID
         SourceTable:     CSReportComments
         comment1         Memo     -
         AllowZeroLength:         False
         Attributes:      Variable Length
         CollatingOrder:          General
         ColumnHidden:    False
         ColumnOrder:     Default
         ColumnWidth:     Default
         DataUpdatable:   False
         OrdinalPosition:         1
         Required:        False
         SourceField:     comment1
         SourceTable:     CSReportComments
         comment2         Memo     -
         AllowZeroLength:         False
         Attributes:      Variable Length
         CollatingOrder:          General
         ColumnHidden:    False
         ColumnOrder:     Default
         ColumnWidth:     Default
         DataUpdatable:   False
         OrdinalPosition:         2
         Required:        False
         SourceField:     comment2
         SourceTable:     CSReportComments
         Table Indexes
         Name     Number of Fields


Table: CSReportComments  Page: 48
         recordID         1
         Clustered:       False
         DistinctCount:   729
         Foreign:         False
         IgnoreNulls:     False
         Name:    recordID
         Primary:         False
         Required:        False
         Unique:          True
         Fields:
         RecordID         Ascending
         User Permissions
         admin
         Group Permissions
         Admins
         Users    Delete, Read Permissions, Set Permissions, Change Owner, Read Definition, Write
         Definition, Read Data, Insert Data, Update Data, Delete Data


Table: CSTargets         Page: 49
         Columns
         Name     Type     Size
         TypeID   Long Integer     4
         AllowZeroLength:         False
         Attributes:      Fixed Size
         CollatingOrder:          General
         ColumnHidden:    False
         ColumnOrder:     Default
         ColumnWidth:     Default
         DataUpdatable:   False
         DecimalPlaces:   Auto
         DisplayControl:          Text Box
         OrdinalPosition:         0
         Required:        False
         SourceField:     TypeID
         SourceTable:     CSTargets
         ApplicationQueried       Text     3
         AllowZeroLength:         False
         Attributes:      Variable Length
         CollatingOrder:          General
         ColumnHidden:    False
         ColumnOrder:     Default
         ColumnWidth:     Default
         DataUpdatable:   False
         Description:     Used for grouping in reports
         DisplayControl:          Text Box
         OrdinalPosition:         1
         Required:        False
         SourceField:     ApplicationQueried
         SourceTable:     CSTargets
         ValidationText:          Please enter Yes, No, or All
         TypeGroup        Long Integer     4
         AllowZeroLength:         False
         Attributes:      Fixed Size
         CollatingOrder:          General
         ColumnHidden:    False
         ColumnOrder:     Default
         ColumnWidth:     Default
         DataUpdatable:   False
         DecimalPlaces:   Auto
         Description:     Used for grouping in reports
         DisplayControl:          Text Box
         OrdinalPosition:         2
         Required:        False


Table: CSTargets         Page: 50
         SourceField:     TypeGroup
         SourceTable:     CSTargets
         Description      Text     50
         AllowZeroLength:         False
         Attributes:      Variable Length
         CollatingOrder:          General
         ColumnHidden:    False
         ColumnOrder:     Default
         ColumnWidth:     4290
         DataUpdatable:   False
         DisplayControl:          Text Box
         OrdinalPosition:         3
         Required:        False
         SourceField:     Description
         SourceTable:     CSTargets
         DaysAllowed      Long Integer     4
         AllowZeroLength:         False
         Attributes:      Fixed Size
         CollatingOrder:          General
         ColumnHidden:    False
         ColumnOrder:     Default
         ColumnWidth:     Default
         DataUpdatable:   False
         DecimalPlaces:   Auto
         Description:     Days allowed for Stage 1 Targets
         DisplayControl:          Text Box
         OrdinalPosition:         4
         Required:        False
         SourceField:     DaysAllowed
         SourceTable:     CSTargets
         DaysAllowed2     Long Integer     4
         AllowZeroLength:         False
         Attributes:      Fixed Size
         CollatingOrder:          General
         ColumnHidden:    False
         ColumnOrder:     Default
         ColumnWidth:     Default
         DataUpdatable:   False
         DecimalPlaces:   Auto
         Description:     Days allowed for Stage 2 Targets
         DisplayControl:          Text Box
         OrdinalPosition:         5
         Required:        False
         SourceField:     DaysAllowed2
         SourceTable:     CSTargets
         startDate        Date/Time        8
         AllowZeroLength:         False
         Attributes:      Fixed Size
         CollatingOrder:          General
         ColumnHidden:    False
         ColumnOrder:     Default
         ColumnWidth:     Default


Table: CSTargets         Page: 51
         DataUpdatable:   False
         OrdinalPosition:         6
         Required:        False
         SourceField:     startDate
         SourceTable:     CSTargets
         endDate  Date/Time        8
         AllowZeroLength:         False
         Attributes:      Fixed Size
         CollatingOrder:          General
         ColumnHidden:    False
         ColumnOrder:     Default
         ColumnWidth:     Default
         DataUpdatable:   False
         OrdinalPosition:         7
         Required:        False
         SourceField:     endDate
         SourceTable:     CSTargets
         Stage1Within     Long Integer     4
         AllowZeroLength:         False
         Attributes:      Fixed Size
         CollatingOrder:          General
         ColumnHidden:    False
         ColumnOrder:     Default
         ColumnWidth:     Default
         DataUpdatable:   False
         DecimalPlaces:   Auto
         DisplayControl:          Text Box
         OrdinalPosition:         8
         Required:        False
         SourceField:     Stage1Within
         SourceTable:     CSTargets
         Stage1Off        Long Integer     4
         AllowZeroLength:         False
         Attributes:      Fixed Size
         CollatingOrder:          General
         ColumnHidden:    False
         ColumnOrder:     Default
         ColumnWidth:     Default
         DataUpdatable:   False
         DecimalPlaces:   Auto
         DisplayControl:          Text Box
         OrdinalPosition:         9
         Required:        False
         SourceField:     Stage1Off
         SourceTable:     CSTargets
         Stage1Percentage         Long Integer     4
         AllowZeroLength:         False
         Attributes:      Fixed Size
         CollatingOrder:          General
         ColumnHidden:    False
         ColumnOrder:     Default
         ColumnWidth:     Default


Table: CSTargets         Page: 52
         DataUpdatable:   False
         DecimalPlaces:   Auto
         DisplayControl:          Text Box
         OrdinalPosition:         10
         Required:        False
         SourceField:     Stage1Percentage
         SourceTable:     CSTargets
         Stage2Within     Long Integer     4
         AllowZeroLength:         False
         Attributes:      Fixed Size
         CollatingOrder:          General
         ColumnHidden:    False
         ColumnOrder:     Default
         ColumnWidth:     Default
         DataUpdatable:   False
         DecimalPlaces:   Auto
         DisplayControl:          Text Box
         OrdinalPosition:         11
         Required:        False
         SourceField:     Stage2Within
         SourceTable:     CSTargets
         Stage2Off        Long Integer     4
         AllowZeroLength:         False
         Attributes:      Fixed Size
         CollatingOrder:          General
         ColumnHidden:    False
         ColumnOrder:     Default
         ColumnWidth:     Default
         DataUpdatable:   False
         DecimalPlaces:   Auto
         DisplayControl:          Text Box
         OrdinalPosition:         12
         Required:        False
         SourceField:     Stage2Off
         SourceTable:     CSTargets
         Stage2Percentage         Long Integer     4
         AllowZeroLength:         False
         Attributes:      Fixed Size
         CollatingOrder:          General
         ColumnHidden:    False
         ColumnOrder:     Default
         ColumnWidth:     Default
         DataUpdatable:   False
         DecimalPlaces:   Auto
         DisplayControl:          Text Box
         OrdinalPosition:         13
         Required:        False
         SourceField:     Stage2Percentage
         SourceTable:     CSTargets
         Table Indexes


Table: CSTargets         Page: 53
         Name     Number of Fields
         PrimaryKey       1
         Clustered:       False
         DistinctCount:   6
         Foreign:         False
         IgnoreNulls:     False
         Name:    PrimaryKey
         Primary:         True
         Required:        True
         Unique:          True
         Fields:
         TypeID   Ascending
         TypeID   1
         Clustered:       False
         DistinctCount:   6
         Foreign:         False
         IgnoreNulls:     False
         Name:    TypeID
         Primary:         False
         Required:        False
         Unique:          False
         Fields:
         TypeID   Ascending
         User Permissions
         admin
         Group Permissions
         Admins
         Users    Delete, Read Permissions, Set Permissions, Change Owner, Read Definition, Write
         Definition, Read Data, Insert Data, Update Data, Delete Data


Table: CSUserSearch      Page: 54
         Columns
         Name     Type     Size
         searchID         Long Integer     4
         AllowZeroLength:         False
         Attributes:      Fixed Size, Auto-Increment
         CollatingOrder:          General
         ColumnHidden:    False
         ColumnOrder:     1
         ColumnWidth:     Default
         DataUpdatable:   False
         OrdinalPosition:         0
         Required:        False
         SourceField:     searchID
         SourceTable:     CSUserSearch
         userName         Text     50
         AllowZeroLength:         False
         Attributes:      Variable Length
         CollatingOrder:          General
         ColumnHidden:    False
         ColumnOrder:     Default
         ColumnWidth:     Default
         DataUpdatable:   False
         DisplayControl:          Text Box
         OrdinalPosition:         1
         Required:        False
         SourceField:     userName
         SourceTable:     CSUserSearch
         searchName       Text     50
         AllowZeroLength:         False
         Attributes:      Variable Length
         CollatingOrder:          General
         ColumnHidden:    False
         ColumnOrder:     Default
         ColumnWidth:     1875
         DataUpdatable:   False
         DisplayControl:          Text Box
         OrdinalPosition:         2
         Required:        False
         SourceField:     searchName
         SourceTable:     CSUserSearch
         Table Indexes
         Name     Number of Fields


Table: CSUserSearch      Page: 55
         PrimaryKey       1
         Clustered:       False
         DistinctCount:   0
         Foreign:         False
         IgnoreNulls:     False
         Name:    PrimaryKey
         Primary:         True
         Required:        True
         Unique:          True
         Fields:
         searchID         Ascending
         search   2
         Clustered:       False
         DistinctCount:   0
         Foreign:         False
         IgnoreNulls:     False
         Name:    search
         Primary:         False
         Required:        False
         Unique:          True
         Fields:
         userName         Ascending
         searchName       Ascending
         User Permissions
         admin
         Group Permissions
         Admins
         Users    Delete, Read Permissions, Set Permissions, Change Owner, Read Definition, Write
         Definition, Read Data, Insert Data, Update Data, Delete Data


Table: dateExclusion     Page: 56
         Columns
         Name     Type     Size
         DateExcluded     Date/Time        8
         AllowZeroLength:         False
         Attributes:      Fixed Size
         CollatingOrder:          General
         ColumnHidden:    False
         ColumnOrder:     1
         ColumnWidth:     Default
         DataUpdatable:   False
         Description:     Date to be excluded
         Format:          dd/mmm/yyyy
         OrdinalPosition:         0
         Required:        False
         SourceField:     DateExcluded
         SourceTable:     dateExclusion
         Description      Text     50
         AllowZeroLength:         False
         Attributes:      Variable Length
         CollatingOrder:          General
         ColumnHidden:    False
         ColumnOrder:     Default
         ColumnWidth:     1500
         DataUpdatable:   False
         Description:     Why is the date excluded
         DisplayControl:          Text Box
         OrdinalPosition:         1
         Required:        False
         SourceField:     Description
         SourceTable:     dateExclusion
         Table Indexes
         Name     Number of Fields
         PrimaryKey       1
         Clustered:       False
         DistinctCount:   134
         Foreign:         False
         IgnoreNulls:     False
         Name:    PrimaryKey
         Primary:         True
         Required:        True
         Unique:          True


Table: dateExclusion     Page: 57
         Fields:
         DateExcluded     Ascending
         User Permissions
         admin
         Group Permissions
         Admins
         Users    Delete, Read Permissions, Set Permissions, Change Owner, Read Definition, Write
         Definition, Read Data, Insert Data, Update Data, Delete Data


Table: GovernmentDepartment      Page: 58
         Columns
         Name     Type     Size
         DepartmentID     Long Integer     4
         AllowZeroLength:         False
         Attributes:      Fixed Size, Auto-Increment
         CollatingOrder:          General
         ColumnHidden:    False
         ColumnOrder:     Default
         ColumnWidth:     1455
         DataUpdatable:   False
         OrdinalPosition:         0
         Required:        False
         SourceField:     DepartmentID
         SourceTable:     GovernmentDepartment
         DepartmentAbbrev         Text     10
         AllowZeroLength:         False
         Attributes:      Variable Length
         CollatingOrder:          General
         ColumnHidden:    False
         ColumnOrder:     Default
         ColumnWidth:     1950
         DataUpdatable:   False
         Description:     Government Department Abbreviated Name (up to 10 characters)
         DisplayControl:          Text Box
         OrdinalPosition:         1
         Required:        False
         SourceField:     DepartmentAbbrev
         SourceTable:     GovernmentDepartment
         DepartmentName   Text     100
         AllowZeroLength:         False
         Attributes:      Variable Length
         CollatingOrder:          General
         ColumnHidden:    False
         ColumnOrder:     Default
         ColumnWidth:     4695
         DataUpdatable:   False
         Description:     Government Department full Name (up to 100 characters)
         DisplayControl:          Text Box
         OrdinalPosition:         2
         Required:        False
         SourceField:     DepartmentName
         SourceTable:     GovernmentDepartment
         DepartmentNotes  Text     255


Table: GovernmentDepartment      Page: 59
         AllowZeroLength:         False
         Attributes:      Variable Length
         CollatingOrder:          General
         ColumnHidden:    False
         ColumnOrder:     Default
         ColumnWidth:     1785
         DataUpdatable:   False
         Description:     Notes - e.g. previous name(s) of this department (up to 255 characters)
         DisplayControl:          Text Box
         OrdinalPosition:         3
         Required:        False
         SourceField:     DepartmentNotes
         SourceTable:     GovernmentDepartment
         ActiveFlag       Yes/No   1
         AllowZeroLength:         False
         Attributes:      Fixed Size
         CollatingOrder:          General
         ColumnHidden:    False
         ColumnOrder:     Default
         ColumnWidth:     Default
         DataUpdatable:   False
         Description:     Is this Government Department a current one available for new input?
         (Yes/No)
         DisplayControl:          106
         Format:          Yes/No
         OrdinalPosition:         4
         Required:        False
         SourceField:     ActiveFlag
         SourceTable:     GovernmentDepartment
         Relationships
         GovernmentDepartmentCSAPPLICANT
         GovernmentDepartmen      CSAPPLICANT
         DepartmentID     1        ¥         DepartmentID
         Attributes:      Enforced, Right Join
         RelationshipType:        One-To-Many
         GovernmentDepartmentMAPPLICANT
         GovernmentDepartmen      MAPPLICANT
         DepartmentID     1        ¥         DepartmentID
         Attributes:      Enforced, Right Join
         RelationshipType:        One-To-Many


Table: GovernmentDepartment      Page: 60
         Table Indexes
         Name     Number of Fields
         PrimaryKey       1
         Clustered:       False
         DistinctCount:   130
         Foreign:         False
         IgnoreNulls:     False
         Name:    PrimaryKey
         Primary:         True
         Required:        True
         Unique:          True
         Fields:
         DepartmentID     Ascending
         User Permissions
         admin
         Group Permissions
         Admins
         Users    Delete, Read Permissions, Set Permissions, Change Owner, Read Definition, Write
         Definition, Read Data, Insert Data, Update Data, Delete Data


Table: GovernmentPost    Page: 61
         Columns
         Name     Type     Size
         GovernmentPostID         Long Integer     4
         AllowZeroLength:         False
         Attributes:      Fixed Size, Auto-Increment
         CollatingOrder:          General
         ColumnHidden:    False
         ColumnOrder:     1
         ColumnWidth:     1785
         DataUpdatable:   False
         OrdinalPosition:         0
         Required:        False
         SourceField:     GovernmentPostID
         SourceTable:     GovernmentPost
         GovernmentCode   Text     8
         AllowZeroLength:         False
         Attributes:      Variable Length
         CollatingOrder:          General
         ColumnHidden:    False
         ColumnOrder:     Default
         ColumnWidth:     2085
         DataUpdatable:   False
         Description:     8 Character abreviation
         DisplayControl:          Text Box
         OrdinalPosition:         1
         Required:        False
         SourceField:     GovernmentCode
         SourceTable:     GovernmentPost
         GovernmentPostName       Text     50
         AllowZeroLength:         False
         Attributes:      Variable Length
         CollatingOrder:          General
         ColumnHidden:    False
         ColumnOrder:     Default
         ColumnWidth:     4770
         DataUpdatable:   False
         Description:     up to 50 characters
         DisplayControl:          Text Box
         OrdinalPosition:         2
         Required:        False
         SourceField:     GovernmentPostName
         SourceTable:     GovernmentPost


Table: GovernmentPost    Page: 62
         Table Indexes
         Name     Number of Fields
         GovernmentCode   1
         Clustered:       False
         DistinctCount:   24
         Foreign:         False
         IgnoreNulls:     False
         Name:    GovernmentCode
         Primary:         False
         Required:        False
         Unique:          False
         Fields:
         GovernmentCode   Ascending
         GradeCategoryID  1
         Clustered:       False
         DistinctCount:   24
         Foreign:         False
         IgnoreNulls:     False
         Name:    GradeCategoryID
         Primary:         False
         Required:        False
         Unique:          False
         Fields:
         GovernmentPostID         Ascending
         PrimaryKey       1
         Clustered:       False
         DistinctCount:   24
         Foreign:         False
         IgnoreNulls:     False
         Name:    PrimaryKey
         Primary:         True
         Required:        True
         Unique:          True
         Fields:
         GovernmentPostID         Ascending
         User Permissions
         admin
         Group Permissions
         Admins
         Users    Delete, Read Permissions, Set Permissions, Change Owner, Read Definition, Write
         Definition, Read Data, Insert Data, Update Data, Delete Data


Table: GradeCategory     Page: 63
         Columns
         Name     Type     Size
         GradeCategoryID  Long Integer     4
         AllowZeroLength:         False
         Attributes:      Fixed Size, Auto-Increment
         CollatingOrder:          General
         ColumnHidden:    False
         ColumnOrder:     Default
         ColumnWidth:     1785
         DataUpdatable:   False
         OrdinalPosition:         0
         Required:        False
         SourceField:     GradeCategoryID
         SourceTable:     GradeCategory
         GradeCategoryCode        Text     2
         AllowZeroLength:         False
         Attributes:      Variable Length
         CollatingOrder:          General
         ColumnHidden:    False
         ColumnOrder:     Default
         ColumnWidth:     2085
         DataUpdatable:   False
         Description:     Grade Category Code (A1, B, etc.) - up to 2 characters
         DisplayControl:          Text Box
         OrdinalPosition:         1
         Required:        False
         SourceField:     GradeCategoryCode
         SourceTable:     GradeCategory
         GradeCategoryName        Text     50
         AllowZeroLength:         False
         Attributes:      Variable Length
         CollatingOrder:          General
         ColumnHidden:    False
         ColumnOrder:     Default
         ColumnWidth:     2145
         DataUpdatable:   False
         Description:     Grade Category Name - up to 50 characters
         DisplayControl:          Text Box
         OrdinalPosition:         2
         Required:        False
         SourceField:     GradeCategoryName
         SourceTable:     GradeCategory


Table: GradeCategory     Page: 64
         Relationships
         GradeCategoryCSAPPLICANT
         GradeCategory    CSAPPLICANT
         GradeCategoryID  1        ¥         GradeCategoryID
         Attributes:      Enforced, Right Join
         RelationshipType:        One-To-Many
         Table Indexes
         Name     Number of Fields
         GradeCategoryCode        1
         Clustered:       False
         DistinctCount:   6
         Foreign:         False
         IgnoreNulls:     False
         Name:    GradeCategoryCode
         Primary:         False
         Required:        False
         Unique:          False
         Fields:
         GradeCategoryCode        Ascending
         PrimaryKey       1
         Clustered:       False
         DistinctCount:   6
         Foreign:         False
         IgnoreNulls:     False
         Name:    PrimaryKey
         Primary:         True
         Required:        True
         Unique:          True
         Fields:
         GradeCategoryID  Ascending
         User Permissions
         admin
         Group Permissions
         Admins
         Users    Delete, Read Permissions, Set Permissions, Change Owner, Read Definition, Write
         Definition, Read Data, Insert Data, Update Data, Delete Data


Table: MAPPLICANT        Page: 65
         Columns
         Name     Type     Size
         ApplicantID      Long Integer     4
         AllowZeroLength:         False
         Attributes:      Fixed Size
         CollatingOrder:          General
         ColumnHidden:    False
         ColumnOrder:     Default
         ColumnWidth:     Default
         DataUpdatable:   False
         DecimalPlaces:   Auto
         Description:     ID number of Applicant (autogenerated for new entries)
         DisplayControl:          Text Box
         OrdinalPosition:         0
         Required:        True
         SourceField:     ApplicantID
         SourceTable:     MAPPLICANT
         Surname  Text     30
         AllowZeroLength:         False
         Attributes:      Variable Length
         CollatingOrder:          General
         ColumnHidden:    False
         ColumnOrder:     Default
         ColumnWidth:     Default
         DataUpdatable:   False
         Description:     Surname of Applicant (up to 30 characters)
         DisplayControl:          Text Box
         OrdinalPosition:         1
         Required:        True
         SourceField:     Surname
         SourceTable:     MAPPLICANT
         Initials         Text     30
         AllowZeroLength:         False
         Attributes:      Variable Length
         CollatingOrder:          General
         ColumnHidden:    False
         ColumnOrder:     Default
         ColumnWidth:     Default
         DataUpdatable:   False
         Description:     Initials of Applicant (up to 30 characters) **** This field doubles as
         Forename
         DisplayControl:          Text Box
         OrdinalPosition:         2
         Required:        True


Table: MAPPLICANT        Page: 66
         SourceField:     Initials
         SourceTable:     MAPPLICANT
         Title    Text     15
         AllowZeroLength:         False
         Attributes:      Variable Length
         CollatingOrder:          General
         ColumnHidden:    False
         ColumnOrder:     Default
         ColumnWidth:     Default
         DataUpdatable:   False
         Description:     Title of Applicant (up to 15 characters)
         DisplayControl:          Text Box
         OrdinalPosition:         3
         Required:        False
         SourceField:     Title
         SourceTable:     MAPPLICANT
         Honours  Text     15
         AllowZeroLength:         False
         Attributes:      Variable Length
         CollatingOrder:          General
         ColumnHidden:    False
         ColumnOrder:     Default
         ColumnWidth:     Default
         DataUpdatable:   False
         Description:     Honours awarded to Applicant (up to 15 characters)
         DisplayControl:          Text Box
         OrdinalPosition:         4
         Required:        False
         SourceField:     Honours
         SourceTable:     MAPPLICANT
         PoliticalParty   Long Integer     4
         AllowZeroLength:         False
         Attributes:      Fixed Size
         CollatingOrder:          General
         ColumnHidden:    False
         ColumnOrder:     Default
         ColumnWidth:     Default
         DataUpdatable:   False
         DecimalPlaces:   Auto
         Description:     Ministers Political Party
         DisplayControl:          Text Box
         OrdinalPosition:         5
         Required:        False
         SourceField:     PoliticalParty
         SourceTable:     MAPPLICANT
         MostRecentPost   Long Integer     4
         AllowZeroLength:         False
         Attributes:      Fixed Size
         CollatingOrder:          General
         ColumnHidden:    False
         ColumnOrder:     Default
         ColumnWidth:     Default


Table: MAPPLICANT        Page: 67
         DataUpdatable:   False
         DecimalPlaces:   Auto
         Description:     Most recent government post held by Applicant as a Minister
         DisplayControl:          Text Box
         OrdinalPosition:         6
         Required:        False
         SourceField:     MostRecentPost
         SourceTable:     MAPPLICANT
         DepartmentID     Long Integer     4
         AllowZeroLength:         False
         Attributes:      Fixed Size
         CollatingOrder:          General
         ColumnHidden:    False
         ColumnOrder:     Default
         ColumnWidth:     Default
         DataUpdatable:   False
         DecimalPlaces:   Auto
         Description:     Government Department worked for - cross-reference to control table
         DisplayControl:          Text Box
         OrdinalPosition:         7
         Required:        False
         SourceField:     DepartmentID
         SourceTable:     MAPPLICANT
         CabinetRank      Yes/No   1
         AllowZeroLength:         False
         Attributes:      Fixed Size
         CollatingOrder:          General
         ColumnHidden:    False
         ColumnOrder:     Default
         ColumnWidth:     Default
         DataUpdatable:   False
         Description:     Was minister Cabinet Rank
         DisplayControl:          106
         Format:          Yes/No
         OrdinalPosition:         8
         Required:        False
         SourceField:     CabinetRank
         SourceTable:     MAPPLICANT
         PreviousPost1    Long Integer     4
         AllowZeroLength:         False
         Attributes:      Fixed Size
         CollatingOrder:          General
         ColumnHidden:    False
         ColumnOrder:     Default
         ColumnWidth:     Default
         DataUpdatable:   False
         DecimalPlaces:   Auto
         Description:     Previous Government post (Same control file as MostRecentPost)
         DisplayControl:          Text Box
         OrdinalPosition:         9
         Required:        False
         SourceField:     PreviousPost1
         SourceTable:     MAPPLICANT


Table: MAPPLICANT        Page: 68
         PreviousPost2    Long Integer     4
         AllowZeroLength:         False
         Attributes:      Fixed Size
         CollatingOrder:          General
         ColumnHidden:    False
         ColumnOrder:     Default
         ColumnWidth:     Default
         DataUpdatable:   False
         DecimalPlaces:   Auto
         Description:     Previous Government post (Same control file as MostRecentPost)
         DisplayControl:          Text Box
         OrdinalPosition:         10
         Required:        False
         SourceField:     PreviousPost2
         SourceTable:     MAPPLICANT
         PreviousPost3    Long Integer     4
         AllowZeroLength:         False
         Attributes:      Fixed Size
         CollatingOrder:          General
         ColumnHidden:    False
         ColumnOrder:     Default
         ColumnWidth:     Default
         DataUpdatable:   False
         DecimalPlaces:   Auto
         Description:     Previous Government post (Same control file as MostRecentPost)
         DisplayControl:          Text Box
         OrdinalPosition:         11
         Required:        False
         SourceField:     PreviousPost3
         SourceTable:     MAPPLICANT
         LastDayInPost    Date/Time        8
         AllowZeroLength:         False
         Attributes:      Fixed Size
         CollatingOrder:          General
         ColumnHidden:    False
         ColumnOrder:     Default
         ColumnWidth:     Default
         DataUpdatable:   False
         Description:     Date left government
         OrdinalPosition:         12
         Required:        False
         SourceField:     LastDayInPost
         SourceTable:     MAPPLICANT
         ReasonForLeavingID       Long Integer     4
         AllowZeroLength:         False
         Attributes:      Fixed Size
         CollatingOrder:          General
         ColumnHidden:    False
         ColumnOrder:     Default
         ColumnWidth:     Default
         DataUpdatable:   False
         DecimalPlaces:   Auto
         Description:     Reason for leaving Minister post - cross-reference to control table


Table: MAPPLICANT        Page: 69
         DisplayControl:          Text Box
         OrdinalPosition:         13
         Required:        False
         SourceField:     ReasonForLeavingID
         SourceTable:     MAPPLICANT
         paperRecord      Yes/No   1
         AllowZeroLength:         False
         Attributes:      Fixed Size
         CollatingOrder:          General
         ColumnHidden:    False
         ColumnOrder:     Default
         ColumnWidth:     Default
         DataUpdatable:   False
         Description:     Paper Record exists for this applicant
         DisplayControl:          106
         Format:          Yes/No
         OrdinalPosition:         14
         Required:        False
         SourceField:     paperRecord
         SourceTable:     MAPPLICANT
         Relationships
         PoliticalPartyMAPPLICANT
         PoliticalParty   MAPPLICANT
         PoliticalPartyID         1        ¥         PoliticalParty
         Attributes:      Enforced, Right Join
         RelationshipType:        One-To-Many
         GovernmentDepartmentMAPPLICANT
         GovernmentDepartmen      MAPPLICANT
         DepartmentID     1        ¥         DepartmentID
         Attributes:      Enforced, Right Join
         RelationshipType:        One-To-Many
         MAPPLICANTMApplication
         MAPPLICANT       MApplication
         ApplicantID      1        ¥         ApplicantID
         Attributes:      Enforced, Cascade Updates, Cascade Deletes
         RelationshipType:        One-To-Many


Table: MAPPLICANT        Page: 70
         MReasonForLeavingMAPPLICANT
         MReasonForLeaving        MAPPLICANT
         MReasonForLeavingID      1        ¥         ReasonForLeavingID
         Attributes:      Enforced, Right Join
         RelationshipType:        One-To-Many
         Table Indexes
         Name     Number of Fields
         1D1E8CDB-5395-4912-A219-         1
         Clustered:       False
         DistinctCount:   4
         Foreign:         True
         IgnoreNulls:     False
         Name:    1D1E8CDB-5395-4912-A219-CFD06757C7BE
         Primary:         False
         Required:        False
         Unique:          False
         Fields:
         PoliticalParty   Ascending
         69CCF5D7-533B-4DAA-B6CD-         1
         Clustered:       False
         DistinctCount:   39
         Foreign:         True
         IgnoreNulls:     False
         Name:    69CCF5D7-533B-4DAA-B6CD-14C784A61301
         Primary:         False
         Required:        False
         Unique:          False
         Fields:
         DepartmentID     Ascending
         F7BF73F2-9FEB-4950-9C35-         1
         Clustered:       False
         DistinctCount:   5
         Foreign:         True
         IgnoreNulls:     False
         Name:    F7BF73F2-9FEB-4950-9C35-39D468D2D760
         Primary:         False
         Required:        False
         Unique:          False
         Fields:
         ReasonForLeavingID       Ascending
         Department       1
         Clustered:       False
         DistinctCount:   39
         Foreign:         False
         IgnoreNulls:     False
         Name:    Department
         Primary:         False


Table: MAPPLICANT        Page: 71
         Required:        False
         Unique:          False
         Fields:
         DepartmentID     Ascending
         PoliticalParty   1
         Clustered:       False
         DistinctCount:   4
         Foreign:         False
         IgnoreNulls:     False
         Name:    PoliticalParty
         Primary:         False
         Required:        False
         Unique:          False
         Fields:
         PoliticalParty   Ascending
         PrimaryKey       1
         Clustered:       False
         DistinctCount:   141
         Foreign:         False
         IgnoreNulls:     False
         Name:    PrimaryKey
         Primary:         True
         Required:        True
         Unique:          True
         Fields:
         ApplicantID      Ascending
         ReasonForLeaving         1
         Clustered:       False
         DistinctCount:   5
         Foreign:         False
         IgnoreNulls:     False
         Name:    ReasonForLeaving
         Primary:         False
         Required:        False
         Unique:          False
         Fields:
         ReasonForLeavingID       Ascending
         User Permissions
         admin
         Group Permissions
         Admins
         Users    Delete, Read Permissions, Set Permissions, Change Owner, Read Definition, Write
         Definition, Read Data, Insert Data, Update Data, Delete Data


Table: MApplication      Page: 72
         Columns
         Name     Type     Size
         recordID         Long Integer     4
         AllowZeroLength:         False
         Attributes:      Fixed Size, Auto-Increment
         CollatingOrder:          General
         ColumnHidden:    False
         ColumnOrder:     Default
         ColumnWidth:     Default
         DataUpdatable:   False
         OrdinalPosition:         0
         Required:        False
         SourceField:     recordID
         SourceTable:     MApplication
         ApplicantID      Long Integer     4
         AllowZeroLength:         False
         Attributes:      Fixed Size
         CollatingOrder:          General
         ColumnHidden:    False
         ColumnOrder:     Default
         ColumnWidth:     Default
         DataUpdatable:   False
         DecimalPlaces:   Auto
         Description:     Cross-reference to MAPPLICANTS table
         DisplayControl:          Text Box
         OrdinalPosition:         1
         Required:        True
         SourceField:     ApplicantID
         SourceTable:     MApplication
         ApplicationID    Byte     1
         AllowZeroLength:         False
         Attributes:      Fixed Size
         CollatingOrder:          General
         ColumnHidden:    False
         ColumnOrder:     Default
         ColumnWidth:     Default
         DataUpdatable:   False
         DecimalPlaces:   Auto
         Description:     Starts at 1 for each Applicant
         DisplayControl:          Text Box
         OrdinalPosition:         2
         Required:        True
         SourceField:     ApplicationID
         SourceTable:     MApplication


Table: MApplication      Page: 73
         DateReceived     Date/Time        8
         AllowZeroLength:         False
         Attributes:      Fixed Size
         CollatingOrder:          General
         ColumnHidden:    False
         ColumnOrder:     Default
         ColumnWidth:     1470
         DataUpdatable:   False
         Description:     Date Application Received in division
         OrdinalPosition:         3
         Required:        True
         SourceField:     DateReceived
         SourceTable:     MApplication
         DateToDept       Date/Time        8
         AllowZeroLength:         False
         Attributes:      Fixed Size
         CollatingOrder:          General
         ColumnHidden:    False
         ColumnOrder:     Default
         ColumnWidth:     Default
         DataUpdatable:   False
         Description:     Date infromation sent to department
         OrdinalPosition:         4
         Required:        False
         SourceField:     DateToDept
         SourceTable:     MApplication
         ReferredToDept   Yes/No   1
         AllowZeroLength:         False
         Attributes:      Fixed Size
         CollatingOrder:          General
         ColumnHidden:    False
         ColumnOrder:     Default
         ColumnWidth:     Default
         DataUpdatable:   False
         Description:     Information received from department
         DisplayControl:          106
         Format:          Yes/No
         OrdinalPosition:         5
         Required:        False
         SourceField:     ReferredToDept
         SourceTable:     MApplication
         DateReferred     Date/Time        8
         AllowZeroLength:         False
         Attributes:      Fixed Size
         CollatingOrder:          General
         ColumnHidden:    False
         ColumnOrder:     Default
         ColumnWidth:     Default
         DataUpdatable:   False
         Description:     Date referred to ACOBA
         OrdinalPosition:         6
         Required:        False
         SourceField:     DateReferred


Table: MApplication      Page: 74
         SourceTable:     MApplication
         DateCompleted    Date/Time        8
         AllowZeroLength:         False
         Attributes:      Fixed Size
         CollatingOrder:          General
         ColumnHidden:    False
         ColumnOrder:     Default
         ColumnWidth:     1620
         DataUpdatable:   False
         Description:     Date completed/minister notified
         OrdinalPosition:         7
         Required:        False
         SourceField:     DateCompleted
         SourceTable:     MApplication
         WorkingDaysToComplete    Integer  2
         AllowZeroLength:         False
         Attributes:      Fixed Size
         CollatingOrder:          General
         ColumnHidden:    False
         ColumnOrder:     Default
         ColumnWidth:     1365
         DataUpdatable:   False
         DecimalPlaces:   Auto
         Description:     Estimated number of working days to compete the Application (Auto
         Calculate)
         DisplayControl:          Text Box
         OrdinalPosition:         8
         Required:        False
         SourceField:     WorkingDaysToComplete
         SourceTable:     MApplication
         NewEmployerName  Text     60
         AllowZeroLength:         False
         Attributes:      Variable Length
         CollatingOrder:          General
         ColumnHidden:    False
         ColumnOrder:     Default
         ColumnWidth:     2025
         DataUpdatable:   False
         Description:     New Employer or Client name
         DisplayControl:          Text Box
         OrdinalPosition:         9
         Required:        True
         SourceField:     NewEmployerName
         SourceTable:     MApplication
         IndependentConsultant    Yes/No   1
         AllowZeroLength:         False
         Attributes:      Fixed Size
         CollatingOrder:          General
         ColumnHidden:    False
         ColumnOrder:     Default
         ColumnWidth:     2355


Table: MApplication      Page: 75
         DataUpdatable:   False
         Description:     Independent Consultant (Yes/No)
         DisplayControl:          106
         Format:          Yes/No
         OrdinalPosition:         10
         Required:        False
         SourceField:     IndependentConsultant
         SourceTable:     MApplication
         NatureOfBusinessID       Long Integer     4
         AllowZeroLength:         False
         Attributes:      Fixed Size
         CollatingOrder:          General
         ColumnHidden:    False
         ColumnOrder:     Default
         ColumnWidth:     2010
         DataUpdatable:   False
         DecimalPlaces:   Auto
         Description:     Nature of Business of New Employer or Client- cross-reference to control
         table
         DisplayControl:          Text Box
         OrdinalPosition:         11
         Required:        False
         SourceField:     NatureOfBusinessID
         SourceTable:     MApplication
         NatureOfJobID    Long Integer     4
         AllowZeroLength:         False
         Attributes:      Fixed Size
         CollatingOrder:          General
         ColumnHidden:    False
         ColumnOrder:     Default
         ColumnWidth:     1530
         DataUpdatable:   False
         DecimalPlaces:   Auto
         Description:     Nature of new Job - cross-reference to control table
         DisplayControl:          Text Box
         OrdinalPosition:         12
         Required:        False
         SourceField:     NatureOfJobID
         SourceTable:     MApplication
         Paid     Text     3
         AllowZeroLength:         False
         Attributes:      Variable Length
         CollatingOrder:          General
         ColumnHidden:    False
         ColumnOrder:     Default
         ColumnWidth:     585
         DataUpdatable:   False
         Description:     Whether Paid or not - Yes/No/IC (IC=Independent Consultant)
         DisplayControl:          Text Box
         OrdinalPosition:         13
         Required:        False
         SourceField:     Paid


Table: MApplication      Page: 76
         SourceTable:     MApplication
         ValidationText:          Paid must be Yes, No or IC
         Hours    Text     2
         AllowZeroLength:         False
         Attributes:      Variable Length
         CollatingOrder:          General
         ColumnHidden:    False
         ColumnOrder:     Default
         ColumnWidth:     690
         DataUpdatable:   False
         Description:     Hours ("FT" or "PT)
         DisplayControl:          Text Box
         OrdinalPosition:         14
         Required:        False
         SourceField:     Hours
         SourceTable:     MApplication
         ValidationRule:          "FT" Or "PT" Or Is Null
         ValidationText:          Hours must be FT or PT
         DeptAndEmployer  Yes/No   1
         AllowZeroLength:         False
         Attributes:      Fixed Size
         CollatingOrder:          General
         ColumnHidden:    False
         ColumnOrder:     Default
         ColumnWidth:     1425
         DataUpdatable:   False
         Description:     (Involved in contractual matters between dept and new employer)
         DisplayControl:          106
         Format:          Yes/No
         OrdinalPosition:         15
         Required:        False
         SourceField:     DeptAndEmployer
         SourceTable:     MApplication
         EmployerAndOthers        Text     3
         AllowZeroLength:         False
         Attributes:      Variable Length
         CollatingOrder:          General
         ColumnHidden:    False
         ColumnOrder:     Default
         ColumnWidth:     1590
         DataUpdatable:   False
         Description:     (Involved in contractual matters between new employer and other
         parties)
         DisplayControl:          Text Box
         OrdinalPosition:         16
         Required:        False
         SourceField:     EmployerAndOthers
         SourceTable:     MApplication
         ContractValue    Double   8
         AllowZeroLength:         False
         Attributes:      Fixed Size


Table: MApplication      Page: 77
         CollatingOrder:          General
         ColumnHidden:    False
         ColumnOrder:     Default
         ColumnWidth:     1500
         DataUpdatable:   False
         DecimalPlaces:   Auto
         Description:     Total value of Contract(s) in £
         DisplayControl:          Text Box
         OrdinalPosition:         17
         Required:        False
         SourceField:     ContractValue
         SourceTable:     MApplication
         NonContractualContact    Text     3
         AllowZeroLength:         False
         Attributes:      Variable Length
         CollatingOrder:          General
         ColumnHidden:    False
         ColumnOrder:     Default
         ColumnWidth:     2340
         DataUpdatable:   False
         Description:     Non-contractual Contact - Yes/No or Null
         DisplayControl:          Text Box
         OrdinalPosition:         18
         Required:        False
         SourceField:     NonContractualContact
         SourceTable:     MApplication
         RegulatoryContact        Yes/No   1
         AllowZeroLength:         False
         Attributes:      Fixed Size
         CollatingOrder:          General
         ColumnHidden:    False
         ColumnOrder:     Default
         ColumnWidth:     1905
         DataUpdatable:   False
         Description:     Regulatory Contract? (Yes/No)
         DisplayControl:          106
         Format:          Yes/No
         OrdinalPosition:         19
         Required:        False
         SourceField:     RegulatoryContact
         SourceTable:     MApplication
         PrivatisationInvolvement         Yes/No   1
         AllowZeroLength:         False
         Attributes:      Fixed Size
         CollatingOrder:          General
         ColumnHidden:    False
         ColumnOrder:     Default
         ColumnWidth:     2505
         DataUpdatable:   False
         Description:     Privatisation Involvement? (Yes/No)
         DisplayControl:          106
         Format:          Yes/No
         OrdinalPosition:         20


Table: MApplication      Page: 78
         Required:        False
         SourceField:     PrivatisationInvolvement
         SourceTable:     MApplication
         AccessToSecrets  Text     3
         AllowZeroLength:         False
         Attributes:      Variable Length
         CollatingOrder:          General
         ColumnHidden:    False
         ColumnOrder:     Default
         ColumnWidth:     1740
         DataUpdatable:   False
         Description:     Access to Trade Secrets? (Yes/No/Null)
         DisplayControl:          Text Box
         OrdinalPosition:         21
         Required:        False
         SourceField:     AccessToSecrets
         SourceTable:     MApplication
         ConcernRewards   Yes/No   1
         AllowZeroLength:         False
         Attributes:      Fixed Size
         CollatingOrder:          General
         ColumnHidden:    False
         ColumnOrder:     Default
         ColumnWidth:     1770
         DataUpdatable:   False
         Description:     Cause for Concern - Rewards? (Yes/No)
         DisplayControl:          106
         Format:          Yes/No
         OrdinalPosition:         22
         Required:        False
         SourceField:     ConcernRewards
         SourceTable:     MApplication
         ConcernSecrets   Yes/No   1
         AllowZeroLength:         False
         Attributes:      Fixed Size
         CollatingOrder:          General
         ColumnHidden:    False
         ColumnOrder:     Default
         ColumnWidth:     1644
         DataUpdatable:   False
         Description:     Cause for Concern - Trade Secrets? (Yes/No)
         DisplayControl:          106
         Format:          Yes/No
         OrdinalPosition:         23
         Required:        False
         SourceField:     ConcernSecrets
         SourceTable:     MApplication
         ConcernPolicy    Yes/No   1
         AllowZeroLength:         False
         Attributes:      Fixed Size
         CollatingOrder:          General
         ColumnHidden:    False


Table: MApplication      Page: 79
         ColumnOrder:     Default
         ColumnWidth:     Default
         DataUpdatable:   False
         Description:     Cause for Concern - Impending Policy? (Yes/No)
         DisplayControl:          106
         Format:          Yes/No
         OrdinalPosition:         24
         Required:        False
         SourceField:     ConcernPolicy
         SourceTable:     MApplication
         ConcernPerceptionOnly    Yes/No   1
         AllowZeroLength:         False
         Attributes:      Fixed Size
         CollatingOrder:          General
         ColumnHidden:    False
         ColumnOrder:     Default
         ColumnWidth:     Default
         DataUpdatable:   False
         Description:     Cause for Concern - Public Perception? (Yes/No)
         DisplayControl:          106
         Format:          Yes/No
         OrdinalPosition:         25
         Required:        False
         SourceField:     ConcernPerceptionOnly
         SourceTable:     MApplication
         ConcernOther     Yes/No   1
         AllowZeroLength:         False
         Attributes:      Fixed Size
         CollatingOrder:          General
         ColumnHidden:    False
         ColumnOrder:     Default
         ColumnWidth:     Default
         DataUpdatable:   False
         Description:     Cause for Concern - Other? (Yes/No)
         DisplayControl:          106
         Format:          Yes/No
         OrdinalPosition:         26
         Required:        False
         SourceField:     ConcernOther
         SourceTable:     MApplication
         ApprovedUnconditionally  Text     3
         AllowZeroLength:         False
         Attributes:      Variable Length
         CollatingOrder:          General
         ColumnHidden:    False
         ColumnOrder:     Default
         ColumnWidth:     2550
         DataUpdatable:   False
         Description:     Application Approved Unconditionally?(inc. where automatic waiting
         period, if relevant, was waived or has expired)
         DisplayControl:          Text Box
         OrdinalPosition:         27
         Required:        False


Table: MApplication      Page: 80
         SourceField:     ApprovedUnconditionally
         SourceTable:     MApplication
         AutoWaitApplies  Yes/No   1
         AllowZeroLength:         False
         Attributes:      Fixed Size
         CollatingOrder:          General
         ColumnHidden:    False
         ColumnOrder:     Default
         ColumnWidth:     1725
         DataUpdatable:   False
         Description:     Does the automatic waiting period apply to this Grade/Rank?
         DisplayControl:          106
         Format:          Yes/No
         OrdinalPosition:         28
         Required:        False
         SourceField:     AutoWaitApplies
         SourceTable:     MApplication
         AutoWaitAction   Text     1
         AllowZeroLength:         False
         Attributes:      Variable Length
         CollatingOrder:          General
         ColumnHidden:    False
         ColumnOrder:     Default
         ColumnWidth:     Default
         DataUpdatable:   False
         Description:     Automatic waiting period: (A)pplied, (E)xpired, (L)engthened, (W)aived
         DisplayControl:          Text Box
         OrdinalPosition:         29
         Required:        False
         SourceField:     AutoWaitAction
         SourceTable:     MApplication
         ValidationRule:          "A" Or "E" Or "L" Or "W" Or Is Null
         ValidationText:          If present, Auto Wait must be A, E, L or W
         WaitingPeriodAdvised     Yes/No   1
         AllowZeroLength:         False
         Attributes:      Fixed Size
         CollatingOrder:          General
         ColumnHidden:    False
         ColumnOrder:     Default
         ColumnWidth:     Default
         DataUpdatable:   False
         Description:     Only allowed if approved uncoditionally = N
         DisplayControl:          106
         Format:          Yes/No
         OrdinalPosition:         30
         Required:        False
         SourceField:     WaitingPeriodAdvised
         SourceTable:     MApplication
         WaitingPeriodLength      Long Integer     4
         AllowZeroLength:         False


Table: MApplication      Page: 81
         Attributes:      Fixed Size
         CollatingOrder:          General
         ColumnHidden:    False
         ColumnOrder:     Default
         ColumnWidth:     Default
         DataUpdatable:   False
         DecimalPlaces:   Auto
         Description:     Length of waiting period ([mm] months)
         DisplayControl:          Text Box
         OrdinalPosition:         31
         Required:        False
         SourceField:     WaitingPeriodLength
         SourceTable:     MApplication
         ValidationRule:          Between 0 And 24 Or Is Null
         ValidationText:          Waiting period must be between 0 and 24 months
         ConsideredUnsuitable     Yes/No   1
         AllowZeroLength:         False
         Attributes:      Fixed Size
         CollatingOrder:          General
         ColumnHidden:    False
         ColumnOrder:     Default
         ColumnWidth:     Default
         DataUpdatable:   False
         Description:     Application considered unsuitable
         DisplayControl:          106
         Format:          Yes/No
         OrdinalPosition:         32
         Required:        False
         SourceField:     ConsideredUnsuitable
         SourceTable:     MApplication
         UnsuitableDuration       Integer  2
         AllowZeroLength:         False
         Attributes:      Fixed Size
         CollatingOrder:          General
         ColumnHidden:    False
         ColumnOrder:     Default
         ColumnWidth:     Default
         DataUpdatable:   False
         DecimalPlaces:   Auto
         Description:     Length considered unsuitable ([mm] months)
         DisplayControl:          Text Box
         OrdinalPosition:         33
         Required:        False
         SourceField:     UnsuitableDuration
         SourceTable:     MApplication
         ValidationRule:          Between 0 And 24 Or Is Null
         ValidationText:          Unsuitable duration must be between 0 and 24 months
         UndertakingAdvised       Yes/No   1
         AllowZeroLength:         False
         Attributes:      Fixed Size
         CollatingOrder:          General
         ColumnHidden:    False
         ColumnOrder:     Default


Table: MApplication      Page: 82
         ColumnWidth:     Default
         DataUpdatable:   False
         DisplayControl:          106
         Format:          Yes/No
         OrdinalPosition:         34
         Required:        False
         SourceField:     UndertakingAdvised
         SourceTable:     MApplication
         UndertakingNature        Memo     -
         AllowZeroLength:         False
         Attributes:      Variable Length
         CollatingOrder:          General
         ColumnHidden:    False
         ColumnOrder:     Default
         ColumnWidth:     Default
         DataUpdatable:   False
         Description:     Nature of undertaking
         OrdinalPosition:         35
         Required:        False
         SourceField:     UndertakingNature
         SourceTable:     MApplication
         UndertakingLength        Integer  2
         AllowZeroLength:         False
         Attributes:      Fixed Size
         CollatingOrder:          General
         ColumnHidden:    False
         ColumnOrder:     Default
         ColumnWidth:     Default
         DataUpdatable:   False
         DecimalPlaces:   Auto
         Description:     Length of undertaking ([mm] months)
         DisplayControl:          Text Box
         OrdinalPosition:         36
         Required:        False
         SourceField:     UndertakingLength
         SourceTable:     MApplication
         ValidationRule:          Between 0 And 24 Or Is Null
         ValidationText:          Undertaking length must be between 0 and 24 months
         InternalQuarantine       Text     3
         AllowZeroLength:         False
         Attributes:      Variable Length
         CollatingOrder:          General
         ColumnHidden:    False
         ColumnOrder:     Default
         ColumnWidth:     Default
         DataUpdatable:   False
         Description:     Internal Quarantine? (Yes/No)
         DisplayControl:          Text Box
         OrdinalPosition:         37
         Required:        False
         SourceField:     InternalQuarantine
         SourceTable:     MApplication
         ValidationRule:          "Yes" Or "No" Or Is Null


Table: MApplication      Page: 83
         QuarantineLength         Byte     1
         AllowZeroLength:         False
         Attributes:      Fixed Size
         CollatingOrder:          General
         ColumnHidden:    False
         ColumnOrder:     Default
         ColumnWidth:     Default
         DataUpdatable:   False
         DecimalPlaces:   Auto
         Description:     Length of Internal Quarantine in months
         DisplayControl:          Text Box
         OrdinalPosition:         38
         Required:        False
         SourceField:     QuarantineLength
         SourceTable:     MApplication
         ValidationRule:          Between 0 And 24 Or Is Null
         ValidationText:          Length of Internal Quarantine must be between 0 and 24 months
         FollowUp         Text     3
         AllowZeroLength:         False
         Attributes:      Variable Length
         CollatingOrder:          General
         ColumnHidden:    False
         ColumnOrder:     Default
         ColumnWidth:     Default
         DataUpdatable:   False
         Description:     Outcome to be followed up by department? (Yes/No)
         DisplayControl:          Text Box
         OrdinalPosition:         39
         Required:        False
         SourceField:     FollowUp
         SourceTable:     MApplication
         ValidationRule:          "Yes" Or "No" Or Is Null
         Precedents       Text     50
         AllowZeroLength:         False
         Attributes:      Variable Length
         CollatingOrder:          General
         ColumnHidden:    False
         ColumnOrder:     Default
         ColumnWidth:     Default
         DataUpdatable:   False
         Description:     Precedents used for this application (Applicant ID numbers, free text)
         DisplayControl:          Text Box
         OrdinalPosition:         40
         Required:        False
         SourceField:     Precedents
         SourceTable:     MApplication
         AdviseFollowed   Yes/No   1
         AllowZeroLength:         False
         Attributes:      Fixed Size
         CollatingOrder:          General
         ColumnHidden:    False
         ColumnOrder:     Default
         ColumnWidth:     Default


Table: MApplication      Page: 84
         DataUpdatable:   False
         Description:     ACOBA's advise followed
         DisplayControl:          106
         Format:          Yes/No
         OrdinalPosition:         41
         Required:        False
         SourceField:     AdviseFollowed
         SourceTable:     MApplication
         AnnouncementMade         Text     1
         AllowZeroLength:         True
         Attributes:      Variable Length
         CollatingOrder:          General
         ColumnHidden:    False
         ColumnOrder:     Default
         ColumnWidth:     Default
         DataUpdatable:   False
         DisplayControl:          Text Box
         OrdinalPosition:         42
         Required:        False
         SourceField:     AnnouncementMade
         SourceTable:     MApplication
         ValidationRule:          "Y" Or "N" Or "U" Or Is Null
         ExpectedStart    Date/Time        8
         AllowZeroLength:         False
         Attributes:      Fixed Size
         CollatingOrder:          General
         ColumnHidden:    False
         ColumnOrder:     Default
         ColumnWidth:     Default
         DataUpdatable:   False
         Description:     Date appointment expected to start
         OrdinalPosition:         43
         Required:        False
         SourceField:     ExpectedStart
         SourceTable:     MApplication
         AppointmentAccepted      Text     3
         AllowZeroLength:         False
         Attributes:      Variable Length
         CollatingOrder:          General
         ColumnHidden:    False
         ColumnOrder:     Default
         ColumnWidth:     Default
         DataUpdatable:   False
         Description:     Appointment taken up
         DisplayControl:          Text Box
         OrdinalPosition:         44
         Required:        False
         SourceField:     AppointmentAccepted
         SourceTable:     MApplication
         ValidationRule:          "Y" Or "N" Or "U" Or Is Null
         DateTakenUp      Date/Time        8
         AllowZeroLength:         False


Table: MApplication      Page: 85
         Attributes:      Fixed Size
         CollatingOrder:          General
         ColumnHidden:    False
         ColumnOrder:     Default
         ColumnWidth:     Default
         DataUpdatable:   False
         Description:     Date appointment actually taken up
         OrdinalPosition:         45
         Required:        False
         SourceField:     DateTakenUp
         SourceTable:     MApplication
         Comments         Memo     -
         AllowZeroLength:         False
         Attributes:      Variable Length
         CollatingOrder:          General
         ColumnHidden:    False
         ColumnOrder:     Default
         ColumnWidth:     Default
         DataUpdatable:   False
         Description:     Appointment Comments
         OrdinalPosition:         46
         Required:        False
         SourceField:     Comments
         SourceTable:     MApplication
         _OLDreportComment1       Memo     -
         AllowZeroLength:         False
         Attributes:      Variable Length
         CollatingOrder:          General
         ColumnHidden:    False
         ColumnOrder:     Default
         ColumnWidth:     Default
         DataUpdatable:   False
         Description:     *** NO Longer USED ***Comments for end of year reports
         OrdinalPosition:         47
         Required:        False
         SourceField:     _OLDreportComment1
         SourceTable:     MApplication
         Relationships
         NatureOfJobMApplication
         NatureOfJob      MApplication
         NatureOfJobID    1        ¥         NatureOfJobID
         Attributes:      Enforced, Right Join
         RelationshipType:        One-To-Many


Table: MApplication      Page: 86
         NatureOfBusinessMApplication
         NatureOfBusiness         MApplication
         NatureOfBusinessID       1        ¥         NatureOfBusinessID
         Attributes:      Enforced, Right Join
         RelationshipType:        One-To-Many
         MAPPLICANTMApplication
         MAPPLICANT       MApplication
         ApplicantID      1        ¥         ApplicantID
         Attributes:      Enforced, Cascade Updates, Cascade Deletes
         RelationshipType:        One-To-Many
         Table Indexes
         Name     Number of Fields
         03C6F4F6-5728-4594-9664-EC27BE62C0FE     1
         Clustered:       False
         DistinctCount:   13
         Foreign:         True
         IgnoreNulls:     False
         Name:    03C6F4F6-5728-4594-9664-EC27BE62C0FE
         Primary:         False
         Required:        False
         Unique:          False
         Fields:
         NatureOfJobID    Ascending
         3383A1F0-334E-4F91-A7EF-         1
         Clustered:       False
         DistinctCount:   21
         Foreign:         True
         IgnoreNulls:     False
         Name:    3383A1F0-334E-4F91-A7EF-2D14275F74C5
         Primary:         False
         Required:        False
         Unique:          False
         Fields:
         NatureOfBusinessID       Ascending
         6B5898F9-30BD-406B-8054-453C38D12721     1
         Clustered:       False
         DistinctCount:   140
         Foreign:         True
         IgnoreNulls:     False
         Name:    6B5898F9-30BD-406B-8054-453C38D12721
         Primary:         False
         Required:        False


Table: MApplication      Page: 87
         Unique:          False
         Fields:
         ApplicantID      Ascending
         Application      2
         Clustered:       False
         DistinctCount:   464
         Foreign:         False
         IgnoreNulls:     False
         Name:    Application
         Primary:         False
         Required:        False
         Unique:          True
         Fields:
         ApplicantID      Ascending
         ApplicationID    Ascending
         NatureOfBusiness         1
         Clustered:       False
         DistinctCount:   21
         Foreign:         False
         IgnoreNulls:     False
         Name:    NatureOfBusiness
         Primary:         False
         Required:        False
         Unique:          False
         Fields:
         NatureOfBusinessID       Ascending
         NatureOfJob      1
         Clustered:       False
         DistinctCount:   13
         Foreign:         False
         IgnoreNulls:     False
         Name:    NatureOfJob
         Primary:         False
         Required:        False
         Unique:          False
         Fields:
         NatureOfJobID    Ascending
         Paid     1
         Clustered:       False
         DistinctCount:   3
         Foreign:         False
         IgnoreNulls:     False
         Name:    Paid
         Primary:         False
         Required:        False
         Unique:          False
         Fields:
         Paid     Ascending
         PrimaryKey       1
         Clustered:       False
         DistinctCount:   464
         Foreign:         False
         IgnoreNulls:     False


Table: MApplication      Page: 88
         Name:    PrimaryKey
         Primary:         True
         Required:        True
         Unique:          True
         Fields:
         recordID         Ascending
         User Permissions
         admin
         Group Permissions
         Admins
         Users    Delete, Read Permissions, Set Permissions, Change Owner, Read Definition, Write
         Definition, Read Data, Insert Data, Update Data, Delete Data


Table: MQueryDefinition  Page: 89
         Columns
         Name     Type     Size
         QueryID  Long Integer     4
         AllowZeroLength:         False
         Attributes:      Fixed Size, Auto-Increment
         CollatingOrder:          General
         ColumnHidden:    False
         ColumnOrder:     Default
         ColumnWidth:     Default
         DataUpdatable:   False
         OrdinalPosition:         0
         Required:        False
         SourceField:     QueryID
         SourceTable:     MQueryDefinition
         UserQuery        Yes/No   1
         AllowZeroLength:         False
         Attributes:      Fixed Size
         CollatingOrder:          General
         ColumnHidden:    False
         ColumnOrder:     Default
         ColumnWidth:     Default
         DataUpdatable:   False
         Description:     User defined query
         DisplayControl:          106
         Format:          Yes/No
         OrdinalPosition:         1
         Required:        False
         SourceField:     UserQuery
         SourceTable:     MQueryDefinition
         QueryName        Text     64
         AllowZeroLength:         False
         Attributes:      Variable Length
         CollatingOrder:          General
         ColumnHidden:    False
         ColumnOrder:     Default
         ColumnWidth:     2610
         DataUpdatable:   False
         Description:     (ONLY if UserQuery = True) Name of Query exactly as saved in the
         database
         DisplayControl:          Text Box
         OrdinalPosition:         2
         Required:        False
         SourceField:     QueryName
         SourceTable:     MQueryDefinition


Table: MQueryDefinition  Page: 90
         QueryFileName    Text     50
         AllowZeroLength:         False
         Attributes:      Variable Length
         CollatingOrder:          General
         ColumnHidden:    False
         ColumnOrder:     Default
         ColumnWidth:     1860
         DataUpdatable:   False
         DisplayControl:          Text Box
         OrdinalPosition:         3
         Required:        False
         SourceField:     QueryFileName
         SourceTable:     MQueryDefinition
         QueryField       Text     255
         AllowZeroLength:         False
         Attributes:      Variable Length
         CollatingOrder:          General
         ColumnHidden:    False
         ColumnOrder:     Default
         ColumnWidth:     1752
         DataUpdatable:   False
         DisplayControl:          Text Box
         OrdinalPosition:         4
         Required:        False
         SourceField:     QueryField
         SourceTable:     MQueryDefinition
         QueryFunction    Text     255
         AllowZeroLength:         False
         Attributes:      Variable Length
         CollatingOrder:          General
         ColumnHidden:    False
         ColumnOrder:     Default
         ColumnWidth:     1776
         DataUpdatable:   False
         DisplayControl:          Text Box
         OrdinalPosition:         5
         Required:        False
         SourceField:     QueryFunction
         SourceTable:     MQueryDefinition
         Parameter1       Text     255
         AllowZeroLength:         False
         Attributes:      Variable Length
         CollatingOrder:          General
         ColumnHidden:    False
         ColumnOrder:     Default
         ColumnWidth:     2250
         DataUpdatable:   False
         Description:     Fieldname of first parameter in this query (* indicates optional use of
         wildcard before/after parameter value)
         DisplayControl:          Text Box
         OrdinalPosition:         6
         Required:        False
         SourceField:     Parameter1


Table: MQueryDefinition  Page: 91
         SourceTable:     MQueryDefinition
         Parameter2       Text     255
         AllowZeroLength:         False
         Attributes:      Variable Length
         CollatingOrder:          General
         ColumnHidden:    False
         ColumnOrder:     Default
         ColumnWidth:     2070
         DataUpdatable:   False
         Description:     Fieldname of second parameter in this query (* indicates optional use of
         wildcard before/after parameter value)
         DisplayControl:          Text Box
         OrdinalPosition:         7
         Required:        False
         SourceField:     Parameter2
         SourceTable:     MQueryDefinition
         Table Indexes
         Name     Number of Fields
         PrimaryKey       1
         Clustered:       False
         DistinctCount:   55
         Foreign:         False
         IgnoreNulls:     False
         Name:    PrimaryKey
         Primary:         True
         Required:        True
         Unique:          True
         Fields:
         QueryID  Ascending
         QueryName        1
         Clustered:       False
         DistinctCount:   55
         Foreign:         False
         IgnoreNulls:     False
         Name:    QueryName
         Primary:         False
         Required:        False
         Unique:          True
         Fields:
         QueryName        Ascending
         User Permissions
         admin
         Group Permissions
         Admins


Table: MQueryDefinition  Page: 92
         Users    Delete, Read Permissions, Set Permissions, Change Owner, Read Definition, Write
         Definition, Read Data, Insert Data, Update Data, Delete Data


Table: MQueryFields      Page: 93
         Columns
         Name     Type     Size
         fieldName        Text     64
         AllowZeroLength:         False
         Attributes:      Variable Length
         CollatingOrder:          General
         ColumnHidden:    False
         ColumnOrder:     Default
         ColumnWidth:     2700
         DataUpdatable:   False
         DisplayControl:          Text Box
         OrdinalPosition:         0
         Required:        False
         SourceField:     fieldName
         SourceTable:     MQueryFields
         fieldType        Text     20
         AllowZeroLength:         False
         Attributes:      Variable Length
         CollatingOrder:          General
         ColumnHidden:    False
         ColumnOrder:     Default
         ColumnWidth:     Default
         DataUpdatable:   False
         DisplayControl:          Text Box
         OrdinalPosition:         1
         Required:        False
         SourceField:     fieldType
         SourceTable:     MQueryFields
         fieldSize        Text     50
         AllowZeroLength:         False
         Attributes:      Variable Length
         CollatingOrder:          General
         ColumnHidden:    False
         ColumnOrder:     Default
         ColumnWidth:     Default
         DataUpdatable:   False
         DisplayControl:          Text Box
         OrdinalPosition:         2
         Required:        False
         SourceField:     fieldSize
         SourceTable:     MQueryFields
         fieldDescription         Text     128
         AllowZeroLength:         False


Table: MQueryFields      Page: 94
         Attributes:      Variable Length
         CollatingOrder:          General
         ColumnHidden:    False
         ColumnOrder:     Default
         ColumnWidth:     1635
         DataUpdatable:   False
         DisplayControl:          Text Box
         OrdinalPosition:         3
         Required:        False
         SourceField:     fieldDescription
         SourceTable:     MQueryFields
         fieldIncluded    Yes/No   1
         AllowZeroLength:         False
         Attributes:      Fixed Size
         CollatingOrder:          General
         ColumnHidden:    False
         ColumnOrder:     Default
         ColumnWidth:     Default
         DataUpdatable:   False
         DisplayControl:          106
         Format:          Yes/No
         OrdinalPosition:         4
         Required:        False
         SourceField:     fieldIncluded
         SourceTable:     MQueryFields
         highLight        Yes/No   1
         AllowZeroLength:         False
         Attributes:      Fixed Size
         CollatingOrder:          General
         ColumnHidden:    False
         ColumnOrder:     Default
         ColumnWidth:     Default
         DataUpdatable:   False
         DisplayControl:          106
         Format:          Yes/No
         OrdinalPosition:         5
         Required:        False
         SourceField:     highLight
         SourceTable:     MQueryFields
         Table Indexes
         Name     Number of Fields
         PrimaryKey       1
         Clustered:       False
         DistinctCount:   92
         Foreign:         False
         IgnoreNulls:     False
         Name:    PrimaryKey
         Primary:         True
         Required:        True
         Unique:          True


Table: MQueryFields      Page: 95
         Fields:
         fieldName        Ascending
         User Permissions
         admin
         Group Permissions
         Admins
         Users    Delete, Read Permissions, Set Permissions, Change Owner, Read Definition, Write
         Definition, Read Data, Insert Data, Update Data, Delete Data


Table: MQueryLog         Page: 96
         Columns
         Name     Type     Size
         UserName         Text     20
         AllowZeroLength:         False
         Attributes:      Variable Length
         CollatingOrder:          General
         ColumnHidden:    False
         ColumnOrder:     Default
         ColumnWidth:     Default
         DataUpdatable:   False
         Description:     Name of the User who ran or is running the search
         DisplayControl:          Text Box
         OrdinalPosition:         0
         Required:        False
         SourceField:     UserName
         SourceTable:     MQueryLog
         QuerySequence    Byte     1
         AllowZeroLength:         False
         Attributes:      Fixed Size
         CollatingOrder:          General
         ColumnHidden:    False
         ColumnOrder:     Default
         ColumnWidth:     1680
         DataUpdatable:   False
         DecimalPlaces:   Auto
         Description:     Sequence No of the query in this search (always starts at 1)
         DisplayControl:          Text Box
         OrdinalPosition:         1
         Required:        False
         SourceField:     QuerySequence
         SourceTable:     MQueryLog
         QueryID  Long Integer     4
         AllowZeroLength:         False
         Attributes:      Fixed Size
         CollatingOrder:          General
         ColumnHidden:    False
         ColumnOrder:     Default
         ColumnWidth:     Default
         DataUpdatable:   False
         DecimalPlaces:   Auto
         Description:     ID of the Query (cross-reference to MQueryDefinition control table)
         DisplayControl:          Text Box
         OrdinalPosition:         2
         Required:        False


Table: MQueryLog         Page: 97
         SourceField:     QueryID
         SourceTable:     MQueryLog
         Parameter1       Text     255
         AllowZeroLength:         False
         Attributes:      Variable Length
         CollatingOrder:          General
         ColumnHidden:    False
         ColumnOrder:     Default
         ColumnWidth:     2400
         DataUpdatable:   False
         Description:     Value of first parameter in the query (or "<<none>>" if no first
         parameter)
         DisplayControl:          Text Box
         OrdinalPosition:         3
         Required:        False
         SourceField:     Parameter1
         SourceTable:     MQueryLog
         Parameter2       Text     255
         AllowZeroLength:         False
         Attributes:      Variable Length
         CollatingOrder:          General
         ColumnHidden:    False
         ColumnOrder:     Default
         ColumnWidth:     2235
         DataUpdatable:   False
         Description:     Value of second parameter in the query (or "<<none>>" if no second
         parameter)
         DisplayControl:          Text Box
         OrdinalPosition:         4
         Required:        False
         SourceField:     Parameter2
         SourceTable:     MQueryLog
         RecordCount      Long Integer     4
         AllowZeroLength:         False
         Attributes:      Fixed Size
         CollatingOrder:          General
         ColumnHidden:    False
         ColumnOrder:     Default
         ColumnWidth:     Default
         DataUpdatable:   False
         DecimalPlaces:   Auto
         Description:     Number of records returned when this query was run
         DisplayControl:          Text Box
         OrdinalPosition:         5
         Required:        False
         SourceField:     RecordCount
         SourceTable:     MQueryLog
         Table Indexes
         Name     Number of Fields


Table: MQueryLog         Page: 98
         PrimaryKey       2
         Clustered:       False
         DistinctCount:   11
         Foreign:         False
         IgnoreNulls:     False
         Name:    PrimaryKey
         Primary:         True
         Required:        True
         Unique:          True
         Fields:
         UserName         Ascending
         QuerySequence    Ascending
         QueryID  1
         Clustered:       False
         DistinctCount:   7
         Foreign:         False
         IgnoreNulls:     False
         Name:    QueryID
         Primary:         False
         Required:        False
         Unique:          False
         Fields:
         QueryID  Ascending
         User Permissions
         admin
         Group Permissions
         Admins
         Users    Delete, Read Permissions, Set Permissions, Change Owner, Read Definition, Write
         Definition, Read Data, Insert Data, Update Data, Delete Data


Table: MQueryResult      Page: 99
         Columns
         Name     Type     Size
         TimeStamp        Date/Time        8
         AllowZeroLength:         False
         Attributes:      Variable Length
         CollatingOrder:          General
         ColumnHidden:    False
         ColumnOrder:     Default
         ColumnWidth:     Default
         DataUpdatable:   False
         OrdinalPosition:         0
         Required:        False
         SourceField:     TimeStamp
         SourceTable:     MQueryResult
         UserName         Text     255
         AllowZeroLength:         False
         Attributes:      Variable Length
         CollatingOrder:          General
         ColumnHidden:    False
         ColumnOrder:     Default
         ColumnWidth:     Default
         DataUpdatable:   False
         DisplayControl:          Text Box
         OrdinalPosition:         1
         Required:        False
         SourceField:     UserName
         SourceTable:     MQueryResult
         QuerySequence    Long Integer     4
         AllowZeroLength:         False
         Attributes:      Variable Length
         CollatingOrder:          General
         ColumnHidden:    False
         ColumnOrder:     Default
         ColumnWidth:     Default
         DataUpdatable:   False
         DecimalPlaces:   Auto
         DisplayControl:          Text Box
         OrdinalPosition:         2
         Required:        False
         SourceField:     QuerySequence
         SourceTable:     MQueryResult
         recordID         Long Integer     4
         AllowZeroLength:         False


Table: MQueryResult      Page: 100
         Attributes:      Fixed Size
         CollatingOrder:          General
         ColumnHidden:    False
         ColumnOrder:     Default
         ColumnWidth:     Default
         DataUpdatable:   False
         DecimalPlaces:   Auto
         DisplayControl:          Text Box
         OrdinalPosition:         3
         Required:        False
         SourceField:     recordID
         SourceTable:     MQueryResult
         applicantId      Long Integer     4
         AllowZeroLength:         False
         Attributes:      Fixed Size
         CollatingOrder:          General
         ColumnHidden:    False
         ColumnOrder:     Default
         ColumnWidth:     Default
         DataUpdatable:   False
         DecimalPlaces:   Auto
         DisplayControl:          Text Box
         OrdinalPosition:         4
         Required:        False
         SourceField:     applicantId
         SourceTable:     MQueryResult
         Table Indexes
         Name     Number of Fields
         applicantId      1
         Clustered:       False
         DistinctCount:   141
         Foreign:         False
         IgnoreNulls:     False
         Name:    applicantId
         Primary:         False
         Required:        False
         Unique:          False
         Fields:
         applicantId      Ascending
         recordID         1
         Clustered:       False
         DistinctCount:   464
         Foreign:         False
         IgnoreNulls:     False
         Name:    recordID
         Primary:         False
         Required:        False
         Unique:          False
         Fields:
         recordID         Ascending


Table: MQueryResult      Page: 101
         admin
         Group Permissions
         Admins
         Users    Delete, Read Permissions, Set Permissions, Change Owner, Read Definition, Write
         Definition, Read Data, Insert Data, Update Data, Delete Data


Table: MReasonForLeaving         Page: 102
         Columns
         Name     Type     Size
         MReasonForLeavingID      Long Integer     4
         AllowZeroLength:         False
         Attributes:      Fixed Size, Auto-Increment
         CollatingOrder:          General
         ColumnHidden:    False
         ColumnOrder:     Default
         ColumnWidth:     2130
         DataUpdatable:   False
         OrdinalPosition:         0
         Required:        False
         SourceField:     MReasonForLeavingID
         SourceTable:     MReasonForLeaving
         MReasonForLeavingAbbrev  Text     5
         AllowZeroLength:         False
         Attributes:      Variable Length
         CollatingOrder:          General
         ColumnHidden:    False
         ColumnOrder:     Default
         ColumnWidth:     2610
         DataUpdatable:   False
         Description:     Abbreviated Ministers Reason For Leaving (up to 5 characters)
         DisplayControl:          Text Box
         OrdinalPosition:         1
         Required:        False
         SourceField:     MReasonForLeavingAbbrev
         SourceTable:     MReasonForLeaving
         MReasonForLeavingDescription     Text     255
         AllowZeroLength:         False
         Attributes:      Variable Length
         CollatingOrder:          General
         ColumnHidden:    False
         ColumnOrder:     Default
         ColumnWidth:     4020
         DataUpdatable:   False
         Description:     Ministers Reason For Leaving Description (up to 255 characters)
         DisplayControl:          Text Box
         OrdinalPosition:         2
         Required:        False
         SourceField:     MReasonForLeavingDescription
         SourceTable:     MReasonForLeaving
         MActiveFlag      Yes/No   1


Table: MReasonForLeaving         Page: 103
         AllowZeroLength:         False
         Attributes:      Fixed Size
         CollatingOrder:          General
         ColumnHidden:    False
         ColumnOrder:     Default
         ColumnWidth:     2520
         DataUpdatable:   False
         Description:     Is this Ministers Reason For Leaving a current one available for new
         Applicants? (Yes/No)
         DisplayControl:          106
         Format:          Yes/No
         OrdinalPosition:         3
         Required:        False
         SourceField:     MActiveFlag
         SourceTable:     MReasonForLeaving
         Relationships
         MReasonForLeavingMAPPLICANT
         MReasonForLeaving        MAPPLICANT
         MReasonForLeavingID      1        ¥         ReasonForLeavingID
         Attributes:      Enforced, Right Join
         RelationshipType:        One-To-Many
         Table Indexes
         Name     Number of Fields
         PrimaryKey       1
         Clustered:       False
         DistinctCount:   5
         Foreign:         False
         IgnoreNulls:     False
         Name:    PrimaryKey
         Primary:         True
         Required:        True
         Unique:          True
         Fields:
         MReasonForLeavingID      Ascending
         ReasonForLeavingID       1
         Clustered:       False
         DistinctCount:   5
         Foreign:         False
         IgnoreNulls:     False
         Name:    ReasonForLeavingID
         Primary:         False
         Required:        False
         Unique:          False
         Fields:
         MReasonForLeavingID      Ascending


Table: MReasonForLeaving         Page: 104
         User Permissions
         admin
         Group Permissions
         Admins
         Users    Delete, Read Permissions, Set Permissions, Change Owner, Read Definition, Write
         Definition, Read Data, Insert Data, Update Data, Delete Data


Table: MReportComments   Page: 105
         Columns
         Name     Type     Size
         RecordID         Long Integer     4
         AllowZeroLength:         False
         Attributes:      Fixed Size
         CollatingOrder:          General
         ColumnHidden:    False
         ColumnOrder:     Default
         ColumnWidth:     Default
         DataUpdatable:   False
         DecimalPlaces:   Auto
         DisplayControl:          Text Box
         OrdinalPosition:         0
         Required:        True
         SourceField:     RecordID
         SourceTable:     MReportComments
         comment1         Memo     -
         AllowZeroLength:         False
         Attributes:      Variable Length
         CollatingOrder:          General
         ColumnHidden:    False
         ColumnOrder:     Default
         ColumnWidth:     Default
         DataUpdatable:   False
         OrdinalPosition:         1
         Required:        False
         SourceField:     comment1
         SourceTable:     MReportComments
         comment2         Memo     -
         AllowZeroLength:         False
         Attributes:      Variable Length
         CollatingOrder:          General
         ColumnHidden:    False
         ColumnOrder:     Default
         ColumnWidth:     Default
         DataUpdatable:   False
         OrdinalPosition:         2
         Required:        False
         SourceField:     comment2
         SourceTable:     MReportComments
         Table Indexes
         Name     Number of Fields


Table: MReportComments   Page: 106
         PrimaryKey       1
         Clustered:       False
         DistinctCount:   286
         Foreign:         False
         IgnoreNulls:     False
         Name:    PrimaryKey
         Primary:         True
         Required:        True
         Unique:          True
         Fields:
         RecordID         Ascending
         recordID         1
         Clustered:       False
         DistinctCount:   286
         Foreign:         False
         IgnoreNulls:     False
         Name:    recordID
         Primary:         False
         Required:        False
         Unique:          True
         Fields:
         RecordID         Ascending
         User Permissions
         admin
         Group Permissions
         Admins
         Users    Delete, Read Permissions, Set Permissions, Change Owner, Read Definition, Write
         Definition, Read Data, Insert Data, Update Data, Delete Data


Table: MTargets  Page: 107
         Columns
         Name     Type     Size
         TypeID   Long Integer     4
         AllowZeroLength:         False
         Attributes:      Fixed Size
         CollatingOrder:          General
         ColumnHidden:    False
         ColumnOrder:     Default
         ColumnWidth:     Default
         DataUpdatable:   False
         DecimalPlaces:   Auto
         DisplayControl:          Text Box
         OrdinalPosition:         0
         Required:        False
         SourceField:     TypeID
         SourceTable:     MTargets
         Description      Text     50
         AllowZeroLength:         False
         Attributes:      Variable Length
         CollatingOrder:          General
         ColumnHidden:    False
         ColumnOrder:     Default
         ColumnWidth:     4290
         DataUpdatable:   False
         DisplayControl:          Text Box
         OrdinalPosition:         1
         Required:        False
         SourceField:     Description
         SourceTable:     MTargets
         DaysAllowed      Long Integer     4
         AllowZeroLength:         False
         Attributes:      Fixed Size
         CollatingOrder:          General
         ColumnHidden:    False
         ColumnOrder:     Default
         ColumnWidth:     Default
         DataUpdatable:   False
         DecimalPlaces:   Auto
         Description:     Days allowed for Stage 1 Targets
         DisplayControl:          Text Box
         OrdinalPosition:         2
         Required:        False
         SourceField:     DaysAllowed
         SourceTable:     MTargets


Table: MTargets  Page: 108
         startDate        Date/Time        8
         AllowZeroLength:         False
         Attributes:      Fixed Size
         CollatingOrder:          General
         ColumnHidden:    False
         ColumnOrder:     Default
         ColumnWidth:     Default
         DataUpdatable:   False
         Format:          dd/mmm/yyyy
         OrdinalPosition:         3
         Required:        False
         SourceField:     startDate
         SourceTable:     MTargets
         enddate  Date/Time        8
         AllowZeroLength:         False
         Attributes:      Fixed Size
         CollatingOrder:          General
         ColumnHidden:    False
         ColumnOrder:     Default
         ColumnWidth:     Default
         DataUpdatable:   False
         Format:          dd/mmm/yyyy
         OrdinalPosition:         4
         Required:        False
         SourceField:     enddate
         SourceTable:     MTargets
         Stage1Within     Long Integer     4
         AllowZeroLength:         False
         Attributes:      Fixed Size
         CollatingOrder:          General
         ColumnHidden:    False
         ColumnOrder:     Default
         ColumnWidth:     Default
         DataUpdatable:   False
         DecimalPlaces:   Auto
         DisplayControl:          Text Box
         OrdinalPosition:         5
         Required:        False
         SourceField:     Stage1Within
         SourceTable:     MTargets
         Stage1Off        Long Integer     4
         AllowZeroLength:         False
         Attributes:      Fixed Size
         CollatingOrder:          General
         ColumnHidden:    False
         ColumnOrder:     Default
         ColumnWidth:     Default
         DataUpdatable:   False
         DecimalPlaces:   Auto
         DisplayControl:          Text Box
         OrdinalPosition:         6
         Required:        False
         SourceField:     Stage1Off


Table: MTargets  Page: 109
         SourceTable:     MTargets
         Stage1Percentage         Long Integer     4
         AllowZeroLength:         False
         Attributes:      Fixed Size
         CollatingOrder:          General
         ColumnHidden:    False
         ColumnOrder:     Default
         ColumnWidth:     Default
         DataUpdatable:   False
         DecimalPlaces:   Auto
         DisplayControl:          Text Box
         OrdinalPosition:         7
         Required:        False
         SourceField:     Stage1Percentage
         SourceTable:     MTargets
         Table Indexes
         Name     Number of Fields
         PrimaryKey       1
         Clustered:       False
         DistinctCount:   1
         Foreign:         False
         IgnoreNulls:     False
         Name:    PrimaryKey
         Primary:         True
         Required:        True
         Unique:          True
         Fields:
         TypeID   Ascending
         TypeID   1
         Clustered:       False
         DistinctCount:   1
         Foreign:         False
         IgnoreNulls:     False
         Name:    TypeID
         Primary:         False
         Required:        False
         Unique:          False
         Fields:
         TypeID   Ascending
         User Permissions
         admin
         Group Permissions
         Admins


Table: MTargets  Page: 110
         Users    Delete, Read Permissions, Set Permissions, Change Owner, Read Definition, Write
         Definition, Read Data, Insert Data, Update Data, Delete Data


Table: NatureOfBusiness  Page: 111
         Columns
         Name     Type     Size
         NatureOfBusinessID       Long Integer     4
         AllowZeroLength:         False
         Attributes:      Fixed Size, Auto-Increment
         CollatingOrder:          General
         ColumnHidden:    False
         ColumnOrder:     Default
         ColumnWidth:     2010
         DataUpdatable:   False
         OrdinalPosition:         0
         Required:        False
         SourceField:     NatureOfBusinessID
         SourceTable:     NatureOfBusiness
         NatureOfBusinessDescription      Text     50
         AllowZeroLength:         False
         Attributes:      Variable Length
         CollatingOrder:          General
         ColumnHidden:    False
         ColumnOrder:     Default
         ColumnWidth:     2880
         DataUpdatable:   False
         Description:     Description of Nature Business of New Employer - up to 50 characters
         DisplayControl:          Text Box
         OrdinalPosition:         1
         Required:        False
         SourceField:     NatureOfBusinessDescription
         SourceTable:     NatureOfBusiness
         NatureOfBusinessComments         Text     255
         AllowZeroLength:         False
         Attributes:      Variable Length
         CollatingOrder:          General
         ColumnHidden:    False
         ColumnOrder:     Default
         ColumnWidth:     5190
         DataUpdatable:   False
         Description:     Comments - up to 255 characters
         DisplayControl:          Text Box
         OrdinalPosition:         2
         Required:        False
         SourceField:     NatureOfBusinessComments
         SourceTable:     NatureOfBusiness


Table: NatureOfBusiness  Page: 112
         Relationships
         NatureOfBusinessCSAPPLICATION
         NatureOfBusiness         CSAPPLICATION
         NatureOfBusinessID       1        ¥         NatureOfBusinessID
         Attributes:      Enforced, Right Join
         RelationshipType:        One-To-Many
         NatureOfBusinessMApplication
         NatureOfBusiness         MApplication
         NatureOfBusinessID       1        ¥         NatureOfBusinessID
         Attributes:      Enforced, Right Join
         RelationshipType:        One-To-Many
         Table Indexes
         Name     Number of Fields
         PrimaryKey       1
         Clustered:       False
         DistinctCount:   21
         Foreign:         False
         IgnoreNulls:     False
         Name:    PrimaryKey
         Primary:         True
         Required:        True
         Unique:          True
         Fields:
         NatureOfBusinessID       Ascending
         User Permissions
         admin
         Group Permissions
         Admins
         Users    Delete, Read Permissions, Set Permissions, Change Owner, Read Definition, Write
         Definition, Read Data, Insert Data, Update Data, Delete Data


Table: NatureOfJob       Page: 113
         Columns
         Name     Type     Size
         NatureOfJobID    Long Integer     4
         AllowZeroLength:         False
         Attributes:      Fixed Size, Auto-Increment
         CollatingOrder:          General
         ColumnHidden:    False
         ColumnOrder:     Default
         ColumnWidth:     1530
         DataUpdatable:   False
         OrdinalPosition:         0
         Required:        False
         SourceField:     NatureOfJobID
         SourceTable:     NatureOfJob
         NatureOfJobDescription   Text     50
         AllowZeroLength:         False
         Attributes:      Variable Length
         CollatingOrder:          General
         ColumnHidden:    False
         ColumnOrder:     Default
         ColumnWidth:     4200
         DataUpdatable:   False
         Description:     Description of Nature of new Job - up to 50 characters
         DisplayControl:          Text Box
         OrdinalPosition:         1
         Required:        False
         SourceField:     NatureOfJobDescription
         SourceTable:     NatureOfJob
         ActiveFlag       Yes/No   1
         AllowZeroLength:         False
         Attributes:      Fixed Size
         CollatingOrder:          General
         ColumnHidden:    False
         ColumnOrder:     Default
         ColumnWidth:     Default
         DataUpdatable:   False
         Description:     Is this Nature of Job a current one available for new input? (Yes/No)
         DisplayControl:          106
         Format:          Yes/No
         OrdinalPosition:         2
         Required:        False
         SourceField:     ActiveFlag
         SourceTable:     NatureOfJob


Table: NatureOfJob       Page: 114
         Relationships
         NatureOfJobMApplication
         NatureOfJob      MApplication
         NatureOfJobID    1        ¥         NatureOfJobID
         Attributes:      Enforced, Right Join
         RelationshipType:        One-To-Many
         NatureOfJobCSAPPLICATION
         NatureOfJob      CSAPPLICATION
         NatureOfJobID    1        ¥         NatureOfJobID
         Attributes:      Enforced, Right Join
         RelationshipType:        One-To-Many
         Table Indexes
         Name     Number of Fields
         PrimaryKey       1
         Clustered:       False
         DistinctCount:   424
         Foreign:         False
         IgnoreNulls:     False
         Name:    PrimaryKey
         Primary:         True
         Required:        True
         Unique:          True
         Fields:
         NatureOfJobID    Ascending
         User Permissions
         admin
         Group Permissions
         Admins
         Users    Delete, Read Permissions, Set Permissions, Change Owner, Read Definition, Write
         Definition, Read Data, Insert Data, Update Data, Delete Data


Table: PoliticalParty    Page: 115
         Columns
         Name     Type     Size
         PoliticalPartyID         Long Integer     4
         AllowZeroLength:         False
         Attributes:      Fixed Size, Auto-Increment
         CollatingOrder:          General
         ColumnHidden:    False
         ColumnOrder:     Default
         ColumnWidth:     Default
         DataUpdatable:   False
         OrdinalPosition:         0
         Required:        False
         SourceField:     PoliticalPartyID
         SourceTable:     PoliticalParty
         PoliticalPartyAbbrev     Text     10
         AllowZeroLength:         False
         Attributes:      Variable Length
         CollatingOrder:          General
         ColumnHidden:    False
         ColumnOrder:     Default
         ColumnWidth:     Default
         DataUpdatable:   False
         Description:     Abbreviated name of Political Party - up to 10 characters
         DisplayControl:          Text Box
         OrdinalPosition:         1
         Required:        False
         SourceField:     PoliticalPartyAbbrev
         SourceTable:     PoliticalParty
         PoliticalPartyName       Text     50
         AllowZeroLength:         False
         Attributes:      Variable Length
         CollatingOrder:          General
         ColumnHidden:    False
         ColumnOrder:     Default
         ColumnWidth:     Default
         DataUpdatable:   False
         Description:     Full Name of Political Party - up to 50 characters
         DisplayControl:          Text Box
         OrdinalPosition:         2
         Required:        False
         SourceField:     PoliticalPartyName
         SourceTable:     PoliticalParty


Table: PoliticalParty    Page: 116
         Relationships
         PoliticalPartyMAPPLICANT
         PoliticalParty   MAPPLICANT
         PoliticalPartyID         1        ¥         PoliticalParty
         Attributes:      Enforced, Right Join
         RelationshipType:        One-To-Many
         Table Indexes
         Name     Number of Fields
         PrimaryKey       1
         Clustered:       False
         DistinctCount:   7
         Foreign:         False
         IgnoreNulls:     False
         Name:    PrimaryKey
         Primary:         True
         Required:        True
         Unique:          True
         Fields:
         PoliticalPartyID         Ascending
         User Permissions
         admin
         Group Permissions
         Admins
         Users    Delete, Read Permissions, Set Permissions, Change Owner, Read Definition, Write
         Definition, Read Data, Insert Data, Update Data, Delete Data


Table: Rank      Page: 117
         Columns
         Name     Type     Size
         RankID   Long Integer     4
         AllowZeroLength:         False
         Attributes:      Fixed Size, Auto-Increment
         CollatingOrder:          General
         ColumnHidden:    False
         ColumnOrder:     Default
         ColumnWidth:     Default
         DataUpdatable:   False
         OrdinalPosition:         0
         Required:        False
         SourceField:     RankID
         SourceTable:     Rank
         RankAbbrev       Text     15
         AllowZeroLength:         False
         Attributes:      Variable Length
         CollatingOrder:          General
         ColumnHidden:    False
         ColumnOrder:     Default
         ColumnWidth:     1785
         DataUpdatable:   False
         Description:     HM Forces Rank Abbreviated Name (up to 10 characters)
         DisplayControl:          Text Box
         OrdinalPosition:         1
         Required:        False
         SourceField:     RankAbbrev
         SourceTable:     Rank
         RankName         Text     50
         AllowZeroLength:         False
         Attributes:      Variable Length
         CollatingOrder:          General
         ColumnHidden:    False
         ColumnOrder:     Default
         ColumnWidth:     4245
         DataUpdatable:   False
         Description:     HM Forces Rank full Name (up to 50 characters)
         DisplayControl:          Text Box
         OrdinalPosition:         2
         Required:        False
         SourceField:     RankName
         SourceTable:     Rank
         ActiveFlag       Yes/No   1


Table: Rank      Page: 118
         AllowZeroLength:         False
         Attributes:      Fixed Size
         CollatingOrder:          General
         ColumnHidden:    False
         ColumnOrder:     Default
         ColumnWidth:     Default
         DataUpdatable:   False
         Description:     Is this Rank a current one available for new input? (Yes/No)
         DisplayControl:          106
         Format:          Yes/No
         OrdinalPosition:         3
         Required:        False
         SourceField:     ActiveFlag
         SourceTable:     Rank
         Relationships
         RankCSAPPLICANT
         Rank     CSAPPLICANT
         RankID   1        ¥         RankID
         Attributes:      Enforced, Right Join
         RelationshipType:        One-To-Many
         Table Indexes
         Name     Number of Fields
         PrimaryKey       1
         Clustered:       False
         DistinctCount:   45
         Foreign:         False
         IgnoreNulls:     False
         Name:    PrimaryKey
         Primary:         True
         Required:        True
         Unique:          True
         Fields:
         RankID   Ascending
         User Permissions
         admin
         Group Permissions
         Admins
         Users    Delete, Read Permissions, Set Permissions, Change Owner, Read Definition, Write
         Definition, Read Data, Insert Data, Update Data, Delete Data


Table: Rank      Page: 119


Table: systemControl     Page: 120
         Columns
         Name     Type     Size
         objID    Long Integer     4
         AllowZeroLength:         False
         Attributes:      Fixed Size, Auto-Increment
         CollatingOrder:          General
         ColumnHidden:    False
         ColumnOrder:     Default
         ColumnWidth:     Default
         DataUpdatable:   False
         OrdinalPosition:         0
         Required:        False
         SourceField:     objID
         SourceTable:     systemControl
         type     Text     6
         AllowZeroLength:         False
         Attributes:      Variable Length
         CollatingOrder:          General
         ColumnHidden:    False
         ColumnOrder:     Default
         ColumnWidth:     Default
         DataUpdatable:   False
         DisplayControl:          Text Box
         OrdinalPosition:         1
         Required:        False
         SourceField:     type
         SourceTable:     systemControl
         Name     Text     50
         AllowZeroLength:         False
         Attributes:      Variable Length
         CollatingOrder:          General
         ColumnHidden:    False
         ColumnOrder:     Default
         ColumnWidth:     Default
         DataUpdatable:   False
         DisplayControl:          Text Box
         OrdinalPosition:         2
         Required:        False
         SourceField:     Name
         SourceTable:     systemControl
         value    Text     128
         AllowZeroLength:         False
         Attributes:      Variable Length


Table: systemControl     Page: 121
         CollatingOrder:          General
         ColumnHidden:    False
         ColumnOrder:     Default
         ColumnWidth:     7305
         DataUpdatable:   False
         DisplayControl:          Text Box
         OrdinalPosition:         3
         Required:        False
         SourceField:     value
         SourceTable:     systemControl
         Table Indexes
         Name     Number of Fields
         objID    1
         Clustered:       False
         DistinctCount:   26
         Foreign:         False
         IgnoreNulls:     False
         Name:    objID
         Primary:         False
         Required:        False
         Unique:          False
         Fields:
         objID    Ascending
         PrimaryKey       1
         Clustered:       False
         DistinctCount:   26
         Foreign:         False
         IgnoreNulls:     False
         Name:    PrimaryKey
         Primary:         True
         Required:        True
         Unique:          True
         Fields:
         objID    Ascending
         User Permissions
         admin
         Group Permissions
         Admins
         Users    Delete, Read Permissions, Set Permissions, Change Owner, Read Definition, Write
         Definition, Read Data, Insert Data, Update Data, Delete Data


Table: systemQueryFunctions      Page: 122
         Columns
         Name     Type     Size
         ID       Long Integer     4
         AllowZeroLength:         False
         Attributes:      Fixed Size, Auto-Increment
         CollatingOrder:          General
         ColumnHidden:    False
         ColumnOrder:     1
         ColumnWidth:     Default
         DataUpdatable:   False
         OrdinalPosition:         0
         Required:        False
         SourceField:     ID
         SourceTable:     systemQueryFunctions
         queryFunction    Text     255
         AllowZeroLength:         False
         Attributes:      Variable Length
         CollatingOrder:          General
         ColumnHidden:    False
         ColumnOrder:     Default
         ColumnWidth:     2256
         DataUpdatable:   False
         Description:     Query statement, where P1 = Parameter1 and P2 = Parameter2
         DisplayControl:          Text Box
         OrdinalPosition:         1
         Required:        False
         SourceField:     queryFunction
         SourceTable:     systemQueryFunctions
         Description      Text     50
         AllowZeroLength:         False
         Attributes:      Variable Length
         CollatingOrder:          General
         ColumnHidden:    False
         ColumnOrder:     Default
         ColumnWidth:     1740
         DataUpdatable:   False
         Description:     Description of query type
         DisplayControl:          Text Box
         OrdinalPosition:         2
         Required:        False
         SourceField:     Description
         SourceTable:     systemQueryFunctions
         Parameter1Format         Text     50


Table: systemQueryFunctions      Page: 123
         AllowZeroLength:         False
         Attributes:      Variable Length
         CollatingOrder:          General
         ColumnHidden:    False
         ColumnOrder:     Default
         ColumnWidth:     Default
         DataUpdatable:   False
         Description:     Description of what the end user would enter into the field
         DisplayControl:          Text Box
         OrdinalPosition:         3
         Required:        False
         SourceField:     Parameter1Format
         SourceTable:     systemQueryFunctions
         Parameter2Format         Text     50
         AllowZeroLength:         False
         Attributes:      Variable Length
         CollatingOrder:          General
         ColumnHidden:    False
         ColumnOrder:     Default
         ColumnWidth:     Default
         DataUpdatable:   False
         Description:     Description of what the end user would enter into the field
         DisplayControl:          Text Box
         OrdinalPosition:         4
         Required:        False
         SourceField:     Parameter2Format
         SourceTable:     systemQueryFunctions
         Table Indexes
         Name     Number of Fields
         PrimaryKey       1
         Clustered:       False
         DistinctCount:   10
         Foreign:         False
         IgnoreNulls:     False
         Name:    PrimaryKey
         Primary:         True
         Required:        True
         Unique:          True
         Fields:
         ID       Ascending
         User Permissions
         admin
         Group Permissions
         Admins


Table: systemQueryFunctions      Page: 124
         Users    Delete, Read Permissions, Set Permissions, Change Owner, Read Definition, Write
         Definition, Read Data, Insert Data, Update Data, Delete Data