CustomDeclarationPrinting Help

 

 

 

1. Custom Declaration Printing - Menu Options

1.1 Login Menu

           Allows the user to login into the application and, based on the user type, access its functionality

           By clicking on the Login menu, a form will pop up for the user to introduce user name and the password

          

The user name and the password entered using the Login form will be verified and in case of a positive verification, meaning, the combination user name and password match a defined user, the user will be authenticated and will have access to the application.

If, when the user was defined the “Password change at login” was checked, a new defined user will be requested to change the password at the first login.

For the “Password change at login” more details on Tools menu help documentation.

 

 

The action of changing the password at login is enabled through “Passord change” form which will appear after the user logins into the application and has the credentials (user name and password) verified succesfully.

1.2 Tools - Utils Menu

Tools Menu

User Administration – provides the following functionalities, depending on the type of the user logged in into the application

ü     Regular User – for a regular user it allows to view the various properties or characteristics for the user currently logged in and using the application;

The User Admin form for a Regular User

           

            The only property available to be changed is the password of the user.This operation can be performed using the “Password change” form.

            

ü     Application Administration User – this type of user can perform more actions regarding the user administration like adding, update users and these action can be performed for any other user defined or that it needs to be defined for the application, as shown below

 

      

         

§         Application Administration User – Add user

When a new user is added there are certain attributes need to be defined or selected before the user will be saved and become a valid user for the application:

o       User Name – the name of the new user

o       User Is Application Admin – the option will be checked if the user to be created will be Application Adminstartion user type, having all the privileges for this type of user

o       Password – allows establishing the password for the new user

o       Password Expiry Date – a date on which the user password will expire and the user will not be allowed to log in into the application using this password

o       Pasword never expires – eliminates the need for the user to change is password after it expired based on the value of Password Expiry Date field

The Password expiry date will be automatically set to 31-12-9998 and will not allow to be edited

o       Passwor change at login – having this option checked the new user will have to enter a new password after a succcesful login using the password defined here.

o       User Begin Date and User End Date – allow to define a period of time for which the user is a valid user for the application and can log in into the application using the combination user name and password defined for the user

o       User never expires – will make the user permanently available for the application

User end date will be automatically set to 31-12-9998 and will not allow to be edited

 

        

 

§         Application Administration User – Update user

Allows to be edit any of the attributes of an already defined application user

 

 

 

Database – provides the application administration user with the options for application database administration, as it follows:

ü      Backup – allows the backup of the database that supports the application

  – the application administration user will be prompted with a screen in which he is notified that connections to the database will be closed and that he must save any current work before proceeding. He can choose to cancel the backup operation or continue.

-   database backupps are placed in a specific application folder defined in application configuration file

 

      

 

      

ü      Restore  – allows the restore of a previous backuped database

     – the application administration user will be prompted with a screen wich provides the date and time when the database backup   was  performed, so to allow the user to identify the database that he/she wants to restore.

 

             

 

            

ü      Compact - compacts the database;

    - this operation is intended to recover the disk space lost as result of     database usage and it can help improving the database performance.

ü      Empty – deletes all the information and records stored in the database, excepting the information regarding the users.

                 – this allows to limit the database growing and by that ensures an optimal usage and faster response during usage, from the application.

 

 

 

 

                       

 

 

 

 

1.3 Tools - Database Menu

Tools Menu

User Administration – provides the following functionalities, depending on the type of the user logged in into the application

ü     Regular User – for a regular user it allows to view the various properties or characteristics for the user currently logged in and using the application;

The User Admin form for a Regular User

           

            The only property available to be changed is the password of the user.This operation can be performed using the “Password change” form.

            

ü     Application Administration User – this type of user can perform more actions regarding the user administration like adding, update users and these action can be performed for any other user defined or that it needs to be defined for the application, as shown below

 

      

         

§         Application Administration User – Add user

When a new user is added there are certain attributes need to be defined or selected before the user will be saved and become a valid user for the application:

o       User Name – the name of the new user

o       User Is Application Admin – the option will be checked if the user to be created will be Application Adminstartion user type, having all the privileges for this type of user

o       Password – allows establishing the password for the new user

o       Password Expiry Date – a date on which the user password will expire and the user will not be allowed to log in into the application using this password

o       Pasword never expires – eliminates the need for the user to change is password after it expired based on the value of Password Expiry Date field

The Password expiry date will be automatically set to 31-12-9998 and will not allow to be edited

o       Passwor change at login – having this option checked the new user will have to enter a new password after a succcesful login using the password defined here.

