SPR_PAGE_CODESPR_PAGE_CD_TBL(SQL Table) |
Index Back |
|---|---|
sPro Analysis-Page Code SetupsPro Analysis-Page Code Setup Table for defining charting parameters |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | SPR_PAGE_CODE |
Character(3) | VARCHAR2(3) NOT NULL | Analysis Page Code |
| 2 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
| 3 | SPR_GRAPH_FIELD | Character(34) | VARCHAR2(34) NOT NULL | Chart Field Name |
| 4 | SPR_GRAPH_RECORD | Character(15) | VARCHAR2(15) NOT NULL | Graph Record |
| 5 | SPR_GRID_RECORD | Character(15) | VARCHAR2(15) NOT NULL | Grid record parameter for sPro Analysis Page Code Setup table |
| 6 | SPR_GRAPH_TITLE | Number(4,0) | SMALLINT NOT NULL | Chart Title |
| 7 | SPR_X_FIELD | Character(34) | VARCHAR2(34) NOT NULL | X Axis chart field |
| 8 | SPR_X_TITLE | Number(4,0) | SMALLINT NOT NULL | X Title |
| 9 | SPR_Y_FIELD | Character(34) | VARCHAR2(34) NOT NULL | Y Axis chart field |
| 10 | SPR_Y_TITLE | Number(3,0) | SMALLINT NOT NULL | Y Title |
| 11 | SPR_SERIES_FIELD | Character(34) | VARCHAR2(34) NOT NULL | sPro Data Series Field |
| 12 | SPR_OVERLAY_FIELD | Character(34) | VARCHAR2(34) NOT NULL | Overlay Data Field |
| 13 | SPR_GRAPH_TYPE | Number(2,0) | SMALLINT NOT NULL | Chart Type |
| 14 | SPR_GRAPH_O_TITLE | Number(3,0) | SMALLINT NOT NULL | Overlay Title |
| 15 | SPR_TRANSFER_MENU | Character(32) | VARCHAR2(32) NOT NULL | Transfer Menu |
| 16 | SPR_TRANSFER_BAR | Character(32) | VARCHAR2(32) NOT NULL | Transfer Barname |
| 17 | SPR_TRANSFER_ITEM | Character(32) | VARCHAR2(32) NOT NULL | Transfer Item |
| 18 | SPR_TRANSFER_PAGE | Character(32) | VARCHAR2(32) NOT NULL | Item Name |
| 19 | SPB_PREF_RECORD | Character(15) | VARCHAR2(15) NOT NULL | Preference Recrod |
| 20 | DIMENSION_ID | Character(30) | VARCHAR2(30) NOT NULL | Dimension/Measure/Attribute |