Company

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 D Decimal P Percent
MyPaycheckDisbl	Indicates that my paycheck & taxes/direct deposits should be disabled	Enum	1		ENUM
ChangeLogEnable	Indicates that trigger should proceed for this company	Enum	1		ENUM
InstaPayEnable	Indicates that this company uses Instapay	Enum	1		ENUM
ClientID		Long	12
ClientName		Varchar	80
AdvSecFlg	Advanced Security Flag	Enum	1		ENUM L Legacy A Advanced
LstModBy	Last Modified By Name	Varchar	40
LstModDate	Last Modified Date	Date	32
LockSeqNbr	*SYSTEM* Row Sequence Nbr	Long	12