RB_CHART_2

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	OPRID	Character(30)	VARCHAR2(30) NOT NULL	A user's ID (see PSOPRDEFN).
2	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit Prompt Table: SP_BU_FS_NONVW
3	APPLICATION_OWNER	Character(4)	VARCHAR2(4) NOT NULL	Describes the Card or Chart Owner (i.e. RC, RO etc.) This field was originally designed to be used for Electronic Cards, but has been expanded to include other applications, such as Charts. RC=Call Center RF=FieldService RO=Order Capture RY=Online Marketing
4	SEQNUM	Number(3,0)	SMALLINT NOT NULL	Sequence Number Prompt Table: RB_CHART_SETUP
5	RC_CHART_TIME_AMT	Number(3,0)	SMALLINT NOT NULL	Field contains the amount of time to chart for a graph. Default Value: 1
6	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) Default Value: D
7	RC_CHART_LOW	Number(6,0)	INTEGER NOT NULL	This field is used to store the user value for the "Low" gauge, which is used for Charting. Default Value: 25
8	RC_CHART_MID	Number(6,0)	INTEGER NOT NULL	This field is used to store the user value for the "Mid" gauge, which is used for Charting. Default Value: 50
9	RC_CHART_HIGH	Number(6,0)	INTEGER NOT NULL	This field is used to store the user value for the "High" gauge, which is used for Charting. Default Value: 75
10	RC_CHART_TYPE	Character(1)	VARCHAR2(1) NOT NULL	This field is used by the user to turn on and off the Summary and Detail Charts. B=Summary and Detail Chart D=Detail Chart Only S=Summary Chart Only Default Value: B