|
Shows the staff information for the Intercorp. |
|
Name |
Code |
|
Name |
|
|
Code |
|
|
Data Type |
integer |
|
Mandatory |
Yes |
|
Shows the staff number. Every staff is given a unique number. This is also the primary key for the IntercorpStaffInfo table. |
|
Name |
|
|
Code |
|
|
Data Type |
char(40) |
|
Mandatory |
No |
|
Shows the name of the staff. |
|
Name |
|
|
Code |
|
|
Data Type |
char(20) |
|
Mandatory |
No |
|
Shows the type of residence document. |
|
Name |
|
|
Code |
|
|
Data Type |
char(20) |
|
Mandatory |
No |
|
Shows the residence document number. |
|
Name |
|
|
Code |
|
|
Data Type |
char(20) |
|
Mandatory |
No |
|
Shows the residence document valid duration, i.e. how long this document can be used. |
|
Name |
|
|
Code |
|
|
Data Type |
date |
|
Mandatory |
No |
|
Shows the expiry date of the residence document. |
|
Name |
|
|
Code |
|
|
Data Type |
char(20) |
|
Mandatory |
No |
|
Displays the employee number. |
|
Name |
|
|
Code |
|
|
Data Type |
char(20) |
|
Mandatory |
No |
|
Shows the social number. |
|
Name |
|
|
Code |
|
|
Data Type |
date |
|
Mandatory |
No |
|
Shows the expiry date for the social security number. |
|
Name |
|
|
Code |
|
|
Data Type |
char(20) |
|
Mandatory |
No |
|
Shows the nationality of the employee. |
|
Name |
|
|
Code |
|
|
Data Type |
char(20) |
|
Mandatory |
No |
|
Stores a description for the nationality. It can also be the full name. |
|
Name |
|
|
Code |
|
|
Data Type |
char(30) |
|
Mandatory |
No |
|
Shows the designation for the staff. |
|
Name |
|
|
Code |
|
|
Data Type |
char(40) |
|
Mandatory |
No |
|
Shows the department of the staff. |
|
Name |
|
|
Code |
|
|
Data Type |
char(40) |
|
Mandatory |
No |
|
Stores the description of the department. It can also be the full name. |
|
Name |
|
|
Code |
|
|
Data Type |
double |
|
Mandatory |
No |
|
Shows the hourly wage for the staff. |
|
Name |
|
|
Code |
|
|
Data Type |
date |
|
Mandatory |
No |
|
Shows the effective date for the new wage. |
|
Name |
|
|
Code |
|
|
Data Type |
double |
|
Mandatory |
No |
|
Shows the new hourly wage for the staff. |
|
Name |
|
|
Code |
|
|
Data Type |
timestamp |
|
Mandatory |
No |
|
Displays the timestamp of Sage EasyPay Enterprise. |
|
Name |
|
|
Code |
|
|
Data Type |
timestamp |
|
Mandatory |
No |
|
Shows the timestamp for the intercorp staff information. |
|
|
|