TIME_SHEET_IDPrompt Table: EX_TRC_MAP_VW
MHR=Muti Hourly
PER=Percentage
SQF=Square Footage
Prompt Table: UNITS_TBL
EX_TMPOL_ADJ_VW(SQL View) |
Index Back |
|---|---|
Time Policy Adjustment View |
| SELECT A.TIME_SHEET_ID , A.VERSION_NUM , B.DATE_UNDER_RPT , A.TRC , B.TIME_QUANTITY , B.UNIT_OF_MEASURE FROM PS_EX_TIME_POL A , PS_EX_TIME_POL_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 AND A.VERSION_NUM > 1 |
| # | 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 | TRC | Character(5) | VARCHAR2(5) NOT NULL |
Time Reporting Code
Prompt Table: EX_TRC_MAP_VW |
| 5 | TIME_QUANTITY | Signed Number(16,2) | DECIMAL(14,2) NOT NULL | Time Quantity |
| 6 | 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 |