Job_resource_role

Columns

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

Primary key

PK Column Name
job_resource_role_id

Foreign keys referencing this table

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