Job_Accommodation_Network_Technical_Exhibit_1.pdf

TECHNICAL EXHIBIT 1: System Technical Components for Website

Website

A. 12,252 files; 41Gb

B. 1,506 static pages; 2.7 million non-static pages

C. 10.5 Million page views per year; 1.4 Million unique visitors per year

D. Internet connection speed of multiple 10 gigabit links

E. Searchable Online Accommodation Resource (SOAR) providing customized accommodation search capabilities using product and vendor data tables.

F. Materials available in Spanish

G. Features

1. Blog

2. Chat

The Government provides this information to inform Offerors of the available content management software.

All content updates are to be performed by the Offeror. Such updates do not include new pages or web refreshes. Design of website refreshes, including concept, content, wireframe, art, etc. is the responsibility of the Offeror.

The Technical Contractor is responsible for establishing and maintaining the security of the systems and will advise the Communications Contractor of appropriate processes. The Technical Contractor expects the Communications Contractor to use prudence and common sense when connecting to any of the systems through the Internet. ODEP will advise the Communications Contractor of the limits regarding Personal Information that may be used.

H.2 Current JAN Specifications

West Virginia University currently operates the Job Accommodation Network, which entails the following activities, as per ODEP requirements:

Individualized Technical Assistance

Website

Documents and Materials

Expert-Level Training

Communication and Outreach

Collaborative Relationships

Document Costs/Benefits of Job Accommodations

Performance Measures/Policy Data Reporting Further details for each of these activities is provided.

H.2.1 Individualized Technical Assistance

A. Telephone System

1. Toll-free telephone number: 800-526-7234;

2. Toll-free TTY Number: 877-781-9403

3. Text support (SMS)

4. 11 phone lines

5. Digital voice-mail system

6. Customer-selected automated call attendant routing system

7. Email integration of voice mail

8. Computer interface for call logs

9. VOIP capability

10. System redundancy

B. On-line Chat

C. Email

D. Computer-Based Case Management System NOTE: specific field information attached

1. 163 Tables; 11.7Gb

2. Case records

i. Client contact information [634,763 records as of 12-31- 2016]

ii. TA request-specific data tables (Many-to-One [M-2-1], relational)

a. Causative factors [550,396 records, M-2-1,]

b. Limitations [589,902 records, M-2-1]

c. Issues [1,205,624 records, M-2-1]

d. Job functions [540,745 records, M-2-1]

e. NAISC codes [276,317 records]

f. Occupational categories [124,482 records]

g. Case notes [779,953 records]

h. Products tables [28,024 records]

i. Cases_products

ii. Products_causative_factors

iii. Products_issues_concerns

iv. Products_job_functions

v. Products_limitations

vi. Products_NAISC_codes

vii. Products_occupational_cats

viii. Products_organizations

ix. Products_solutions

x. Products

xi. Products_images

i. Organizations

i. Callers_organizations

ii. Cases_organizations

iii. Orgs_orgs_categories

iv. Organizations

v. Orgs_addresses

vi. Orgs_email_addresses

vii. Orgs_phone_numbers

viii. Org_category

ix. Org_type

x. Orgs_address_types

xi. Orgs_email_types

xii. Orgs_phone_types

j. Solutions

i. Solutions_causative_factors

ii. Solutions_issues_concerns

iii. Solutions_job_functions

iv. Solutions_limitations

v. Solutions_NAISC_codes

vi. Solutions_occupational_cats

vii. Solutions_organizations

k. Code files for each of the above Example: Causative Factors

[359 identified factors]

iii. Other tables [Note: This list is not exhaustive]

a. Events

i. Int_events_event_types

ii. Int_event_logistics_users

iii. Int_events_cases

iv. Int_events_media

v. Int_events_publications

b. Permissions

i. Int_permissions_role_areas

ii. Int_permissions_roles

c. Lookup

i. Lkup_address_types

ii. Lkup_aud_scope

iii. Lkup_business_sizes

iv. Lkup_call_statuses

v. Lkup_caller_descriptions

vi. Lkup_caller_descriptions_group

vii. Lkup_career_status_types

viii. Lkup_case_statuses

ix. Lkup_case_types

x. Lkup_case_view_types

xi. Lkup_collaborative

xii. Lkup_contact_level

xiii. Lkup_contact_methods

xiv. Lkup_contact_methods_group

xv. Lkup_count_type

xvi. Lkup_countries

xvii. Lkup_email_types

xviii. Lkup_event_link_type

xix. Lkup_event_location_type

xx. Lkup_event_status

xxi. Lkup_event_training

xxii. Lkup)event_type

xxiii. Lkup_follow_up_lengths

xxiv. Lkup_issue_domains

xxv. Lkup_language

xxvi. Lkup_link_types

xxvii. Lkup_market_source xxviii. Lkup_media_categories

xxix. Lkup_media_formats

xxx. Lkup_media_languages

xxxi. Lkup_months

xxxii. Lkup_options xxxiii. Lkup_org_category

xxxiv. Lkup_org_type

xxxv. Lkup_orgs_address_types

xxxvi. Lkup_orgs_email_types xxxvii. Lkup_orgs_phone_types xxxviii. Lkup_permissions

xxxix. Lkup_person_types

xl. Xl kup_poc_type xli. xli. Lkup_prefix xlii. xlii. Lkup_role_areas xliii. xliii. Lkup_roles xliv. xliv. Lkup_sass_participation_types xlv. xlv. Lkup_sass_survey_type xlvi. xlvi. Lkup_states xlvii. xlvii. Lkup_subscriptions xlviii. xlviii. Lkup_suffix xlix. xlix. Lkup_template_types

l. l. Lkup_time_zones

li. li. Lkup_vet_mils

3. Supports Website

4. Examples:

i. Case 1—Contacted by employer with 8 previous cases for situation involving a person with a traumatic brain injury. Involves 1 causative factor (traumatic brain injury), 5 limitations (memory loss, concentration, vision impairment, fatigue, emotion control), 11 issues

(e.g., absences, limited scheduling, essential functions, production standard), NAICS code of 221210 Utilities—Natural Gas

Distribution, Standard Occupational Classification System code of

17-2071 Electrical Engineer.

