Home » Categories » Solutions by Business Process » Finance » Payroll |
Employee-3 File Database Structure |
Article Number: 2093 | Rating: Unrated | Last Updated: Fri, Jun 16, 2023 at 4:29 PM
|
Datafile Software 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. |
Attachments
There are no attachments for this article.
|
Employee File – Full Screen Design (Premier only)
Viewed 1375 times since Tue, Mar 26, 2013
Copy Pay to EMP (1/2) - Copy Pay to EMP (2/2)
Viewed 1524 times since Wed, Mar 27, 2013
Expand Data Files
Viewed 2707 times since Wed, Mar 27, 2013
Employee Mandatory 4/4
Viewed 1532 times since Wed, Mar 27, 2013
Include Statutory Payments in Gross Pay
Viewed 5700 times since Mon, Jun 11, 2012
Employee Optional 4/11
Viewed 1542 times since Wed, Mar 27, 2013
NEW – Add New Employees
Viewed 2760 times since Tue, Mar 26, 2013
Submit P45 On-Line
Viewed 2870 times since Wed, Jun 13, 2012
Benefits in Kind / Company Cars
Viewed 1282 times since Mon, Jun 26, 2017
Taxation Table
Viewed 1645 times since Tue, Mar 26, 2013
|