Attribute/Logical Rolename |
Domain |
Datatype |
NULL |
Definition |
FUNCTIONAL_ROLE_CD |
|
VARCHAR(10) |
NO |
Name: Functional Role. Description: Unique identifier for this functional role. |
FUNCTIONAL_ROLE_NAME |
|
VARCHAR(30) |
NO |
Name: Functional Role Description. Description: Unique description of functional role. |
S_ROLE_TYPE_CD |
|
VARCHAR(1) |
NO |
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 |
|
VARCHAR(1) |
NO |
Name: Modify Timesheet Flag. Description: Logical as to whether this supervisor can modify the timesheets of the employees in this group. |
TS_APPROVE_FL |
|
VARCHAR(1) |
NO |
Name: Approve Timesheet Flag. Description: Logical as to whether this supervisor can approve the employee timesheets. |
MODIFIED_BY |
|
VARCHAR(20) |
NO |
Name: Modified By. Description: The User ID of the person who last modified this record. |
ROWVERSION |
|
NUMERIC(10, 0) |
NO |
Name: Row Version. Description: The number of times this record has been updated. |
TIME_STAMP |
|
DATE |
NO |
Name: Time Stamp. Description: Date and time the record was last modified. |
EMPL_GROUP_MODIFY_FL |
|
VARCHAR(1) |
NO |
Name: Modify Employee Group Flag. Description: Logical as to whether this supervisor can modify employee groups with this role. |
UDT_MODIFY_FL |
|
VARCHAR(1) |
NO |
Name: Modify UDT Flag. Description: Logical as to whether this supervisor can modify udts with this role. |
UDT_APPROVE_FL |
|
VARCHAR(1) |
NO |
Name: Approve UDT Charges Flag. Description: Logical as to whether this supervisor can approve udts with this role. |
EMPL_MODIFY_FL |
|
VARCHAR(1) |
NO |
Name: Modify Employee Flag. Description: Logical as to whether this supervisor can modify employee records with this role. |
TS_VIEW_FL |
|
VARCHAR(1) |
NO |
Name: View Timesheet Flag. Description: Logical as to whether this supervisor can view the timesheets of the employees in this group. |
RATE1_VIEW_FL |
|
VARCHAR(1) |
NO |
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 |
|
VARCHAR(1) |
NO |
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 |
|
VARCHAR(1) |
NO |
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 |
|
VARCHAR(1) |
NO |
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 |
|
VARCHAR(1) |
NO |
Name: View Schedule Flag. Description: Logical as to whether functional role has ability to view employee schedule. |
SCHEDULE_MODIFY_FL |
|
VARCHAR(1) |
NO |
Name: Modify Schedule Flag. Description: Logical as to whether functional role has ability to modify employee schedule. |
SCHEDULE_APPROVE_FL |
|
VARCHAR(1) |
NO |
Name: Approve Schedule Flag. Description: Logical as to whether functional role has ability to approve employee schedule. |
EXPENSE_VIEW_FL |
|
VARCHAR(1) |
NO |
Name: View Expense Reports Flag. Description: Logical as to whether functional role has ability to view employee expense reports. |
EXPENSE_MODIFY_FL |
|
VARCHAR(1) |
NO |
Name: Modify Expense Reports Flag. Description: Logical as to whether functional role has ability to modify employee expense reports. |
EXPENSE_APPROVE_FL |
|
VARCHAR(1) |
NO |
Name: Approve Expense Charges Flag. Description: Logical as to whether functional role has ability to approve expense reports. schedule. |
RECORD_RECEIPTS_FL |
|
VARCHAR(1) |
NO |
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 |
|
VARCHAR(1) |
NO |
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 |
|
VARCHAR(1) |
NO |
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 |
|
VARCHAR(1) |
NO |
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 |
|
VARCHAR(1) |
NO |
Name: Allow Delegation Flag. Description: Logical as to whether employees who have the functional role can be delegated. |
DELEGATION_ROLE_CD |
|
VARCHAR(10) |
YES |
Name: Delegated Funtional Role. Description: The functional role code that can be delegated tasks/alerts for this functional role. |
IMAGE_RECEIPTS_FL |
|
VARCHAR(1) |
NO |
Name: Image Receitps Flag. Description: Logical as to whether functional role has ability to image receipts for expense reports. |
VIEW_RECEIPTS_FL |
|
VARCHAR(1) |
NO |
Name: View Receipts Flag. Description: Logical as to whether functional role has ability to view receipts for expense reports. |
ADJUST_CEILING_MODIFY_FL |
|
VARCHAR(1) |
NO |
Name: Adjust Ceiling Flag. Description: Logical as to whether role can adjust expense ceilings. |
REVISIONS_FL |
|
VARCHAR(1) |
NO |
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 |
|
VARCHAR(1) |
NO |
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 |
|
NUMERIC(3, 0) |
NO |
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 |
|
VARCHAR(1) |
NO |
Name: Active Charges Only. Description: Determines whether only expense reports with active charges can be corrected. |