ii. Case 2—Contacted by a rehabilitation counselor for the first time regarding an individual with MS. Discussed 7 limitations (overall fatigue, walking, reading, grasping, carrying, typing, holding), 3 issues (accommodations, medical documentation, and undue hardship), NAICS code of 53111 Lessors of Residential Buildings and Dwellings, Standard Occupational Classification System code of

43-3010 Bill and Account Collectors

5. The JEMS software is owned by West Virginia University and is non-transferrable. It is important to note the above data tables were developed specifically for use in this software system and may not be relevant to other operational models.

H.2.2 Website

A. 12,252 files; 41Gb

B. 1,506 static pages; 2.7 million non-static pages

C. 10.5 Million page views per year; 1.4 Million unique visitors per year

D. Internet connection speed of multiple 10 gigabit links

E. Searchable Online Accommodation Resource (SOAR) providing customized accommodation search capabilities using product and vendor data tables.

F. Materials available in Spanish

G. Features

H. Blog

I. Chat

H.2.3 Documents and Materials

A. Over 300 electronic documents available via the Website and in print.

B. Published in multiple formats to accommodate accessibility.

H.2.4 Website Files

FileName

Variable

Type

Length

(Char)

Not Null

Definition

INT CALLER CALL STATUSES ICCS8 BIT X STATUS

INT CALLER EVENTS ICE3 BIT X SURVEY

INT CALLER EVENTS ICE8 BIT STATUS

INT CALLER ORGANIZATIONS ICO4 BIT STATUS

INT CALLER ORGANIZATIONS ICO5 BIT STATUS2

INT CALLERS PERSON TYPES ICPT8 BIT STATUS

INT CALLERS SUBSCRIPTIONS ICS7 BIT STATUS

INT CASES CAUSATIVE FACTORS ICCF7 BIT STATUS

INT CASES COLLABORATION ICC3 BIT ODEP

INT CASES COLLABORATION ICC11 BIT STATUS

INT CASES ISSUES CONCERNS ICIC7 BIT X STATUS

INT CASES JOB FUNCTIONS ICJF7 BIT STATUS

INT CASES LIMITATIONS ICL7 BIT STATUS

INT CASES MEDIA ICM9 BIT X STATUS

INT CASES NAISC CODES ICNC7 BIT STATUS

INT CASES OCCUPATIONAL CATS ICCC7 BIT STATUS

INT CASES ORGANIZATIONS ICOA7 BIT STATUS

INT CASES PRODUCTS ICP7 BIT X STATUS

INT CASES PUBLICATIONS ICPA8 BIT X STATUS

INT CASES SOLUTIONS ICSA7 BIT X STATUS

INT EVENT EVENT TYPES IEET7 BIT STATUS

INT EVENT LOGISTICS USERS IELU7 BIT ACTIVE

INT EVENTS CASES IEC9 BIT X STATUS

INT EVENTS MEDIA IEM9 BIT X STATUS

INT EVENTS PUBLICATIONS IEP8 BIT X STATUS

INT LINKED CASES ILC9 BIT X STATUS

INT ORGS CAUSATIVE FACTORS IOCF7 BIT X STATUS

INT ORGS ISSUES CONCERNS IOIC3 BIT X STATUS

INT ORGS LIMITATIONS IOL3 BIT X STATUS

INT ORGS NAISC CODES IONC3 BIT X STATUS

INT ORGS OCCUPATIONAL CATS IOOC3 BIT X STATUS

INT ORGS ORG CATEGORIES IOOCA7 BIT STATUS

INT PRODUCTS CAUSATIVE FACTORS ICPF3 BIT X STATUS

INT PRODUCTS ISSUES CONCERNS IPIC3 BIT X STATUS

INT PRODUCTS JOB FUNCTIONS IPJF3 BIT X STATUS

INT PRODUCTS LIMITATIONS IPL3 BIT X STATUS

INT PRODUCTS NAISC CODES IPNC3 BIT X STATUS

INT PRODUCTS OCCUPATIONAL CATS IPOC3 BIT X STATUS

INT PRODUCTS ORGANIZATIONS IPO3 BIT X STATUS

INT PRODUCTS SOLUTIONS IPS3 BIT X STATUS

INT PUBLICATION MEDIA CATEGORIES IPMC8 BIT X STATUS

INT PUBLCATION MEDIA FORMAT LAN IPMFL9 BIT STATUS

INT SOLUTIONS CAUSATIVE FACTORS ISCF3 BIT X STATUS

INT SOLUTIONS ISSUES CONCERNS ISIC3 BIT X STAT

INT SOLUTIONS JOB FUNCTIONS ISJF3 BIT X STAT

INT SOLUTIONS LIMITATIONS ISL3 BIT X STAT

INT SOLUTIONS NAISC CODES ISNC3 BIT X STAT

INT SOLUTIONS OCCUPATIONAL CATS ISOC3 BIT X STAT

INT SOLUTIONS ORGANIZATIONS ISO3 BIT X STAT

IssuesConcerns4 IC23 BIT TEMP

IssuesConcerns5 IC24 BIT TEMP

IssuesConcerns6 IC25 BIT TEMP

IssuesConcerns7 IC26 BIT TEMP

IssuesConcerns8 IC27 BIT TEMP

IssuesConcerns9 IC28 BIT TEMP

IssuesConcerns10 IC29 BIT TEMP

JEMS ADDRESSES MAIN BIT X MAIN

JEMS ADDRESSES STATUS BIT X STATUS

JEMS ANNOUNCEMENTS JA7 BIT X STATUS

JEMS CALLER NOTES STATUS BIT X STATUS

JEMS CALLERS UNKNOWN BIT UNKNOWN

JEMS CALLERS ANONYMOUS BIT ANONYMOUS

JEMS CALLERS STATUS BIT X STATUS

JEMS CALLERS MERGED BIT X MERGED

JEMS CALLS ACTIVE BIT X ACTIVE

JEMS CASE EMAILS SENT BIT SENT

JEMS CASE EMAILS ATTACHMENT BIT ATTACHMENT

JEMS CASE EMAILS BCC BIT BCC

JEMS CASE EMAILS STATUS BIT STATUS

