alerk/ci-c

ci-c's Issues

[Feature report] Calculation methods

@VuTienNguyen,
Please check the calculation method for
.) Base Hourly Rate = Annual Base Compensation / Annual Base HOurs
.) Incentive Benefit = Actual W-2 Box 16 Wages (if employee == NJ)
.) State With-holding Retained by Company = State With-holding (if program.retained ... checkbox is checked)
.) Tax Credit Calculation = Incentive Benefit - State With-holding Retained by Company
.) Actual Hourly Rate = ActualStateTaxableWages / Actual hours for this period

[GUI]Misspelling

• Report screen
  • Project Name group > Last column: Health Insurance "Elibility" Date => Health Insurance Eligibility Date
  • Button "Cannel" => "Cancel"
• Browser tab name: "IncetiLock" => "IncentiLock": Fixed

[GUI] Landing page and icon

CI-C has sent us the landing page and icons. We can mix it to our system.
Active icons
Hover icons

The landing page they sent is awful! We need to discuss how to change it.
Landing Page 12.11.16.pptx

However, this issue has low priority. Don't start this issue before finish the system hanged issues.
BR.

[GUI] Text change

• Legal Entities > User > Edit User
  • Change text Status > "Hide" to "Inactive"

[Feature] Adding State/County/City

@https://github.com/VuNguyenTien
Under System>State/County/City, we're still using this form to add Location

However, this is not appropriate anymore. Could we disable the Add Location under System > State/County/City? Only displaying is needed (it means we can view the Location grouped by Container Company and search for some field).
This has low priority. Just disabling/hiding the button "Add Location" is enough for this version.

[ Report feature] Fix GUI

Under "Employees", if there is no employee data, it reads "There are not any employees in current location. Please upload surplus employee data file ! That message pops up very briefly when I open the report for the first time. If I close the report and reopen, that message does not appear.

Please remove the pop up message that briefly appears when the user opens a report for the first time.

[Report feature] Aggregate report

Dear Vu,
We need to make the aggregate report for headcount incentive.

• Information fields (name, start date, ...) is the same as monthly report.
• Formula fields is the some of monthly fields.
  I am waiting for the formula from the customer. At the moment, please make an option "Summary" in the drop-down box for "Choose Date of Report" at index 0 and display the place holder. I will notify you when we have the detail formula.
  Thanks much!

[All features] Company code and Location code

1. System does not allow more than 1 company to have the same company code. System must allow this. Many companies have one company with code 100, etc
2. Similar issue with location codes. Location codes do not equal a physical location. Many companies will use the same location code numbering but each location code may be assigned to unique locations. For example, location 10 for one company may be in California while location 10 for another company may be Missouri. There is no uniformity in location codes. They are assigned independently by each parent company. Companies within a parent group will not have duplicate location codes. Location codes within a parent company are uniform.

[GUI] Typos and field labels change

Please fix the following:

• At login screen, "Forget the password" should be changed to "Forgot password"
• When click on "forget the password", change "Get back password" to "Reset password"
• In the "Headcount Incentive Detail Report", in the Report Summary, you need to delete an "e" on "periode" so it reads "Net new jobs total actual wages this period"
• Under "Employees", if there are no locations set (i.e., Test 1c), it reads "There are not any locations in this company, please add location before upload employee information !" Put a period after company, capitalize Please, and add "ing" to upload, to be "uploading". New sentence should be: "There are not any locations in this company. Please add location before uploading employee information !"
• When viewing the "Headcount Incentive Detail Report", under Project Name, "Benefit Percentage" should read 6%, not 0.06%. The formula needs to be changed so this displays correctly

[GUI] Location code display

• Upload employee file: [Location code] - [Long Address] format
• Report tab: [Location code] - [Long Address] format
• Report table: Location Code column

[Employee feature] CICJob_Number

We need to add a column to Employee, named CICJob_Number. The value of this column is generated as bellow:
- Base Job before project:
<sequence number at setting up time (from 1 to …)>_
- Terminated Base Job (Vacant Job):
<sequence number at setting up time (from 1 to …)>.x_
- New/Surplus:
<Project_Code><Employee_ID>_
- Terminated New/Surplus:
<Project_Code><Employee_ID>.x_
- Backfilling employee:
< vacant Job ID>.

< vacant Job ID>

_ Equals
<sequence number at setting up time (from 1 to …)>_
Or
<Project_Code><Employee_ID>_
o For Base Job before Project
<sequence number at setting up time (from 1 to …)>._
o For New/Surplus:
<Project_Code>_<Employee_ID>.

• The sequence of this will be

• < vacant Job ID>.x : Terminated 1
• < vacant Job ID>.1 : Backfill number 1
• < vacant Job ID>.x : Terminated 2
• < Vacant Job ID>.2 : Backfill number 2
• < Vacant Job ID>.x : Terminated 3
• < Vacant Job ID>.3 : Backfill number 3
  …
  After the project stop, the New/Surplus job will become Base Job, but the CICJob_Number is kept.

[Employee] Duplicated data

@VuTienNguyen,
The employees displayed in Employee tab is duplicated at Test 1 - Loc 26 - 01/2016 to 03/2016.
Could you please check this problem?
BR,

[GUI] Change fields' labels

We need to change the fields' labels
Project Set-up: Basic Information tab:
"Benefit qualified wages min" => "Min Annual Wages for Benefit"
"Benefit qualified wages max" => "Max Annual Wages for Benefit"
"CAW" => "County Average Wage"

