Payroll Database Maintenance

Payroll Database Maintenance

Field in atrieveERP	Report Writer Table	Report Writer Field	Field Information
Expense Sub-Ledger Account (formatted)	STORAGE_BANK_TABLE_CODE	EXPENSE_SL_ACCOUNT_FORMATTED	Sub-Ledger account to which the accrual storage bank amount is expensed Size: 10

Bank Cycle Code

Field in atrieveERP	Report Writer Table	Report Writer Field	Field Information
Storage Bank Cycle	BANK_CYCLE_CODE	BANK_CYCLE_CODE	Size: 10
Storage Bank Cycle Description	BANK_CYCLE_CODE	BANK_CYCLE_DESC	Size: 30

Deduction Code

Field in atrieveERP	Report Writer Table	Report Writer Field	Field Information
Code	DEDUCTION_CODE	DEDUCTION_CODE	Size: 8
Description	DEDUCTION_CODE	DEDUCTION_DESC	Size: 30
Short Desc	DEDUCTION_CODE	SHORT_DESC	Size: 10
Group	DEDUCTION_CODE	GROUP_CODE	Size: 10
Type	DEDUCTION_CODE	TYPE	Size: 4
Freq	DEDUCTION_CODE	FREQUENCY	Size: 4
Table	DEDUCTION_CODE	TABLE	Y=Yes, N=No, Size: 5
Register	DEDUCTION_CODE	REGISTER	Y=Yes, N=No, Size: 8
Factor	DEDUCTION_CODE	FACTOR	Size: 10 Format: ######.####
Limit	DEDUCTION_CODE	LIMIT	Size: 10 Format: ########.##
Share %	DEDUCTION_CODE	EMPLOYER_SHARE	Size: 10
Vendor #	DEDUCTION_CODE	VENDOR_NO	Size: 10
Arrears	DEDUCTION_CODE	ARREARS	Size: 6
Arrears Deduction	DEDUCTION_CODE	ARREARS_DEDUCTION_CODE	Only available when Arrears = S Size: 10
Zero Balances	DEDUCTION_CODE	ZERO_BALANCES	Size: 10
Field Lock	DEDUCTION_CODE	FIELD_LOCK	Size: 10
Step [Fac/Lim,]	DEDUCTION_CODE	STEP	Size: 10
Extras	DEDUCTION_CODE	EXTRA_PARAMETERS	Size: 10
GL Expense	DEDUCTION_CODE	EXPENSE_GL_ACCOUNT	Size: 20
GL Expense	DEDUCTION_CODE	EXPENSE_GL_ACCOUNT_FORMATTED	Formatted Size: 20
GL Expense	DEDUCTION_CODE	EXPENSE_SL_ACCOUNT	Size: 10
GL Expense	DEDUCTION_CODE	EXPENSE_SL_ACCOUNT_FORMATTED	Formatted Size: 10
GL Liab.	DEDUCTION_CODE	LIABILITY_GL_ACCOUNT	Size: 20
GL Liab.	DEDUCTION_CODE	LIABILITY_GL_ACCOUNT_FORMATTED	Formatted Size: 20
GL Liab.	DEDUCTION_CODE	LIABILITY_SL_ACCOUNT	Size: 10
GL Liab.	DEDUCTION_CODE	LIABILITY_SL_ACCOUNT_FORMATTED	Formatted Size: 10
Earn [I/EE,EE,]	DEDUCTION_CODE	EARNINGS_LIST	Size: 10
Earn [I/EE,EE,] (1st Line)	DEDUCTION_CODE	INCLUDE_EARNINGS_CODE	Size: 8
Earn [I/EE,EE,] (2nd Line)	DEDUCTION_CODE	ADDITIONAL_EARNINGS_LIST	Size: 10
Deds [i/DD,DD,]	DEDUCTION_CODE	DEDUCTIONS_LIST	Size: 10
Deds [i/DD,DD,] (1st Line)	DEDUCTION_CODE	INCLUDE_DEDUCTIONS_CODE	Size: 7
Deds [i/DD,DD,] (2nd Line)	DEDUCTION_CODE	ADDITIONAL_DEDUCTION_LIST	Size: 10
Registration #	DEDUCTION_CODE	REGISTRATION_NO	Size: 10
External Name	DEDUCTION_CODE	EXTERNAL_NAME	Size: 30
RPP Maximum	DEDUCTION_CODE	RPP_MAX	Size: 10 Format: ########.##