JEMS CASE EMAILS SUCCESS BIT X SUCCESS

JEMS CASE NOTES THANKYOU BIT THANKYOU

JEMS CASE NOTES EMAILREPLY BIT EMAILREPLY

JEMS CASE NOTES ISSTORY BIT ISSTORY

JEMS CASE NOTES STATUS BIT X STATUS

JEMS CASES REMINDER EMAIL BIT REMINDER EMAIL

JEMS CASES REMINDER QUEUE BIT REMINDER QUEUE

JEMS CASES FOL ASKED BIT FOL ASKED

JEMS CASES FOL PARTICIPATE BIT FOL PARTICIPATE

JEMS CASES RELEASE BIT RELEASE

JEMS CASES STATUS BIT STATUS

JEMS CAUSATIVE FACTORS JCS9 BIT STATUS

JEMS EMAIL ADDRESSES JEA3 BIT X STATUS

JEMS EMAIL ADDRESSES JEA11 BIT X STATUS

JEMS EMAIL ATTACHMENTS JEAA9 BIT STATUS

JEMS EMAIL TEMPLATES JET12 BIT STATUS

JEMS EVENT ATTENDANCE JEA12 BIT X STATUS

JEMS EVENT EMAILS JEE10 BIT SENT

JEMS EVENT EMAILS JEE11 BIT ATTACHMENT

JEMS EVENT EMAILS JEE13 BIT SEND TO

JEMS EVENT EMAILS JEE19 BIT STATUS

JEMS EVENT EMAILS JEE20 BIT X STATUS2

INT CALLER CALL STATUSES ICCS4 DATETIME X DATE

INT CALLER CALL STATUSES ICCS6 DATETIME X UPDATED

INT CALLER EVENTS ICE4 DATETIME X CREATED

INT CALLER EVENTS ICE6 DATETIME X UPDATED

INT CALLER ORGANIZATIONS ICO6 DATETIME CREATED

INT CALLER ORGANIZATIONS ICO8 DATETIME UPDATED

INT CALLERS PERSON TYPES ICPT4 DATETIME X CREATED

INT CALLERS PERSON TYPES ICPT6 DATETIME X UPDATED

INT CALLERS SUBSCRIPTIONS ICS3 DATETIME X CREATED

INT CALLERS SUBSCRIPTIONS ICS5 DATETIME X UPDATED

INT CASES CAUSATIVE FACTORS ICCF3 DATETIME X CREATED

INT CASES CAUSATIVE FACTORS ICCF5 DATETIME X UPDATED

INT CASES COLLABORATION ICC7 DATETIME X CREATED

INT CASES COLLABORATION ICC9 DATETIME X UPDATED

INT CASES ISSUES CONCERNS ICIC3 DATETIME X CREATED

INT CASES ISSUES CONCERNS ICIC5 DATETIME X UPDATED

INT CASES JOB FUNCTIONS ICJF3 DATETIME X CREATED

INT CASES JOB FUNCTIONS ICJF5 DATETIME X UPDATED

INT CASES LIMITATIONS ICL3 DATETIME X CREATED

INT CASES LIMITATIONS ICL5 DATETIME X UPDATED

INT CASES MEDIA ICM5 DATETIME X CREATED

INT CASES MEDIA ICM7 DATETIME X UPDATED

INT CASES NAISC CODES ICNC3 DATETIME X CREATED

INT CASES NAISC CODES ICNC5 DATETIME X UPDATED

INT CASES OCCUPATIONAL CATS ICCC3 DATETIME X CREATED

INT CASES OCCUPATIONAL CATS ICCC5 DATETIME X UPDATED

INT CASES ORGANIZATIONS ICOA3 DATETIME X CREATED

INT CASES ORGANIZATIONS ICOA5 DATETIME X UPDATED

INT CASES PRODUCTS ICP3 DATETIME X CREATED

INT CASES PRODUCTS ICP5 DATETIME X UPDATED

INT CASES PUBLICATIONS ICPA4 DATETIME X CREATED

INT CASES PUBLICATIONS ICPA6 DATETIME X UPDATED

INT CASES SOLUTIONS ICSA3 DATETIME X CREATED

INT CASES SOLUTIONS ICSA5 DATETIME X UPDATED

INT EVENT EVENT TYPES IEET3 DATETIME CREATED

INT EVENT EVENT TYPES IEET5 DATETIME UPDATED

INT EVENT LOGISTICS USERS IELU3 DATETIME CREATED

INT EVENT LOGISTICS USERS IELU5 DATETIME UPDATED

INT EVENTS CASES IEC5 DATETIME X CREATED

INT EVENTS CASES IEC7 DATETIME X UPDATED

INT EVENTS MEDIA IEM5 DATETIME X CREATED

INT EVENTS MEDIA IEM7 DATETIME X UPDATED

INT EVENTS PUBLICATIONS IEP4 DATETIME X CREATED

INT EVENTS PUBLICATIONS IEP6 DATETIME X UPDATED

INT LINKED CASES ILC5 DATETIME X CREATED

INT LINKED CASES ILC7 DATETIME X UPDATED

INT ORGS CAUSATIVE FACTORS IOCF3 DATETIME X CREATED

INT ORGS CAUSATIVE FACTORS IOCF5 DATETIME X UPDATED

INT ORGS ISSUES CONCERNS IOIC4 DATETIME X CREATED

INT ORGS ISSUES CONCERNS IOIC6 DATETIME X UPDATED

INT ORGS JOB FUNCTIONS IOJF4 DATETIME X CREATED

INT ORGS JOB FUNCTIONS IOJF6 DATETIME X UPDATED

INT ORGS LIMITATIONS IOL4 DATETIME X CREATED

INT ORGS LIMITATIONS IOL6 DATETIME X UPDATED

INT ORGS NAISC CODES IONC4 DATETIME X CREATED

INT ORGS NAISC CODES IONC6 DATETIME X UPDATED

INT ORGS OCCUPATIONAL CATS IOOC4 DATETIME X CREATED

INT ORGS OCCUPATIONAL CATS IOOC6 DATETIME X UPDATED

INT ORGS ORG CATEGORIES IOOCA3 DATETIME CREATED

