RIT_SETUP_TBL(SQL Table) |
Index Back |
|---|---|
Setup Table for CIC04-10-2001 - JBE - Setup Table for CIC to filter selected rows of data. The buffer could load ma |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  VIEW_NAME |
Character(30) | VARCHAR2(30) NOT NULL | View Name |
| 2 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
| 3 | FIELDNAME | Character(18) | VARCHAR2(18) NOT NULL |
Field Name (see PSDBFIELD).
Prompt Table: RI_RECNAME_VW |
| 4 | MAX_ROWS_SCROLL | Number(5,0) | INTEGER NOT NULL | Max Number of Rows in Scrolls |
| 5 | RI_CRITERIA | Character(4) | VARCHAR2(4) NOT NULL |
Search Criteria
<=Less Than ==Equal To >=Greater Than DATE=Last n Days ROWS=Row Amount STAT=Status = |
| 6 | CRITERIA_VALUE | Character(50) | VARCHAR2(50) NOT NULL | A value for criteria code that will be used to match people with Service Orders or Call Center Cases. |
| 7 | VISIBLE | Character(1) | VARCHAR2(1) NOT NULL |
Show Sub Page
Y/N Table Edit Default Value: N |
| 8 | CAPTURE_INT_ADD | Character(1) | VARCHAR2(1) NOT NULL |
Capture Interaction Add Mode
Y/N Table Edit Default Value: N |
| 9 | CAPTURE_UPD_MODE | Character(1) | VARCHAR2(1) NOT NULL |
Capture Interaction Update
Y/N Table Edit Default Value: N |
| 10 | OBJECT_TYPE1 | Character(4) | VARCHAR2(4) NOT NULL |
Object Type
ACCT=Accounts BILL=Bills CASE=Case INST=Installed Product INTR=Interaction ORD=Order QUO=Quotes SORD=Service Order |