Please update by tomorrow afternoon.

[Feature] Upload employee hanged at Step 4

I tried to upload a file to Test1.a company, taxdirector account. After matching all the column, I stucked at step 4, couldn't import the data.

Could you please check this problem? I attached the upload file.
Test 1.a Jan 2016_.xlsx

Matching columns:
ActualHoursforthisPeriod -> Hours Worked
GrossWages -> State Gross Wages
HealthInsurancePaid -> Health Insurance Paid
AnnualBaseHours -> Annual Hours Scheduled to Work

[Report feature] Formatting problem

We need to fix some formatting problem. Our customer described it in the attachment.

1. For any cell that has a dollar amount (wages, compensation, withholding tax, tax credit, hourly rate, benefit amount), please include a $ and comma separations and only 2 decimal points
   i.e 1234567 => $1,234,567.00
2. For any number cell (total employees, hours, jobs, etc), please use comma separations and only 2 decimal places.
   For employees number & jobs number: I will ask for confirmation (there will be no 123.01 employees at all)
   For other number: i.e Total work hours 12345 => 12,345.00
3. If a field says “percentage” in the label, then the field should hold a whole number such as 7.25 (and not .0725 or .9725% or 7.25%) Please show 2 decimal places for all percentages.
   Correct:

• Value 0.0725 => display 7.25%
• Value 0.09 => display 9.00%
  Incorrect:
• Value 0.07 => display 7%
• Value 0.0925 => display 0.0925%
  scan.pdf

[Report feature] 2 other reports

Report #1: Our current report
Report #2: The summary report but add the columns in the below table
Report #3: Jane will deliver the Formula. Very similar to Report #2.
The report link will display a box to Report #1, #2, #3
13_columns_added.docx

[All feature] Prepare for demo

1. Delete this alert
   
2. Disable the "Add Location" by Administrator type user.
3. Change the range of Week Hours (highlighted) from 1-24 to 1-40
   

[New feature] Add footer and "Term and Condition Tab"

We need to add a footer for the web-page. It's similar to the footer in the pdf file. No arrow in the middle. The text display is: "©2016 Vancil Brown LLC. All rights reserved"
IncentiLock_Login_Screen-Final.pdf

We need to add "Term and Condition Tab" next to "System" tab on the top tab menu. In side that tab, display 2 parts: "Terms & Conditions of Use" and "Privacy Policy" like the image. The detail of 2 parts is sent via email [email protected].
BR,

[GUI] Changing the welcome page

We need to change the welcome page as

The icon and icon with mouseHover are:

[GUI] Edit footer and other texts

1. When it is time to put the footer back into the CIC system, please update the footer date to 2017.
2. On Report screen, please change message to "There are no reports for this location."

The current language is not good English: There are not any reports in this location.

[Feature Employee] CI-C Number

We need to add the CI-C number for employee. I will clarify about the format and change conditions.
This is used by customer, but doesn't affect our system.
Report #1 - Base Jobs report.xlsx
Attachment from customer.

[Time related] Problems with timing in CI-C

Please update the problem here.

[Employee Feature]Backfilling

We have some problem with the backfilling process. Our customer report that

It appears that the backfilling process is not correct. As I am working on the sample report and matching the backfilled positions, I noticed that we are backfilling project jobs vacated in January of 2016 with employees who were hired in 2001. That shows that we’re backfilling base jobs with existing base jobs. An employee who backfills a vacated position should be hired after the base job is vacated In this example, the jobs vacated on January 10, 2016 should be backfilled by employees hired on or after January 10, 2016.

The employee who is used to backfill a vacant job must:

• Be hired after the termination date of the vacant job
• Be a new/surplus employee
  Could we change this process? I send the flow chart attachment for this.
  BR,
  CI-C-backfill.pdf

[All features] Create the indicator to notify the user of processing request

At the moment, some process like:

• Uploading data
• Scrolling the report/Change the Date of Report
  ...
  Doesn't have any indicator to notify user of processing request. Can we put something on this, the example would be: When user logging into the system, 3 color squares indicator rolling to notify the user. At that time, the button control can be disable so that the user doesn't accidentally click twice.
  I will check for the list of required features that we want to put this thing on.

[Performance] Excel file upload format slows down the system

We're having problem with uploading Excel file. The system is too slow, and the columns to match contained non-header columns. Sometime the customer has problem with blank row (after the last row that had data).
Could we format the upload excel file of the customer so that we can avoid this problem? We can trim out the non-data columns and non-data rows.

Add the NodeJS Express framework for the project

Add the Express frame with:

• Admin
  • Add Company with default User
  • Modify system setup
• User
  • Add Sub-Company
  • Upload data from Excel
  • Auto calculate report

Modify the ng2-admin for acceptable view of CI-C

Modify ng2-admin

• The function and navigation
• The color theme from Blue to Green
• Prepare the chart

[Feature] Export report to excel file

We need to export the report to excel file, with format similar to the report page.
Fields name: Fields value
Table
Summary

[Feature employee] Remove the jumping to top-page at Step 3

At step 3 of uploading employee file, while matching the columns, the system always jumps to the top-page for every column change. This is abnormal User Experience.
Expected: The system stays at the current position after choosing a column to match. It will not jump back to the top-page anymore.