TIME_SHEET_IDVERSION_NUMDefault Value: 1
LINE_NBRDATE_UNDER_RPTMHR=Muti Hourly
PER=Percentage
SQF=Square Footage
Default Value: MHR
Prompt Table: UNITS_TBL
EX_TIME_DLY_VW(SQL View) |
Index Back |
|---|---|
EX_TIME_DLY_VWTime report detail daily view, used to check dupliicate date under report. |
| SELECT h.time_sheet_id , h.version_num ,h.emplid , d.line_nbr , d.date_under_rpt , d.time_quantity , d.unit_of_measure FROM PS_EX_TIME_HDR_VW2 h , ps_ex_time_dtl_dly d WHERE h.time_sheet_id = d.time_sheet_id AND h.version_num = d.version_num |
| # | 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
Default Value: 1 |
| 3 | EMPLID | Character(11) | VARCHAR2(11) NOT NULL | Employee ID |
| 4 | LINE_NBR |
Number(5,0) | INTEGER NOT NULL | Line Number: 11/24/08 - Added TARGET label [PC product] |
| 5 | DATE_UNDER_RPT |
Date(10) | DATE | Date Under Report |
| 6 | TIME_QUANTITY | Signed Number(16,2) | DECIMAL(14,2) NOT NULL | Time Quantity |
| 7 | UNIT_OF_MEASURE | Character(3) | VARCHAR2(3) NOT NULL |
Used on an approval rule set.
MHR=Muti Hourly PER=Percentage SQF=Square Footage Default Value: MHR Prompt Table: UNITS_TBL |