EMPLOYEESAUDIT
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 : EMPLOYEESAUDIT
Description : This table tracks changes to an employees salary field.
Attributes Caption Nullability Persistent DataType Business Rule
EmployeeID Employee ID Required Persistent Long
DateChanged date Required Persistent DateTime Default(date())
LogonID System User Optional Persistent VarChar(32) Formula( If ( Inserting ) Then $value = USER() End If )
OldSalary Old Salary Optional Persistent Currency Default(0)
NewSalary New Salary Optional Persistent Currency ParentReplicate(Employee(EMPLOYEES), Salary, Not Maintained)
CurrName CurrName Optional Persistent VarChar(32) ParentReplicate(Employee(EMPLOYEES), Name, Not Maintained)
OldName OldName Optional Persistent VarChar(32) Formula(getEmployee().getOldName())
Constraints When Constraint Error Message
Event Condition Action Condition Action
Parent Relationships Parent Child Enforced
Child Relationships Child Parent Enforced
EMPLOYEES_JN_EMPLOYEESAUDIT EMPLOYEESAUDIT (EmployeeAudit) EMPLOYEES (Employee) Enforced
Indexes
PKEY_EMPSALHIST EmployeeID || DateChanged || Pimary Key
User Defined Methods Method Signature
addListeners public void SampDB1.EMPLOYEESAUDITImpl.addListeners()
getNewObject public static SampDB1.EMPLOYEESAUDITImpl SampDB1.EMPLOYEESAUDITImpl.getNewObject(versata.vls.Session,boolean)
Used By Used In
EmpSalaryHistory QUERY
EMPLOYEESAUDIT FORM PDX_Dynamic_Hide_Show_Style:pEMPLOYEESAUDIT
EMPLOYEESAUDIT FORM PDX_Inclusion:pBottomRightAUDIT
EMPLOYEESAUDIT FORM Server_EventAction_CreateChildren:fEMPLOYEES