Time Tracking Project

External Interface Specification: General Ledger Time Reporting 

Ronin International, Inc.

Version 1.0

 
Change History

Date	Version	Description	Author
May 1, 2002	1.0	Initial Draft	John Nalbone

 
General Ledger Time Reporting External Interface Specification

Identifier (A unique identifier for this External Interface)
EI10

Description (A couple of sentences or a paragraph describing the External Interface)
This External Interface describes the interface between the Time Tracking system and 
the General Ledger system. The General Ledger system will interface with the Time Tracking 
system to obtain employee billing data, which will feed the invoicing process, compensation 
process for hourly employees, etc.

Type (The type of interface, e.g., XML, JMS, Java API, Flat file, etc.)
Flat file

Direction (List the direction of the transfer)
The file will be created by the Time Tracking system and placed on an internal server 
for the General Ledger system to pick up.

Frequency (Approximately how often this interface is exercised, e.g., once a week, 
500 times a day, etc)
Weekly

Timing (List and specific time requirements)
The GL system will expect the file to be present by Monday morning.

Transfer Rate (List known or required transfer rates, e.g., must be able to load 
X records per minute)
N/A

Security (List known security issues, e.g., login required, firewalls, etc)
The file will be placed in the security portion of the network and will not require 
additional security measures.

Format (Describe in detail the format of the transfer, e.g., XML DTDs, file record layouts, etc. 
The data in this section will vary depending on the interface specifics.)

The files will be named in the following format:

	YYYYMMDD.time

where YYYY is the year, MM is the month (01 = January, etc.) and DD is the day of the month.

The file will be in the follow format:

   Data name    Type    Start column  End Column  Format
   Employee Id  Text    1             10          Left justified
   Client Id    Text    11            20          Left justified
   Day          Numeric 21            27          YYYYDDD, where YYYY is the year 
                                                   and DDD is the Julian day
   Hours worked Numeric 28            32          HH.HH, e.g., 08.50 is eight and 
                                                   one-half hours

Issues (List any "to dos", concerns to be addressed, etc.)
1.	

Decisions (List any important decisions made during the development of this interrace)
1.