Loading presentation...

Present Remotely

Send the link below via email or IM

Copy

Present to your audience

Start remote presentation

  • Invited audience members will follow you as you navigate and present
  • People invited to a presentation do not need a Prezi account
  • This link expires 10 minutes after you close the presentation
  • A maximum of 30 users can follow your presentation
  • Learn more about this feature in our knowledge base article

Do you really want to delete this prezi?

Neither you, nor the coeditors you shared it with will be able to recover it again.

DeleteCancel

Make your likes visible on Facebook?

Connect your Facebook account to Prezi and let your likes appear on your timeline.
You can change this under Settings & Account at any time.

No, thanks

SFG Fulfillment Process & Database Flow

No description
by

Zac Alldredge

on 5 September 2013

Comments (0)

Please log in to add your comment.

Report abuse

Transcript of SFG Fulfillment Process & Database Flow

Shipment
___________________
Travel Information System & Process
Vendor
suppliers
=
Phone center
+
Reader cards services
+
LITS
inventory
Bad file
Errors
Edits
Dupes
TICS
entry
.....................
_______
Nightly
Nightly
_______________________________
Fulfillment company
Format B (daily)
Format A (daily)
Format C (daily)
TIS
FTP
server
Web
site/services
Vendor reports
1:00 a.m. daily order file fulfillment
Inventory file feed
(Every 4 hours)
....................
Web
site/services
System, Process, Access
Vendor
suppliers
=
Phone center
+
Reader cards services
+
LITS
Inventory
Format B (daily)
Format A (daily)
Format C (daily)
Bad File
Errors
Edits
Dupes
Nightly
Nightly
Vendor reports
TIS
SFG database support
SFG FTP server
SFG internal
hygiene processes
SFG
reporting systems
SFG
exception processes
SFG web services
SFG web services
____________________
SFG Services - Travel Information System & Process
Vendor
suppliers
=
Phone center
+
Reader cards services
+
LITS
inventory
Bad File
Errors
Edits
Dupes
TICS
entry
.....................
_______
Nightly
Nightly
_______________________________
Fulfillment company
Format B (daily)
Format A (daily)
Format C (daily)
Web
site/services
Vendor reports
1:00 a.m. daily order fulfillment
Inventory file feed
TIS
SFG database support
SFG FTP server
SFG internal
hygiene processes
SFG
reporting systems
SFG
exception processes
SFG web services
SFG web services
.....................
Web
site/services
Complete Solution - Travel Information System & Process
Vendor
suppliers
=
Phone center
+
Reader cards services
+
LITS
Inventory
TICS
entry
Format B (daily)
Format A (daily)
Format C (daily)
Bad File
Errors
Edits
Dupes
Nightly
Nightly
Vendor reports
TIS
SFG database support
SFG FTP server
SFG internal
hygiene processes
SFG
reporting systems
SFG
exception processes
SFG web services
SFG web services
Travel Literature Fulfillment Process
TIS
FTP
server

Inventory file by package number
Customer
Process#/order#
Fulfillment flag
Special/promo
inserts
Trigger email confirmation to customer?
Fulfillment process
300 packages for best postage rates

72-hour turnaround
VS.
(M/W/F usually)
Email shipment confirmation

Sent summary
SFG services - Travel Literature Fulfillment Process
TIS
SFG FTP server
Inventory file by package number
Customer
Process#/order#
Fulfillment flag
Special/promo
inserts
Trigger email confirmation to customer?
300 packages for best postage rates

72-hour turnaround
VS.
(M/W/F usually)
SFG
reporting system
SFG
reporting system
SFG email shipping confirmation
SFG fulfillment processing
.......................
Web
site/services
System, Process, Access, Fulfillment
Vendor
suppliers
=
Phone center
+
Reader cards services
+
LITS
Inventory
Format B (daily)
Format A (daily)
Format C (daily)
Bad File
Errors
Edits
Dupes
Nightly
Nightly
Vendor reports
Customer
Process#/order#
Fulfillment flag
Inventory file by package number
TIS
SFG database support
SFG FTP server
SFG internal
hygiene processes
SFG
reporting systems
SFG
exception processes
SFG web services
(every 4 hours)
SFG web services
Trigger email confirmation to customer?
Fulfillment process
Shipment
Special/promo
inserts
300 packages for best postage rates

72-hour turnaround
FTP server
Web services
Exception processes
Reporting systems
Database support
Internal hygiene processes
Trigger email confirmations to customers
Special promo inserts
Fulfillment processing
SFG Fulfillment Process & Database Flow
Accessing TIS
Subscribers
Admin users
Governor's Office Users
WWW
TX Travel Info Users
Submit orders on behalf of consumers
Reports
FTP data to RUF
FTP monthly ROI
Reports
Access
TIS
Postage report daily
(on fulfillment days)
TXDOT team input
SFG fulfillment process
Shipment
TXDOT team input
SFG
reporting system
Email shipment confirmation
Sent summary
Postage report daily
(on fulfillment days)
SFG
reporting system
SFG database support
Vendor
suppliers
Internal/External system users
TXDOT team input
Accessing TIS
Query File
Subscribers
Currently semicolon delimited
Prefer Excel format
Admin users
Governor's Office Users
WWW
TX Travel Info Users
Submit orders on behalf of consumers
Reports
FTP data to RUF
FTP monthly ROI
Reports
Access
TIS
SFG web services
SFG reporting
SFG reporting
SFG reporting
SFG web services
Query File
Currently semicolon delimited
Prefer Excel format
Admin users
Reports
Access
TX Travel Info Users
Submit orders on behalf of consumers
Subscribers
Governor's Office Users
Reports
FTP data to RUF
FTP monthly ROI
Admin users
Reports
Access
TX Travel Info Users
Submit orders on behalf of consumers
Subscribers
Governor's Office Users
Reports
FTP data to RUF
FTP monthly ROI
TXDOT team input
Full transcript