<taCreateEmployee>*
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.