Deduction Rate Table

Field in atrieveERP	Report Writer Table	Report Writer Field	Field Information
Deduction Code	DEDUCTION_TABLE_CODE	DEDUCTION_CODE	Size: 8
Table Code	DEDUCTION_TABLE_CODE	DEDUCTION_TABLE_CODE	Size: 5
Short Description	DEDUCTION_TABLE_CODE	SHORT_DESCRIPTION	Size: 20
Table Description	DEDUCTION_TABLE_CODE	DEDUCTION_TABLE_DESC	Size: 30
Amount	DEDUCTION_TABLE_CODE	DEDUCTION_AMOUNT	Size: 10 Format: ########.##
Vendor #	DEDUCTION_TABLE_CODE	VENDOR_NO	Size: 10
Employer Share	DEDUCTION_TABLE_CODE	EMPLOYER_SHARE_PERCENT	Size: 10

Employee Code

Field in atrieveERP	Report Writer Table	Report Writer Field	Field Information
Employee Code	EMPLOYEE_TYPE_CODE	EMPLOYEE_TYPE_CODE	Size: 8
Employee Code Description	EMPLOYEE_TYPE_CODE	EMPLOYEE_TYPE_DESC	Size: 30
Base Hours	EMPLOYEE_TYPE_CODE	BASE_HOURS	Size: 10 Format: ########.##
Maximum Credit	EMPLOYEE_TYPE_CODE	MAX_CREDIT	Size: 10 Format: ########.##
Contributor Months	EMPLOYEE_TYPE_CODE	CONTRIBUTOR_MONTHS	Size: 10 Format: ########.##

Frequency Code

Field in atrieveERP	Report Writer Table	Report Writer Field	Field Information
Frequency Code	FREQUENCY_CODE	FREQUENCY_CODE	Size: 10
Frequency Code Description	FREQUENCY_CODE	FREQUENCY_CODE_DESC	Size: 30

Location Code

Field in atrieveERP	Report Writer Table	Report Writer Field	Field Information
Location Code	LOCATION_CODE	LOCATION_CODE	Size: 10
Location Code	LOCATION_CODE	LOCATION_DESC	Size: 30
Alternate Sort Code	LOCATION_CODE	ALTERNATE_SORT_CODE	Size: 10

Occupation Code

Field in atrieveERP	Report Writer Table	Report Writer Field	Field Information
Occupation Code	OCCUPATION_CODE	OCCUPATION_CODE	Size: 4
Occupation Description	OCCUPATION_CODE	OCCUPATION_DESC	Size: 30
Factor	OCCUPATION_CODE	FACTOR	Size: 10
Calculation Code [*+R]	OCCUPATION_CODE	CALCULATION_CODE	Size: 10
Pay Code 1	OCCUPATION_CODE	PAY_CODE	Size: 8

Pay Code

