Employee Metadata
GET {{base_url}}/metadata/employee
Use this endpoint to retrieve the Employee metadata.
The metadata describes the fields in each table of the database for the record and describes whether or not the table is a custom table and whether or not it has a grid ID. Each field describes whether or not the field is required, the data type, the default value, whether or not it is updateable, and other useful minimums, limits, and maximum details.
For more information, see Metadata Reference.
HEADERS
| Key | Datatype | Required | Description |
|---|---|---|---|
Content-Type | string | Required. |
The type of content supported by the API endpoint. |
| Authorization | string | | Required.
The type of authorization supported by the API endpoint. |
RESPONSES
status: OK
{"EM":{"Keys":"Employee","TableName":"EM","GridID":null,"Hidden":false,"Updateable":true,"Fields":[{"FieldName":"Employee","FieldType":"Employee","Caption":"Employee","DefaultValue":"[AUTONUMBER]","Hidden":false,"Required":true,"Updateable":false,"MaxLength":5},{"FieldName":"EmployeeCompany","FieldType":"Company","Caption":"Employee Companyxxxxx Name","DefaultValue":"[CURRENTCOMPANY]","Hidden":false,"Required":true,"Updateable":true,"MaxLength":14},{"FieldName":"Org","FieldType":"Org","Caption":"Organization","DefaultValue":"","Hidden":false,"Required":false,"Updateable":true,"MaxLength":11},{"FieldName":"Supervisor","FieldType":"Employee","Caption":"Supervisor","DefaultValue":"","Hidden":false,"Required":false,"Updateable":true,"MaxLength":5},{"FieldName":"SupervisorName","FieldType":"String","Caption":"Supervisor","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false,"MaxLength":200},{"FieldName":"HireDate","FieldType":"Date","Caption":"Hire Date","DefaultValue":"","Hidden":false,"Required":false,"Updateable":true},{"FieldName":"Status","FieldType":"Dropdown","Caption":"Status","DefaultValue":"A","Hidden":false,"Required":true,"Updateable":true,"MaxLength":30,"CodeTable":"CFGEmployeeStatus","LimitToList":true},{"FieldName":"YearsOtherFirms","FieldType":"Numeric","Caption":"Years with Other Firms","DefaultValue":"0","Hidden":false,"Required":false,"Updateable":true,"MaxValue":99},{"FieldName":"PriorYearsFirm","FieldType":"Numeric","Caption":"Prior Years with This Firm","DefaultValue":"0","Hidden":false,"Required":false,"Updateable":true,"MaxValue":99},{"FieldName":"ReadyForProcessing","FieldType":"Checkbox","Caption":"Approved for use in processing","DefaultValue":"N","Hidden":false,"Required":true,"Updateable":true},{"FieldName":"PayRate","FieldType":"Numeric","Caption":"Pay Rate","DefaultValue":"0","Hidden":false,"Required":false,"Updateable":true,"Digits":9,"Decimals":4},{"FieldName":"PayOvtPct","FieldType":"Numeric","Caption":"Pay Rate OT Pct","DefaultValue":"0","Hidden":false,"Required":false,"Updateable":true,"Decimals":2},{"FieldName":"PaySpecialOvtPct","FieldType":"Numeric","Caption":"Pay Rate OT-2 Pct","DefaultValue":"0","Hidden":false,"Required":false,"Updateable":true,"Decimals":2},{"FieldName":"PayType","FieldType":"Dropdown","Caption":"Pay Type","DefaultValue":"H","Hidden":false,"Required":true,"Updateable":true,"MaxLength":1,"Codes":{"H":"Hourly","S":"Salary"},"LimitToList":true},{"FieldName":"OtherPay","FieldType":"Currency","Caption":"Other Pay","DefaultValue":"0","Hidden":false,"Required":false,"Updateable":true},{"FieldName":"OtherPay2","FieldType":"Currency","Caption":"Other Pay 2","DefaultValue":"0","Hidden":false,"Required":false,"Updateable":true},{"FieldName":"OtherPay3","FieldType":"Currency","Caption":"Other Pay 3","DefaultValue":"0","Hidden":false,"Required":false,"Updateable":true},{"FieldName":"OtherPay4","FieldType":"Currency","Caption":"Other Pay 4","DefaultValue":"0","Hidden":false,"Required":false,"Updateable":true},{"FieldName":"OtherPay5","FieldType":"Currency","Caption":"Other Pay 5","DefaultValue":"0","Hidden":false,"Required":false,"Updateable":true},{"FieldName":"FormW4Version","FieldType":"Numeric","Caption":"Form W-4 Version","DefaultValue":"2020","Hidden":false,"Required":false,"Updateable":true},{"FieldName":"FormW4Step2","FieldType":"Checkbox","Caption":"Step 2 of W-4","DefaultValue":"N","Hidden":false,"Required":false,"Updateable":true},{"FieldName":"FormW4Dependents","FieldType":"Numeric","Caption":"Dependents (Qualifying Children under 17)","DefaultValue":"0","Hidden":false,"Required":false,"Updateable":true},{"FieldName":"FormW4DependentsOther","FieldType":"Numeric","Caption":"Other Dependents","DefaultValue":"0","Hidden":false,"Required":false,"Updateable":true},{"FieldName":"FormW4OtherTaxCredit","FieldType":"Currency","Caption":"Other Tax Credit Amount","DefaultValue":"0","Hidden":false,"Required":false,"Updateable":true},{"FieldName":"FormW4OtherIncome","FieldType":"Currency","Caption":"Other Income","DefaultValue":"0","Hidden":false,"Required":false,"Updateable":true},{"FieldName":"FormW4Deductions","FieldType":"Currency","Caption":"Deductions","DefaultValue":"0","Hidden":false,"Required":false,"Updateable":true},{"FieldName":"UseTotalHrsAsStd","FieldType":"String","Caption":"Use total hours as standard on Time Analysis","DefaultValue":"N","Hidden":false,"Required":false,"Updateable":true,"MaxLength":1},{"FieldName":"ChangeDefaultLC","FieldType":"Checkbox","Caption":"Allow Employee to change Labor Code in timesheet","DefaultValue":"Y","Hidden":false,"Required":false,"Updateable":true,"MaxLength":1},{"FieldName":"Locale","FieldType":"String","Caption":"Default Tax Locale","DefaultValue":"","Hidden":false,"Required":false,"Updateable":true,"MaxLength":10},{"FieldName":"LocaleMethod","FieldType":"String","Caption":"Locale Method","DefaultValue":"0","Hidden":false,"Required":true,"Updateable":true,"MaxLength":1},{"FieldName":"IncludeLocalJurisOnly","FieldType":"String","Caption":"Only Include Local Jusidictions","DefaultValue":"N","Hidden":false,"Required":false,"Updateable":true,"MaxLength":1},{"FieldName":"AllowChargeUnits","FieldType":"Checkbox","Caption":"Allow Employee to charge Units in timesheet","DefaultValue":"N","Hidden":false,"Required":false,"Updateable":true,"MaxLength":1},{"FieldName":"RequireStartEndTime","FieldType":"String","Caption":"Require Employee to enter start and end times","DefaultValue":"N","Hidden":false,"Required":false,"Updateable":true,"MaxLength":1},{"FieldName":"AllowBreakTime","FieldType":"Checkbox","Caption":"Allow Employee to enter meals and breaks","DefaultValue":"N","Hidden":false,"Required":false,"Updateable":true,"MaxLength":1},{"FieldName":"DefaultBreakStartDateTime","FieldType":"Datetime","Caption":"Default meals and break start date time","DefaultValue":"","Hidden":false,"Required":false,"Updateable":true},{"FieldName":"DefaultBreakEndDateTime","FieldType":"Datetime","Caption":"Default meals and break end date time","DefaultValue":"","Hidden":false,"Required":false,"Updateable":true},{"FieldName":"OccupationalCode","FieldType":"String","Caption":"Standard Occupational Classification Code","DefaultValue":"","Hidden":false,"Required":false,"Updateable":true,"MaxLength":20},{"FieldName":"GeographicCode","FieldType":"String","Caption":"Alaska Geographic Code","DefaultValue":"","Hidden":false,"Required":false,"Updateable":true,"MaxLength":2},{"FieldName":"StatutoryEmployee","FieldType":"String","Caption":"Statutory Employee","DefaultValue":"N","Hidden":false,"Required":false,"Updateable":true},{"FieldName":"RetirementPlan","FieldType":"String","Caption":"Retirement Plan","DefaultValue":"N","Hidden":false,"Required":false,"Updateable":true},{"FieldName":"ThirdPartySickPay","FieldType":"String","Caption":"Third Party Sick Pay","DefaultValue":"N","Hidden":false,"Required":false,"Updateable":true},{"FieldName":"ClieOp","FieldType":"String","Caption":"ClieOp","DefaultValue":"N","Hidden":false,"Required":false,"Updateable":true},{"FieldName":"HomeCompany","FieldType":"Company","Caption":"Home Companyxxxxx","DefaultValue":"[CURRENTCOMPANY]","Hidden":false,"Required":true,"Updateable":true,"MaxLength":14},{"FieldName":"Salutation","FieldType":"Dropdown","Caption":"Prefix","DefaultValue":"","Hidden":false,"Required":false,"Updateable":true,"MaxLength":10,"CodeTable":"CFGPrefix","LimitToList":true},{"FieldName":"FirstName","FieldType":"String","Caption":"First Name","DefaultValue":"","Hidden":false,"Required":false,"Updateable":true,"MaxLength":25},{"FieldName":"MiddleName","FieldType":"String","Caption":"Middle Name","DefaultValue":"","Hidden":false,"Required":false,"Updateable":true,"MaxLength":50},{"FieldName":"LastName","FieldType":"String","Caption":"Last Name","DefaultValue":"","Hidden":false,"Required":true,"Updateable":true,"MaxLength":50},{"FieldName":"Suffix","FieldType":"Dropdown","Caption":"Suffix","DefaultValue":"","Hidden":false,"Required":false,"Updateable":true,"CodeTable":"CFGSuffix","LimitToList":true},{"FieldName":"PreferredName","FieldType":"String","Caption":"Preferred Name","DefaultValue":"","Hidden":false,"Required":false,"Updateable":true,"MaxLength":60},{"FieldName":"Title","FieldType":"Dropdown","Caption":"Title","DefaultValue":"","Hidden":false,"Required":false,"Updateable":true,"CodeTable":"CFGEmployeeTitle","LimitToList":false},{"FieldName":"EMail","FieldType":"String","Caption":"Email","DefaultValue":"","Hidden":false,"Required":false,"Updateable":true,"MaxLength":50},{"FieldName":"WorkPhone","FieldType":"Phone","Caption":"Work Phone","DefaultValue":"","Hidden":false,"Required":false,"Updateable":true,"MaxLength":24},{"FieldName":"MobilePhone","FieldType":"Phone","Caption":"Mobile","DefaultValue":"","Hidden":false,"Required":false,"Updateable":true,"MaxLength":24},{"FieldName":"AvailableForCRM","FieldType":"Checkbox","Caption":"CRM users","DefaultValue":"Y","Hidden":false,"Required":false,"Updateable":true},{"FieldName":"ReadyForApproval","FieldType":"Checkbox","Caption":"Accounting users","DefaultValue":"Y","Hidden":false,"Required":false,"Updateable":true},{"FieldName":"Address1","FieldType":"String","Caption":"Address Line 1","DefaultValue":"","Hidden":false,"Required":false,"Updateable":true,"MaxLength":50},{"FieldName":"Address2","FieldType":"String","Caption":"Address Line 2","DefaultValue":"","Hidden":false,"Required":false,"Updateable":true,"MaxLength":50},{"FieldName":"Address3","FieldType":"String","Caption":"Address Line 3","DefaultValue":"","Hidden":false,"Required":false,"Updateable":true,"MaxLength":50},{"FieldName":"City","FieldType":"String","Caption":"City","DefaultValue":"","Hidden":false,"Required":false,"Updateable":true,"MaxLength":30},{"FieldName":"State","FieldType":"Dropdown","Caption":"State/Province","DefaultValue":"","Hidden":false,"Required":false,"Updateable":true,"CodeTable":"CFGStates","LimitToList":true},{"FieldName":"ZIP","FieldType":"String","Caption":"Zip/Postcode","DefaultValue":"","Hidden":false,"Required":false,"Updateable":true,"MaxLength":10},{"FieldName":"Country","FieldType":"Dropdown","Caption":"Country","DefaultValue":"","Hidden":false,"Required":false,"Updateable":true,"MaxLength":40,"CodeTable":"FW_CFGCountry","LimitToList":true},{"FieldName":"Memo","FieldType":"String","Caption":"Memo","DefaultValue":"","Hidden":false,"Required":false,"Updateable":true},{"FieldName":"FAX","FieldType":"Phone","Caption":"Fax","DefaultValue":"","Hidden":false,"Required":false,"Updateable":true,"MaxLength":24},{"FieldName":"UtilizationRatio","FieldType":"Numeric","Caption":"Utilization Target","DefaultValue":"0","Hidden":false,"Required":false,"Updateable":true,"Decimals":2,"MinValue":0,"MaxValue":100},{"FieldName":"TargetRatio","FieldType":"Numeric","Caption":"Target Ratio","DefaultValue":"0","Hidden":false,"Required":false,"Updateable":true,"Decimals":2},{"FieldName":"WorkPhoneFormat","FieldType":"String","Caption":"Work Phone Format","DefaultValue":"","Hidden":false,"Required":false,"Updateable":true,"MaxLength":24},{"FieldName":"MobilePhoneFormat","FieldType":"String","Caption":"Mobile Phone Format","DefaultValue":"","Hidden":false,"Required":false,"Updateable":true,"MaxLength":24},{"FieldName":"FaxFormat","FieldType":"String","Caption":"Fax Format","DefaultValue":"","Hidden":false,"Required":false,"Updateable":true,"MaxLength":24},{"FieldName":"ConsultantInd","FieldType":"Checkbox","Caption":"Firm Indicator","DefaultValue":"N","Hidden":false,"Required":false,"Updateable":true},{"FieldName":"ClientVendorInd","FieldType":"Dropdown","Caption":"Consultantz/Partner/Client","DefaultValue":"C","Hidden":false,"Required":false,"Updateable":true,"Codes":{"C":"[Client]","V":"[Vendor]"},"LimitToList":true},{"FieldName":"Vendor","FieldType":"Vendor","Caption":"Vendor","DefaultValue":"","Hidden":false,"Required":false,"Updateable":true,"MaxLength":8},{"FieldName":"ClientID","FieldType":"Client","Caption":"Client","DefaultValue":"","Hidden":false,"Required":false,"Updateable":true,"MaxLength":32},{"FieldName":"ClendorName","FieldType":"String","Caption":"Firm Name","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false,"MaxLength":100},{"FieldName":"HasPhoto","FieldType":"Numeric","Caption":"Has Photo","DefaultValue":"0","Hidden":false,"Required":false,"Updateable":false,"MaxLength":1},{"FieldName":"PhotoModDate","FieldType":"Datetime","Caption":"Photo Modified Date","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false},{"FieldName":"TalentUserID","FieldType":"String","Caption":"Talent Management User ID","DefaultValue":"","Hidden":true,"Required":false,"Updateable":true},{"FieldName":"TalentModDate","FieldType":"Datetime","Caption":"Talent Management Last Modified Date","DefaultValue":"","Hidden":true,"Required":false,"Updateable":false},{"FieldName":"HoursPerDay","FieldType":"Numeric","Caption":"Hours/Day","DefaultValue":"0","Hidden":false,"Required":false,"Updateable":true,"Decimals":2},{"FieldName":"RaiseDate","FieldType":"Date","Caption":"Raise Date","DefaultValue":"","Hidden":false,"Required":false,"Updateable":true},{"FieldName":"TerminationDate","FieldType":"Date","Caption":"Termination Date","DefaultValue":"","Hidden":false,"Required":false,"Updateable":true},{"FieldName":"TaxRegistrationNumber","FieldType":"String","Caption":"Tax Reg. #","DefaultValue":"","Hidden":false,"Required":false,"Updateable":true,"MaxLength":20},{"FieldName":"HomePhone","FieldType":"Phone","Caption":"Home","DefaultValue":"","Hidden":false,"Required":false,"Updateable":true,"MaxLength":24},{"FieldName":"HomePhoneFormat","FieldType":"String","Caption":"Home Phone Format","DefaultValue":"","Hidden":false,"Required":false,"Updateable":true,"MaxLength":24},{"FieldName":"SSN","FieldType":"String","Caption":"Social Security Number","DefaultValue":"","Hidden":false,"Required":false,"Updateable":true,"MaxLength":11},{"FieldName":"JobCostRate","FieldType":"Numeric","Caption":"Job Cost Rate","DefaultValue":"0","Hidden":false,"Required":false,"Updateable":true,"Decimals":4},{"FieldName":"JCOvtPct","FieldType":"Numeric","Caption":"Job Cost OT Pct","DefaultValue":"0","Hidden":false,"Required":false,"Updateable":true,"Decimals":2},{"FieldName":"JCSpecialOvtPct","FieldType":"Numeric","Caption":"Job Cost OT-2 Pct","DefaultValue":"0","Hidden":false,"Required":false,"Updateable":true,"Decimals":2},{"FieldName":"JobCostType","FieldType":"Dropdown","Caption":"Job Cost Type","DefaultValue":"H","Hidden":false,"Required":true,"Updateable":true,"MaxLength":1,"Codes":{"H":"Hourly","S":"Salary"},"LimitToList":true},{"FieldName":"ProvCostRate","FieldType":"Numeric","Caption":"Cost Rate","DefaultValue":"0","Hidden":false,"Required":false,"Updateable":true,"Decimals":4},{"FieldName":"ProvCostOTPct","FieldType":"Numeric","Caption":"Cost OT Pct","DefaultValue":"0","Hidden":false,"Required":false,"Updateable":true,"Decimals":2},{"FieldName":"ProvCostSpecialOTPct","FieldType":"Numeric","Caption":"Cost Overtime - 2 Percent","DefaultValue":"0","Hidden":false,"Required":false,"Updateable":true,"Decimals":2},{"FieldName":"ProvBillRate","FieldType":"Numeric","Caption":"Billing Rate","DefaultValue":"0","Hidden":false,"Required":false,"Updateable":true,"Decimals":4},{"FieldName":"ProvBillOTPct","FieldType":"Numeric","Caption":"Billing OT Pct","DefaultValue":"0","Hidden":false,"Required":false,"Updateable":true,"Decimals":2},{"FieldName":"ProvBillSpecialOTPct","FieldType":"Numeric","Caption":"Billing OT-2 Pct","DefaultValue":"0","Hidden":false,"Required":false,"Updateable":true,"Decimals":2},{"FieldName":"Type","FieldType":"Dropdown","Caption":"Employee Type","DefaultValue":"","Hidden":false,"Required":false,"Updateable":true,"MaxLength":30,"CodeTable":"CFGEmployeeType","LimitToList":true},{"FieldName":"BillingCategory","FieldType":"Dropdown","Caption":"Labor Category","DefaultValue":"","Hidden":false,"Required":false,"Updateable":true,"CodeTable":"BTLaborCats","LimitToList":true},{"FieldName":"ADPFileNumber","FieldType":"String","Caption":"ADP File Number","DefaultValue":"","Hidden":false,"Required":false,"Updateable":true,"MaxLength":9},{"FieldName":"ADPCompanyCode","FieldType":"String","Caption":"ADP Company Code","DefaultValue":"","Hidden":false,"Required":false,"Updateable":true,"MaxLength":8},{"FieldName":"ADPRateCode","FieldType":"String","Caption":"ADP Rate Code / Ceridian Distribution Code","DefaultValue":"","Hidden":false,"Required":false,"Updateable":true,"MaxLength":3},{"FieldName":"PaychexCode1","FieldType":"String","Caption":"Paychex Code Regular","DefaultValue":"","Hidden":false,"Required":false,"Updateable":true,"MaxLength":2},{"FieldName":"PaychexCode2","FieldType":"String","Caption":"Paychex Code Overtime","DefaultValue":"","Hidden":false,"Required":false,"Updateable":true,"MaxLength":2},{"FieldName":"PaychexCode3","FieldType":"String","Caption":"Paychex Code Overtime - 2","DefaultValue":"","Hidden":false,"Required":false,"Updateable":true,"MaxLength":2},{"FieldName":"PaychexRateNumber","FieldType":"Dropdown","Caption":"Paychex Rate Number","DefaultValue":"","Hidden":false,"Required":false,"Updateable":true,"LimitToList":true},{"FieldName":"EmailPayrollRemittance","FieldType":"Checkbox","Caption":"Email Payroll Remittance","DefaultValue":"N","Hidden":false,"Required":false,"Updateable":true},{"FieldName":"EmailExpenseRemittance","FieldType":"Checkbox","Caption":"Email Expense Remittance","DefaultValue":"N","Hidden":false,"Required":false,"Updateable":true},{"FieldName":"ClieOpAccount","FieldType":"String","Caption":"Account Number","DefaultValue":"","Hidden":false,"Required":false,"Updateable":true},{"FieldName":"ClieOpAccountType","FieldType":"Dropdown","Caption":"Account Type","DefaultValue":"","Hidden":false,"Required":false,"Updateable":true,"Codes":{"7":"Seven Digit [Account]","O":"Ordinary [Account]"},"LimitToList":true},{"FieldName":"ClieOpTransactionType","FieldType":"String","Caption":"ClieOp Transaction Type","DefaultValue":"","Hidden":false,"Required":false,"Updateable":true},{"FieldName":"SEPAIBAN","FieldType":"String","Caption":"IBAN","DefaultValue":"","Hidden":false,"Required":false,"Updateable":true,"MaxLength":35},{"FieldName":"SEPABIC","FieldType":"String","Caption":"BIC","DefaultValue":"","Hidden":false,"Required":false,"Updateable":true,"MaxLength":35},{"FieldName":"TKGroup","FieldType":"Dropdown","Caption":"Timesheet Group","DefaultValue":"","Hidden":false,"Required":false,"Updateable":true,"LimitToList":true},{"FieldName":"CheckHours","FieldType":"Dropdown","Caption":"Check hours entered against expected","DefaultValue":"W","Hidden":false,"Required":false,"Updateable":true,"MaxLength":1,"Codes":{"1":"Error if Over","2":"Error if Under","G":"Global","E":"Error if Either Over or Under","O":"Warning if Over","U":"Warning if Under","W":"Warning if Either Over or Under","N":"None"},"LimitToList":true},{"FieldName":"DefaultLC1","FieldType":"Dropdown","Caption":"Department","DefaultValue":"","Hidden":false,"Required":false,"Updateable":true,"MaxLength":14,"CodeTable":"CFGLCCodes1","LimitToList":true},{"FieldName":"DefaultLC2","FieldType":"Dropdown","Caption":"Phasex","DefaultValue":"","Hidden":false,"Required":false,"Updateable":true,"MaxLength":14,"CodeTable":"CFGLCCodes2","LimitToList":true},{"FieldName":"DefaultLC3","FieldType":"Dropdown","Caption":"Service","DefaultValue":"","Hidden":false,"Required":false,"Updateable":true,"MaxLength":14,"CodeTable":"CFGLCCodes3","LimitToList":true},{"FieldName":"DefaultLC4","FieldType":"Dropdown","Caption":"Staff","DefaultValue":"","Hidden":false,"Required":false,"Updateable":true,"MaxLength":14,"CodeTable":"CFGLCCodes4","LimitToList":true},{"FieldName":"DefaultLC5","FieldType":"Dropdown","Caption":"Labor Code Level 5","DefaultValue":"","Hidden":true,"Required":false,"Updateable":true,"MaxLength":14,"CodeTable":"CFGLCCodes5","LimitToList":true},{"FieldName":"EKGroup","FieldType":"Dropdown","Caption":"Expense Group","DefaultValue":"","Hidden":false,"Required":false,"Updateable":true,"LimitToList":true},{"FieldName":"DefaultTaxLocation","FieldType":"Dropdown","Caption":"Default Expense Location","DefaultValue":"","Hidden":false,"Required":false,"Updateable":true,"LimitToList":true},{"FieldName":"TaxAuditingEnabled","FieldType":"String","Caption":"TaxAuditingEnabled","DefaultValue":"","Hidden":true,"Required":false,"Updateable":false},{"FieldName":"CostRateMeth","FieldType":"Dropdown","Caption":"Cost Method","DefaultValue":"0","Hidden":false,"Required":true,"Updateable":true,"MaxLength":1,"Codes":{"0":"None","1":"From Labor Rate Table","2":"From Category Rate Table","3":"From [Labor Code] Table"},"LimitToList":true},{"FieldName":"CostRateTableNo","FieldType":"Dropdown","Caption":"Cost Table","DefaultValue":"0","Hidden":false,"Required":false,"Updateable":true,"MaxLength":10,"LimitToList":true},{"FieldName":"PayRateMeth","FieldType":"Dropdown","Caption":"Pay Rate Table Method","DefaultValue":"0","Hidden":false,"Required":true,"Updateable":true,"MaxLength":1,"Codes":{"0":"None","1":"From Labor Rate Table","2":"From Category Rate Table","3":"From [Labor Code] Table"},"LimitToList":true},{"FieldName":"PayRateTableNo","FieldType":"Dropdown","Caption":"Pay Table","DefaultValue":"0","Hidden":false,"Required":false,"Updateable":true,"MaxLength":10,"LimitToList":true},{"FieldName":"DisableTSRevAudit","FieldType":"Checkbox","Caption":"Disable Timesheet Revision Auditing","DefaultValue":"N","Hidden":false,"Required":false,"Updateable":true},{"FieldName":"TKAdminLevel","FieldType":"Dropdown","Caption":"Timesheet Administration Level","DefaultValue":"","Hidden":false,"Required":false,"Updateable":true,"MaxLength":1,"Codes":{"0":"[Labcd Level 2]","1":"Group","2":"System","3":"[Org Level 1]"},"LimitToList":true},{"FieldName":"EKAdminLevel","FieldType":"Dropdown","Caption":"Expense Administration Level","DefaultValue":"","Hidden":false,"Required":false,"Updateable":true,"MaxLength":1,"Codes":{"0":"[Labcd Level 2]","1":"Group","2":"System","3":"[Org Level 1]"},"LimitToList":true},{"FieldName":"TKAdminEdit","FieldType":"Checkbox","Caption":"Timesheet Administration Editing","DefaultValue":"N","Hidden":false,"Required":false,"Updateable":true},{"FieldName":"EKAdminEdit","FieldType":"Checkbox","Caption":"Expense Report Administration Editing","DefaultValue":"N","Hidden":false,"Required":false,"Updateable":true},{"FieldName":"ProfessionalSuffix","FieldType":"String","Caption":"Professional Suffix","DefaultValue":"","Hidden":false,"Required":false,"Updateable":true,"MaxLength":255},{"FieldName":"TotalYearsWithThisFirm","FieldType":"Numeric","Caption":"Total Years with this Firm","DefaultValue":"0","Hidden":false,"Required":false,"Updateable":false},{"FieldName":"TotalYearsExperience","FieldType":"Numeric","Caption":"Total Years Experi","DefaultValue":"0","Hidden":false,"Required":false,"Updateable":false},{"FieldName":"HomeCompanyName","FieldType":"String","Caption":"Home Companyxxxxx Name","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false,"MaxLength":42},{"FieldName":"EmployeeCompanyName","FieldType":"String","Caption":"Employee Companyxxxxx Name","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false,"MaxLength":42},{"FieldName":"OrganizationName","FieldType":"String","Caption":"Organization Name","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false,"MaxLength":100},{"FieldName":"TitleName","FieldType":"String","Caption":"Full Name","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false,"MaxLength":100},{"FieldName":"Location","FieldType":"Dropdown","Caption":"Location","DefaultValue":"","Hidden":false,"Required":false,"Updateable":true,"MaxLength":50,"CodeTable":"CFGEMLocation","LimitToList":true},{"FieldName":"LocationDescription","FieldType":"String","Caption":"Location Description","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false,"MaxLength":50},{"FieldName":"UIPaymentMethod","FieldType":"Dropdown","Caption":"UI Payment Method","DefaultValue":"N","Hidden":false,"Required":false,"Updateable":true,"MaxLength":1,"LimitToList":true},{"FieldName":"CitizenshipStatus","FieldType":"String","Caption":"Citizenship Status","DefaultValue":"","Hidden":false,"Required":false,"Updateable":true,"MaxLength":1},{"FieldName":"PayrollFrequency","FieldType":"String","Caption":"Payroll Frequency","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false},{"FieldName":"Language","FieldType":"Dropdown","Caption":"Language","DefaultValue":"","Hidden":false,"Required":false,"Updateable":true,"Codes":{"en-US":"English (United States)","en-GB":"English (international)","fr-CA":"French (Canada)","fr-FR":"French (France)","es-ES":"Spanish (international)","nl-NL":"Dutch (Netherlands)","de-DE":"German (Germany)","pt-BR":"Portuguese (Brazil)"},"LimitToList":true},{"FieldName":"QBOID","FieldType":"String","Caption":"QBO Id","DefaultValue":"","Hidden":false,"Required":false,"Updateable":true,"MaxLength":18},{"FieldName":"QBOAddressID","FieldType":"String","Caption":"QBO Address Id","DefaultValue":"","Hidden":false,"Required":false,"Updateable":true,"MaxLength":18},{"FieldName":"QBOLastUpdated","FieldType":"Datetime","Caption":"QBO Mod Date","DefaultValue":"","Hidden":false,"Required":false,"Updateable":true},{"FieldName":"QBOVendorID","FieldType":"Dropdown","Caption":"Connected QuickBooks Vendor","DefaultValue":"","Hidden":false,"Required":false,"Updateable":true,"MaxLength":18,"LimitToList":true},{"FieldName":"PIMID","FieldType":"String","Caption":"PIM","DefaultValue":"[GUID]","Hidden":false,"Required":true,"Updateable":true,"MaxLength":32},{"FieldName":"Terminated","FieldType":"Checkbox","Caption":"Terminated","DefaultValue":"N","Hidden":false,"Required":false,"Updateable":true},{"FieldName":"CreateUser","FieldType":"User","Caption":"Created by","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false,"MaxLength":32},{"FieldName":"ModUser","FieldType":"User","Caption":"Modified by","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false,"MaxLength":32},{"FieldName":"CreateUserName","FieldType":"User","Caption":"CreateUserName","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false,"MaxLength":32},{"FieldName":"ModUserName","FieldType":"User","Caption":"ModUserName","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false,"MaxLength":32},{"FieldName":"CreateDate","FieldType":"Datetime","Caption":"Create date","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false},{"FieldName":"ModDate","FieldType":"Datetime","Caption":"Modify date","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false},{"FieldName":"CustNewField","FieldType":"Checkbox","Caption":"New Field","DefaultValue":"N","Hidden":false,"Required":false,"Updateable":true,"CustomField":true},{"FieldName":"desc_CustNewValueDropdown","FieldType":"String","Caption":"New Value Drop down Description","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false,"CustomField":true},{"FieldName":"CustNewValueDropdown","FieldType":"Dropdown","Caption":"New Value Drop down","DefaultValue":"","Hidden":false,"Required":false,"Updateable":true,"CustomField":true,"LimitToList":true},{"FieldName":"Custbird","FieldType":"String","Caption":"bird","DefaultValue":"","Hidden":false,"Required":false,"Updateable":true,"CustomField":true,"MaxLength":255},{"FieldName":"desc_CustProjectfield","FieldType":"String","Caption":"Project field Description","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false,"CustomField":true},{"FieldName":"CustProjectfield","FieldType":"WBS1","Caption":"Project field","DefaultValue":"","Hidden":false,"Required":false,"Updateable":true,"CustomField":true,"MaxLength":10},{"FieldName":"CustcustomfieldaddedtotheProfessionaltab","FieldType":"String","Caption":"custom field added to the Professional tab","DefaultValue":"","Hidden":false,"Required":false,"Updateable":true,"CustomField":true,"MaxLength":255},{"FieldName":"desc_CustLayoutfield","FieldType":"String","Caption":"Layout field Description","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false,"CustomField":true},{"FieldName":"CustLayoutfield","FieldType":"UDIC","Caption":"Layout field","DefaultValue":"","Hidden":false,"Required":false,"Updateable":true,"CustomField":true,"UDICType":"UDIC_Layout"},{"FieldName":"Custdatefield","FieldType":"Date","Caption":"date field","DefaultValue":"","Hidden":false,"Required":false,"Updateable":true,"CustomField":true},{"FieldName":"desc_CustAccountfield","FieldType":"String","Caption":"Account field Description","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false,"CustomField":true},{"FieldName":"CustAccountfield","FieldType":"Account","Caption":"Account field","DefaultValue":"","Hidden":false,"Required":false,"Updateable":true,"CustomField":true,"MaxLength":6},{"FieldName":"desc_CustEmployeefield","FieldType":"String","Caption":"Employee field Description","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false,"CustomField":true},{"FieldName":"CustEmployeefield","FieldType":"Employee","Caption":"Employee field","DefaultValue":"","Hidden":false,"Required":false,"Updateable":true,"CustomField":true,"MaxLength":5},{"FieldName":"CustCurrencyRecordfield","FieldType":"Currency","Caption":"Currency (Record) field","DefaultValue":"0","Hidden":false,"Required":false,"Updateable":true,"CustomField":true},{"FieldName":"CustCurrencySpecificfield","FieldType":"Currency","Caption":"Currency (Specific) field","DefaultValue":"0","Hidden":false,"Required":false,"Updateable":true,"CustomField":true},{"FieldName":"CustNumeric2field","FieldType":"Numeric","Caption":"Numeric 2 fieldxx","DefaultValue":"0","Hidden":false,"Required":false,"Updateable":true,"CustomField":true,"Decimals":0},{"FieldName":"desc_CustDropdownfield","FieldType":"String","Caption":"Dropdown field Description","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false,"CustomField":true},{"FieldName":"CustDropdownfield","FieldType":"Dropdown","Caption":"Dropdown field","DefaultValue":"","Hidden":false,"Required":false,"Updateable":true,"CustomField":true,"LimitToList":true},{"FieldName":"CustCharacterfield","FieldType":"String","Caption":"Character field","DefaultValue":"","Hidden":false,"Required":false,"Updateable":true,"CustomField":true,"MaxLength":255},{"FieldName":"desc_CustDropdowntypefield2","FieldType":"String","Caption":"Drop-down type field #2 Description","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false,"CustomField":true},{"FieldName":"CustDropdowntypefield2","FieldType":"Dropdown","Caption":"Drop-down type field #2","DefaultValue":"","Hidden":false,"Required":false,"Updateable":true,"CustomField":true,"LimitToList":true},{"FieldName":"CustSeasonalEmploye","FieldType":"Checkbox","Caption":"Seasonal Employe","DefaultValue":"N","Hidden":false,"Required":false,"Updateable":true,"CustomField":true},{"FieldName":"desc_CustSeasons","FieldType":"String","Caption":"Seasons Description","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false,"CustomField":true},{"FieldName":"CustSeasons","FieldType":"Dropdown","Caption":"Seasons","DefaultValue":"","Hidden":false,"Required":false,"Updateable":true,"CustomField":true,"LimitToList":true}],"Caption":"Employees","CustomTableName":"EmployeeCustomTabFields"},"EMAccrual":{"Keys":"Employee,EmployeeCompany,Code","TableName":"EMAccrual","GridID":null,"Hidden":false,"Updateable":true,"Fields":[{"FieldName":"Employee","FieldType":"Employee","Caption":"Employee","DefaultValue":"","Hidden":false,"Required":true,"Updateable":true,"MaxLength":5},{"FieldName":"Code","FieldType":"String","Caption":"Absence Accrual Code","DefaultValue":"","Hidden":false,"Required":true,"Updateable":true,"MaxLength":20},{"FieldName":"Description","FieldType":"String","Caption":"Description","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false},{"FieldName":"UseSchedule","FieldType":"String","Caption":"Method","DefaultValue":"N","Hidden":false,"Required":false,"Updateable":true,"MaxLength":1},{"FieldName":"ScheduleID","FieldType":"String","Caption":"Schedule","DefaultValue":"","Hidden":false,"Required":false,"Updateable":true},{"FieldName":"DefaultScheduleID","FieldType":"String","Caption":"DefaultScheduleID","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false},{"FieldName":"ScheduleDescription","FieldType":"String","Caption":"ScheduleDescription","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false},{"FieldName":"HoursPerYear","FieldType":"Numeric","Caption":"Hours Earned\u003c/br\u003ePer Year","DefaultValue":"0","Hidden":false,"Required":false,"Updateable":true,"Decimals":4},{"FieldName":"HoursPerHourWorked","FieldType":"Numeric","Caption":"Hours Earned Per\u003c/br\u003eHour Worked","DefaultValue":"0","Hidden":false,"Required":false,"Updateable":true,"Decimals":4},{"FieldName":"MaxHoursPerProcess","FieldType":"Numeric","Caption":"Max Hours Earned\u003c/br\u003ePer Accrual Process","DefaultValue":"0","Hidden":false,"Required":false,"Updateable":true,"Decimals":4},{"FieldName":"ChangeDate","FieldType":"Date","Caption":"Change Date","DefaultValue":"","Hidden":false,"Required":true,"Updateable":true},{"FieldName":"HasMaximum","FieldType":"String","Caption":"Has Maximum","DefaultValue":"S","Hidden":false,"Required":false,"Updateable":true,"MaxLength":1},{"FieldName":"Maximum","FieldType":"Numeric","Caption":"Maximum","DefaultValue":"0","Hidden":false,"Required":false,"Updateable":true,"Decimals":4},{"FieldName":"HasCarryoverLimit","FieldType":"String","Caption":"Has Carry Over Limit","DefaultValue":"S","Hidden":false,"Required":false,"Updateable":true,"MaxLength":1},{"FieldName":"CarryoverLimit","FieldType":"Numeric","Caption":"Carry Over Limit","DefaultValue":"0","Hidden":false,"Required":false,"Updateable":true,"Decimals":4},{"FieldName":"EmployeeCompany","FieldType":"Company","Caption":"EmployeeCompany","DefaultValue":"","Hidden":false,"Required":true,"Updateable":true,"MaxLength":14},{"FieldName":"CreateUser","FieldType":"User","Caption":"Created by","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false,"MaxLength":32},{"FieldName":"ModUser","FieldType":"User","Caption":"Modified by","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false,"MaxLength":32},{"FieldName":"CreateDate","FieldType":"Datetime","Caption":"Create date","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false},{"FieldName":"ModDate","FieldType":"Datetime","Caption":"Modify date","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false}],"Caption":"Absence Accruals"},"EMDirectDeposit":{"Keys":"Employee,EmployeeCompany,Seq","TableName":"EMDirectDeposit","GridID":null,"Hidden":false,"Updateable":true,"Fields":[{"FieldName":"Employee","FieldType":"Employee","Caption":"Employee","DefaultValue":"","Hidden":false,"Required":true,"Updateable":true,"MaxLength":5},{"FieldName":"EmployeeCompany","FieldType":"Company","Caption":"EmployeeCompany","DefaultValue":"","Hidden":false,"Required":true,"Updateable":true,"MaxLength":14},{"FieldName":"Seq","FieldType":"Numeric","Caption":"Seq","DefaultValue":"0","Hidden":false,"Required":true,"Updateable":true,"Decimals":0},{"FieldName":"BankID","FieldType":"String","Caption":"BankID","DefaultValue":"","Hidden":false,"Required":true,"Updateable":true,"MaxLength":8},{"FieldName":"Account","FieldType":"String","Caption":"Account","DefaultValue":"","Hidden":false,"Required":true,"Updateable":true,"MaxLength":32},{"FieldName":"AccountType","FieldType":"String","Caption":"AccountType","DefaultValue":"","Hidden":false,"Required":true,"Updateable":true,"MaxLength":1},{"FieldName":"Status","FieldType":"String","Caption":"Status","DefaultValue":"","Hidden":false,"Required":true,"Updateable":true,"MaxLength":1},{"FieldName":"Override","FieldType":"Checkbox","Caption":"Override","DefaultValue":"N","Hidden":false,"Required":false,"Updateable":true},{"FieldName":"Method","FieldType":"String","Caption":"Method","DefaultValue":"","Hidden":false,"Required":false,"Updateable":true,"MaxLength":1},{"FieldName":"AmtPct","FieldType":"Numeric","Caption":"AmtPct","DefaultValue":"0","Hidden":false,"Required":false,"Updateable":true,"Decimals":4},{"FieldName":"exMethod","FieldType":"String","Caption":"exMethod","DefaultValue":"","Hidden":false,"Required":true,"Updateable":true,"MaxLength":1},{"FieldName":"exAmtPct","FieldType":"Numeric","Caption":"exAmtPct","DefaultValue":"0","Hidden":false,"Required":false,"Updateable":true,"Decimals":4},{"FieldName":"CreateUser","FieldType":"User","Caption":"Created by","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false,"MaxLength":32},{"FieldName":"ModUser","FieldType":"User","Caption":"Modified by","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false,"MaxLength":32},{"FieldName":"CreateDate","FieldType":"Datetime","Caption":"Create date","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false},{"FieldName":"ModDate","FieldType":"Datetime","Caption":"Modify date","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false}],"Caption":"Direct Deposit"},"EMDegree":{"Keys":"Employee,RecordID","TableName":"EMDegree","GridID":null,"Hidden":false,"Updateable":true,"Fields":[{"FieldName":"RecordID","FieldType":"String","Caption":"RecordID","DefaultValue":"[GUID]","Hidden":false,"Required":true,"Updateable":true,"MaxLength":32},{"FieldName":"Seq","FieldType":"Numeric","Caption":"Seq","DefaultValue":"0","Hidden":false,"Required":false,"Updateable":true},{"FieldName":"Employee","FieldType":"Employee","Caption":"Employee","DefaultValue":"","Hidden":false,"Required":true,"Updateable":true,"MaxLength":5},{"FieldName":"Degree","FieldType":"Dropdown","Caption":"Degree","DefaultValue":"","Hidden":false,"Required":false,"Updateable":true,"MaxLength":60,"CodeTable":"CFGEMDegree","LimitToList":true},{"FieldName":"DegreeDescription","FieldType":"String","Caption":"DegreeDescription","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false},{"FieldName":"Specialty","FieldType":"String","Caption":"Specialty","DefaultValue":"","Hidden":false,"Required":false,"Updateable":true,"MaxLength":60},{"FieldName":"Institution","FieldType":"String","Caption":"Institution","DefaultValue":"","Hidden":false,"Required":false,"Updateable":true,"MaxLength":60},{"FieldName":"YearEarned","FieldType":"Numeric","Caption":"Year","DefaultValue":"0","Hidden":false,"Required":false,"Updateable":true},{"FieldName":"IncludeInProposal","FieldType":"Checkbox","Caption":"Proposals","DefaultValue":"Y","Hidden":false,"Required":false,"Updateable":true,"MaxLength":1},{"FieldName":"CreateUser","FieldType":"User","Caption":"Created by","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false,"MaxLength":32},{"FieldName":"ModUser","FieldType":"User","Caption":"Modified by","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false,"MaxLength":32},{"FieldName":"CreateDate","FieldType":"Datetime","Caption":"Create date","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false},{"FieldName":"ModDate","FieldType":"Datetime","Caption":"Modify date","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false}],"Caption":"Education"},"EMRegistration":{"Keys":"Employee,RecordID","TableName":"EMRegistration","GridID":null,"Hidden":false,"Updateable":true,"Fields":[{"FieldName":"RecordID","FieldType":"String","Caption":"RecordID","DefaultValue":"[GUID]","Hidden":false,"Required":true,"Updateable":true,"MaxLength":32},{"FieldName":"Seq","FieldType":"Numeric","Caption":"Seq","DefaultValue":"0","Hidden":false,"Required":false,"Updateable":true},{"FieldName":"Employee","FieldType":"Employee","Caption":"Employee","DefaultValue":"","Hidden":false,"Required":true,"Updateable":true,"MaxLength":5},{"FieldName":"Registration","FieldType":"Dropdown","Caption":"License","DefaultValue":"","Hidden":false,"Required":false,"Updateable":true,"MaxLength":60,"CodeTable":"CFGEMRegistration","LimitToList":true},{"FieldName":"RegistrationDescription","FieldType":"String","Caption":"RegistrationDescription","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false},{"FieldName":"RegistrationType","FieldType":"Dropdown","Caption":"Type","DefaultValue":"","Hidden":false,"Required":false,"Updateable":true,"MaxLength":60,"CodeTable":"CFGEMRegistrationType","LimitToList":true},{"FieldName":"TypeDescription","FieldType":"String","Caption":"TypeDescription","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false},{"FieldName":"DateEarned","FieldType":"Date","Caption":"Earned","DefaultValue":"","Hidden":false,"Required":false,"Updateable":true},{"FieldName":"StateRegistered","FieldType":"Dropdown","Caption":"State/Province","DefaultValue":"","Hidden":false,"Required":false,"Updateable":true,"MaxLength":50,"CodeTable":"CFGStates","LimitToList":true},{"FieldName":"StateRegisteredDescription","FieldType":"String","Caption":"StateRegisteredDescription","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false},{"FieldName":"CountryRegistered","FieldType":"Dropdown","Caption":"Country Registered","DefaultValue":"","Hidden":false,"Required":false,"Updateable":true,"MaxLength":2,"CodeTable":"FW_CFGCountry","LimitToList":true},{"FieldName":"CountryRegisteredDescription","FieldType":"String","Caption":"CountryRegisteredDescription","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false},{"FieldName":"RegistrationNo","FieldType":"String","Caption":"Number","DefaultValue":"","Hidden":false,"Required":false,"Updateable":true,"MaxLength":50},{"FieldName":"DateExpires","FieldType":"Date","Caption":"Expires","DefaultValue":"","Hidden":false,"Required":false,"Updateable":true},{"FieldName":"LastRenewed","FieldType":"Date","Caption":"Last Renewal","DefaultValue":"","Hidden":false,"Required":false,"Updateable":true},{"FieldName":"IncludeInProposal","FieldType":"Checkbox","Caption":"Proposals","DefaultValue":"Y","Hidden":false,"Required":false,"Updateable":true,"MaxLength":1},{"FieldName":"StatusDescription","FieldType":"String","Caption":"StatusDescription","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false},{"FieldName":"CreateUser","FieldType":"User","Caption":"Created by","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false,"MaxLength":32},{"FieldName":"ModUser","FieldType":"User","Caption":"Modified by","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false,"MaxLength":32},{"FieldName":"CreateDate","FieldType":"Datetime","Caption":"Create date","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false},{"FieldName":"ModDate","FieldType":"Datetime","Caption":"Modify date","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false}],"Caption":"Credentials"},"EMSkills":{"Keys":"Employee,Skill","TableName":"EMSkills","GridID":null,"Hidden":false,"Updateable":true,"Fields":[{"FieldName":"Employee","FieldType":"Employee","Caption":"Employee","DefaultValue":"","Hidden":false,"Required":true,"Updateable":true,"MaxLength":5},{"FieldName":"Skill","FieldType":"Dropdown","Caption":"Skill","DefaultValue":"","Hidden":false,"Required":true,"Updateable":true,"MaxLength":60,"CodeTable":"CFGEMSkill","LimitToList":true},{"FieldName":"SkillDescription","FieldType":"String","Caption":"SkillDescription","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false},{"FieldName":"SkillLevel","FieldType":"Dropdown","Caption":"Level","DefaultValue":"","Hidden":false,"Required":false,"Updateable":true,"MaxLength":60,"CodeTable":"CFGEMSkillLevel","LimitToList":true},{"FieldName":"SkillLevelDescription","FieldType":"String","Caption":"SkillLevelDescription","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false},{"FieldName":"SkillUsage","FieldType":"Dropdown","Caption":"Usage","DefaultValue":"","Hidden":false,"Required":false,"Updateable":true,"MaxLength":60,"CodeTable":"CFGEMSkillUsage","LimitToList":true},{"FieldName":"SkillUsageDescription","FieldType":"String","Caption":"SkillUsageDescription","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false},{"FieldName":"PrimaryInd","FieldType":"Checkbox","Caption":"Primary","DefaultValue":"N","Hidden":false,"Required":false,"Updateable":true,"MaxLength":1},{"FieldName":"CreateUser","FieldType":"User","Caption":"Created by","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false,"MaxLength":32},{"FieldName":"ModUser","FieldType":"User","Caption":"Modified by","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false,"MaxLength":32},{"FieldName":"CreateDate","FieldType":"Datetime","Caption":"Create date","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false},{"FieldName":"ModDate","FieldType":"Datetime","Caption":"Modify date","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false}],"Caption":"Skills"},"EMCitizenship":{"Keys":"Employee,RecordID","TableName":"EMCitizenship","GridID":null,"Hidden":false,"Updateable":true,"Fields":[{"FieldName":"Employee","FieldType":"Employee","Caption":"Employee","DefaultValue":"","Hidden":false,"Required":true,"Updateable":true,"MaxLength":5},{"FieldName":"RecordID","FieldType":"String","Caption":"RecordID","DefaultValue":"[GUID]","Hidden":false,"Required":true,"Updateable":true,"MaxLength":32},{"FieldName":"Country","FieldType":"Dropdown","Caption":"Citizenship Country","DefaultValue":"","Hidden":false,"Required":false,"Updateable":true,"MaxLength":32,"CodeTable":"FW_CFGCountry","LimitToList":true},{"FieldName":"CountryDescription","FieldType":"String","Caption":"CountryDescription","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false},{"FieldName":"CitizenshipType","FieldType":"Dropdown","Caption":"Citizenship Type","DefaultValue":"","Hidden":false,"Required":false,"Updateable":true,"MaxLength":10,"CodeTable":"CFGCitizenship","LimitToList":true},{"FieldName":"CitizenshipTypeDescription","FieldType":"String","Caption":"CitizenshipTypeDescription","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false},{"FieldName":"Expiration","FieldType":"Date","Caption":"Expiration","DefaultValue":"","Hidden":false,"Required":false,"Updateable":true},{"FieldName":"CreateUser","FieldType":"User","Caption":"Created by","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false,"MaxLength":32},{"FieldName":"ModUser","FieldType":"User","Caption":"Modified by","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false,"MaxLength":32},{"FieldName":"CreateDate","FieldType":"Datetime","Caption":"Create date","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false},{"FieldName":"ModDate","FieldType":"Datetime","Caption":"Modify date","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false}],"Caption":"Citizenship Information"},"Activity":{"Keys":"ActivityID","TableName":"Activity","GridID":null,"Hidden":false,"Updateable":true,"Fields":[{"FieldName":"ActivityID","FieldType":"String","Caption":"ActivityID","DefaultValue":"[GUID]","Hidden":false,"Required":true,"Updateable":true,"MaxLength":32},{"FieldName":"ClientID","FieldType":"Firm","Caption":"Firms","DefaultValue":"","Hidden":false,"Required":false,"Updateable":true,"MaxLength":32},{"FieldName":"ContactID","FieldType":"Contact","Caption":"Primary Contact","DefaultValue":"","Hidden":false,"Required":false,"Updateable":true,"MaxLength":32},{"FieldName":"WBS1","FieldType":"WBS1","Caption":"Project","DefaultValue":"","Hidden":false,"Required":false,"Updateable":true,"MaxLength":10},{"FieldName":"WBS2","FieldType":"WBS2","Caption":"WBS2","DefaultValue":"","Hidden":false,"Required":false,"Updateable":true,"MaxLength":3},{"FieldName":"WBS3","FieldType":"WBS3","Caption":"WBS3","DefaultValue":"","Hidden":false,"Required":false,"Updateable":true,"MaxLength":3},{"FieldName":"Employee","FieldType":"Employee","Caption":"Employee","DefaultValue":"","Hidden":false,"Required":false,"Updateable":true,"MaxLength":5},{"FieldName":"CreateEmployee","FieldType":"Employee","Caption":"Create Employee","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false,"MaxLength":5},{"FieldName":"CampaignID","FieldType":"Mkt","Caption":"Marketing Campaign","DefaultValue":"","Hidden":false,"Required":false,"Updateable":true,"MaxLength":32},{"FieldName":"CompletionInd","FieldType":"Checkbox","Caption":"Completed","DefaultValue":"N","Hidden":false,"Required":false,"Updateable":true,"MaxLength":1},{"FieldName":"isTask","FieldType":"Checkbox","Caption":"Is task item","DefaultValue":"N","Hidden":false,"Required":false,"Updateable":false,"MaxLength":1},{"FieldName":"isCalendar","FieldType":"Checkbox","Caption":"Is calendar item","DefaultValue":"N","Hidden":false,"Required":false,"Updateable":false,"MaxLength":1},{"FieldName":"Type","FieldType":"Dropdown","Caption":"Type","DefaultValue":"Activity","Hidden":false,"Required":true,"Updateable":true,"MaxLength":15,"CodeTable":"CFGActivityType","LimitToList":true},{"FieldName":"acType","FieldType":"String","Caption":"acType","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false,"MaxLength":15},{"FieldName":"TypeName","FieldType":"String","Caption":"Type Name","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false},{"FieldName":"Subject","FieldType":"String","Caption":"Name","DefaultValue":"","Hidden":false,"Required":true,"Updateable":true,"MaxLength":255},{"FieldName":"StartDate","FieldType":"Datetime","Caption":"Start Date","DefaultValue":"[TODAY]","Hidden":false,"Required":false,"Updateable":true},{"FieldName":"StartDateObj","FieldType":"Datetime","Caption":"Start Date","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false},{"FieldName":"InstanceStartDate","FieldType":"Datetime","Caption":"Start Date","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false},{"FieldName":"Priority","FieldType":"Dropdown","Caption":"Priority","DefaultValue":"Medium","Hidden":false,"Required":false,"Updateable":true,"MaxLength":10,"Codes":{"High":"High","Medium":"Medium","Low":"Low"},"LimitToList":true},{"FieldName":"PriorityDesc","FieldType":"Dropdown","Caption":"PriorityDesc","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false,"LimitToList":true},{"FieldName":"EndDate","FieldType":"Datetime","Caption":"End Date","DefaultValue":"[TODAY]","Hidden":false,"Required":false,"Updateable":true},{"FieldName":"EndDateObj","FieldType":"Datetime","Caption":"Start Date","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false},{"FieldName":"Duration","FieldType":"Numeric","Caption":"Duration","DefaultValue":"0","Hidden":false,"Required":false,"Updateable":true},{"FieldName":"PrivateInd","FieldType":"Checkbox","Caption":"Private","DefaultValue":"N","Hidden":false,"Required":false,"Updateable":true,"MaxLength":1},{"FieldName":"ReminderInd","FieldType":"String","Caption":"Reminder","DefaultValue":"Y","Hidden":false,"Required":false,"Updateable":true,"MaxLength":1},{"FieldName":"ReminderUnit","FieldType":"Numeric","Caption":"ReminderUnit","DefaultValue":"15","Hidden":false,"Required":false,"Updateable":true},{"FieldName":"ReminderMinHrDay","FieldType":"String","Caption":"ReminderMinHrDay","DefaultValue":"Minutes","Hidden":false,"Required":false,"Updateable":true,"MaxLength":10},{"FieldName":"ReminderDate","FieldType":"Datetime","Caption":"Reminder Date","DefaultValue":"","Hidden":false,"Required":false,"Updateable":true},{"FieldName":"ShowTimeAs","FieldType":"Dropdown","Caption":"Show Time As","DefaultValue":"Busy","Hidden":false,"Required":false,"Updateable":true,"MaxLength":20,"Codes":{"Busy":"Busy","Free":"Free","Outoftheoffice":"Out of the office","Tentative":"Tentative"},"LimitToList":true},{"FieldName":"AllDayEventInd","FieldType":"Checkbox","Caption":"All Day Event","DefaultValue":"N","Hidden":false,"Required":false,"Updateable":true,"MaxLength":1},{"FieldName":"LeadID","FieldType":"String","Caption":"LeadID","DefaultValue":"","Hidden":false,"Required":false,"Updateable":true,"MaxLength":32},{"FieldName":"Owner","FieldType":"Employee","Caption":"Owner","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false,"MaxLength":5},{"FieldName":"OwnerName","FieldType":"String","Caption":"OwnerName","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false,"MaxLength":45},{"FieldName":"ClientName","FieldType":"String","Caption":"ClientName","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false,"MaxLength":100},{"FieldName":"ContactName","FieldType":"String","Caption":"ContactName","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false,"MaxLength":45},{"FieldName":"Vendor","FieldType":"Vendor","Caption":"Vendor","DefaultValue":"","Hidden":false,"Required":false,"Updateable":true,"MaxLength":8},{"FieldName":"VendorName","FieldType":"String","Caption":"VendorName","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false},{"FieldName":"ContactIDForVendor","FieldType":"Contact","Caption":"Vendor Contact","DefaultValue":"","Hidden":false,"Required":false,"Updateable":true},{"FieldName":"ContactNameForVendor","FieldType":"String","Caption":"ContactNameForVendor","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false},{"FieldName":"ContactPhoneForVendor","FieldType":"String","Caption":"ContactPhoneForVendor","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false},{"FieldName":"VendorContactName","FieldType":"String","Caption":"VendorContactName","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false},{"FieldName":"ProjName","FieldType":"String","Caption":"ProjName","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false,"MaxLength":80},{"FieldName":"MktName","FieldType":"String","Caption":"MktName","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false,"MaxLength":100},{"FieldName":"Location","FieldType":"String","Caption":"Location","DefaultValue":"","Hidden":false,"Required":false,"Updateable":true,"MaxLength":50},{"FieldName":"Notes","FieldType":"Memo","Caption":"Notes","DefaultValue":"","Hidden":false,"Required":false,"Updateable":true},{"FieldName":"HasNotes","FieldType":"String","Caption":"HasNotes","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false,"MaxLength":1},{"FieldName":"RP","FieldType":"String","Caption":"RP","DefaultValue":"N","Hidden":false,"Required":false,"Updateable":true,"MaxLength":1},{"FieldName":"RecurrenceInd","FieldType":"Checkbox","Caption":"Repeats","DefaultValue":"N","Hidden":false,"Required":false,"Updateable":true,"MaxLength":1},{"FieldName":"RecurrType","FieldType":"String","Caption":"Repeats","DefaultValue":"","Hidden":false,"Required":false,"Updateable":true,"MaxLength":20},{"FieldName":"RecurrDailyFreq","FieldType":"Numeric","Caption":"Days","DefaultValue":"1","Hidden":false,"Required":false,"Updateable":true},{"FieldName":"RecurrDailyWeekDay","FieldType":"String","Caption":"Repeat","DefaultValue":"N","Hidden":false,"Required":false,"Updateable":true,"MaxLength":1},{"FieldName":"RecurrWeeklyFreq","FieldType":"Numeric","Caption":" ","DefaultValue":"1","Hidden":false,"Required":false,"Updateable":true},{"FieldName":"RecurrWeeklySun","FieldType":"String","Caption":"Sun","DefaultValue":"N","Hidden":false,"Required":false,"Updateable":true,"MaxLength":1},{"FieldName":"RecurrWeeklyMon","FieldType":"String","Caption":"Mon","DefaultValue":"N","Hidden":false,"Required":false,"Updateable":true,"MaxLength":1},{"FieldName":"RecurrWeeklyTue","FieldType":"String","Caption":"Tue","DefaultValue":"N","Hidden":false,"Required":false,"Updateable":true,"MaxLength":1},{"FieldName":"RecurrWeeklyWed","FieldType":"String","Caption":"Wed","DefaultValue":"N","Hidden":false,"Required":false,"Updateable":true,"MaxLength":1},{"FieldName":"RecurrWeeklyThu","FieldType":"String","Caption":"Thu","DefaultValue":"N","Hidden":false,"Required":false,"Updateable":true,"MaxLength":1},{"FieldName":"RecurrWeeklyFri","FieldType":"String","Caption":"Fri","DefaultValue":"N","Hidden":false,"Required":false,"Updateable":true,"MaxLength":1},{"FieldName":"RecurrWeeklySat","FieldType":"String","Caption":"Sat","DefaultValue":"N","Hidden":false,"Required":false,"Updateable":true,"MaxLength":1},{"FieldName":"RecurrMonthlyFreq","FieldType":"Numeric","Caption":" ","DefaultValue":"1","Hidden":false,"Required":false,"Updateable":true},{"FieldName":"RecurrMonthlyDay","FieldType":"Numeric","Caption":" ","DefaultValue":"0","Hidden":false,"Required":false,"Updateable":true},{"FieldName":"RecurrMonthlyOccurInd","FieldType":"String","Caption":" ","DefaultValue":"N","Hidden":false,"Required":false,"Updateable":true,"MaxLength":1},{"FieldName":"RecurrMonthlyOccur","FieldType":"Numeric","Caption":" ","DefaultValue":"0","Hidden":false,"Required":false,"Updateable":true},{"FieldName":"RecurrMonthlyOccurDay","FieldType":"Numeric","Caption":" ","DefaultValue":"0","Hidden":false,"Required":false,"Updateable":true},{"FieldName":"RecurrMonthlyOccurFreq","FieldType":"Numeric","Caption":" ","DefaultValue":"1","Hidden":false,"Required":false,"Updateable":true},{"FieldName":"RecurrYearlyMonth","FieldType":"Numeric","Caption":" ","DefaultValue":"0","Hidden":false,"Required":false,"Updateable":true},{"FieldName":"RecurrYearlyDay","FieldType":"Numeric","Caption":" ","DefaultValue":"0","Hidden":false,"Required":false,"Updateable":true},{"FieldName":"RecurrEndType","FieldType":"String","Caption":"Ends","DefaultValue":"N","Hidden":false,"Required":false,"Updateable":true,"MaxLength":1},{"FieldName":"RecurrStartDate","FieldType":"Date","Caption":"Recurrence Starts","DefaultValue":"","Hidden":false,"Required":false,"Updateable":true},{"FieldName":"RecurrEndDate","FieldType":"Date","Caption":"Recurrence Ends","DefaultValue":"","Hidden":false,"Required":false,"Updateable":true},{"FieldName":"TaskCompletionDate","FieldType":"Date","Caption":"Task Completion Date","DefaultValue":"","Hidden":false,"Required":false,"Updateable":true},{"FieldName":"RecurrID","FieldType":"String","Caption":"RecurrID","DefaultValue":"","Hidden":false,"Required":false,"Updateable":true},{"FieldName":"OutlookType","FieldType":"String","Caption":"OutlookType","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false},{"FieldName":"RecurrYearlyOccurInd","FieldType":"String","Caption":" ","DefaultValue":"N","Hidden":false,"Required":false,"Updateable":true},{"FieldName":"RecurrYearlyOccur","FieldType":"Numeric","Caption":" ","DefaultValue":"0","Hidden":false,"Required":false,"Updateable":true},{"FieldName":"RecurrYearlyOccurDay","FieldType":"Numeric","Caption":" ","DefaultValue":"0","Hidden":false,"Required":false,"Updateable":true},{"FieldName":"RecurrYearlyOccurMonth","FieldType":"Numeric","Caption":" ","DefaultValue":"0","Hidden":false,"Required":false,"Updateable":true},{"FieldName":"MaxOccurences","FieldType":"Numeric","Caption":"MaxOccurences","DefaultValue":"0","Hidden":false,"Required":false,"Updateable":true},{"FieldName":"UpdateID","FieldType":"String","Caption":"UpdateID","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false},{"FieldName":"ReadID","FieldType":"String","Caption":"ReadID","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false},{"FieldName":"PrimaryClient","FieldType":"Client","Caption":"Primary Firm","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false,"MaxLength":32},{"FieldName":"Attendees","FieldType":"Contact","Caption":"Attendees","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false},{"FieldName":"Associations","FieldType":"Firm","Caption":"Associations","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false,"MaxLength":32},{"FieldName":"EndDateSort","FieldType":"String","Caption":"EndDateSort","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false},{"FieldName":"EndDateFilter","FieldType":"String","Caption":"EndDateFilter","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false},{"FieldName":"ConversationID","FieldType":"String","Caption":"Conversation ID","DefaultValue":"","Hidden":false,"Required":false,"Updateable":true},{"FieldName":"CreateUser","FieldType":"User","Caption":"Created by","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false,"MaxLength":32},{"FieldName":"ModUser","FieldType":"User","Caption":"Modified by","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false,"MaxLength":32},{"FieldName":"CreateUserName","FieldType":"User","Caption":"CreateUserName","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false,"MaxLength":32},{"FieldName":"ModUserName","FieldType":"User","Caption":"ModUserName","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false,"MaxLength":32},{"FieldName":"CreateDate","FieldType":"Datetime","Caption":"Create date","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false},{"FieldName":"ModDate","FieldType":"Datetime","Caption":"Modify date","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false},{"FieldName":"SingleOccurrenceDateTime","FieldType":"Datetime","Caption":"Single occurrence date time ","DefaultValue":"","Hidden":false,"Required":false,"Updateable":true},{"FieldName":"ActivityTypeFlag","FieldType":"String","Caption":"Activity type","DefaultValue":"","Hidden":false,"Required":false,"Updateable":true},{"FieldName":"ParentMaxOccurences","FieldType":"Numeric","Caption":"ParentMaxOccurences","DefaultValue":"0","Hidden":false,"Required":false,"Updateable":false},{"FieldName":"ParentRecurrStartDate","FieldType":"Date","Caption":"ParentRecurrStartDate","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false},{"FieldName":"ParentRecurrEndDate","FieldType":"Date","Caption":"ParentRecurrEndDate","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false},{"FieldName":"ParentRecurrEndType","FieldType":"String","Caption":"ParentRecurrEndType","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false},{"FieldName":"ParentRecurrType","FieldType":"String","Caption":"ParentRecurrType","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false},{"FieldName":"OccurrenceDate","FieldType":"Datetime","Caption":"OccurrenceDate","DefaultValue":"","Hidden":false,"Required":false,"Updateable":true},{"FieldName":"ExceptionType","FieldType":"String","Caption":"ExceptionType","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false},{"FieldName":"TimeZoneOffset","FieldType":"Numeric","Caption":"TimeZoneOffset","DefaultValue":"0","Hidden":false,"Required":false,"Updateable":true}],"Caption":"Activity"},"EMPLOYEEFILELINKS":{"Keys":"LinkID,Employee","TableName":"EmployeeFileLinks","GridID":null,"Hidden":false,"Updateable":true,"Fields":[{"FieldName":"LinkID","FieldType":"String","Caption":"LinkID","DefaultValue":"[GUID]","Hidden":false,"Required":false,"Updateable":true,"MaxLength":32},{"FieldName":"Employee","FieldType":"String","Caption":"Employee","DefaultValue":"","Hidden":false,"Required":false,"Updateable":true},{"FieldName":"Description","FieldType":"String","Caption":"Description","DefaultValue":"","Hidden":false,"Required":true,"Updateable":true,"MaxLength":100},{"FieldName":"FilePath","FieldType":"String","Caption":"File Path","DefaultValue":"","Hidden":false,"Required":true,"Updateable":true,"MaxLength":255},{"FieldName":"Graphic","FieldType":"Checkbox","Caption":"Graphic","DefaultValue":"N","Hidden":false,"Required":false,"Updateable":true,"MaxLength":1},{"FieldName":"CreateUser","FieldType":"User","Caption":"Created by","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false,"MaxLength":32},{"FieldName":"ModUser","FieldType":"User","Caption":"Modified by","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false,"MaxLength":32},{"FieldName":"CreateDate","FieldType":"Datetime","Caption":"Create date","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false},{"FieldName":"ModDate","FieldType":"Datetime","Caption":"Modify date","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false}],"Caption":"Links"},"FW_ATTACHMENTS":{"Keys":"PKey,FileID","TableName":"FW_ATTACHMENTS","GridID":null,"Hidden":false,"Updateable":true,"Fields":[{"FieldName":"PKey","FieldType":"String","Caption":"PKey","DefaultValue":"[GUID]","Hidden":false,"Required":false,"Updateable":true,"MaxLength":32},{"FieldName":"FileID","FieldType":"String","Caption":"FileID","DefaultValue":"","Hidden":false,"Required":false,"Updateable":true,"MaxLength":36},{"FieldName":"Key1","FieldType":"String","Caption":"Key1","DefaultValue":"","Hidden":false,"Required":false,"Updateable":true,"MaxLength":32},{"FieldName":"Key2","FieldType":"String","Caption":"Key2","DefaultValue":"","Hidden":false,"Required":false,"Updateable":true,"MaxLength":32},{"FieldName":"Key3","FieldType":"String","Caption":"Key3","DefaultValue":"","Hidden":false,"Required":false,"Updateable":true,"MaxLength":32},{"FieldName":"Employee","FieldType":"String","Caption":"Employee","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false,"MaxLength":32},{"FieldName":"CategoryCode","FieldType":"Dropdown","Caption":"Category","DefaultValue":"","Hidden":false,"Required":false,"Updateable":true,"MaxLength":15,"CodeTable":"FW_CFGAttachmentCategory","LimitToList":true},{"FieldName":"CategoryDescription","FieldType":"String","Caption":"Category Description","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false,"MaxLength":255},{"FieldName":"FileName","FieldType":"String","Caption":"File Name","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false,"MaxLength":250},{"FieldName":"FileDescription","FieldType":"String","Caption":"Description","DefaultValue":"","Hidden":false,"Required":true,"Updateable":true,"MaxLength":500},{"FieldName":"FileSize","FieldType":"Numeric","Caption":"File Size","DefaultValue":"0","Hidden":false,"Required":false,"Updateable":false,"MaxLength":1},{"FieldName":"Application","FieldType":"String","Caption":"Application","DefaultValue":"Employees","Hidden":false,"Required":false,"Updateable":true,"MaxLength":250},{"FieldName":"ContentType","FieldType":"String","Caption":"Content Type","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false,"MaxLength":200},{"FieldName":"CreateUser","FieldType":"User","Caption":"Created by","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false,"MaxLength":32},{"FieldName":"ModUser","FieldType":"User","Caption":"Modified by","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false,"MaxLength":32},{"FieldName":"CreateDate","FieldType":"Datetime","Caption":"Create date","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false},{"FieldName":"ModDate","FieldType":"Datetime","Caption":"Modify date","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false}],"Caption":"Files"},"EMTIMERATIOS":{"Keys":"Ratios","TableName":"EMTIMERATIOS","GridID":null,"Hidden":false,"Updateable":false,"Fields":[{"FieldName":"Ratios","FieldType":"String","Caption":"Ratios","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false},{"FieldName":"CUR","FieldType":"Numeric","Caption":"CUR","DefaultValue":"0","Hidden":false,"Required":false,"Updateable":false,"Decimals":2},{"FieldName":"MTD","FieldType":"Numeric","Caption":"MTD","DefaultValue":"0","Hidden":false,"Required":false,"Updateable":false,"Decimals":2},{"FieldName":"YTD","FieldType":"Numeric","Caption":"YTD","DefaultValue":"0","Hidden":false,"Required":false,"Updateable":false,"Decimals":2},{"FieldName":"QTD","FieldType":"Numeric","Caption":"QTD","DefaultValue":"0","Hidden":false,"Required":false,"Updateable":false,"Decimals":2},{"FieldName":"ShowRatioCur","FieldType":"String","Caption":"ShowRatioCur","DefaultValue":"N","Hidden":false,"Required":false,"Updateable":false,"MaxLength":1},{"FieldName":"ShowRatioMTD","FieldType":"String","Caption":"ShowRatioMTD","DefaultValue":"N","Hidden":false,"Required":false,"Updateable":false,"MaxLength":1},{"FieldName":"ShowRatioQTD","FieldType":"String","Caption":"ShowRatioQTD","DefaultValue":"N","Hidden":false,"Required":false,"Updateable":false,"MaxLength":1},{"FieldName":"ShowRatioYTD","FieldType":"String","Caption":"ShowRatioYTD","DefaultValue":"N","Hidden":false,"Required":false,"Updateable":false,"MaxLength":1}],"Caption":"EMTIMERATIOS"},"EMBenefitHours":{"Keys":"Employee","TableName":"EMBenefitHours","GridID":null,"Hidden":false,"Updateable":false,"Fields":[{"FieldName":"Employee","FieldType":"Employee","Caption":"Employee","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false,"MaxLength":5},{"FieldName":"EnableApprovalWorkflow","FieldType":"String","Caption":"EnableApprovalWorkflow","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false,"MaxLength":1},{"FieldName":"Description","FieldType":"String","Caption":"Description","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false},{"FieldName":"StartBal","FieldType":"Numeric","Caption":"StartBal","DefaultValue":"0","Hidden":false,"Required":false,"Updateable":false,"Decimals":4},{"FieldName":"CurYrEarn","FieldType":"Numeric","Caption":"CurYrEarn","DefaultValue":"0","Hidden":false,"Required":false,"Updateable":false,"Decimals":4},{"FieldName":"CurYrTaken","FieldType":"Numeric","Caption":"CurYrTaken","DefaultValue":"0","Hidden":false,"Required":false,"Updateable":false,"Decimals":4},{"FieldName":"UnpostedTime","FieldType":"Numeric","Caption":"UnpostedTime","DefaultValue":"0","Hidden":false,"Required":false,"Updateable":false,"Decimals":4},{"FieldName":"CurBal","FieldType":"Numeric","Caption":"CurBal","DefaultValue":"0","Hidden":false,"Required":false,"Updateable":false,"Decimals":4}],"Caption":"EMBenefitHours"},"EMWORKHISTORY":{"Keys":"ProjectID","TableName":"PR","GridID":null,"Hidden":false,"Updateable":false,"Fields":[{"FieldName":"ProjectName","FieldType":"String","Caption":"ProjectName","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false,"MaxLength":40},{"FieldName":"ProjectID","FieldType":"WBS1","Caption":"ProjectID","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false,"MaxLength":10},{"FieldName":"RT_Status","FieldType":"String","Caption":"RT_Status","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false,"MaxLength":1},{"FieldName":"ClientName","FieldType":"String","Caption":"ClientName","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false,"MaxLength":100},{"FieldName":"TotalHours","FieldType":"Numeric","Caption":"TotalHours","DefaultValue":"0","Hidden":false,"Required":false,"Updateable":false,"Decimals":0},{"FieldName":"MinDate","FieldType":"Datetime","Caption":"MinDate","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false},{"FieldName":"MaxDate","FieldType":"Datetime","Caption":"MaxDate","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false},{"FieldName":"ProjMgrName","FieldType":"String","Caption":"ProjMgrName","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false}],"Caption":"PR"},"EMResume":{"Keys":"Employee,ResumeCategory","TableName":"EMResume","GridID":null,"Hidden":false,"Updateable":true,"Fields":[{"FieldName":"Employee","FieldType":"Employee","Caption":"Employee","DefaultValue":"","Hidden":false,"Required":true,"Updateable":true,"MaxLength":5},{"FieldName":"ResumeCategory","FieldType":"Dropdown","Caption":"Category","DefaultValue":"","Hidden":false,"Required":true,"Updateable":true,"MaxLength":60,"CodeTable":"CFGResumeCategory","LimitToList":true},{"FieldName":"ResumeCategoryDescription","FieldType":"String","Caption":"ResumeCategoryDescription","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false},{"FieldName":"ResumeText","FieldType":"String","Caption":"Resume Text","DefaultValue":"","Hidden":false,"Required":false,"Updateable":true},{"FieldName":"DefaultInd","FieldType":"Checkbox","Caption":"Default","DefaultValue":"N","Hidden":false,"Required":false,"Updateable":true,"MaxLength":1},{"FieldName":"CreateUser","FieldType":"User","Caption":"Created by","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false,"MaxLength":32},{"FieldName":"ModUser","FieldType":"User","Caption":"Modified by","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false,"MaxLength":32},{"FieldName":"CreateDate","FieldType":"Datetime","Caption":"Create date","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false},{"FieldName":"ModDate","FieldType":"Datetime","Caption":"Modify date","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false}],"Caption":"Resume"},"EMProjectAssoc":{"Keys":"Employee,WBS1,WBS2,WBS3,RecordID","TableName":"EMProjectAssoc","GridID":null,"Hidden":false,"Updateable":true,"Fields":[{"FieldName":"RecordID","FieldType":"String","Caption":"RecordID","DefaultValue":"[GUID]","Hidden":false,"Required":true,"Updateable":true,"MaxLength":32},{"FieldName":"WBS1","FieldType":"WBS1","Caption":"Number","DefaultValue":"","Hidden":false,"Required":true,"Updateable":true,"MaxLength":10},{"FieldName":"WBS2","FieldType":"WBS2","Caption":"WBS2","DefaultValue":" ","Hidden":false,"Required":false,"Updateable":true,"MaxLength":3},{"FieldName":"WBS3","FieldType":"WBS3","Caption":"WBS3","DefaultValue":" ","Hidden":false,"Required":false,"Updateable":true,"MaxLength":3},{"FieldName":"Employee","FieldType":"Employee","Caption":"Employee","DefaultValue":"","Hidden":false,"Required":true,"Updateable":true,"MaxLength":5},{"FieldName":"Role","FieldType":"Dropdown","Caption":"Role","DefaultValue":" ","Hidden":false,"Required":false,"Updateable":true,"MaxLength":60,"CodeTable":"CFGEmployeeRole","LimitToList":true},{"FieldName":"RoleDesc","FieldType":"String","Caption":"RoleDesc","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false},{"FieldName":"RoleDescription","FieldType":"Memo","Caption":"Role Description","DefaultValue":"","Hidden":false,"Required":false,"Updateable":true},{"FieldName":"TeamStatus","FieldType":"String","Caption":"TeamStatus","DefaultValue":"Proposed","Hidden":false,"Required":false,"Updateable":true,"MaxLength":10},{"FieldName":"StartDate","FieldType":"Date","Caption":"Start Date","DefaultValue":"","Hidden":false,"Required":false,"Updateable":true},{"FieldName":"EndDate","FieldType":"Date","Caption":"End Date","DefaultValue":"","Hidden":false,"Required":false,"Updateable":true},{"FieldName":"CRMHours","FieldType":"Numeric","Caption":"Hours","DefaultValue":"0","Hidden":false,"Required":false,"Updateable":false},{"FieldName":"Project","FieldType":"String","Caption":"Name","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false,"MaxLength":40},{"FieldName":"PrimaryClientID","FieldType":"Client","Caption":"Client","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false,"MaxLength":32},{"FieldName":"PrimaryClient","FieldType":"Client","Caption":"Primary Client Name","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false,"MaxLength":32},{"FieldName":"PrimaryContactID","FieldType":"Contact","Caption":"Contact","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false,"MaxLength":32},{"FieldName":"PrimaryContact","FieldType":"String","Caption":"Primary Contact Name","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false,"MaxLength":75},{"FieldName":"PrimaryContactEmail","FieldType":"String","Caption":"Primary Contact Email","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false,"MaxLength":255},{"FieldName":"PrimaryContactWorkPhone","FieldType":"Phone","Caption":"Primary Contact Phone","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false,"MaxLength":24},{"FieldName":"Status","FieldType":"Dropdown","Caption":"Status","DefaultValue":"A","Hidden":false,"Required":false,"Updateable":false,"MaxLength":1,"CodeTable":"CFGProjectStatus","LimitToList":true},{"FieldName":"ProjectAddress1","FieldType":"String","Caption":"Address","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false,"MaxLength":50},{"FieldName":"ProjectAddress2","FieldType":"String","Caption":"Address","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false,"MaxLength":50},{"FieldName":"ProjectAddress3","FieldType":"String","Caption":"Address","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false,"MaxLength":50},{"FieldName":"ProjectCity","FieldType":"String","Caption":"City","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false,"MaxLength":30},{"FieldName":"ProjectState","FieldType":"Dropdown","Caption":"State/Province","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false,"CodeTable":"CFGStates","LimitToList":true},{"FieldName":"ProjectZip","FieldType":"String","Caption":"Zip/Postcode","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false,"MaxLength":10},{"FieldName":"ProjectCountry","FieldType":"Dropdown","Caption":"Country","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false,"MaxLength":40,"CodeTable":"FW_CFGCountry","LimitToList":true},{"FieldName":"ProjectCounty","FieldType":"Dropdown","Caption":"County","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false,"MaxLength":50,"CodeTable":"CFGCounty","LimitToList":false},{"FieldName":"ProjMgrName","FieldType":"Employee","Caption":"Project Manager Full Name","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false,"MaxLength":5},{"FieldName":"PrincipalName","FieldType":"Employee","Caption":"Principal-In-Charge Full Name","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false,"MaxLength":5},{"FieldName":"SupervisorName","FieldType":"Employee","Caption":"Supervisor Full Name","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false,"MaxLength":5},{"FieldName":"OwnerName","FieldType":"String","Caption":"Owner","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false},{"FieldName":"OrgName","FieldType":"String","Caption":"Organization","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false,"MaxLength":100},{"FieldName":"CloseDate","FieldType":"Date","Caption":"Won/Lost Date","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false},{"FieldName":"Revenue","FieldType":"Currency","Caption":"Estimated Fee","DefaultValue":"0","Hidden":false,"Required":false,"Updateable":false,"Digits":15},{"FieldName":"ProjectType","FieldType":"Dropdown","Caption":"Project Type","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false,"MaxLength":50,"CodeTable":"CFGProjectType","LimitToList":true},{"FieldName":"EstCompletionDate","FieldType":"Date","Caption":"Estimated Completion Date","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false},{"FieldName":"ActCompletionDate","FieldType":"Date","Caption":"Actual Completion Date","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false},{"FieldName":"EstStartDate","FieldType":"Date","Caption":"Estimated Start Date","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false},{"FieldName":"ActualStartDate","FieldType":"Date","Caption":"Actual Start Date","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false},{"FieldName":"FirmCost","FieldType":"Currency","Caption":"Our Cost","DefaultValue":"0","Hidden":false,"Required":false,"Updateable":false},{"FieldName":"ProfServicesComplDate","FieldType":"Date","Caption":"Professional Services Completion Date","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false},{"FieldName":"ConstComplDate","FieldType":"Date","Caption":"Construction Completion Date","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false},{"FieldName":"ContractDate","FieldType":"Date","Caption":"Contract Awarded Date","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false},{"FieldName":"LongName","FieldType":"String","Caption":"Long Name","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false,"MaxLength":255},{"FieldName":"TotalContractValue","FieldType":"Currency","Caption":"Owner Value","DefaultValue":"0","Hidden":false,"Required":false,"Updateable":false,"Digits":15},{"FieldName":"Stage","FieldType":"Dropdown","Caption":"Stage","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false,"CodeTable":"CFGProjectStage","LimitToList":true},{"FieldName":"StageDescription","FieldType":"String","Caption":"Stage","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false},{"FieldName":"Memo","FieldType":"Memo","Caption":"Additional Details","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false},{"FieldName":"Fee","FieldType":"Currency","Caption":"Compensation","DefaultValue":"0","Hidden":false,"Required":false,"Updateable":false},{"FieldName":"Description","FieldType":"Memo","Caption":"Description","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false,"MaxLength":2147483647},{"FieldName":"CustDRRList","FieldType":"Dropdown","Caption":"DRR List","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false,"CustomField":true,"LimitToList":false},{"FieldName":"desc_CustUDIC_testhub","FieldType":"String","Caption":"UDIC_testhub Description","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false,"CustomField":true},{"FieldName":"CustUDIC_testhub","FieldType":"UDIC","Caption":"UDIC_testhub","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false,"CustomField":true,"UDICType":"UDIC_testhub"},{"FieldName":"CustNewNumericField","FieldType":"Numeric","Caption":"New Numeric Field","DefaultValue":"1","Hidden":false,"Required":false,"Updateable":false,"CustomField":true,"Decimals":2,"MinValue":0,"MaxValue":5},{"FieldName":"desc_CustLocation","FieldType":"String","Caption":"Location Description","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false,"CustomField":true},{"FieldName":"CustLocation","FieldType":"WBS1","Caption":"Location","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false,"CustomField":true,"MaxLength":10},{"FieldName":"desc_CustBillingCareOf","FieldType":"String","Caption":"Billing Care Of Description","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false,"CustomField":true},{"FieldName":"CustBillingCareOf","FieldType":"Contact","Caption":"Billing Care Of","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false,"CustomField":true},{"FieldName":"desc_CustDarwin","FieldType":"String","Caption":"Darwin Description","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false,"CustomField":true},{"FieldName":"CustDarwin","FieldType":"WBS1","Caption":"Darwin","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false,"CustomField":true,"MaxLength":10},{"FieldName":"CustStartDate","FieldType":"Date","Caption":"Start Date","DefaultValue":"2018-12-17","Hidden":false,"Required":false,"Updateable":false,"CustomField":true},{"FieldName":"desc_CustAccountNumber","FieldType":"String","Caption":"Account Number Description","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false,"CustomField":true},{"FieldName":"CustAccountNumber","FieldType":"Account","Caption":"Account Number","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false,"CustomField":true,"MaxLength":6},{"FieldName":"Custnewcurrencytype","FieldType":"Currency","Caption":"new currency type","DefaultValue":"500","Hidden":false,"Required":false,"Updateable":false,"CustomField":true,"MinValue":500,"MaxValue":50000},{"FieldName":"CustCurrencyfromStandard","FieldType":"Currency","Caption":"Currency from Standard","DefaultValue":"1000","Hidden":false,"Required":false,"Updateable":false,"CustomField":true,"MinValue":1000,"MaxValue":10000},{"FieldName":"CustProj","FieldType":"Numeric","Caption":"ProjNumTest","DefaultValue":"3","Hidden":false,"Required":false,"Updateable":false,"CustomField":true,"Decimals":0},{"FieldName":"desc_CustContactPersonUDF","FieldType":"String","Caption":"Contact Person UDF Description","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false,"CustomField":true},{"FieldName":"CustContactPersonUDF","FieldType":"Employee","Caption":"Contact Person UDF","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false,"CustomField":true,"MaxLength":5},{"FieldName":"desc_custCaptureManager","FieldType":"String","Caption":"[OPP] Capture Manager Description","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false,"CustomField":true},{"FieldName":"custCaptureManager","FieldType":"Employee","Caption":"[OPP] Capture Manager","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false,"CustomField":true,"MaxLength":5},{"FieldName":"custDate","FieldType":"Date","Caption":"[OPP] Date","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false,"CustomField":true},{"FieldName":"desc_custLeadConsultant","FieldType":"String","Caption":"[OPP] Lead Consultant Description","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false,"CustomField":true},{"FieldName":"custLeadConsultant","FieldType":"Firm","Caption":"[OPP] Lead Consultant","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false,"CustomField":true,"MaxLength":32},{"FieldName":"desc_custProposalManager","FieldType":"String","Caption":"[OPP] Proposal Manager Description","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false,"CustomField":true},{"FieldName":"custProposalManager","FieldType":"Employee","Caption":"[OPP] Proposal Manager","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false,"CustomField":true,"MaxLength":5},{"FieldName":"desc_custTechnicalWriter","FieldType":"String","Caption":"[OPP] Technical Writer Description","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false,"CustomField":true},{"FieldName":"custTechnicalWriter","FieldType":"Employee","Caption":"[OPP] Technical Writer","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false,"CustomField":true,"MaxLength":5},{"FieldName":"custUDF","FieldType":"String","Caption":"[OPP] UDF","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false,"CustomField":true,"MaxLength":255},{"FieldName":"custINPUTAcronym","FieldType":"String","Caption":"[OPP] Acronym","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false,"CustomField":true,"MaxLength":255},{"FieldName":"custINPUTAgency","FieldType":"String","Caption":"[OPP] Agency","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false,"CustomField":true,"MaxLength":255},{"FieldName":"custINPUTComments","FieldType":"Memo","Caption":"[OPP] Comments","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false,"CustomField":true},{"FieldName":"custINPUTCompetitionType","FieldType":"String","Caption":"[OPP] Competition Type","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false,"CustomField":true,"MaxLength":255},{"FieldName":"custINPUTContractType","FieldType":"String","Caption":"[OPP] Contract Type","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false,"CustomField":true,"MaxLength":255},{"FieldName":"custINPUTCurrentStatus","FieldType":"Memo","Caption":"[OPP] Current Status","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false,"CustomField":true},{"FieldName":"custINPUTDepartment","FieldType":"String","Caption":"[OPP] Department","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false,"CustomField":true,"MaxLength":255},{"FieldName":"custINPUTDuration","FieldType":"String","Caption":"[OPP] Duration","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false,"CustomField":true,"MaxLength":255},{"FieldName":"custINPUTEstimatedValue","FieldType":"Numeric","Caption":"[OPP] Estimated Value ($K)","DefaultValue":"0","Hidden":false,"Required":false,"Updateable":false,"CustomField":true,"Decimals":0},{"FieldName":"custINPUTLastUpdate","FieldType":"Date","Caption":"[OPP] IQ Analyst Update","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false,"CustomField":true},{"FieldName":"custINPUTID","FieldType":"String","Caption":"[OPP] IQ ID","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false,"CustomField":true,"MaxLength":255},{"FieldName":"custINPUTAgencyWebsite","FieldType":"URL","Caption":"[OPP] IQ Opportunity Link","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false,"CustomField":true},{"FieldName":"custINPUTLastGovWinUpdate","FieldType":"Date","Caption":"[OPP] Last IQ Sync","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false,"CustomField":true},{"FieldName":"custINPUTNAICSCode","FieldType":"String","Caption":"[OPP] NAICS Code","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false,"CustomField":true,"MaxLength":255},{"FieldName":"custINPUTPotentialBidders","FieldType":"Memo","Caption":"[OPP] Potential Bidders","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false,"CustomField":true},{"FieldName":"custINPUTPrimaryOffering","FieldType":"String","Caption":"[OPP] Primary Offering","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false,"CustomField":true,"MaxLength":255},{"FieldName":"custINPUTProcurementActivity","FieldType":"Memo","Caption":"[OPP] Procurement Activity","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false,"CustomField":true},{"FieldName":"custINPUTProgramDescription","FieldType":"Memo","Caption":"[OPP] Program Description","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false,"CustomField":true},{"FieldName":"custINPUTProgramName","FieldType":"String","Caption":"[OPP] Program Name","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false,"CustomField":true,"MaxLength":255},{"FieldName":"custINPUTSolicitationNumber","FieldType":"String","Caption":"[OPP] Solicitation Number","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false,"CustomField":true,"MaxLength":255},{"FieldName":"custINPUTSummary","FieldType":"Memo","Caption":"[OPP] Summary","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false,"CustomField":true},{"FieldName":"desc_custExteriorAttributes","FieldType":"String","Caption":"Exterior Attributes Description","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false,"CustomField":true},{"FieldName":"custExteriorAttributes","FieldType":"Dropdown","Caption":"Exterior Attributes","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false,"CustomField":true,"LimitToList":true},{"FieldName":"CustField2","FieldType":"String","Caption":"Field 2","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false,"CustomField":true,"MaxLength":255},{"FieldName":"CustField3","FieldType":"String","Caption":"Field 3","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false,"CustomField":true,"MaxLength":255},{"FieldName":"custNoofFloors","FieldType":"Numeric","Caption":"No. of Floors","DefaultValue":"0","Hidden":false,"Required":false,"Updateable":false,"CustomField":true,"Decimals":0},{"FieldName":"CustOtherinfo","FieldType":"String","Caption":"Other info","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false,"CustomField":true,"MaxLength":255},{"FieldName":"desc_custPropManager","FieldType":"String","Caption":"Prop. Manager Description","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false,"CustomField":true},{"FieldName":"custPropManager","FieldType":"Employee","Caption":"Prop. Manager","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false,"CustomField":true,"MaxLength":5},{"FieldName":"CreateUser","FieldType":"User","Caption":"Created by","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false,"MaxLength":32},{"FieldName":"ModUser","FieldType":"User","Caption":"Modified by","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false,"MaxLength":32},{"FieldName":"CreateDate","FieldType":"Datetime","Caption":"Create date","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false},{"FieldName":"ModDate","FieldType":"Datetime","Caption":"Modify date","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false}],"Caption":"Projects"},"EMClientAssoc":{"Keys":"Employee,ClientID","TableName":"EMClientAssoc","GridID":null,"Hidden":false,"Updateable":true,"Fields":[{"FieldName":"Employee","FieldType":"Employee","Caption":"Employee","DefaultValue":"","Hidden":false,"Required":true,"Updateable":true,"MaxLength":5},{"FieldName":"ClientID","FieldType":"Client","Caption":"Name","DefaultValue":"","Hidden":false,"Required":true,"Updateable":true,"MaxLength":32},{"FieldName":"FirmName","FieldType":"String","Caption":"FirmName","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false},{"FieldName":"Relationship","FieldType":"Dropdown","Caption":"Relationship","DefaultValue":"","Hidden":false,"Required":false,"Updateable":true,"MaxLength":50,"CodeTable":"CFGEmployeeRelationship","LimitToList":true},{"FieldName":"RelationshipDesc","FieldType":"String","Caption":"Description","DefaultValue":"","Hidden":false,"Required":false,"Updateable":true},{"FieldName":"Status","FieldType":"Dropdown","Caption":"Status","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false,"MaxLength":30,"CodeTable":"CFGClientStatus","LimitToList":true},{"FieldName":"CreateUser","FieldType":"User","Caption":"Created by","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false,"MaxLength":32},{"FieldName":"ModUser","FieldType":"User","Caption":"Modified by","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false,"MaxLength":32},{"FieldName":"CreateDate","FieldType":"Datetime","Caption":"Create date","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false},{"FieldName":"ModDate","FieldType":"Datetime","Caption":"Modify date","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false}],"Caption":"Firms"},"EMContactAssoc":{"Keys":"Employee,ContactID","TableName":"EMContactAssoc","GridID":null,"Hidden":false,"Updateable":true,"Fields":[{"FieldName":"Employee","FieldType":"Employee","Caption":"Employee","DefaultValue":"","Hidden":false,"Required":true,"Updateable":true,"MaxLength":5},{"FieldName":"ContactID","FieldType":"Contact","Caption":"Name","DefaultValue":"","Hidden":false,"Required":true,"Updateable":true},{"FieldName":"ContactName","FieldType":"String","Caption":"ContactName","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false,"MaxLength":100},{"FieldName":"Relationship","FieldType":"Dropdown","Caption":"Relationship","DefaultValue":"","Hidden":false,"Required":false,"Updateable":true,"MaxLength":50,"CodeTable":"CFGEmployeeRelationship","LimitToList":true},{"FieldName":"RelationshipDesc","FieldType":"String","Caption":"Description","DefaultValue":"","Hidden":false,"Required":false,"Updateable":true},{"FieldName":"ContactStatus","FieldType":"Dropdown","Caption":"Status","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false,"MaxLength":50,"CodeTable":"ContactStatus","LimitToList":true},{"FieldName":"CreateUser","FieldType":"User","Caption":"Created by","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false,"MaxLength":32},{"FieldName":"ModUser","FieldType":"User","Caption":"Modified by","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false,"MaxLength":32},{"FieldName":"CreateDate","FieldType":"Datetime","Caption":"Create date","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false},{"FieldName":"ModDate","FieldType":"Datetime","Caption":"Modify date","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false}],"Caption":"Contacts"},"EMTKGROUPS":{"Keys":"Employee,TKGroup,Company","TableName":"EMTKGROUPS","GridID":null,"Hidden":false,"Updateable":true,"Fields":[{"FieldName":"Employee","FieldType":"Employee","Caption":"Employee","DefaultValue":"","Hidden":false,"Required":true,"Updateable":true,"MaxLength":5},{"FieldName":"Company","FieldType":"Company","Caption":"Company","DefaultValue":"","Hidden":false,"Required":true,"Updateable":true,"MaxLength":14},{"FieldName":"TKGroupDesc","FieldType":"Dropdown","Caption":"Description","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false,"MaxLength":20,"CodeTable":"CFGTKEmployeeGroup","LimitToList":true},{"FieldName":"TKGroup","FieldType":"String","Caption":"Timesheet Group","DefaultValue":"","Hidden":false,"Required":true,"Updateable":true,"MaxLength":20},{"FieldName":"AllowEdit","FieldType":"Checkbox","Caption":"Editing","DefaultValue":"N","Hidden":false,"Required":false,"Updateable":true,"MaxLength":1},{"FieldName":"CreateUser","FieldType":"User","Caption":"Created by","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false,"MaxLength":32},{"FieldName":"ModUser","FieldType":"User","Caption":"Modified by","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false,"MaxLength":32},{"FieldName":"CreateDate","FieldType":"Datetime","Caption":"Create date","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false},{"FieldName":"ModDate","FieldType":"Datetime","Caption":"Modify date","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false}],"Caption":"Timesheet Group"},"EMEKGROUPS":{"Keys":"Employee,EKGroup,Company","TableName":"EMEKGROUPS","GridID":null,"Hidden":false,"Updateable":true,"Fields":[{"FieldName":"Employee","FieldType":"Employee","Caption":"Employee","DefaultValue":"","Hidden":false,"Required":true,"Updateable":true,"MaxLength":5},{"FieldName":"Company","FieldType":"Company","Caption":"Company","DefaultValue":"","Hidden":false,"Required":true,"Updateable":true,"MaxLength":14},{"FieldName":"EKGroup","FieldType":"Dropdown","Caption":"Timesheet Group","DefaultValue":"","Hidden":false,"Required":true,"Updateable":true,"MaxLength":20,"LimitToList":true},{"FieldName":"EKGroupDesc","FieldType":"String","Caption":"Description","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false,"MaxLength":20},{"FieldName":"AllowEdit","FieldType":"Checkbox","Caption":"Editing","DefaultValue":"N","Hidden":false,"Required":false,"Updateable":true,"MaxLength":1},{"FieldName":"CreateUser","FieldType":"User","Caption":"Created by","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false,"MaxLength":32},{"FieldName":"ModUser","FieldType":"User","Caption":"Modified by","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false,"MaxLength":32},{"FieldName":"CreateDate","FieldType":"Datetime","Caption":"Create date","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false},{"FieldName":"ModDate","FieldType":"Datetime","Caption":"Modify date","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false}],"Caption":"Expense Group"},"EMPAYROLLWITHHOLDING":{"Keys":"Employee,Code,EmployeeCompany","TableName":"EMPAYROLLWITHHOLDING","GridID":null,"Hidden":false,"Updateable":true,"Fields":[{"FieldName":"Employee","FieldType":"Employee","Caption":"Employee","DefaultValue":"","Hidden":false,"Required":true,"Updateable":true,"MaxLength":5},{"FieldName":"Locale","FieldType":"String","Caption":"Locale","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false,"MaxLength":12},{"FieldName":"Type","FieldType":"String","Caption":"Type","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false,"MaxLength":6},{"FieldName":"SystemSuppress","FieldType":"String","Caption":"SystemSuppress","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false,"MaxLength":6},{"FieldName":"Code","FieldType":"Dropdown","Caption":"Withholding Code","DefaultValue":"","Hidden":false,"Required":true,"Updateable":true,"MaxLength":10,"LimitToList":true},{"FieldName":"Suppress","FieldType":"Dropdown","Caption":"Active","DefaultValue":"S","Hidden":false,"Required":true,"Updateable":true,"MaxLength":1,"Codes":{"A":"Active","I":"Inactive","S":"System"},"LimitToList":true},{"FieldName":"PrintOnCheck","FieldType":"Dropdown","Caption":"Print On/Check","DefaultValue":"S","Hidden":false,"Required":true,"Updateable":true,"MaxLength":1,"Codes":{"P":"Print","N":"No Print","S":"System"},"LimitToList":true},{"FieldName":"Method","FieldType":"Dropdown","Caption":"Method","DefaultValue":"S","Hidden":false,"Required":true,"Updateable":true,"MaxLength":1,"Codes":{"A":"Amount","P":"Percentage","S":"System","N":"None"},"LimitToList":true},{"FieldName":"AmtPct","FieldType":"Numeric","Caption":"AmtPct","DefaultValue":"0","Hidden":false,"Required":false,"Updateable":true,"Decimals":4},{"FieldName":"FilingStatus","FieldType":"Dropdown","Caption":"Filing Status","DefaultValue":"","Hidden":false,"Required":false,"Updateable":true,"MaxLength":1,"LimitToList":true},{"FieldName":"Exemptions","FieldType":"Numeric","Caption":"Exemptions","DefaultValue":"0","Hidden":false,"Required":false,"Updateable":true},{"FieldName":"AdditionalAmt","FieldType":"Currency","Caption":"Additional Amount","DefaultValue":"0","Hidden":false,"Required":false,"Updateable":true},{"FieldName":"OtherExemptions","FieldType":"Numeric","Caption":"Other Exemptions","DefaultValue":"0","Hidden":false,"Required":false,"Updateable":true},{"FieldName":"Limit","FieldType":"Currency","Caption":"Limit","DefaultValue":"0","Hidden":false,"Required":false,"Updateable":true},{"FieldName":"LimitLinkCode","FieldType":"String","Caption":"LimitLinkCode","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false,"MaxLength":10},{"FieldName":"FilingStatusRequired","FieldType":"String","Caption":"FilingStatusRequired","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false,"MaxLength":1},{"FieldName":"UsePrimaryExemptions","FieldType":"String","Caption":"UsePrimaryExemptions","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false,"MaxLength":1},{"FieldName":"UseSecondaryExemptions","FieldType":"String","Caption":"UseSecondaryExemptions","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false,"MaxLength":1},{"FieldName":"EmployeeCompany","FieldType":"Company","Caption":"EmployeeCompany","DefaultValue":"","Hidden":false,"Required":true,"Updateable":true,"MaxLength":14},{"FieldName":"CreateUser","FieldType":"User","Caption":"Created by","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false,"MaxLength":32},{"FieldName":"ModUser","FieldType":"User","Caption":"Modified by","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false,"MaxLength":32},{"FieldName":"CreateDate","FieldType":"Datetime","Caption":"Create date","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false},{"FieldName":"ModDate","FieldType":"Datetime","Caption":"Modify date","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false}],"Caption":"Withholding"},"EMPAYROLLCONTRIBUTION":{"Keys":"Employee,Code,EmployeeCompany","TableName":"EMPAYROLLCONTRIBUTION","GridID":null,"Hidden":false,"Updateable":true,"Fields":[{"FieldName":"Employee","FieldType":"Employee","Caption":"Employee","DefaultValue":"","Hidden":false,"Required":true,"Updateable":true,"MaxLength":5},{"FieldName":"SystemSuppress","FieldType":"String","Caption":"SystemSuppress","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false,"MaxLength":1},{"FieldName":"Code","FieldType":"Dropdown","Caption":"Contribution Code","DefaultValue":"","Hidden":false,"Required":true,"Updateable":true,"MaxLength":10,"LimitToList":true},{"FieldName":"Method","FieldType":"Dropdown","Caption":"Method","DefaultValue":"","Hidden":false,"Required":false,"Updateable":true,"MaxLength":1,"Codes":{"P":"Percent of [Employee] wages","W":"Percent of [Employee] withholding","F":"Fixed amount","L":"Lesser of [Employee] withholding or wages","R":"Rate table"},"LimitToList":true},{"FieldName":"Suppress","FieldType":"Dropdown","Caption":"Active","DefaultValue":"S","Hidden":false,"Required":true,"Updateable":true,"MaxLength":1,"Codes":{"A":"Active","I":"Inactive","S":"System"},"LimitToList":true},{"FieldName":"AmtPct","FieldType":"Numeric","Caption":"AmtPct","DefaultValue":"0","Hidden":false,"Required":false,"Updateable":true,"Decimals":4},{"FieldName":"AdditionalAmt","FieldType":"Currency","Caption":"Additional Amount","DefaultValue":"0","Hidden":false,"Required":false,"Updateable":true},{"FieldName":"Limit","FieldType":"Currency","Caption":"Limit","DefaultValue":"0","Hidden":false,"Required":false,"Updateable":true},{"FieldName":"EmployeeCompany","FieldType":"Company","Caption":"EmployeeCompany","DefaultValue":"","Hidden":false,"Required":true,"Updateable":true,"MaxLength":14},{"FieldName":"CreateUser","FieldType":"User","Caption":"Created by","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false,"MaxLength":32},{"FieldName":"ModUser","FieldType":"User","Caption":"Modified by","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false,"MaxLength":32},{"FieldName":"CreateDate","FieldType":"Datetime","Caption":"Create date","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false},{"FieldName":"ModDate","FieldType":"Datetime","Caption":"Modify date","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false}],"Caption":"Employer Contribution"},"EMLOCALE":{"Keys":"Employee,Locale,EmployeeCompany","TableName":"EMLOCALE","GridID":null,"Hidden":false,"Updateable":true,"Fields":[{"FieldName":"Employee","FieldType":"Employee","Caption":"Employee","DefaultValue":"","Hidden":false,"Required":true,"Updateable":true,"MaxLength":5},{"FieldName":"Locale","FieldType":"Dropdown","Caption":"Locale","DefaultValue":"","Hidden":false,"Required":true,"Updateable":true,"MaxLength":10,"LimitToList":true},{"FieldName":"EmployeeCompany","FieldType":"Company","Caption":"EmployeeCompany","DefaultValue":"","Hidden":false,"Required":true,"Updateable":true,"MaxLength":14},{"FieldName":"Active","FieldType":"Checkbox","Caption":"Active","DefaultValue":"Y","Hidden":false,"Required":false,"Updateable":true,"MaxLength":1},{"FieldName":"WagePct","FieldType":"Numeric","Caption":"% of Wages","DefaultValue":"0","Hidden":false,"Required":false,"Updateable":true,"Decimals":2},{"FieldName":"Code","FieldType":"Numeric","Caption":"Withholding Code","DefaultValue":"0","Hidden":false,"Required":false,"Updateable":false},{"FieldName":"Type","FieldType":"String","Caption":"Type","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false,"MaxLength":6},{"FieldName":"CreateUser","FieldType":"User","Caption":"Created by","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false,"MaxLength":32},{"FieldName":"ModUser","FieldType":"User","Caption":"Modified by","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false,"MaxLength":32},{"FieldName":"CreateDate","FieldType":"Datetime","Caption":"Create date","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false},{"FieldName":"ModDate","FieldType":"Datetime","Caption":"Modify date","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false}],"Caption":"State /Local /Tax /Jurisdictions"},"EQICEMAssoc":{"Keys":"Employee","TableName":"EQICEMAssoc","GridID":null,"Hidden":false,"Updateable":false,"Fields":[{"FieldName":"Company","FieldType":"String","Caption":"Company","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false,"MaxLength":42},{"FieldName":"AssetNumber","FieldType":"String","Caption":"AssetNumber","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false,"MaxLength":50},{"FieldName":"Description","FieldType":"String","Caption":"Description","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false,"MaxLength":100},{"FieldName":"SerialNumber","FieldType":"String","Caption":"SerialNumber","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false,"MaxLength":50},{"FieldName":"Manufacturer","FieldType":"String","Caption":"Manufacturer","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false,"MaxLength":100},{"FieldName":"ModelNumber","FieldType":"String","Caption":"ModelNumber","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false,"MaxLength":50},{"FieldName":"AssignedDate","FieldType":"Date","Caption":"AssignedDate","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false},{"FieldName":"CreateUser","FieldType":"User","Caption":"Created by","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false,"MaxLength":32},{"FieldName":"ModUser","FieldType":"User","Caption":"Modified by","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false,"MaxLength":32},{"FieldName":"CreateDate","FieldType":"Datetime","Caption":"Create date","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false},{"FieldName":"ModDate","FieldType":"Datetime","Caption":"Modify date","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false}],"Caption":"Assigned Assets"},"tsControl":{"Keys":"Batch","TableName":"tsControl","GridID":null,"Hidden":false,"Updateable":true,"Fields":[{"FieldName":"Batch","FieldType":"String","Caption":"Batch","DefaultValue":"","Hidden":false,"Required":false,"Updateable":true,"MaxLength":32},{"FieldName":"Description","FieldType":"String","Caption":"Description","DefaultValue":"","Hidden":false,"Required":false,"Updateable":true,"MaxLength":40},{"FieldName":"Creator","FieldType":"String","Caption":"Creator","DefaultValue":"","Hidden":false,"Required":false,"Updateable":true,"MaxLength":30},{"FieldName":"EndDate","FieldType":"Date","Caption":"EndDate","DefaultValue":"","Hidden":false,"Required":false,"Updateable":true},{"FieldName":"TotalHrs","FieldType":"Numeric","Caption":"TotalHrs","DefaultValue":"0","Hidden":false,"Required":false,"Updateable":true},{"FieldName":"Period","FieldType":"Numeric","Caption":"Period","DefaultValue":"0","Hidden":false,"Required":false,"Updateable":true}],"Caption":"tsControl"},"Employees_CustJulisCustomGrid":{"Keys":"Seq,Employee","CustomTable":true,"TableName":"Employees_CustJulisCustomGrid","GridID":"CustJulisCustomGrid","Hidden":false,"Updateable":true,"Fields":[{"FieldName":"Employee","FieldType":"String","Caption":"Employee","DefaultValue":"","Hidden":false,"Required":true,"Updateable":true},{"FieldName":"Seq","FieldType":"String","Caption":"Seq","DefaultValue":"[GUID]","Hidden":false,"Required":true,"Updateable":true,"MaxLength":32},{"FieldName":"CreateUser","FieldType":"User","Caption":"Created by","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false,"MaxLength":32},{"FieldName":"ModUser","FieldType":"User","Caption":"Modified by","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false,"MaxLength":32},{"FieldName":"CreateDate","FieldType":"Datetime","Caption":"Create date","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false},{"FieldName":"ModDate","FieldType":"Datetime","Caption":"Modify date","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false},{"FieldName":"CustColA","FieldType":"String","Caption":"Col A","DefaultValue":"","Hidden":false,"Required":false,"Updateable":true,"CustomField":true,"MaxLength":255},{"FieldName":"CustColB","FieldType":"String","Caption":"Col B","DefaultValue":"","Hidden":false,"Required":false,"Updateable":true,"CustomField":true,"MaxLength":255},{"FieldName":"CustColC","FieldType":"Checkbox","Caption":"Col C","DefaultValue":"N","Hidden":false,"Required":false,"Updateable":true,"CustomField":true},{"FieldName":"CustColD","FieldType":"Currency","Caption":"Col D","DefaultValue":"0","Hidden":false,"Required":false,"Updateable":true,"CustomField":true},{"FieldName":"CustColECurrency","FieldType":"Currency","Caption":"Col E - Currency","DefaultValue":"0","Hidden":false,"Required":false,"Updateable":true,"CustomField":true}],"Caption":"Juli's Custom Grid"},"Employees_CustGrid2":{"Keys":"Seq,Employee","CustomTable":true,"TableName":"Employees_CustGrid2","GridID":"CustGrid2","Hidden":false,"Updateable":true,"Fields":[{"FieldName":"Employee","FieldType":"String","Caption":"Employee","DefaultValue":"","Hidden":false,"Required":true,"Updateable":true},{"FieldName":"Seq","FieldType":"String","Caption":"Seq","DefaultValue":"[GUID]","Hidden":false,"Required":true,"Updateable":true,"MaxLength":32},{"FieldName":"CreateUser","FieldType":"User","Caption":"Created by","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false,"MaxLength":32},{"FieldName":"ModUser","FieldType":"User","Caption":"Modified by","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false,"MaxLength":32},{"FieldName":"CreateDate","FieldType":"Datetime","Caption":"Create date","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false},{"FieldName":"ModDate","FieldType":"Datetime","Caption":"Modify date","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false}],"Caption":"Grid 2"},"Employees_CustYetAnotherGrid":{"Keys":"Seq,Employee","CustomTable":true,"TableName":"Employees_CustYetAnotherGrid","GridID":"CustYetAnotherGrid","Hidden":false,"Updateable":true,"Fields":[{"FieldName":"Employee","FieldType":"String","Caption":"Employee","DefaultValue":"","Hidden":false,"Required":true,"Updateable":true},{"FieldName":"Seq","FieldType":"String","Caption":"Seq","DefaultValue":"[GUID]","Hidden":false,"Required":true,"Updateable":true,"MaxLength":32},{"FieldName":"CreateUser","FieldType":"User","Caption":"Created by","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false,"MaxLength":32},{"FieldName":"ModUser","FieldType":"User","Caption":"Modified by","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false,"MaxLength":32},{"FieldName":"CreateDate","FieldType":"Datetime","Caption":"Create date","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false},{"FieldName":"ModDate","FieldType":"Datetime","Caption":"Modify date","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false}],"Caption":"Yet Another Grid"},"Employees_CustSortbyCharactergrid":{"Keys":"Seq,Employee","CustomTable":true,"TableName":"Employees_CustSortbyCharactergrid","GridID":"CustSortbyCharactergrid","Hidden":false,"Updateable":true,"Fields":[{"FieldName":"Employee","FieldType":"String","Caption":"Employee","DefaultValue":"","Hidden":false,"Required":true,"Updateable":true},{"FieldName":"Seq","FieldType":"String","Caption":"Seq","DefaultValue":"[GUID]","Hidden":false,"Required":true,"Updateable":true,"MaxLength":32},{"FieldName":"CreateUser","FieldType":"User","Caption":"Created by","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false,"MaxLength":32},{"FieldName":"ModUser","FieldType":"User","Caption":"Modified by","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false,"MaxLength":32},{"FieldName":"CreateDate","FieldType":"Datetime","Caption":"Create date","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false},{"FieldName":"ModDate","FieldType":"Datetime","Caption":"Modify date","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false},{"FieldName":"CustcoCharacter1","FieldType":"String","Caption":"col 1-Character","DefaultValue":"","Hidden":false,"Required":false,"Updateable":true,"CustomField":true,"MaxLength":255},{"FieldName":"Custcol2Character","FieldType":"String","Caption":"col2-Character","DefaultValue":"","Hidden":false,"Required":false,"Updateable":true,"CustomField":true,"MaxLength":255},{"FieldName":"Custcol3Currency","FieldType":"Currency","Caption":"col3-Currency","DefaultValue":"0","Hidden":false,"Required":false,"Updateable":true,"CustomField":true},{"FieldName":"Custcol4CurrencyRecord","FieldType":"Currency","Caption":"col4-Currency (Record)","DefaultValue":"0","Hidden":false,"Required":false,"Updateable":true,"CustomField":true}],"Caption":"UD - Sort by Character grid"},"Employees_CustSortbyNumber":{"Keys":"Seq,Employee","CustomTable":true,"TableName":"Employees_CustSortbyNumber","GridID":"CustSortbyNumber","Hidden":false,"Updateable":true,"Fields":[{"FieldName":"Employee","FieldType":"String","Caption":"Employee","DefaultValue":"","Hidden":false,"Required":true,"Updateable":true},{"FieldName":"Seq","FieldType":"String","Caption":"Seq","DefaultValue":"[GUID]","Hidden":false,"Required":true,"Updateable":true,"MaxLength":32},{"FieldName":"CreateUser","FieldType":"User","Caption":"Created by","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false,"MaxLength":32},{"FieldName":"ModUser","FieldType":"User","Caption":"Modified by","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false,"MaxLength":32},{"FieldName":"CreateDate","FieldType":"Datetime","Caption":"Create date","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false},{"FieldName":"ModDate","FieldType":"Datetime","Caption":"Modify date","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false},{"FieldName":"CustCol1Character","FieldType":"String","Caption":"Col1-Character","DefaultValue":"","Hidden":false,"Required":false,"Updateable":true,"CustomField":true,"MaxLength":255},{"FieldName":"CustCol2Number","FieldType":"Numeric","Caption":"Col2-Number","DefaultValue":"0","Hidden":false,"Required":false,"Updateable":true,"CustomField":true,"Decimals":0}],"Caption":"UD - Sort by Number"},"Employees_CustEmploymentHistory_Sample1":{"Keys":"Seq,Employee","CustomTable":true,"TableName":"Employees_CustEmploymentHistory_Sample1","GridID":"CustEmploymentHistory_Sample1","Hidden":false,"Updateable":true,"RequiredRow":true,"Fields":[{"FieldName":"Employee","FieldType":"String","Caption":"Employee","DefaultValue":"","Hidden":false,"Required":true,"Updateable":true},{"FieldName":"Seq","FieldType":"String","Caption":"Seq","DefaultValue":"[GUID]","Hidden":false,"Required":true,"Updateable":true,"MaxLength":32},{"FieldName":"CreateUser","FieldType":"User","Caption":"Created by","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false,"MaxLength":32},{"FieldName":"ModUser","FieldType":"User","Caption":"Modified by","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false,"MaxLength":32},{"FieldName":"CreateDate","FieldType":"Datetime","Caption":"Create date","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false},{"FieldName":"ModDate","FieldType":"Datetime","Caption":"Modify date","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false},{"FieldName":"desc_CustEmployee","FieldType":"String","Caption":"Employee Description","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false,"CustomField":true},{"FieldName":"CustEmployee","FieldType":"Employee","Caption":"Employee","DefaultValue":"","Hidden":false,"Required":false,"Updateable":true,"CustomField":true,"MaxLength":5},{"FieldName":"CustCompany","FieldType":"String","Caption":"Company","DefaultValue":"","Hidden":false,"Required":false,"Updateable":true,"CustomField":true,"MaxLength":255},{"FieldName":"CustRegular","FieldType":"Checkbox","Caption":"Regular","DefaultValue":"N","Hidden":false,"Required":false,"Updateable":true,"CustomField":true}],"Caption":"Employment History"}}