o       User Begin Date and User End Date – allow to define a period of time for which the user is a valid user for the application and can log in into the application using the combination user name and password defined for the user

o       User never expires – will make the user permanently available for the application

User end date will be automatically set to 31-12-9998 and will not allow to be edited

 

        

 

§         Application Administration User – Update user

Allows to be edit any of the attributes of an already defined application user

 

 

 

Database – provides the application administration user with the options for application database administration, as it follows:

ü      Backup – allows the backup of the database that supports the application

  – the application administration user will be prompted with a screen in which he is notified that connections to the database will be closed and that he must save any current work before proceeding. He can choose to cancel the backup operation or continue.

-   database backupps are placed in a specific application folder defined in application configuration file

 

      

 

      

ü      Restore  – allows the restore of a previous backuped database

     – the application administration user will be prompted with a screen wich provides the date and time when the database backup   was  performed, so to allow the user to identify the database that he/she wants to restore.

 

             

 

            

ü      Compact - compacts the database;

    - this operation is intended to recover the disk space lost as result of     database usage and it can help improving the database performance.

ü      Empty – deletes all the information and records stored in the database, excepting the information regarding the users.

                 – this allows to limit the database growing and by that ensures an optimal usage and faster response during usage, from the application.

 

 

 

 

                       

 

 

 

 

1.4 Tools - Import Data

Tools - Import Data

The application offers the possibility of importing data as a way of loading the database with data needed for the Custom Declarations to be printed.

Data is imported based on a Standard Input File (SIF) that reflects the application’s database physical model.

SIF is an XML file having a corresponding XML schema file (XSD) against which is validated to ensure that data in the SIF file conforms to the application’s database constraint and data types.

This allows minimizing the errors during the import process by ensuring the data to be loaded has the format expected.

The user has the option of selecting the SIF file that will be used for import as well as the XSD file that will be used for validating the SIF file. New Topic. (Press Shift-Enter to insert a line break. Press Enter to add a paragraph return.)

Other options presented for the Import Data process are:

·        Save XML and XSD path into the configuration file – this allows saving the path for the SIF (XML) file and its corresponding XSD file into the configuration file so they will be provided as default options when the Import feature is activated;

·        Include Users for Import – By selecting this option, the user informs the application that Import Data will process/import the users supplied in the SIF file.

If the option is not selected the application will ignore at import the users’ data even if the data is present into the SIF file.

 

The process of importing the data consists in a few steps, as it follows:

1.      SIF (XML) validation;

2.      Existing data delete from the database, the database being emptied and being prepared for import;

3.      Data import.

The user is informed of the completion of each step and the completion status (success or error).

1.5 Print Menu

Allows an application user to access application functionalities related to printing Custom Declaration forms, forms which are country specific.

In order to be able to print the Custom forms for a flight passengers, application user will need to make a selection for certain mandatory fields :

ü     Country  - the Country for which the Custom form is printed

ü     Airport - the destination airport for the flight

ü     Flights – permits the selction of the flight number, so the that Custom declaration will be printed for the passengers of  a specific flight

 

     

       

A number of other optional selections are provided to ensure the …

ü     Print Seat No – it will print the airplane seat number on the Custom declaration so to ease the distribution of the printed Custom Decalaration among the flight passengers

ü     Print Persons on separate pages – it will print a person per Custom Declaration; option available only if the country selected is Canada

ü     Print with background – it will print the information required by a country specific Custom declaration along with the Custom Declaration itself

1.6 Passenger List

Passenger List

Using the Passenger List the user can verify the list of passengers scheduled for boarding.

The user can filter the flight that want to verify the list for, through a series of conditions.

 

 

 

Once the Passenger List is showed, the user can perform a series of operations:

ü  Update List – allows the user to uncheck if an user did not actually board.

ü  Filter – which allows user to search through the passenger list based on information like First Name, Last Name, Seat No, Checked (if   boarded).

These filter criteria can be combined in a group using AND or the search can be performed based of any of the filter criteria using OR.

ü  Sorting - the passenger list can be sorted ascending or descending, by clicking on each of the items in the header of the list.

 

1.7 Product Key Menu

Custom Declaration Printing is offered for a trial period of 30 days.

 

In order to be able to use it beyond this trial period the evaluation period can be extended or the product can be purchased.

For this you need to make a request for a product activation key using Request product Key form.

 

 

 

ü     The information needed to be provided are detailed below:

ü     License Requester – the name of the company or person who requests a product activation ley

