PUBLICNED.NED_PERSON

The following attributes are included in the Oracle PUBLICNED.NED_PERSON view.

NAME	DATA TYPE	COMMENTS
UNIQUEIDENTIFIER	CHAR (10) NOT NULL	Primary key (NIH ID#)
BUILDINGNAME	VARCHAR2 (256)
C	CHAR (2)
DESCRIPTION	VARCHAR2 (1024)
FACSIMILETELEPHONE	VARCHAR2 (30)
GENERATIONQUALIF	VARCHAR2 (5)	Mixed case
GIVENNAME	VARCHAR2 (64) NOT NULL	Initial Caps
INITIALS	VARCHAR2 (5)	UPPERCASE
L	VARCHAR2 (128)
MAIL	VARCHAR2 (256)
MANAGER	CHAR (10)	DN converted to uniqueidentifier (NIH ID#) [currently unused]
MIDDLENAME	VARCHAR2 (64)	Initial Caps
MOBILETELEPHONENUM	VARCHAR2 (30)
NIHIDBADGETITLE	VARCHAR2 (40)	Designation (e.g., Physician, Nurse) printed on ID badges of patient care workers or people working in the Clinical Center.
NIHCOMMONGENQUALIF	VARCHAR2 (5)	Mixed case
NIHCOMMONGIVENNAME	VARCHAR2 (64)	Initial Caps
NIHCOMMONMIDDLENAM	VARCHAR2 (64)	Initial Caps
NIHCOMMONSN	VARCHAR2 (64)	UPPERCASE
NIHCREATETIMESTAMP	DATE	Date NIH ID # first assigned
NIHCREATORSNAME	CHAR (10)	DN converted to uniqueidentifier (NIH ID#)
NIHDELIVERYADDRESS	VARCHAR2 (255)
NIHDIRENTRYNOPRINT	CHAR (1)
NIHDIRENTRYEFFECTIVEDATE	DATE	NIH entry on duty (EOD) date
NIHDIRENTRYEXPDATE	DATE
NIHDIRENTRYUNLIST	CHAR (1)
NIHHHSUNIQUEMAIL	VARCHAR2 (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	VARCHAR2 (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	VARCHAR2 (48)
NIHLIBRARYAUTH	CHAR (1)	'Y' indicates a person is authorized for NIH Library privileges
NIHMAILSTOP	VARCHAR2 (40)
NIHMDSLINKTOADNIH	VARCHAR2 (20)	Active Directory sAMAccountName
NIHMDSLINKTOHELP	VARCHAR2 (12)	Remedy Customer ID
NIHMDSLINKTOPH	VARCHAR2 (32)	PH alias
NIHMIXCASECOMMONSN	VARCHAR2 (64)	preferred surname (mixed case)
NIHMIXCASESN	VARCHAR2 (64)	surname (mixed case)
NIHMODIFIERSNAME	CHAR (10)	DN converted to uniqueidentifier (NIH ID#)
NIHMODIFYTIMESTAMP	DATE	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	VARCHAR2 (64)	IC abbreviation (e.g., NCI)
NIHORGNAME	VARCHAR2 (64)	IC name (e.g., National Cancer Institute)
NIHORGPATH	VARCHAR2 (256)
NIHOUACRONYM	VARCHAR2 (64)	Acronym of organizational unit
NIHOUNAME	VARCHAR2 (64)	Name of organizational unit
NIHPHYSICALADDRESS	VARCHAR2 (255)
NIHPHYSPOSTALCODE	VARCHAR2 (40)
NIHSAC	VARCHAR2 (30)	Standard Administration Code (SAC); 'HN' converted to null
NIHSITE	VARCHAR2 (15)
NIHSSODOMAIN	VARCHAR2 (15)
NIHSSOUSERNAME	VARCHAR2 (20)
NIHSUFFIXQUALIFIER	VARCHAR2 (20)	UPPERCASE
NIHSUMMERSTATUS	CHAR (1)	'Y' indicates the person is a summer worker
NIHTTY	VARCHAR2 (30)
NIHUIDQUALITY	NUMBER (1)	[currently unused]
NIHUIDVALIDATIONTS	DATE	[currently unused]
NIHUIDVALIDATOR	CHAR (10)	DN converted to uniqueidentifier (NIH ID#) [currently unused]
NIHUNIQUEMAIL	VARCHAR2 (256)
ORGANIZATIONALSTAT	VARCHAR2 (256)
PAGERTELEPHONENUM	VARCHAR2 (30)
PERSONALTITLE	CHAR (16)	Mixed case
POSTALADDRESS	VARCHAR2 (255)
POSTALCODE	VARCHAR2 (40)
ROOMNUMBER	VARCHAR2 (256)
SECRETARY	CHAR (10)	DN converted to uniqueidentifier (NIH ID#)
SN	VARCHAR2 (64) NOT NULL	UPPERCASE
ST	VARCHAR2 (128)
STREET	VARCHAR2 (128)
TELEPHONENUMBER	VARCHAR2 (30)
TITLE	VARCHAR2 (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.

Return to "Data Access"