Hinweis
Für den Zugriff auf diese Seite ist eine Autorisierung erforderlich. Sie können versuchen, sich anzumelden oder das Verzeichnis zu wechseln.
Für den Zugriff auf diese Seite ist eine Autorisierung erforderlich. Sie können versuchen, das Verzeichnis zu wechseln.
Element name |
Data type |
Length |
Required |
Default |
Description |
|---|---|---|---|---|---|
EMPLOYID |
string |
15 |
Y |
Not applicable |
Employee ID |
EMPLCLAS |
string |
15 |
N |
<blank> |
Employee class |
INACTIVE |
i4 |
1 |
N |
0 |
Inactive: 0=False; 1=True |
LASTNAME |
string |
20 |
Y |
Not applicable |
Last name |
FRSTNAME |
string |
15 |
Y |
Not applicable |
First name |
MIDLNAME |
string |
15 |
N |
<blank> |
Middle name |
EMPLSUFF |
string |
4 |
N |
<blank> |
Employee suffix |
ADRSCODE |
string |
15 |
N |
<blank> |
Address code |
ADDRESS1 |
string |
30 |
N |
<blank> |
Address code 1 |
ADDRESS2 |
string |
30 |
N |
<blank> |
Address code 2 |
ADDRESS3 |
string |
30 |
N |
<blank> |
Address code 3 |
CITY |
string |
30 |
N |
<blank> |
City |
STATE |
string |
29 |
N |
<blank> |
State |
ZIPCODE |
string |
10 |
N |
<blank> |
ZIP Code |
COUNTY |
string |
20 |
N |
<blank> |
County |
COUNTRY |
string |
20 |
N |
<blank> |
Country |
PHONE1 |
string |
21 |
N |
<blank> |
Phone number 1 |
PHONE2 |
string |
21 |
N |
<blank> |
Phone number 2 |
PHONE3 |
string |
21 |
N |
<blank> |
Phone number 3 |
FAX |
string |
21 |
N |
<blank> |
Fax number |
SOCSCNUM |
string |
15 |
Y |
Not applicable |
Social Security number |
BRTHDATE |
datetime |
8 bytes (19 to 23 chars) |
N |
<blank> |
Birth date |
GENDER |
i4 |
2 |
N |
3 |
Gender: 1=Male; 2=Female; 3=Not applicable |
ETHNORGN |
i4 |
2 |
N |
7 |
Ethnic origin: 1=White; 2=Native American or Alaskan Native; 3=Black or African American; 4=Asian; 5=Hispanic or Latino; 6=Two or more races; 7=Not applicable; 8=Native Hawaiian or Pacific Islander |
Calc_Min_Wage_Bal |
i4 |
1 |
N |
Default from setup |
Calculate minimum wage balance: 0=False; 1=True |
DIVISIONCODE_I |
string |
6 |
N |
<blank> |
Division code; HR option only |
DEPRTMNT |
string |
6 |
Y |
Not applicable |
Department |
JOBTITLE |
string |
6 |
Y |
Not applicable |
Job title/position |
SUPERVISORCODE_I |
string |
6 |
N |
<blank> |
Supervisor Code |
LOCATNID |
string |
15 |
N |
<blank> |
Location ID |
WCACFPAY |
i4 |
2 |
N |
0 |
Cash account from: 0=Checkbook; 1=Employee |
AccountNumber |
string |
75 |
N |
<blank> |
Account number |
WKHRPRYR |
i4 |
2 |
N |
0 |
Work hours per year |
STRTDATE |
datetime |
8 bytes (19 to 23 chars) |
N |
<blank> |
Start date |
DEMPINAC |
datetime |
8 bytes (19 to 23 chars) |
N |
<blank> |
Date employee inactivated; this field is active if INACTIVE=1 |
RSNEMPIN |
string |
30 |
N |
<blank> |
Reason employee inactivated; this field is active if INACTIVE=1 |
MINETPAY |
number |
21 |
N |
Default from setup |
Minimum net pay |
SUTASTAT |
string |
2 |
N |
<blank> |
SUTA state |
WRKRCOMP |
string |
6 |
N |
<blank> |
Workers' compensation code |
ATACRVAC |
i4 |
1 |
N |
Default from setup |
Auto accrue vacation: 0=False; 1=True |
VACCRAMT |
number |
21 |
N |
Default from setup |
Vacation accrual amount |
VACCRMTH |
i4 |
2 |
N |
Default from setup |
Vacation accrual method: 0=Hours worked; 1=Set hours |
VACAPRYR |
number |
21 |
N |
Default from setup |
Vacation hours per year |
VACAVLBL |
number |
21 |
N |
Default from setup |
Vacation available |
WRNVCNFLSBLWZR |
i4 |
1 |
N |
Default from setup |
Warn if vacation falls below zero: 0=False; 1=True |
ATACRSTM |
i4 |
1 |
N |
<blank> |
Auto accrue sick time: 0=False 1=True |
STMACMTH |
i4 |
2 |
N |
0 |
Sick Time Accrual Method: 0=Hours worked 1=Set hours |
SKTMACAM |
number |
21 |
N |
<blank> |
Sick time accrual amount |
SIKTIMAV |
number |
21 |
N |
<blank> |
Sick time available |
SKTMHPYR |
number |
21 |
N |
<blank> |
Sick time hours per year |
WRNSTFLSBLWZR |
i4 |
1 |
N |
<blank> |
Warn sick time falls below zero 0=False 1=True |
USERDEF1 |
string |
20 |
N |
<blank> |
User defined 1 |
USERDEF2 |
string |
20 |
N |
<blank> |
User defined 2 |
EMPLOYMENTTYPE |
i4 |
2 |
N |
Default from setup |
Type of employment: 1=Full-time regular; 2=Full-time temporary; 3=Part-time regular; 4=Part-time temporary; 5=Intern; 6=Other |
MARITALSTATUS |
i4 |
2 |
N |
3 |
Marital status: 1=Married; 2=Single; 3=Not applicable |
BENADJDATE |
datetime |
8 bytes (19 to 23 chars) |
N |
<blank> |
Benefit adjustment date |
LASTDAYWORKED_I |
datetime |
8 bytes (19 to 23 chars) |
N |
<blank> |
Last day worked |
BIRTHDAY |
i4 |
2 |
N |
0 |
Birthday |
BIRTHMONTH |
i4 |
2 |
N |
0 |
Birth month: 1=January; 2=February; 3=March; 4=April; 5=May; 6=June; 7=July; 8=August; 9=September; 10=October; 11=November; 12=December |
SPOUSE |
string |
15 |
N |
<blank> |
Spouse |
SPOUSESSN |
string |
15 |
N |
<blank> |
Spouse Social Security number |
NICKNAME |
string |
20 |
N |
<blank> |
Nickname |
ALTERNATENAME |
string |
20 |
N |
<blank> |
Alternate name |
STATUSCD |
string |
15 |
N |
<blank> |
Status code |
HRSTATUS |
i4 |
2 |
N |
1 |
HR Status; HR option only: 1=Active; 2=Family leave; 3=Leave of absence; 4=Maternity; 5=Retired; 6=Separated; 7=Suspended; 8=Terminated; 9=Other |
DATEOFLASTREVIEW_I |
datetime |
8 bytes (19 to 23 chars) |
N |
<blank> |
Date of last review; HR option only |
DATEOFNEXTREVIEW_I |
datetime |
8 bytes (19 to 23 chars) |
N |
<blank> |
Date of next review; HR option only |
BENEFITEXPIRE_I |
datetime |
8 bytes (19 to 23 chars) |
N |
<blank> |
Benefit expire |
HANDICAPPED |
i4 |
1 |
N |
0 |
Handicapped; HR option only: 0=False; 1=True |
VETERAN |
i4 |
1 |
N |
0 |
Veteran; HR option only: 0=False; 1=True |
VIETNAMVETERAN |
i4 |
1 |
N |
0 |
Vietnam veteran; HR option only: 0=False; 1=True |
DISABLEDVETERAN |
i4 |
1 |
N |
0 |
Disabled veteran; HR option only: 0=False; 1=True |
UNIONEMPLOYEE |
i4 |
1 |
N |
0 |
Union employee; HR option only: 0=False; 1=True |
SMOKER_I |
i4 |
1 |
N |
0 |
Smoker; HR option only: 0=False; 1=True |
CITIZEN |
i4 |
1 |
N |
0 |
Citizen; HR option only: 0=False; 1=True |
VERIFIED |
i4 |
1 |
N |
0 |
Verified; HR option only: 0=False; 1=True |
I9RENEW |
datetime |
8 bytes (19 to 23 chars) |
N |
<blank> |
I9 renew; HR option only |
Primary_Pay_Record |
string |
6 |
N |
<blank> |
Primary pay record; HR option only |
CHANGEBY_I |
string |
15 |
N |
<blank> |
Change by; HR option only |
CHANGEDATE_I |
datetime |
8 bytes (19 to 23 chars) |
N |
<blank> |
Change date; HR option only |
UNIONCD |
string |
6 |
N |
<blank> |
Union code; HR option only |
RATECLSS |
string |
15 |
N |
<blank> |
Rate class; HR option only |
FEDCLSSCD |
string |
10 |
N |
<blank> |
Federal class; HR option only |
OTHERVET |
i4 |
1 |
N |
0 |
Other veterans; HR option only |
Military_Discharge_Date |
datetime |
8 bytes (19 to 23 chars) |
N |
<blank> |
Military discharge date; HR option only |
DefaultFromClass |
i4 |
1 |
N |
1 |
Default information from class: 0=False; 1=True |
UpdateIfExists |
i4 |
1 |
N |
1 |
Flag to allow customer data to be updated if it exists: 0=No; 1=Yes |
RequesterTrx |
i4 |
2 |
N |
0 |
Requester transaction 0=False; 1=True (if True, it populates the requester shadow table) |
USRDEFND1 |
string |
50 |
N |
<blank> |
User-defined field--developer use only |
USRDEFND2 |
string |
50 |
N |
<blank> |
User-defined field--developer use only |
USRDEFND3 |
string |
50 |
N |
<blank> |
User-defined field--developer use only |
USRDEFND4 |
string |
8000 |
N |
<blank> |
User-defined field--developer use only |
USRDEFND5 |
string |
8000 |
N |
<blank> |
User-defined field--developer use only |
USERID |
string |
15 |
N |
<blank> |
GP user ID |
* The <taCreateEmployee> node uses field level updates to provide update functionality.