RegisteredUsers
Name: Registered Users
Type: Application
Modules: Info, COM-Investigator, COM-Representative
Description: Used by subscription and notification mechanism. Also used in COM for registered customer information.
| Field | Documentation |
|---|---|
| RegisteredUserId | Unique identifier for a registered user. |
| LoginName | Login name for the user for the Trapeze system. |
| Password | Password for the user to login into the Trapeze system. |
| FirstName | User's first name. |
| LastName | User's last name. |
| MiddleInitial | User's middle initial. |
| Gender | User's gender. |
| Address | User's address. |
| AddrName | Name of the building the address is at. For example, Sears Tower. |
| SiteName | Name of the site the address is at. |
| StreetNo | Street number of the user's address. |
| OnStreet | Name of the street the address is on. |
| AtStreet | Street name of the intersection nearest to the address. |
| Unit | Unit number of the address. |
| City | City that the address is in. |
| ZipCode | Zip code or Postal code of the address. |
| State | State that the address is in. |
| Lon | Longitude coordinate of the address. |
| Lat | Latitude coordinate of the address. |
| GeoStatus | GeoStatus code. Specifies the lon and lat values and their validity. |
| PhoneHome | Home phone number of the user. |
| PhoneBusiness | Business phone number of the user. |
| PhoneCell | Cell phone number of the user. |
| PhoneOther | Alternative phone number of the user. |
| Email address of the user. | |
| FaxNumber | Fax number of the user. |
| LanguageName | Language spoken by the user. |
| FromDate | Date from which the user is valid. Format: YYYYMMDD. |
| ToDate | Date to which the user is valid. Format: YYYYMMDD. |
| CreBy | User who registered this user. |
| CreDate | Date when the user was registered. Format: YYYYMMDD. |
| CreTime | Time when the user was registered. Value is in seconds from midnight. |
| ModBy | User who last modified the record. |
| ModDate | Date when the record was last modified. |
| ModTime | Time when the record was last modified. Value is in seconds from midnight. |
| FundingSourceId | Funding source identifier from FundingSources.FundingSourceId. |
| Active | Indicates whether the specific user is active. |
| Comments | Comments about the record. |
| TitleId | Title identifier from Titles.TitleId. References the title of the user. |
| UserLong1 | User-defined numeric data, usually used as a supplementary field for a large integer. |
| UserLong10 | User-defined numeric data, usually used as a supplementary field for a large integer. |
| UserLong11 | User-defined numeric data, usually used as a supplementary field for a large integer. |
| UserLong12 | User-defined numeric data, usually used as a supplementary field for a large integer. |
| UserLong13 | User-defined numeric data, usually used as a supplementary field for a large integer. |
| UserLong14 | User-defined numeric data, usually used as a supplementary field for a large integer. |
| UserLong15 | User-defined numeric data, usually used as a supplementary field for a large integer. |
| UserLong2 | User-defined numeric data, usually used as a supplementary field for a large integer. |
| UserLong3 | User-defined numeric data, usually used as a supplementary field for a large integer. |
| UserLong4 | User-defined numeric data, usually used as a supplementary field for a large integer. |
| UserLong5 | User-defined numeric data, usually used as a supplementary field for a large integer. |
| UserLong6 | User-defined numeric data, usually used as a supplementary field for a large integer. |
| UserLong7 | User-defined numeric data, usually used as a supplementary field for a large integer. |
| UserLong8 | User-defined numeric data, usually used as a supplementary field for a large integer. |
| UserLong9 | User-defined numeric data, usually used as a supplementary field for a large integer. |
| UserLongString1 | User-defined string data, usually used as a supplementary field for a long string. |
| UserLongString10 | User-defined string data, usually used as a supplementary field for a long string. |
| UserLongString11 | User-defined string data, usually used as a supplementary field for a long string. |
| UserLongString12 | User-defined string data, usually used as a supplementary field for a long string. |
| UserLongString13 | User-defined string data, usually used as a supplementary field for a long string. |
| UserLongString14 | User-defined string data, usually used as a supplementary field for a long string. |
| UserLongString15 | User-defined string data, usually used as a supplementary field for a long string. |
| UserLongString16 | User-defined string data, usually used as a supplementary field for a long string. |
| UserLongString17 | User-defined string data, usually used as a supplementary field for a long string. |
| UserLongString18 | User-defined string data, usually used as a supplementary field for a long string. |
| UserLongString19 | User-defined string data, usually used as a supplementary field for a long string. |
| UserLongString2 | User-defined string data, usually used as a supplementary field for a long string. |
| UserLongString20 | User-defined string data, usually used as a supplementary field for a long string. |
| UserLongString21 | User-defined string data, usually used as a supplementary field for a long string. |
| UserLongString22 | User-defined string data, usually used as a supplementary field for a long string. |
| UserLongString23 | User-defined string data, usually used as a supplementary field for a long string. |
| UserLongString24 | User-defined string data, usually used as a supplementary field for a long string. |
| UserLongString25 | User-defined string data, usually used as a supplementary field for a long string. |
| UserLongString26 | User-defined string data, usually used as a supplementary field for a long string. |
| UserLongString27 | User-defined string data, usually used as a supplementary field for a long string. |
| UserLongString28 | User-defined string data, usually used as a supplementary field for a long string. |
| UserLongString29 | User-defined string data, usually used as a supplementary field for a long string. |
| UserLongString3 | User-defined string data, usually used as a supplementary field for a long string. |
| UserLongString30 | User-defined string data, usually used as a supplementary field for a long string. |
| UserLongString4 | User-defined string data, usually used as a supplementary field for a long string. |
| UserLongString5 | User-defined string data, usually used as a supplementary field for a long string. |
| UserLongString6 | User-defined string data, usually used as a supplementary field for a long string. |
| UserLongString7 | User-defined string data, usually used as a supplementary field for a long string. |
| UserLongString8 | User-defined string data, usually used as a supplementary field for a long string. |
| UserLongString9 | User-defined string data, usually used as a supplementary field for a long string. |
| UserDouble1 | User-defined numeric data, usually used as a supplementary field for a decimal value. |
| UserDouble10 | User-defined numeric data, usually used as a supplementary field for a decimal value. |
| UserDouble2 | User-defined numeric data, usually used as a supplementary field for a decimal value. |
| UserDouble3 | User-defined numeric data, usually used as a supplementary field for a decimal value. |
| UserDouble4 | User-defined numeric data, usually used as a supplementary field for a decimal value. |
| UserDouble5 | User-defined numeric data, usually used as a supplementary field for a decimal value. |
| UserDouble6 | User-defined numeric data, usually used as a supplementary field for a decimal value. |
| UserDouble7 | User-defined numeric data, usually used as a supplementary field for a decimal value. |
| UserDouble8 | Use-defined numeric data, usually used as a supplementary field for a decimal value. |
| UserDouble9 | User-defined numeric data, usually used as a supplementary field for a decimal value. |
| UserShort1 | User-defined numeric data, usually used as a supplementary field for a small integer. |
| UserShort10 | User-defined numeric data, usually used as a supplementary field for a small integer. |
| UserShort2 | User-defined numeric data, usually used as a supplementary field for a small integer. |
| UserShort3 | User-defined numeric data, usually used as a supplementary field for a small integer. |
| UserShort4 | User-defined numeric data, usually used as a supplementary field for a small integer. |
| UserShort5 | User-defined numeric data, usually used as a supplementary field for a small integer. |
| UserShort6 | User-defined numeric data, usually used as a supplementary field for a small integer. |
| UserShort7 | User-defined numeric data, usually used as a supplementary field for a small integer. |
| UserShort8 | User-defined numeric data, usually used as a supplementary field for a small integer. |
| UserShort9 | User-defined numeric data, usually used as a supplementary field for a small integer. |
| UserString1 | User-defined string data, usually used as a supplementary field for a short string. |
| UserString10 | User-defined string data, usually used as a supplementary field for a short string. |
| UserString11 | User-defined string data, usually used as a supplementary field for a short string. |
| UserString12 | User-defined string data, usually used as a supplementary field for a short string. |
| UserString13 | User-defined string data, usually used as a supplementary field for a short string. |
| UserString14 | User-defined string data, usually used as a supplementary field for a short string. |
| UserString15 | User-defined string data, usually used as a supplementary field for a short string. |
| UserString16 | User-defined string data, usually used as a supplementary field for a short string. |
| UserString17 | User-defined string data, usually used as a supplementary field for a short string. |
| UserString18 | User-defined string data, usually used as a supplementary field for a short string. |
| UserString19 | User-defined string data, usually used as a supplementary field for a short string. |
| UserString2 | User-defined string data, usually used as a supplementary field for a short string. |
| UserString20 | User-defined string data, usually used as a supplementary field for a short string. |
| UserString21 | User-defined string data, usually used as a supplementary field for a short string. |
| UserString22 | User-defined string data, usually used as a supplementary field for a short string. |
| UserString23 | User-defined string data, usually used as a supplementary field for a short string. |
| UserString24 | User-defined string data, usually used as a supplementary field for a short string. |
| UserString25 | User-defined string data, usually used as a supplementary field for a short string. |
| UserString26 | User-defined string data, usually used as a supplementary field for a short string. |
| UserString27 | User-defined string data, usually used as a supplementary field for a short string. |
| UserString28 | User-defined string data, usually used as a supplementary field for a short string. |
| UserString29 | User-defined string data, usually used as a supplementary field for a short string. |
| UserString3 | User-defined string data, usually used as a supplementary field for a short string. |
| UserString30 | User-defined string data, usually used as a supplementary field for a short string. |
| UserString4 | User-defined string data, usually used as a supplementary field for a short string. |
| UserString5 | User-defined string data, usually used as a supplementary field for a short string. |
| UserString6 | User-defined string data, usually used as a supplementary field for a short string. |
| UserString7 | User-defined string data, usually used as a supplementary field for a short string. |
| UserString8 | User-defined string data, usually used as a supplementary field for a short string. |
| UserString9 | User-defined string data, usually used as a supplementary field for a short string. |
| DeliveryMethodId | Delivery method identifier from DeliveryMethods.DeliveryMethodId. References the delivery method for the user's subscription, e.g., Mail, Email. |
| ActivationString | String used to activate TransitNOW accounts. |
| Deleted | Indicates whether the user was deleted. |
| RegistrationDate | Date when the user was registered. Format: YYYYMMDD. |
| ActivationDate | Date when the user was activated. Format: YYYYMMDD. |
| RegistrationTime | Time when the user was registered. Value is in seconds from midnight. |
| ActivationTime | Time when the user was activated and permitted to use the system. Value is in seconds from midnight. |
| NewEmail | Stores the new email address when a TransitNOW user changes passwords. |
| NewEmailActivationString | String used by TransitNOW user to activate new emails when changing email addresses. |
| IsLocked | Indicates whether the user is locked. |
| FailedLoginAttempts | Number of failed logins since the last successful login. |
| SMSCarrier | TransitNOW user's cellular carrier when sending SMS message via email protocol. |
| ExpirationString | Unique string made up of a date, time, and a randomly generated key for securing the reset password functionality. |
| PasswordVersion | Enumeration for the hashing algorithm used to store the password. |
| LockedTimeStamp | Date and time when the user account is locked. |