INT ORGS ORG CATEGORIES IOOCA5 DATETIME UPDATED

INT PRODUCTS CAUSATIVE FACTORS ICPF4 DATETIME X CREATED

INT PRODUCTS CAUSATIVE FACTORS ICPF6 DATETIME X UPDATED

INT PRODUCTS ISSUES CONCERNS IPIC4 DATETIME X CREATED

INT PRODUCTS ISSUES CONCERNS IPIC6 DATETIME X UPDATED

INT PRODUCTS JOB FUNCTIONS IPJF4 DATETIME X CREATED

INT PRODUCTS JOB FUNCTIONS IPJF6 DATETIME X UPDATED

INT PRODUCTS LIMITATIONS IPL4 DATETIME X CREATED

INT PRODUCTS LIMITATIONS IPL6 DATETIME X UPDATED

INT PRODUCTS NAISC CODES IPNC4 DATETIME X CREATED

INT PRODUCTS NAISC CODES IPNC6 DATETIME X UPDATED

INT PRODUCTS OCCUPATIONAL CATS IPOC4 DATETIME X CREATED

INT PRODUCTS OCCUPATIONAL CATS IPOC6 DATETIME X UPDATED

INT PRODUCTS ORGANIZATIONS IPO4 DATETIME X CREATED

INT PRODUCTS ORGANIZATIONS IPO6 DATETIME X UPDATED

INT PRODUCTS SOLUTIONS IPS4 DATETIME X CREATED

INT PRODUCTS SOLUTIONS IPS6 DATETIME X UPDATED

INT PUBLICATION MEDIA CATEGORIES IPMC4 DATETIME CREATED

INT PUBLICATION MEDIA CATEGORIES IPMC6 DATETIME UPDATED

INT PUBLCATION MEDIA FORMAT LAN IPMFL5 DATETIME CREATED

INT PUBLCATION MEDIA FORMAT LAN IPMFL7 DATETIME UPDATED

INT SOLUTIONS CAUSATIVE FACTORS ISCF4 DATETIME X CREATED

INT SOLUTIONS CAUSATIVE FACTORS ISCF6 DATETIME X UPDATED

INT SOLUTIONS ISSUES CONCERNS ISIC4 DATETIME X CREATED

INT SOLUTIONS ISSUES CONCERNS ISIC6 DATETIME X UPDATED

INT SOLUTIONS JOB FUNCTIONS ISJF4 DATETIME X CREATED

INT SOLUTIONS JOB FUNCTIONS ISJF6 DATETIME X UPDATED

INT SOLUTIONS LIMITATIONS ISL4 DATETIME X CREATED

INT SOLUTIONS LIMITATIONS ISL6 DATETIME X UPDATED

INT SOLUTIONS NAISC CODES ISNC4 DATETIME X CREATED

INT SOLUTIONS NAISC CODES ISNC6 DATETIME X UPDATED

INT SOLUTIONS OCCUPATIONAL CATS ISOC4 DATETIME X CREATED

INT SOLUTIONS OCCUPATIONAL CATS ISOC6 DATETIME X UPDATED

INT SOLUTIONS ORGANIZATIONS ISO4 DATETIME X CREATED

INT SOLUTIONS ORGANIZATIONS ISO6 DATETIME X UPDATED

JEMS ADDRESSES CREATED DATETIME X CREATED

JEMS ADDRESSES UPDATED DATETIME X UPDATED

JEMS ANNOUNCEMENTS JA3 DATETIME CREATED

JEMS CALLER NOTES CREATED DATETIME X CREATED

JEMS CALLER NOTES UPDATED DATETIME X UPDATED

JEMS CALLERS CREATED DATETIME X CREATED

JEMS CALLERS UPDATED DATETIME X UPDATED

JEMS CALLS CREATED DATETIME X CREATED

JEMS CALLS UPDATED DATETIME UPDATED

JEMS CASE EMAILS SENT DATETIME SENT

JEMS CASE EMAILS CREATED DATETIME X CREATED

JEMS CASE EMAILS UPDATED DATETIME X UPDATED

JEMS CASE NOTES CREATED DATETIME X CREATED

JEMS CASE NOTES UPDATED DATETIME X UPDATED

JEMS CASES FOL Q DATE DATETIME FOL Q DATE

JEMS CASES

DATE DOCUMENTATION COMPLETE

DATETIME

DATE DOCUMENTATION

COMPLETE

JEMS CASES DATE COMPLETE DATETIME DATE COMPLETE

JEMS CASES CREATED DATETIME X CREATED

JEMS CASES UPDATED DATETIME X UPDATED

JEMS CAUSATIVE FACTORS JCS5 DATETIME X CREATED

JEMS CAUSATIVE FACTORS JCS7 DATETIME X UPDATED

JEMS EMAIL ADDRESSES JEA7 DATETIME X CREATED

JEMS EMAIL ADDRESSES JEA9 DATETIME X UPDATED

JEMS EMAIL ATTACHMENTS JEAA5 DATETIME CREATED

JEMS EMAIL ATTACHMENTS JEAA7 DATETIME UPDATED

JEMS EMAIL TEMPLATES JET8 DATETIME X CREATED

JEMS EMAIL TEMPLATES JET10 DATETIME X UPDATED

JEMS EVENT ATTENDANCE JEA8 DATETIME X CREATED

JEMS EVENT ATTENDANCE JEA10 DATETIME X UDATED

JEMS EVENT EMAILS JEE12 DATETIME X SENT

JEMS EVENT EMAILS JEE15 DATETIME X CREATED

JEMS EVENT EMAILS JEE17 DATETIME X UPDATED

INT ORGS JOB FUNCTIONS IOJF3 IBIT X STATUS

INT CALLER CALL STATUSES ICCS1 INT X ID

INT CALLER CALL STATUSES ICCS2 INT STATUS

INT CALLER CALL STATUSES ICCS5 INT CREATED

INT CALLER CALL STATUSES ICCS7 INT BY

INT CALLER CALL STATUSES ICCS10 INT ID2

INT CALLER EVENTS ICE1 INT X ID

INT CALLER EVENTS ICE2 INT X ID2

