2.36 NC_User Table

The NC_User table contains information about entered users.

Column

Key

Type

Null

Description

UserOID

PK

binary(16)

No

An internal ID number used as a primary key.

FirstName

nvarchar(32)

The user’s first name.

MiddleName

nvarchar(32)

The user’s middle name.

LastName

nvarchar(32)

The user’s last name.

Phone

nvarchar(32)

The user’s telephone number.

Email

nvarchar(100)

The user’s e-mail address.

Phone2

nvarchar(32)

The user’s second telephone number.

Fax

nvarchar(32)

The user’s fax number.

IsDeleted

DateTime

The date and time the record was deleted; else null.

ADF0

 

nvarchar(256)

 

Description of "Administrator Defined Field 0"

ADF1

 

nvarchar(256)

 

Description of "Administrator Defined Field 1"

ADF2

 

nvarchar(64)

 

Description of "Administrator Defined Field 2"

ADF3

 

nvarchar(64)

 

Description of "Administrator Defined Field 3"

ADF4

 

nvarchar(64)

 

Description of "Administrator Defined Field 4"

ADF5

 

nvarchar(64)

 

Description of "Administrator Defined Field 5"

ADF6

 

nvarchar(64)

 

Description of "Administrator Defined Field 6"

ADF7

 

nvarchar(64)

 

Description of "Administrator Defined Field 7"

ADF8

 

nvarchar(64)

 

Description of "Administrator Defined Field 8"

ADF9

 

nvarchar(64)

 

Description of "Administrator Defined Field 9"

ADF10

 

nvarchar(64)

 

Description of "Administrator Defined Field 10"

ADF11

 

nvarchar(64)

 

Description of "Administrator Defined Field 11"

ADF12

 

nvarchar(64)

 

Description of "Administrator Defined Field 12"

ADF13

 

nvarchar(64)

 

Description of "Administrator Defined Field 13"

ADF14

 

nvarchar(64)

 

Description of "Administrator Defined Field 14"

ADF15

 

nvarchar(64)

 

Description of "Administrator Defined Field 15"

ADF16

 

nvarchar(64)

 

Description of "Administrator Defined Field 16"

ADF17

 

nvarchar(64)

 

Description of "Administrator Defined Field 17"

ADF18

 

nvarchar(64)

 

Description of "Administrator Defined Field 18"

ADF19

 

nvarchar(64)

 

Description of "Administrator Defined Field 19"