ASSET PORTFOLIO DATA GLOSSARY
AS S E T PO R T F OLI O D AT A G L O S S AR Y
P AG E 1
TABLE OF CONTENTS
S3 S E C T I O N 1 : T AB L E D E F I N I T I O N S . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 3 SECTION 2: TABLE GLOSSARIES AND FORM REFERENCE ................................................................. 5 P H Y S I C AL _ L O C AT I O N . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 5 COM PUTER_ROOM ................................................................................................................ 6 S E R V E R M AI N T E N AN C E . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 7 S E R V E R _ S O F T W AR E . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 8 P E R I P H E R AL S ( AL L N O N - S H AR E D D E V I C E S W H I C H M AY B E P L U G G E D I N T O A C O M P U T E R ) . . . . . . . 9 P E R S O N AL _ C O M P U T E R . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 1 0 NETW ORK_DEVICE ............................................................................................................. 11 NETW ORK_SERVICE ........................................................................................................... 12 TELCO_EQUIPM ENT ............................................................................................................ 13 TELCO_SERVICE ................................................................................................................ 14 S H AR E D _ E N T E R P R I S E _ D E V I C E . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 1 5 AG E N C Y B U S I N E S S AP P L I C AT I O N ..................................................................................... 16
E X T E R N AL _ C O N T R AC T _ S E R V I C E . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 1 7 BILLING ............................................................................................................................ 18 S O F T W AR E S T AN D AR D S . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 1 9 SECTION 3: APPENDIX - REFERENCE TABLES ............................................................................... 20 C O M P U T E R _ M AK E . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 2 1 DBMS ................................................................................................................................. 21 EXTERNAL_CONTRACT_SERVICE_FAMILY CROSS REFERENCE (VITA SERVICE FAMILIES) ................. 22 JOB_CATEGORY (TO BE USED ON SPREADSHEET) ..................................................................... 23 LANGUAGE ........................................................................................................................... 25 LAN_DEVICE_TYPE.................................................................................................................. 26 LAN_TECHNOLOGY_ID ......................................................................................................... 27 LICENSE_TYPE ................................................................................................................... 27 LINE_SPEED....................................................................................................................... 28 M AN U F AC T U R E R . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 2 8
PERATING_SYSTEM ................................................................................................................... PERIPHERALS_TYPE
30
............................................................................................................... 30 31
SERVER_FUNCTION .................................................................................................................. 30
TELCO_PROVIDER .................................................................................................................... TELCO_SERVICE_TYPE_CATEGORY
................................................................................................ 33 34 34
TELCO_SERVICE_TYPE .............................................................................................................. 33
TOOL_TYPE ............................................................................................................................ TOOL_ID...............................................................................................................................
TELCO_EQUIPMENT_TYPE ........................................................................................................... 38 VENDOR ............................................................................................................................... 39
AS S E T PO R T F OLI O D AT A G L O S S AR Y
P AG E 2
SECTION 1: TABLE DEFINITIONS
Table Physical_Location Definition Information describing the physical location(s) for an agency (starting with Headquarters and including all locations). The street address and associated details of a particular physical location for an agency. If an agency has a campus environment, the physical location is the street address for each building in the campus. Information concerning computer rooms, defined as a room that houses servers, mainframes or midrange computers that have the following characteristics: (1) at least 100 square feet, (2) separate climate controls for temperature and humidity and (3) electrical connections adequate for multiple computing devices. Information concerning servers, midrange and mainframe computers at a specific location. You will also be asked to select which of your agency‟s business applications, if any, are running on each server and/or mainframe.
Computer_Room
Servers Details
Server Software
For each server, specify the software details. Server software includes operating systems, utilities, business applications, e-mail, GroupWare, communications, and connectivity. Included are commercial applications and shrink wrap software. Site licenses or select agreements are typically capitalized over the duration of the agreement. Software that is licensed under an annual subscription is recorded as an annual expense. If a maintenance or support agreement exists on a software license, and the main purpose of the agreement is to obtain updates and upgrades, the cost for the maintenance/support agreement should be recorded here. Software that is resident on a server but used by clients or is difficult to allocate cost wise between servers and clients should be allocated to the PC software category. Specify the current quantity of peripherals by type for this location. Includes all nonshared devices which can be plugged into a computer. Specify the quantity of PCs by type for this location. Includes any stationary desktop workstations and mobile computers. Mobile computers include laptops and handheld devices. A network device is any communications device necessary to support a LAN, WAN or Wireless LAN infrastructure. Information concerning the Local Area Network (LAN) services at a specific physical location. Information concerning any telecommunications equipment provided at a specific physical location that is NOT BILLED by DIT. Such equipment includes customer premises equipment such as PBX, ACD, Key Systems and IVR/VRU. Also includes equipment for conferencing, audio/video, satellite and broadcasting. This category EXCLUDES desktop telephones. Information concerning any telecommunications circuits and services provided at a specific physical location which are NOT billed by DIT. All telecommunications services billed by DIT will be captured directly from DIT and presented to the Agency for review. Examples include all voice, data, and video services, both wired and wireless, including satellite, cellular, mobile radio, audio/video, broadcasting, Internet, etc. Information concerning Enterprise class devices attached to networks for shared use by servers and/or users. Examples include, high capacity printers used for high volume
Peripherals
Personal Computer
Network Device
Network_Service
Telco Equipment
Telco_Service
Shared_Enterprise_Device
AS S E T PO R T F OLI O D AT A G L O S S AR Y
P AG E 3
batch printing services, network attached storage devices, storage area networks, tape backup silos, tape cartridge subsystems, etc. Do NOT include typical workgroup printers and similar devices (less than $1,500 value). Agency Business Application Agency acquired or developed strategic business applications or systems which may include multiple licensed software components as well as custom developed software. Examples include Pavement Management System, Voter Registration System, etc. Central systems such as CARS and PMIS should only be reported by the central agency that owns it. External_Contract Services Information concerning the paid services provided to your agency either by external service providers or some other agency (e.g. DGS, etc.). External services include such things as application hosting, ASP services, backup services, database hosting, email, IT consulting, seat management, storage services, systems development and web hosting. External services does not apply to staff augmentation (i.e., body shop contracting), Telco or any services billed by DIT. Total annual maintenance costs for LAN/WAN premise equipment should be included in this section as well. Information concerning third party/vendor maintenance and warranty costs for servers, software and shared enterprise devices is NOT captured here. Billing Information concerning DIT billing. The adjusted cost field allows agencies to rectify any inaccuracies. Information concerning all licensed, „commercial off the shelf‟ (COTS) software currently installed on servers and mainframes (as defined in this document), for which a license was purchased or leased, and ongoing software maintenance fees are paid. This definition includes such things as operating systems, DBMS, email, ERP Applications, GIS, group/collaboration, etc. This definition does NOT include such things as custom developed code or COTS module customization where no licensing is involved. In addition, standard utility applications (i.e. backup, virus, etc.) should not be identified.
Software Standards
AS S E T PO R T F OLI O D AT A G L O S S AR Y
P AG E 4
SECTION 2: TABLE GLOSSAR IES AND FORM REFERENCE
COLUMN_NAME
PHYSICAL_LOCATION Building_name street_name_1 street_name_2 City District_ID Enter the building name (such as Monroe, Washington, Plaza, 9th Street Office) associated with a location. Enter the street name (UPS not PO Box) associated with the location. Additional Address Information Enter the full town or city name (no abbreviations). This is a new feature built into Asset Portfolio. Agency‟s with large numbers of people gathering data and many physical locations, may add the physical locations which they are responsible for to a district. They may then sort their locations by district. It is not a mandatory field, and agencies do not need to use this feature. Indicate whether the location is owned, leased or other by the state (other might include property donated for free). Enter any related comments. Enter any related comments Select the two-letter abbreviation for the state associated with the location. Enter zip code Information describing the date on which the current facility lease terminates. Information describing the financial penalties associated with terminating the lease prior to the lease termination date. For small agencies prior to < 1/01/04, For medium agencies <
DEFINITION
state_ownership_ind Agency Location comment Physical Location comment state_code zip_code lease_termination_date lease_termination_penalties
7/1/04, for large agencies < 1/1/05
closed_ind cost_per_sq_foot Check if location closed Enter annual cost for lease/state charge ending Form Reference: Physical Location Maintenance
AS S E T PO R T F OLI O D AT A G L O S S AR Y
P AG E 5
COMPUTER_ROOM computer_room_id room_name_number cost_per_sq_ft raised_floor_sq_ft non_raised_floor_sq_ft comment_text Delete_record Number that uniquely identifies a computer room. Enter the name and/or number of the computer room. A computer room houses server, mainframes etc. and must be at least 100 sq. feet. If a premium is paid for space used as the computer room, enter the annual cost per square foot of the computer room here. Enter computer room square footage of removable flooring with space provided underneath for wiring access, air conditioning and/water control Enter the square footage of computer room space not counted as raised floor Enter related comments. Allows you to delete a computer room record
AS S E T PO R T F OLI O D AT A G L O S S AR Y
P AG E 6
S E R V E R M AI N T E N A N C E ( please note, you will need to add function, software, and business app. for each server) server_name Use_type operating_system model_name Computer_make Production_ind shared_with_agencies_ind comment_text Serial_No owned_leased_ind lease_termination_date annual_lease_cost lease_termination_penalties purchase_year cost_per_unit annual_maint_warranty_cost Indicate the server name by which the server is commonly known (e.g., some nickname). Select from Drop Down (see appendix) Select from Drop Down list. Enter the model name and/or number of the server (e.g., Proliant). Manufacturer Select whether the server is used as a production server. Check if shared with other agency Enter related comments. Enter serial number located on the server Select if the server is owned or leased or other. The date that the lease of the server ends. Enter the annual cost associated with the lease Enter penalties if any. For small agencies prior to < 1/01/04, For medium agencies <
7/1/04, for large agencies < 1/1/05
Enter the year that the server was purchased Enter cost per unit Enter the annual third party/vendor cost to maintain and/or provide warranty support. Form Reference: Servers
AS S E T PO R T F OLI O D AT A G L O S S AR Y
P AG E 7
SERVER_SOFTWARE Server Software_id Vendor Version production_ind license_type_id per_seat_license_count owned_leased_ind lease_termination_date lease_termination_penalties
Select from drop down the name of the software. If “other”, enter description Select from drop down list Enter the version name and/or number. Is it a production server Select the type of license associated with the cost entered. If the license type is per seat, indicate the number of seats. If the server participates in a farm, only enter seat count on one server in the farm. Select whether the software is owned by the agency or leased or other. Select Leaset termination date Enter the monetary penalty associated with terminating the lease. For small agencies prior to
< 1/01/04, For medium agenicies < 7/1/04, for large agencies < 1/1/05.
annual_lease_cost purchase_year cost_per_unit annual_maintenance_cost comment_text Enter the annual cost associated with the lease Select Purchase year Enter Cost per unit Enter annual maintenance cost Enter related comments Form Reference: Server Software
AS S E T PO R T F OLI O D AT A G L O S S AR Y
P AG E 8
P E R I P H E R A L S ( AL L N O N - S H A R E D D E V I C E S W H I C H M A Y B E P L U G G E D I N T O A C O M P U T E R ) peripheral_make_id peripheral_type_id Quantity model_name Use_type production_ind owned_leased_ind lease_termination_date lease_termination_penalties annual_lease_cost purchase_year cost_per_unit Select from drop down list (see appendix) If other, enter description Select from drop down list (see appendix) Enter Quantity Enter description of the model or model number Department, Enterprise, Group, Large Enterprise, or Personal. Peripherals would typically be personal. Check if in production Indicate whether the shared/enterprise device is owned or leased or other. If leased, enter termination date Enter any penalties for breaking a lease. For small agencies prior to < 1/01/04, For
medium agenicies < 7/1/04, for large agencies < 1/1/05
Enter lease cost Enter year purchased Enter total cost for all peripherals of a certain type or make (not per unit cost) Form Reference: Peripherals
AS S E T PO R T F OLI O D AT A G L O S S AR Y
P AG E 9
P E R S O N AL _ C O M P U T E R Computer_Make model_name operating_system PC_Type Quantity owned_leased_ind lease_termination_date lease_termination_penalties annual_lease_cost purchase_year Total Purchase Cost Select from drop down list (if other, enter description) Enter Model Name Select from drop down list (if other, enter description) Select from Drop Down. Quantity for this location Owned, leased or other If leased, enter lease termination date If leased, enter termination penalties. For small agencies prior to < 1/01/04, For medium
agenicies < 7/1/04, for large agencies < 1/1/05
If leased, enter lease cost Enter average year purchase for PCs at this location The total purchase cost for all PCs at this location
AS S E T PO R T F OLI O D AT A G L O S S AR Y
P AG E 1 0
NETWORK_DEVICE Devices Vendor production_ind Network Service Select from drop down (if other, enter description). Any communication device necessary to support a LAN, Wan or wireless infrastructure. Select from drop down list Indicate whether or not the server is a production server Information concerning the local area network services at a physical location (such as protocol and speed). Only select from this list if the device is not in use (such as an old hub that may no longer be compatible with new network protocol. (These devices may be used elsewhere) Select from Drop Down (see appendix) Enter purchase year Owned/leased? Enter the number of active ports provided by the LAN service Enter cost of server Enter the annual third party/vendor cost to maintain and/or provide warranty support. Enter the total number of these devices at this location. Enter any penalties. For small agencies prior to < 1/01/04, For medium agenicies < 7/1/04,
Network_Technology Type Purchase_year owned_leased_ind Number_ports_used cost_per_unit annual_maint_cost Device_quantity lease_termination_penalties
for large agencies < 1/1/05.
lan_technology_comment_text Enter additional comments annual_lease_cost If leased, annual lease cost for device lease_termination_date If leased, termination date of lease on this device Form Reference: Network Device Maintenance
AS S E T PO R T F OLI O D AT A G L O S S AR Y
P AG E 1 1
NETWORK_SERVICE Network_technology_Type Select Network Topology type Provided_by_your_agency_ind Select whether the LAN service is provided by your agency or by a third party. For example, if your network service was outsourced, you would indicate that here and put annual cost in the next field. annual_cost_if_purchased Annual cost for this service number_ports_used Enter the number of active users comment_text Enter any comments. Form Reference: LAN Service
AS S E T PO R T F OLI O D AT A G L O S S AR Y
P AG E 1 2
TELCO_EQUIPMENT telco_equip_type_id cost_per_unit owned_leased_ind lease_termination_penalties model_name Number_active_ports lease_termination_date comment_text annual_licensing_cost annual_lease_cost device_count Select from Drop Down. Concerns information provided at a location not billed by VITA. Includes ACD equipment, key systems, IVR/VRU etc. Cost per unit. Owned, leased or other Enter any penalties for early termination of lease. For small agencies prior to < 1/01/04, For
medium agenicies < 7/1/04, for large agencies < 1/1/05.
Model name of device Number of active ports Enter lease termination date Enter Comments
Enter the annual cost associated with this service.
Enter lease cost information Enter the number of devices Form Reference: Telco Equipment
AS S E T PO R T F OLI O D AT A G L O S S AR Y
P AG E 1 3
TELCO_SERVICE Quantity telco_provider_comment_text annual_cost Provider_ID line_speed_id Contract_expiration_date contracted_with_dit_ind line_speed_comment_text comment_text telco_service_type_id change_dt Enter the number of circuits of the type terminated at this location. Enter related comments. Enter the annual cost associated with this service Select a provider. Select the bandwidth of the circuit. Enter the expiration date of the contract. Not entered by a user. Enter Comments Enter Comments Select a service type. Need This Form Reference: Telco Services
AS S E T PO R T F OLI O D AT A G L O S S AR Y
P AG E 1 4
SHARED_ENTERPRISE_DEVICE lease_termination_dt Quantity purchase_year owned_leased_ind comment_text annual_maint_warranty_cost annual_lease_cost cost_per_unit model_name manufacturer_comment_text device_type_comment_text lease_termination_penalties Enter the date that the lease on the shared/enterprise device terminates Enter the total number of these devices at this location by usage. Enter the year in which the device was purchased. Indicate whether the shared/enterprise device is owned or leased. Enter related comments Enter the annual third party/vendor cost to maintain and/or provide warranty support. Enter the annual lease cost for the device. Enter cost per unit Enter the model name and/or Enter information on the manufacturer Enter information on the device type Enter the monetary penalty associated with terminating the lease. For small agencies prior to
< 1/01/04, For medium agencies < 7/1/04, for large agencies < 1/1/05.
Form Reference: Shared Enterprise Device
AS S E T PO R T F OLI O D AT A G L O S S AR Y
P AG E 1 5
AGENCY BUSINESS APPLICATION (CROSS REFERENCE IN APPENDIX: TOOL_ID, LANGUAGE, DBMS application_name application_acronym Business_owner_name Business_owner_phone Business_owner_phone_ext implement_year Version developer_name technical_lead_name technical_lead_phone technical_lead_phone_ext retiring_ind client_info_text Security_desc comment_text maintenance_type_comment_ text Business_application_id maintenance_type_id status_id Enter the name of the application. Enter any applicable acronym. Enter the name of the functional manager for the application‟s business owner. Enter the phone number of the business owner. Enter the phone number of the business owner. Enter year implemented Enter the version of the application, if applicable. Enter the vendor or organization that produced the application. Enter the name of the technical manager for the application. Enter the phone number of the technical support person. Enter the phone number of the technical lead. Indicate whether the application is in the process of being retired. Enter the key client group or customer interacting with the application Enter any security measures the application utilizes. Enter any applicable comment. Enter maintenance information An automatically assigned id that uniquely identifies a business application. Not entered by a user. Select from maintenance type
Select the appropriate status of the application from the drop-down menu. Status is choices are as follows: - Operational – application is currently in production with no plans to retire in the foreseeable future.
- Planning, Design or Development – application is currently not in production, but is in one of the project life cycle stages.- n/a – not applicable
shared_ind cots_ind
Is this business application shared Select whether or not the application entered above is a commercial-off-the-shelf (COTS) product. Form Reference Below: AGENCY BUSINESS APPLICATION
AS S E T PO R T F OLI O D AT A G L O S S AR Y
P AG E 1 6
EXTERNAL_CONTRACT_SERVICE Service_provider_name Contract_number Effective_date end_date Annual_cost Renewal_periods_remaining Number_of_renewals comment_text Enter the full name of the provider (may be a state agency or private contractor) that provides the service. Enter any associated contract number(s). Date Contract became effective Contract End Date The annual cost for the service. In all cases use FY2003 (the year ending June 30, 2003) data. Enter renewal periods remaining Enter any related comments. Form Reference: External Contract Services
AS S E T PO R T F OLI O D AT A G L O S S AR Y
P AG E 1 7
B I L L I N G ( B I L L I N G I N F O R M AT I O N P R O V I D E D B Y V I T A – B I L L I N G W I L L B E S H O W N O N A G E N C Y H Q BUILDING) Fiscal Year Cost Type Actual Cost Adjusted Cost No Entry Required No Entry Required No Entry Required Enter any adjustments to Bill Form Reference: Billing
AS S E T PO R T F OLI O D AT A G L O S S AR Y
P AG E 1 8
SOFTWARE STANDARDS Software Standards Multiple reference tables contained in attached appendix which allows agencies to select or add software standards: Operating_System, Form Reference: Software Standards
AS S E T PO R T F OLI O D AT A G L O S S AR Y
P AG E 1 9
APPENDIX - REFERENCE TABLES
AS S E T PO R T F OLI O D AT A G L O S S AR Y
P AG E 2 0
CO M PUT E R_M AK E
Computer_Make_Code Computier_Make_Name 999 1 2 4 6 8 9 12 13 15 16 17 19 20 21 25 28 30 31 32 Other Access Tech Acer Amdahl AST BULL Compaq Dec Dell Gateway HP IBM NCR NEC Quantex Sun UNISYS Apple Mac WIN
DB MS DBMS_ID 1 2 DBMS_NAME DataEase DB2
AS S E T PO R T F OLI O D AT A G L O S S AR Y
P AG E 2 1
DBMS_ID 3 4 5 6 7 8 9 10 999
DBMS_NAME DMS ADABAS Oracle Informix rbase SQL Server IMS VSAM Other
E XT ER N AL _ CO NT R AC T _ SE R VI CE_ F AM IL Y CR OS S R EF ER E NC E V IT A SE R VI C E F A MIL I ES
Family Business Services Family Description Provide custom full life cycle systems development and provide production maintenance. Assist to provide Business Goals and business solutions to meet those goals. Provide integration Services to meet Agency goals and Commonwealth Strategic goals. Assist in development of IT Strategic goals, assist in the management of major IT projects, and conduct Total Cost of Ownership (TCO) studies. Assist in development of workflow automation solutions that support Agency business processes. Assist Agency customers with billing issues and requests, setup accounts, handle credit adjustments to standard bill. Provide systematic and reliable Data protection services for Agency determined critical data, including audit, annual testing, and offsite storage. Provide Agency with high performance, volume, security, and availability of Mainframe resources. Provide Print Service requirements from Mainframe resources through Data Center high volume printers and low volume Agency directed local printers. Provide Agency with UNIX and Windows Operating System Administrative support, including deployment, security, server management, and VITA infrastructure connectivity. Provide Server network and array storage access and availability on an Agency requested basis. Provide connectivity for access to VITA Data Center and other State entities through frame relay, ATM, SNA, dial-up, and dedicated services using TCP/IP protocol. Provide Internet access through competitive bid State contract with MCI and VISINET. Provide WAN equipment through contract or lease and provide connectivity through MCI or Verizon. Provide statewide connectivity with triple DES encryption capability. Provide provisioning and support for email and Office Application software to the Desktop. Provide provisioning and support for wireless handheld PDAs and office connection.
1
2
Computing Platform Services
3
Data System Services
4
Desktop & End-User Services
AS S E T PO R T F OLI O D AT A G L O S S AR Y
P AG E 2 2
Family
5
e-Government Services
6
Knowledge Systems Services Network Services Video Services
Family Description Provide provisioning and onsite support for desktop equipment. Providing seat management and coordination of service. Provide LAN/WAN equipment provisioning and connectivity within the Agency and to the VITA network. Coordination of VIPNet Service to maintain website portal for the agency. Coordination of VIPNet Web Content Management Service. Providing content management of agency website. Coordination of VIPNet service to provide website development, hosting, and maintenance. Providing web access to agency application store through the Internet. Provide data information repository about data maintained by numerous sources. Providing location of data about municipal boundaries, geographic layers, natural resources, etc.
7 8
9
Voice Services
Provide satellite space on a per hour basis rate for video events. Scheduling is through VITA Help Desk. Provide Audio Visual equipment on a scheduling basis for meetings and conferences. Provide video bridging for regional or statewide video conferencing and broadcasting. Provide Agencies with video tape product development utilizing the Executive Teleconferencing Center (ETC). Providing staff, equipment, materials, and editing capability. Provide video conferencing and broadcasting services through the Executive Teleconferencing Center (ETC) generally via satellite. Provide wireless telephone service throughout a majority of the Commonwealth. Providing regional and nationwide service plans and support. Provide premise based audio conferencing equipment in support of telephone conferencing. Provide wire line telephone service throughout the majority of the Commonwealth. Providing analog and digital service and support. Provide telephone equipment to support service throughout the Commonwealth. Providing key systems, ISDN, and ISDN Centrex equipment service and support. Provide inbound and outbound toll traffic for domestic and international calls. Providing calling cards, enhanced call routing, and support. Provide customized enhancements to telephone systems throughout the Commonwealth. Provide wireless paging service throughout a majority of the Commonwealth. Providing Local, Statewide, and Nationwide service plans and two-way paging and support.
10
Other
JOB_ C AT EGO R Y ( TO BE US E D O N S P RE A D S H E E T)
Category_Code Category_Name 1 CIO/CTO Category_Desc Chief Information Officer, Chief Technology Officer, or Agency head of IT. May be more than one person, if appropriate. Include staff time spent technical planning and reporting activities such as efforts in Architecture and Design, Technical Engineering, Standards, and Performance Management. Include staff time spent performing IT audits, ADP audits, IT security audits, IT risk assessments, etc. Include staff time spent performing systems tests or user acceptance
2
Plan Management
3
ITAudit
4
IT_QA_Test
AS S E T PO R T F OLI O D AT A G L O S S AR Y
P AG E 2 3
Category_Code Category_Name
Category_Desc tests.
5
IT_Procurement
Include staff time spent on the procurement aspects of creating, evaluating, negotiating, and executing bid solicitations and associated contracts. Do NOT include staff time spent performing technical content, review and evaluation of bid solicitations. Include staff time spent in a webmaster or content management role supporting web servers. This includes designing and executing web site pages, modifying pages and functions, and providing content management. This does NOT include web applications coding (i.e. JAVA, etc.). Include staff time spent coordinating and facilitating the alignment of business rules and requirements with associated IT Systems. Include staff time spent providing end-user workstation support. This includes Tier 2 / 3 technical support for end user devices including workstations, laptops, printers, network connectivity, software and hardware support. Include all staff time spent on the provisioning and support of all Mainframe platforms, including systems programming, user administration, backup / recovery, License Management, NOS / OS, Disk / File Management, Tier 2 / 3 Technical support. Include all staff time spent on the provisioning and support of all Midrange and Server platforms (including file/print servers), including systems programming, user administration, backup / recovery, License Management, NOS / OS, Disk / File Management, Tier 2 / 3 Technical support. Include all staff time spent on LAN data services, including the provisioning and support of network hubs, switches, routers, and other data communications Customer Premise Equipment, and associated Tier 2 / 3 technical support. Includes staff time spent on all aspects of database development and administration. Includes staff time spent on programming, coding, and developing new applications, as well as applications maintenance / enhancement activities, regardless of server platform type or application type. Includes staff time spent on service or help desk activities, including Tier 0 / 1 assistance, call logging and reporting. Includes staff time spent on activities related to security provisioning and support (e.g.,. firewall, authentication, encryption, etc.), as well as other risk mitigation exercises such as BCP/DRP. Includes staff time spent all voice and video services, including telecommunications circuits and services, premises equipment (e.g., . PBX, ACD, CODEC, Conference Bridge, etc.), mobile radio, wireless, etc. Also include all staff time spent on WAN data telecommunications services.
6
Web_Content
7
IT_Business_Analysis
8
Tech_Desktop
9
Tech_Mainframe
10
Tech_Midrange_Server
11
Tech_Network
12
DBA
13
Tech_SA_SD_Prg
14
Help_Desk_0_1
19
Tech_Security
15
Tech_Telco
AS S E T PO R T F OLI O D AT A G L O S S AR Y
P AG E 2 4
Category_Code Category_Name 16 GIS
Category_Desc Includes staff time spent on systems, applications, and data development / acquisition associated with GIS. Includes staff time spent in direct support of IT resources in the areas of clerical / administrative assistance, reception, etc. Includes staff time spent in direct support of IT resources in the areas of Finance and Budget, Human Resources, Training, and other similar roles.
17
IT_Admin_Support
18
IT_Support_Other
LANGUAGE LANGUAGE_ID 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 LANGUAGE_NAME ASP Assembler C C++ Clipper Clist COBOL Cold Fusion COM COM+ Cross System Product DHTML Easytrieve HTML Java JavaScript Kornshell MAPPER MS Visual Basic Natural
AS S E T PO R T F OLI O D AT A G L O S S AR Y
P AG E 2 5
LANGUAGE_ID 21 22 23 24 25 26 27 28 29 30 31 32 999
LANGUAGE_NAME Pascal PDL Perl PL/SQL Powerbuilder Oracle SQLPlus Unix Scripting Viking Software MS VBScript XML SQL Visual C++ Other
LAN_DEVICE_TYPE
Device_Code Device_Name Router - A device used to connect networks of different types, such as those using different architectures and protocols. Routers can switch and route information across multiple networks by exchanging protocol-specific information between separate networks. Routers determine the best path for sending data and filtering broadcast traffic to the local segment. Routers are used to isolate network sections and provide interconnectivity amongst workgroup and department level servers. Routers are useful in segmenting very large networks into smaller subnetworks. Routers have on average 8 ports and is a chassis based solution. Bridge - A bridge is a device used to join two local or remote networks regardless of higher level protocols involved. By connecting networks with a bridge, the bridge forms a single logical network, centralizing network administration and allowing stations on either network to access resources on the other. Bridges can be used to increase the allowable length or number of nodes for a given network. Switch - A switch is a hardware/software based network device that provides intelligent hub, bridge, and router functions in a single device. The switch provides high speed dedicated logical network connections between clients, servers, and other network devices. Hub - A Network Hub is a connectivity component that provides a common connection among computers in a star-configured network. Active hubs regenerate and retransmit network data. Passive hubs simply organize wiring. The Network Hub is also known as a repeater. An average hub is an 8 port stand alone device. 4
1
2
3
AS S E T PO R T F OLI O D AT A G L O S S AR Y
P AG E 2 6
Device_Code
Device_Name Gateways - A gateway is a device that connects two dissimilar local area networks or connects a local area network to a wide-area network, a minicomputer, or a mainframe. A gateway has its own processor and memory and may perform protocol conversion and bandwidth conversion.
5 0 Other
L A N_ T EC H N OL OG Y_ I D
Technology_Type_Code Technology_Type_Name 999 1 2 3 4 5 6 7 Other ATM Ethernet, 100Mb Ethernet, 10Mb Ethernet, 1Gb FDDI Token Ring, 16Mb Token Ring, 4Mb
LIC E N S E_T Y P E
License_Type_Code License_Type_Name 1 2 3 4 5 999 Per Site Per Server Per Seat Per Enterprise Per CPU Other
AS S E T PO R T F OLI O D AT A G L O S S AR Y
P AG E 2 7
LINE_SPEED
Speed_Code 999 1 2 3 4 5 6 7 Speed_Name Other 56 kbps 128 kbps 384 kbps 512 kbps 768 kbps T1 T3
M ANUFACTURER
Manufacturer_Code 999 1 2 3 4 24 39 41 45 47 48 50 Manufacturer_Name Other EMC Sun IBM StorageTek Gentner Leitch Panasonic Sharp Sony Telex Videotek Manufacturer_Flag V E E E E V V V V V V V
AS S E T PO R T F OLI O D AT A G L O S S AR Y
P AG E 2 8
Manufacturer_Code 58 61 63 66 72 73 76 77 78 79 81 82 83 84 87 88 90 91 94 95 100 101 105 106 107
Manufacturer_Name Fujitsu Kodak NEC Proxima Toshiba Viewsonic Kyocera Motorola Nextel Nokia Samsung Comdial Qualcomm Vodavi Direct TV Dish Network Prodelin General Instruments Accord Cisco PictureTel Polycom VTEL Zydacron Logitech
Manufacturer_Flag V V V V V V V V V V V V V V V V V V V V V V V V V
AS S E T PO R T F OLI O D AT A G L O S S AR Y
P AG E 2 9
OPERATING_SYSTEM
Software_Code 1 2 3 4 5 7 8 9 10 11 99 12 Software_Name Mac OS 8.x Windows 2000 Windows 95 Windows 98 Windows ME Windows XP Unix Linux Red Hat Windows NT 4.X N/A DOS
PERIPHERALS_TYPE
Type_Code 1 3 4 5 6 999 Type_Name Scanner Printer LCD Projector Print/Fax/Scan Handheld Other
SERVER_FUNCTION
Use_Type_Code Use_Type_Name 999 Other
AS S E T PO R T F OLI O D AT A G L O S S AR Y
P AG E 3 0
1 2 3 4 5 6 7 8 9 10 11 12 13
Application Database Domain Controller Email File Print Thin-client server (e.g., Citrix, MS Terminal Server) Web Server GIS Test and/or Development Security (e.g., Firewall, Anti-virus, Network Intrusion) Domain Name Services (DNS) DHCP Services
TELCO_PROVIDER
Provider_Id 999 16 19 20 23 24 27 28 29 30
Provider_Name Other Alltel Metro Call Nextel SunCom Verizon Wireless Direct TV Dish Network Global Access Public TV
AS S E T PO R T F OLI O D AT A G L O S S AR Y
P AG E 3 1
Provider_Id 31 35 36 38 39 42 43 44 55 56 57 58 61 63 64 65 70 71 72 73
Provider_Name Space Connection NetworkVA VCCS Verizon South Verizon Virginia Central Tel. Co. of VA Peoples Mutual Tel. Co. of VA Citizens Tel. Co-op Virginia Telephone Co. Worldcom Sprint AT&T Visinet AOL Earthlink NTelos Cox Communications Afton Communications Aquis Communications Local Government
AS S E T PO R T F OLI O D AT A G L O S S AR Y
P AG E 3 2
TELCO_SERVICE_TYPE_CATEGORY
TELCO_SERVICE_TYPE_CAT_ID 1 2 3 999 TELCO_SERVICE_TYPE_CAT_NAME Voice Usage Data Usage Internet Access Other
TELCO_SERVICE_TYPE
TELCO_SERVICE_TYPE_ID 32 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 TELCO_SERVICE_TYPE_NAME Other Centrex Lines Other Local Phone Services PBX T-1 ISDN PRI Trunks Long Distance - Toll Free Long Distance - Intra-LATA Long Distance - Inter-LATA Calling Cards Call Center Other Private Lines Frame Relay ATM ISDN BRI xDSL Other Access Circuits Dial-up
AS S E T PO R T F OLI O D AT A G L O S S AR Y
P AG E 3 3
TELCO_SERVICE_TYPE_ID 19 20 21 22 23 24 25 26 28 29 30 31
TELCO_SERVICE_TYPE_NAME Remote Access VPN Other Audio Conferencing Video Conferencing Audio / Video Production Services Audio / Visual Support-Events Cellular Telephone Paging 2 Way Land/Mobile Satellite Radio/TV Broadcast Microwave
TOOL_TYPE
TOOL_TYPE_ID 1 2 3 4 5 6 7 8 TOOL_TYPE_NAME Business Intelligence Data Mining Development ETL Information Portal Network Management Productivity Reporting
TOOL_ID
TOOL_ID 1 2 TOOL_NAME Business Objects COGNOS
AS S E T PO R T F OLI O D AT A G L O S S AR Y
P AG E 3 4
TOOL_ID 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29
TOOL_NAME PowerPlan PVCS Siebel Unisys Workflow SPSS Advanced Revelation Advantage Repository ArcGIS ArcIMS ArcView ATG Dynamo BDE BEA Weblogic COFAX Cold Fusion Studio DPS Dreamweaver Flash FoxPro Genesys MS DTS MS FrontPage MS Visual Interdev MS Publisher MS Visual Studio Oracle Designer Oracle Developer
AS S E T PO R T F OLI O D AT A G L O S S AR Y
P AG E 3 5
TOOL_ID 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56
TOOL_NAME Oracle Forms Oracle PL/SQL Tool Kit Pronexus VBVoice Rockwell Development Tools Visual Cafe Visual FoxPro Visual Voice PeopleSoft SAP Exor Highways HP Image MS Exchange MS Hyperterminal OAS Manager Acrobat Adaytum ePlanning All Clear Flow Chart ASPQmail Attachmate Extra Borland Paradox Construct DataCap dBase dBaseIII Delphi Entire Connection Entire Print System
AS S E T PO R T F OLI O D AT A G L O S S AR Y
P AG E 3 6
TOOL_ID 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83
TOOL_NAME EntireX FileMaker Pro FileNet Image Vision ImageMagick JCL Expeditor Lotus Lotus Notes MitemView MS Access MS Excel MS Office MS Outlook MS Word Notepad Nuance Speech Recognition OmniPage Pro PeopleTools ScriptWrite - Provoice SharePoint Speedware Text Bridge Pro Time Sheet Pro UltraDev UltraEdit USoft VMS Macros
AS S E T PO R T F OLI O D AT A G L O S S AR Y
P AG E 3 7
TOOL_ID 84 85 86 87 88 89 90 91 92 93 94 95 999
TOOL_NAME VTLS Imaging Crystal Reports Oracle Reports R R Report Writer Report Writer SAS ArcInfo FoxBase Pro Oracle RPT Informatica ResQPortal MS Powerpoint Other
TELCO_EQUIPMENT_TYPE
Service_Type_Code Service_Type_Name 999 1 2 3 4 5 6 7 Other PBX Key System IVR/VRU ACD Audio Conferencing Video Conferencing Audio/Video Production
AS S E T PO R T F OLI O D AT A G L O S S AR Y
P AG E 3 8
Service_Type_Code Service_Type_Name 8 10 11 12 13 Audio/Visual Support Paging Two Way/Land/Mobile Satellite Radio/TV Broadcast
VENDOR
Vendor_Code 999 6 7 8 9 10 11 16 17 18 19 20 21 22 23 24 25 Vendor_Name Other Microsoft Oracle Computer Associates IBM Linux (Various Vendors) Apple ESRI Unisys Hewlett-Packard ATT Novell Sun Software AG WinZip Computing Symantec Various Vendors Vendor_Flag S S S S S S S S S S S S S S S S S
AS S E T PO R T F OLI O D AT A G L O S S AR Y
P AG E 3 9
Vendor_Code 26 27 28 29 1 2 3 4 5 12 30 31
Vendor_Name Network Associates, Inc. Veritas Software Corporation Executive Software International Apache Cisco LinkSys Belkin 3COM Net Gear Intel Nortel Other
Vendor_Flag S S S S H H H H H H H H
AS S E T PO R T F OLI O D AT A G L O S S AR Y
P AG E 4 0