EmployeeDetails
Generated schema file.
Columns
| Name | Type | References | |
| Id [KEY] | Integer |
Employees.Id | |
| TargetDate | Date | ||
| CompanyId | Integer | ||
| Num | String | ||
| DisplayName | String | ||
| BasePensionNum | String | ||
| EmploymentInsuranceReferenceNumber | String | ||
| BirthDate | Datetime | ||
| EntryDate | Datetime | ||
| RetireDate | Datetime | ||
| UserId | Integer | ||
| ProfileRuleId | Integer | ||
| ProfileRuleCompanyId | Integer | ||
| ProfileRuleEmployeeId | Integer | ||
| ProfileRuleLastName | String | ||
| ProfileRuleFirstName | String | ||
| ProfileRuleLastNameKana | String | ||
| ProfileRuleFirstNameKana | String | ||
| ProfileRuleZipcode1 | String | ||
| ProfileRuleZipcode2 | String | ||
| ProfileRulePref | String | ||
| ProfileRuleAddress | String | ||
| ProfileRuleAddressKana | String | ||
| ProfileRulePhone1 | String | ||
| ProfileRulePhone2 | String | ||
| ProfileRulePhone3 | String | ||
| ProfileRuleResidentialZipcode1 | String | ||
| ProfileRuleResidentialZipcode2 | String | ||
| ProfileRuleResidentialPref | String | ||
| ProfileRuleResidentialAddress | String | ||
| ProfileRuleResidentialAddressKana | String | ||
| ProfileRuleEmploymentType | String | ||
| ProfileRuleTitle | String | ||
| ProfileRuleGender | Integer | ||
| ProfileRuleMarried | Boolean | ||
| ProfileRuleIsWorkingStudent | Boolean | ||
| ProfileRuleWidowType | String | ||
| ProfileRuleDisabilityType | String | ||
| HealthInsuranceRuleId | Integer | ||
| HealthInsuranceRuleCompanyId | Integer | ||
| HealthInsuranceRuleEmployeeId | Integer | ||
| HealthInsuranceRuleEntried | Boolean | ||
| HealthInsuranceRuleReferenceNum | String | ||
| HealthInsuranceRuleStandardMonthlyRemuneration | Integer | ||
| WelfarePensionInsuranceRuleId | Integer | ||
| WelfarePensionInsuranceRuleCompanyId | Integer | ||
| WelfarePensionInsuranceRuleEmployeeId | Integer | ||
| WelfarePensionInsuranceRuleEntried | Boolean | ||
| WelfarePensionInsuranceRuleReferenceNum | String | ||
| WelfarePensionInsuranceRuleStandardMonthlyRemuneration | Integer | ||
| DependentRules | String | ||
| BankAccountRuleId | Integer | ||
| BankAccountRuleCompanyId | Integer | ||
| BankAccountRuleEmployeeId | Integer | ||
| BankAccountRuleBankName | String | ||
| BankAccountRuleBankNameKana | String | ||
| BankAccountRuleBankCode | String | ||
| BankAccountRuleBranchName | String | ||
| BankAccountRuleBranchNameKana | String | ||
| BankAccountRuleBranchCode | String | ||
| BankAccountRuleAccountNumber | String | ||
| BankAccountRuleAccountName | String | ||
| BankAccountRuleAccountType | String | ||
| BasicPayRuleId | Integer | ||
| BasicPayRuleCompanyId | Integer | ||
| BasicPayRuleEmployeeId | Integer | ||
| BasicPayRulePayCalcType | String | ||
| BasicPayRulePayAmount | Integer |