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 | CASE_ID | 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 | BUSINESS_UNIT | Character(5) | VARCHAR2(5) NOT NULL | Business Unit |
3 | LANGUAGE_CD | Character(3) | VARCHAR2(3) NOT NULL | Language Code |
4 | DESCR254 | Character(254) | VARCHAR2(254) NOT NULL | Description of length 254 |