EXHIBIT 1- Database Fields.pdf
PDF 113 KB Posted
- Attached to
- OPM OIG Database Requirement
- Solicitation number
- OPMOIG050924
- Issued by
-
Office of Personnel Management
About this file
This document appears to be an exhibit detailing the required data fields for a database that the Office of Personnel Management (OPM) Office of the Inspector General (OIG) is seeking to procure. The exhibit provides a comprehensive list of over 40 data fields, including information related to debarment and suspensions, as well as FEHB (Federal Employees Health Benefits) carriers. The key details include the character limits, data types, and descriptions for each field, such as last name, first name, business name, SSN, FEIN/TIN, DUNS, NPI, license information, exclusion dates, and various dates and codes related to the debarment and suspension process. For the FEHB carrier data, the fields include plan information, contact details, provider data, and various metrics related to the plan's performance. The document is likely part of a larger solicitation, as indicated by the related federal contract opportunity for an OPM OIG Database Requirement, which is currently in the pre-solicitation phase and seeking a high-level technical overview and rough order of magnitude pricing from interested vendors for market research purposes.
View the file
Other files
| File | Type | Posted |
|---|---|---|
| ASG SOW 05.08.24.pdf | ||
| ASG System RFI.pdf |
On GovTribe
Work with this file
- Download the original file
- Contacts named in this file
- Similar government files
- Ask GovTribe AI about this file
Text version
EXHIBIT 1
Required Data Fields
Data Entry:
The database must provide the ability to enter a wide variety of data in all fields, which include, but are not limited to the fields listed below:
a. Debarment and Suspensions
i. Last Name (25 CHARACTERS)
ii. Suffix (3 CHARACTERS)
iii. Middle Name (25 CHARACTERS)
iv. First Name (25 CHARACTERS)
v. Business Name (35 CHARACTERS, ALPHA & NUMBERIC)
vi. DOB (8 DIGITS, MM/DD/YEAR)
vii. SSN (9 DIGITS)
viii. FEIN/TIN (9 DIGITS)
ix. UPIN
x. DUNS (9 DIGITS)
xi. NPI (10 DIGITS)
xii. X-REF (50 CHARACTERS)
xiii. TITLE (25 CHARACTERS)
xiv. STREET ADDRESS (50 CHARACTERS, ALPHA & NUMBERIC)
xv. CITY (20 CHARACTERS)
xvi. ZIP (9 DIGITS)
xvii. TELEPHONE (10 DIGITS)
xviii. EMAIL (30 CHARACTERS, ALPHA & NUMERIC)
xix. LICENSE (50 CHARACTERS, ALPHA & NUMERIC)
xx. HHS EXCLUSION DATE (8 DIGITS)
xxi. HHS EXCLUSION CODE (12 CHARACTERS, ALPHA & NUMERIC)
xxii. HHS ID (4 DIGITS)
xxiii. YEARS (2 DIGITS)
xxiv. REMARKS (25 CHARACTERS)
xxv. DEBAR CODE (12 CHARACTERS, ALPHA & NUMERIC)
xxvi. FACTS (72 CHARACTERS, ALPHA & NUMERIC)
xxvii. PROFESSIONAL CODE (2 DIGITS) xxviii. STATUS CODE (8 DIGITS)
xxix. NPD (8 DIGITS)
xxx. RECEIPT DATE (8 DIGITS)
xxxi. SUSPEND DATE (8 DIGITS)
xxxii. DEBAR DATE (8 DIGITS) xxxiii. TERM DATE (8 DIGITS)
xxxiv. CONTEST DATE (8 DIGITS)
xxxv. REMINDER DATE (8 DIGITS)
xxxvi. CASE ORIGIN (8 CHARACTERS) xxxvii. CASE ANALYST (3 CHARACTERS) xxxviii. GSA BATCH (4 DIGITS)
xxxix. CORRESPONDENCE DATE (8 DIGITS)
xl. CORRESPONDENCE CODE (2 CHARACTERS) xli. MEMO (600 CHARACTERS)
b. FEHB Carriers
i. PLAN RECEIVED Y/N TOGGLE BOX/DROP DOWN
ii. LAST NAME (25 CHARACTERS)
iii. MIDDLE NAME (25 CHARACTERS)
iv. FIRST NAME (25 CHARACTERS)
v. TITLE (15 CHARACTERS)
vi. COMPANY (35 CHARACTERS, ALPHA & NUMBERIC)
vii. PLAN CONTRACT NUMBER (5 CHARACTERS, ALPHA & NUMBERIC)
viii. PLAN CODE (50 CHARACTERS, ALPHA & NUMBERIC)
ix. STREET ADDRESS (50 CHARACTERS, ALPHA & NUMBERIC)
x. CITY (20 CHARACTERS)
xi. ZIP (9 DIGITS)
xii. TELEPHONE (10 DIGITS)
xiii. EMAIL (30 CHARACTERS, ALPHA & NUMERIC)
xiv. PLAN JOIN DATE (8 DIGITS)
xv. PLAN DROPPED DATE (8 DIGITS)
xvi. MEMO (600 CHARACTERS)
xvii. OPM CONTRACT SPECIALIST (50 CHARACTERS)
xviii. REPORT RECEIVED Y/N TOGGLE CHECK BOX/DROP DOWN
xix. REPORT RECEIPT DATE (8 DIGITS)
xx. NUMBER OF PROVIDERS IDENTIFIED (4 DIGITS)
xxi. NUMBER OF PROACTIVE NOTIFIES (4 DIGITS)
xxii. NUMBER OF REACTIVE NOITCES (4 DIGITS)
xxiii. NOTICES TO PROVIDERS (4 DIGITS)
xxiv. CLAIMS DENIED (4 DIGITS)
xxv. CLAIMS PAID (4 DIGITS)
xxvi. CASE REFERRALS (4 DIGITS)
xxvii. BC NOTICES (4 DIGITS) xxviii. ENROLLEE EXCEPTIONS REQUESTS (4 DIGITS)
xxix. OWNERSHIP NOTIFICATIONS (4 DIGITS)
xxx. INPATIENT SERVICES NOTIFICATIONS (4 DIGITS)
File details come from the government source that posted it. Updated .