| SysPK_Empl |
int(11)
|
|
|
|
| old_personId |
int(11)
|
|
|
|
| person_id |
int(11)
|
|
|
|
| status_update |
varchar(11)
|
latin1_swedish_ci
|
|
|
| priority |
int(11)
|
|
|
|
| AccountNo_Empl |
varchar(50)
|
latin1_swedish_ci
|
|
|
| Emp_no |
varchar(50)
|
latin1_swedish_ci
|
|
|
| trans_date |
date
|
|
|
|
| Name_Empl |
varchar(255)
|
latin1_swedish_ci
|
|
|
| FirstName_Empl |
varchar(50)
|
latin1_swedish_ci
|
|
|
| MiddleName_Empl |
varchar(50)
|
latin1_swedish_ci
|
|
|
| LastName_Empl |
varchar(50)
|
latin1_swedish_ci
|
|
|
| SuffixName_Empl |
varchar(50)
|
latin1_swedish_ci
|
|
|
| PrefixName_Empl |
varchar(255)
|
latin1_swedish_ci
|
|
|
| nickname |
varchar(255)
|
latin1_swedish_ci
|
|
|
| Address_Empl |
varchar(255)
|
latin1_swedish_ci
|
|
|
| empl_contactno |
varchar(100)
|
latin1_swedish_ci
|
|
|
| email_address |
varchar(100)
|
latin1_swedish_ci
|
|
|
| BirthDate_Empl |
date
|
|
|
|
| weight |
varchar(255)
|
latin1_swedish_ci
|
|
|
| height |
varchar(255)
|
latin1_swedish_ci
|
|
|
| gender |
varchar(255)
|
latin1_swedish_ci
|
|
|
| civilStatus |
varchar(255)
|
latin1_swedish_ci
|
|
|
| dependent |
tinyint(4)
|
|
|
|
| GSIS_Empl |
varchar(50)
|
latin1_swedish_ci
|
|
|
| SSS_Empl |
varchar(50)
|
latin1_swedish_ci
|
|
|
| TIN_Empl |
varchar(50)
|
latin1_swedish_ci
|
|
|
| philhealth_no |
varchar(255)
|
latin1_swedish_ci
|
|
|
| pagibig_no |
varchar(255)
|
latin1_swedish_ci
|
|
|
| with_atm |
varchar(100)
|
latin1_swedish_ci
|
|
|
| bankname_Empl |
varchar(250)
|
latin1_swedish_ci
|
|
|
| bankaccount_Empl |
varchar(100)
|
latin1_swedish_ci
|
|
|
| BloodType_Empl |
varchar(50)
|
latin1_swedish_ci
|
|
|
| EmergencyName_Empl |
varchar(255)
|
latin1_swedish_ci
|
|
|
| EmergencyAdd_Empl |
varchar(255)
|
latin1_swedish_ci
|
|
|
| EmergencyTelNo_Empl |
varchar(50)
|
latin1_swedish_ci
|
|
|
| Position_Empl |
varchar(100)
|
latin1_swedish_ci
|
|
|
| count |
varchar(50)
|
latin1_swedish_ci
|
|
|
| Department_Empl |
varchar(100)
|
latin1_swedish_ci
|
|
|
| shift_code |
varchar(20)
|
latin1_swedish_ci
|
|
|
| RateBasis |
varchar(50)
|
latin1_swedish_ci
|
|
|
| RatePerDay_Empls |
double
|
|
|
|
| BasicSalary_Empls |
double
|
|
|
|
| DateHired_Empl |
date
|
|
|
|
| DateEffectivity_Empl |
date
|
|
|
|
| DatTerminated_Empl |
varchar(30)
|
latin1_swedish_ci
|
|
|
| DateRetired |
date
|
|
|
|
| Status_Empl |
varchar(50)
|
latin1_swedish_ci
|
|
|
| Type_Empl |
varchar(50)
|
latin1_swedish_ci
|
|
|
| office_location |
varchar(20)
|
latin1_swedish_ci
|
|
|
| payroll_group |
varchar(20)
|
latin1_swedish_ci
|
|
|
| with_bio |
varchar(50)
|
latin1_swedish_ci
|
|
|
| with_contract |
varchar(20)
|
latin1_swedish_ci
|
|
|
| pertrip |
varchar(5)
|
latin1_swedish_ci
|
|
|
| title_id |
int(11)
|
|
|
|
| branch_id |
varchar(50)
|
latin1_swedish_ci
|
|
|
| time_stamp |
timestamp
|
|
|
|
| RHouse_No |
varchar(50)
|
latin1_swedish_ci
|
|
|
| RSubd_Village |
varchar(100)
|
latin1_swedish_ci
|
|
|
| RCity_Mun |
varchar(100)
|
latin1_swedish_ci
|
|
|
| RZipcode |
varchar(100)
|
latin1_swedish_ci
|
|
|
| RStreet |
varchar(100)
|
latin1_swedish_ci
|
|
|
| brgyid |
int(11)
|
|
|
|
| RBrgy |
varchar(100)
|
latin1_swedish_ci
|
|
|
| RProvince |
varchar(100)
|
latin1_swedish_ci
|
|
|
| PHouse_No |
varchar(100)
|
latin1_swedish_ci
|
|
|
| PSubd_Village |
varchar(100)
|
latin1_swedish_ci
|
|
|
| PCity_Mun |
varchar(100)
|
latin1_swedish_ci
|
|
|
| PZipcode |
varchar(100)
|
latin1_swedish_ci
|
|
|
| PStreet |
varchar(100)
|
latin1_swedish_ci
|
|
|
| PBrgy |
varchar(100)
|
latin1_swedish_ci
|
|
|
| PProvince |
varchar(100)
|
latin1_swedish_ci
|
|
|
| sal_grade_id |
int(11)
|
|
|
|
| recruitment_id |
int(11)
|
|
|
|
| birthplace |
varchar(255)
|
latin1_swedish_ci
|
|
|
| government_ID |
varchar(100)
|
latin1_swedish_ci
|
|
|
| ID_License_Passport |
varchar(100)
|
latin1_swedish_ci
|
|
|
| Date_Place_Issuance |
varchar(225)
|
latin1_swedish_ci
|
|
|
| privilege |
varchar(50)
|
latin1_swedish_ci
|
|
|
| Appoint_Status |
int(11)
|
|
|
|
| jo_group_no |
varchar(100)
|
latin1_swedish_ci
|
|
|
| with_pds |
varchar(50)
|
latin1_swedish_ci
|
|
|
| level |
varchar(100)
|
latin1_swedish_ci
|
|
|
| indigenous_group |
varchar(50)
|
latin1_swedish_ci
|
|
|
| person_disablity |
varchar(50)
|
latin1_swedish_ci
|
|
|
| solo_parent |
varchar(50)
|
latin1_swedish_ci
|
|
|
| bp_number |
varchar(225)
|
latin1_swedish_ci
|
|
|
| designate_dept |
int(11)
|
|
|
|
| designate_pos |
int(11)
|
|
|
|
| designate_count |
varchar(50)
|
latin1_swedish_ci
|
|
|
| item_no |
varchar(100)
|
latin1_swedish_ci
|
|
|
| authorized |
double
|
|
|
|
| date_promotion |
date
|
|
|
|
| level_csc |
varchar(50)
|
latin1_swedish_ci
|
|
|
| inactive_date |
date
|
|
|
|
| shift_type |
varchar(50)
|
latin1_swedish_ci
|
|
|
| payrollType |
varchar(50)
|
latin1_swedish_ci
|
|
|
| group_pm |
varchar(50)
|
latin1_swedish_ci
|
|
|
| lc_earn_start_date_casual |
date
|
|
|
|
| lc_earn_start_date |
date
|
|
|
|
| jo_wtax |
varchar(10)
|
latin1_swedish_ci
|
|
|
| citizen |
varchar(50)
|
latin1_swedish_ci
|
|
|
| agency_no |
varchar(50)
|
latin1_swedish_ci
|
|
|
| period_from |
date
|
|
|
|
| period_to |
date
|
|
|
|
| old_emp_id |
int(11)
|
|
|
|
| included |
int(1)
|
|
|
|
| compute_u_l |
varchar(10)
|
latin1_swedish_ci
|
|
|
| use_new_lv_ldger |
varchar(10)
|
latin1_swedish_ci
|
|
|
| is_email_otp |
varchar(10)
|
latin1_swedish_ci
|
|
|
