Import time banks

You can import time banks for an organization.

Before you begin 

Verify that the import file has the following column headers in the first row:

  • NAME

  • STARTDATE

  • ENDDATE

  • DAYOFWEEK

  • TARGETMINUTESWEEK1

  • TARGETMINUTES2

  • TARGETMINUTESWEEK[N]

Procedure 

  1. Go to Work Administration. Under Work Rules, select Time Banks.

  2. Select the organization for which you want to import time banks.

  3. Select Import.

  4. Complete the fields on the File Setup screen.

  5. The system imports the data accordingly. It is populated as specified on the Time Banks screen.

    Select Import.

  6. Note the following:

    • The time bank base period dates are based on the organization week boundary day.

    • The algorithm does not distinguish between the first period being a partial or a full week; it puts the hours sequentially into each base period.

    • If there are too few week values, the extra weeks have target hours of 0.

    • If there are too many week values, the extra values are ignored.

    • If a data value is unreadable because it is not numeric, it is replaced with a 0.

    • If a data value is not divisible by 15 minutes, it is rounded to a value divisible by 15.

    • If the Start Day of Week is -1, it is not imported. This value indicates that the data is not weekly data. Only weekly period values can be imported.

Related topics 

File setup screen for imports and exports

Workflow: Assign work rules to employees