| CompanyID
|
Company Identifier |
SmallID |
12 |
|
| Address1
|
Address, Line 1 |
Varchar |
80 |
|
| Address2
|
Address, Line 2 |
Varchar |
80 |
|
| City
|
City |
Varchar |
80 |
|
| State
|
State Code |
Varchar |
2 |
|
| ZipCode
|
Zip Code |
Varchar |
10 |
|
| Country
|
Country |
Varchar |
80 |
|
| BiCycleDt
|
Billing Cycle End Date |
Date |
32 |
|
| CmpnyName
|
Company Name |
Varchar |
120 |
|
| CobraName
|
Cobra Notice Send Name |
Varchar |
80 |
|
| CobraTitle
|
Cobra Notice Send Title |
Varchar |
80 |
|
| CobraSignPhone
|
Cobra signatory contact phone |
Varchar |
40 |
|
| DefHoursWk
|
Default Hours Per Week |
Number |
22 |
|
| FaxNbr
|
Fax Number |
Varchar |
25 |
|
| FedTaxID
|
Federal Tax Identifier |
Varchar |
25 |
|
| FiscalDay
|
Fiscal Year - Start Day |
Long |
12 |
|
| FiscalMon
|
Fiscal Year - Start Month |
Long |
12 |
|
| Notes
|
Comments |
Text |
16000 |
|
| PayPeriod
|
Pay Period |
Enum |
1 |
|
 ENUM
| D | Daily |
| W | Weekly |
| B | Bi-Weekly |
| S | Semi-Monthly |
| M | Monthly |
|
| Period
|
Period |
Long |
12 |
|
| PhoneNbr
|
Phone Number |
Varchar |
40 |
|
| SICNbr
|
Standard Industrial Code |
Varchar |
25 |
|
| UpgradeSt
|
System Upgrade Status |
Varchar |
128 |
|
| EEO4GovFlag
|
Government or Priviate |
Enum |
1 |
|
 ENUM
| G | Government (EEO-4) |
| P | Private Sector (EEO-1) |
|
| YearType
|
Fiscal Year Type |
Enum |
1 |
|
 ENUM
| B | Back Year |
| C | Company Fiscal |
| E | Employee |
| Y | Calendar |
| X | 12 Months Between |
|
| CompanyType
|
Normal, Sample, Applicant |
Enum |
1 |
|
 ENUM
| N | Normal |
| S | Sample |
| A | Applicant |
|
| SMTPFQDomain
|
SMTP Fully Qualified Domain |
Varchar |
120 |
|
| SMTPUsername
|
User Name for SMTP |
Varchar |
255 |
|
| SMTPPassword
|
SMTP Password |
Varchar |
80 |
|
| HipaaClrHsUserID
|
User Password |
Varchar |
40 |
|
| HipaaClrHsPwd
|
Clearinghouse specific user password |
Varchar |
40 |
|
| HRUserPID
|
UserPID for HR contact. |
Varchar |
80 |
|
| DataPath
|
Company-specific path to file data |
Text |
16000 |
|
| UnlimDpst
|
Y/N - Y: unlimited d deposts, N: Limit of NumDpst |
Varchar |
1 |
|
| NumDpst
|
Maximum number of direct deposits allowed |
Long |
12 |
|
| ComparatioFmt
|
(Percent | Decimal) |
Enum |
1 |
|
 ENUM
|
| LstModBy
|
Last Modified By Name |
Varchar |
40 |
|
| LstModDate
|
Last Modified Date |
Date |
32 |
|
| LockSeqNbr
|
*SYSTEM* Row Sequence Nbr |
Long |
12 |
|