ü     License Type – the period for which you want to register or license the product

ü     License Start Date – starting date od the product registration or product usage

ü     Windows to be licensed – the serial number for the Windows operating system that will be licensed.This information is automatically collected for and from the PC where the request is sent

ü     Email – email that will receive the product activation key and/or email for contact

 

In case more licenses are required an email should be sent to office@columnasoft.com, email having an attachement with the above mentioned information containing the serial numbers for Windows machines that need to be licensed.

 

Once the product activation key is received, the product will be licensed/registered using the Product Registration form.

For product registration, the product key received will be entered and then Register Product will be clicked.

 

1.8 Exit Menu

The Exit menu allows the application user to leave the application in two ways:

ü     Exit – the user will exit the application and the application will be closed

ü     Logout- the user logs off form the application but the application remains available and another user or the same user can log back in at any time using the Login menu

2. Custom Declaration Printing - Installation

2.1 Installation - Overview

Installation - Overview

Custom Declaration Printing requires the presence of other Microsoft products and components, as it follows:

ü     Microsoft .NET Framework

ü     Microsoft Report Viewer

ü     Microsoft SQL Server Compact Edition

The exact version of additional products and components required can be found in the ReadMe.txt file which is provided along with Custom Declaration Printing application.

The additional products and components are required to be installed before the installation of Custom Declaration Printing.

For the installation and setup of Custom Declaration Printing there will be provided installer programs as below:

-         Custom Declaration Printing - Full Installer – contains all the products and components required. No additional downloads and installs are required.

-         Custom Declaration Printing - Simple Installer – contains Custom Declaration Printing application and Microsoft report Viewer. Any other product or component required will need to be downloaded and installed separately, before the installation of Custom Declaration Printing.

If the application is installed in one of the Windows special or predefined folders , make sure the Windows user which will execute the application has, at minimum, the Write permissions for the folder on which the application was installed.

A definition of Windows special or predefined folders can be found here: http://msdn.microsoft.com/en-us/library/s2esdf4x.aspx

2.2 Installation using Simple Installer

Disk space required for installer: 10 MB

Disk space required for application: 15 MB

 

Double-click or click Enter for CDP_Setup_Simple.exe

If you are asked to allow the program to make changes on your computer click <Yes>

When the following screen shows, click Next

 

Choose the installation folder in this screen and click Next

 

 

The following screens will present with options of creating in the Start Menu and on Desktop

 

The user can review the options chosen before the installation

 

Once the Install button is hit, the installation begins

 

At the end of the installation the user has the option to start the application

2.3 Installation using Full Installer

Disk space required for installer: 62 MB

Disk space required for application and Microsoft products and components: 350 MB

 

Double-click or click Enter for CDP_Setup_Full.exe

If you are asked to allow the program to make changes on your computer click Yes

 

When the following screen shows, click Next

 

 

Choose the installation folder in this screen and click Next

 

The following screens will present with options of creating in the Start Menu and on Desktop

The user can review the options chosen before the installation

 

 

Once the Install button is hit, the installation begins

 

 

 

During the installation, additional products and components are also installed

 

 

 

 

 

At the end of the installation the user has the option to start the application

 

3. Custom Declaration Printing - Data Model

3.1 Data Model - Overview

3.2 Data Model - Tables Definitions

Data Model - Tables Definitions

 

TABLE_NAME:  Addresses 

COLUMN_NAME

COLUMN_DEFAULT

 IS_NULLABLE

DATA_TYPE

 CHARACTER_MAXIMUM_LENGTH

NUMERIC_PRECISION

NUMERIC_SCALE

  DATETIME_PRECISION

AddressId

NULL

NO

int

NULL

NULL

NULL

NULL

CityId

NULL

NO

int

NULL

NULL

NULL

NULL

StreetNumber

NULL

YES

smallint

NULL

NULL

NULL

NULL

StreetPreDirection

NULL

YES

nvarchar

4

8

NULL

NULL

StreetName

NULL

NO

nvarchar

50

100

NULL

NULL

StreetType

NULL

YES

nvarchar

15

30

NULL

NULL

StreetPostDirection

NULL

YES

nvarchar

4

8

NULL

NULL

UnitType

NULL

YES

nvarchar

10

20

NULL

NULL

UnitNumber

NULL

YES

smallint

NULL

NULL

NULL

NULL

 

 

TABLE_NAME:  AdministrativeRegions 

COLUMN_NAME

COLUMN_DEFAULT

 IS_NULLABLE

