Employee Import Field Specification.xls - IMS

							Required	Required
Column Name in	Key	Field	Data	Max	Min	Max	New	Existing	Values -	Values -
Header Record	Field	Type	Type	Width	Value	Value	Employee	Employee	New Employees	Existing Employees	Notes

Employee ID	Yes	D	Integer		1		No	Conditional	Blank	Blank or Valid Employee ID	Required for existing employee when no valid Employee Number or Surname/First Names/Birth Date provided
Employee Number	Yes	D	Integer		1	999999	No	Conditional	Blank or Valid Employee Number	Blank, Valid Employee Number, or ~ (to Clear value)	Requried for existing employee when no valid Employee ID or Surname/First Names/Birth Date provided
First Names	Yes	D	String	30			Yes	Conditional	Non-Blank	Blank or Valid First Names	Required for existing employee when no valid Employee ID or Employee Number provided
Surname	Yes	D	String	30			Yes	Conditional	Non-Blank	Blank or Valid Employee Surname	Required for existing employee when no valid Employee ID or Employee Number provided
Birth Date	Yes	D	Date				No	No	Blank or Valid Date	Blank, Valid Date or ~ (to Clear value)	Used to match employee if value present when no valid Employee ID or Employee Number provided
Address Line 1	No	D	String	30			No	No	Blank or Non-Blank	Blank or Non-Blank
Address Line 2	No	D	String	30			No	No	Blank or Non-Blank	Blank or Non-Blank
Address Line 3	No	D	String	30			No	No	Blank or Non-Blank	Blank or Non-Blank
Address Line 4	No	D	String	30			No	No	Blank or Non-Blank	Blank or Non-Blank
Gender	No	D	String	1			Yes	No	M(ale) / F(emale) / A(nother)	Blank, M(ale) / F(emale) / A(nother)
Home Phone	No	D	String	13			No	No	Blank or Non-Blank	Blank, Non-Blank or ~ (to Clear value)
Occupation	No	D	String	30			Yes	No	Blank or Non-Blank	Blank or Non-Blank
Pay Point	No	D	String	30			Yes	No	Valid Pay Point Name	Blank or Name of Valid Pay Point
Costing Code	No	D	String	20			Yes	No	Valid Costing Code	Blank or Valid Costing Code	Field must be present but value only required if Costing is active in payroll company
Apprentice	No	D	String	1			Yes	No	Y(es) / N(o), T(rue) / F(alse)	Blank, Y(es) / N(o), T(rue) / F(alse)
Start Date	No	D	Date				Yes	No	Valid Date	Blank or Valid Date
Finish Date	No	D	Date				No	No	Blank or Valid Date	Blank, Valid Date or ~ (to Clear value)	Cannot be assigned in conjunction with applied or existing Due Back date
Finish Action	No	A	String	1			No	No	Blank, F(inish) or T(erminate) ***	Blank, F(inish) or T(erminate)	Blank unless Finish Date supplied. T terminates / F finishes and creates termination transactions.
Due Back	No	D	Date				No	No	Blank or Valid Date	Blank, Valid Date or ~ (to Clear value)	Cannot be assigned in conjunction with applied or existing Finish Date
Employee Type	No	D	String	1			Yes	No	S(alary) or W(age)	Blank, S(alary) or W(age)	If set to S - Salary must exist or be applied / if W - Hourly Pay Rate 1 must exist or be applied
Salary	No	D	Float - 2dp		0		Conditional	No	Employee Type W - Blank / Employee Type S - Money	Employee Type W - Blank / Employee Type S - Blank or Money
Hourly Pay Rate 1	No	D	Float - 4dp		0		Conditional	No	Employee Type S - Blank or Money / Employee Type W - Money	Employee Type S - Blank or Money / Employee Type W - Blank or Money
Hourly Pay Rate 2	No	D	Float - 4dp		0		No	No	Blank or Money	Blank or Money
Hourly Pay Rate 3	No	D	Float - 4dp		0		No	No	Blank or Money	Blank or Money
Hourly Pay Rate 4	No	D	Float - 4dp		0		No	No	Blank or Money	Blank or Money
Hourly Pay Rate 5	No	D	Float - 4dp		0		No	No	Blank or Money	Blank or Money
Pay Frequency	No	D	String	1			Yes	No	W(eekly), F(ortnightly), H(alf monthly), Q(4 weekly) or M(onthly)	Blank, W(eekly), F(ortnightly), H(alf monthly), Q(4 weekly) or M(onthly)
Tax Code	No	D	String	5			No	No	Blank or Valid Tax Code ***	Blank or Valid Tax Code
IRD Number	No	D	String	9			Yes	No	Valid IRD Number	Blank or Valid IRD Number	If set to "000000000" Tax Code will be overridden to "ND" (No Notification) if Tax Code not "WT", "NSW" or "ND"
Tax Override Rate PAYE	No	D	Float - 4dp		0	100	No	No	Blank or Valid Percentage	Blank, Valid Percentage or ~ (to Clear value)	required for "WT" Tax Code,
Tax Override Rate SLRD	No	D	Float - 4dp		0	100	No	No	Blank or Valid Percentage	Blank, Valid Percentage or ~ (to Clear value)
Tax Override Rate EMOL	No	D	Float - 4dp		0	100	No	No	Blank or Valid Percentage	Blank, Valid Percentage or ~ (to Clear value)
Payment Method	No	D	String	1			Yes	No	B(ank), Q(cheque) or C(ash)	Blank, B(ank), Q(cheque) or C(ash)	If set to B - Bank Account number must already exist or be applied by import
Bank Account	No	D	String	16			Conditional	No	For Payment Method B - Valid Account / Otherwise Blank	Payment Method B - Valid Account / Otherwise - Blank or ~(to Clear value)	15 digit (2 digit suffix) or 16 digit (3 digit suffix) account number e.g. 123075011451600 (ASB has 2 digit suffix)
Bank Reference	No	D	String	12			No	No	Blank or Non-Blank	Blank, Non-Blank or ~ (to Clear value)
Bank Particulars	No	D	String	12			No	No	Blank or Non-Blank	Blank, Non-Blank or ~ (to Clear value)
Bank Code	No	D	String	12			No	No	Blank or Non-Blank	Blank, Non-Blank or ~ (to Clear value)
Hours Worked Per Day	No	D	Float - 2dp				Yes	No	Valid Hours	Blank or Valid Hours	Depends on Annual Leave Type and Annual Leave Units
Hours Worked Per Period	No	D	Float - 2dp				Yes	No	Valid Hours	Blank or Valid Hours	Depends on Annual Leave Type and Annual Leave Units
Annual Leave Type	No	D	String	1			Yes	No	F(Permanent Set Hours), P(Permanent Variable Hours) or C(asual)	Blank, F(Permanent - Set Hours), P(Permanent - Variable Hours) or C(asual)
Annual Leave Units	No	D	String	1			Yes	No	D(ays) or H(ours)	Blank, D(ays) or H(ours)
AL % of Gross	No	D	Float		0	100	No	No	Blank or Valid Percentage	Blank or Valid Percentage
AL Full Entitlement	No	D	Float - 2dp				No	No	Blank or Valid Days or Hours value	Blank or Valid Days or Hours value	Depends on Annual Leave Type and units depend on Annual Leave Units
AL Next Entitlement	No	D	Float - 2dp				No	No	Blank or Valid Days or Hours value	Blank or Valid Days or Hours value	Depends on Annual Leave Type and units depend on Annual Leave Units
AL Due Date	No	D	Date				No	No	Blank or Valid Date	Blank or Valid Date
AL For (Weeks)	No	D	Integer		0	52	No	No	Blank or Valid Number of Weeks	Blank or Valid Number of Weeks	Depends on Annual Leave Type
AL Outstanding Ent	No	D	Float - 2dp		0		No	No	Blank or Valid Days or Hours value	Blank or Valid Days or Hours value	Depends on Annual Leave Type and units depend on Annual Leave Units
AL Paid In Advance	No	D	Float - 2dp		0		No	No	Blank or Valid Days or Hours value	Blank or Valid Days or Hours value	Depends on Annual Leave Type and Annual Leave Units - Only if AL Outstanding Ent. = 0
AL Amount In Advance	No	D	Float - 2dp		0		No	No	Blank or Money	Blank or Money	Depends on Annual Leave Type and Annual Leave Units - Only if AL Outstanding Ent. = 0
AL Last Years Rate	No	D	Float - 2dp		0		No	No	Obsolete - Leave Blank	Obsolete	Obsolete - Value Ignored
AL Previous Years Rate	No	D	Float - 2dp		0		No	No	Obsolete - Leave Blank	Obsolete	Obsolete - Value Ignored
AL Gross Earnings	No	D	Float - 2dp		0		No	No	Blank or Money	Blank or Money
AL Hours	No	D	Float - 2dp		0		No	No	Blank or Valid Hours value	Blank or Valid Hours value	Depends on Annual Leave Type
AL Adjustment	No	D	Float - 2dp		0		No	No	Obsolete - Leave Blank	Blank or Money	Obsolete - Value Ignored
Sick Leave Units	No	D	String	1			No	No	Blank, D(ays) or H(ours)	Blank, D(ays) or H(ours)
SL Full Entitlement	No	D	Float - 2dp		0		No	No	Blank or Valid Days or Hours value	Blank or Valid Days or Hours value	Units depend on Sick Leave Units
SL Next Entitlement	No	D	Float - 2dp		0		No	No	Blank or Valid Days or Hours value	Blank or Valid Days or Hours value	Units depend on Sick Leave Units
SL Due Date	No	D	Date				No	No	Blank or Valid Date	Blank or Valid Date
SL Months	No	D	Integer		0	12	No	No	Blank or Valid Number of Months	Blank or Valid Number of Months
SL Maximum	No	D	Float - 2dp		0		No	No	Blank or Valid Days or Hours value	Blank or Valid Days or Hours value	Units depend on Sick Leave Units (zero (0) = no maximum)
SL % of Gross	No	D	Float - 4dp		0	100	No	No	Blank or Valid Percentage	Blank or Valid Percentage	Only valid for Annual Leave Type P
Sick Leave Balance	No	D	Float - 2dp		0		No	No	Blank or Valid Days or Hours value	Blank or Valid Days or Hours value	Units depend on Sick Leave Units. Enter a negative sign in front of Units to import a negative balance eg: -5
Alternative Leave Balance	No	D	Float - 2dp		0		No	No	Blank or Valid Days or Hours value	Blank or Valid Days or Hours value	Units depend on Alternative Leave Units
Alternative Leave Units	No	D	String	1			No	No	D(ays) or H(ours)	Blank, D(ays) or H(ours)
Email Address	No	D	String	60			No	No	Blank or Non-Blank	Blank or Non-Blank
Email Payslip	No	D	String	1			Yes	No	Y(es) / N(o), T(rue) / F(alse)	Blank, Y(es) / N(o), T(rue) / F(alse)	Email Address required if set to "Y" or "T"
GSCM	No	D	String	1			Yes	No	Y(es) / N(o), T(rue) / F(alse)	Blank, Y(es) / N(o), T(rue) / F(alse)	Only applies only to salaried employees
STC Expiry Date	No	D	Date				Conditional	Conditional	Tax Code STC - Valid Date / Otherwise Blank	Tax Code STC - Valid Date / Otherwise Blank
Home Phone 2	No	D	String	13			No	No	Blank or Non-Blank	Blank, Non-Blank or ~(to Clear value)
ACC Class Unit	No	D	String	6			No	No	Blank or any ACC Classification Unit code	Blank or any ACC Classification Unit code
Use Average Daily Pay	No	D	String	1			Yes	No	Y(es) / N(o), T(rue) / F(alse)	Blank, Y(es) / N(o), T(rue) / F(alse)
Time in Lieu Units	No	D	String	1			Yes	No	D(ays) or H(ours)	Blank, D(ays) or H(ours)
Time in Lieu Pay On Termination	No	D	String	1			Yes	No	Y(es) / N(o), T(rue) / F(alse)	Blank, Y(es) / N(o), T(rue) / F(alse)
Time in Lieu Balance	No	D	Float - 2dp		0		No	No	Blank or Valid Days or Hours value	Blank or Valid Days or Hours value	Units depend on Time in Lieu Units
Review Date	No	D	Date				No	No	Blank or Valid Date	Blank, Valid Date or ~ (to Clear value)
Contract	No	D	String	30			No	No	Blank or Non-Blank	Blank or Non-Blank	Contract will be added to Employee Contracts list if it doesn't already exist
Preferred Name	No	D	String	30			No	No	Blank or Non-Blank	Blank or Non-Blank
Super Scheme	No	D	String	15			No	No	Blank or Non-Blank	Blank or Non-Blank
Super Reference	No	D	String	12			No	No	Blank or Non-Blank	Blank or Non-Blank
Super Code	No	D	Integer		0		No	No	Blank or Valid PayElementID	Blank or Valid PayElementID	A valid superannuation type deduction
Super Calc Method	No	D	String	1			No	No	Blank, 'R'ated or 'F'ixed	Blank, 'R'ated or 'F'ixed
Super Percentage Rate	No	D	Float - 2dp		0		No	No	Blank or Valid Percentage	Blank or Valid Percentage	Depends on Super Calc Method
Super Earnings Type	No	D	Integer		1	5	No	No	Blank or 1 - 5	Blank or 1 - 5	Depends on Super Calc Method. Values are: Total Gross Earnings, Superable Earnings (DEFAULT), Taxable Earnings, Ordinary Earnings, Special Total, KS Employer Earnings, CF Employer Earnings, KS Employee Earnings, CF Employee Earnings.
Super Limit	No	D	Float - 2dp		0		No	No	Blank or Money	Blank or Money
Super Fixed Rate	No	D	Float - 2dp		0		No	No	Blank or Money	Blank or Money	Depends on Super Calc Method
Super GL Account	No	D	String	25			No	No	Blank or Non-Blank	Blank or Non-Blank	Only required if General Ledger is active in payroll company
Super Tax Method	No	D	String	1			No	No	Blank, 'E'xclusive (default), 'I'nclusive or Tax 'F'ree	Blank, 'E'xclusive (default), 'I'nclusive or Tax 'F'ree
Super Tax Rate Code	No	D	Integer		1	3	No	No	Blank, 1, 2, 3 or 4	Blank, 1, 2, 3 or 4	Codes: 1 = 10.5%, 2 = 17.5%, 3 = 30%, 4 = 33% (default)
KiwiSaver Entry Status	No	D	String	1			Yes	No	N'ot Eligible, 'A'uto Enrol, 'O'pt In or 'E'xisting	N'ot Eligible, 'A'uto Enrol, 'O'pt In or 'E'xisting
KiwiSaver Opt In Date	No	D	Date				Conditional	Conditional	Blank or Valid Date	Blank or Valid Date	Required if KiwiSaver Entry Status = 'O'
KiwiSaver Employee Active	No	D	String	1			Conditional	Conditional	Blank, Y(es) / N(o), T(rue) / F(alse)	Blank, Y(es) / N(o), T(rue) / F(alse)	Depends on KiwiSaver Entry Status
KiwiSaver Employee Percentage	No	D	Float - 2dp		2	8	Conditional	Conditional	Blank or Valid Percentage (3, 4, 6, 8 or 10)	Blank or Valid Percentage 3, 4, 6, 8 or 10)	Depends on KiwiSaver Entry Status
KiwiSaver Employer Active	No	D	String	1			Conditional	Conditional	Blank, Y(es) / N(o), T(rue) / F(alse)	Blank, Y(es) / N(o), T(rue) / F(alse)	Depends on KiwiSaver Entry Status
KiwiSaver Calc Method	No	D	String	1			Conditional	Conditional	Blank, 'R'ated or 'F'ixed	Blank, 'R'ated or 'F'ixed	Depends on KiwiSaver Entry Status
KiwiSaver Employer Percentage	No	D	Float - 2dp		2		Conditional	Conditional	Blank or valid rate of 2% and greater	Blank or valid rate of 2% and greater	Depends on KiwiSaver Calc Method
KiwiSaver Gross Up	No	D	String	1			Conditional	Conditional	Blank, Y(es) / N(o), T(rue) / F(alse)	Blank, Y(es) / N(o), T(rue) / F(alse)	Depends on KiwiSaver Entry Status
KiwiSaver Fixed Rate	No	D	Float - 2dp		1		Conditional	Conditional	Blank or Money	Blank or Money	Depends on KiwiSaver Calc Method
KiwiSaver ESCT Tax Rate Code	No	D	Integer		1	3	Conditional	Conditional	Blank, 1, 2, 3 or 4	Blank, 1, 2, 3 or 4	Depends on KiwiSaver Entry Status or Compliant Fund Active. Codes: 1 = 10.5%, 2 = 17.5%, 3 = 30%, 4 = 33% (default)
KiwiSaver Contrib GL Account	No	D	String	25			Conditional	Conditional	Blank or Non-Blank	Blank or Non-Blank	Required if KiwiSaver Employer Active is True and General Ledger is active in payroll company
KiwiSaver Contrib Holiday	No	D	String	1			Conditional	Conditional	Blank, Y(es) / N(o), T(rue) / F(alse)	Blank, Y(es) / N(o), T(rue) / F(alse)	Depends on KiwiSaver Entry Status
KiwiSaver Holiday Ceases Date	No	D	Date				No	No	Blank or Valid Date	Blank or Valid Date	Depends on KiwiSaver Entry Status
KiwiSaver Holiday Continue CEC	No	D	String	1			No	No	Blank, Y(es) / N(o), T(rue) / F(alse)	Blank, Y(es) / N(o), T(rue) / F(alse)	Depends on KiwiSaver Entry Status
KiwiSaver Opt Out	No	D	String	1			Conditional	Conditional	Blank, Y(es) / N(o), T(rue) / F(alse)	Blank, Y(es) / N(o), T(rue) / F(alse)	Depends on KiwiSaver Entry Status
KiwiSaver Opt Out Date	No	D	Date				Conditional	Conditional	Blank or Valid Date	Blank or Valid Date	Required if KiwiSaver Opt Out = True/Yes.
KiwiSaver Opt Out Bank Acc	No	D	String	16			No	No	Blank or Valid Account	Blank or Valid Account	15 digit (2 digit suffix) or 16 digit (3 digit suffix) account number e.g. 123075011451600 (ASB has 2 digit suffix)
KiwiSaver Opt Out Acc. Name	No	D	String	16			No	No	Blank or Non-Blank	Blank or Non-Blank	Depends on KiwiSaver Opt Out
Compliant Fund	No	D	String	1			No	No	Blank, Y(es) / N(o), T(rue) / F(alse)	Blank, Y(es) / N(o), T(rue) / F(alse)	Optional if Compliant Fund Active is active in payroll company
Compliant Fund Scheme	No	D	String	15			No	No	Blank or Non-Blank	Blank or Non-Blank	Depends on Compliant Fund
Compliant Fund Reference	No	D	String	12			No	No	Blank or Non-Blank	Blank or Non-Blank	Depends on Compliant Fund
Compliant Fund Employee Active	No	D	String	1			Conditional	Conditional	Blank, Y(es) / N(o), T(rue) / F(alse)	Blank, Y(es) / N(o), T(rue) / F(alse)	Depends on Compliant Fund
Compliant Fund Employee Percentage	No	D	Float - 2dp		2		Conditional	Conditional	Blank or Valid Percentage (3% or Greater)	Blank or Valid Percentage (3% or Greater)	Depends on Compliant Fund Employee Active and Calc Method
Compliant Fund Employer Active	No	D	String	1			Conditional	Conditional	Blank, Y(es) / N(o), T(rue) / F(alse)	Blank, Y(es) / N(o), T(rue) / F(alse)	Depends on Compliant Fund - required if KiwiSaver Employer is not active
Compliant Fund Calc Method	No	D	String	1			Conditional	Conditional	Blank, 'R'ated or 'F'ixed	Blank, 'R'ated or 'F'ixed	Depends on Compliant Fund Employer Active
Compliant Fund Employer Percentage	No	D	Float - 2dp		2		Conditional	Conditional	Blank or valid rate	Blank or valid rate	Depends on Compliant Fund Calc Method
Compliant Fund Gross Up	No	D	String	1			No	No	Blank, Y(es) / N(o), T(rue) / F(alse)	Blank, Y(es) / N(o), T(rue) / F(alse)	Depends on Compliant Fund Employer Active
Compliant Fund Fixed Rate	No	D	Float - 2dp		1		Conditional	Conditional	Blank or Money	Blank or Money	Depends on Compliant Fund Calc Method
Compliant Fund Contrib GL Account	No	D	String	25			No	No	Blank or Non-Blank	Blank or Non-Blank	Depends on Compliant Fund Employer Active and if General Ledger active in payroll company
CEC Exempt	No	D	String	1			No	No	Blank, Y(es) / N(o), T(rue) / F(alse)	Blank, Y(es) / N(o), T(rue) / F(alse)	Optional if CEC Exempt is active in payroll company
Contractor	No	D	String	1			No	No	Blank, Y(es) / N(o), T(rue) / F(alse)	Blank, Y(es) / N(o), T(rue) / F(alse)
GST Registered	No	D	String	1			No	No	Blank, Y(es) / N(o), T(rue) / F(alse)	Blank, Y(es) / N(o), T(rue) / F(alse)	Depends on whether Contractor Active
AL Cash Up Entitlement	No	D	Float - 2dp		0		No	No	Blank or Valid Days or Hours value	Blank or Valid Days or Hours value	Only for Set Hour (F) and Variable Hour (P) employees. 'Entitlement' minus 'Paid Out' can not be greater than Annual Leave Outstanding Entitlement.
AL Cash Up Paid Out	No	D	Float - 2dp		0		No	No	Blank or Valid Days or Hours value	Blank or Valid Days or Hours value	Only for Set Hour (F) and Variable Hour (P) employees. 'Entitlement' minus 'Paid Out' can not be greater than Annual Leave Outstanding Entitlement.
SLRD Income Type	No	D	Integer		0	1	No	No	Blank, 0 or 1	Blank, 0 or 1	Required where tax code = 'STC' and SLRD Override % > 0
SLRD Certificate Type	No	D	Integer		0	2	No	No	0, 1 or 2	Blank, 0, 1 or 2	Special Deduction Rate (SDR) certificate only available (Blank= None, 0=None, 1=RDE, 2=SDR)
SLRD Expiry Tax Code	No	D	String	5			No	No	Blank or Valid Tax Code	Blank or Valid Tax Code	Only applicable for RDE and SDR certificates (optional for SDR)
Print Payslip	No	D	String	1			No	No	Blank, Y(es) / N(o), T(rue) / F(alse)	Blank, Y(es) / N(o), T(rue) / F(alse)	Blank=Yes, Y=Yes, T=Yes, F=No, N=No
KiwiSaver As Salary	No	D	String	1			No	No	Blank, Y(es) / N(o), T(rue) / F(alse)	Blank, Y(es) / N(o), T(rue) / F(alse)
KiwiSaver As Salary Net Or Gross	No	D	Integer		0	1	No	No	Blank, 0 or 1	Blank, 0 or 1	Where KiwiSaver As Salary is active. 0 = Net, 1 = Gross
No Online Payslip	No	D	String	1			No	No	Blank, Y(es) / N(o), T(rue) / F(alse)	Blank, Y(es) / N(o), T(rue) / F(alse)	Only actioned if IMS Online activated for company. Blank=No, Y=Yes, T=Yes, F=No, N=No
Kiwisaver Costing Code	No	D	String	20			No	No	Blank, Valid Costing Code	Blank or Valid Costing Code	Field optional if Costing is active in payroll company
Compliant Costing Code	No	D	String	20			No	No	Blank, Valid Costing Code	Blank or Valid Costing Code	Field optional if Costing and Compliant Fund active in payroll company
Super Costing Code	No	D	String	20			No	No	Blank, Valid Costing Code	Blank or Valid Costing Code	Field optional if Costing and Company Superannuation active in payroll company
Parental Leave	No	D	String	1			No	No	Blank, Y(es) / N(o), T(rue) / F(alse)	Blank, Y(es) / N(o), T(rue) / F(alse)	Annual Leave Type must be F(Set Hour) or P(Variable Hours)
PL Start Date	No	D	Date				Conditional	Conditional	Blank or Valid Date	Blank or Valid Date	Must be a valid date where Parental Leave is True
PL Expected Return Date	No	D	Date				No	No	Blank or Valid Date	Blank or Valid Date	Depends on Parental Leave
PL Actual Return Date	No	D	Date				No	No	Blank or Valid Date	Blank or Valid Date	Depends on Parental Leave
PL Outstanding Ent	No	D	Float - 2dp		0		No	No	Blank or Valid Days or Hours value	Blank or Valid Days or Hours value	Depends on Parental Leave
PL Entitlement Date	No	D	Date				No	No	Blank or Valid Date	Blank or Valid Date	Depends on Parental Leave
PL Gross Earnings	No	D	Float - 2dp		0		No	No	Blank or Money	Blank or Money	Depends on Parental Leave
PL Amount In Advance	No	D	Float - 2dp		0		No	No	Blank or Money	Blank or Money	Depends on Parental Leave
FVL Recording Method	No	D	String	1			No	No	D(ays) or H(ours)	Blank, D(ays) or H(ours)
FVL Full Entitlement	No	D	Float - 2dp		0		No	No	Blank or Valid Days or Hours value	Blank or Valid Days or Hours value
FVL Next Entitlement	No	D	Float - 2dp		0		No	No	Blank or Valid Days or Hours value	Blank or Valid Days or Hours value
FVL Full Cycle	No	D	Integer		0	12	No	No	Blank or Valid Number of Months	Blank or Valid Number of Months
FVL Due Date	No	D	Date				No	No	Blank or Valid Date	Blank or Valid Date
AL In Weeks	No	D	String	1			No	No	Y(es) / N(o), T(rue) / F(alse)	Blank, Y(es) / N(o), T(rue) / F(alse)
AL Full Entitlement in Weeks	No	D	Float - 4dp		0		No	No	Blank or Valid Weeks value	Blank or Valid Weeks value
AL Next Entitlement in Weeks	No	D	Float - 4dp		0		No	No	Blank or Valid Weeks value	Blank or Valid Weeks value
Days Per Week	No	D	Float - 2dp		0		No	No	Blank or Valid Days	Blank or Valid Days	Depends on AL In Weeks
Hours Per Week	No	D	Float - 2dp		0		No	No	Blank or Valid Hours	Blank or Valid Hours	Depends on AL In Weeks
KiwiSaver Opt Out Late Code	No	D	String	10			No	No	Blank or Valid code	Blank or Valid code	Only required when KS Opt Out date is more than 56 days after Start Date
KiwiSaver Opt Out Late Other	No	D	String	500			No	No	Blank or Valid reason	Blank or Valid reason	Only required when KS Opt Out Late Code = 'OTHR'
END	No	D	String	1			Yes	Yes	E	E	Required field - to indicate the end of detail columns for an employee

Legend

Field Type D : Data Field
Field Type A : Action Field

Page tree