| Column | Field | Description | Data Type | Edit Type | Length | Decimals | SQL Create Statement |
---|
| 1 | EPEMPLOYID | Employee ID | Numeric | Generic Edit | 8 | 0 | Allow NULL? |
| 2 | EPEMPLREF | Employee Reference Number | String | Generic Edit | 10 | 0 | Allow NULL? |
| 3 | EPMGRID | Manager ID | Numeric | Generic Edit | 8 | 0 | Allow NULL? |
| 4 | EPGRPPROF | Group Profile | String | Generic Edit | 5 | 0 | Allow NULL? |
| 5 | EPMULTIEMP | Multiple Employee Authority | Character | Generic Edit | 1 | 0 | Allow NULL? |
| 6 | EPMONEMPL | Monitor Employee | Character | Generic Edit | 1 | 0 | Allow NULL? |
| 7 | EPREIMMETH | Reimbursement Method | String | UDC (09E RM) | 2 | 0 | Allow NULL? |
| 8 | EPREIMCRCY | Reimbursement Currency | String | Generic Edit | 3 | 0 | Allow NULL? |
| 9 | EPAPPREQD | Approval Required | Character | Generic Edit | 1 | 0 | Allow NULL? |
| 10 | EPEFTJ | Date - Effective | Date | Generic Edit | 6 | 0 | |
| 11 | EPHMCUSRCE | Home Business Unit Source | Character | Generic Edit | 1 | 0 | Allow NULL? |
| 12 | EPEMSFLAG1 | EMS Flag 01 - Future Use | Character | Generic Edit | 1 | 0 | Allow NULL? |
| 13 | EPEMSFLAG2 | EMS Flag 02 - Future Use | Character | Generic Edit | 1 | 0 | Allow NULL? |
| 14 | EPEMSSTR10 | EMS String(10) -Future Use | String | Generic Edit | 10 | 0 | Allow NULL? |
| 15 | EPEMSSTR40 | EMS String(40) -Future Use | String | Generic Edit | 40 | 0 | Allow NULL? |
| 16 | EPEMSNUM10 | EMS Numeric(10) - Future Use | Numeric | Generic Edit | 10 | 0 | Allow NULL? |
| 17 | EPEMSDATE1 | EMS Date 01 - Future Use | Date | Generic Edit | 6 | 0 | |
| 18 | EPPID | Program ID | String | Generic Edit | 10 | 0 | Allow NULL? |
| 19 | EPUSER | User ID | String | Generic Edit | 10 | 0 | Allow NULL? |
| 20 | EPJOBN | Work Station ID | String | Generic Edit | 10 | 0 | Allow NULL? |
| 21 | EPUPMT | Time - Last Updated | Numeric | Generic Edit | 6 | 0 | Allow NULL? |
| 22 | EPUPMJ | Date - Updated | Date | Generic Edit | 6 | 0 | |