Sundial Support Help Center

Knowledgebase Home | Glossary | Favorites | Login Knowledgebase Home | Glossary | Favorites | Login Welcome to our knowledge base. To find what you're after, use the search box below or choose a category to view listed articles. Search the Knowledgebase Browse by Category [Advanced Search] -- Select Category -- GeneralHardware and Software    - Time Clock Software        - Data Exports        - Realtime Advanced            - Day to Day            - Instaltaion            - Realtime Advance Known Errors            - Realtime Advanced Communications            - Special Functions    - Time Clocks        - Software TimeclockNetworking and Communications Knowledgebase Home > Hardware and Software > Time Clock Software > Data Exports RealTime Advanced 3.x: Export Ascii detail format Article Details Last Updated 21st o May, 2008 Would you like to... Print this page Email this page Post a comment Subscribe me Add to favorites Remove Highlighting Edit this Article Quick Edit Export to PDF User Opinions ( ) How would you rate this answer? Helpful Not helpful Help us improve. Why was this unhelpful? Thank you for rating this answer. The Field Layout is presented below, and is exported in comma delimited format  The infomation in the brackets describes the source of the field.  Some fields are no longer used and may be empty when exported.  Each line is from a specific punch transaction. Card ID, [Employee Badge ID] Date In Time In DAte Out TIme Out TotalDol, [Not Used] Rate1, [Employee's Payrate, Adjusted by Variable Rate System] RegT, [Regular Hours] OT, [Overtime Hours] DT, [Double Time Hours] Other ID, [Employee's Export Code] Name, [Employee Name] Department, [Department Code if asigned to a Punch Transaction] DeptCodes_Dept Description, [Department Description associated with the code in Department] Counter, [AutoNumber from Punch Table] Punch Type, [Code from Punch Table indicating Type of Transaction] Tips, [Monetary Amount of Tips] Advances, [Monetary Amount of Advance] Other, [Monetary Amount of Other] Card IDZ, [Employee's Badge ID - Same as above Card ID] Dept, [Department Code of Punch, otherwise Home Department code] ActualDeptDesc, [Description associated with code in Dept] Home Department, [Employee's Home Department Code] DeptCodes_1_Dept Description, [Department Description associated to Home Department Code] Lunch, [Amount of Lunch Hours if line is a Lunch Deduction record] Total Time, [Calculated Hours for Transaction, Negative for Lunch Deductions, Empty for Punched Lunches or Breaks] Wk, [Not Used] JobNum, [Job Number from Punch Transaction] JobDescription, [Job Description asociated with JobNum] Notes, [Notes from Punch Transaction] ShiftNo, [Shift number assigned to Employee] Assignment, [Not Used] ExceptionType, [Not Used] SchedNo, [Employee's Schedule Number] Vacation, [Vacation Hours] Sick, [Sick Hours] Holiday, [Holiday Hours] Bonus, [Bonus Hours] Personal, [Personal Hours] Level4, [Not Used - Work Order Code from TRANZ clock] Level5, [Not Used - Task Code from TRANZ clock] Quantity, [Count Data from Punch transaction] ShiftDiff, [True, False - from Employee's Differential setting, or empty] ShiftDiffHours, [Number of Hours qualifying for Differential] ShiftDiffAmount, [Amount of Differential] StartDateTime, [Combined Date In and Time In] EndDateTime, [Combined Date Out and Time Out] RIN, [Rounded Date/Time In] ROUT, [Rounded Date/Time Out] Break, [Calcualted Hours for Break Punches] TransactionDate, [Date/Time stamp of first transaction of WorkShift] Restricted, [False] TotalTime, [Amount of User Override of Calcualtion] BaseRate, [Employee's Base Rate of Pay] Money, [Monetary Calculation for Transaction (Hours * Rate1)] Visitor Comments No visitor comments posted. Post a comment Post Comment for "RealTime Advanced 3.x: Export Ascii detail format" To post a comment for this article, simply complete the form below. Fields marked with an asterisk are required.    Your Name:    Email Address: * Your Comment: * Enter the code below:   Related Articles No related articles were found. Attachments No attachments were found. Continue

Powered by Interspire Knowledge Manager Knowledgebase Software

Sundial Employee Time Clock selection