The ISC_BILLING_DETAIL table contains detailed records about ISC charges, by accounting period. Records are categorized by a Service ID, with additional information about the charge provided in the Item and Desc columns. The following table briefly desribes the ISC Services included, along with their respective Item and Desc fields.
|
|
|
|
Explanation of Field contents in Data Warehouse based on Service ID |
New Service ID (From Apptio) |
Old Service ID |
General Description of Service |
|
ITEM |
DESC1 |
DESC2 |
DESC3 |
DESC4 |
Adobe |
|
Provisioned software |
|
"Monthly Fee" |
School/ Center |
null |
null |
null |
BackItUp |
|
Data protection and backup system available for Client servers. |
|
School/center (alpha) |
Label |
Qty GB consumed |
Date |
|
Backup for Desktop and Laptop |
|
Mozy backup for desktops and laptops |
|
Client |
Quantity |
null |
null |
null |
Broadcasting Studio |
VIDEO:BROADCAST |
Provides video broadcast uplinks to broadcast news outlets and television networks |
|
Service Order # |
Bldg |
Requestor |
Description of work |
Date Order Completed |
Contact Center |
ACD Service (previously billed from Mysoft) |
For helpdesks that handle large call volumes, customized automated call distribution (ACD) services route calls and offers a range of features and reporting tools, including FAQs, email, and instant message. |
|
Phone Number |
Agent Type |
Agent Description and Client ID |
null |
null |
Copper/Hupnet Ports |
NET:OUTLET |
Copper and Hupnet ports |
|
Outlet ID |
Bldg |
Location |
SO # |
Rate Description |
CSF Bundle |
NET:CS |
Headcount portion of Central Service Fee. Schools/centers that choose to pay in a lump sum will only see a charge for this in July. Others will see monthly charges distributed across each IP. |
|
IP Address |
Bldg |
Location |
hostname |
"CS-IP Fee" |
Custom Designed and Advanced Network Solutions |
NET:OUTLET |
VLAN, Subnetm SSA-Fiber, SSA-PATHWAY, Power Supply |
|
Item ID |
Bldg |
Location |
SO # |
Rate Description |
Data Installations |
NET:OUTLET |
One-Time Service Order charges for wiring, data port activation and conversions. |
|
Service Order # |
Bldg |
Requestor |
Description of work |
Date Order Completed |
Domain Names |
NET:TLD |
Third Level Domain Names |
|
Domain Name |
Department |
Requestor |
Date Created |
null |
Email and Calendaring |
NET:EMAIL |
Integrated email, Calendaring, Tasks, and contacts service. |
|
E-mail address |
Penn ID |
Name |
Type (Fac-Staff, shared, student) |
O365 |
Endpoint Management Service |
TSS:EPM |
Endpoint Management Service-BIG FIX |
|
Department - Org |
# of Devices Billed |
null |
null |
null |
Fire Alarms |
Fire Alarm Circuits (previously billed from Mysoft) |
Provides infrastructure in support of fire alarms |
|
Circuit ID |
Location |
Charge Type |
Circuit Type and Secondary Circuit ID |
null |
Firewall Maintenance |
|
Firewall maintenance service for departments that do not have staff with in-house firewall expertise |
|
Client and Group |
Make and Model |
# of firewalls |
Contact |
null |
Forward-only |
NET:EMAIL |
Forward Only Email Service |
|
Email Address |
Owner |
Penn ID |
null |
null |
HireIT Field Services |
|
Project-based HireIT work based on number of PlanView hours logged per month |
|
Charge Description |
Quantity |
Charge Type |
null |
null |
Hosting |
|
Monthly charge for client-owned racks |
|
Charge Description |
Client ID |
null |
null |
null |
IP Billing |
NET:CS |
Fixed Monthly IP charge |
|
IP Address |
Bldg |
Location |
hostname |
"CS-FTE Allocation" |
Lab Rentals |
|
Computer lab with 14 PC's, projection, and an instructor's station available for rent to the Penn community, private companies, and nonprofit agencies. |
|
Class Description |
Contact |
Date of Rental |
null |
null |
Lynda.com |
|
Provisioned software |
|
"Monthly Fee" |
School/ Center |
null |
null |
null |
Mainframe |
Previously in the Mainframe Universe |
Fixed Monthly Fee for Mainframe |
|
"Monthly Fee" |
School/ Center |
null |
null |
null |
Penn on iTunes U |
VIDEO:STREAMING |
Provide technical services for Penn on iTunes U portal and administrate access for campus user community |
|
Service Order # |
Bldg |
Requestor |
Description of work |
Date Order Completed |
PennNet Mailing List |
NET:LISTSERV |
Mailing Lists administered via Listserv |
|
List Name |
Charge Type |
List Contact |
|
|
Penn Video Recording and Production Editing Service |
VIDEO:PRODUCTION |
Provide video recording and editing of production services at campus locations and from our 3401 Walnut St. 232a Green Screen Studio. |
|
Service Order # |
Bldg |
Requestor |
Description of work |
Date Order Completed |
PennNet Ethernet Ports |
NET:OUTLET |
PennNet 10/100/1000 Base-T Network ports, Public and private vlans, VoIP/PoE ports, switch ports, routers and hardware |
|
Outlet ID |
Bldg |
Location |
SO # |
Rate Description |
PennNet Phone Lines (Infrastructure) |
Previously billed from Mysoft |
VoIP line service. Includes: web interface (PPS), feature development, PSTN gateways and PRIs |
|
Phone Nbr |
Number Type |
Bldg and Room |
Pennkey |
null |
PennNet Phone Sets |
PennNet Phone Handsets |
|
MAC Address - Nbr on Line 1 |
Set Type |
Bldg and Room |
Rate Description |
null |
PennNet Phone Voicemail |
Integrated voice mail service and web service that enables users to access messages through their email clients and web browsers. |
|
Mailbox Nbr |
Phone Nbr |
Rate Description |
Pennkey |
null |
PVN Campus Television Services |
NET:OUTLET |
Video ports |
|
Outlet ID |
Bldg |
Location |
SO # |
Rate Description |
Redhat |
|
Provisioned software |
|
"Monthly Fee" |
School/ Center |
null |
null |
null |
Secure Remote Access |
|
Secure remote access services for accessing firewalled networks on PennNet (VPNs) |
|
Department |
Type of vpn Access |
# of accounts |
Contact |
null |
SMTP Mail Relay |
NET:SMTPRELAY |
Allows devices capable of sending email but NOT capable of authenticating the ability to accept mail. |
|
Server Name |
Contact |
null |
null |
null |
Storage |
|
Enterprise grade SAN storage available to clients who currently host systems with ISC |
|
Asset/Server/VM Name |
Client ID |
Quantity |
null |
null |
Tech Services -Service Agreement |
NET:OUTLET |
Support agreements, SLAs |
|
Item ID |
Bldg |
Location |
SO # |
Rate Description |
Traditional Voice Lines (Infrastructure) |
Previously billed from Mysoft |
Centrex telephone line service used for fax lines, alarms and an ever-decreasing number of administrative telephone lines. |
|
Phone Nbr |
Number Type |
Bldg and Room |
|
|
Traditional Voice Specialty Circuits |
Other Circuits, ISDN and Dry Pair (previously billed from Mysoft) |
Specialty circuits from Verizon to support customer needs ISDN, Dry Pairs, etc. |
|
Circuit ID/ Phone Number |
Location |
Charge Type |
Circuit Type and Secondary Circuit ID |
null |
Training |
|
Technology Training Services provides training classes on applications/tools to support Penn's IT community. |
|
Class Description |
Attendee |
Date of Training |
null |
null |
Video Content Management |
|
Service provides recording systems in designated Central Pool classrooms. Instructors may request recording services for any class or event conducted in these classrooms, provided that the class/event is specifically tied to an academic course. FY17 switched to new vendor Panopto |
|
"Monthly Fee" |
School/ Center |
null |
null |
null |
Voice Installations |
Previously in Telecom Universe |
One-Time Service Order charges for new phone lines, sets and line conversions. |
|
Service Order # |
Bldg |
Requestor |
Description of work |
Date Order Completed |
Web Platform Service |
|
Web Hosting provided by Pantheon |
|
Client |
Service Level |
null |
null |
null |
Wireless - AirPennNet |
NET:OUTLET |
Wireless ports and access points |
|
Outlet ID |
Bldg |
Location |
SO # |
Rate Description |
Zimbra Collaboration Suite |
NET:EMAIL |
Zimbra service scheduled for retirement |
|
Charge Description |
null |
null |
null |
null |