INT CALLER EVENTS ICE5 INT BY1

INT CALLER EVENTS ICE7 INT BY2

INT CALLER ORGANIZATIONS ICO1 INT X ID

INT CALLER ORGANIZATIONS ICO2 INT X ID2

INT CALLER ORGANIZATIONS ICO3 INT ID3

INT CALLER ORGANIZATIONS ICO7 INT BY1

INT CALLER ORGANIZATIONS ICO9 INT BY2

INT CALLERS PERSON TYPES ICPT1 INT X ID

INT CALLERS PERSON TYPES ICPT2 INT X TYPE

INT CALLERS PERSON TYPES ICPT5 INT BY1

INT CALLERS PERSON TYPES ICPT7 INT BY2

INT CALLERS SUBSCRIPTIONS ICS1 INT X ID1

INT CALLERS SUBSCRIPTIONS ICS2 INT X ID2

INT CALLERS SUBSCRIPTIONS ICS4 INT BY1

INT CALLERS SUBSCRIPTIONS ICS6 INT BY2

INT CASES CAUSATIVE FACTORS ICCF1 INT X ID1

INT CASES CAUSATIVE FACTORS ICCF2 INT X ID2

INT CASES CAUSATIVE FACTORS ICCF4 INT BY1

INT CASES CAUSATIVE FACTORS ICCF6 INT BY2

INT CASES CAUSATIVE FACTORS ICCF8 INT ID3

INT CASES COLLABORATION ICC1 INT X ID

INT CASES COLLABORATION ICC2 INT ID2

INT CASES COLLABORATION ICC4 INT ID3

INT CASES COLLABORATION ICC8 INT BY1

INT CASES COLLABORATION ICC10 INT BY2

INT CASES ISSUES CONCERNS ICIC1 INT X ID1

INT CASES ISSUES CONCERNS ICIC2 INT ID2

INT CASES ISSUES CONCERNS ICIC4 INT BY1

INT CASES ISSUES CONCERNS ICIC6 INT BY2

INT CASES ISSUES CONCERNS ICIC8 INT ID3

INT CASES JOB FUNCTIONS ICJF1 INT X ID1

INT CASES JOB FUNCTIONS ICJF2 INT X ID2

INT CASES JOB FUNCTIONS ICJF4 INT BY1

INT CASES JOB FUNCTIONS ICJF6 INT BY2

INT CASES JOB FUNCTIONS ICJF8 INT X ID3

INT CASES LIMITATIONS ICL1 INT X ID1

INT CASES LIMITATIONS ICL2 INT X ID2

INT CASES LIMITATIONS ICL4 INT BY1

INT CASES LIMITATIONS ICL6 INT BY2

INT CASES LIMITATIONS ICL8 INT X ID3

INT CASES MEDIA ICM1 INT X ID1

INT CASES MEDIA ICM2 INT X ID2

INT CASES MEDIA ICM3 INT X ID3

INT CASES MEDIA ICM4 INT QUANTITY

INT CASES MEDIA ICM6 INT BY1

INT CASES MEDIA ICM8 INT BY2

INT CASES NAISC CODES ICNC1 INT X ID1

INT CASES NAISC CODES ICNC2 INT X ID2

INT CASES NAISC CODES ICNC4 INT BY1

INT CASES NAISC CODES ICNC6 INT BY2

INT CASES NAISC CODES ICNC8 INT X ID3

INT CASES OCCUPATIONAL CATS ICCC1 INT X ID1

INT CASES OCCUPATIONAL CATS ICCC2 INT X ID2

INT CASES OCCUPATIONAL CATS ICCC4 INT BY1

INT CASES OCCUPATIONAL CATS ICCC6 INT BY2

INT CASES OCCUPATIONAL CATS ICCC8 INT X ID3

INT CASES ORGANIZATIONS ICOA1 INT X ID1

INT CASES ORGANIZATIONS ICOA2 INT ID2

INT CASES ORGANIZATIONS ICOA4 INT BY1

INT CASES ORGANIZATIONS ICOA6 INT BY2

INT CASES PRODUCTS ICP1 INT X ID1

INT CASES PRODUCTS ICP2 INT X ID2

INT CASES PRODUCTS ICP4 INT BY1

INT CASES PRODUCTS ICP6 INT BY2

INT CASES PUBLICATIONS ICPA1 INT X ID1

INT CASES PUBLICATIONS ICPA2 INT X ID2

INT CASES PUBLICATIONS ICPA3 INT QUANTITY

INT CASES PUBLICATIONS ICPA5 INT BY1

INT CASES PUBLICATIONS ICPA7 INT BY2

INT CASES SOLUTIONS ICSA1 INT X ID

INT CASES SOLUTIONS ICSA2 INT X ID2

INT CASES SOLUTIONS ICSA4 INT BY1

INT CASES SOLUTIONS ICSA6 INT BY2

INT EVENT EVENT TYPES IEET1 INT X ID1

INT EVENT EVENT TYPES IEET2 INT X ID2

INT EVENT EVENT TYPES IEET4 INT BY1

INT EVENT EVENT TYPES IEET6 INT BY2

INT EVENT LOGISTICS USERS IELU1 INT X ID1

INT EVENT LOGISTICS USERS IELU2 INT X ID2

INT EVENT LOGISTICS USERS IELU4 INT BY1

INT EVENT LOGISTICS USERS IELU6 INT BY2

INT EVENTS CASES IEC1 INT X ID1

INT EVENTS CASES IEC2 INT X ID2

INT EVENTS CASES IEC3 INT ID3

INT EVENTS CASES IEC6 INT BY1

INT EVENTS CASES IEC8 INT BY2

INT EVENTS MEDIA IEM1 INT X ID1

INT EVENTS MEDIA IEM2 INT X ID2

INT EVENTS MEDIA IEM3 INT X ID3

INT EVENTS MEDIA IEM4 INT QUANTITY

INT EVENTS MEDIA IEM6 INT BY1

INT EVENTS MEDIA IEM8 INT BY2

INT EVENTS PUBLICATIONS IEP1 INT X ID1

INT EVENTS PUBLICATIONS IEP2 INT X ID2

INT EVENTS PUBLICATIONS IEP3 INT QUANTITY

