Constants

12129

Overview of Constants

_constant Structure

CREATE TABLE `_constant` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `constantKey` varchar(255)  DEFAULT NULL,
  `constantType` varchar(255)  DEFAULT NULL COMMENT 'Type of constant; object, array',
  `desc` varchar(255)  DEFAULT NULL COMMENT 'Description',
  `constantValue` text  COMMENT 'Content of the constant; object, array',
  `operation` varchar(255)  DEFAULT 'insert' COMMENT 'Operation; insert, update, jhInsert, jhUpdate, jhDelete, jhRestore',
  `operationByUserId` varchar(255)  DEFAULT NULL COMMENT 'User ID of the operator',
  `operationByUser` varchar(255)  DEFAULT NULL COMMENT 'Username of the operator',
  `operationAt` varchar(255)  DEFAULT NULL COMMENT 'Operation time; E.g: 2021-05-28T10:24:54+08:00 ',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 4 DEFAULT CHARSET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = 'Constant table; soft delete not enabled;'

Data in _constant Table

Salary Items

constantKey constantType
salaryOption array
[
  {
    "optionId": "1161",
    "code": 10,
    "parentCode": 0,
    "name": "Basic Salary",
    "remarks": null,
    "isFixed": 0,
    "isPlus": 1,
    "isTax": 1,
    "isShow": 1,
    "isCompute": 1,
    "isOpen": 1
  },
  {
    "optionId": "1165",
    "code": 20,
    "parentCode": 0,
    "name": "Subsidy",
    "remarks": "Benefits provided by the company to employees",
    "isFixed": 0,
    "isPlus": 1,
    "isTax": 1,
    "isShow": 1,
    "isCompute": 1,
    "isOpen": 1
  },
  {
    "optionId": "1170",
    "code": 30,
    "parentCode": 0,
    "name": "Variable Salary",
    "remarks": "Variable salary needs to be manually entered before monthly payroll calculation",
    "isFixed": 0,
    "isPlus": 1,
    "isTax": 1,
    "isShow": 1,
    "isCompute": 1,
    "isOpen": 1
  },
  {
    "optionId": "1172",
    "code": 40,
    "parentCode": 0,
    "name": "Bonus",
    "remarks": null,
    "isFixed": 0,
    "isPlus": 1,
    "isTax": 1,
    "isShow": 1,
    "isCompute": 1,
    "isOpen": 1
  },
  {
    "optionId": "1176",
    "code": 50,
    "parentCode": 0,
    "name": "Commission Salary",
    "remarks": null,
    "isFixed": 0,
    "isPlus": 1,
    "isTax": 1,
    "isShow": 1,
    "isCompute": 1,
    "isOpen": 1
  },
  {
    "optionId": "1178",
    "code": 60,
    "parentCode": 0,
    "name": "Piece Rate Salary",
    "remarks": null,
    "isFixed": 0,
    "isPlus": 1,
    "isTax": 1,
    "isShow": 1,
    "isCompute": 1,
    "isOpen": 1
  },
  {
    "optionId": "1180",
    "code": 70,
    "parentCode": 0,
    "name": "Hourly Wage",
    "remarks": null,
    "isFixed": 0,
    "isPlus": 1,
    "isTax": 1,
    "isShow": 1,
    "isCompute": 1,
    "isOpen": 1
  },
  {
    "optionId": "1182",
    "code": 80,
    "parentCode": 0,
    "name": "Seniority Salary",
    "remarks": null,
    "isFixed": 0,
    "isPlus": 1,
    "isTax": 1,
    "isShow": 1,
    "isCompute": 1,
    "isOpen": 1
  },
  {
    "optionId": "1185",
    "code": 90,
    "parentCode": 0,
    "name": "Title Salary",
    "remarks": null,
    "isFixed": 0,
    "isPlus": 1,
    "isTax": 1,
    "isShow": 1,
    "isCompute": 1,
    "isOpen": 1
  },
  {
    "optionId": "1189",
    "code": 100,
    "parentCode": 0,
    "name": "Withholding",
    "remarks": "Expenses paid by the company on behalf of individuals, such as personal social security and housing fund. Items under this category will be deducted from taxable income, affecting individual tax calculation",
    "isFixed": 0,
    "isPlus": 0,
    "isTax": 1,
    "isShow": 1,
    "isCompute": 1,
    "isOpen": 1
  },
  {
    "optionId": "1192",
    "code": 110,
    "parentCode": 0,
    "name": "Corporate Social Security",
    "remarks": "Items under this category do not participate in salary calculation, only involved in corporate cost statistics or social security cost analysis",
    "isFixed": 0,
    "isPlus": 1,
    "isTax": 0,
    "isShow": 1,
    "isCompute": 0,
    "isOpen": 1
  },
  {
    "optionId": "1194",
    "code": 120,
    "parentCode": 0,
    "name": "Corporate Housing Fund",
    "remarks": "Items under this category do not participate in salary calculation, only involved in corporate cost statistics or social security cost analysis",
    "isFixed": 0,
    "isPlus": 1,
    "isTax": 0,
    "isShow": 1,
    "isCompute": 0,
    "isOpen": 1
  },
  {
    "optionId": "1196",
    "code": 130,
    "parentCode": 0,
    "name": "Pre-tax Reissue",
    "remarks": "Pre-tax reissue, paid together with the salary of that month, needs to be included in tax calculation",
    "isFixed": 0,
    "isPlus": 1,
    "isTax": 0,
    "isShow": 1,
    "isCompute": 1,
    "isOpen": 1
  },
  {
    "optionId": "1198",
    "code": 140,
    "parentCode": 0,
    "name": "Pre-tax Deduction",
    "remarks": "Amounts deducted from the salary of that month before tax, which will affect the total taxable salary for the month",
    "isFixed": 0,
    "isPlus": 0,
    "isTax": 0,
    "isShow": 1,
    "isCompute": 1,
    "isOpen": 1
  },
  {
    "optionId": "1200",
    "code": 150,
    "parentCode": 0,
    "name": "Post-tax Reissue",
    "remarks": "Post-tax reissue, does not participate in salary calculation for that month, will affect the actual income for the month",
    "isFixed": 0,
    "isPlus": 1,
    "isTax": 0,
    "isShow": 1,
    "isCompute": 1,
    "isOpen": 1
  },
  {
    "optionId": "1202",
    "code": 160,
    "parentCode": 0,
    "name": "Post-tax Deduction",
    "remarks": "Amounts deducted from post-tax salary, do not participate in tax calculation for that month's salary",
    "isFixed": 0,
    "isPlus": 0,
    "isTax": 0,
    "isShow": 1,
    "isCompute": 1,
    "isOpen": 1
  },
  {
    "optionId": "1206",
    "code": 170,
    "parentCode": 0,
    "name": "Special Tax Items",
    "remarks": "Other subjects that do not participate in salary calculation, but need to be taxed",
    "isFixed": 0,
    "isPlus": 1,
    "isTax": 1,
    "isShow": 1,
    "isCompute": 1,
    "isOpen": 1
  },
  {
    "optionId": "1208",
    "code": 180,
    "parentCode": 0,
    "name": "Overtime Pay",
    "remarks": "Overtime compensation calculated by the company based on employee overtime hours",
    "isFixed": 1,
    "isPlus": 1,
    "isTax": 1,
    "isShow": 1,
    "isCompute": 1,
    "isOpen": 1
  },
  {
    "optionId": "1210",
    "code": 190,
    "parentCode": 0,
    "name": "Attendance Deduction Details",
    "remarks": null,
    "isFixed": 1,
    "isPlus": 0,
    "isTax": 1,
    "isShow": 1,
    "isCompute": 1,
    "isOpen": 1
  },
  {
    "optionId": "1217",
    "code": 200,
    "parentCode": 0,
    "name": "Total Attendance Deductions",
    "remarks": null,
    "isFixed": 1,
    "isPlus": 0,
    "isTax": 1,
    "isShow": 1,
    "isCompute": 0,
    "isOpen": 1
  },
  {
    "optionId": "1219",
    "code": 210,
    "parentCode": 0,
    "name": "Salary Payable",
    "remarks": null,
    "isFixed": 1,
    "isPlus": 2,
    "isTax": 2,
    "isShow": 1,
    "isCompute": 0,
    "isOpen": 1
  },
  {
    "optionId": "1221",
    "code": 220,
    "parentCode": 0,
    "name": "Taxable Salary",
    "remarks": null,
    "isFixed": 1,
    "isPlus": 2,
    "isTax": 2,
    "isShow": 1,
    "isCompute": 0,
    "isOpen": 1
  },
  {
    "optionId": "1223",
    "code": 230,
    "parentCode": 0,
    "name": "Individual Income Tax",
    "remarks": null,
    "isFixed": 1,
    "isPlus": 2,
    "isTax": 2,
    "isShow": 1,
    "isCompute": 0,
    "isOpen": 1
  },
  {
    "optionId": "1225",
    "code": 240,
    "parentCode": 0,
    "name": "Actual Salary",
    "remarks": null,
    "isFixed": 1,
    "isPlus": 2,
    "isTax": 2,
    "isShow": 1,
    "isCompute": 0,
    "isOpen": 1
  },
  {
    "optionId": "1227",
    "code": 10101,
    "parentCode": 10,
    "name": "Basic Salary",
    "remarks": "Standard salary agreed in the labor contract.",
    "isFixed": 0,
    "isPlus": 1,
    "isTax": 1,
    "isShow": 1,
    "isCompute": 1,
    "isOpen": 1
  },
  {
    "optionId": "1228",
    "code": 10102,
    "parentCode": 10,
    "name": "Position Salary",
    "remarks": "Different salaries for different positions based on responsibilities and skill requirements.",
    "isFixed": 0,
    "isPlus": 1,
    "isTax": 1,
    "isShow": 1,
    "isCompute": 1,
    "isOpen": 1
  },
  {
    "optionId": "1229",
    "code": 10103,
    "parentCode": 10,
    "name": "Post Salary",
    "remarks": "Salary varies based on the level of the position and technical expertise, changing with the position.",
    "isFixed": 0,
    "isPlus": 1,
    "isTax": 1,
    "isShow": 1,
    "isCompute": 1,
    "isOpen": 1
  },
  {
    "optionId": "1230",
    "code": 20101,
    "parentCode": 20,
    "name": "Housing Subsidy",
    "remarks": "Subsidy provided to solve housing issues for employees.",
    "isFixed": 0,
    "isPlus": 1,
    "isTax": 1,
    "isShow": 1,
    "isCompute": 1,
    "isOpen": 1
  },
  {
    "optionId": "1231",
    "code": 20102,
    "parentCode": 20,
    "name": "High Temperature Subsidy",
    "remarks": "When employees work in high temperatures above 33°C, a high temperature subsidy should be paid.",
    "isFixed": 0,
    "isPlus": 1,
    "isTax": 1,
    "isShow": 1,
    "isCompute": 1,
    "isOpen": 1
  },
  {
    "optionId": "1232",
    "code": 20103,
    "parentCode": 20,
    "name": "Transportation Subsidy",
    "remarks": "Monthly transportation subsidy paid by the company according to standards.",
    "isFixed": 0,
    "isPlus": 1,
    "isTax": 1,
    "isShow": 1,
    "isCompute": 1,
    "isOpen": 1
  },
  {
    "optionId": "1233",
    "code": 20104,
    "parentCode": 20,
    "name": "Meal Subsidy",
    "remarks": "Subsidy for lunch or dinner paid monthly according to standards when the company does not provide meals.",
    "isFixed": 0,
    "isPlus": 1,
    "isTax": 1,
    "isShow": 1,
    "isCompute": 1,
    "isOpen": 1
  },
  {
    "optionId": "1234",
    "code": 30101,
    "parentCode": 30,
    "name": "Performance Salary",
    "remarks": "Salary paid as a reward based on employees' actual labor results or performance.",
    "isFixed": 0,
    "isPlus": 1,
    "isTax": 1,
    "isShow": 1,
    "isCompute": 1,
    "isOpen": 1
  },
  {
    "optionId": "1235",
    "code": 40101,
    "parentCode": 40,
    "name": "Quarterly Bonus",
    "remarks": "Reward salary given quarterly to employees with outstanding performance.",
    "isFixed": 0,
    "isPlus": 1,
    "isTax": 1,
    "isShow": 1,
    "isCompute": 1,
    "isOpen": 1
  },
  {
    "optionId": "1236",
    "code": 40102,
    "parentCode": 40,
    "name": "Attendance Bonus",
    "remarks": "Reward for employees who arrive on time without any tardiness or early leave, generally assessed monthly.",
    "isFixed": 0,
    "isPlus": 1,
    "isTax": 1,
    "isShow": 1,
    "isCompute": 1,
    "isOpen": 1
  },
  {
    "optionId": "1237",
    "code": 40103,
    "parentCode": 40,
    "name": "Referral Bonus",
    "remarks": "Reward salary given to internal employees who refer talents that successfully join the company.",
    "isFixed": 0,
    "isPlus": 1,
    "isTax": 1,
    "isShow": 1,
    "isCompute": 1,
    "isOpen": 1
  },
  {
    "optionId": "1238",
    "code": 50101,
    "parentCode": 50,
    "name": "Sales Commission",
    "remarks": "For sales or business personnel, profits are usually shared between the company and employees based on a certain percentage.",
    "isFixed": 0,
    "isPlus": 1,
    "isTax": 1,
    "isShow": 1,
    "isCompute": 1,
    "isOpen": 1
  },
  {
    "optionId": "1239",
    "code": 60101,
    "parentCode": 60,
    "name": "Piece Rate Salary",
    "remarks": "Salary calculated and paid based on the quantity of work completed by employees and the predetermined piece rate.",
    "isFixed": 0,
    "isPlus": 1,
    "isTax": 1,
    "isShow": 1,
    "isCompute": 1,
    "isOpen": 1
  },
  {
    "optionId": "1240",
    "code": 70101,
    "parentCode": 70,
    "name": "Hourly Wage",
    "remarks": "Salary calculated and paid based on employees' working hours according to wage standards and levels.",
    "isFixed": 0,
    "isPlus": 1,
    "isTax": 1,
    "isShow": 1,
    "isCompute": 1,
    "isOpen": 1
  },
  {
    "optionId": "1241",
    "code": 80101,
    "parentCode": 80,
    "name": "Seniority Salary",
    "remarks": "Economic compensation given by the company based on employees' years of service, reflecting their work experience and contributions.",
    "isFixed": 0,
    "isPlus": 1,
    "isTax": 1,
    "isShow": 1,
    "isCompute": 1,
    "isOpen": 1
  },
  {
    "optionId": "1242",
    "code": 80102,
    "parentCode": 80,
    "name": "Company Tenure Salary",
    "remarks": "Salary calculated based on the length of time employees have worked at the company.",
    "isFixed": 0,
    "isPlus": 1,
    "isTax": 1,
    "isShow": 1,
    "isCompute": 1,
    "isOpen": 1
  },
  {
    "optionId": "1243",
    "code": 90101,
    "parentCode": 90,
    "name": "Title Salary",
    "remarks": "Salary is linked to the title; the higher the title, the higher the salary.",
    "isFixed": 0,
    "isPlus": 1,
    "isTax": 1,
    "isShow": 1,
    "isCompute": 1,
    "isOpen": 1
  },
  {
    "optionId": "1244",
    "code": 90102,
    "parentCode": 90,
    "name": "Skill Salary",
    "remarks": "Salary paid based on the knowledge, skills, and abilities possessed by employees.",
    "isFixed": 0,
    "isPlus": 1,
    "isTax": 1,
    "isShow": 1,
    "isCompute": 1,
    "isOpen": 1
  },
  {
    "optionId": "1245",
    "code": 90103,
    "parentCode": 90,
    "name": "Education Salary",
    "remarks": "Appropriate allowances given based on the degrees obtained by employees from educational institutions.",
    "isFixed": 0,
    "isPlus": 1,
    "isTax": 1,
    "isShow": 1,
    "isCompute": 1,
    "isOpen": 1
  },
  {
    "optionId": "1246",
    "code": 100101,
    "parentCode": 100,
    "name": "Personal Social Security",
    "remarks": "The portion of social security paid by individuals",
    "isFixed": 0,
    "isPlus": 0,
    "isTax": 1,
    "isShow": 1,
    "isCompute": 1,
    "isOpen": 1
  },
  {
    "optionId": "1247",
    "code": 100102,
    "parentCode": 100,
    "name": "Personal Housing Fund",
    "remarks": "The portion of the housing fund paid by individuals",
    "isFixed": 0,
    "isPlus": 0,
    "isTax": 1,
    "isShow": 1,
    "isCompute": 1,
    "isOpen": 1
  },
  {
    "optionId": "1248",
    "code": 110101,
    "parentCode": 110,
    "name": "Corporate Social Security",
    "remarks": "Social security costs borne by the company",
    "isFixed": 0,
    "isPlus": 1,
    "isTax": 0,
    "isShow": 1,
    "isCompute": 0,
    "isOpen": 1
  },
  {
    "optionId": "1249",
    "code": 120101,
    "parentCode": 120,
    "name": "Corporate Housing Fund",
    "remarks": "Housing fund costs borne by the company",
    "isFixed": 0,
    "isPlus": 1,
    "isTax": 0,
    "isShow": 1,
    "isCompute": 0,
    "isOpen": 1
  },
  {
    "optionId": "1250",
    "code": 130101,
    "parentCode": 130,
    "name": "Pre-tax Reissue",
    "remarks": "Salary reissued this month for amounts missed last month",
    "isFixed": 0,
    "isPlus": 1,
    "isTax": 0,
    "isShow": 1,
    "isCompute": 1,
    "isOpen": 1
  },
  {
    "optionId": "1251",
    "code": 140101,
    "parentCode": 140,
    "name": "Pre-tax Deduction",
    "remarks": "Deductions made this month for amounts not deducted last month;",
    "isFixed": 0,
    "isPlus": 0,
    "isTax": 0,
    "isShow": 1,
    "isCompute": 1,
    "isOpen": 1
  },
  {
    "optionId": "1252",
    "code": 150101,
    "parentCode": 150,
    "name": "Post-tax Reissue",
    "remarks": "Other post-tax reissues",
    "isFixed": 0,
    "isPlus": 1,
    "isTax": 0,
    "isShow": 1,
    "isCompute": 1,
    "isOpen": 1
  },
  {
    "optionId": "1253",
    "code": 160101,
    "parentCode": 160,
    "name": "Party Fee",
    "remarks": "Fees paid to the party organization for party activities, collected by the company.",
    "isFixed": 0,
    "isPlus": 0,
    "isTax": 0,
    "isShow": 1,
    "isCompute": 1,
    "isOpen": 1
  },
  {
    "optionId": "1254",
    "code": 160102,
    "parentCode": 160,
    "name": "Union Fee",
    "remarks": "Fees paid by employees for union activities",
    "isFixed": 0,
    "isPlus": 0,
    "isTax": 0,
    "isShow": 1,
    "isCompute": 1,
    "isOpen": 1
  },
  {
    "optionId": "1255",
    "code": 160103,
    "parentCode": 160,
    "name": "Supplementary Medical Insurance",
    "remarks": "Additional medical insurance paid by the company on top of basic medical insurance.",
    "isFixed": 0,
    "isPlus": 0,
    "isTax": 0,
    "isShow": 1,
    "isCompute": 1,
    "isOpen": 1
  },
  {
    "optionId": "1256",
    "code": 170101,
    "parentCode": 170,
    "name": "Commercial Insurance Payment",
    "remarks": "Commercial insurance payments do not participate in calculations but are subject to tax",
    "isFixed": 0,
    "isPlus": 1,
    "isTax": 1,
    "isShow": 1,
    "isCompute": 1,
    "isOpen": 1
  },
  {
    "optionId": "1257",
    "code": 180101,
    "parentCode": 180,
    "name": "Overtime Pay",
    "remarks": "Overtime pay calculated based on a certain percentage and overtime hours worked",
    "isFixed": 1,
    "isPlus": 1,
    "isTax": 1,
    "isShow": 1,
    "isCompute": 1,
    "isOpen": 1
  },
  {
    "optionId": "1258",
    "code": 190101,
    "parentCode": 190,
    "name": "Late Deduction",
    "remarks": "Deductions for employees who are late without reason",
    "isFixed": 1,
    "isPlus": 0,
    "isTax": 1,
    "isShow": 1,
    "isCompute": 1,
    "isOpen": 1
  },
  {
    "optionId": "1259",
    "code": 190102,
    "parentCode": 190,
    "name": "Early Leave Deduction",
    "remarks": "Deductions for employees who leave early without reason",
    "isFixed": 1,
    "isPlus": 0,
    "isTax": 1,
    "isShow": 1,
    "isCompute": 1,
    "isOpen": 1
  },
  {
    "optionId": "1260",
    "code": 190103,
    "parentCode": 190,
    "name": "Absenteeism Deduction",
    "remarks": "Deductions for employees who are absent without reason",
    "isFixed": 1,
    "isPlus": 0,
    "isTax": 1,
    "isShow": 1,
    "isCompute": 1,
    "isOpen": 1
  },
  {
    "optionId": "1261",
    "code": 190104,
    "parentCode": 190,
    "name": "Leave Deduction",
    "remarks": "Deductions for employees who are absent due to personal or sick leave",
    "isFixed": 1,
    "isPlus": 0,
    "isTax": 1,
    "isShow": 1,
    "isCompute": 1,
    "isOpen": 1
  },
  {
    "optionId": "1262",
    "code": 190105,
    "parentCode": 190,
    "name": "Missing Card Deduction",
    "remarks": "Deductions for employees who fail to clock in without reason",
    "isFixed": 1,
    "isPlus": 0,
    "isTax": 1,
    "isShow": 1,
    "isCompute": 1,
    "isOpen": 1
  },
  {
    "optionId": "1263",
    "code": 190106,
    "parentCode": 190,
    "name": "Comprehensive Deduction",
    "remarks": "Attendance deduction amount calculated based on accumulated tardiness and early leave duration or frequency",
    "isFixed": 1,
    "isPlus": 0,
    "isTax": 1,
    "isShow": 1,
    "isCompute": 1,
    "isOpen": 1
  },
  {
    "optionId": "1264",
    "code": 200101,
    "parentCode": 200,
    "name": "Total Attendance Deductions",
    "remarks": "Total deductions for six types of abnormal attendance: tardiness, early leave, absenteeism, missing card, leave, etc.",
    "isFixed": 1,
    "isPlus": 0,
    "isTax": 1,
    "isShow": 1,
    "isCompute": 0,
    "isOpen": 1
  },
  {
    "optionId": "1265",
    "code": 210101,
    "parentCode": 210,
    "name": "Salary Payable",
    "remarks": "Salary Payable = Total Employee Salary - Leave Deductions - Attendance Deductions, etc.",
    "isFixed": 1,
    "isPlus": 2,
    "isTax": 2,
    "isShow": 1,
    "isCompute": 0,
    "isOpen": 1
  },
  {
    "optionId": "1266",
    "code": 220101,
    "parentCode": 220,
    "name": "Taxable Salary",
    "remarks": "Taxable Salary = Salary Payable - Personal Social Security - Personal Housing Fund - Monthly Deduction",
    "isFixed": 1,
    "isPlus": 2,
    "isTax": 2,
    "isShow": 1,
    "isCompute": 0,
    "isOpen": 1
  },
  {
    "optionId": "1267",
    "code": 230101,
    "parentCode": 230,
    "name": "Individual Income Tax",
    "remarks": "Monthly individual income tax calculated according to tax calculation rules",
    "isFixed": 1,
    "isPlus": 2,
    "isTax": 2,
    "isShow": 1,
    "isCompute": 0,
    "isOpen": 1
  },
  {
    "optionId": "1268",
    "code": 240101,
    "parentCode": 240,
    "name": "Actual Salary",
    "remarks": "Actual income received by employees each month.",
    "isFixed": 1,
    "isPlus": 2,
    "isTax": 2,
    "isShow": 1,
    "isCompute": 0,
    "isOpen": 1
  }
]

