SETIDRC_CATEGORYSEQNUMDefault Value: 1
D=Day(s)
H=Hour(s)
M=Month(s)
Q=Quarte(s)
W=Week(s)
Y=Year(s)
RC_CASE_AGING(SQL Table) |
Index Back |
|---|---|
Service Order Aging DateCase Aging Date Configuration Table |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | SETID |
Character(5) | VARCHAR2(5) NOT NULL | This field is used to store the value of SetID on various setup tables. |
| 2 | RC_CATEGORY |
Character(5) | VARCHAR2(5) NOT NULL | CallCenter Category. Used in HD. |
| 3 | SEQNUM |
Number(3,0) | SMALLINT NOT NULL |
Sequence Number
Default Value: 1 |
| 4 | RC_CHART_TIME | Character(1) | VARCHAR2(1) NOT NULL |
This field is for defining the period of time in which to gather data for the Manager's Dashboard application.
D=Day(s) H=Hour(s) M=Month(s) Q=Quarte(s) W=Week(s) Y=Year(s) |
| 5 | FROM_DAY | Number(5,0) | INTEGER NOT NULL | Used for specifying a date range for the service order aging smart view. |
| 6 | TO_DAY | Number(5,0) | INTEGER NOT NULL | Used for specifying a date range for the service order aging smart view. |
| 7 | CASE_AGE_RANGE | Character(30) | VARCHAR2(30) NOT NULL | Field created for case age range |