por_user

The Portal user table is used to store user attributes and profile information.

Column Name	Column Datatype	Column Null Option	Column Comment
objectkey	integer	not null	Represents the UID of a Portal object in the objectrepos table that contains more information on the user.
fname	nvarchar(40)	with null	User's first name.
lname	nvarchar(40)	with null	User's last name.
defaultgroup	integer	with null	User's default group.
homefolderkey	integer	with null	User's home folder. This is where the user's documents will go by default.
email	nvarchar(100)	with null	User's email address.
address1	nvarchar(100)	with null	First line of user's address.
address2	nvarchar(100)	with null	Second line of user's address.
city	nvarchar(40)	with null	City user is located in.
state	nvarchar(40)	with null	State the user is located in.
country	nvarchar(40)	with null	Country the user is located in.
zip	nvarchar(40)	with null	User's zip code.
homephone	nvarchar(40)	with null	User's home phone number.
company	nvarchar(100)	with null	Company the user is a part of.
title	nvarchar(40)	with null	User's title.
busphone	nvarchar(40)	with null	User's work phone number.
fax	nvarchar(40)	with null	User's fax number.
department	nvarchar(40)	with null	User's department.
pager	nvarchar(40)	with null	User's pager number.
cellphone	nvarchar(40)	with null	User's mobile phone number.
templateptr	integer	with null	Group id whose template the user should use. If the value is -1, the Portal user is allowed to choose their own individual template in MyProfile.
templatekey	integer	with null	Unique ID of this template.
publicnews	integer	with null	(This field is not used by Portal.)
groupnews	integer	with null	(This field is not used by Portal.)
privatenews	integer	with null	(This field is not used by Portal.)
resetwrkplc	nvarchar(10)	with null	Boolean value true/false describing whether or not to reset the user's workplace the next time they login.

Product Name: Portal

Table Type: Table

Relationships:

Primary Key	Related Table	Related Column
objectkey