OBSTACLES_MOBIL(SQL Table) | 
Index Back | 
|---|---|
Obstacles to Mobility - CareerOBSTACLES_MOBIL is part of Career Planning for an employee. Use it to identify any obstacles, such as a spouse's job, that might hamper an employee's ability to change job locations. | 
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description | 
|---|---|---|---|---|
| 1 | Character(11) | VARCHAR2(11) NOT NULL | 
Employee ID
 Prompt Table: PERSON  | 
|
| 2 | Date(10) | DATE NOT NULL | 
Effective Date
 Default Value: %date  | 
|
| 3 | Character(2) | VARCHAR2(2) NOT NULL | 
Obstacles to Mobility
 FE=Family Member's Education FH=Family Member's Health FJ=Family Member's Job H=Homeowner N=None OT=Other P=Prefer Current Location  |