DISABILITY_CHE(SQL Table) | 
Index Back | 
|---|---|
Disability Table - CHEThis table holds the employee disability information for Switzerland | 
| # | 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 | HANDICAP_PERCENT | Number(3,0) | SMALLINT NOT NULL | Handicap Percent |