Class PM_Employee_svc

Inherits

CI_MFGEmployeeFormatter, PM_EmployeeBrowse, SY_Service

Properties

LOCAL cMainTable$="PM_Employee"  

[string] main table for class

LOCAL cIsSysDB=isFALSE  

[boolean] value denoting whether the main table is a system table

Methods

FUNCTION FormatEmployeeName$(employeeKey$)  
FUNCTION FormatEmployeeName$(employeeKey$, lastNameFirst)  

Returns empty string or Employee Name formatted as First Name + Middle Initial + Last Name + Suffix or Last Name + Suffix + First Name + Middle Name

ParameterDescription
employeeKey$ [input string] Key to employee record
lastNameFirst {optional} [input, boolean] when true () employee name will be formatted with last name first
Returns [string] empty string or formatted employee name
FUNCTION GetEmployeeInfo(employeeKey$, empNoFormatted$, empNameFormatted$)  
FUNCTION GetEmployeeInfo(employeeKey$, empNoFormatted$, empNameFormatted$, lastNameFirst)  

Returns formatted department / employee number and employee name formatted as First Name + Middle Initial + Last Name + Suffix or Last Name + Suffix + First Name + Middle Name

ParameterDescription
employeeKey$ [input string] Key to employee record
empNoFormatted$ [output, string] string with properly formatted department / employee number
empNameFormatted$ [output, string] string with formatted employee name
lastNameFirst {optional} [input, boolean] when true () employee name will be formatted with last name first
Returns retSUCCESS(1) if employee was found otherwise returns retFAILURE(0)
FUNCTION LookupPostRead(encryptedVals$, decryptedRec$, decryptedIOL$)  

Called from ALE Post Select routine, needed to decrypt information within the employee table. Will return a decrypted record and iolist of data from the Employee table

ParameterDescription
encryptedVals$ [input, string] Encrypted values column from the encrypted table.
decryptedRec$ [output, string] $8A$ separated list of decrypted values
decryptedIOL$ [output, string] compiled Providex IOList, of the columns that are encrypted.
Returns retSUCCESS(1) if decryption was successful, otherwise returns retFAILURE(0)
FUNCTION LookupSetup(empMask$, lockLookup$, deptSecurity$)  

Called from ALE initialize logic to set variables needed for employee mask and to lock lookup from customization.

ParameterDescription
empMask$ [output, string] mask to be used to display department/employee number combination within the lookup
lockLookup [output, string] Y/N flag to indicate whether the user is allowed to customize the lookup
deptSecurity$ [output, string] list of departments user is allowed to access
Returns Always returns retSUCCESS(1)

Properties inherited from: CI_MFGEmployeeFormatter

DepartmentLength

Properties inherited from: SY_Service

BOF, CurrentBrowseIndex$, CurrentIndex$, EOF, SecurityAccess

Methods inherited from: CI_MFGEmployeeFormatter

ParseEmployee()

Methods inherited from: PM_EmployeeBrowse

MoveFirst(), MoveLast(), MoveNext(), MovePrevious()

Methods inherited from: SY_Service

BindVariable(), CheckMainTable(), Clear(), Find(), FindById(), GetChildHandle(), GetChildKeyReference$(), GetColumns$(), GetDataSources$(), GetDataSourcesAddl$(), GetJson$(), GetKey$(), GetKeyColumns$(), GetKeyPadded$(), GetPartialRecord(), GetRecord(), GetRecordCount(), GetRecordEx(), GetResultSets(), GetTable$(), GetTablePath$(), GetValue(), GetValues(), IsValid(), MoveFirst(), MoveLast(), MoveNext(), MovePrevious(), ReadAdditional(), SetBrowseFilter(), SetBrowseIndex(), SetCacheMode(), SetIndex(), SetKeyValue(), SetParentColumns(), SetParentHandle(), SetUIHandle(), PERFORM ClearEditRcd(), FormatJson$(), GetAddlDataSources(), GetDateColumns$(), InitChildCollection(), MoveFirstLast(), MoveNextPrevious(), OpenMainTable(), ParseKeyDef(), PrepareKeyDef(), ReadRec(), ResolveColumnList$(), SetControls(), SetCurrentKey(), UseKeyColl()