Table: vwRubyPreFilledPositionList
Primary Key: None defined
Fields
| Field | Type | Size | Required | PK |
|---|---|---|---|---|
| Application Status ID | Long | 4 | ||
| Position ID | Long | 4 | ✓ | |
| People ID | Long | 4 | ||
| Job ID | Long | 4 | ||
| Which Dashboard | Long | 4 | ||
| Job | Text | 255 | ||
| Org Unit | Text | 255 | ||
| Pay Point | Text | 255 | ||
| Position Status ID | Long | 4 | ||
| Position Status | Text | 255 | ||
| Employee | Memo | - | ✓ | |
| Start Date | DateTime | 8 | ||
| Termination Date | DateTime | 8 | ||
| Date Eliminated | DateTime | 8 | ||
| Date Suspended | DateTime | 8 | ||
| Company Name | Text | 255 | ||
| Person | Memo | - | ✓ |