Field in atrieveERP	Report Writer Table	Report Writer Field	Field Information
Pay Code	PAY_CODE	PAY_CODE	Size: 3
Description	PAY_CODE	PAY_CODE_DESC	Size: 30
Factor	PAY_CODE	FACTOR	Size: 10
Calculation Code	PAY_CODE	CALCULATION_CODE	Size: 10
Type of Code	PAY_CODE	TYPE_CODE	Size: 4
GL Expense Account	PAY_CODE	GL_EXPENSE_ACCOUNT	Size: 20
GL Expense Account	PAY_CODE	SL_EXPENSE_ACCOUNT	Size: 10
GL Expense Account (Formatted)	PAY_CODE	GL_EXPENSE_ACCOUNT_FORMATTED	Size: 20
GL Expense Account (Formatted)	PAY_CODE	SL_EXPENSE_ACCOUNT_FORMATTED	Size: 10
Override EI Allocation	PAY_CODE	UIC_ALLOCATION_CODE	Size: 10
Hours EI Insurable	PAY_CODE	HOURS_EI_INSURABLE	Y=Yes, N=No, Size: 10
Unit Factor	PAY_CODE	UNIT_FACTOR	Size: 10
Hours Pensionable	PAY_CODE	HOURS_PENSIONABLE	Y=Yes, N=No, Size: 10
Pension Service Override	PAY_CODE	PENSION_OVERRIDE	Size: 10
Omit Benefit Costs	PAY_CODE	OMIT_BENEFIT_COSTS	Size: 10
Memo Field	PAY_CODE	MEMO_FIELD	Size: 30
Bank Transactions [D###/W##.##...]	PAY_CODE	BANKS_TRANS	Size: 30

Pay Cycle Code

Field in atrieveERP	Report Writer Table	Report Writer Field	Field Information
Pay Cycle Code	PAY_CYCLE_CODE	PAY_CYCLE_CODE	Size: 5
Pay Cycle Code Description	PAY_CYCLE_CODE	PAY_CYCLE_CODE_DESC	Size: 30
Number of Periods	PAY_CYCLE_CODE	NUMBER_OF_PERIODS	Size: 7 Format: ###########
Days Or Hours	PAY_CYCLE_CODE	DAYS_OR_HOURS	Size: 10
Number of Hours To A Day	PAY_CYCLE_CODE	HOURS_PER_DAY	Size: 10 Format: ########.##
Current Tax Period	PAY_CYCLE_CODE	CURRENT_TAX_PERIOD	Size: 10
Number Of Salary Periods	PAY_CYCLE_CODE	NUMBER_OF_SALARY_PERIODS	Size: 10 Format: ########.##

Payroll Calendar

Field in atrieveERP	Report Writer Table	Report Writer Field	Field Information
Acct Period	CALENDAR_CODE	ACCOUNTING_PERIOD	Size: 10
Bank Clear	CALENDAR_CODE	BANK_CLEAR	Size: 10
Bank Cycles	CALENDAR_CODE	BANK_CYCLES	Size: 10
Bank Payout	CALENDAR_CODE	BANK_PAYOUT	Size: 10
Bank Year	CALENDAR_CODE	BANK_YEAR	Size: 10
Cheque Date	CALENDAR_CODE	CHEQUE_DATE	Size: 11 Format: DD-MMM-YYYY
Deduction Frequencies	CALENDAR_CODE	DEDUCTION_FREQUENCIES	Size: 10
Override to Cheque	CALENDAR_CODE	OVERRIDE_TO_CHEQUE	Size: 10
Pay Cycle	CALENDAR_CODE	PAY_CYCLE_CODE	Fields: 08,11,14,17,20,23,26,29,32,35,38) Size: 5
Pay End Date	CALENDAR_CODE	PAY_END_DATE	Fields: 10,13,16,19,22,25,28,31,34,37,40 Size: 11 Format: DD-MMM-YYYY
Pay Period	CALENDAR_CODE	PAY_PERIOD	Size: 6
Pay Start Date	CALENDAR_CODE	PAY_START_DATE	Fields: 09,12,15,18,21,24,27,30,33,36,39 Size: 11 Format: DD-MMM-YYYY
Field in atrieveERP	Report Writer Table	Report Writer Field	Field Information
Salary Grid	CALENDAR_CODE	SALARY_GRID_NO	Size: 8
Supplement to Mail	CALENDAR_CODE	SUPPLEMENT_TO_MAIL	Size: 10
Working Days	CALENDAR_CODE	WORKING_DAYS	Size: 10 Format: ########.##

Salary Grid

