VLAMr3FH

1CREATE TABLE IF NOT EXISTS `hs_hr_document_placeholder` (
2  `machine_name` varchar(255) NOT NULL,
3  `alias_name` varchar(255) DEFAULT NULL,
4  `human_name` varchar(255) NOT NULL,
5  `data_type` smallint(1) NOT NULL COMMENT '1: Text , 2: Option, 3: Date, 4: Function',
6  `value_mapping` varchar(255) DEFAULT NULL COMMENT 'format: key1:value1,key2:value2,...,keyN:valueN'
7) ENGINE=InnoDB DEFAULT CHARSET=utf8;
8
9--
10-- Dumping data for table `hs_hr_document_placeholder`
11--
12
13INSERT INTO `hs_hr_document_placeholder` (`machine_name`, `alias_name`, `human_name`, `data_type`, `value_mapping`) VALUES
14('$employee->getFullName()', 'fullName', 'Full Name', 4, NULL),
15('$employee->getLatestContractEndDate()', 'contract_end', 'Contract End Date', 4, NULL),
16('$employee->getLatestContractStartDate()', 'contract_start', 'Contract Start Date', 4, NULL),
17('city', NULL, 'Address City', 1, NULL),
18('country', NULL, 'Address Country', 1, NULL),
19('employeeId', NULL, 'Employee ID', 1, NULL),
20('emp_birthday', NULL, 'Birthday', 3, NULL),
21('emp_bpjs_no', NULL, 'No. BPJS', 1, NULL),
22('emp_gender', NULL, 'Gender', 2, '1:Male,2:Female'),
23('emp_hm_telephone', NULL, 'Home Telephone', 1, NULL),
24('emp_marital_status', NULL, 'Marital Status', 1, NULL),
25('emp_mobile', NULL, 'Mobile', 1, NULL),
26('emp_zipcode', NULL, 'Address ZIP Code', 1, NULL),
27('firstName', NULL, 'First Name', 1, NULL),
28('lastName', NULL, 'Last Name', 1, NULL),
29('licenseNo', NULL, 'No. SIM', 1, NULL),
30('middleName', NULL, 'Middle Name', 1, NULL),
31('nickName', NULL, 'Nick Name', 1, NULL),
32('number_format($employee->getActiveBasicSalary())', 'salary_rate', 'Basic Salary', 4, NULL),
33('otherId', NULL, 'No. KTP', 1, NULL),
34('province', NULL, 'Address Province', 1, NULL),
35('street1', NULL, 'Address Street 1', 1, NULL),
36('street2', NULL, 'Address Street 2', 1, NULL);