Column | Type | Length | Contents |
---|
ID | int | | Entity ID number |
Type | char | 1 | Entity Type (H=human, G=group) |
Title | char | 5 | Entity title |
LastName | char | 25 | Entity last name |
FirstName | char | 20 | Entity first name, also referred to as Name of Record |
MiddleName | char | 15 | Entity middle name |
Suffix | char | 5 | Entity suffix |
FamiliarName | char | 20 | Entity familiar name, also referred to as Preferred Name |
MaintDt | smalldatatime | | Last date the record was updated |
LastChgName | varchar | 46 | Name of last user who updated the record |
OrigDt | datetime | | Date the entity was originally created |
StdtFlag | char | 1 | Flag indicating whether the entity is a student (Y=student,N=not a student) |
NonStdtFlag | char | 1 | Flag indicating whether the entity is not a student (Y=not a student,N=student) |
Obsolete | char | 1 | Flag indicating whether the entity is obsolete (Y=obsolete, N=not obsolete) |
Memo | varchar | 100 | Explanatory information |
TestPerson | char | 1 | Flag indicating whether the entity is a test person (Y=test person, Null=not a test person) |
Pronunciation | varchar | 60 | Entity’s description of how to pronounce their name |