FUNCTIONAL_ROLE 
Default Table Name  FUNCTIONAL_ROLE 
Definition 
 Name: Functional role.     Description: This table contains the user defined functional roles.
 

FUNCTIONAL_ROLE Attributes 
Attribute/Logical Rolename  Domain  Datatype  NULL  Definition 
FUNCTIONAL_ROLE_CD(PK)    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(FK)    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.
 

FUNCTIONAL_ROLE Keys 
Key Name  Key Type  Keys 
PI_0129  PrimaryKey  FUNCTIONAL_ROLE_CD 
RI_F00317  Inversion Entry  DELEGATION_ROLE_CD 

FUNCTIONAL_ROLE Relationships 
Parent Relationships: 
Entity Name  Type  Cardinality  Business Name  VerbPhrase  InversePhrase  Foreign Keys  Is Supertype 
FUNCTIONAL_ROLE  Non-Identifying  Zero or One to Zero or More        DELEGATION_ROLE_CD  NO 
Child Relationships: 
Entity Name  Type  Cardinality  Business Name  VerbPhrase  InversePhrase  Foreign Keys  Is Subtype 
EMPL_GROUP_SPVSR  Identifying  One To Zero or More          NO 
EVENT  Non-Identifying  One To Zero or More          NO 
EVENT_NOTIFICATION  Identifying  One To Zero or More          NO 
UDT01_SPVSR  Identifying  One To Zero or More          NO 
UDT02_SPVSR  Identifying  One To Zero or More          NO 
DESKTOP_TASKS  Identifying  One To Zero or More          NO 
DESKTOP_ALERTS  Identifying  One To Zero or More          NO 
DESKTOP_EXPENSE_ALERTS  Identifying  One To Zero or More          NO 
DESKTOP_SCHEDULE_TASKS  Identifying  One To Zero or More          NO 
FUNCTIONAL_ROLE  Non-Identifying  One To Zero or More          NO 
DESKTOP_DELEGATION_EMPLOYEE  Identifying  One To Zero or More          NO 
DESKTOP_DELEGATION_UDT  Identifying  One To Zero or More          NO 
DESKTOP_AUTH_TASKS  Identifying  One To Zero or More          NO 
LIFE_EVENT  Non-Identifying  One To Zero or More          NO 
LIFE_EVENT  Non-Identifying  One To Zero or More          NO 
DESKTOP_SELF_SERVICE_TASKS  Non-Identifying  One To Zero or More          NO 
DESKTOP_SELF_SERVICE_ALERTS  Identifying  One To Zero or More          NO 
ESS_CONFIG  Non-Identifying  One To Zero or More          NO 
EXP_RPT_TASKS_EMPL  Identifying  One To Zero or More          NO 
EXP_AUTH_TASKS_EMPL  Identifying  One To Zero or More          NO 
CORRECT_EXP_RPT_TASKS_EMPL  Identifying  One To Zero or More          NO 
EXP_TYPE_TASK  Identifying  One To Zero or More          NO 
EXP_RPT_TYPE_TASK  Identifying  One To Zero or More          NO 
EXP_RPT_TYPE_TASK  Non-Identifying  One To Zero or More          NO 
TASK  Non-Identifying  One To Zero or More          NO 
TASK  Non-Identifying  Zero or One to Zero or More          NO 
CORRECT_TASK  Non-Identifying  Zero or One to Zero or More          NO 
CORRECT_TASK  Non-Identifying  One To Zero or More          NO 
TASK_EMPL  Identifying  One To Zero or More          NO 
CORRECT_TASK_EMPL  Identifying  One To Zero or More          NO