Datafile Software
Employee-3 File Database Structure
This database is maintained and used by the system for
attachment of earnings orders. This list
allows you to see what the data items hold for use in reports and documents.
No Data Item Type Description
1 A1-NAME X (14) Description of the attachment order. You would print this label on your payslip.
2 A1-TYPE N Type of order
3 A1-PRIORITY ? Flag set if priority order
4 A1-METHOD X (1) Method of Deduction
5 A1-RATE K Rate of Deduction
6 A1-PROTECTED K Protected Earnings Amount or Percentage
7 A1-TOTAL K Total Amount to Repay
8 A1-DATE E Issue Date of the order
9 A1-REF X (14) Reference No of the order
10 A1-ADMIN K Administration charge to be deducted for the order
11 A1-CURR K Amount deducted in the current period. You would print this value on your payslip.
12 A1-YTD K Amount deducted for the year-to-date
13 A1-C/F K Amount not deducted this period due to insufficient funds (i.e. reached protected earnings level)
14 A1-ACCUM K Amount deducted in total for this order
15 A1-START E Start Date the order is to take effect
16 A1-END E End Date of the order.
17 A2-NAME X (14) Description of the attachment order. You would print this label on your payslip.
18 A2-TYPE N Type of order
19 A2-PRIORITY ? Flag set if priority order
20 A2-METHOD X (1) Method of Deduction
21 A2-RATE K Rate of Deduction
22 A2-PROTECTED K Protected Earnings Amount or Percentage
23 A2-TOTAL K Total Amount to Repay
24 A2-DATE E Issue Date of the order
25 A2-REF X (14) Reference No of the order
26 A2-ADMIN K Administration charge to be deducted for the order
27 A2-CURR K Amount deducted in the current period. You would print this value on your payslip.
28 A2-YTD K Amount deducted for the year-to-date
29 A2-C/F K Amount not deducted this period due to insufficient funds (i.e. reached protected earnings level)
30 A2-ACCUM K Amount deducted in total for this order
31 A2-START E Start Date the order is to take effect
32 A2-END E End Date of the order.
33 A3-NAME X (14) Description of the attachment order. You would print this label on your payslip.
34 A3-TYPE N Type of order
35 A3-PRIORITY ? Flag set if priority order
36 A3-METHOD X (1) Method of Deduction
37 A3-RATE K Rate of Deduction
38 A3-PROTECTED K Protected Earnings Amount or Percentage
39 A3-TOTAL K Total Amount to Repay
40 A3-DATE E Issue Date of the order
41 A3-REF X (14) Reference No of the order
42 A3-ADMIN K Administration charge to be deducted for the order
43 A3-CURR K Amount deducted in the current period. You would print this value on your payslip.
44 A3-YTD K Amount deducted for the year-to-date
45 A3-C/F K Amount not deducted this period due to insufficient funds (i.e. reached protected earnings level)
46 A3-ACCUM K Amount deducted in total for this order
47 A3-START E Start Date the order is to take effect
48 A3-END E End Date of the order.
49 A4-NAME X (14) Description of the attachment order. You would print this label on your payslip.
50 A4-TYPE N Type of order
51 A4-PRIORITY ? Flag set if priority order
52 A4-METHOD X (1) Method of Deduction
53 A4-RATE K Rate of Deduction
54 A4-PROTECTED K Protected Earnings Amount or Percentage
55 A4-TOTAL K Total Amount to Repay
56 A4-DATE E Issue Date of the order
57 A4-REF X (14) Reference No of the order
58 A4-ADMIN K Administration charge to be deducted for the order
59 A4-CURR K Amount deducted in the current period. You would print this value on your payslip.
60 A4-YTD K Amount deducted for the year-to-date
61 A4-C/F K Amount not deducted this period due to insufficient funds (i.e. reached protected earnings level)
62 A4-ACCUM K Amount deducted in total for this order
63 A4-START E Start Date the order is to take effect
64 A4-END E End Date of the order.
65 AEO-SEQ X (4) Sequence in which the orders are to be processed (if more than one).If left blank they are processed in the order 1234.
97 A1-CFPER K } If earnings are below the protected
98 A2-CFPER K } earnings level then the shortfall is carried
99 A3-CFPER K } forward to the next period and added to
100 A4-CFPER K } the protected earnings level for the next
} period.
103 A1-PROT% ? }
104 A2-PROT% ? } Flag to identify if the protected earnings
105 A3-PROT% ? } rate is a percentage rather than a fixed
106 A4-PROT% ? } amount.
Article ID: 2093
Created On: Wed, Mar 27, 2013 at 2:01 PM
Last Updated On: Fri, Jun 16, 2023 at 4:29 PM
Online URL: https://kb.datafile.co.uk/article/employee-3-file-database-structure-2093.html