Salary Configuration

constantKey constantType
salaryConfig object
{
  "salaryCycleStartDay": 1,
  "salaryCycleEndDay": 31,
  "payType": "Current Month",
  "payDay": "Pay Date",
  "socialSecurityMonthType": "1",
  "salaryStartMonth": "2022-03",
  "socialSecurityStartMonth": "2022-01"
}

Calculation Configuration

constantKey constantType
salaryComputation object
{
  "weekendSubsidy": 400,
  "schoolAgeSubsidy": 150,
  "professionalTitleAllowanceGuide": {
    "Bachelor": 300,
    "Master": 600,
    "Doctor": 1000
  }
}

_constant Statements

INSERT INTO _constant (id, constantKey, constantType, desc, constantValue, operation, operationByUserId, operationByUser, operationAt) VALUES (1, 'salaryOption', 'array', 'Salary Items', '[{"optionId":"1161","code":10,"parentCode":0,"name":"Basic Salary","remarks":null,"isFixed":0,"isPlus":1,"isTax":1,"isShow":1,"isCompute":1,"isOpen":1},{"optionId":"1165","code":20,"parentCode":0,"name":"Subsidy","remarks":"Benefits provided by the company to employees","isFixed":0,"isPlus":1,"isTax":1,"isShow":1,"isCompute":1,"isOpen":1},{"optionId":"1170","code":30,"parentCode":0,"name":"Variable Salary","remarks":"Variable salary needs to be manually entered before monthly payroll calculation","isFixed":0,"isPlus":1,"isTax":1,"isShow":1,"isCompute":1,"isOpen":1},{"optionId":"1172","code":40,"parentCode":0,"name":"Bonus","remarks":null,"isFixed":0,"isPlus":1,"isTax":1,"isShow":1,"isCompute":1,"isOpen":1},{"optionId":"1176","code":50,"parentCode":0,"name":"Commission Salary","remarks":null,"isFixed":0,"isPlus":1,"isTax":1,"isShow":1,"isCompute":1,"isOpen":1},{"optionId":"1178","code":60,"parentCode":0,"name":"Piece Rate Salary","remarks":null,"isFixed":0,"isPlus":1,"isTax":1,"isShow":1,"isCompute":1,"isOpen":1},{"optionId":"1180","code":70,"parentCode":0,"name":"Hourly Wage","remarks":null,"isFixed":0,"isPlus":1,"isTax":1,"isShow":1,"isCompute":1,"isOpen":1},{"optionId":"1182","code":80,"parentCode":0,"name":"Seniority Salary","remarks":null,"isFixed":0,"isPlus":1,"isTax":1,"isShow":1,"isCompute":1,"isOpen":1},{"optionId":"1185","code":90,"parentCode":0,"name":"Title Salary","remarks":null,"isFixed":0,"isPlus":1,"isTax":1,"isShow":1,"isCompute":1,"isOpen":1},{"optionId":"1189","code":100,"parentCode":0,"name":"Withholding","remarks":"Expenses paid by the company on behalf of individuals, such as personal social security, personal housing fund. Items under this category will be deducted from taxable income, affecting individual tax calculation","isFixed":0,"isPlus":0,"isTax":1,"isShow":1,"isCompute":1,"isOpen":1},{"optionId":"1192","code":110,"parentCode":0,"name":"Corporate Social Security","remarks":"Items under this category do not participate in salary calculation, only involved in corporate cost statistics or social security cost analysis","isFixed":0,"isPlus":1,"isTax":0,"isShow":1,"isCompute":0,"isOpen":1},{"optionId":"1194","code":120,"parentCode":0,"name":"Corporate Housing Fund","remarks":"Items under this category do not participate in salary calculation, only involved in corporate cost statistics or social security cost analysis","isFixed":0,"isPlus":1,"isTax":0,"isShow":1,"isCompute":0,"isOpen":1},{"optionId":"1196","code":130,"parentCode":0,"name":"Pre-tax Reissue","remarks":"Pre-tax reissue, paid together with the salary of that month, needs to be included in tax calculation","isFixed":0,"isPlus":1,"isTax":0,"isShow":1,"isCompute":1,"isOpen":1},{"optionId":"1198","code":140,"parentCode":0,"name":"Pre-tax Deduction","remarks":"Amounts deducted from the salary of that month before tax, which will affect the total taxable salary for the month","isFixed":0,"isPlus":0,"isTax":0,"isShow":1,"isCompute":1,"isOpen":1},{"optionId":"1200","code":150,"parentCode":0,"name":"Post-tax Reissue","remarks":"Post-tax reissue, does not participate in salary calculation for that month, will affect the actual income for the month","isFixed":0,"isPlus":1,"isTax":0,"isShow":1,"isCompute":1,"isOpen":1},{"optionId":"1202","code":160,"parentCode":0,"name":"Post-tax Deduction","remarks":"Amounts deducted from post-tax salary, do not participate in tax calculation for that month's salary","isFixed":0,"isPlus":0,"isTax":0,"isShow":1,"isCompute":1,"isOpen":1},{"optionId":"1206","code":170,"parentCode":0,"name":"Special Tax Items","remarks":"Other subjects that do not participate in salary calculation, but need to be taxed","isFixed":0,"isPlus":1,"isTax":1,"isShow":1,"isCompute":1,"isOpen":1},{"optionId":"1208","code":180,"parentCode":0,"name":"Overtime Pay","remarks":"Overtime compensation calculated by the company based on employee overtime hours","isFixed":1,"isPlus":1,"isTax":1,"isShow":1,"isCompute":1,"isOpen":1},{"optionId":"1210","code":190,"parentCode":0,"name":"Attendance Deduction Details","remarks":null,"isFixed":1,"isPlus":0,"isTax":1,"isShow":1,"isCompute":1,"isOpen":1},{"optionId":"1217","code":200,"parentCode":0,"name":"Total Attendance Deductions","remarks":null,"isFixed":1,"isPlus":0,"isTax":1,"isShow":1,"isCompute":0,"isOpen":1},{"optionId":"1219","code":210,"parentCode":0,"name":"Salary Payable","remarks":null,"isFixed":1,"isPlus":2,"isTax":2,"isShow":1,"isCompute":0,"isOpen":1},{"optionId":"1221","code":220,"parentCode":0,"name":"Taxable Salary","remarks":null,"isFixed":1,"isPlus":2,"isTax":2,"isShow":1,"isCompute":0,"isOpen":1},{"optionId":"1223","code":230,"parentCode":0,"name":"Individual Income Tax","remarks":null,"isFixed":1,"isPlus":2,"isTax":2,"isShow":1,"isCompute":0,"isOpen":1},{"optionId":"1225","code":240,"parentCode":0,"name":"Actual Salary","remarks":null,"isFixed":1,"isPlus":2,"isTax":2,"isShow":1,"isCompute":0,"isOpen":1},{"optionId":"1227","code":10101,"parentCode":10,"name":"Basic Salary","remarks":"Standard salary agreed in the labor contract.","isFixed":0,"isPlus":1,"isTax":1,"isShow":1,"isCompute":1,"isOpen":1},{"optionId":"1228","code":10102,"parentCode":10,"name":"Position Salary","remarks":"Different salaries for different positions based on responsibilities and skill requirements.","isFixed":0,"isPlus":1,"isTax":1,"isShow":1,"isCompute":1,"isOpen":1},{"optionId":"1229","code":10103,"parentCode":10,"name":"Post Salary","remarks":"Salary varies based on the level of the position and technical expertise, changing with the position.","isFixed":0,"isPlus":1,"isTax":1,"isShow":1,"isCompute":1,"isOpen":1},{"optionId":"1230","code":20101,"parentCode":20,"name":"Housing Subsidy","remarks":"Subsidy provided to solve housing issues for employees.","isFixed":0,"isPlus":1,"isTax":1,"isShow":1,"isCompute":1,"isOpen":1},{"optionId":"1231","code":20102,"parentCode":20,"name":"High Temperature Subsidy","remarks":"When employees work in high temperatures above 33°C, a high temperature subsidy should be paid.","isFixed":0,"isPlus":1,"isTax":1,"isShow":1,"isCompute":1,"isOpen":1},{"optionId":"1232","code":20103,"parentCode":20,"name":"Transportation Subsidy","remarks":"Monthly transportation subsidy paid by the company according to standards.","isFixed":0,"isPlus":1,"isTax":1,"isShow":1,"isCompute":1,"isOpen":1},{"optionId":"1233","code":20104,"parentCode":20,"name":"Meal Subsidy","remarks":"Subsidy for lunch or dinner paid monthly according to standards when the company does not provide meals.","isFixed":0,"isPlus":1,"isTax":1,"isShow":1,"isCompute":1,"isOpen":1},{"optionId":"1234","code":30101,"parentCode":30,"name":"Performance Salary","remarks":"Salary paid as a reward based on employees' actual labor results or performance.","isFixed":0,"isPlus":1,"isTax":1,"isShow":1,"isCompute":1,"isOpen":1},{"optionId":"1235","code":40101,"parentCode":40,"name":"Quarterly Bonus","remarks":"Reward salary given quarterly to employees with outstanding performance.","isFixed":0,"isPlus":1,"isTax":1,"isShow":1,"isCompute":1,"isOpen":1},{"optionId":"1236","code":40102,"parentCode":40,"name":"Attendance Bonus","remarks":"Reward for employees who arrive on time without any tardiness or early leave, generally assessed monthly.","isFixed":0,"isPlus":1,"isTax":1,"isShow":1,"isCompute":1,"isOpen":1},{"optionId":"1237","code":40103,"parentCode":40,"name":"Referral Bonus","remarks":"Reward salary given to internal employees who refer talents that successfully join the company.","isFixed":0,"isPlus":1,"isTax":1,"isShow":1,"isCompute":1,"isOpen":1},{"optionId":"1238","code":50101,"parentCode":50,"name":"Sales Commission","remarks":"For sales or business personnel, profits are usually shared between the company and employees based on a certain percentage.","isFixed":0,"isPlus":1,"isTax":1,"isShow":1,"isCompute":1,"isOpen":1},{"optionId":"1239","code":60101,"parentCode":60,"name":"Piece Rate Salary","remarks":"Salary calculated and paid based on the quantity of work completed by employees and the predetermined piece rate.","isFixed":0,"isPlus":1,"isTax":1,"isShow":1,"isCompute":1,"isOpen":1},{"optionId":"1240","code":70101,"parentCode":70,"name":"Hourly Wage","remarks":"Salary calculated and paid based on employees' working hours according to wage standards and levels.","isFixed":0,"isPlus":1,"isTax":1,"isShow":1,"isCompute":1,"isOpen":1},{"optionId":"1241","code":80101,"parentCode":80,"name":"Seniority Salary","remarks":"Economic compensation given by the company based on employees' years of service, reflecting their work experience and contributions.","isFixed":0,"isPlus":1,"isTax":1,"isShow":1,"isCompute":1,"isOpen":1},{"optionId":"1242","code":80102,"parentCode":80,"name":"Company Tenure Salary","remarks":"Salary calculated based on the length of time employees have worked at the company.","isFixed":0,"isPlus":1,"isTax":1,"isShow":1,"isCompute":1,"isOpen":1},{"optionId":"1243","code":90101,"parentCode":90,"name":"Title Salary","remarks":"Salary is linked to the title; the higher the title