PERSONNEL_MASTER
PERSONNEL MASTER DATABASE TABLE
tableMANPERSONNEL
PERSONNEL_MASTER — PERSONNEL MASTER DATABASE TABLE. MAN table in the standard Ross ERP 8.0 schema: 60 columns, used by 18 programs. Columns, data types, keys, foreign keys and relationships.
Open PERSONNEL_MASTER 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 | HPM_OWN_ID | varchar(12) | Company/Factory Id | |
| 3 | HPM_BDG_ID | varchar(10) | PK | Badge Id |
| 4 | HPM_BDG_NM | varchar(25) | Individual's Name (Last First MI) | |
| 5 | HPM_PH | varchar(11) | Home Phone Number | |
| 6 | HPM_WRK_PH | varchar(11) | Work Phone Number | |
| 7 | HPM_STR_ADR | varchar(40) | Home Street Address | |
| 8 | HPM_CTY_ADR | varchar(40) | Home City Address | |
| 9 | HPM_ST_ID | varchar(2) | FK→PERSONNEL_STATE_CODES | Home State Id |
| 10 | HPM_ZIP | varchar(9) | Home Zip Code | |
| 11 | HPM_MILE | numeric(20,1) | Miles from Home to Work Site | |
| 12 | HPM_SSN | varchar(11) | Social Security Number | |
| 13 | HPM_LVL | varchar(4) | Employment Level | |
| 14 | HPM_CRW_ID | varchar(2) | FK→PERSONNEL_CREW_CODES | Crew Id |
| 15 | HPM_DPT_ID | varchar(5) | FK→PERSONNEL_DEPARTMENT_CODES | Department Id |
| 16 | HPM_TRDE_ID | varchar(5) | Trade Id | |
| 17 | HPM_LBR_RATE | numeric(20,2) | Labor Rate | |
| 18 | HPM_SHIFT_ID | varchar(1) | FK→PERSONNEL_SHIFT_CODES | Shift Id |
| 19 | HPM_EMPL_DTE | datetime | Date of Employment | |
| 20 | HPM_DTE_DPT | datetime | Date Assigned to Department | |
| 21 | HPM_TRDE_EMPL | varchar(5) | Trade on Date of Employment | |
| 22 | HPM_PRMO_DTE | datetime | Date of Promotion | |
| 23 | HPM_PAY_DTE | datetime | Date of Labor Rate Change | |
| 24 | HPM_WRK_LOC | varchar(40) | Work Location | |
| 25 | HPM_CALL_OT | numeric(20,1) | Call-In Overtime | |
| 26 | HPM_LVL_EMPL | varchar(4) | Level on Date of Employment | |
| 27 | HPM_PAY_EMPL | numeric(20,2) | Pay Rate on Employment | |
| 28 | HPM_REG_EMPL | varchar(1) | FK→SV_YES_NO | Regular Employee Indicator |
| 29 | HPM_FRMN_DTE | datetime | Date Assigned to Foreman | |
| 30 | HPM_TRDE_DTE | datetime | Date of Trade Change | |
| 31 | HPM_FRMN_NM | varchar(25) | Foreman's Name | |
| 32 | HPM_SUPV_IND | varchar(1) | FK→SV_YES_NO | Supervisor Indicator |
| 33 | HPM_BIRTH | datetime | Date of Birth | |
| 34 | HPM_SEX | varchar(1) | FK→SV_SEX | Sex |
| 35 | HPM_MARR | varchar(1) | Marital Status | |
| 36 | HPM_PRV_TRDE | varchar(5) | Previous Trade | |
| 37 | HPM_PRV_LVL | varchar(4) | Previous Level | |
| 38 | HPM_PRV_DPT | varchar(5) | Previous Department | |
| 39 | HPM_PRV_FRMN | varchar(25) | Previous Foreman | |
| 40 | HPM_PRV_PAY | numeric(20,2) | Previous Labor Rate | |
| 41 | HPM_EMER_CON1 | varchar(25) | Emergency Contact 1 | |
| 42 | HPM_EMER_CON2 | varchar(25) | Emergency Contact 2 | |
| 43 | HPM_EMER_PH1 | varchar(11) | Emergency Phone Number 1 | |
| 44 | HPM_EMER_PH2 | varchar(11) | Emergency Phone Number 2 | |
| 45 | HPM_EMER_STR1 | varchar(40) | Emergency Street Address 1 | |
| 46 | HPM_EMER_STR2 | varchar(40) | Emergency Street Address 2 | |
| 47 | HPM_EMER_CTY1 | varchar(40) | Emergency City Address 1 | |
| 48 | HPM_EMER_CTY2 | varchar(40) | Emergency City Address 2 | |
| 49 | HPM_EMER_ZIP1 | varchar(9) | Emergency Zip Code 1 | |
| 50 | HPM_EMER_ZIP2 | varchar(9) | Emergency Zip Code 2 | |
| 51 | HPM_EMER_ST_ID1 | varchar(2) | FK→PERSONNEL_STATE_CODES | Emergency State Id 1 |
| 52 | HPM_EMER_ST_ID2 | varchar(2) | FK→PERSONNEL_STATE_CODES | Emergency State Id 2 |
| 53 | INS_UID | varchar(20) | User Id who Inserted Row | |
| 54 | INS_DTE | datetime | Date of Row Insertion | |
| 55 | INS_TME | varchar(4) | Time of Row Insertion | |
| 56 | NBK_NB_ID | varchar(20) | Notebook ID | |
| 57 | NBK_NB_TYP | varchar(5) | Notebook Type | |
| 58 | HPM_ASSGN_FLG | varchar(1) | ASSIGNED TO FLAG | |
| 59 | FACTORY_CODE | varchar(2) | FK→NOTEBOOK_MASTER | Factory Code |
| 60 | COMPANY_CODE | varchar(10) | FK→PERSONNEL_TRADE_CODES | Company Code |