PTSF_DBOARD_DTL(SQL Table) |
Index Back |
---|---|
Insight Details |
# | 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 | ATTACHSYSFILENAME | Character(128) | VARCHAR2(128) NOT NULL | File Name |
4 | PTSF_UPLOAD_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Upload Status
F=Failed S=Successful |
5 | LAST_UPDATE_DTTM | 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. |
6 | PTSF_DEPLOY_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Deploy Status
D=Deployed F=Deploy failed U=Undeployed |
7 | PTSF_KIBDB_RTIME | Character(1) | VARCHAR2(1) NOT NULL | Restore Time |
8 | PTSF_KIBDB_FTIME | Character(100) | VARCHAR2(100) NOT NULL | From Time |
9 | PTSF_KIBDB_TTIME | Character(100) | VARCHAR2(100) NOT NULL | To Time |
10 | PTSF_DBTIMEFILTER | Character(1) | VARCHAR2(1) NOT NULL |
Hide Time Filter
Y/N Table Edit |
11 | PTSF_CHECKBOX | Character(1) | VARCHAR2(1) NOT NULL |
Select
Y/N Table Edit Default Value: Y |
12 | PTSF_MSGTEXTLONG | Long Character | CLOB | Field used to display search status |