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