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.
|
Special 161+ Print Items
Viewed 6221 times since Wed, Mar 27, 2013
Statutory Pay Schemes
Viewed 1850 times since Tue, Mar 26, 2013
Payslip Design - Document Design Manager
Viewed 3966 times since Wed, Mar 27, 2013
Submit P45 On-Line
Viewed 3105 times since Wed, Jun 13, 2012
Payroll Considerations - Employee File Data Items
Viewed 1833 times since Tue, Mar 26, 2013
Payroll Considerations - Link to Job Costing
Viewed 5684 times since Tue, Mar 26, 2013
AMEND – Amend Existing Employee Details
Viewed 1224 times since Tue, Mar 26, 2013
ALL – Amend All Employee Details
Viewed 1011 times since Tue, Mar 26, 2013
Employee Mandatory 4/4
Viewed 1741 times since Wed, Mar 27, 2013
Application User Facilities
Viewed 1762 times since Wed, Mar 27, 2013
|