INT EVENTS PUBLICATIONS IEP5 INT BY1

INT EVENTS PUBLICATIONS IEP7 INT BY2

INT LINKED CASES ILC1 INT X ID1

INT LINKED CASES ILC2 INT X ID2

INT LINKED CASES ILC3 INT X ID3

INT LINKED CASES ILC6 INT BY1

INT LINKED CASES ILC8 INT X BY2

INT ORGS CAUSATIVE FACTORS IOCF1 INT X ID1

INT ORGS CAUSATIVE FACTORS IOCF2 INT X ID2

INT ORGS CAUSATIVE FACTORS IOCF4 INT BY1

INT ORGS CAUSATIVE FACTORS IOCF6 INT BY2

INT ORGS ISSUES CONCERNS IOIC1 INT X ID1

INT ORGS ISSUES CONCERNS IOIC2 INT X ID2

INT ORGS ISSUES CONCERNS IOIC5 INT BY1

INT ORGS ISSUES CONCERNS IOIC7 INT BY2

INT ORGS JOB FUNCTIONS IOJF1 INT X ID1

INT ORGS JOB FUNCTIONS IOJF2 INT X ID2

INT ORGS JOB FUNCTIONS IOJF5 INT BY1

INT ORGS JOB FUNCTIONS IOJF7 INT BY2

INT ORGS LIMITATIONS IOL1 INT X ID1

INT ORGS LIMITATIONS IOL2 INT X ID2

INT ORGS LIMITATIONS IOL5 INT BY1

INT ORGS LIMITATIONS IOL7 INT BY2

INT ORGS NAISC CODES IONC1 INT X ID1

INT ORGS NAISC CODES IONC2 INT X ID2

INT ORGS NAISC CODES IONC5 INT BY1

INT ORGS NAISC CODES IONC7 INT BY2

INT ORGS OCCUPATIONAL CATS IOOC1 INT X ID1

INT ORGS OCCUPATIONAL CATS IOOC2 INT X ID2

INT ORGS OCCUPATIONAL CATS IOOC5 INT BY1

INT ORGS OCCUPATIONAL CATS IOOC7 INT BY2

INT ORGS ORG CATEGORIES IOOCA1 INT X ID1

INT ORGS ORG CATEGORIES IOOCA2 INT X ID2

INT ORGS ORG CATEGORIES IOOCA4 INT BY1

INT ORGS ORG CATEGORIES IOOCA6 INT BY2

INT PERMISSIONS ROLE AREAS IPRA1 INT X ID1

INT PERMISSIONS ROLE AREAS IPRA2 INT X ID2

INT PERMISSIONS ROLE AREAS IPRA3 INT X ID3

INT PERMISSIONS ROLES IPR1 INT ID1

INT PERMISSIONS ROLES IPR2 INT ID2

INT PRODUCTS CAUSATIVE FACTORS IPCF1 INT X ID1

INT PRODUCTS CAUSATIVE FACTORS ICPF2 INT X ID2

INT PRODUCTS CAUSATIVE FACTORS ICPF5 INT BY1

INT PRODUCTS CAUSATIVE FACTORS ICPF7 INT BY2

INT PRODUCTS ISSUES CONCERNS IPIC1 INT X ID1

INT PRODUCTS ISSUES CONCERNS IPIC2 INT X ID2

INT PRODUCTS ISSUES CONCERNS IPIC5 INT BY1

INT PRODUCTS ISSUES CONCERNS IPIC7 INT BY2

INT PRODUCTS JOB FUNCTIONS IPJF1 INT X ID1

INT PRODUCTS JOB FUNCTIONS IPJF2 INT X ID2

INT PRODUCTS JOB FUNCTIONS IPJF5 INT BY1

INT PRODUCTS JOB FUNCTIONS IPJF7 INT BY2

INT PRODUCTS LIMITATIONS IPL1 INT X ID1

INT PRODUCTS LIMITATIONS IPL2 INT X ID2

INT PRODUCTS LIMITATIONS IPL5 INT BY1

INT PRODUCTS LIMITATIONS IPL7 INT BY2

INT PRODUCTS NAISC CODES IPNC1 INT X ID1

INT PRODUCTS NAISC CODES IPNC2 INT X ID2

INT PRODUCTS NAISC CODES IPNC5 INT BY1

INT PRODUCTS NAISC CODES IPNC7 INT BY2

INT PRODUCTS OCCUPATIONAL CATS IPOC1 INT X ID1

INT PRODUCTS OCCUPATIONAL CATS IPOC2 INT X ID2

INT PRODUCTS OCCUPATIONAL CATS IPOC5 INT BY1

INT PRODUCTS OCCUPATIONAL CATS IPOC7 INT BY2

INT PRODUCTS ORGANIZATIONS IPO1 INT X ID1

INT PRODUCTS ORGANIZATIONS IPO2 INT X ID2

INT PRODUCTS ORGANIZATIONS IPO5 INT BY1

INT PRODUCTS ORGANIZATIONS IPO7 INT BY2

INT PRODUCTS SOLUTIONS IPS1 INT X ID1

INT PRODUCTS SOLUTIONS IPS2 INT X ID2

INT PRODUCTS SOLUTIONS IPS5 INT BY1

INT PRODUCTS SOLUTIONS IPS7 INT BY2

INT PUBLICATION MEDIA CATEGORIES IPMC1 INT X ID1

INT PUBLICATION MEDIA CATEGORIES IPMC2 INT X ID2

INT PUBLICATION MEDIA CATEGORIES IPMC3 INT X ID3

INT PUBLICATION MEDIA CATEGORIES IPMC5 INT BY1

INT PUBLICATION MEDIA CATEGORIES IPMC7 INT BY2

INT PUBLCATION MEDIA FORMAT LAN IPMFL1 INT X ID1

INT PUBLCATION MEDIA FORMAT LAN IPMFL2 INT X ID2

INT PUBLCATION MEDIA FORMAT LAN IPMFL3 INT X ID3

INT PUBLCATION MEDIA FORMAT LAN IPMFL4 INT X ID4

INT PUBLCATION MEDIA FORMAT LAN IPMFL6 INT BY1

