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. |