# Presentation: 284670

## NIH DB Survey Progress Report

- NIH AMG Technical Subcommittee

- DRAFT 3

- 9/16/98

## DBs Included in Survey

- NIH Email Directory and Forwarding Service
- NIH Human Resources Database
- NIH Scientific Directory
- Parking/ID Badge/Transhare (PAID) DB
- NIH Telecommunications DB

- DRAFT 3

- 9/16/98

## DBs Included in Survey (cont.)

- NCI/NHLBI NDS
- CIT NT & Exchange
- NIH Data Warehouse
- Fogarty DB

- DRAFT 3

- 9/16/98

## NIH Email Directory and Forwarding Service

- A meta-directory and forwarding service for 23 NIH email systems
- Over 28,700 entries, >700 duplicates
- Can provide to NIH Directory:
- PH alias
- Preferred email address
- Nickname list

- DRAFT 3

- 9/16/98

## NIH Email Directory and Forwarding Service (cont.)

- Freeware CSO server on Solaris
- Integration options:
- Replace with COTS product
- Replace CSO DB w/ LDAP connection to meta-directory
- Connect to meta-directory

- DRAFT 3

- 9/16/98

## NIH Human Resources Database

- Current and historical HR data (from 1982) on all NIH Civil Service and PHS Commissioned Corps employees
- 17,000 current employees
- DB2/MVS
- Most data provided by DHHS/OPM
- ICs provide timekeeper name

- DRAFT 3

- 9/16/98

## NIH Human Resources Database (cont.)

- Can provide to NIH Directory:
- First name, Last name, Middle Initial
- SSN
- Position code and free form text
- Tenure code
- Home Postal address
- Timekeeper
- SAC (Standard Administration Code)
- SAC/IC table

- DRAFT 3

- 9/16/98

## NIH Human Resources Database (cont.)

- NIH Directory could provide to HRDB:
- Information currently obtained from *NIH Telephone and Services Directory*
- buildingName
- houseIdentifier
- roomNumber
- telephoneNumber
- FacsimileTelephoneNumber
- Timekeeper information currently obtained from ICs

- DRAFT 3

- 9/16/98

## NIH Human Resources Database (cont.)

- HRDB SAC information believed to be:
- Outdated
- Incomplete
- Inconsistent

- DRAFT 3

- 9/16/98

## NIH Scientific Directory

- Consolidated, historical information about all researchers who have worked in an NIH lab for more than 2 months
- NIH organizational information
- Over 9,000 researchers and 4,000 OUs
- Oracle on Digital UNIX (EOS)
- Initialized w/ data from HRDB (scientific series), OFM, and JEFIC

- DRAFT 3

- 9/16/98

## NIH Scientific Directory (cont.)

- Scientific Directory should reference NIHPerson info in NIH Directory via NIH UID
- Scientific Directory Organizational DB and update service should be consolidated with NIH Directory

- DRAFT 3

- 9/16/98

## PAID--Parking/ID Badge/ Transhare

- Tracks
- permits issued to persons using NIH parking facilities (about 18,800)
- participants in the NIH Transhare program (about 2,000)
- assignment of NIH ID badges to (non FDA) workers at MD sites (about 31,800)

- DRAFT 3

- 9/16/98

## PAID--Parking/ID Badge/ Transhare (cont.)

- dBASE IV on NT
- Can provide to NIH Directory:
- Digitized photo ID
- NIH status (NIH, Guest, Contractor, Volunteer)
- Updates to work and home address and telephone number

- DRAFT 3

- 9/16/98

## PAID--Parking/ID Badge/ Transhare (cont.)

- PAID system to be redesigned as part of directory project
- Integration with new card key system under investigation
- Survey ID badge systems at RTP/NC, Waltham/MA, RML/MT?
- Consider use of “smart” badges?

- DRAFT 3

- 9/16/98

## NIH Telecommunications DB

- On-line information system for NIH switchboard operators and code blue service, and production of the *NIH Telephone and Service Directory*
- Lists:
- Permanent Federal employees
- Temporary Federal employees >1 year
- Temporary Federal physicians >6 months
- Other non-Federal employees
- FoxPro on NT

- DRAFT 3

- 9/16/98

## NIH Telecommunications DB (cont.)

- Includes SSN for Federal employees (60% of all “white pages” entries)
- Personnel listing DB could be used to initially load NIH directory with:
- telephone
- FAX
- building/room/MSC

- DRAFT 3

- 9/16/98

## NIH Telecommunications DB (cont.)

- NIH Directory should replace form NIH 433
- consider direct update by users via Web
- Other “ad hoc” updates to directory of on-call personnel (“gray pages”)
- direct update via Web highly desirable

- DRAFT 3

- 9/16/98

## NCI/NHLBI NDS

- Directory supporting Novell NOS
- Users:
- NCI: 4,000
- NHLBI: 1,200
- Can provide: Name, Title, Organization, Work phone, Work FAX, Work location
- Info entered/updated by system administrators

- DRAFT 3

- 9/16/98

## NCI/NHLBI NDS (cont.)

- NDS administrators wish to update these attributes in NDS
- PAID, Telecom, Scientific Directory, others wish to update same attributes in meta-directory
- Conflict if meta-directory does not support multi-mastered attributes

- DRAFT 3

- 9/16/98

## NIH NT Domain Registry

- NIH-wide, centrally administered NT domain
- Trust relationships with 55 of 171 NT domains that at NIH
- Authentication service for NIH Central Exchange Service
- Approximately 8,000 entries

- DRAFT 3

- 9/16/98

## NIH NT Domain Registry

- Contains
- First/Last Name
- BUILDING/ROOM WORK-TELEPHONE IC-BRANCH in *description* field
- Integrate with directory:
- add UID to description field
- obtain other info from directory

- DRAFT 3

- 9/16/98

## NIH Central Exchange Service

- Provides central email lookup and delivery service for NIH MS Exchange email users
- Approximately 15,000 entries
- Connected to NIH Email Directory and Forwarding Service
- Provides MS Exchange email address
- Obtains attributes for non-Exchange entries in Global Address List (GAL)
- Survey incomplete

- DRAFT 3

- 9/16/98

## NIH Data Warehouse

- Contains “transformed and cleaned” data from HRDB and others
- Read-only
- Survey incomplete

- DRAFT 3

- 9/16/98

## Coming Attractions

- Fogarty DB

- DRAFT 3

- 9/16/98