Created by Miki Yanagi, last modified by Corina C Larsen on Jan 28, 2020
DO NOT use this table.
This is a batch upload staging table that replaces manual data entry for primarily PATFA (part-time) teaching contracts.
The data is incomplete, and this table is an interim solution that will be improved or replaced once teaching contracts are processed in a MaineStreet tool that is currently in development.
| Key Fields | Record.Fieldname | Format | XLAT | Heading Text |
|---|---|---|---|---|
| → | UM_BATCH_ID - Batch ID | Char30 | Batch ID | |
| → | EMPLID - Empl ID | Char11 | ID | |
| → | EMPL_RCD - Empl Record | Num3.0 | Empl Record | |
| UM_CLASS_NBR - Class number | Char5 | Class number | ||
| → | CLASS_NBR - Class Nbr | Num5.0 | Class Nbr | |
| → | TERM - Term | Num5.0 | Term | |
| UM_COURSE_ID - Course ID | Char10 | Course ID | ||
| UMS_PATFA_STATUS - Status | Char1 | N | Status | |
| UM_GOAL_AMT - Goal Amount | Char30 | Goal Amount | ||
| NAME - Name | Char50 | Name | ||
| JOB_TITLE - Job Title | Char10 | Job Title | ||
| PROCESS_INSTANCE - Process Instance | Num10.0 | Instance | ||
| ACAD_ORG - Academic Organization | Char10 | Acad Org | ||
| POSITION_NBR - Position Number | Char8 | Position | ||
| JOBCODE - Job Code | Char6 | Job Code | ||
| COURSE_CD_OFR_TYP2 - Course Code Offered Type 2 | Char5 | Course Cd Ofr 2 | ||
| SESSION_CODE - Session | Char3 | N | Session | |
| SUBJECT - Subject Area | Char8 | Subject | ||
| CATALOG_NBR - Catalog Nbr | Char10 | Catalog | ||
| SECTION_ID - Section ID | Char10 | Sect ID | ||
| COURSE_TITLE_LONG - Long Course Title | Char100 | Long Title | ||
| START_DT - Start Date | Date | Start Date | ||
| END_DT - End Date | Date | End Date | ||
| ACCT_CD - Combination Code | Char25 | Combo Code | ||
| LAST_NAME - Last Name | Char30 | Last | ||
| FIRST_NAME - First Name | Char30 | First Name | ||
| UOM_ACAD_RANK - Academic Rank | Char10 | Academic Rank | ||
| UNION_CD - Union Code | Char3 | Union Code | ||
| SERVICEID_LIST - Service ID Lists | Text | ID Lists | ||
| MONTHLY_RT - Monthly Rate | Num16.3 | Monthly Rt | ||
| NUM1 - Number 1 | Char6 | Nbr 1 | ||
| UM_PATFA_STRTDT - Start Date | Date | Start Date | ||
| UM_PATFA_ENDDT - End Date | Date | End Date | ||
| BUSINESS_UNIT - Business Unit | Char5 | Unit | ||
| DEPTID - Department | Char10 | Dept ID | ||
| ACCOUNT - Account | Char10 | Acct | ||
| CLASS_FLD - Class Field | Char5 | Class | ||
| FUND_CODE - Fund Code | Char5 | Fund | ||
| PROGRAM_CODE - Program Code | Char5 | Program | ||
| PROJECT_ID - Project | Char15 | Project | ||
| OPERATING_UNIT - Operating Unit | Char8 | Operating Unit | ||
| UM_CANCEL_FLAT_FEE - Cancel Flat Fee | Char20 | Flat Fee | ||
| UM_EARN_TYPE - Earnings Type | Char20 | Earnings Type | ||
| ERNCD - Earnings Code | Char3 | Earn Code | ||
| UM_COURSE_CREDITS - Course Credits | Num3.2 | Course Credits | ||
| UM_LAB_CREDIT_HRS - Lab Credit Hours | Num3.2 | Lab Cred Hrs | ||
| UM_SERVICE_CREDITS - Service Credits | Num2.0 | Service Credits | ||
| DEPTID_CF - Department | Char10 | Dept ID | ||
| UM_PATFA_CHAIR - Chair | Char6 | Chair | ||
| UM_PATFA_UNDERGRAD - Chair | Char10 | Chair | ||
| COMBO_SEQ_NO - Combination Sequence Num | Num18.0 | Combo Seq No | ||
| ERRORMSG - Error Message | Char254 | Error Msg | ||
| OPRID - User ID | Char30 | User | ||
| UM_PATFA_CNTRCTSEN - Chair | Char6 | Chair | ||
| UM_PATFA_CNTRCTRET - Chair | Char6 | Chair | ||
| FDM_COMBO_CD - GL Combination Code | Char25 | GL Combo Code | ||
| UM_EMAIL_BUS_ADDR - Business Email Address | Char70 | |||
| LASTUPDDTTM - Last Update Date/Time | DateTm | Last Upd DtTm |
Data Dictionary Links
Clicking the linked (blue) fields in any table will take you to the Data Dictionary and provide you with more information about that field as well as field values if they are available.