EMPLOYEES
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 : EMPLOYEES
Description : Table of all employees
Attributes Caption Nullability Persistent DataType Business Rule
EmpID Employee ID Required Persistent AutoNumber
Name Name Required Persistent VarChar(32)
LogonID Logon Optional Persistent VarChar(32)
WorksForDeptNum Works For Dept Required Persistent Long
OnLoanDeptNum On Loan Dept Optional Persistent Long
YearlyPay Yearly Pay Optional Persistent Currency Formula(IIF (EmpType = 'H', Salary * 52 * 40, IIF(EmpType = 'S', Salary * 12, IIF(EmpType = 'C', (Salary * 52) + (PaidOrderSum * CommissionRate), 0 ))))
DeptManager Is Manager Optional Persistent Boolean Default(false)
EmpType EmployeeType Required Persistent VarChar(1) CodedValueList( VALID_EMPTYPE )
Salary Salary Optional Persistent Currency Formula( If ( Salary IS NULL ) Then $value = 0ElseIf (PercentRaiseToGive IS NOT NULL ) Then $value = Salary * (1+ PercentRaiseToGive / 100) + dbDec('raise by rule')Else $value = Salary + dbDec('no raise by rule')End If)
UnionDues Union Dues Optional Persistent Currency
Territory Territory Optional Persistent VarChar(20)
PaidOrderSum Year's Paid Orders Optional Persistent Currency Sum(Orders(ORDERS), OrderTotal, RepositoryName = SampDB1 and AttrName = PaidOrderSum and DataObjectName = EMPLOYEES)
CommissionRate Commission Rate Optional Persistent Single Default(0.075)
Photo Photo Optional Persistent LongBinary
Email Email Optional Persistent VarChar(50)
PercentRaiseToGive PercentRaiseToGive Optional Derived Integer Formula(if ( 1=0 )then $value = 0end if)
EffectiveDateWorksForDept EffectiveDateWorksForDept Optional Derived Date Formula(null)
Constraints When Constraint Error Message
UnionDuesInappropriate RejectWhen UnionDues IS NOT NULL AND UnionDues > 0 AND EmpType != 'H' Only hourly employees can have union dues.
Event Condition Action Condition Action
AuditNameChanges Updating AND Name <> :Old. Name insertObjects('this', 'EMPLOYEESAUDITImpl', 'setEmployee( this ); setOldName( this.getOldName() ) ' )
CreateCommissionedSkills Inserting AND EmpType = 'C' /* Commission */ createSalesSkills()
CreateSalariedSkills Inserting AND EmpType = 'S' /* Salary*/ insertObjects('getValidEmpType().getDefaultSkills()', 'EMPLOYEESKILLImpl', 'setEmployee( this ); setSkillNum( source.getSkillNum() ) ' )
Parent Relationships Parent Child Enforced
EMPLOYEES_JN_DEPARTMENT EMPLOYEES (ManagedBy) DEPARTMENT (Manages) Enforced
EMPLOYEES_JN_EMPLOYEESAUDIT EMPLOYEES (Employee) EMPLOYEESAUDIT (EmployeeAudit) Enforced
EMPLOYEES_JN_EMPLOYEESKILL EMPLOYEES (Employee) EMPLOYEESKILL (EmployeeSkills) Enforced
EMPLOYEES_JN_EMPLOYEESPENDING EMPLOYEES (EmployeeForChanges) EMPLOYEESPENDING (PendingChanges) Enforced
EMPLOYEES_JN_ORDERS EMPLOYEES (SalesRep) ORDERS (Orders) Enforced
Child Relationships Child Parent Enforced
DEPARTMENT_JN_EMPLOYEES EMPLOYEES (EmployeesReportingTo) DEPARTMENT (ReportingDepartment) Enforced
DEPARTMENT_JN_EMPLOYEES EMPLOYEES (EmployeesOnLoanTo) DEPARTMENT (OnLoanDepartment) Enforced
VALID_EMPTYPE_JN_EMPLOYEES EMPLOYEES (Employee) VALID_EMPTYPE (ValidEmpType) Enforced
Indexes
Name_EMPLOYEES Name ||
User Defined Methods Method Signature
afterUpdate public void SampDB1.EMPLOYEESImpl.afterUpdate(versata.vls.DataObject)
addListeners public void SampDB1.EMPLOYEESImpl.addListeners()
getNewObject public static SampDB1.EMPLOYEESImpl SampDB1.EMPLOYEESImpl.getNewObject(versata.vls.Session,boolean)
giveRaise public void SampDB1.EMPLOYEESImpl.giveRaise(int) throws versata.common.VSORBException
createSalesSkills public void SampDB1.EMPLOYEESImpl.createSalesSkills()
populateSkills public void SampDB1.EMPLOYEESImpl.populateSkills(java.lang.String)
Used By Used In
DEPARTMENT Count
EMPLOYEESAUDIT ParentReplicate Salary
EMPLOYEESAUDIT ParentReplicate Name
ORDERS ParentReplicate EmpType
EmpJoinDept QUERY
EmpList QUERY
OrderJoinOptSalesRep QUERY
OrderJoinSalesRep QUERY
OrderJoinSalesRepAndMgr QUERY
OrderJoinSalesRepAndMgr QUERY
OrderJoinSalesRepCust QUERY
OrderJoinSalesRepForTree QUERY
EMPLOYEES FORM Events_DataSource:pEMPLOYEES_Grid
EMPLOYEES FORM Events_DataSource:pEMPLOYEESGiveRaise
EMPLOYEES FORM Events_Hide_Fields:pEMPLOYEES
EMPLOYEES FORM Recompute_Derivations:pEMPLOYEES_Grid
EMPLOYEES FORM Server_Extended_Properties:pEMPLOYEES
EMPLOYEES FORM SubClass:pEMPLOYEES
EMPLOYEES FORM PDX_Basic_HTML:pEmployeeSearch
EMPLOYEES FORM PDX_Basic_HTML:pEmployeeList
EMPLOYEES FORM PDX_Basic_HTML:pEmployeeDetails
EMPLOYEES FORM PDX_Basic_HTML:pAddEmployee
EMPLOYEES FORM Automation_Demo:pEMP_Add1
EMPLOYEES FORM Automation_Demo:pEMP_Add2_C
EMPLOYEES FORM Automation_Demo:pEMP_Add2_H
EMPLOYEES FORM Automation_Demo:pEMP_Add2_S
EMPLOYEES FORM Automation_Demo:pEMP_Add3_Skills
EMPLOYEES FORM PDX_Basic_Layout:pEMPLOYEES
EMPLOYEES FORM PDX_Dynamic_Hide_Show_Style:pEMPLOYEES
EMPLOYEES FORM PDX_Groups:pEMPLOYEES
EMPLOYEES FORM PDX_Groups:pEMPLOYEES
EMPLOYEES FORM PDX_Inclusion:pDEPARTMENT10
EMPLOYEES FORM PDX_Inclusion:pDEPARTMENT10
EMPLOYEES FORM PDX_Inclusion:pTopLeftEMPLOYEES
EMPLOYEES FORM PDX_Menu_Tabs:pEMPLOYEES
EMPLOYEES FORM _Demo:EmployeeList
EMPLOYEES FORM _Demo:fDepartment
EMPLOYEES FORM _Pick:fEmployee
EMPLOYEES FORM _Transitions:fEmpHello
EMPLOYEES FORM _Transitions:fFellowEmployeesGrid
EMPLOYEES FORM Basic_Data_Access:DEPARTMENT
EMPLOYEES FORM Client_Subclass_VariantPanel:fEMPLOYEES
EMPLOYEES FORM Client_Subclass_VariantPanel:fEMPLOYEE
EMPLOYEES FORM Demo_BusinessObject_Methods:DEPARTMENT
EMPLOYEES FORM Demo_BusinessObject_Methods:ObjectByRow
EMPLOYEES FORM Demo_BusinessObject_Methods:ObjectByFactory
EMPLOYEES FORM Demo_BusinessObject_Methods:fEmpByAttrs
EMPLOYEES FORM MDI_Application:fDEPARTMENT
EMPLOYEES FORM Server_EventAction_CreateChildren:fEMPLOYEES
EMPLOYEES FORM Server_Security:fEMPLOYEES
EMPLOYEES FORM Server_XDA_StoredProcedure:EMPLOYEES