PERSONNEL_TRAINING_HISTORY
PERSONNEL TRAINING EVENT HISTORY
tableMANPERSONNEL
PERSONNEL_TRAINING_HISTORY — PERSONNEL TRAINING EVENT HISTORY. MAN table in the standard Ross ERP 8.0 schema: 11 columns, used by 5 programs. Columns, data types, keys, foreign keys and relationships.
Open PERSONNEL_TRAINING_HISTORY in the interactive Data Dictionary →Part of PERSONNEL tables & objects · all tables, views & procedures
Columns
| # | Column | Type | Key | Description |
|---|---|---|---|---|
| 1 | GEM_DBKEY | int | GEMBASE internal surrogate primary key: a system-generated unique row identifier (the database key). Not a business field; every table carries one. | |
| 2 | HTH_AUTO_NUM | numeric(20,0) | PK | Training History Number |
| 3 | HTH_BDG_ID | varchar(10) | PK FK→PERSONNEL_MASTER | Badge Id |
| 4 | HTH_COUR | varchar(25) | Course Name | |
| 5 | HTH_CMPL_DTE | datetime | Course Completion Date | |
| 6 | HTH_GRDE | varchar(4) | Course Grade | |
| 7 | HTH_DSC1 | varchar(50) | Course Description - Line 1 | |
| 8 | HTH_DSC2 | varchar(50) | Course Description - Line 2 | |
| 9 | INS_UID | varchar(20) | User Id who Inserted Row | |
| 10 | INS_DTE | datetime | Date of Row Insertion | |
| 11 | INS_TME | varchar(4) | Time of Row Insertion |