FUNCTIONAL_ROLE_CD 
ColumnName  FUNCTIONAL_ROLE_CD 
Definition 
Name: Functional Role. Description: Unique identifier for this functional role.
 

FUNCTIONAL_ROLE_NAME 
ColumnName  FUNCTIONAL_ROLE_NAME 
Definition 
Name: Functional Role Description. Description: Unique description of functional role.
 

S_ROLE_TYPE_CD 
ColumnName  S_ROLE_TYPE_CD 
Definition 
Name: Role Type. Description: The type of records that functional role is assigned. The valid options are as follows: E – Employees. C – Charges. B - Both
 

TS_MODIFY_FL 
ColumnName  TS_MODIFY_FL 
Definition 
Name: Modify Timesheet Flag. Description: Logical as to whether this supervisor can modify the timesheets of the employees in this group.
 

TS_APPROVE_FL 
ColumnName  TS_APPROVE_FL 
Definition 
Name: Approve Timesheet Flag. Description: Logical as to whether this supervisor can approve the employee timesheets.
 

MODIFIED_BY 
ColumnName  MODIFIED_BY 
Definition 
Name: Modified By. Description: The User ID of the person who last modified this record.
 

ROWVERSION 
ColumnName  ROWVERSION 
Definition 
Name: Row Version. Description: The number of times this record has been updated.
 

TIME_STAMP 
ColumnName  TIME_STAMP 
Definition 
Name: Time Stamp. Description: Date and time the record was last modified.
 

EMPL_GROUP_MODIFY_FL 
ColumnName  EMPL_GROUP_MODIFY_FL 
Definition 
Name: Modify Employee Group Flag. Description: Logical as to whether this supervisor can modify employee groups with this role.
 

UDT_MODIFY_FL 
ColumnName  UDT_MODIFY_FL 
Definition 
Name: Modify UDT Flag. Description: Logical as to whether this supervisor can modify udts with this role.
 

UDT_APPROVE_FL 
ColumnName  UDT_APPROVE_FL 
Definition 
Name: Approve UDT Charges Flag. Description: Logical as to whether this supervisor can approve udts with this role.
 

EMPL_MODIFY_FL 
ColumnName  EMPL_MODIFY_FL 
Definition 
Name: Modify Employee Flag. Description: Logical as to whether this supervisor can modify employee records with this role.
 

TS_VIEW_FL 
ColumnName  TS_VIEW_FL 
Definition 
Name: View Timesheet Flag. Description: Logical as to whether this supervisor can view the timesheets of the employees in this group.
 

RATE1_VIEW_FL 
ColumnName  RATE1_VIEW_FL 
Definition 
Name: View Rate 1 Flag. Description: Logical as to whether functional role has ability to view user-defined rate 1 for employees in this group.
 

RATE1_MODIFY_FL 
ColumnName  RATE1_MODIFY_FL 
Definition 
Name: Modify Rate 1 Flag. Description: Logical as to whether functional role has ability to modify user-defined rate 1 for employees in this group.
 

RATE2_VIEW_FL 
ColumnName  RATE2_VIEW_FL 
Definition 
Name: View Rate 2 Flag. Description: Logical as to whether functional role has ability to view user-defined rate 2 for employees in this group.
 

RATE2_MODIFY_FL 
ColumnName  RATE2_MODIFY_FL 
Definition 
Name: Modify Rate 2 Flag. Description: Logical as to whether functional role has ability to modify user-defined rate 2 for employees in this group.
 

SCHEDULE_VIEW_FL 
ColumnName  SCHEDULE_VIEW_FL 
Definition 
Name: View Schedule Flag. Description: Logical as to whether functional role has ability to view employee schedule.
 

SCHEDULE_MODIFY_FL 
ColumnName  SCHEDULE_MODIFY_FL 
Definition 
Name: Modify Schedule Flag. Description: Logical as to whether functional role has ability to modify employee schedule.
 

