Skip to main content

sistem_tablolari_ik

System Tables - Human Resources

In human resource management systems, special tables are used to organize and manage employee data and related information. These tables ensure that the workforce is effectively monitored and managed.

OSUSERS - User Table

Description: This table contains basic information for all employees. It has fields such as employee ID, name, surname, and password.

Function: Organizes employees' personal information and keeps it up to date. It is the main source of data for the HR department.

The Column Information of this table is as follows.

' 'ID: User ID

' 'USERNAME: Username

' 'FIRSTNAME: Name

' 'LASTNAME: Surname

' 'PASSWORD: Password

' 'EMAIL: Email

' 'STATUS: Status (Active/Passive)

' 'TYPE: Type

' 'IMPORTSTATUS: Import Status·

' 'BIRTHDATE: Date of Birth

' 'EMPLOYEMENTSTART: Employment Start Date

' 'EMPLOYEMENTEND: Date of Termination of Employment

' ' CATEGORY: Category

' 'SEX: Gender

' 'DEPARTMENT: Department

' 'PROFESSION: Profession

' 'PHONE: Phone

' 'MOBILEPHONE: Mobile Phone

' 'REGISTRATIONNUMBER: Registration Number

' ' WAYOFWORK: Method of Operation

' 'PLACEOFBIRTH: Place of Birth

' 'MARITALSTATUS: Marital Status

' 'IDENTIFICATIONNUMBER: ID Number

' 'PERSONALEMAIL: Personal Email

' ' PERSONALPHONE: Personal Phone

' 'PERSONALMOBILEPHONE: Personal Mobile Phone

' 'ADDRESS: Address

' ' EDUCATIONALSTATUS: Education Status

' 'SHIFTID: Shift ID

' 'DEFAULTCULTURE: Default Culture

' ' MFAENABLED: MFA Enabled

' 'AUTHENTICATORENABLED: Authenticator Enabled

OSDEPARTMENTS - Department Table

Description: Contains information about the different departments of the company. It contains information such as department name, department manager, and department code.

Function: Manages the structure of the organization and interdepartmental relations. Which employees

It follows that it works in departments.

The Column Information of this table is as follows.

' 'ID: Department ID

' 'DEPARTMENTCODE: Department Code

' ' DESCRIPTION: Description

' 'MANAGERDEPARTMENT: Manager's Department

' 'STATUS: Status ( Active/Passive )

' 'TYPE: Type

' 'IMPORTSTATUS: Import Status

' 'MANAGERUSERID: Manager User ID

OSGROUPS - User Group Table

The OsGroups table is used to identify and manage various groups or teams within an organization.

An analogue of this table is the OsGorupContent table.

The content includes GroupCode and UserId. This table helps us to associate with the OSUSERS and OSGROUPS table.

The Column Information of this table is as follows.

' 'ID: ID

' 'GROUPCODE: Group Code

' ' DESCRIPTION: Description

' 'STATUS: Status( Active/Passive )

' 'IMPORTSTATUS: Import Status

An Example Scenario for the Connection Between Tables;

' ' Users and Departments:

  • Each employee works in a department. For example, Nelson Dale works in the Finance department. The ID of this department is 557, and this relationship is established between the DEPARTMENT column in the osusers table and the ID column in the osdepartments table.

' 'Departments and Managers:

  • Each department has a manager. The manager of the Finance Unit department is BURCU SEVGİLİ. This relationship is established between the MANAGERUSERID column in the osdepartments table and the ID column in the osusers table. That is, the user ID of the Finance Department MANAGERUSERID= SIGN DEAR is 548.

OSPOSITIONS - User Positions Table

An OSPositions table is a table that is used to identify and manage various positions or job roles within an organization. This table shows what positions employees hold and how the organizational structure is structured.

' 'ID: Position ID

' 'POSITIONCODE: Position Code

' ' DESCRIPTION: Description

' 'USERID: User ID (User in position)

' 'STATUS: Status(Active/Passive)

' 'TYPE: Type

' 'IMPORTEDPOSCODE: Imported position code

' 'IMPORTSTATUS: Import Status

OSPROPERTIES - Properties Table

An OSProperties table is a table that is used to define various features, settings, or configuration parameters within an organization. This table manages custom attributes for the application or system and supports data configuration.

For example,

PropertyTypeID: Defines the data type of the property. This specifies what type of data the property contains

IsRequired: A field that specifies whether the feature is mandatory. This indicates whether the feature is required for the user's or system's operations.

Order: The sort order of the property. Determines the order in which features are shown in the user interface or in reporting.

can be given.

The tables mentioned above are Human Resources tables that are related to each other, as can be seen in the example scenario given.