TIME_SHEET_IDB=Billable
I=Internal
P=Personal
U=Nonbillable
MHR=Muti Hourly
PER=Percentage
SQF=Square Footage
Prompt Table: UNITS_TBL
EX_TMDTL_ADJ_VW(SQL View) |
Index Back |
|---|---|
Time Detail Adjustment View |
| SELECT A.TIME_SHEET_ID , A.VERSION_NUM , B.DATE_UNDER_RPT , %subrec(EX_PROJFLDS_02, A) , A.BILLING_ACTION , B.TIME_QUANTITY , B.UNIT_OF_MEASURE , A.COMMENTS 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 |
| # | 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 | DATE_UNDER_RPT | Date(10) | DATE | Date Under Report |
| 4 | BUSINESS_UNIT_PC | Character(5) | VARCHAR2(5) NOT NULL | PC Business Unit |
| 5 | PROJECT_ID | Character(15) | VARCHAR2(15) NOT NULL | Project Id ChartField |
| 6 | ACTIVITY_ID | Character(15) | VARCHAR2(15) NOT NULL | Activity ID |
| 7 | RESOURCE_CATEGORY | Character(5) | VARCHAR2(5) NOT NULL | Category |
| 8 | RESOURCE_TYPE | Character(5) | VARCHAR2(5) NOT NULL | Source Type |
| 9 | RESOURCE_SUB_CAT | Character(5) | VARCHAR2(5) NOT NULL | Subcategory |
| 10 | BILLING_ACTION | Character(1) | VARCHAR2(1) NOT NULL |
Billing Action
B=Billable I=Internal P=Personal U=Nonbillable |
| 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 Prompt Table: UNITS_TBL |
| 13 | COMMENTS | Long Character | CLOB | Comment |