DATA_TYPE

 CHARACTER_MAXIMUM_LENGTH

NUMERIC_PRECISION

NUMERIC_SCALE

  DATETIME_PRECISION

AdministrativeRegionId

NULL

NO

int

NULL

NULL

NULL

NULL

AdministrativeRegionCode

NULL

YES

nvarchar

4

8

NULL

NULL

AdministrativeRegion

NULL

YES

nvarchar

35

70

NULL

NULL

AdministrativeRegionCode1

NULL

YES

nvarchar

4

8

NULL

NULL

AdministrativeRegion1

NULL

YES

nvarchar

35

70

NULL

NULL

AdministrativeRegionCode2

NULL

YES

nvarchar

4

8

NULL

NULL

AdministrativeRegion2

NULL

YES

nvarchar

35

70

NULL

NULL

AdministrativeRegionCode3

NULL

YES

nvarchar

4

8

NULL

NULL

AdministrativeRegion3

NULL

YES

nvarchar

35

70

NULL

NULL

AdministrativeRegionCode4

NULL

YES

nvarchar

4

8

NULL

NULL

AdministrativeRegion4

NULL

YES

nvarchar

35

70

NULL

NULL

CountryId

('')

NO

int

NULL

NULL

NULL

NULL

 

 

TABLE_NAME:  Airlines

COLUMN_NAME

COLUMN_DEFAULT

 IS_NULLABLE

DATA_TYPE

 CHARACTER_MAXIMUM_LENGTH

NUMERIC_PRECISION

NUMERIC_SCALE

  DATETIME_PRECISION

AirlineId

NULL

NO

int

NULL

NULL

NULL

NULL

OrganizationId

NULL

NO

int

NULL

NULL

NULL

NULL

AirlineCode

NULL

YES

nvarchar

10

20

NULL

NULL

IATACode

NULL

YES

nvarchar

4

8

NULL

NULL

ICAOCode

NULL

YES

nvarchar

4

8

NULL

NULL

AirlineInfo

NULL

YES

nvarchar

150

300

NULL

NULL

 

 

TABLE_NAME:  Airports

COLUMN_NAME

COLUMN_DEFAULT

 IS_NULLABLE

DATA_TYPE

 CHARACTER_MAXIMUM_LENGTH

NUMERIC_PRECISION

NUMERIC_SCALE

  DATETIME_PRECISION

AirportCode

NULL

NO

nchar

3

6

NULL

NULL

AirportName

NULL

YES

nvarchar

150

300

NULL

NULL

CountryId

NULL

YES

int

NULL

NULL

NULL

NULL

rowguid

NULL

NO

uniqueidentifier

NULL

NULL

NULL

NULL

 

 

TABLE_NAME:  Cities

COLUMN_NAME

COLUMN_DEFAULT

 IS_NULLABLE

DATA_TYPE

 CHARACTER_MAXIMUM_LENGTH

NUMERIC_PRECISION

NUMERIC_SCALE

  DATETIME_PRECISION

CityId

NULL

NO

int

NULL

NULL

NULL

NULL

City

NULL

YES

nvarchar

50

100

NULL

NULL

CountryId

NULL

NO

int

NULL

NULL

NULL

NULL

AdministrativeRegionId

NULL

YES

int

NULL

NULL

NULL

NULL

Latitude

NULL

YES

float

NULL

NULL

NULL

NULL

Longitude

NULL

YES

float

NULL

NULL

NULL

NULL

TimeZone

NULL

YES

nvarchar

50

100

NULL

NULL

UTC

NULL

YES

nvarchar

10

20

NULL

NULL

 

 

TABLE_NAME:  CivilStatus

COLUMN_NAME

COLUMN_DEFAULT

 IS_NULLABLE

DATA_TYPE

 CHARACTER_MAXIMUM_LENGTH

NUMERIC_PRECISION

NUMERIC_SCALE

  DATETIME_PRECISION

CivilStatusId

NULL

NO

int

NULL

NULL

NULL

NULL

CivilStatusCode

NULL

NO

nvarchar

2

4

NULL

NULL

CivilStatus

NULL

YES

nvarchar

25

50

NULL

NULL

CivilStatusDescription

NULL

YES

nvarchar

255

510

NULL

NULL

 

 

TABLE_NAME:  Countries

COLUMN_NAME

COLUMN_DEFAULT

 IS_NULLABLE

DATA_TYPE

 CHARACTER_MAXIMUM_LENGTH

NUMERIC_PRECISION

