| Table | Table Description | Column# | Prefix | Alias | Column Description | Data Type | Edit Type | Length | Decimals |
|---|
| TOP05A: PeopleSoft HR & PR Foundation |
| 1 | F060116 | Employee Master Information | 107 | YA | SOCC | Standard Occupational Class Code | String | UDC | 4 | 0 |
| 2 | F0601161 | Point-In-Time Employee Master | 109 | PT | SOCC | Standard Occupational Class Code | String | UDC | 4 | 0 |
| 3 | F060116W | EE Master Request File | 107 | YA | SOCC | Standard Occupational Class Code | String | UDC | 4 | 0 |
User Defined Codes are, by design, customisable and thus will differ from system to system depending on the business requirements.
TOPUDC 06 / SO (Standard Occupational Class) stock values
| Value | Description | Special Handling Code | Hard Coded |
|---|
| 1 | | Default | | |
| 2 | 1412 | Accountant/Auditor | | |
| 3 | 1419 | Fin Officer, Other | | |
| 4 | 1430 | Labor Relations Specialist | | |
| 5 | 1449 | Purchasing Agent | | |
| 6 | 1450 | Buss/Promotion Agent | | |
| 7 | 1472 | Construction Inspector | | |
| 8 | 1610 | Architect | | |
| 9 | 1623 | Eng Metal/Material | | |
| 10 | 1628 | Engineer Civil | | |
| 11 | 1633 | Enginner Electrical | | |
| 12 | 1634 | Engineer Industrial | | |
| 13 | 1635 | Engineer Mechanical | | |
| 14 | 1712 | Computer Sys Analyst | | |
| 15 | 1912 | Econimist | | |
| 16 | 3220 | Designer | | |
| 17 | 3711 | Eng Tech Electrical | | |
| 18 | 3712 | Eng Tech Industrial | | |
| 19 | 3713 | Eng Tech Mechanical | | |
| 20 | 3719 | Engineering Tech NEC | | |
| 21 | 3720 | Drafting Occs | | |
| 22 | 4512 | Computer Equip Supvr | | |
| 23 | 4514 | Clk Supvr Info | | |
| 24 | 4519 | Clk Supvr Record | | |
| 25 | 4521 | Clk Supvr Fin Record | | |
| 26 | 4525 | Clk Supvr Mat Dist | | |
| 27 | 4612 | Computer Operator | | |
| 28 | 4642 | Clk Interviewing | | |
| 29 | 4664 | Clk Order | | |
| 30 | 4692 | Clk Pers X Payroll | | |
| 31 | 4696 | Clk File | | |
| 32 | 4712 | Clk Bookkeep/Acct/Audi | | |
| 33 | 4713 | Clk Payroll/Time | | |
| 34 | 4715 | Clk Billing | | |
| 35 | 4716 | Clk Cost/Rate | | |
| 36 | 4718 | Bill/Post/Calc Mach Op | | |
| 37 | 4722 | Duplicating Mach Op | | |
| 38 | 4744 | Clk Mail X Postal | | |
| 39 | 4751 | Dispatcher | | |
| 40 | 4752 | Clk Production/Plan | | |
| 41 | 4753 | Clk Traffic/Ship/Rec | | |
| 42 | 4754 | Clk Stock/Inventory | | |
| 43 | 4758 | Expediter | | |
| 44 | 4793 | Data Entry Keyer | | |
| 45 | 5211 | Food/Beverage Supvr | | |
| 46 | 5214 | Cook X Short Order | | |
| 47 | 5215 | Cook Short Order | | |
| 48 | 5216 | Food Counter & Related | | |
| 49 | 5245 | Elevator Op | | |
| 50 | 5622 | Gardener | | |
| 51 | 6176 | Elevator Install/Rep | | |
| 52 | 6311 | Supervisor Overall Constr. | | |
| 53 | 6312 | Brick/Stone/Tile Supvr | | |
| 54 | 6313 | Carpenter Supvr | | |
| 55 | 6314 | Elec/Power Trans Supvr | | |
| 56 | 6318 | Const Supvr Other | | |
| 57 | 6412 | Brickmason | | |
| 58 | 6413 | Stonemason | | |
| 59 | 6422 | Carpenter | | |
| 60 | 6424 | Drywall Installer | | |
| 61 | 6432 | Electrician | | |
| 62 | 6433 | Elec Power Install/Rep | | |
| 63 | 6450 | Plumber/Pipefitter/Steamfitter | | |
| 64 | 6462 | Carpet/Soft Tile Inst. | | |
| 65 | 6463 | Concrete/Terr Finisher | | |
| 66 | 6465 | Insulation Worker | | |
| 67 | 6474 | Driller, Earth | | |
| 68 | 6475 | Air Hammer Operator | | |
| 69 | 6479 | Const Trades NEC | | |
| 70 | 6530 | Explosive Wkr | | |
| 71 | 6814 | Boilermaker | | |
| 72 | 6832 | Cabinet Maker | | |
| 73 | 7720 | Assembler | | |
| 74 | 8214 | Delivery & Route | | |
| 75 | 8315 | Crane/Tower Op | | |
| 76 | 8316 | Excavate/Load Mach Op | | |
| 77 | 8620 | Fabricate/Inspect Hlp | | |
| 78 | 8641 | Brick/Stone/Tile Hlp | | |
| 79 | 8642 | Carpenter Hlp | | |
| 80 | 8643 | Electrician Hlp | | |
| 81 | 8648 | Const Trade Hlp Other | | |
| 82 | 8650 | Extractive Occ Hlp | | |
| 83 | 8710 | Construction Laborer | | |
| 84 | 8722 | Garbage Collector | | |
