TIME_SHEET_IDVERSION_NUMB=Billable
I=Internal
P=Personal
U=Nonbillable
Default Value: B
MHR=Muti Hourly
PER=Percentage
SQF=Square Footage
Prompt Table: UNITS_TBL
EX_TMDTL_RPT_VW(SQL View) |
Index Back |
|---|---|
Time Report Detail ViewUsed for HTML report of Time Report. |
| SELECT A.TIME_SHEET_ID , A.VERSION_NUM , %subrec(EX_PROJFLDS_02, A) , A.BILLING_ACTION , SUM(B.TIME_QUANTITY) , B.UNIT_OF_MEASURE FROM PS_EX_TIME_DTL A ,PS_EX_TIME_DTL_DLY B WHERE A.TIME_SHEET_ID = B.TIME_SHEET_ID AND A.VERSION_NUM = B.VERSION_NUM AND A.LINE_NBR = B.LINE_NBR GROUP BY A.TIME_SHEET_ID, A.VERSION_NUM, %subrec(EX_PROJFLDS_02, A), A.BILLING_ACTION , B.UNIT_OF_MEASURE |
| # | 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 | BUSINESS_UNIT_PC | Character(5) | VARCHAR2(5) NOT NULL | PC Business Unit |
| 4 | PROJECT_ID | Character(15) | VARCHAR2(15) NOT NULL | Project Id ChartField |
| 5 | ACTIVITY_ID | Character(15) | VARCHAR2(15) NOT NULL | Activity ID |
| 6 | RESOURCE_CATEGORY | Character(5) | VARCHAR2(5) NOT NULL | Category |
| 7 | RESOURCE_TYPE | Character(5) | VARCHAR2(5) NOT NULL | Source Type |
| 8 | RESOURCE_SUB_CAT | Character(5) | VARCHAR2(5) NOT NULL | Subcategory |
| 9 | BILLING_ACTION | Character(1) | VARCHAR2(1) NOT NULL |
Billing Action
B=Billable I=Internal P=Personal U=Nonbillable Default Value: B |
| 10 | TIME_QUANTITY | Signed Number(16,2) | DECIMAL(14,2) NOT NULL | Time Quantity |
| 11 | UNIT_OF_MEASURE | Character(3) | VARCHAR2(3) NOT NULL |
Used on an approval rule set.
MHR=Muti Hourly PER=Percentage SQF=Square Footage Prompt Table: UNITS_TBL |