| CompanyID
|
Company Identifier |
SmallID |
12 |
|
| LogoSource
|
path to jpg |
Text |
16000 |
|
| AlwEmpAuthAgain
|
Allow employee to re-authenticate after X minutes. |
Long |
12 |
|
| AlwLeaveTaken
|
Show employees leave taken records (Y/N) |
Varchar |
1 |
|
| AlwLeaveCmnt
|
Allow leave comments to be shown |
Varchar |
1 |
|
| LeaveAdjStyle
|
How to display leave adjustments: Separate: adjustments shown separately, Foldin1: pos adjust add to accrued, neg adj add to taken, Foldin2: roll adjust into accrued |
Enum |
1 |
|
 ENUM
| S | Separate |
| 1 | Foldin1 |
| 2 | Foldin2 |
|
| DisblAftFailNum
|
Number of failures before disabling account |
Long |
12 |
|
| DisblAftLogFail
|
After # of login failures, disable (DisblAfterFailNum determines #) (Y/N) |
Varchar |
1 |
|
| IdVerBirthDate
|
Birth date part of verification process (Y/N) |
Varchar |
1 |
|
| IdVerChkNick
|
Check nick name for first name match (Y/N) |
Varchar |
1 |
|
| IdVerEmail
|
Email part of verification process (Y/N) |
Varchar |
1 |
|
| IdVerEmpID
|
Emp ID part of verification process (Y/N) |
Varchar |
1 |
|
| IdVerHireDate
|
Hire date part of verification process (Y/N) |
Varchar |
1 |
|
| IdVerHomePhone
|
Home Phone part of verification process (Y/N) |
Varchar |
1 |
|
| IdVerifyChoice
|
first last and ALL, or first last and some |
Enum |
1 |
|
ENUM
|
| IdVerifyNumReqd
|
Number of fields required for authentication |
Long |
12 |
|
| IdVerSSN
|
SSN part of verification process (Y/N) |
Varchar |
1 |
|
| PwdMinLen
|
|
Long |
12 |
|
| PwdMinLenReqd
|
(Y/N) |
Varchar |
1 |
|
| PwdReqAlphaNum
|
Require letters AND numbers in pwd (Y/N) |
Varchar |
1 |
|
| ReenableAfter
|
Number of minutes to wait before reenabling |
Long |
12 |
|
| ReenablePer
|
Reenable after a time period specified in ReenableAfter (Y/N) |
Varchar |
1 |
|
| RemUserID
|
Remember user id in browser between sessions (Y/N) |
Varchar |
1 |
|
| UserIDFormat
|
last first initial, first last initial, empid, ssn, email address, set up own |
Enum |
1 |
|
ENUM
| L | LFI |
| F | FLI |
| E | EMPID |
| S | SSN |
| M | EMAIL |
| C | CUSTOM |
|
| LogoDescription
|
|
Varchar |
100 |
|
| LogoLink
|
|
Text |
16000 |
|
| EssCompanyURL
|
Company website url |
Text |
16000 |
|
| fpAction
|
Forgotten password action |
Enum |
1 |
|
ENUM
| E | Email |
| A | Require Authorization |
| H | Contact HR |
|
| CntctName
|
Contact Name |
Varchar |
80 |
|
| CntctEmail
|
Contact Email Address |
Varchar |
80 |
|
| CntctPhone
|
Contact Phone Number |
Varchar |
40 |
|
| SndEmailConf
|
Y - indicates email should be sent confirming changes |
Enum |
1 |
|
ENUM
|
| LvRqCalcAmt
|
Y/N Leave requests should try to calculate the amount |
Varchar |
1 |
|
| UseCalendar
|
Y/N: indicates whether the Company uses the CalHoliday & CalWeekend tables |
Char |
1 |
|
| UseConnectStr
|
Y/N |
Varchar |
1 |
|
| LockSeqNbr
|
*SYSTEM* Row Sequence Nbr |
Long |
12 |
|