RC_DFLT_CASEAGE (SQL Table)	Index Back
BU case age configuration Case Aging Date Configuration Table

RC_DFLT_CASEAGE

(SQL Table)

BU case age configuration

Case Aging Date Configuration Table

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit

2 SEQNUM Number(3,0) SMALLINT NOT NULL Sequence Number
Default Value: 1

3 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)

4 FROM_DAY Number(5,0) INTEGER NOT NULL Used for specifying a date range for the service order aging smart view.

5 TO_DAY Number(5,0) INTEGER NOT NULL Used for specifying a date range for the service order aging smart view.

6 CASE_AGE_RANGE Character(30) VARCHAR2(30) NOT NULL Field created for case age range

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit
2	SEQNUM	Number(3,0)	SMALLINT NOT NULL	Sequence Number Default Value: 1
3	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)
4	FROM_DAY	Number(5,0)	INTEGER NOT NULL	Used for specifying a date range for the service order aging smart view.
5	TO_DAY	Number(5,0)	INTEGER NOT NULL	Used for specifying a date range for the service order aging smart view.
6	CASE_AGE_RANGE	Character(30)	VARCHAR2(30) NOT NULL	Field created for case age range