SCHEDULE_APPROVE_FL 
ColumnName  SCHEDULE_APPROVE_FL 
Definition 
Name: Approve Schedule Flag. Description: Logical as to whether functional role has ability to approve employee schedule.
 

EXPENSE_VIEW_FL 
ColumnName  EXPENSE_VIEW_FL 
Definition 
Name: View Expense Reports Flag. Description: Logical as to whether functional role has ability to view employee expense reports.
 

EXPENSE_MODIFY_FL 
ColumnName  EXPENSE_MODIFY_FL 
Definition 
Name: Modify Expense Reports Flag. Description: Logical as to whether functional role has ability to modify employee expense reports.
 

EXPENSE_APPROVE_FL 
ColumnName  EXPENSE_APPROVE_FL 
Definition 
Name: Approve Expense Charges Flag. Description: Logical as to whether functional role has ability to approve expense reports. schedule.
 

RECORD_RECEIPTS_FL 
ColumnName  RECORD_RECEIPTS_FL 
Definition 
Name: Record Receipts Flag. Description: Logical as to whether functional role has ability to record the receiving of receipts for expense reports.
 

EXPENSE_CREATE_FL 
ColumnName  EXPENSE_CREATE_FL 
Definition 
Name: Create Expense Report Flag. Description: Logical as to whether this functional role has the ability to create an expense report on behalf of someone else
 

EXPENSE_VOID_FL 
ColumnName  EXPENSE_VOID_FL 
Definition 
Name: Void Expense Reports Flag. Description: Logical as to whether this functional role has the ability of voiding another user’s expense report.
 

AUTO_LOAD_EMPL_FAV_FL 
ColumnName  AUTO_LOAD_EMPL_FAV_FL 
Definition 
Name: Auto Load Timesheet Favorites Flag. Description: Logical to determine whether employee favorites will load for a supervisor (assigned this functional role) who searched and is viewing their employee’s missing timesheet.
 

ALLOW_DELEGATION_FL 
ColumnName  ALLOW_DELEGATION_FL 
Definition 
Name: Allow Delegation Flag. Description: Logical as to whether employees who have the functional role can be delegated.
 

DELEGATION_ROLE_CD 
ColumnName  DELEGATION_ROLE_CD 
Definition 
Name: Delegated Funtional Role. Description: The functional role code that can be delegated tasks/alerts for this functional role.
 

IMAGE_RECEIPTS_FL 
ColumnName  IMAGE_RECEIPTS_FL 
Definition 
Name: Image Receitps Flag. Description: Logical as to whether functional role has ability to image receipts for expense reports.
 

VIEW_RECEIPTS_FL 
ColumnName  VIEW_RECEIPTS_FL 
Definition 
Name: View Receipts Flag. Description: Logical as to whether functional role has ability to view receipts for expense reports.
 

ADJUST_CEILING_MODIFY_FL 
ColumnName  ADJUST_CEILING_MODIFY_FL 
Definition 
Name: Adjust Ceiling Flag. Description: Logical as to whether role can adjust expense ceilings. 
 

REVISIONS_FL 
ColumnName  REVISIONS_FL 
Definition 
Name: Revision Without Status Change Flag. Description: Logical as to whether revised expense reports and authorizations need to go through another draft status, requiring a re-sign and re-approval.
 

S_CORRECTION_CD 
ColumnName  S_CORRECTION_CD 
Definition 
Name: Correction Code. Description: Determines whether roles with this class can perform expense report corrections and what type can be performed. Valid values are: 0 – not allowed,1 – Net Zero Only,2 – All Corrections Allowed.
 

DAYS_PAST_EXP_RPT_NO 
ColumnName  DAYS_PAST_EXP_RPT_NO 
Definition 
Name: Days Past Expense Report Date. Description: Number of days past the expense report’s date that corrections can be performed.
 

ACTIVE_CHARGES_ONLY_FL 
ColumnName  ACTIVE_CHARGES_ONLY_FL 
Definition 
Name: Active Charges Only. Description: Determines whether only expense reports with active charges can be corrected.