Field in atrieveERP	Report Writer Table	Report Writer Field	Field Information
Salary Grid	SALARY_GRID_CODE	SALARY_GRID_CODE	Size: 10
Salary Grid Description	SALARY_GRID_CODE	SALARY_GRID_DESC	Size: 30
Base Salary for Grid Point 1	SALARY_GRID_CODE	SALARY_1	Size: 10 Format: ########.##
Base Hours for Grid Point 1	SALARY_GRID_CODE	HOURS_1	Size: 10 Format: ########.##
Base Salary for Grid Point 2	SALARY_GRID_CODE	SALARY_2	Size: 10 Format: ########.##
Base Hours for Grid Point 2	SALARY_GRID_CODE	HOURS_2	Size: 10 Format: ########.##
Base Salary for Grid Point 3	SALARY_GRID_CODE	SALARY_3	Size: 10 Format: ########.##
Base Hours for Grid Point 3	SALARY_GRID_CODE	HOURS_3	Size: 10 Format: ########.##
Base Salary for Grid Point 4	SALARY_GRID_CODE	SALARY_4	Size: 10 Format: ########.##
Base Hours for Grid Point 4	SALARY_GRID_CODE	HOURS_4	Size: 10 Format: ########.##
Base Salary for Grid Point 5	SALARY_GRID_CODE	SALARY_5	Size: 10 Format: ########.##
Base Hours for Grid Point 5	SALARY_GRID_CODE	HOURS_5	Size: 10 Format: ########.##
Base Salary for Grid Point 6	SALARY_GRID_CODE	SALARY_6	Size: 10 Format: ########.##
Base Hours for Grid Point 6	SALARY_GRID_CODE	HOURS_6	Size: 10 Format: ########.##
Base Salary for Grid Point 7	SALARY_GRID_CODE	SALARY_7	Size: 10 Format: ########.##
Base Hours for Grid Point 7	SALARY_GRID_CODE	HOURS_7	Size: 10 Format: ########.##
Base Salary for Grid Point 8	SALARY_GRID_CODE	SALARY_8	Size: 10 Format: ########.##
Base Hours for Grid Point 8	SALARY_GRID_CODE	HOURS_8	Size: 10 Format: ########.##
Base Salary for Grid Point 9	SALARY_GRID_CODE	SALARY_9	Size: 10 Format: ########.##
Base Hours for Grid Point 9	SALARY_GRID_CODE	HOURS_9	Size: 10 Format: ########.##
Base Salary for Grid Point 10	SALARY_GRID_CODE	SALARY_10	Size: 10 Format: ########.##
Base Hours for Grid Point 10	SALARY_GRID_CODE	HOURS_10	Size: 10 Format: ########.##
Base Salary for Grid Point 11	SALARY_GRID_CODE	SALARY_11	Size: 10 Format: ########.##
Base Hours for Grid Point 11	SALARY_GRID_CODE	HOURS_11	Size: 10 Format: ########.##
Base Salary for Grid Point 12	SALARY_GRID_CODE	SALARY_12	Size: 10 Format: ########.##
Base Hours for Grid Point 12	SALARY_GRID_CODE	HOURS_12	Size: 10 Format: ########.##

Shift Code

Field in atrieveERP	Report Writer Table	Report Writer Field	Field Information
Shift Code	SHIFT_CODE	SHIFT_CODE	Size: 10
Shift Code Description	SHIFT_CODE	SHIFT_CODE_DESC	Size: 30
Factor	SHIFT_CODE	FACTOR	Size: 10
Calculation Code	SHIFT_CODE	CALCULATION_CODE	Size: 10
Pay Code	SHIFT_CODE	PAY_CODE	Size: 8

Storage Bank Control

