PTSF_VISUAL_DTL (SQL Table)	Index Back
Visualization Data Insight Visualization Data

PTSF_VISUAL_DTL

(SQL Table)

Visualization Data

Insight Visualization Data

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 PTSF_DBOARD_NAME Character(100) VARCHAR2(100) NOT NULL Dashboard Name

2 PTSF_DBOARD_ID Character(36) VARCHAR2(36) NOT NULL Dashboard ID

3 PTSF_KIB_OBJID Character(100) VARCHAR2(100) NOT NULL Object ID

4 PTSF_KIB_OBJTYP Character(2) VARCHAR2(2) NOT NULL Object Type
D=Dashboard
RD=Remove Dashboard
RV=Remove Visualization
V=Visualization

5 PTSF_VISUAL_NAME Character(254) VARCHAR2(254) NOT NULL Visualization Name

6 PTSF_DESCRLONG Long Character CLOB Summary

7 PTSF_METRIC_TYPE Character(30) VARCHAR2(30) NOT NULL Visualization Metric Type

8 PTSF_INS_STATUS Character(2) VARCHAR2(2) NOT NULL Insights Status
DP=Deployed
IM=Imported
UD=Undeployed

9 LASTUPDDTTM DateTime(26) TIMESTAMP Specifies the date and time of the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	PTSF_DBOARD_NAME	Character(100)	VARCHAR2(100) NOT NULL	Dashboard Name
2	PTSF_DBOARD_ID	Character(36)	VARCHAR2(36) NOT NULL	Dashboard ID
3	PTSF_KIB_OBJID	Character(100)	VARCHAR2(100) NOT NULL	Object ID
4	PTSF_KIB_OBJTYP	Character(2)	VARCHAR2(2) NOT NULL	Object Type D=Dashboard RD=Remove Dashboard RV=Remove Visualization V=Visualization
5	PTSF_VISUAL_NAME	Character(254)	VARCHAR2(254) NOT NULL	Visualization Name
6	PTSF_DESCRLONG	Long Character	CLOB	Summary
7	PTSF_METRIC_TYPE	Character(30)	VARCHAR2(30) NOT NULL	Visualization Metric Type
8	PTSF_INS_STATUS	Character(2)	VARCHAR2(2) NOT NULL	Insights Status DP=Deployed IM=Imported UD=Undeployed
9	LASTUPDDTTM	DateTime(26)	TIMESTAMP	Specifies the date and time of the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.