NUMERIC_SCALE

  DATETIME_PRECISION

CountryId

NULL

NO

int

NULL

NULL

NULL

NULL

CountryCodeA2

NULL

YES

nchar

2

4

NULL

NULL

CountryCodeA3

NULL

YES

nchar

3

6

NULL

NULL

CountryName

NULL

NO

nvarchar

100

200

NULL

NULL

rowguid

NULL

NO

uniqueidentifier

NULL

NULL

NULL

NULL

 

 

TABLE_NAME:  Flights 

COLUMN_NAME

COLUMN_DEFAULT

 IS_NULLABLE

DATA_TYPE

 CHARACTER_MAXIMUM_LENGTH

NUMERIC_PRECISION

NUMERIC_SCALE

  DATETIME_PRECISION

FlightId

NULL

NO

int

NULL

NULL

NULL

NULL

AirportCodeDeparture

NULL

NO

nchar

3

6

NULL

NULL

AirportCodeArrival

NULL

NO

nchar

3

6

NULL

NULL

DepartureTime

NULL

NO

datetime

NULL

NULL

3

3

ArrivalTime

NULL

NO

datetime

NULL

NULL

3

3

DepartureDelay

NULL

YES

smallint

NULL

NULL

NULL

NULL

ArrivalDelay

NULL

YES

smallint

NULL

NULL

NULL

NULL

TravelClassId

NULL

YES

int

NULL

NULL

NULL

NULL

rowguid

NULL

NO

uniqueidentifier

NULL

NULL

NULL

NULL

FlightNo

NULL

YES

nvarchar

4

8

NULL

NULL

FlighCode

NULL

YES

nvarchar

8

16

NULL

NULL

SeatNo

NULL

YES

nvarchar

3

6

NULL

NULL

AirlineId

NULL

NO

int

NULL

NULL

NULL

NULL

FlightInfromation

NULL

YES

nvarchar

50

100

NULL

NULL

 

 

TABLE_NAME:  Gender

COLUMN_NAME

COLUMN_DEFAULT

 IS_NULLABLE

DATA_TYPE

 CHARACTER_MAXIMUM_LENGTH

NUMERIC_PRECISION

NUMERIC_SCALE

  DATETIME_PRECISION

GenderId

NULL

NO

int

NULL

NULL

NULL

NULL

GenderCode

NULL

NO

nvarchar

1

2

NULL

NULL

Gender

NULL

YES

nvarchar

25

50

NULL

NULL

 

 

TABLE_NAME:  Groups

COLUMN_NAME

COLUMN_DEFAULT

 IS_NULLABLE

DATA_TYPE

 CHARACTER_MAXIMUM_LENGTH

NUMERIC_PRECISION

NUMERIC_SCALE

  DATETIME_PRECISION

GroupId

NULL

NO

int

NULL

NULL

NULL

NULL

GroupName

NULL

YES

nvarchar

50

100

NULL

NULL

IsAppAdmin

((0))

NO

bit

NULL

NULL

0

NULL

BeginDate

(getdate())

NO

datetime

NULL

NULL

3

3

EndDate

NULL

YES

datetime

NULL

NULL

3

3

 

 

TABLE_NAME:  Passports

COLUMN_NAME

COLUMN_DEFAULT

 IS_NULLABLE

DATA_TYPE

 CHARACTER_MAXIMUM_LENGTH

NUMERIC_PRECISION

NUMERIC_SCALE

  DATETIME_PRECISION

PassportId

NULL

NO

int

NULL

NULL

NULL

NULL

PersonId

NULL

NO

int

NULL

NULL

NULL

NULL

PassportNo

NULL

NO

nvarchar

50

100

NULL

NULL

PassportIssuedDate

NULL

NO

datetime

NULL

NULL

3

3

PassportExpiryDate

NULL

NO

datetime

NULL

NULL

3

3

PassportIssueAuthority

NULL

YES

nvarchar

50

100

NULL

NULL

CountryId

NULL

NO

int

NULL

NULL

NULL

NULL

 

 

TABLE_NAME:  Persons 

COLUMN_NAME

COLUMN_DEFAULT

 IS_NULLABLE

DATA_TYPE

 CHARACTER_MAXIMUM_LENGTH

NUMERIC_PRECISION

NUMERIC_SCALE

  DATETIME_PRECISION

rowguid

NULL

NO

uniqueidentifier

NULL

NULL

NULL

NULL

PersonId

NULL

NO

int

NULL

NULL

NULL

NULL

