START_DTEMPLIDEMPL_RCDTRCSTATUS_FLAGSEQNUMTL_MBLE_TRCDT(SQL Table) |
Index Back |
|---|---|
TRC date for Mobile DeviceThis record contains reported time dates for a TRC. The TRC was not valid for the reported time date and the date saved in this record will be used to resent TRCs to the device based on the date in this record. |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | START_DT |
Date(10) | DATE | Start Date |
| 2 | EMPLID |
Character(11) | VARCHAR2(11) NOT NULL | Employee ID |
| 3 | EMPL_RCD |
Number(3,0) | SMALLINT NOT NULL | Empl Rcd Nbr |
| 4 | TRC |
Character(5) | VARCHAR2(5) NOT NULL | Time Reporting Code used to report time in Time and Labor |
| 5 | STATUS_FLAG |
Character(1) | VARCHAR2(1) NOT NULL | Status Flag |
| 6 | SEQNUM |
Number(3,0) | SMALLINT NOT NULL | Sequence Number |