| Column | Field | Description | SQL Type | Length | Decimals | Relation | Default Value | Constraints | SQL Create Statement |
|---|
| 1 | empID | Employee No. | int | 11 | 0 | | | | Allow NULL? |
| 2 | lastName | Last Name | nvarchar | 50 | 0 | | | | Allow NULL? |
| 3 | firstName | First Name | nvarchar | 50 | 0 | | | | Allow NULL? |
| 4 | middleName | Middle Name | nvarchar | 20 | 0 | | | | Allow NULL? |
| 5 | sex | Gender | char | 1 | 0 | | M | F=Female, M=Male | Allow NULL? |
| 6 | jobTitle | Job Title | nvarchar | 20 | 0 | | | | Allow NULL? |
| 7 | type | Employee Type | int | 11 | 0 | OHTY | | | Allow NULL? |
| 8 | dept | Department | int | 6 | 0 | OUDP | | | Allow NULL? |
| 9 | branch | Branch | int | 6 | 0 | OUBR | | | Allow NULL? |
| 10 | workStreet | Work Street | nvarchar | 100 | 0 | | | | Allow NULL? |
| 11 | workBlock | Work Block | nvarchar | 100 | 0 | | | | Allow NULL? |
| 12 | workZip | Work Zip Code | nvarchar | 20 | 0 | | | | Allow NULL? |
| 13 | workCity | Work City | nvarchar | 100 | 0 | | | | Allow NULL? |
| 14 | workCounty | Work County | nvarchar | 100 | 0 | | | | Allow NULL? |
| 15 | workCountr | Work Country | nvarchar | 3 | 0 | OCRY | | | Allow NULL? |
| 16 | workState | Work State | nvarchar | 3 | 0 | OCST | | | Allow NULL? |
| 17 | manager | Manager | int | 11 | 0 | OHEM | | | Allow NULL? |
| 18 | userId | User ID | int | 11 | 0 | OUSR | | | Allow NULL? |
| 19 | salesPrson | Sales Employee | int | 6 | 0 | OSLP | | | Allow NULL? |
| 20 | officeTel | Office Phone | nvarchar | 20 | 0 | | | | Allow NULL? |
| 21 | officeExt | Office Ext. | nvarchar | 20 | 0 | | | | Allow NULL? |
| 22 | mobile | Mobile Phone | nvarchar | 20 | 0 | | | | Allow NULL? |
| 23 | pager | Pager | nvarchar | 20 | 0 | | | | Allow NULL? |
| 24 | homeTel | Home Phone | nvarchar | 20 | 0 | | | | Allow NULL? |
| 25 | fax | Fax | nvarchar | 20 | 0 | | | | Allow NULL? |
| 26 | email | E-Mail | nvarchar | 100 | 0 | | | | Allow NULL? |
| 27 | startDate | Start Date | date | 8 | 0 | | | | |
| 28 | status | Status | int | 11 | 0 | OHST | | | Allow NULL? |
| 29 | salary | Salary | num | 19 | 6 | | | | Allow NULL? |
| 30 | salaryUnit | Salary Unit | char | 1 | 0 | | M | B=Bi-Weekly, D=Day, H=Hour, M=Month, S=Semi-Monthly, W=Week, Y=Year | Allow NULL? |
| 31 | emplCost | Employee Costs | num | 19 | 6 | | | | Allow NULL? |
| 32 | empCostUnt | Employee Cost Unit | char | 1 | 0 | | M | D=Day, H=Hour, M=Month, W=Week, Y=Year | Allow NULL? |
| 33 | termDate | Termination Date | date | 8 | 0 | | | | |
| 34 | termReason | Termination Reason | int | 11 | 0 | OHTR | | | Allow NULL? |
| 35 | bankCode | Bank Code | nvarchar | 30 | 0 | | | | Allow NULL? |
| 36 | bankBranch | Bank Branch | nvarchar | 100 | 0 | | | | Allow NULL? |
| 37 | bankBranNo | Bank Branch No. | nvarchar | 30 | 0 | | | | Allow NULL? |
| 38 | bankAcount | Bank Account | nvarchar | 100 | 0 | | | | Allow NULL? |
| 39 | homeStreet | Home Street | nvarchar | 100 | 0 | | | | Allow NULL? |
| 40 | homeBlock | Home Block | nvarchar | 100 | 0 | | | | Allow NULL? |
| 41 | homeZip | Home Zip Code | nvarchar | 20 | 0 | | | | Allow NULL? |
| 42 | homeCity | Home City | nvarchar | 100 | 0 | | | | Allow NULL? |
| 43 | homeCounty | Home County | nvarchar | 100 | 0 | | | | Allow NULL? |
| 44 | homeCountr | Home Country | nvarchar | 3 | 0 | OCRY | | | Allow NULL? |
| 45 | homeState | Home State | nvarchar | 3 | 0 | OCST | | | Allow NULL? |
| 46 | birthDate | Date of Birth | date | 8 | 0 | | | | |
| 47 | brthCountr | Country of Birth | nvarchar | 3 | 0 | OCRY | | | Allow NULL? |
| 48 | martStatus | Marital Status | char | 1 | 0 | | S | D=Divorced, M=Married, S=Single, W=Widowed | Allow NULL? |
| 49 | nChildren | No. of Children | int | 6 | 0 | | | | Allow NULL? |
| 50 | govID | ID issued by Authorities | nvarchar | 20 | 0 | | | | Allow NULL? |
| 51 | citizenshp | Citizenship | nvarchar | 3 | 0 | OCRY | | | Allow NULL? |
| 52 | passportNo | Passport No. | nvarchar | 20 | 0 | | | | Allow NULL? |
| 53 | passportEx | Passport Expiration Date | date | 8 | 0 | | | | |
| 54 | picture | Picture | nvarchar | 200 | 0 | | | | Allow NULL? |
| 55 | remark | Remarks | text | 16 | 0 | | | | |
| 56 | attachment | Attachments | text | 16 | 0 | | | | |
| 57 | salaryCurr | Salary Currency | nvarchar | 3 | 0 | | | | Allow NULL? |
| 58 | empCostCur | Employee Costs Currency | nvarchar | 3 | 0 | | | | Allow NULL? |
| 59 | WorkBuild | Work Building/Floor/Room | text | 16 | 0 | | | | |
| 60 | HomeBuild | Home Building/Floor/Room | text | 16 | 0 | | | | |
| 61 | position | Position | int | 11 | 0 | OHPS | | | Allow NULL? |
| 62 | AtcEntry | Attachment Entry | int | 11 | 0 | | | | Allow NULL? |
| 63 | AddrTypeW | Work Address Type | nvarchar | 100 | 0 | | | | Allow NULL? |
| 64 | AddrTypeH | Home Address Type | nvarchar | 100 | 0 | | | | Allow NULL? |
| 65 | StreetNoW | Work Street No. | nvarchar | 100 | 0 | | | | Allow NULL? |
| 66 | StreetNoH | Home Street No. | nvarchar | 100 | 0 | | | | Allow NULL? |
| 67 | DispMidNam | Display Middle Name | char | 1 | 0 | | N | N=No, Y=Yes | Allow NULL? |
| 68 | NamePos | Name Positioning Set | char | 1 | 0 | | 1 | 1=Last Name, First Name, 2=First Name, Last Name | Allow NULL? |
| 69 | DispComma | Display Comma | char | 1 | 0 | | N | N=No, Y=Yes | Allow NULL? |
| 70 | CostCenter | Cost Center | nvarchar | 8 | 0 | OPRC | | | Allow NULL? |
| 71 | CompanyNum | Company Number | nvarchar | 20 | 0 | | | | Allow NULL? |
| 72 | VacPreYear | Vacation: Previous Year | int | 11 | 0 | | | | Allow NULL? |
| 73 | VacCurYear | Vacation: Current Year | int | 11 | 0 | | | | Allow NULL? |
| 74 | MunKey | Municipality Key | nvarchar | 20 | 0 | | | | Allow NULL? |
| 75 | TaxClass | Tax Class | nvarchar | 2 | 0 | | 0 | 0, 1=Tax Class I, 2=Tax Class II, 3=Tax Class III, 4=Tax Class IV, 5=Tax Class V, 6=Tax Class VI | Allow NULL? |
| 76 | InTaxLiabi | Income Tax Liability | nvarchar | 2 | 0 | | 0 | 0, 1=On Tax Card, 2=Flat-Rate Tax, 3=Cross-Border Employee, 4=Not Liable | Allow NULL? |
| 77 | EmTaxCCode | Religion | nvarchar | 9 | 0 | | 0 | --=No Church Tax Liability, 0, AK=(AK) Old Catholic, EV=(EV) Protestant, FA=(FA) Non-Denomination Alzey, FB=(FB) Non-Denominational Regional Congregation Baden, FG=(FG) Non-Denominational Regional Congregation Palatinate, FM=(FM) Non-Denominational Congregation Mainz, FR=(FR) French-Reformed, FS=(FS) Non-Denominational Congregation Offenba | Allow NULL? |
| 78 | RelPartner | Religion of Partner | nvarchar | 9 | 0 | | 0 | --=No Church Tax Liability, 0, AK=(AK) Old Catholic, EV=(EV) Protestant, FA=(FA) Non-Denomination Alzey, FB=(FB) Non-Denominational Regional Congregation Baden, FG=(FG) Non-Denominational Regional Congregation Palatinate, FM=(FM) Non-Denominational Congregation Mainz, FR=(FR) French-Reformed, FS=(FS) Non-Denominational Congregation Offenba | Allow NULL? |
| 79 | ExemptAmnt | Exemption Amount | num | 19 | 6 | | | | Allow NULL? |
| 80 | ExemptUnit | Exemption Amount Period | nvarchar | 20 | 0 | | 0 | 0, 1=Yearly, 2=Monthly, 3=Weekly, 4=Daily | Allow NULL? |
| 81 | AddiAmnt | Additional Amount | num | 19 | 6 | | | | Allow NULL? |
| 82 | AddiUnit | Additional Amount Period | nvarchar | 20 | 0 | | 0 | 0, 1=Yearly, 2=Monthly, 3=Weekly, 4=Daily | Allow NULL? |
| 83 | TaxOName | Tax Office Name | nvarchar | 50 | 0 | | | | Allow NULL? |
| 84 | TaxONum | Tax Office Number | nvarchar | 20 | 0 | | | | Allow NULL? |
| 85 | HeaInsName | Health Insurance Company Name | nvarchar | 50 | 0 | | | | Allow NULL? |
| 86 | HeaInsCode | Health Insurance Code | nvarchar | 50 | 0 | | | | Allow NULL? |
| 87 | HeaInsType | Type of Health Insurance | nvarchar | 20 | 0 | | | , AOK=(AOK), BKK=(BKK), BKS=(BKS), EKK=(EKK), IKK=(IKK), LKK=(LKK) | Allow NULL? |
| 88 | SInsurNum | Social Insurance Number | nvarchar | 20 | 0 | | | | Allow NULL? |
| 89 | StatusOfP | Professional Status | nvarchar | 2 | 0 | | -1 | -1, 0=Trainee, 1=Worker, 2=Skilled Worker, 3=Supervisor/Foreman, 4=Office Worker, 5=Youth Help/Sheltered Workshop, 6=On Career Advancement Training, 7=Homeworker, 8=Part Time < 18 Hrs, 9=Part Time > 18 Hrs | Allow NULL? |
| 90 | StatusOfE | Educational Status | nvarchar | 2 | 0 | | 0 | 0, 1=W/o Professional Qualification, 2=W. Professional Qualification, 3=High School w/o Prof. Qualif., 4=High School w. Prof. Qualific., 5=Vocational Qualification, 6=University, 7=Not Possible to Specify | Allow NULL? |
| 91 | BCodeDateV | Bank Code for DATEV | nvarchar | 20 | 0 | | | | Allow NULL? |
| 92 | DevBAOwner | Deviating Bank Account Owner | char | 1 | 0 | | N | N=No, Y=Yes | Allow NULL? |
| 93 | FNameSP | First Name of Spouse | nvarchar | 50 | 0 | | | | Allow NULL? |
| 94 | SurnameSP | Last Name of Spouse | nvarchar | 50 | 0 | | | | Allow NULL? |
| 95 | LogInstanc | Log Instance | int | 11 | 0 | | 0 | | Allow NULL? |
| 96 | UserSign | User Signature | int | 6 | 0 | OUSR | | | Allow NULL? |
| 97 | UserSign2 | Updating User | int | 6 | 0 | OUSR | | | Allow NULL? |
| 98 | UpdateDate | Update Date | date | 8 | 0 | | | | |
| 99 | PersGroup | Person Group | nvarchar | 5 | 0 | | -1 | -1, 101=Subject to Social Insurance, 102=Apprentice, 104=Home Worker, 105=Trainee, 106=Student, 108=Early Retirement, 109=Part-Time Employee, 110=Short-Term Employee, 112=Family Member: Agriculture, 113=Addnl Income: Agriculture, 114=Addnl Income: Seasonal Agriculture, 116=Receiving Compensation Pay, 118=Irregularly Employed, 119=Pensioner | Allow NULL? |
| 100 | JTCode | Job Title Code | nvarchar | 5 | 0 | | | | Allow NULL? |
| 101 | ExtEmpNo | Ext. Employee No. | nvarchar | 20 | 0 | | | | Allow NULL? |
| 102 | BirthPlace | Place of Birth | nvarchar | 100 | 0 | | | | Allow NULL? |
| 103 | PymMeth | Payment Method | nvarchar | 2 | 0 | | 05 | -1, 05=Bank Transfer | Allow NULL? |
| 104 | ExemptCurr | Exemption Amount Currency | nvarchar | 3 | 0 | | | | Allow NULL? |
| 105 | AddiCurr | Additional Amount Currency | nvarchar | 3 | 0 | | | | Allow NULL? |
