HCTS_TILESEQ_VW(SQL View) |
Index Back |
---|---|
Tile Sequence ViewTile Sequence for Employee Snapshot dashboards |
SELECT PORTAL_NAME , PORTAL_REFTYPE , PORTAL_OBJNAME , PORTAL_PRNTOBJNAME , PORTAL_LABEL , PORTAL_SEQ_NUM FROM PSPRSMDEFN |
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | Character(30) | VARCHAR2(30) NOT NULL | Portal Name (see PSPRDMDEFN). | |
2 | Character(1) | VARCHAR2(1) NOT NULL |
Portal Reference Type
C=Content F=Folder |
|
3 | Character(30) | VARCHAR2(30) NOT NULL | Portal Object Name | |
4 | PORTAL_PRNTOBJNAME | Character(30) | VARCHAR2(30) NOT NULL | Portal Parent Object Name |
5 | HCTS_TILE_TITLE | Character(30) | VARCHAR2(30) NOT NULL | Employee Snapshot Tile Title |
6 | HCTS_TILE_SEQUENCE | Number(4,0) | SMALLINT NOT NULL | Employee Snapshot Tile Sequence |