PERSONNEL_ACCIDENT_HISTORY
PERSONNEL ACCIDENT EVENT HISTORY
tableMANPERSONNEL
PERSONNEL_ACCIDENT_HISTORY — PERSONNEL ACCIDENT EVENT HISTORY. MAN table in the standard Ross ERP 8.0 schema: 13 columns, used by 5 programs. Columns, data types, keys, foreign keys and relationships.
Open PERSONNEL_ACCIDENT_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 | HAH_OWN_ID | varchar(12) | Company/Factory Id | |
| 3 | HAH_AUTO_NUM | numeric(20,0) | PK | Accident Event History Number |
| 4 | HAH_EQP_ID | varchar(20) | FK→EQUIPMENT_MASTER | Equipment Id Related to Accident |
| 5 | HAH_BDG_ID | varchar(10) | PK FK→PERSONNEL_MASTER | Badge Id |
| 6 | HAH_ACC_DTE | datetime | Date of Accident | |
| 7 | HAH_DSC1 | varchar(50) | Accident Description - Line 1 | |
| 8 | HAH_DSC2 | varchar(50) | Accident 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 | |
| 12 | FACTORY_CODE | varchar(2) | Factory Code | |
| 13 | COMPANY_CODE | varchar(10) | Company Code |