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