|
|
SQL Human Resources / Education
API AHE2
AHE2 - Education Table
Employees OHEM SQL Table
Education Types OHED SQL Table
SBO SQL database table details
| Field | Description | Type | Constraints | Size | Related | Default | Primary_Key | Unique | empID KEY UNIQUE | Employee No. | Int | 11 | OHEM Employees | PRIMARY | Yes |
|---|---|---|---|---|---|---|---|---|
| line | Education: Information Row | Int | 6 | |||||
| fromDate | Education from | Date | 8 | |||||
| toDate | Education to | Date | 8 | |||||
| type | Education Type | Int | 11 | OHED Education Types | ||||
| institute | Institute | nVarChar | 100 | |||||
| major | Major | nVarChar | 50 | |||||
| diploma | Diploma | nVarChar | 50 | |||||
| LogInstanc | Log Instance | Int | 11 | 0 |
Table relationship map
SELECT statement
SELECT
AHE2.empID AS 'Employee No.',
AHE2.line AS 'Education: Information Row',
AHE2.fromDate AS 'Education from',
AHE2.toDate AS 'Education to',
AHE2.type AS 'Education Type',
AHE2.institute AS 'Institute',
AHE2.major AS 'Major',
AHE2.diploma AS 'Diploma',
AHE2.LogInstanc AS 'Log Instance'
FROM AHE2 AS AHE2
Related information
Employees OHEM SQL Table
Education Types OHED SQL Table
This website is not affiliated with, maintained, authorized, endorsed or sponsored by SAP AG or any of its affiliates