Field in atrieveERP	Report Writer Table	Report Writer Field	Field Information
Bank Code	STORAGE_BANK_CODE	STORAGE_BANK_CODE	Size: 4
Description	STORAGE_BANK_CODE	STORAGE_BANK_DESC	Size: 30
Bank Type	STORAGE_BANK_CODE	BANK_TYPE	[A/I/P/D/G/S] Size: 4
Transactions	STORAGE_BANK_CODE	TRANSACTION_TYPE	[H/E] H = To accumulate hourly totals; E = to accumulate earnings totals; HE or EH = To accumulate hours and earnings totals Size: 8
Bank Cycle	STORAGE_BANK_CODE	BANK_CYCLE_CODE	Size: 5
Rollover Bank	STORAGE_BANK_CODE	ROLLOVER_BANK_CODE	Size: 10
Increment by % [Y/N]	STORAGE_BANK_CODE	INCREMENT_BY_BASE_HOURS	Size: 10
%Hour Base Hours [####.##]	STORAGE_BANK_CODE	INCREMENT_BASE_HOURS	Size: 10
All/Paid Employees	STORAGE_BANK_CODE	ALL_OR_PAID_EMPS	Size: 10
Accrual Hours [I/Ecc,cc,]	STORAGE_BANK_CODE	EARNINGS_INCLUDE_OR_EXCLUDE	Size: 10
Accrual Hours [I/Ecc,cc,]	STORAGE_BANK_CODE	HOURS_INCLUDE_OR_EXCLUDE	Size: 10
Accrual Hours [I/Ecc,cc,] (Line 1)	STORAGE_BANK_CODE	EARNS_INCLUDE_EXCLUDE_LIST1	Size: 30
Accrual Hours [I/Ecc,cc,] (Line 1)	STORAGE_BANK_CODE	HOURS_INCLUDE_EXCLUDE_LIST1	Size: 30
Accrual Hours [I/Ecc,cc,] (Line 2)	STORAGE_BANK_CODE	EARNS_INCLUDE_EXCLUDE_LIST2	Size: 30
Accrual Hours [I/Ecc,cc,] (Line 2)	STORAGE_BANK_CODE	HOURS_INCLUDE_EXCLUDE_LIST2	Size: 30
Hours Bank Limit	STORAGE_BANK_CODE	HOURS_BANK_LIMIT	Size: 10 Format: ######.####
Earnings Bank Limit	STORAGE_BANK_CODE	EARNINGS_LIMIT	Size: 10
Print Balances [Y/N]	STORAGE_BANK_CODE	PRINT_BALANCE	Size: 8
Negative Balance [Y/N]	STORAGE_BANK_CODE	NEGATIVE_BALANCE	Size: 8
Pool Bank Code	STORAGE_BANK_CODE	POOL_BANK_CODE	Size: 8
Pool Table	STORAGE_BANK_CODE	POOL_BANK_TABLE_CODE	Size: 10
Pool Bank Limit	STORAGE_BANK_CODE	POOL_BANK_LIMIT	Size: 10
Pool Bank %	STORAGE_BANK_CODE	POOL_BANK_PERCENT	Size: 10
Multiiple Tables	STORAGE_BANK_CODE	MULTIPLE_TABLES	Size: 10
Year Limit Str Period	STORAGE_BANK_CODE	LIMIT_START_PERIOD	Size: 10
Year Limit End Period	STORAGE_BANK_CODE	LIMIT_END_PERIOD	Size: 10
Liability General Ledger account	STORAGE_BANK_CODE	LIABILITY_GL_ACCOUNT	Where the accrual storage bank amount is costed Size: 20
Liability General Ledger account	STORAGE_BANK_CODE	LIABILITY_GL_ACCOUNT_FORMATTED	Formatted account Where the accrual storage bank amount is costed Size: 20
Liability Sub Ledger account	STORAGE_BANK_CODE	LIABILITY_SL_ACCOUNT	Where the accrual storage bank amount is costed Size: 10
Liability Sub Ledger account	STORAGE_BANK_CODE	LIABILITY_SL_ACCOUNT_FORMATTED	Where the accrual storage bank amount is costed (Formatted) Size: 10
Pay code	STORAGE_BANK_CODE	PAYOUT_PAY_CODE	Defined as the code to payout storage bank balances Size: 10
Payout Current	STORAGE_BANK_CODE	PAYOUT_CURRENT	[Y/N] Y = Pay out current period accrual earnings amount along with the storage bank balance; N = to not pay out the current pay period accrual when the storage bank payout has been set but to store the current amount in the bank Size: 10
Payout Negative	STORAGE_BANK_CODE	PAYOUT_NEGATIVE	[Y/N] Y = Pay out negatives which will reduce an employee's cheque; N = to block negative balances from being paid out/recouped Size: 10

Storage Bank Table Control

Field in atrieveERP	Report Writer Table	Report Writer Field	Field Information
Bank Code	STORAGE_BANK_TABLE_CODE	STORAGE_BANK_CODE	Size: 4
Table Code	STORAGE_BANK_TABLE_CODE	STORAGE_BANK_TABLE_CODE	Size: 5
Description	STORAGE_BANK_TABLE_CODE	BANK_TABLE_DESC	Size: 30
All/Paid Employees	STORAGE_BANK_TABLE_CODE	ALL_OR_PAID_EMPS	Size: 10
Accrual Hours [I/Ecc,cc,]	STORAGE_BANK_TABLE_CODE	HOURS_INCLUDE_OR_EXCLUDE	Size: 10
Accrual Hours [I/Ecc,cc,] (Line 1)	STORAGE_BANK_TABLE_CODE	HOURS_INCLUDE_EXCLUDE_LIST1	Size: 30
Accrual Hours [I/Ecc,cc,] (Line 2)	STORAGE_BANK_TABLE_CODE	HOURS_INCLUDE_EXCLUDE_LIST2	Size: 30
Bank Cycle	STORAGE_BANK_TABLE_CODE	BANK_CYCLE_CODE	Code used to control the calculation of bank Size: 5
Bank List	STORAGE_BANK_TABLE_CODE	BANKS_LIST	List of banks that could trigger the storage bank table increment. Size: 10
Decimals	STORAGE_BANK_TABLE_CODE	DECIMALS_NO	limit amount applicable to this storage bank Size: 10 Format: ###########
Earn Percentage [%%.%%%%]	STORAGE_BANK_TABLE_CODE	EARNINGS_PCT	Percentage of earnings to be accrued Size: 10 Format: ########.##
Earning Increment	STORAGE_BANK_TABLE_CODE	EARNINGS_INCREMENT	Earning defined to increment into an employee's bank Size: 10 Format: ########.##
Earnings Table Limit	STORAGE_BANK_TABLE_CODE	EARNINGS_LIMIT	limit amount applicable to this storage bank Size: 10 Format: ########.##
Earnings Year Accr Limit	STORAGE_BANK_TABLE_CODE	EARNINGS_YEAR_LIMIT	Size: 10 Format: ######.####
End Earnings	STORAGE_BANK_TABLE_CODE	END_EARNINGS	The total earnings that must be accumulated before the employee will automatically increment to the next bank table. Size: 10 Format: ########.##
End Hours	STORAGE_BANK_TABLE_CODE	END_HOURS	The total hours that must be accumulated before the employee will automatically increment to the next bank table Size: 10 Format: ########.##
End Type	STORAGE_BANK_TABLE_CODE	END_TYPE_CODE	[Y/A] Y = The automatic table level increments based on years of service; A = automatic table level increments are to be defined based on the accumulated bank balance of another unrelated storage bank Size: 8
Expense GL Account	STORAGE_BANK_TABLE_CODE	EXPENSE_GL_ACCOUNT	General Ledger account to which the accrual storage bank amount is expensed Size: 20
Expense Sub-Ledger Account	STORAGE_BANK_TABLE_CODE	EXPENSE_SL_ACCOUNT	Sub-Ledger account to which the accrual storage bank amount is expensed Size: 10
Hours Increment	STORAGE_BANK_TABLE_CODE	HOURS_INCREMENT	Hours defined to increment into an employee's bank Size: 10 Format: ########.##
Hours Percent	STORAGE_BANK_TABLE_CODE	HOURS_PERCENT	Percentage of hours to be accrued Size: 10 Format: ########.##
Hours Table Limit	STORAGE_BANK_TABLE_CODE	HOURS_TABLE_LIMIT	limit amount applicable to this storage bank Size: 10 Format: ######.####
Hours Year Accr Limit	STORAGE_BANK_TABLE_CODE	HOURS_YEAR_LIMIT	limit amount applicable to this storage bank Size: 10
Increment Base Hours	STORAGE_BANK_TABLE_CODE	INCREMENT_BASE_HOURS	Max base hours Size: 10 Format: ########.##
Increment Earns Level	STORAGE_BANK_TABLE_CODE	INCREMENT_EARNING_LEVEL	Size: 10
Increment Hours Level	STORAGE_BANK_TABLE_CODE	INCREMENT_HOURS_LEVEL	Size: 10 Format: ######.####
Increment by Base Hours	STORAGE_BANK_TABLE_CODE	INCREMENT_BY_BASE_HOURS	[Y/N] Y = Do you want prorate increment setting Size: 10
Liability Sub-Ledger account	STORAGE_BANK_TABLE_CODE	LIABILITY_SL_ACCOUNT	Liability Sub Ledger account to which the accrual storage bank amount is costed Size: 10
Liability Sub-Ledget Account	STORAGE_BANK_TABLE_CODE	LIABILITY_SL_ACCOUNT_FORMATTED	Liability Sub Ledger account to which the accrual storage bank amount is costed Size: 10
Liablity GL Account	STORAGE_BANK_TABLE_CODE	LIABILITY_GL_ACCOUNT	Liability General Ledger account to which the accrual storage bank amount is costed Size: 20
Limit on rollver bank	STORAGE_BANK_TABLE_CODE	LIMIT_ON_ROLLOVER	Value to cap rollover bank Size: 8
Minimum Hours to start accrual	STORAGE_BANK_TABLE_CODE	MINIMUM_HOURS	Size: 10
Pay code (include/exclude)	STORAGE_BANK_TABLE_CODE	MASTER_TABLE_FOR_LIST	Default master Include/Exclude Pay Code list Size: 10
Payout Current period	STORAGE_BANK_TABLE_CODE	PAYOUT_CURRENT	[Y/N] Y = Pay out current period accrual earnings amount along with the storage bank balance; N = to not pay out the current pay period accrual when the storage bank payout has been set but to store the current amount in the bank Size: 6
Payout Negatives	STORAGE_BANK_TABLE_CODE	PAYOUT_NEGATIVE	[Y/N] Y = Pay out negatives which will reduce an employee's cheque; N = to block negative balances from being paid out/recouped Size: 7
Prorate Ern Inc by FTE	STORAGE_BANK_TABLE_CODE	PRORATE_PAY_BANK	Size: 10
Table End Dates	STORAGE_BANK_TABLE_CODE	END_DATE_LIST	C,C] H - Current Hire Date; O - Original Hire Date; S - Seniority Date; I - Increment Date; V - Vacation Date Size: 11
Table End Point [YYYYMMDD]	STORAGE_BANK_TABLE_CODE	TABLE_END_DATE	Size: 11 Format: DD-MMM-YYYY
Table End Years	STORAGE_BANK_TABLE_CODE	TABLE_END_YEARS	Number of years an employee is on this Storage Bank Table Size: 10
Transactions [H/E]	STORAGE_BANK_TABLE_CODE	TRANSACTION_TYPE_CODE	Size: 10

