The following attributes are included in the DB2 USERREG.NED_PERSON view.
| NAME | DATA TYPE | COMMENTS |
| UNIQUEIDENTIFIER | CHAR (10) NOT NULL | Primary key (NIH ID#) |
| BUILDINGNAME | VARCHAR (255) | |
| C | CHAR (2) | |
| DESCRIPTION | VARCHAR (1024) | |
| FACSIMILETELEPHONE | VARCHAR (30) | |
| GENERATIONQUALIF | VARCHAR (5) | Mixed case |
| GIVENNAME | VARCHAR (64) NOT NULL | Initial Caps |
| INITIALS | VARCHAR (5) | UPPERCASE |
| L | VARCHAR (128) | |
| VARCHAR (256) | ||
| MANAGER | CHAR (10) | DN converted to uniqueidentifier (NIH ID#) [currently unused] |
| MIDDLENAME | VARCHAR (64) | Initial Caps |
| MOBILETELEPHONENUM | VARCHAR (30) | |
| NIHIDBADGETITLE | VARCHAR (40) | Designation (e.g., Physician, Nurse) printed on ID badges of patient care workers or people working in the Clinical Center. |
| NIHCOMMONGENQUALIF | VARCHAR (5) | Mixed case |
| NIHCOMMONGIVENNAME | VARCHAR (64) | Initial Caps |
| NIHCOMMONMIDDLENAM | VARCHAR (64) | Initial Caps |
| NIHCOMMONSN | VARCHAR (64) | UPPERCASE |
| NIHCREATETIMESTAMP | TIMESTAMP | Date NID ID # first assigned |
| NIHCREATORSNAME | CHAR (10) | DN converted to uniqueidentifier (NIH ID#) |
| NIHDELIVERYADDRESS | VARCHAR (255) | |
| NIHDIRENTRYNOPRINT | CHAR (1) | |
| NIHDIRENTRYEFFDATE | DATE | NIH Enter on Date (EOD) |
| NIHDIRENTRYEXPDATE | DATE | |
| NIHDIRENTRYUNLIST | CHAR (1) | NIHHHSUNIQUEMAIL | VARCHAR (255) |
| NIHIDBADGEEXPDATE | DATE | Represents either the the expiration date of an issued NIH ID badge or the requested expiration date for an NIH ID badge that has been authorized, but not yet issued. (See note below regarding how to determine whether a badge is issued or authorized.) |
| NIHIDBADGEISSUEREA | VARCHAR (20) | Reason for a badge authorization (e.g., Initial Request, Renewal, Lost, etc. (nulled upon badge issuance). |
| NIHIDBADGEREQDATE | DATE | The date on which a person was authorized for an NIH ID badge (nulled upon badge issuance). |
| NIHIPD | VARCHAR (48) | |
| NIHLIBRARYAUTH | CHAR (1) | 'Y' indicates a person is authorized for NIH Library privileges |
| NIHMAILSTOP | VARCHAR (40) | |
| NIHMDSLINKTOADNIH | VARCHAR (20) | Active Directory sAMAccountName |
| NIHMDSLINKTOHELP | VARCHAR (12) | Remedy Customer ID |
| NIHMDSLINKTOPH | VARCHAR (32) | PH alias |
| NIHMIXCASECOMMONSN | VARCHAR (64) | preferred surname (mixed case) |
| NIHMIXCASESN | VARCHAR (64) | surname (mixed case) |
| NIHMODIFIERSNAME | CHAR (10) | DN converted to uniqueidentifier (NIH ID#) |
| NIHMODIFYTIMESTAMP | TIMESTAMP | Set to the current time whenever any other column is updated, BUT may also be set to current time even if NO other columns have changed. |
| NIHORGACRONYM | VARCHAR (64) | IC abbreviation (e.g., NCI) |
| NIHORGNAME | VARCHAR (64) | IC name (e.g., National Cancer Institute) |
| NIHORGPATH | VARCHAR (255) | |
| NIHOUACRONYM | VARCHAR (64) | Acronym of organizational unit |
| NIHOUNAME | VARCHAR (64) | Name of organizational unit |
| NIHPHYSICALADDRESS | VARCHAR (255) | |
| NIHPHYSPOSTALCODE | VARCHAR (40) | |
| NIHSAC | VARCHAR (30) | Standard Administration Code (SAC); 'HN' converted to null |
| NIHSITE | VARCHAR (15) | |
| NIHSSODOMAIN | VARCHAR (15) | |
| NIHSSOUSERNAME | VARCHAR (20) | |
| NIHSUFFIXQUALIFIER | VARCHAR (20) | UPPERCASE |
| NIHSUMMERSTATUS | CHAR (1) | 'Y' indicates the person is a summer worker |
| NIHTTY | VARCHAR (30) | |
| NIHUIDQUALITY | DECIMAL (1,0) | [currently unused] |
| NIHUIDVALIDATIONTS | TIMESTAMP | [currently unused] |
| NIHUIDVALIDATOR | CHAR (10) | DN converted to uniqueidentifier (NIH ID#) [currently unused] |
| NIHUNIQUEMAIL | VARCHAR (255) | |
| ORGANIZATIONALSTAT | VARCHAR (255) | |
| PAGERTELEPHONENUM | VARCHAR (30) | |
| PERSONALTITLE | CHAR (16) | Mixed case |
| POSTALADDRESS | VARCHAR (255) | |
| POSTALCODE | VARCHAR (40) | |
| ROOMNUMBER | VARCHAR (255) | |
| SECRETARY | CHAR (10) | DN converted to uniqueidentifier (NIH ID#) |
| SN | VARCHAR (64) NOT NULL | UPPERCASE |
| ST | VARCHAR (128) | |
| STREET | VARCHAR (128) | |
| TELEPHONENUMBER | VARCHAR (30) | |
| TITLE | VARCHAR (64) |
Notes:
1)
Do not expect the creation/modification timestamps and names to be useful.
2) ID badge "status" can be
determined based on information contained in a person's NED record. Badge
status will always be one of the following:
a) Issued (Person has an issued badge):
- NIHIDBADGEEXPDATE is not null and
is a future date
- NIHIDBADGEREQDATE is null
- NIHIDBADGEISSUEREA is null
b) Authorized (Person has been authorized to receive a
badge, but has not yet picked it up):
- NIHIDBADGEEXPDATE is not null
- NIHIDBADGEREQDATE is not null
- NIHIDBADGEISSUEREA is not null
c) Not Authorized (Person has not been authorized for a
badge):
- NIHIDBADGEEXPDATE is null
- NIHIDBADGEREQDATE is null
- NIHIDBADGEISSUEREA is null
If you have questions or need additional information, please contact ned-ops@list.nih.gov.