RC_CAS_DSPTE_LN(SQL Table) | 
Index Back | 
|---|---|
Case extension table (Dispute)Case extension table for capturing details for dispute case. | 
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description | 
|---|---|---|---|---|
| 1 | Number(15,0) | DECIMAL(15) NOT NULL | 
Case ID. This is a unique ID assigned to a case when it is saved. Unique ID is ensured by getting the next value from the auto-numbering table and updating the table.
 Default Value: 999999999999999  | 
|
| 2 | Character(5) | VARCHAR2(5) NOT NULL | Business Unit | |
| 3 | Character(3) | VARCHAR2(3) NOT NULL | Language Code | |
| 4 | DESCR254 | Character(254) | VARCHAR2(254) NOT NULL | Description of length 254 |