BUSINESS_UNITPrompt Table: SP_BU_RC_NONVW
QUICK_CDEFFDTDefault Value: %date
A=Outbound - AAF
B=Inbound Notification
I=Internal
N=Outbound - Note
O=Outbound Notification
S=Self Service
U=Outbound - Solution
A=All
I=Internal
RC_QUICK_CD_NTE(SQL Table) |
Index Back |
|---|---|
Quick Code Note TableQuick Code Note Table. This table stores the note specific to the Quick Code. |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | BUSINESS_UNIT |
Character(5) | VARCHAR2(5) NOT NULL |
Business Unit
Prompt Table: SP_BU_RC_NONVW |
| 2 | QUICK_CD |
Character(3) | VARCHAR2(3) NOT NULL | Quick Code |
| 3 | EFFDT |
Date(10) | DATE |
Effective Date
Default Value: %date |
| 4 | RC_SUMMARY | Character(80) | VARCHAR2(80) NOT NULL | Typically a summary of a long field. |
| 5 | RC_NOTE_TYPE | Character(5) | VARCHAR2(5) NOT NULL | Case Note Types |
| 6 | RC_NOTE_ORIGIN | Character(1) | VARCHAR2(1) NOT NULL |
Used in Case Notes
A=Outbound - AAF B=Inbound Notification I=Internal N=Outbound - Note O=Outbound Notification S=Self Service U=Outbound - Solution |
| 7 | RC_VISIBILITY | Character(4) | VARCHAR2(4) NOT NULL |
Case Visibility, used for cases and case objects/attributes.
A=All I=Internal |
| 8 | RC_DESCRLONG | Long Character | CLOB | Long description used in CallCenter for Problem, Solution... |