|
CDEP Manager Report |
  
|
|
CDEP Manager Report |
|
To facilitate the management reporting requirements for payers of CDEP participant wages, we have created an export file with the required information in it. This conforms to the specifications of the CDEP Manager System.
Each time you finalise a pay for which CDEP was paid, a comma separated file (.csv) file is created in the parent data folder for that company.
The file name will be;
'Company Name' - Payroll Data (Date).csv
eg: All Employment Services - Payroll Data (1-Jul-2006).csv
Field Name |
Descriptor |
Note |
Example |
Mandatory |
Employer ABN |
11 Numeric range from 100000000000 to 99999999999 |
ABN of Employer |
"12345678901"
|
Yes |
Payroll ID |
Up to 12 alphanumeric characters |
Employee payroll number or Unique Identifier |
"123456ABC" |
Yes
|
Customer CRN
|
10 characters of text consisting 9 numeric and 1 alpha |
Centrelink's Customer Reference Number |
Include check character "123456789A" |
Yes |
Employment Status
|
3 alpha characters
|
Status of employment such as casual, full time etc
|
"FTO" – Full time ongoing "FTN" – Full Time Non-Ongoing "PTC" – Part Time Casual "NEM" – Not Employed |
Yes |
Employee Surname
|
Up to 30 alphanumeric characters |
Employee's Surname
|
"O'Neil"
|
Yes |
Employee First Name
|
Up to 30 alphanumeric characters |
Employee's First Name
|
"Dexter"
|
Yes |
Employee Birth Date |
10 DD/MM/CCYY |
Employee's date of Birth |
"31/03/1968" |
Yes |
Hire Date |
10 DD/MM/CCYY |
Date Employee was hired |
"21/12/1998" |
No |
Termination Date |
10 DD/MM/CCYY |
Date employment was terminated |
"23/05/2003" |
No |
Time Worked |
3.2 Decimal |
Time worked during the pay period. Decimals represent fractions of hour. |
210 Hours 30 minutes – "210.50" 137 hours 21 minutes – "137.35" |
Yes |
Pay Period Start Date |
10 DD/MM/CCYY |
Start Date of Pay Period inclusive. |
"1/2/2004" |
Yes |
Pay Period End Date |
10 DD/MM/CCYY |
End date of pay period inclusive. |
"14/2/2004" |
Yes |
Date Income Paid |
10 DD/MM/CCYY |
Date wages paid |
"16/2/2004" |
Yes |
Pay Period Type |
1 Alpha character |
Pat Period Type |
"W" – Weekly "F" – Fortnightly "M" - Monthly |
Yes |
Gross CDEP Wages Payment
|
Numeric, dollars and cents. Decimal required. 0.00 if none. |
Income attributable to CDEP Wages
|
"350.76"
|
Yes |
Gross CDEP Other (Top Up) Payment |
Numeric, dollars and cents. Decimal required. 0.00 if none. |
Income attributable to CDEP Other |
"23.00" |
Yes |