| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 ART_REPORT_ID |
Character(18) |
VARCHAR2(18) NOT NULL |
ART Report ID
|
| 2 |
ART_CHART_TYPE |
Character(2) |
VARCHAR2(2) NOT NULL |
Chart Type
0=2D Bar Chart
1=2D Stacked Bar Chart
10=2D Horizontal Percent Chart
11=3D Percent Bar Chart
13=2D Horizontal Bar Chart
2=2D Percent Bar Chart
3=2DStacked Horizontal Bar Chart
4=2D Line Chart
5=2D Histogram Chart
6=2D Pie Chart
7=3D Bar Chart
8=3D Stacked Bar Chart
9=3D Pie Chart
Default Value: 0
|
| 3 |
ART_CHART_HEIGHT |
Number(3,0) |
SMALLINT NOT NULL |
Analysis Rendering Tool Chart Height
Default Value: 200
|
| 4 |
ART_CHART_WIDTH |
Number(4,0) |
SMALLINT NOT NULL |
ART: Chart Width
Default Value: 200
|
| 5 |
ART_DATA_WIDTH |
Number(3,0) |
SMALLINT NOT NULL |
Data Width
Default Value: 10
|
| 6 |
ART_METRIC_STYLE |
Character(1) |
VARCHAR2(1) NOT NULL |
Metric Style
M=Multiple Metric
S=Single Metric
Default Value: S
|
| 7 |
ART_CHARLOAD_STYLE |
Character(1) |
VARCHAR2(1) NOT NULL |
Analysis Rendering Tool Chart Loading Styles
A=Alternate - Column Based Load
S=Standard - Row Based Load
Default Value: S
|
| 8 |
ART_METRIC_COUNT |
Character(1) |
VARCHAR2(1) NOT NULL |
Number of Metrics
2=2 Metrics
3=3 Metrics
4=4 Metrics
Default Value: 2
|
| 9 |
ART_X_FIELD |
Character(18) |
VARCHAR2(18) NOT NULL |
X Dimension Field Name
Prompt Table:
ART_FIELD_SEQ
|
| 10 |
ART_X_LABEL_ANGLE |
Number(3,0) |
SMALLINT NOT NULL |
X Label Angle
Default Value: 0
|
| 11 |
X_MESSAGE_SET_NBR |
Number(5,0) |
INTEGER NOT NULL |
Message Set Number. This field refers to the Message Set Number in the Message Catalog.
|
| 12 |
X_MESSAGE_NBR |
Number(5,0) |
INTEGER NOT NULL |
Message Number. This field refers to the Message Number in the Message Catalog.
|
| 13 |
ART_Y1_FIELD |
Character(18) |
VARCHAR2(18) NOT NULL |
Y Dimension Field Name
Prompt Table:
ART_FIELD_SEQ
|
| 14 |
ART_Y_LABEL_ANGLE |
Number(3,0) |
SMALLINT NOT NULL |
Y Label Angle
Default Value: 0
|
| 15 |
Y_MESSAGE_SET_NBR |
Number(5,0) |
INTEGER NOT NULL |
Message Set Number. This field refers to the Message Set Number in the Message Catalog.
|
| 16 |
Y_MESSAGE_NBR |
Number(5,0) |
INTEGER NOT NULL |
Message Number. This field refers to the Message Number in the Message Catalog.
|
| 17 |
ART_SERIES_FIELD |
Character(18) |
VARCHAR2(18) NOT NULL |
Chart Series Field
Prompt Table:
ART_FIELD_SEQ
|
| 18 |
ART_Y2_FIELD |
Character(18) |
VARCHAR2(18) NOT NULL |
Y Dimension Field Name
Prompt Table:
ART_FIELD_SEQ
|
| 19 |
ART_Y3_FIELD |
Character(18) |
VARCHAR2(18) NOT NULL |
Y3 Dimension Field Name
Prompt Table:
ART_FIELD_SEQ
|
| 20 |
ART_Y4_FIELD |
Character(18) |
VARCHAR2(18) NOT NULL |
Y3 Dimension Field Name
Prompt Table:
ART_FIELD_SEQ
|
| 21 |
ART_LEGEND_POS |
Character(1) |
VARCHAR2(1) NOT NULL |
Legend Position
0=%ChartLegend_Left
1=%ChartLegend_Right
2=%ChartLegend_Top
3=%ChartLegend_Bottom
N=No Legend
Default Value: N
|
| 22 |
ART_TITLE_FIELD |
Character(18) |
VARCHAR2(18) NOT NULL |
Primary Field
Prompt Table:
ART_FIELD_SEQ
|
| 23 |
ART_AUTOSIZE |
Character(1) |
VARCHAR2(1) NOT NULL |
Automatically Set Size
A=Automatic
M=Manual
Default Value: A
|
| 24 |
ART_IMAGE_TYPE |
Character(1) |
VARCHAR2(1) NOT NULL |
Image Type
F=Source Field
I=Image ID
N=No Image
U=URL
Default Value: I
|
| 25 |
ART_IMAGE_FLD |
Character(18) |
VARCHAR2(18) NOT NULL |
Image Field
Prompt Table:
ART_FIELD_SEQ
|
| 26 |
IMAGE_NAME |
Character(30) |
VARCHAR2(30) NOT NULL |
The name of images used in Personalizations explanations.
|
| 27 |
URL |
Character(254) |
VARCHAR2(254) NOT NULL |
Internet URL (Universal Resource Locator)
|
| 28 |
ART_NAV_URL |
Character(30) |
VARCHAR2(30) NOT NULL |
Navigation URL
Prompt Table:
PSURLDEFN
|
| 29 |
ART_CHART_COLOR |
Character(2) |
VARCHAR2(2) NOT NULL |
Chart Color
0=%ChartColor_Black
1=%ChartColor_Blue
10=%ChartColor_Red
11=%ChartColor_White
12=%ChartColor_Yellow
13=%ChartColor_Red_Orange
14=%ChartColor_Yellow_Green
15=%ChartColor_Blue_Violet
16=%ChartColor_Purple
17=%ChartColor_Yellow_Orange
2=%ChartColor_Cyan
3=%ChartColor_DarkGray
4=%ChartColor_Gray
5=%ChartColor_Green
6=%ChartColor_LightGray
7=%ChartColor_Magenta
8=%ChartColor_Orange
9=%ChartColor_Pink
Default Value: 1
|
| 30 |
ART_NAV_LOC |
Character(1) |
VARCHAR2(1) NOT NULL |
Navigation Location
E=External - URL
I=Internal - CREF
N=No Navigation
Default Value: N
|
| 31 |
ART_NAV_PORTAL |
Character(30) |
VARCHAR2(30) NOT NULL |
Navigation Portal
|
| 32 |
ART_NAV_CREF |
Character(30) |
VARCHAR2(30) NOT NULL |
Navigation CREF
|