TIME_SHEET_IDVERSION_NUMDefault Value: 1
LINE_NBRDATE_UNDER_RPTMHR=Muti Hourly
PER=Percentage
SQF=Square Footage
Default Value: MHR
Prompt Table: UNITS_TBL
Default Value: %datetime
EX_TIME_DTL_DLY(SQL Table) |
Index Back |
|---|---|
Time Report Detail DailyThe Daily Time recordings for the EX_TIME_DTL record |
| # | 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 | LINE_NBR |
Number(5,0) | INTEGER NOT NULL | Line Number: 11/24/08 - Added TARGET label [PC product] |
| 4 | DATE_UNDER_RPT |
Date(10) | DATE NOT NULL | Date Under Report |
| 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 Default Value: MHR Prompt Table: UNITS_TBL |
| 7 | LASTUPDDTTM | DateTime(26) | TIMESTAMP |
Specifies the date and time of the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.
Default Value: %datetime |