INT PUBLCATION MEDIA FORMAT LAN IPMFL8 INT BY2

INT PUBLCATION MEDIA FORMAT LAN IPMFL10 INT X STATUS2

INT SOLUTIONS CAUSATIVE FACTORS ISCF1 INT X ID

INT SOLUTIONS CAUSATIVE FACTORS ISCF2 INT X ID2

INT SOLUTIONS CAUSATIVE FACTORS ISCF5 INT BY1

INT SOLUTIONS CAUSATIVE FACTORS ISCF7 INT BY2

INT SOLUTIONS ISSUES CONCERNS ISIC1 INT X ID1

INT SOLUTIONS ISSUES CONCERNS ISIC2 INT X ID2

INT SOLUTIONS ISSUES CONCERNS ISIC5 INT BY1

INT SOLUTIONS ISSUES CONCERNS ISIC7 INT BY2

INT SOLUTIONS JOB FUNCTIONS ISJF1 INT X ID1

INT SOLUTIONS JOB FUNCTIONS ISJF2 INT X ID2

INT SOLUTIONS JOB FUNCTIONS ISJF5 INT BY1

INT SOLUTIONS JOB FUNCTIONS ISJF7 INT BY2

INT SOLUTIONS LIMITATIONS ISL1 INT X ID1

INT SOLUTIONS LIMITATIONS ISL2 INT X ID2

INT SOLUTIONS LIMITATIONS ISL5 INT BY1

INT SOLUTIONS LIMITATIONS ISL7 INT BY2

INT SOLUTIONS NAISC CODES ISNC1 INT X ID1

INT SOLUTIONS NAISC CODES ISNC2 INT X ID2

INT SOLUTIONS NAISC CODES ISNC5 INT BY1

INT SOLUTIONS NAISC CODES ISNC7 INT BY2

INT SOLUTIONS OCCUPATIONAL CATS ISOC1 INT X ID1

INT SOLUTIONS OCCUPATIONAL CATS ISOC2 INT X ID2

INT SOLUTIONS OCCUPATIONAL CATS ISOC5 INT BY1

INT SOLUTIONS OCCUPATIONAL CATS ISOC7 INT BY2

INT SOLUTIONS ORGANIZATIONS ISO1 INT X ID1

INT SOLUTIONS ORGANIZATIONS ISO2 INT X ID2

INT SOLUTIONS ORGANIZATIONS ISO5 INT BY1

INT SOLUTIONS ORGANIZATIONS ISO7 INT BY2

JEMS ADDRESSES ID INT ID

JEMS ADDRESSES ID2 INT ID2

JEMS ADDRESSES STATEID INT STATEID

JEMS ADDRESSES COUNTRY INT COUNTRY

JEMS ADDRESSES TYPEID INT TYPEID

JEMS ADDRESSES TIMEZONE INT TIMEZONE

JEMS ADDRESSES BY1 INT BY1

JEMS ADDRESSES BY2 INT BY2

JEMS ANNOUNCEMENTS JA1 INT X ID

JEMS ANNOUNCEMENTS JA4 INT BY1

JEMS ANNOUNCEMENTS JA6 INT BY2

JEMS CALLER NOTES ID INT X ID

JEMS CALLER NOTES ID2 INT ID2

JEMS CALLER NOTES BY1 INT BY1

JEMS CALLER NOTES BY2 INT BY2

JEMS CALLERS ID INT X ID

JEMS CALLERS LANGUAGE INT LANGUAGE

JEMS CALLERS SOURCEID INT SOURCEID

JEMS CALLERS TIMEZONE INT TIMEZONE

JEMS CALLERS PREFIXID INT PREFIXID

JEMS CALLERS SUFFIXID INT SUFFIXID

JEMS CALLERS BY1 INT BY1

JEMS CALLERS BY2 INT BY2

JEMS CALLS ID INT X ID

JEMS CALLS ID1 INT X ID1

JEMS CALLS ID2 INT X ID2

JEMS CALLS BY1 INT BY1

JEMS CALLS BY2 INT BY2

JEMS CALLS ID3 INT ID3

JEMS CASE EMAILS ID INT X ID

JEMS CASE EMAILS ID2 INT ID2

JEMS CASE EMAILS ID3 INT ID3

JEMS CASE EMAILS ID4 INT ID4

JEMS CASE EMAILS BY1 INT BY1

JEMS CASE EMAILS BY2 INT BY2

JEMS CASE NOTES ID INT X ID

JEMS CASE NOTES ID2 INT ID2

JEMS CASE NOTES BY1 INT BY1

JEMS CASE NOTES BY2 INT BY2

JEMS CASES ID INT X ID

JEMS CASES ID2 INT ID2

JEMS CASES ID3 INT ID3

JEMS CASES ID4 INT ID4

JEMS CASES ID5 INT ID5

JEMS CASES ID6 INT ID6

JEMS CASES ID7 INT ID7

JEMS CASES ID8 INT ID8

JEMS CASES ID9 INT ID9

JEMS CASES ID10 INT ID10

JEMS CASES ID11 INT ID11

JEMS CASES ID12 INT ID12

JEMS CASES ID13 INT ID13

JEMS CASES SENDMETHOD INT SENDMETHOD

JEMS CASES NOTES INT NOTES

JEMS CASES BY1 INT BY1

JEMS CASES BY2 INT BY2

JEMS CASES ID14 INT ID14

JEMS CASES ID15 INT ID15

JEMS CAUSATIVE FACTORS JCS1 INT X ID

JEMS CAUSATIVE FACTORS JCS3 INT ID2

JEMS CAUSATIVE FACTORS JCS6 INT BY1

JEMS CAUSATIVE FACTORS JCS8 INT BY2

JEMS CAUSATIVE FACTORS JCS10 INT SORT

JEMS EMAIL ADDRESSES JEA1 INT X ID

JEMS EMAIL ADDRESSES JEA4 INT ID2

JEMS EMAIL ADDRESSES JEA6 INT ID3

JEMS EMAIL ADDRESSES JEA8 INT BY1

JEMS EMAIL ADDRESSES JEA10 INT BY2

JEMS EMAIL ATTACHMENTS JEAA1 INT X ID

