TL_DSHBD_CHART(SQL Table) |
Index Back |
|---|---|
TL Mgr Dashboard Chart Rec |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | TL_INTERVAL_VAL | Number(6,0) | INTEGER NOT NULL | Interval Value |
| 2 | TRC | Character(5) | VARCHAR2(5) NOT NULL | Time Reporting Code used to report time in Time and Labor |
| 3 | TRC_SUM_CATEGORY | Character(6) | VARCHAR2(6) NOT NULL | TRC Category |
| 4 | START_DT | Date(10) | DATE | Start Date |
| 5 | END_DT | Date(10) | DATE | end date |
| 6 | NAME_DISPLAY | Character(50) | VARCHAR2(50) NOT NULL | Display Name - name formatted for Display based on the Country |
| 7 | EMPLID | Character(11) | VARCHAR2(11) NOT NULL | Employee ID |
| 8 | EMPL_RCD | Number(3,0) | SMALLINT NOT NULL | Empl Record |
| 9 | TL_QUANTITY1 | Signed Number(20,6) | DECIMAL(18,6) NOT NULL | Quantity |
| 10 | TL_QUANTITY2 | Signed Number(20,6) | DECIMAL(18,6) NOT NULL | Quantity |
| 11 | TL_RECORD_SRC | Character(2) | VARCHAR2(2) NOT NULL |
Record Source
A=All Sources AP=Approved Time D=Scheduled to Date P=Payable Time R=Reported Time S=Scheduled Time SD=Scheduled to Date ST=Scheduled Time |
| 12 | TL_X_AXIS_LBL | Character(30) | VARCHAR2(30) NOT NULL | X-Axis Label |
| 13 | TL_Y_AXIS_LBL | Character(30) | VARCHAR2(30) NOT NULL | Y-Axis Label |
| 14 | TL_Y_AXIS_VALUE | Signed Number(20,6) | DECIMAL(18,6) NOT NULL | Y-Axis Value |
| 15 | TL_CHT_GROUP_VAL | Character(20) | VARCHAR2(20) NOT NULL | Group By |
| 16 | TL_CHT_GROUP_DESCR | Character(30) | VARCHAR2(30) NOT NULL | Group |
| 17 | TL_CHT_SERIES_VAL | Character(60) | VARCHAR2(60) NOT NULL | Chart Series Value |
| 18 | TL_CHT_SERIES_DESC | Character(30) | VARCHAR2(30) NOT NULL | Series Description |
| 19 | TL_CHARTCOLOR | Number(3,0) | SMALLINT NOT NULL | Chart Color |
| 20 | TL_CHAR_VALUE | Character(30) | VARCHAR2(30) NOT NULL | Character Value |
| 21 | TL_HOVERTEXT | Character(80) | VARCHAR2(80) NOT NULL | Hovertext |