| field name | data type | mnd. | description |
|---|---|---|---|
| emp_addr | character(80) | yes | Employee |
| emp_lname | character(30) | no | Last Name |
| emp_fname | character(30) | no | First Name |
| emp_line1 | character(36) | no | Address 1 |
| emp_line2 | character(36) | no | Address 2 |
| emp_city | character(30) | no | City |
| emp_state | character(30) | no | State |
| emp_zip | character(30) | no | Post |
| emp_country | character(30) | no | Country |
| emp_phone | character(30) | no | Home Phone |
| emp_bs_phone | character(30) | no | Business Phone |
| emp_ext | character(30) | no | Ext |
| emp_ssn | character(30) | no | SSN |
| emp_birthday | date | no | Birth Date |
| emp_emp_date | date | no | Date Employed |
| emp_trm_date | date | no | Date Terminated |
| emp_status | character(30) | no | Employment Status |
| emp_freq | character(30) | no | Pay Frequency |
| emp_pay_type | character(30) | no | Pay Type |
| emp_pay_rate | decimal(10) | no | Rate of Pay |
| emp_marital | character(30) | no | Marital Status |
| emp_exempt | integer | no | Personal Exemptions |
| emp_wk_loc | character(30) | no | Default Work Location |
| emp__qad01 | character(80) | no | |
| emp__qad02 | character(30) | no | |
| emp_project | character(80) | no | Default Project |
| emp_dept | character(80) | no | Department |
| emp_units | decimal(10) | no | Normal Hrs/Units |
| emp_sick_hrs | decimal(10) | no | Accrued Sick Leave |
| emp_vac_hrs | decimal(10) | no | Accrued Vacation |
| emp_title | character(80) | no | Job Title |
| emp_wc_class | character(30) | no | Worker Comp Class |
| emp_last_pay | decimal(10) | no | Prior Pay Rate |
| emp_last_dt | date | no | Date of Last Pay Rate Change |
| emp_line3 | character(36) | no | Address 3 |
| emp_user1 | character(80) | no | Ufld1 |
| emp_user2 | character(80) | no | Ufld2 |
| emp_user3 | character(80) | no | User3 |
| emp_user4 | decimal(10) | no | User4 |
| emp_user5 | decimal(10) | no | User5 |
| emp_user6 | date | no | User6 |
| emp_bank | character(30) | no | Bank |
| emp_ad_bank | character(80) | no | Auto Deposit Bank 1 |
| emp_ad_acc1 | character(30) | no | Acct 1 |
| emp_ad_amt1 | decimal(10) | no | Deposit Amount |
| emp_ad_pct1 | decimal(10) | no | Percentage |
| emp_ad_acc2 | character(30) | no | Acct 2 |
| emp_ad_amt2 | decimal(10) | no | Deposit Amount |
| emp_ad_pct2 | decimal(10) | no | Percentage |
| emp__chr01 | character(80) | no | |
| emp__chr02 | character(80) | no | |
| emp__chr03 | character(80) | no | |
| emp__chr04 | character(80) | no | |
| emp__chr05 | character(80) | no | |
| emp__dte01 | date | no | |
| emp__dte02 | date | no | |
| emp__dte03 | date | no | |
| emp__dte04 | date | no | |
| emp__dte05 | date | no | |
| emp__dec01 | decimal(10) | no | |
| emp__dec02 | decimal(10) | no | |
| emp__log01 | logical | no | |
| emp__log02 | logical | no | |
| emp_mod_date | date | no | Modified Date |
| emp_userid | character(80) | no | User ID |
| emp_ad_bank2 | character(80) | no | Auto Deposit Bank 2 |
| emp_transit1 | character(30) | no | Transit Number 1 |
| emp_transit2 | character(30) | no | Transit Number 2 |
| emp_ad_type1 | character(30) | no | Account 1 Type |
| emp_ad_type2 | character(30) | no | Account 2 Type |
| emp_shift | character(30) | no | Employee Shift |
| emp_ctry | character(30) | no | Country Code |
| emp_domain | character(8) | yes | Domain |
| oid_emp_mstr | decimal(10) | no | |
| emp_active | logical | no | Denotes whether employee is active based on Employee.EmployeeIsActive |
| emp_entity | character(30) | no | Reference to Company.CompanyCode |
| emp_name | character(36) | no | Name |
| emp_sort | character(30) | no | Sort Name |
| tc_Rowid | character | yes | primary index |
| tc_ParentRowid | character | no | empty string |
| tc_Status | character | no | update status |
| field name | data type | description |
|---|---|---|
| tcCustomShort0 | character | |
| tcCustomShort1 | character | |
| tcCustomShort2 | character | |
| tcCustomShort3 | character | |
| tcCustomShort4 | character | |
| tcCustomShort5 | character | |
| tcCustomShort6 | character | |
| tcCustomShort7 | character | |
| tcCustomShort8 | character | |
| tcCustomShort9 | character | |
| tcCustomCombo0 | character | |
| tcCustomCombo1 | character | |
| tcCustomCombo2 | character | |
| tcCustomCombo3 | character | |
| tcCustomCombo4 | character | |
| tcCustomCombo5 | character | |
| tcCustomCombo6 | character | |
| tcCustomCombo7 | character | |
| tcCustomCombo8 | character | |
| tcCustomCombo9 | character | |
| tcCustomLong0 | character | |
| tcCustomLong1 | character | |
| tcCustomNote | character | |
| ttCustomDate0 | date | |
| ttCustomDate1 | date | |
| ttCustomDate2 | date | |
| ttCustomDate3 | date | |
| ttCustomDate4 | date | |
| tiCustomInteger0 | integer | |
| tiCustomInteger1 | integer | |
| tiCustomInteger2 | integer | |
| tiCustomInteger3 | integer | |
| tiCustomInteger4 | integer | |
| tdCustomDecimal0 | decimal(4) | |
| tdCustomDecimal1 | decimal(4) | |
| tdCustomDecimal2 | decimal(4) | |
| tdCustomDecimal3 | decimal(4) | |
| tdCustomDecimal4 | decimal(4) | |
| tc_Rowid | character | Use this data item to add as a field in public temp-tables (with index). |
| tc_ParentRowid | character | |
| tc_Status | character |
| field name | data type | description |
|---|---|---|
| tcCustomShort0 | character | |
| tcCustomShort1 | character | |
| tcCustomShort2 | character | |
| tcCustomShort3 | character | |
| tcCustomShort4 | character | |
| tcCustomShort5 | character | |
| tcCustomShort6 | character | |
| tcCustomShort7 | character | |
| tcCustomShort8 | character | |
| tcCustomShort9 | character | |
| tcCustomCombo0 | character | |
| tcCustomCombo1 | character | |
| tcCustomCombo2 | character | |
| tcCustomCombo3 | character | |
| tcCustomCombo4 | character | |
| tcCustomCombo5 | character | |
| tcCustomCombo6 | character | |
| tcCustomCombo7 | character | |
| tcCustomCombo8 | character | |
| tcCustomCombo9 | character | |
| tcCustomLong0 | character | |
| tcCustomLong1 | character | |
| tcCustomNote | character | |
| ttCustomDate0 | date | |
| ttCustomDate1 | date | |
| ttCustomDate2 | date | |
| ttCustomDate3 | date | |
| ttCustomDate4 | date | |
| tiCustomInteger0 | integer | |
| tiCustomInteger1 | integer | |
| tiCustomInteger2 | integer | |
| tiCustomInteger3 | integer | |
| tiCustomInteger4 | integer | |
| tdCustomDecimal0 | decimal(4) | |
| tdCustomDecimal1 | decimal(4) | |
| tdCustomDecimal2 | decimal(4) | |
| tdCustomDecimal3 | decimal(4) | |
| tdCustomDecimal4 | decimal(4) | |
| tc_Rowid | character | Use this data item to add as a field in public temp-tables (with index). |
| tc_ParentRowid | character | |
| tc_Status | character |
| field name | data type | description |
|---|---|---|
| tcCustomShort0 | character | |
| tcCustomShort1 | character | |
| tcCustomShort2 | character | |
| tcCustomShort3 | character | |
| tcCustomShort4 | character | |
| tcCustomShort5 | character | |
| tcCustomShort6 | character | |
| tcCustomShort7 | character | |
| tcCustomShort8 | character | |
| tcCustomShort9 | character | |
| tcCustomCombo0 | character | |
| tcCustomCombo1 | character | |
| tcCustomCombo2 | character | |
| tcCustomCombo3 | character | |
| tcCustomCombo4 | character | |
| tcCustomCombo5 | character | |
| tcCustomCombo6 | character | |
| tcCustomCombo7 | character | |
| tcCustomCombo8 | character | |
| tcCustomCombo9 | character | |
| tcCustomLong0 | character | |
| tcCustomLong1 | character | |
| tcCustomNote | character | |
| ttCustomDate0 | date | |
| ttCustomDate1 | date | |
| ttCustomDate2 | date | |
| ttCustomDate3 | date | |
| ttCustomDate4 | date | |
| tiCustomInteger0 | integer | |
| tiCustomInteger1 | integer | |
| tiCustomInteger2 | integer | |
| tiCustomInteger3 | integer | |
| tiCustomInteger4 | integer | |
| tdCustomDecimal0 | decimal(4) | |
| tdCustomDecimal1 | decimal(4) | |
| tdCustomDecimal2 | decimal(4) | |
| tdCustomDecimal3 | decimal(4) | |
| tdCustomDecimal4 | decimal(4) | |
| tc_Rowid | character | Use this data item to add as a field in public temp-tables (with index). |
| tc_ParentRowid | character | |
| tc_Status | character |