JEMS EMAIL ATTACHMENTS JEAA2 INT ID2

JEMS EMAIL ATTACHMENTS JEAA3 INT ID3

JEMS EMAIL ATTACHMENTS JEAA6 INT BY1

JEMS EMAIL ATTACHMENTS JEAA8 INT BY2

JEMS EMAIL TEMPLATES JET1 INT X ID

JEMS EMAIL TEMPLATES JET5 INT ID2

JEMS EMAIL TEMPLATES JET9 INT BY1

JEMS EMAIL TEMPLATES JET11 INT BY2

JEMS EVENT ATTENDANCE JEA1 INT X ID

JEMS EVENT ATTENDANCE JEA2 INT ID2

JEMS EVENT ATTENDANCE JEA3 INT ATTENDANCE1

JEMS EVENT ATTENDANCE JEA4 INT ATTENDANCE2

JEMS EVENT ATTENDANCE JEA9 INT BY1

JEMS EVENT ATTENDANCE JEA11 INT BY2

JEMS EVENT EMAILS JEE1 INT X ID

JEMS EVENT EMAILS JEE2 INT ID2

JEMS EVENT EMAILS JEE3 INT ID3

JEMS EVENT EMAILS JEE14 INT ID4

JEMS EVENT EMAILS JEE16 INT BY1

JEMS EVENT EMAILS JEE18 INT BY2

JEMS ANNOUNCEMENTS JA5 NCHAR 20 UPDATED

JEMS CALLERS OTHERNAMES NVARCHAR 500 OTHERNAMES

JEMS CALLERS AVATARNAME NVARCHAR 50 AVATARNAME

JEMS CALLERS WEBSITE1 NVARCHAR 200 WEBSITE1

JEMS CALLERS WEBSITE2 NVARCHAR 200 WEBSITE2

JEMS CALLERS INTERNALNOTE NVARCHAR MAX INTERNALNOTE

JEMS CASE EMAILS BODY NVARCHAR MAX BODY

JEMS EMAIL TEMPLATES JET4 NVARCHAR MAX X TEXT

JEMS EVENT EMAILS JEE5 NVARCHAR MAX BODY

JEMS CALLER NOTES VALUE TEXT VALUE

INT CALLER CALL STATUSES ICCS3 VARCHAR 50 NAME

INT CALLER CALL STATUSES ICCS9 VARCHAR MAX COMMENTS

INT CALLERS PERSON TYPES ICPT3 VARCHAR 100 OTHER

INT CASES COLLABORATION ICC5 VARCHAR 100 OTHER1

INT CASES COLLABORATION ICC6 VARCHAR 100 OTHER2

INT EVENTS CASES IEC4 VARCHAR 50 OTHER

INT LINKED CASES ILC4 VARCHAR 50 OTHER

IssuesConcerns2 IC21 VARCHAR 255 TEMP

IssuesConcerns3 IC22 VARCHAR 255 TEMP

JEMS ADDRESSES NAME VARCHAR 50 X NAME

JEMS ADDRESSES ADDRESS1 VARCHAR 100 ADDRESS1

JEMS ADDRESSES ADDRESS2 VARCHAR 100 ADDRESS2

JEMS ADDRESSES ADDRESS VARCHAR 100 ADDRESS

JEMS ADDRESSES CITY VARCHAR 100 CITY

JEMS ADDRESSES ZIP VARCHAR 30 ZIP

JEMS ADDRESSES TYPEOTHER VARCHAR 50 TYPEOTHER

JEMS ADDRESSES EMPLOYER VARCHAR 100 EMPLOYER

JEMS ADDRESSES JOBTITLE VARCHAR 100 JOBTITLE

JEMS ANNOUNCEMENTS JA2 VARCHAR MAX DESCRIPTION

JEMS CALLER NOTES NAME VARCHAR 50 NAME

JEMS CALLERS LASTNAME VARCHAR 50 LASTNAME

JEMS CALLERS FIRSTNAME VARCHAR 50 FIRSTNAME

JEMS CALLERS MIDDLEINITIAL VARCHAR 50 MIDDLEINITIAL

JEMS CALLERS KEYCODE VARCHAR 50 KEYCODE

JEMS CALLERS LANGUAGEOTHER VARCHAR MAX LANGUAGEOTHER

JEMS CALLS NAME VARCHAR 50 NAME

JEMS CALLS KEYCODE VARCHAR 50 KEYCODE

JEMS CALLS COMMENTS VARCHAR 20 COMMENTS

JEMS CALLS ACTION VARCHAR X ACTION

JEMS CASE EMAILS SUBJECT VARCHAR 200 SUBJECT

JEMS CASE EMAILS TO VARCHAR 100 TO

JEMS CASE EMAILS FROM VARCHAR 100 FROM

JEMS CASE EMAILS CC VARCHAR 200 CC

JEMS CASE EMAILS BCC VARCHAR 200 BCC

JEMS CASE NOTES NAME VARCHAR 50 NAME

JEMS CASE NOTES VALUE VARCHAR MAX VALUE

H.3 eCPIC

The CONTRACTOR shall provide data and analysis for Capital Planning and Investment

Control activities for investments in the select, control, and evaluate phases of the Office of

Disability Employment Policy’s JAN.

This includes but is not limited to:

Providing information required for both the Exhibit 300 and Exhibit 53 including periodic updates throughout the fiscal year.

Providing updated cost and schedule values when necessary in accordance with the DOL

Baseline Management Policy.

Providing information to prepare the Quarterly and Annual submission to the OCIO in accordance with the published calendar.

Providing summary updates pertaining to Work Breakdown Structure, Costs and

Schedule, Earned Value Management factors, and Risk Management updates for

Quarterly and Annual reviews.

Maintaining and updating the collection of SDLCM documentation for JAN in accordance with the schedule published by the OCIO, and provide support for annual updates to the Cost Benefit Analysis, Operational Analysis, Acquisition Plan, and Risk

Management Plan. Other documents, such as the Project Charter, Quality Management

Plan (QMP), and Project Management Plan (PMP) updates shall be requested as needed.

Providing information to support cost and schedule, risk, and performance metric reports for monthly OMB IT dashboard updates.