| RC_NOTETYPE_LNG(SQL Table) | Index Back | 
|---|---|
| Case Note TypeCase Note Type Definition | 
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description | 
|---|---|---|---|---|
| 1 | Character(5) | VARCHAR2(5) NOT NULL | This field is used to store the value of SetID on various setup tables. Default Value: OPR_DEF_TBL_RB.SETID Prompt Table: SP_SETID_NONVW | |
| 2 | Character(5) | VARCHAR2(5) NOT NULL | Case Note Types | |
| 3 | Character(3) | VARCHAR2(3) NOT NULL | Language Code | |
| 4 | RC_SHORT_DESCR | Character(20) | VARCHAR2(20) NOT NULL | Short Description. Used on may CallCenter set-up tables | 
| 5 | LONG_DESC | Character(50) | VARCHAR2(50) NOT NULL | Long Description field. |