| Field |
Description |
Type |
Size |
Related |
Default Value |
Constraints |
| empID |
Employee No. |
Int |
11 |
- |
|
|
|
| lastName |
Last Name |
nVarChar |
50 |
- |
|
|
|
| firstName |
First Name |
nVarChar |
50 |
- |
|
|
|
| middleName |
Middle Name |
nVarChar |
50 |
- |
|
|
|
| sex |
Gender |
VarChar |
1 |
- |
M |
F |
Female |
| |
|
|
|
|
|
M |
Male |
| |
|
|
|
|
|
E |
Not Specified |
| |
|
|
|
|
|
* |
Masked |
| |
|
|
|
|
|
I |
Not Valid for System |
| jobTitle |
Job Title |
nVarChar |
20 |
- |
|
|
|
| type |
Employee Type |
Int |
11 |
OHTY |
|
|
|
| dept |
Department |
Int |
6 |
OUDP |
|
|
|
| branch |
Branch |
Int |
6 |
OUBR |
|
|
|
| workStreet |
Work Street |
nVarChar |
100 |
- |
|
|
|
| workBlock |
Work Block |
nVarChar |
100 |
- |
|
|
|
| workZip |
Work Zip Code |
nVarChar |
20 |
- |
|
|
|
| workCity |
Work City |
nVarChar |
100 |
- |
|
|
|
| workCounty |
Work County |
nVarChar |
100 |
- |
|
|
|
| workCountr |
Work Country/Region |
nVarChar |
3 |
OCRY |
|
|
|
| workState |
Work State |
nVarChar |
3 |
OCST |
|
|
|
| manager |
Manager |
Int |
11 |
OHEM |
|
|
|
| userId |
User ID |
Int |
11 |
OUSR |
|
|
|
| salesPrson |
Sales Employee |
Int |
11 |
OSLP |
|
|
|
| officeTel |
Office Phone |
nVarChar |
50 |
- |
|
|
|
| officeExt |
Office Ext. |
nVarChar |
50 |
- |
|
|
|
| mobile |
Mobile Phone |
nVarChar |
50 |
- |
|
|
|
| pager |
Pager |
nVarChar |
50 |
- |
|
|
|
| homeTel |
Home Phone |
nVarChar |
50 |
- |
|
|
|
| fax |
Fax |
nVarChar |
50 |
- |
|
|
|
| email |
E-Mail |
nVarChar |
100 |
- |
|
|
|
| startDate |
Start Date |
Date |
8 |
- |
|
|
|
| status |
Status |
Int |
11 |
OHST |
|
|
|
| salary |
Salary |
Num |
19.6 |
- |
|
|
|
| salaryUnit |
Salary Unit |
VarChar |
1 |
- |
M |
H |
Hour |
| |
|
|
|
|
|
D |
Day |
| |
|
|
|
|
|
W |
Week |
| |
|
|
|
|
|
M |
Month |
| |
|
|
|
|
|
Y |
Year |
| |
|
|
|
|
|
S |
Semimonthly |
| |
|
|
|
|
|
B |
Biweekly |
| emplCost |
Employee Costs |
Num |
19.6 |
- |
|
|
|
| empCostUnt |
Employee Cost Unit |
VarChar |
1 |
- |
M |
H |
Hour |
| |
|
|
|
|
|
D |
Day |
| |
|
|
|
|
|
W |
Week |
| |
|
|
|
|
|
M |
Month |
| |
|
|
|
|
|
Y |
Year |
| termDate |
Termination Date |
Date |
8 |
- |
|
|
|
| termReason |
Termination Reason |
Int |
11 |
OHTR |
|
|
|
| bankCode |
Bank Code |
nVarChar |
30 |
ODSC |
|
|
|
| bankBranch |
Bank Branch |
nVarChar |
100 |
- |
|
|
|
| bankBranNo |
Bank Branch No. |
nVarChar |
30 |
- |
|
|
|
| bankAcount |
Bank Account |
nVarChar |
100 |
- |
|
|
|
| homeStreet |
Home Street |
nVarChar |
100 |
- |
|
|
|
| homeBlock |
Home Block |
nVarChar |
100 |
- |
|
|
|
| homeZip |
Home Zip Code |
nVarChar |
20 |
- |
|
|
|
| homeCity |
Home City |
nVarChar |
100 |
- |
|
|
|
| homeCounty |
Home County |
nVarChar |
100 |
- |
|
|
|
| homeCountr |
Home Country/Region |
nVarChar |
3 |
OCRY |
|
|
|
| homeState |
Home State |
nVarChar |
3 |
OCST |
|
|
|
| birthDate |
Date of Birth |
Date |
8 |
- |
|
|
|
| brthCountr |
Country/Region of Birth |
nVarChar |
3 |
OCRY |
|
|
|
| martStatus |
Marital Status |
VarChar |
1 |
- |
S |
S |
Single |
| |
|
|
|
|
|
M |
Married |
| |
|
|
|
|
|
D |
Divorced |
| |
|
|
|
|
|
W |
Widowed |
| |
|
|
|
|
|
N |
Not Specified |
| nChildren |
No. of Children |
Int |
6 |
- |
|
|
|
| govID |
ID Issued by Authorities |
nVarChar |
64 |
- |
|
|
|
| citizenshp |
Citizenship |
nVarChar |
3 |
OCRY |
|
|
|
| passportNo |
Passport No. |
nVarChar |
64 |
- |
|
|
|
| passportEx |
Passport Expiration Date |
Date |
8 |
- |
|
|
|
| picture |
Picture |
nVarChar |
200 |
- |
|
|
|
| remark |
Remarks |
Text |
16 |
- |
|
|
|
| attachment |
Attachments |
Text |
16 |
- |
|
|
|
| salaryCurr |
Salary Currency |
nVarChar |
3 |
- |
|
|
|
| empCostCur |
Employee Costs Currency |
nVarChar |
3 |
- |
|
|
|
| WorkBuild |
Work Building/Floor/Room |
Text |
16 |
- |
|
|
|
| HomeBuild |
Home Building/Floor/Room |
Text |
16 |
- |
|
|
|
| position |
Position |
Int |
11 |
OHPS |
|
|
|
| AtcEntry |
Attachment Entry |
Int |
11 |
- |
|
|
|
| AddrTypeW |
Work Address Type |
nVarChar |
100 |
- |
|
|
|
| AddrTypeH |
Home Address Type |
nVarChar |
100 |
- |
|
|
|
| StreetNoW |
Work Street No. |
nVarChar |
100 |
- |
|
|
|
| StreetNoH |
Home Street No. |
nVarChar |
100 |
- |
|
|
|
| DispMidNam |
Display Middle Name |
VarChar |
1 |
- |
N |
N |
No |
| |
|
|
|
|
|
Y |
Yes |
| NamePos |
Name Positioning Set |
VarChar |
1 |
- |
1 |
1 |
Last Name, First Name |
| |
|
|
|
|
|
2 |
First Name, Last Name |
| DispComma |
Display Comma |
VarChar |
1 |
- |
N |
N |
No |
| |
|
|
|
|
|
Y |
Yes |
| CostCenter |
Cost Center |
nVarChar |
8 |
OPRC |
|
|
|
| CompanyNum |
Company Number |
nVarChar |
20 |
- |
|
|
|
| VacPreYear |
Vacation: Previous Year |
Int |
11 |
- |
|
|
|
| VacCurYear |
Vacation: Current Year |
Int |
11 |
- |
|
|
|
| MunKey |
Municipality Key |
nVarChar |
20 |
- |
|
|
|
| TaxClass |
Tax Class |
nVarChar |
2 |
- |
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 |
| InTaxLiabi |
Income Tax Liability |
nVarChar |
2 |
- |
0 |
0 |
|
| |
|
|
|
|
|
1 |
On Tax Card |
| |
|
|
|
|
|
2 |
Flat-Rate Tax |
| |
|
|
|
|
|
3 |
Cross-Border Employee |
| |
|
|
|
|
|
4 |
Not Liable |
| EmTaxCCode |
Confession |
nVarChar |
9 |
- |
0 |
0 |
|
| |
|
|
|
|
|
-- |
No Church Tax Liability |
| |
|
|
|
|
|
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 Offenbach/Mainz |
| |
|
|
|
|
|
IB |
(IB) Israelite Religious Community Baden |
| |
|
|
|
|
|
IL |
(IL) Israelite Rural |
| |
|
|
|
|
|
IS |
(IS) Israelite |
| |
|
|
|
|
|
IW |
(IW) Israelite Religious Community Wuerttemberg |
| |
|
|
|
|
|
JD |
(JD) Jewish Religion Tax |
| |
|
|
|
|
|
JH |
(JH) Jewish Religion Tax |
| |
|
|
|
|
|
JS |
(JS) Jewish Religion Tax |
| |
|
|
|
|
|
LT |
(LT) Lutheran |
| |
|
|
|
|
|
RF |
(RF) Reformed |
| |
|
|
|
|
|
RK |
(RK) Roman Catholic |
| RelPartner |
Confession of Partner |
nVarChar |
9 |
- |
0 |
0 |
|
| |
|
|
|
|
|
-- |
No Church Tax Liability |
| |
|
|
|
|
|
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 Offenbach/Mainz |
| |
|
|
|
|
|
IB |
(IB) Israelite Religious Community Baden |
| |
|
|
|
|
|
IL |
(IL) Israelite Rural |
| |
|
|
|
|
|
IS |
(IS) Israelite |
| |
|
|
|
|
|
IW |
(IW) Israelite Religious Community Wuerttemberg |
| |
|
|
|
|
|
JD |
(JD) Jewish Religion Tax |
| |
|
|
|
|
|
JH |
(JH) Jewish Religion Tax |
| |
|
|
|
|
|
JS |
(JS) Jewish Religion Tax |
| |
|
|
|
|
|
LT |
(LT) Lutheran |
| |
|
|
|
|
|
RF |
(RF) Reformed |
| |
|
|
|
|
|
RK |
(RK) Roman Catholic |
| ExemptAmnt |
Exemption Amount |
Num |
19.6 |
- |
|
|
|
| ExemptUnit |
Exemption Amount Period |
nVarChar |
20 |
- |
0 |
0 |
|
| |
|
|
|
|
|
1 |
Yearly |
| |
|
|
|
|
|
2 |
Monthly |
| |
|
|
|
|
|
3 |
Weekly |
| |
|
|
|
|
|
4 |
Daily |
| AddiAmnt |
Additional Amount |
Num |
19.6 |
- |
|
|
|
| AddiUnit |
Additional Amount Period |
nVarChar |
20 |
- |
0 |
0 |
|
| |
|
|
|
|
|
1 |
Yearly |
| |
|
|
|
|
|
2 |
Monthly |
| |
|
|
|
|
|
3 |
Weekly |
| |
|
|
|
|
|
4 |
Daily |
| TaxOName |
Tax Office Name |
nVarChar |
50 |
- |
|
|
|
| TaxONum |
Tax Office Number |
nVarChar |
20 |
- |
|
|
|
| HeaInsName |
Health Insurance Company Name |
nVarChar |
50 |
- |
|
|
|
| HeaInsCode |
Health Insurance Code |
nVarChar |
50 |
- |
|
|
|
| HeaInsType |
Type of Health Insurance |
nVarChar |
20 |
- |
' ' |
' ' |
|
| |
|
|
|
|
|
AOK |
(AOK) |
| |
|
|
|
|
|
IKK |
(IKK) |
| |
|
|
|
|
|
EKK |
(EKK) |
| |
|
|
|
|
|
BKK |
(BKK) |
| |
|
|
|
|
|
BKS |
(BKS) |
| |
|
|
|
|
|
LKK |
(LKK) |
| SInsurNum |
Social Insurance Number |
nVarChar |
20 |
- |
|
|
|
| StatusOfP |
Professional Status |
nVarChar |
2 |
- |
-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 |
| StatusOfE |
Educational Status |
nVarChar |
2 |
- |
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 |
| BCodeDateV |
Bank Code for DATEV |
nVarChar |
20 |
- |
|
|
|
| DevBAOwner |
Deviating Bank Account Owner |
VarChar |
1 |
- |
N |
Y |
Yes |
| |
|
|
|
|
|
N |
No |
| FNameSP |
First Name of Spouse |
nVarChar |
50 |
- |
|
|
|
| SurnameSP |
Last Name of Spouse |
nVarChar |
50 |
- |
|
|
|
| LogInstanc |
Log Instance |
Int |
11 |
- |
0 |
|
|
| UserSign |
User Signature |
Int |
6 |
OUSR |
|
|
|
| UserSign2 |
Updating User |
Int |
6 |
OUSR |
|
|
|
| UpdateDate |
Update Date |
Date |
8 |
- |
|
|
|
| PersGroup |
Person Group |
nVarChar |
5 |
- |
-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 |
| |
|
|
|
|
|
997 |
Not Specified |
| JTCode |
Job Title Code |
nVarChar |
5 |
- |
|
|
|
| ExtEmpNo |
Ext. Employee No. |
nVarChar |
20 |
- |
|
|
|
| BirthPlace |
Place of Birth |
nVarChar |
100 |
- |
|
|
|
| PymMeth |
Payment Method |
nVarChar |
2 |
- |
05 |
-1 |
|
| |
|
|
|
|
|
05 |
Bank Transfer |
| ExemptCurr |
Exemption Amount Currency |
nVarChar |
3 |
- |
|
|
|
| AddiCurr |
Additional Amount Currency |
nVarChar |
3 |
- |
|
|
|
| STDCode |
STD Code |
Int |
11 |
- |
|
|
|
| FatherName |
Father's Name |
nVarChar |
150 |
- |
|
|
|
| CPF |
Personal Fiscal ID |
nVarChar |
100 |
- |
|
|
|
| CRC |
CRC Number |
nVarChar |
20 |
- |
|
|
|
| ContResp |
Accountant Responsible |
VarChar |
1 |
- |
N |
Y |
Yes |
| |
|
|
|
|
|
N |
No |
| RepLegal |
Legal Representative |
VarChar |
1 |
- |
N |
Y |
Yes |
| |
|
|
|
|
|
N |
No |
| DirfDeclar |
DIRF Responsible |
VarChar |
1 |
- |
N |
Y |
Yes |
| |
|
|
|
|
|
N |
No |
| UF_CRC |
CRC State |
nVarChar |
3 |
OCST |
|
|
|
| IDType |
ID Type |
nVarChar |
30 |
OIDT |
|
|
|
| Active |
Employee Status |
VarChar |
1 |
- |
Y |
Y |
Active |
| |
|
|
|
|
|
N |
Inactive |
| BPLId |
Branch |
Int |
11 |
OBPL |
|
|
|
| ManualNUM |
Manual EMP No. |
nVarChar |
60 |
- |
|
|
|
| PassIssue |
Passport Issue Date |
Date |
8 |
- |
|
|
|
| PassIssuer |
Passport Issuer |
nVarChar |
254 |
- |
|
|
|
| QualCode |
Qualification Code |
nVarChar |
3 |
- |
000 |
000 |
n/a |
| |
|
|
|
|
|
203 |
Diretor |
| |
|
|
|
|
|
204 |
Conselheiro de Administra��o |
| |
|
|
|
|
|
205 |
Administrador |
| |
|
|
|
|
|
206 |
Administrador do Grupo |
| |
|
|
|
|
|
207 |
Administrador de Sociedade Filiada |
| |
|
|
|
|
|
220 |
Administrador Judicial - Pessoa Fisica |
| |
|
|
|
|
|
222 |
Administrador Judicial - Pessoa Juridica - profissional respons�vel |
| |
|
|
|
|
|
223 |
Administrador Judicial / Gestor |
| |
|
|
|
|
|
226 |
Gestor Judicial |
| |
|
|
|
|
|
309 |
Procurador |
| |
|
|
|
|
|
312 |
Inventariante |
| |
|
|
|
|
|
313 |
Liquidante |
| |
|
|
|
|
|
315 |
Interventor |
| |
|
|
|
|
|
801 |
Empres�rio |
| |
|
|
|
|
|
900 |
Contador |
| |
|
|
|
|
|
999 |
Outros |
| PRWebAccss |
Enable Access to PR from Web |
VarChar |
1 |
- |
N |
Y |
Yes |
| |
|
|
|
|
|
N |
No |
| PrePRWeb |
Previous Stats of PR Web Access |
VarChar |
1 |
- |
N |
Y |
Yes |
| |
|
|
|
|
|
N |
No |
| BPLink |
BP Link |
nVarChar |
15 |
OCRD |
|
|
|
| NaturalPer |
Natural Person |
VarChar |
1 |
- |
N |
N |
No |
| |
|
|
|
|
|
Y |
Yes |
| DPPStatus |
Data Protection Status |
VarChar |
1 |
- |
N |
N |
None |
| |
|
|
|
|
|
D |
Erased |
| |
|
|
|
|
|
B |
Blocked |
| |
|
|
|
|
|
U |
Unblocked |
| EnRligion |
Encryption of Religion |
Text |
16 |
- |
|
|
|
| EnRligionP |
Encryption of Religion Partner |
Text |
16 |
- |
|
|
|
| EncryptIV |
Encrypt IV |
nVarChar |
100 |
- |
|
|
|
| EnGovID |
Encryption of Government ID |
Text |
16 |
- |
|
|
|
| EnPassport |
Encryption of Passport No. |
Text |
16 |
- |
|
|
|
| CreateDate |
Creation Date |
Date |
8 |
- |
|
|
|
| CreateTS |
Creation Time Incl. Sec. |
Int |
11 |
- |
|
|
|
| UpdateTS |
Update Full Time |
Int |
11 |
- |
|
|
|
| EnInsurNum |
Encryption of Social Insurance No. |
Text |
16 |
- |
|
|
|
| EnBnkAcct |
Encryption of Bank Account |
Text |
16 |
- |
|
|
|
| Code |
Employee Code |
nVarChar |
50 |
- |
|
|
|
| ARetSEFAZ |
Authorization to Retrieve NFe from SEFAZ |
VarChar |
1 |
- |
N |
N |
No |
| |
|
|
|
|
|
Y |
Yes |
| DataSource |
Data Source |
VarChar |
1 |
- |
N |
N |
Unknown |
| |
|
|
|
|
|
I |
Interface |
| |
|
|
|
|
|
U |
Update |
| |
|
|
|
|
|
M |
Import |
| |
|
|
|
|
|
O |
DI API |
| |
|
|
|
|
|
S |
Service Layer |
| |
|
|
|
|
|
W |
Web Client |
| |
|
|
|
|
|
A |
Doc. Generation Wizard |
| |
|
|
|
|
|
D |
Restore Wizard |
| |
|
|
|
|
|
P |
Partner Implementation |
| |
|
|
|
|
|
T |
Year Transfer |
| |
|
|
|
|
|
G |
Fixed Assets Migration |
| EnSex |
Encryption of Sex |
Text |
16 |
- |
|
|
|
| SexEx |
Gender |
nVarChar |
15 |
OGDR |
M |
|
|
| EnSexEx |
Encryption of SexEx |
Text |
16 |
- |
|
|
|