| # | Header | Description | Req. | Notes |
| 1 | Employee Number | Custom field containing the payroll application's unique identifier for the users. | Y | This can vary from installation to installation. You should use whatever indentifier your payroll application uses and then put that in either the Employee Number field or the Social Security Number field. If you use Social Security Numbers, then the header should reflect the same title. |
| 2 | Type | Hard, soft or hidden accrual type within Journyx. | Y | Must be either "hard" or "soft" or "hidden" as appropriate. Probably your payroll system does not have this concept, and so you will need to edit the file you receive from it and add this field with the appropriate values. Hidden accruals behave the same as hard accruals (they cannot be violated) but hidden accrual balances are not shown to the user on his or her time entry screen. Only an administrator can see a hidden accrual balance in most cases, one exception being when a user creates a Leave Request that violates a hidden accrual. |
| 3 | Pay Type | The time entry field that is limited by the accrual balance | Y | This is the code or type of accrual. Value must match exactly a value in Journyx. If the user does not already have an accrual of this type, a new accrual will be created. |
| 4 | Balance | Number of accumulated hours that users have available for this accrual | Y | Numeric amount for replacing, incrementing, or limiting the existing balance. |
| 5 | As Of | Effective date of this accrual balance | N | Must be a date in the format "yyyymmdd". Indicates the date when the specified change becomes effective. The accrual will be adjusted for time taken since that date for actions other than "Increment", which does not require this field. |
| 6 | Action | Action to be taken with the speciified accrual balance. | N | This column is optional. If no action is specified for a row, the default action is "replace", which will replace the existing accrual balance for the specified User and Pay Type (or create a new balance if there is not an existing accrual). The other available actions are "Increment" and "Limit". "Increment" will add (or subtract) the specified Balance from the existing balance for the User and Pay Type. This action does not require an As Of date. If the Balance is negative and would reduce an existing hard accrual below zero hours, an error will bed reported. The "Limit" action is used to apply caps to existing accruals. For a Limit row, the specified Balance will be compared to the accrual balance on the listed date. If the accrual balance exceeds the limit, the accrual will be reduced to the limit amount. If an applied limit reduces a hard accrual below zero due to accrual activity since the As Of date, an error will be repored. |