| WA_CLS_TBL_GER(SQL Table) | Index Back | 
|---|---|
| Work Area Class Table - GERWork Area Class Table - Germany | 
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description | 
|---|---|---|---|---|
| 1 | Character(4) | VARCHAR2(4) NOT NULL | Work Area Class | |
| 2 | Date(10) | DATE NOT NULL | Effective Date Default Value: %date | |
| 3 | EFF_STATUS | Character(1) | VARCHAR2(1) NOT NULL | Effective Status A=Active I=Inactive Default Value: A | 
| 4 | DESCR100 | Character(100) | VARCHAR2(100) NOT NULL | Length 100 Description | 
| 5 | DESCRLONG | Long Character | CLOB | Long Description |