DW_NS_employee_D
This table contains information about the employee entity.
Details
Module:
Key Columns
id
Columns
| Name | Datatype | Length | Precision | Not Null | Comments | Referred Table | Referred Column |
|---|---|---|---|---|---|---|---|
| id | NUMBER | 38 | 0 | True | |||
| SOURCE_RECORD_ID | VARCHAR2 | 128 | This column is for Oracle Internal use only. This is source record id column. | ||||
| firstname | VARCHAR2 | 64 | First Name | ||||
| lastname | VARCHAR2 | 64 | Last Name | ||||
| middlename | VARCHAR2 | 64 | Middle Name | ||||
| eligibleforcommission | VARCHAR2 | 16 | Eligible for Commission | ||||
| commissionpaymentpreference | VARCHAR2 | 64 | Pay Commissions Using | DW_NS_CommissionPaymentType_D | key | ||
| isinactive | VARCHAR2 | 16 | Inactive | ||||
| issalesrep | VARCHAR2 | 16 | Sales Group | ||||
| issupportrep | VARCHAR2 | 16 | Support Rep | ||||
| datecreated | TIMESTAMP | Date Created | |||||
| hiredate | TIMESTAMP | Hire Date | |||||
| releasedate | TIMESTAMP | Termination/Release Date | |||||
| approver | NUMBER | 38 | 0 | Expense Approver | DW_NS_employee_D | id | |
| class | NUMBER | 38 | 0 | Class | DW_NS_classification_D | id | |
| currency | NUMBER | 38 | 0 | Currency | DW_NS_currency_D | id | |
| defaultexpensereportcurrency | NUMBER | 38 | 0 | Default Currency For Expense Reports | DW_NS_currency_D | id | |
| department | NUMBER | 38 | 0 | Department | DW_NS_department_D | id | |
| employeestatus | NUMBER | 38 | 0 | Employee Status | DW_NS_EMPLOYEESTATUS_D | id | |
| employeetype | NUMBER | 38 | 0 | Type | DW_NS_EmployeeType_D | id | |
| location | NUMBER | 38 | 0 | Location | DW_NS_location_D | id | |
| purchaseorderapprover | NUMBER | 38 | 0 | Purchase Approver | DW_NS_employee_D | id | |
| subsidiary | NUMBER | 38 | 0 | Subsidiary | DW_NS_subsidiary_D | id | |
| supervisor | NUMBER | 38 | 0 | Supervisor | DW_NS_employee_D | id | |
| workplace | NUMBER | 38 | 0 | Workplace | DW_NS_workplace_D | id | |
| VARCHAR2 | 512 | ||||||
| entityid | VARCHAR2 | 256 | Entity ID | ||||
| homephone | VARCHAR2 | 128 | Home Phone | ||||
| initials | VARCHAR2 | 16 | Initials | ||||
| jobdescription | VARCHAR2 | 16 | Internal Column - Do not use. Job Description | ||||
| mobilephone | VARCHAR2 | 128 | Mobile Phone | ||||
| officephone | VARCHAR2 | 128 | Office Phone | ||||
| phone | VARCHAR2 | 128 | Phone | ||||
| salutation | VARCHAR2 | 32 | Mr./Ms... | ||||
| title | VARCHAR2 | 256 | Job Title | ||||
| approvallimit | NUMBER | Expense Approval Limit | |||||
| expenselimit | NUMBER | Expense Limit | |||||
| purchaseorderapprovallimit | NUMBER | Purchase Approval Limit | |||||
| purchaseorderlimit | NUMBER | Purchase Limit | |||||
| lastmodifieddate | TIMESTAMP | Last Modified Date | |||||
| isjobmanager | VARCHAR2 | 16 | Job Manager | ||||
| isjobresource | VARCHAR2 | 16 | Job Resource | ||||
| defaultjobresourcerole | NUMBER | 38 | 0 | Default Job Resource Role | DW_NS_JobResourceRole_D | id | |
| workcalendar | NUMBER | 38 | 0 | Work Calendar | DW_NS_workCalendar_D | id | |
| laborcost | NUMBER | Labor Cost | |||||
| targetutilization | NUMBER | Target Utilization | |||||
| billingclass | NUMBER | 38 | 0 | DW_NS_billingclass_D | id |