| DEPARTMENT | |||||||||||||||||||||||||||
| Repository name : | SampDB1 | ||||||||||||||||||||||||||
| Repository location : | C:\Versata_55\Samples\SampDB1 | ||||||||||||||||||||||||||
| Analysis date : | Tue Sep 16 16:10:05 PDT 2003 | ||||||||||||||||||||||||||
| Analysis run on machine : | TYLER_DELL | ||||||||||||||||||||||||||
| Analysis run by user : | Tyler | ||||||||||||||||||||||||||
| DataObject Name : | DEPARTMENT | ||||||||||||||||||||||||||
| Description : | The department structure of the organization | ||||||||||||||||||||||||||
| Attributes | Caption | Nullability | Persistent | DataType | Business Rule | ||||||||||||||||||||||
| DeptNum | Dept Number | Required | Persistent | AutoNumber | |||||||||||||||||||||||
| Name | Name | Optional | Derived | VarChar(24) | |||||||||||||||||||||||
| HeadDeptNum | Head Dept. | Optional | Persistent | Long | |||||||||||||||||||||||
| BudgAllocCap | Maximum Allowable Budget | Optional | Persistent | Currency | Default(0) | ||||||||||||||||||||||
| BudgAllocRem | Remaining Budget | Optional | Persistent | Currency | Formula(BudgAllocCap - BudgAllocTotal) | ||||||||||||||||||||||
| BudgAllocSubs | Budget of Subs | Optional | Persistent | Currency | Sum(SubDepartments(DEPARTMENT), BudgAllocTotal, RepositoryName = SampDB1 and AttrName = BudgAllocSubs and DataObjectName = DEPARTMENT) | ||||||||||||||||||||||
| BudgAllocLocal | Admin Budget | Optional | Persistent | Currency | Default(0) | ||||||||||||||||||||||
| BudgAllocTotal | Cur Budget Allocation | Optional | Persistent | Currency | Formula(BudgAllocSubs+BudgAllocLocal) | ||||||||||||||||||||||
| ManagerCount | # of Mgrs | Optional | Persistent | Integer | Count(EmployeesReportingTo(EMPLOYEES), RepositoryName = SampDB1 and AttrName = ManagerCount and DataObjectName = DEPARTMENT) | ||||||||||||||||||||||
| Mission | Mission | Optional | Persistent | VarChar(250) | |||||||||||||||||||||||
| ManagerEmpID | ManagerEmpID | Optional | Persistent | Long | Default(0) | ||||||||||||||||||||||
| Constraints | When | Constraint | Error Message | ||||||||||||||||||||||||
| BudgetAuthorityExceeded | RejectWhen | BudgAllocTotal > BudgAllocCap | The budget authority has been exceeded. (Check the Maximum Allowable Budget for department and all parent departments) | ||||||||||||||||||||||||
| ValidHeadDepartment | AcceptWhen | HeadDeptNum IS NULL OR (HeadDeptNum != DeptNum ) | A department may not list its head department as itself. Leave head department blank instead. | ||||||||||||||||||||||||
| Event Condition Action | Condition | Action | |||||||||||||||||||||||||
| Parent Relationships | Parent | Child | Enforced | ||||||||||||||||||||||||
| DEPARTMENT_JN_DEPARTMENT | DEPARTMENT (HeadDepartment) | DEPARTMENT (SubDepartments) | Enforced | ||||||||||||||||||||||||
| DEPARTMENT_JN_EMPLOYEES | DEPARTMENT (ReportingDepartment) | EMPLOYEES (EmployeesReportingTo) | Enforced | ||||||||||||||||||||||||
| DEPARTMENT_JN_EMPLOYEES | DEPARTMENT (OnLoanDepartment) | EMPLOYEES (EmployeesOnLoanTo) | Enforced | ||||||||||||||||||||||||
| Child Relationships | Child | Parent | Enforced | ||||||||||||||||||||||||
| DEPARTMENT_JN_DEPARTMENT | DEPARTMENT (SubDepartments) | DEPARTMENT (HeadDepartment) | Enforced | ||||||||||||||||||||||||
| EMPLOYEES_JN_DEPARTMENT | DEPARTMENT (Manages) | EMPLOYEES (ManagedBy) | Enforced | ||||||||||||||||||||||||
| Indexes | |||||||||||||||||||||||||||
| BudgAllocRem_DEPARTMENT | BudgAllocRem || | ||||||||||||||||||||||||||
| User Defined Methods | Method Signature | ||||||||||||||||||||||||||
| addListeners | public void SampDB1.DEPARTMENTImpl.addListeners() | ||||||||||||||||||||||||||
| getNewObject | public static SampDB1.DEPARTMENTImpl SampDB1.DEPARTMENTImpl.getNewObject(versata.vls.Session,boolean) | ||||||||||||||||||||||||||
| defaultMission | public void SampDB1.DEPARTMENTImpl.defaultMission(java.lang.String) | ||||||||||||||||||||||||||
| defaultMissionBySearchRequest | private java.util.Enumeration SampDB1.DEPARTMENTImpl.defaultMissionBySearchRequest() | ||||||||||||||||||||||||||
| getAllSubDepartments | public versata.common.BusinessObjectCollection SampDB1.DEPARTMENTImpl.getAllSubDepartments() | ||||||||||||||||||||||||||
| getMyDepartments | public void SampDB1.DEPARTMENTImpl.getMyDepartments(java.util.Vector,SampDB1.DEPARTMENTImpl) | ||||||||||||||||||||||||||
| Used By | Used In | ||||||||||||||||||||||||||
| DEPARTMENT | Sum BudgAllocTotal | ||||||||||||||||||||||||||
| DeptJoinSubDept | QUERY | ||||||||||||||||||||||||||
| DeptJoinSubDept | QUERY | ||||||||||||||||||||||||||
| EmpJoinDept | QUERY | ||||||||||||||||||||||||||
| OrderJoinSalesRepAndMgr | QUERY | ||||||||||||||||||||||||||
| DEPARTMENT | FORM Controls_Tree:pDEPARTMENT_Grid | ||||||||||||||||||||||||||
| DEPARTMENT | FORM Controls_Tree:pDEPARTMENT | ||||||||||||||||||||||||||
| DEPARTMENT | FORM Events_Tracing:pDEPARTMENT | ||||||||||||||||||||||||||
| DEPARTMENT | FORM Events_Tracing:pDEPARTMENT | ||||||||||||||||||||||||||
| DEPARTMENT | FORM PDX_Basic_HTML:pDepartment | ||||||||||||||||||||||||||
| DEPARTMENT | FORM PDX_Cascading_Picks:pDEPARTMENT | ||||||||||||||||||||||||||
| DEPARTMENT | FORM PDX_Inclusion:pDEPARTMENT | ||||||||||||||||||||||||||
| DEPARTMENT | FORM PDX_Inclusion:pDEPARTMENT10 | ||||||||||||||||||||||||||
| DEPARTMENT | FORM Basic_Data_Access:DEPARTMENT | ||||||||||||||||||||||||||
| DEPARTMENT | FORM Basic_Data_Access:DEPARTMENT | ||||||||||||||||||||||||||
| DEPARTMENT | FORM Basic_Data_Access:DEPARTMENT | ||||||||||||||||||||||||||
| DEPARTMENT | FORM Demo_BusinessObject_Methods:DEPARTMENT | ||||||||||||||||||||||||||
| DEPARTMENT | FORM MDI_Application:fDEPARTMENT | ||||||||||||||||||||||||||
| DEPARTMENT | FORM VFC_Swing_Controls:demoVSTreeTable | ||||||||||||||||||||||||||
| DEPARTMENT | FORM DepartmentExceptions:fDEPARTMENT | ||||||||||||||||||||||||||
| DEPARTMENT | FORM DepartmentExceptions:fDEPARTMENT | ||||||||||||||||||||||||||