Name | Type | Length | Precision | Scale | References | In | Description |
---|---|---|---|---|---|---|---|
description | VARCHAR2 | 999 | Job role description | ||||
has_own_time_approval | VARCHAR2 | 3 | Has own time approval | ||||
has_replace_assignments | VARCHAR2 | 3 | Has Replace Assignments | ||||
is_project_time_approver | VARCHAR2 | 3 | Is project time approver | ||||
isinactive | VARCHAR2 | 3 | Is role inactive | ||||
job_resource_role_id | NUMBER | 39 | 0 | Job resource role ID | |||
name | VARCHAR2 | 50 | Name of the job role | ||||
send_mail_for_ratoff_conflict | VARCHAR2 | 3 | Whether to send email notifications if resource allocations and planned time off conflict |
PK Column Name |
---|
job_resource_role_id |
FK Name | PK Column Name | FK Table Name | FK Column Name | Key Seq |
---|---|---|---|---|
Employees_job_resource_role_fk | job_resource_role_id | Employees | default_job_resource_role_id | 1 |