TIME_SHEET_IDVERSION_NUMLINE_NBREX_TR_DTL_HVW2(SQL View) |
Index Back |
|---|---|
Time Report Detail ViewUsed for Fluid Approvals |
| SELECT TIME_SHEET_ID ,VERSION_NUM ,LINE_NBR ,DATE_UNDER_RPT , BUSINESS_UNIT_GL ,BUSINESS_UNIT_PC , DESCR100 , DESCR100A , TYPE_RTB ,TIME_QUANTITY FROM PS_EX_TR_DTL_HVW ORDER BY TIME_SHEET_ID ,VERSION_NUM ,DATE_UNDER_RPT ,TYPE_RTB ,BUSINESS_UNIT_PC ,DESCR100 ,DESCR100A |
| # | 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 | VERSION_NUM |
Number(3,0) | SMALLINT NOT NULL | Version Number |
| 3 | LINE_NBR |
Number(5,0) | INTEGER NOT NULL | Line Number: 11/24/08 - Added TARGET label [PC product] |
| 4 | DATE_UNDER_RPT | Date(10) | DATE | Date Under Report |
| 5 | BUSINESS_UNIT_GL | Character(5) | VARCHAR2(5) NOT NULL | GL Business Unit |
| 6 | BUSINESS_UNIT_PC | Character(5) | VARCHAR2(5) NOT NULL | PC Business Unit |
| 7 | DESCR100 | Character(100) | VARCHAR2(100) NOT NULL | Length 100 Description |
| 8 | DESCR100A | Character(100) | VARCHAR2(100) NOT NULL | Description |
| 9 | TYPE_RTB | Character(20) | VARCHAR2(20) NOT NULL | Type |
| 10 | TIME_QUANTITY | Signed Number(16,2) | DECIMAL(14,2) NOT NULL | Time Quantity |