Field in atrieveERP	Report Writer Table	Report Writer Field	Field Information
Flat Is Hourly Rate	STORAGE_BANK_TABLE_CODE	RATE_IS_FLAT_AMOUNT	Size: 10
Pool Bank % [%%%.%%%%]	STORAGE_BANK_TABLE_CODE	POOL_BANK_PERCENT	Size: 10
Pool Bank Code	STORAGE_BANK_TABLE_CODE	POOL_BANK_CODE	Size: 8
Pool Bank Limit [Y/N]	STORAGE_BANK_TABLE_CODE	POOL_BANK_LIMIT	Size: 10
Pool Bank Table	STORAGE_BANK_TABLE_CODE	POOL_BANK_TABLE_CODE	Size: 10
Print Balances	STORAGE_BANK_TABLE_CODE	PRINT_BALANCE	Size: 8
Rollover Bank	STORAGE_BANK_TABLE_CODE	ROLLOVER_BANK_CODE	Size: 10

Storage Bank Table Control (Pay Bank)

Field in atrieveERP	Report Writer Table	Report Writer Field	Field Information
Accrual Hours [I/Ecc,cc,] (line 2)	STORAGE_BANK_TABLE_CODE	EARNS_INCLUDE_EXCLUDE_LIST2	Size: 30
Accrual Earn [I/Ecc,cc,]	STORAGE_BANK_TABLE_CODE	EARNINGS_INCLUDE_OR_EXCLUDE	Size: 10
Accrual Earn [I/Ecc,cc,] (line 1)	STORAGE_BANK_TABLE_CODE	EARNS_INCLUDE_EXCLUDE_LIST1	Size: 30
Pay Code	STORAGE_BANK_TABLE_CODE	PAYOUT_PAY_CODE	Size: 8