EC_TILE_SETUP(SQL Table) |
Index Back |
|---|
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  EC_HOME_TILE_ID |
Character(30) | VARCHAR2(30) NOT NULL | Tile ID |
| 2 | EC_TILE_CONTENT | Character(1) | VARCHAR2(1) NOT NULL |
Tile Content Options
1=Image 2=Chart 3=Data-1-KPI 4=HTML Area 5=Chart & KPI 6=Data-2-KPIs Default Value: 1 |
| 3 | PACKAGEROOT | Character(30) | VARCHAR2(30) NOT NULL |
Root Package ID
Prompt Table: PSPACKAGROOT_VW |
| 4 | QUALIFYPATH | Character(127) | VARCHAR2(127) NOT NULL |
Qualified Package/Class Path
Prompt Table: PSPACKAGPATH_VW |
| 5 | APPCLASSID | Character(30) | VARCHAR2(30) NOT NULL |
Application Class ID
Prompt Table: PSPACKAGCLAS_VW |
| 6 | APPCLASS_PATH | Character(254) | VARCHAR2(254) NOT NULL | Application Class Full Path |
| 7 | EC_TILE_HASCOUNT | Character(1) | VARCHAR2(1) NOT NULL |
Badge
Y/N Table Edit Default Value: Y |
| 8 | EC_TILE_LIVEDATA | Character(1) | VARCHAR2(1) NOT NULL |
Tile Live Data
Y/N Table Edit Default Value: N |
| 9 | IMAGE_NAME | Character(30) | VARCHAR2(30) NOT NULL |
The name of images used in Personalizations explanations.
Prompt Table: PSCONTVIEW |
| 10 | EC_SQLID | Character(30) | VARCHAR2(30) NOT NULL |
Transaction Count SQLID
Prompt Table: SQLID_VW |
| 11 | EC_TILE_SIZE | Character(1) | VARCHAR2(1) NOT NULL |
Tile Size
1=1x1 Tile 2=1x2 Tile 3=2x1 Tile 4=2x2 Tile |
| 12 | CLASSID | Character(30) | VARCHAR2(30) NOT NULL |
The name of the class (see PSCLASSDEFN).
Prompt Table: PSCLASSDEFN |
| 13 | OBJECTOWNERID | Character(4) | VARCHAR2(4) NOT NULL | Object owner identifier |