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 |