Approval Plan Import File Format

Header Description Req. Notes
ApprovalType This column is for the type of period approval plan. Y The valid options for this field are Time, Expense or Mileage.
ApprovalName This column is for the name of the period approval plan. If you are making changes to an existing approval plan, the name must be exactly the same. Y  
ApproverL1 This column is for designating the first level approver for a period approval plan. Y This field must contain an existing user in Timesheet with regular or super approver abilities. The Journyx login name is used for this field.
ApproverL1Backup This column is for designating the first level backup approver for a period approval plan. N Backup approvers are optional. Like the approver field, the backup must be designated with a login ID of an existing user in Journyx with approver abilities.
ApproverL2 This column is for designating the second level approver (if applicable) for a period approval plan. N This field must contain an existing user in Journyx with regular or super approver abilities. The Journyx login name is used for this field. Additional columns may be added to the import file for additional levels of approvers (e.g., ApproverL3), or this column may be removed.
ApproverL2Backup This column is for designating the second level backup approver (if applicable) for a period approval plan. N Backup approvers are optional. Like the approver field, the backup must be designated with a login ID of an existing user in Journyx with approver abilities. Additional columns may be added to the import file for additional levels of approvers (e.g., ApproverL3Backup), or this column may be removed.
CurrentlyActive This column is for designating whether or not the period approval plan is active. N Yes and No are the only options for this column.
NotifyUserRejected This column is for enabling/disabling the notice of rejection to the user for a period approval plan. N Yes and No are the only options for this column.
UserRejectedSubject This column is for configuring the subject line of this approval email notice. N Text and HTML are valid for this field. See the product documentation on Approval Plans for the valid list of tricky/data tags that include Journyx system information.
UserRejectedBody This column is for configuring the body of this approval email notice. N Text and HTML are valid for this field. See the product documentation on Approval Plans for the valid list of tricky/data tags that include Journyx system information.
NotifyUserApproved This column is for enabling/disabling the notice of approval to the user for a period approval plan. N Yes and No are the only options for this column.
UserApprovedSubject This column is for configuring the subject line of this approval email notice. N Text and HTML are valid for this field. See the product documentation on Approval Plans for the valid list of tricky/data tags that include Journyx system information.
UserApprovedBody This column is for configuring the body of this approval email notice. N Text and HTML are valid for this field. See the product documentation on Approval Plans for the valid list of tricky/data tags that include Journyx system information.
NotifyApproverSubmitted This column is for enabling/disabling the notice of submission to the approver for a period approval plan. N Yes and No are the only options for this column.
ApproverSubmittedSubject This column is for configuring the subject line of this approval email notice. N Text and HTML are valid for this field. See the product documentation on Approval Plans for the valid list of tricky/data tags that include Journyx system information.
ApproverSubmittedBody This column is for configuring the body of this approval email notice. N Text and HTML are valid for this field. See the product documentation on Approval Plans for the valid list of tricky/data tags that include Journyx system information.
NotifyApproverResubmitted This column is for enabling/disabling the notice of resubmission to the approver for a period approval plan. N Yes and No are the only options for this column.
ApproverResubmittedSubject This column is for configuring the subject line of this approval email notice. N Text and HTML are valid for this field. See the product documentation on Approval Plans for the valid list of tricky/data tags that include Journyx system information.
ApproverResubmittedBody This column is for configuring the body of this approval email notice. N Text and HTML are valid for this field. See the product documentation on Approval Plans for the valid list of tricky/data tags that include Journyx system information.
NotifyUserBeforeDays This column is for enabling/disabling the submit reminder to the user for a period approval plan. N Whole numbers and No are the only options for this column. No disables the notice. Numeric values determine the number of days before period end the notice will be sent. A 0 value indicates the final day of the period.
UserBeforeSubject This column is for configuring the subject line of this approval email notice. N Text and HTML are valid for this field. See the product documentation on Approval Plans for the valid list of tricky/data tags that include Journyx system information.
UserBeforeBody This column is for configuring the body of this approval email notice. N Text and HTML are valid for this field. See the product documentation on Approval Plans for the valid list of tricky/data tags that include Journyx system information.
NotifyUserAfterDays This column is for enabling/disabling the late notice to the user for a period approval plan. N Whole numbers and No are the only options for this column. No disables the notice. Numeric values determine the number of days after period end the notice will be sent. A 0 value indicates the final day of the period.
UserAfterSubject This column is for configuring the subject line of this approval email notice. N Text and HTML are valid for this field. See the product documentation on Approval Plans for the valid list of tricky/data tags that include Journyx system information.
UserAfterBody This column is for configuring the body of this approval email notice. N Text and HTML are valid for this field. See the product documentation on Approval Plans for the valid list of tricky/data tags that include Journyx system information.
NotifyApproverAfterDays This column is for enabling/disabling the late notice to the approver for a period approval plan. N Whole numbers and No are the only options for this column. No disables the notice. Numeric values determine the number of days after period end the notice will be sent. A 0 value indicates the final day of the period.
ApproverAfterSubject This column is for configuring the subject line of this approval email notice. N Text and HTML are valid for this field. See the product documentation on Approval Plans for the valid list of tricky/data tags that include Journyx system information.
ApproverAfterBody This column is for configuring the body of this approval email notice. N Text and HTML are valid for this field. See the product documentation on Approval Plans for the valid list of tricky/data tags that include Journyx system information.
NotifyApproverReminder This column is for enabling/disabling the notice that sheets are still waiting for approval for a period approval plan. N Yes and No are the only options for this column.
ApproverReminderSubject This column is for configuring the subject line of this approval email notice. N Text and HTML are valid for this field. See the product documentation on Approval Plans for the valid list of tricky/data tags that include Journyx system information.
ApproverReminderBody This column is for configuring the body of this approval email notice. N Text and HTML are valid for this field. See the product documentation on Approval Plans for the valid list of tricky/data tags that include Journyx system information.
NotifyApproverReminderDays This column is for enabling/disabling the notice that sheets aren't yet approved to the approver for a period approval plan. N Whole numbers and No are the only options for this column. No disables the notice. Numeric values determine the number of days after period end the notice will be sent. A 0 value indicates the final day of the period.
NotifyBackupAfterDays This column is for enabling/disabling the notice that sheets aren't yet approved to the backup approver for a period approval plan. N Whole numbers and No are the only options for this column. No disables the notice. Numeric values determine the number of days after period end the notice will be sent. A 0 value indicates the final day of the period.
BackupAfterSubject This column is for configuring the subject line of this approval email notice. N Text and HTML are valid for this field. See the product documentation on Approval Plans for the valid list of tricky/data tags that include Journyx system information.
BackupAfterBody This column is for configuring the body of this approval email notice. N Text and HTML are valid for this field. See the product documentation on Approval Plans for the valid list of tricky/data tags that include Journyx system information.
BackupAfterQueue This column is for enabling/disabling the population of the backup approval queue for a period approval plan. N Whole numbers and No are the only options for this column. No disables the population of the backup approval queue. Numeric values determine the number of days after period end the queue will be populated with unapproved sheets. A 0 value indicates the final day of the period. Negative values are also permitted for populating the backup approver queues prior to the end of the period.
AppendToEmailLog This column is for enabling/disabling the logging of email notice debug information to the email log. N Yes and No are the only options for this column. Typically this setting will be disabled unless Journyx Support has specifically requested it be enabled to diagnose a reported problem.
AppendToSheetNotes This column is for enabling/disabling logging of email notice information in the Sheet History available at the foot of each user's entry screens. N Yes and No are the only options for this column.
SendOnWeekends This column is for enabling/disabling email notices that are scheduled to be sent on Saturday or Sunday. N Yes and No are the only options for this column.