Click on the table headers to change how the table is sorted.
Business Unit
BUS_UNIT_TBL_HR - HR Business Unit Table
| BUSINESS_UNIT | Description |
|---|---|
| UMS01 | University of Maine at Augusta |
| UMS02 | University of Maine Farmington |
| UMS03 | University of Maine Fort Kent |
| UMS04 | University of Maine at Machias |
| UMS05 | University of Maine |
| UMS06 | University of Southern Maine |
| UMS07 | University Maine Presque Isle |
| UMS08 | University Services |
| UMS09 | University College Outreach |
Calendar Date Prompt
To run a prompt on a date field that uses a clickable calendar, change the *Format drop-down to Century.
Department ID - HR (DEPTID_HR)
Use this prompt table, SET_DEPT_VW - Department table view, to prompt for DEPTID_HR.
| Key | Record.Fieldname | Format | XLAT | Heading Text |
|---|---|---|---|---|
| COMPANY - Company | Char3 | Co | ||
| → | DEPTID - Department | Char10 | Dept ID | |
| DESCR - Description | Char30 | Descr | ||
| → | EFFDT - Effective Date | Date | Eff Date | |
| EFF_STATUS - Status as of Effective Date | Char1 | N | Status | |
| LOCATION - Location Code | Char10 | Location | ||
| → | SETID_DEPT - Department Set ID | Char5 | Dept Set ID |
