Employee-3 File Database Structure


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.


Custom Fields

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