ReferencedPersonId

NULL

YES

int

NULL

NULL

NULL

NULL

Salutation

NULL

YES

nvarchar

4

8

NULL

NULL

Title

NULL

YES

nvarchar

4

8

NULL

NULL

FirstName

NULL

NO

nvarchar

50

100

NULL

NULL

MiddleName

NULL

YES

nvarchar

50

100

NULL

NULL

LastName

NULL

NO

nvarchar

50

100

NULL

NULL

Suffix

NULL

YES

nvarchar

5

10

NULL

NULL

DateofBirth

NULL

NO

datetime

NULL

NULL

3

3

CivilStatusId

NULL

YES

int

NULL

NULL

NULL

NULL

GenderId

NULL

YES

int

NULL

NULL

NULL

NULL

Citizenship

NULL

YES

nvarchar

50

100

NULL

NULL

AddressId

NULL

YES

int

NULL

NULL

NULL

NULL

 

 

TABLE_NAME:  Persons_Flights

COLUMN_NAME

COLUMN_DEFAULT

 IS_NULLABLE

DATA_TYPE

 CHARACTER_MAXIMUM_LENGTH

NUMERIC_PRECISION

NUMERIC_SCALE

  DATETIME_PRECISION

PersonsToFlightsId

NULL

NO

int

NULL

NULL

NULL

NULL

PersonId

NULL

NO

int

NULL

NULL

NULL

NULL

FlightId

NULL

NO

int

NULL

NULL

NULL

NULL

SeatNo

NULL

YES

nvarchar

3

6

NULL

NULL

Checked

1

YES

bit

NULL

NULL

0

NULL

 

 

TABLE_NAME:  PostalCodes 

COLUMN_NAME

COLUMN_DEFAULT

 IS_NULLABLE

DATA_TYPE

 CHARACTER_MAXIMUM_LENGTH

NUMERIC_PRECISION

NUMERIC_SCALE

  DATETIME_PRECISION

PostalCodeId

NULL

NO

int

NULL

NULL

NULL

NULL

CityId

NULL

NO

int

NULL

NULL

NULL

NULL

PostalCode

NULL

NO

nvarchar

10

20

NULL

NULL

PostalBarCode

NULL

YES

nvarchar

50

100

NULL

NULL

 

 

TABLE_NAME:  TravelClasses

COLUMN_NAME

COLUMN_DEFAULT

 IS_NULLABLE

DATA_TYPE

 CHARACTER_MAXIMUM_LENGTH

NUMERIC_PRECISION

NUMERIC_SCALE

  DATETIME_PRECISION

TravelClassId

NULL

NO

int

NULL

NULL

NULL

NULL

Category

NULL

YES

nvarchar

50

100

NULL

NULL

TravelClassCode

NULL

NO

nchar

1

2

NULL

NULL

TravelClassDescription

NULL

YES

nvarchar

50

100

NULL

NULL

TestSSIS

NULL

YES

nvarchar

100

200

NULL

NULL

 

 

TABLE_NAME:  Users

COLUMN_NAME

COLUMN_DEFAULT

 IS_NULLABLE

DATA_TYPE

 CHARACTER_MAXIMUM_LENGTH

NUMERIC_PRECISION

NUMERIC_SCALE

  DATETIME_PRECISION

UserId

NULL

NO

int

NULL

NULL

NULL

NULL

UserName

NULL

NO

nvarchar

50

100

NULL

NULL

UserPwd

NULL

NO

nvarchar

50

100

NULL

NULL

PwdExpiryDate

NULL

YES

datetime

NULL

NULL

3

3

PwdChangeAtLogin

NULL

YES

bit

NULL

NULL

0

NULL

IsAppAdmin

((0))

NO

bit

NULL

NULL

0

NULL

BeginDate

(getdate())

NO

datetime

NULL

NULL

3

3

EndDate

NULL

YES

datetime

NULL

NULL

3

3

 

 

TABLE_NAME:  Users_Groups

COLUMN_NAME

COLUMN_DEFAULT

 IS_NULLABLE

DATA_TYPE

 CHARACTER_MAXIMUM_LENGTH

NUMERIC_PRECISION

NUMERIC_SCALE

  DATETIME_PRECISION

GroupId

NULL

NO

int

NULL

NULL

NULL

NULL

UserId

NULL

NO

int

NULL

NULL

NULL

NULL

BeginDate

(getdate())

NO

datetime

NULL

NULL

3

3

EndDate

NULL

YES

datetime

NULL

NULL

3

3