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 |