employee/company management app/intranet site

The application needs to be able to do the following: a page Add/Edit an employee database with the following fields: (with an autoID) employee name employee surname sex (1=male; 2=female height (in cm) DOB nationality (Taiwanese, Japanese, chinese, north Korean, south Korean, hong kongese, other) passport number visa type (1=working holiday, dependant visa full work rights=2, PR/citizen=3, limited=4,other=5) entry date first visa start date (only applicable to working holiday visa, add/edit page must reflect this) first visa end date (only applicable to working holiday visa) second visa start date (only applicable to working holiday visa) second visa end date (only applicable to working holiday visa) Holiday visa term (1=first visa; 2=second visa;3=NA) visa end date (via data entry, applicable when visa type not equal 1) contact number email status of ABN application (Yes/no) ABN number bank of bank account BSB of bank account account number of bank account place of work (as a ID with a link to a seperate table) start employment date hourly rate description hourly rate (taken from the site tables-siterate, but with a textbox for other hourly rates) deductions place of stay (taken from houses table-houseID weekly rent rate (entered via textbox) status of bond payment (yes/no) amount of bond payment (entered via text box) status of issued equipment (yes/no) equipment name1 equipment value1 paid for by1 (1=company; 2=employee) equipment name2 equipment value2 paid for by2 (1=company; 2=employee) equipment name3 equipment value3 paid for by3 (1=company; 2=employee) equipment name4 equipment value4 paid for by4 (1=company; 2=employee) vaccination status (yes/no) future employment (yes/no) employed (yes/no) description of final position notes ---- a page that can Add/edit an worksites database with the following fields: AutoID site name site location site rate 1 site rate 2 site rate 3 site rate 4 site rate 5 site rate 6 site rate 7 site rate 8 site rate 9 a worksite details pages which displays the following information the total number of employees employed at the site a list of all employees (where employees name can be drilled down upon) a list of all the houses assignment to the worksiteId (where the address can be drilled down upon) ------ a payment processing page that can do the following: calculate an weekly wage from each worksiteId than each employeeID within worksiteID and would have the following fields for display and entry into a database table employeeID worksiteID full name rate hours worked (from textbox) calculated gross wage amount (rate x hours worked) 10% of gross wage amount displayed as 10% GST (Tax) net wage (gross + 10 GST) rent deductions transport deductions other deductions (with a text box for data entry) total payment amount (gross wage + 10% GST - rent deductions - transport deductions - other deductions) other payments this data entry page must utilise an dataset for easier data entry, each payment must be entered into an payments database with the above fields as a minimum plus an additional transactionsID (autonumber) for each payment. all payments of a given worksiteID must be made in one go within a single long webpage. after all wage payments for given worksiteid is calculated, the webpage must generate a ABA file that complies with Australia banking accoication's format requirements see: [login to view URL] only when each payment is marked paid on this page can each transaction be entered into the transactions database. ----- the employees database must also be able to generate a printable page close to the attached letter template see: attached letter template a invoice creation page where it has the following information: the full name of the employee the employee's ABN an generated invoice number an invoice date (based on date of creatation) a list of transactions/payments with the employee in a list format a gross total amount of all transactions (pre GST amount) a 10% GST amount a net amount (gross+GST) a total amount of all deductions. transaction database must also be able to generate a printable page close to the attached invoice template See template ---- an employee applications tracking feature which includes: a page that can add/edit a applicants with the following fields applicant name applicant surname applicant mobile number applicant email address applicant referer (based on employee id) applicant sex applicant height applicant passport number appicant status (1 for seeking, 2 for employed, 3 terminated) ----- a page that can add/edit and a page that can then view a houses management database (display page will be grouped by the siteID) with the following fields: houseID (autonumber) address rent amount per week payment cycle (weekly=1/fortnightly=2/monthly=3) rent due date(a dedicated page for recording rent payments (every rent payment recorded must update the rent due date in accordance with the rent payment cycle)) tenant1 (each tenant contains a employeeId, each employeeId is a hyperlink to the employee details pages) tenant2 tenant3 tenant4 tenant5 tenant6 tenant7 tenant8 tenant9 tenant10 tenant11 tenant12 tenant13 tenant14 tenant15 tenant16 tenant17 tenant18 tenant19 tenant20 ) realtor company name realtor contact number realtor fax number realtor bank realtor account name realtor account number realtor account bsb the rent payments database must contain the following fields: an autoID the houseID the payment amount the payment date the rent payments must contain the following: the ability to record rent payment transactions, while also updating the rent due date field from the house table, a datalist which its populated on 2 conditions (droplists) first dropdown list=list of all site names second dropdown list (populated by selection of first dropdown) = all house address within a relevant siteID (the house address must be a hyperlink to a page with lists all rent payments associated with the relevant houseID on the page that displays the houses database, add a link (with the address as the hyperlink) where it can drill down on the address to display all the householditems associated with the houseID --- householditemsID (autonumber) Category (number as ID) ( 1=bed 2=mattress 3=wardrobe 4=bedside table 5=table 6=chair 7=cabinet 8=tv 9=vcr/dvd player 10=toaster 11=stove electrice/gas small 12=microwave 13=kettle 14=other ) shortdescription purchased time houseID ---- a page with the ability to add/edit and them view a car management database with the following fields carId (autonumber) car make car model car year car purchase price car insurance company car policy number car insurance cover start date car insurance cover end date car insurance cover cost car insurance cover amount car use location (siteID) ---- add a page for administering resignation of employees (edit employment status) this page must display the following fields: emplyoeeID employee Full name employee work site (worksites-siteID) employee house of stay (houses-houseID) employee start date all equipment issued to employee where issued equipment=yes, status of paid for by=company employee bond amount --- the website must have a simple login feature the front/home page after login must contain the following items each dataset much contain a link to a relevant page a dataset that displays a list of certain types of employees (taken from visa type field=working holiday) who have been employed 4.5 months or more, where future employment field = yes. a dataset that displays all employees names (link to edit employees details page; employee name as hyperlink, where ABN status = no A dataset that displays all the houses with rent due within 3 days (link to the dedicated rent payment page) A dataset that displays all the cars with insurance policies within 2 weeks (link to edit insurance database page an employee search/find feature (searches based on employee name, also from a dropdown list of worksites that then populates a datalist with employee names) on the search results page, each returned search result must contain a link to the employees detailed information page, which contains all the information from the employees table, the name of the worksite the employee is employed at and all of the transaction for the given employee (displayed in a dataset) going back in selectable options of 3/6/12 months.