DW_NS_entityGroup_D
This table contains information about entity groups. A entity group is a group of people that perform a specific step in the manufacturing process.
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. | ||||
| groupmembership | VARCHAR2 | 16 | Membership | ||||
| groupname | VARCHAR2 | 128 | Name | ||||
| groupowner | NUMBER | 38 | 0 | Owner | DW_NS_employee_D | id | |
| grouptypename | VARCHAR2 | 512 | Type | ||||
| isfunctionalteam | VARCHAR2 | 16 | Functional Team | ||||
| isinactive | VARCHAR2 | 16 | Inactive | ||||
| ismanufacturingworkcenter | VARCHAR2 | 16 | Manufacturing Work Center | ||||
| isprivate | VARCHAR2 | 16 | Private | ||||
| isproductteam | VARCHAR2 | 16 | Product Team | ||||
| issalesrep | VARCHAR2 | 16 | Sales Group | ||||
| issupportrep | VARCHAR2 | 16 | Support Group | ||||
| laborresources | NUMBER | Labor Resources | |||||
| machineresources | NUMBER | Machine Resources | |||||
| restrictedtoowner | VARCHAR2 | 16 | Restrict Group Editing to Owner | ||||
| restrictiongroup | NUMBER | 38 | 0 | Restrict to | DW_NS_entityGroup_D | id | |
| subsidiary | NUMBER | 38 | 0 | Subsidiary | DW_NS_subsidiary_D | id | |
| workcalendar | NUMBER | 38 | 0 | Work Calendar | DW_NS_workCalendar_D | id |