| 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 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|