TE_MBL_DTL_VW(SQL View) |
Index Back |
|---|---|
MTE Detail View for CalendarMobile Time Entry Detail View for Calendar |
| SELECT C.EMPLID AS EMPLID , B.DATE_UNDER_RPT AS DATE_UNDER_RPT , b.TIME_SHEET_ID AS TIME_SHEET_ID , b.VERSION_NUM AS VERSION_NUM , 'Y' AS ACTIVE_FLG , B.LINE_NBR AS LINE_NBR , A.BILLING_ACTION AS BILLING_ACTION , A.BUSINESS_UNIT_PC AS BUSINESS_UNIT_PC , A.PROJECT_ID AS PROJECT_ID , A.ACTIVITY_ID AS ACTIVITY_ID , B.TIME_QUANTITY AS TIME_QUANTITY , B.UNIT_OF_MEASURE AS UNIT_OF_MEASURE FROM PS_EX_TIME_DTL A , PS_EX_TIME_DTL_DLY B , PS_EX_TIME_HDR C WHERE A.TIME_SHEET_ID = B.TIME_SHEET_ID AND A.VERSION_NUM = B.VERSION_NUM AND A.VERSION_NUM = ( SELECT MAX(A1.VERSION_NUM) FROM PS_EX_TIME_DTL A1 WHERE A1.TIME_SHEET_ID = A.TIME_SHEET_ID AND A1.LINE_NBR = A.LINE_NBR) AND A.LINE_NBR = B.LINE_NBR AND C.TIME_SHEET_ID = A.TIME_SHEET_ID AND C.VERSION_NUM = A.VERSION_NUM UNION ALL SELECT DISTINCT A.EMPLID AS EMPLID , C.DATE_UNDER_RPT AS DATE_UNDER_RPT , C.TIME_SHEET_ID AS TIME_SHEET_ID , C.VERSION_NUM AS VERSION_NUM , 'N' AS ACTIVE_FLG , C.LINE_NBR AS LINE_NBR , 'N' AS BILLING_ACTION , 'N' AS BUSINESS_UNIT_PC , 'N' AS PROJECT_ID , 'N' AS ACTIVITY_ID , C.TIME_QUANTITY AS TIME_QUANTITY , C.UNIT_OF_MEASURE AS UNIT_OF_MEASURE FROM PS_EX_TIME_HDR A , PS_EX_TIME_POL_DLY C WHERE A.TIME_SHEET_ID = C.TIME_SHEET_ID AND A.VERSION_NUM = C.VERSION_NUM AND A.VERSION_NUM = ( SELECT MAX(A1.VERSION_NUM) FROM PS_EX_TIME_HDR A1 WHERE A1.TIME_SHEET_ID = A.TIME_SHEET_ID) |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | EMPLID | Character(11) | VARCHAR2(11) NOT NULL | Employee ID |
| 2 | DATE_UNDER_RPT | Date(10) | DATE | Date Under Report |
| 3 | TIME_SHEET_ID | Character(10) | VARCHAR2(10) NOT NULL | Time Sheet Unique Identifier (System Generated) |
| 4 | VERSION_NUM | Number(3,0) | SMALLINT NOT NULL | Version Number |
| 5 | ACTIVE_FLG | Character(1) | VARCHAR2(1) NOT NULL |
Event Status
N=Inactive Y=Active |
| 6 | LINE_NBR | Number(5,0) | INTEGER NOT NULL | Line Number: 11/24/08 - Added TARGET label [PC product] |
| 7 | BILLING_ACTION | Character(1) | VARCHAR2(1) NOT NULL |
Billing Action
B=Billable I=Internal P=Personal U=Nonbillable |
| 8 | BUSINESS_UNIT_PC | Character(5) | VARCHAR2(5) NOT NULL | PC Business Unit |
| 9 | PROJECT_ID | Character(15) | VARCHAR2(15) NOT NULL | Project Id ChartField |
| 10 | ACTIVITY_ID | Character(15) | VARCHAR2(15) NOT NULL | Activity ID |
| 11 | TIME_QUANTITY | Signed Number(16,2) | DECIMAL(14,2) NOT NULL | Time Quantity |
| 12 | UNIT_OF_MEASURE | Character(3) | VARCHAR2(3) NOT NULL |
Used on an approval rule set.
MHR=Muti Hourly PER=Percentage SQF=Square Footage |