TIME_SHEET_IDLINE_NBRSPA_TRC_BRK2_VW(SQL View) |
Index Back |
|---|---|
Time Report Detail Hourly ViewChild table of SPA_TIM_DTL_DLY, used to breakout daily hours by TRC code. View used to display TRC breakdown. |
| SELECT TIME_SHEET_ID ,LINE_NBR ,DATE_UNDER_RPT ,TRC ,SP_TIME_QTY FROM PS_SPA_TM_DTL_HRLY |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | TIME_SHEET_ID |
Character(10) | VARCHAR2(10) NOT NULL | Time Sheet Unique Identifier (System Generated) |
| 2 | LINE_NBR |
Number(5,0) | INTEGER NOT NULL | Line Number: 11/24/08 - Added TARGET label [PC product] |
| 3 | DATE_UNDER_RPT | Date(10) | DATE | Date Under Report |
| 4 | TRC | Character(5) | VARCHAR2(5) NOT NULL | Time Reporting Code |
| 5 | SP_TIME_QTY | Signed Number(18,4) | DECIMAL(16,4) NOT NULL | Time Quantity |