ST_INSTANCEEMPLIDEMPL_RCDRT_SOURCEAM=Absence Management
MD=Mobile Device
ONL=Online
SCH=Schedule Source
SYS=Time and Labor System
TCD=Time Collection Device
THE_DATERTIME_TYPEE=Elapsed Time
P=Punch Time
TL_ST_DELETES(SQL Table) |
Index Back |
|---|
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | ST_INSTANCE |
Number(10,0) | DECIMAL(10) NOT NULL | Session Number |
| 2 | EMPLID |
Character(11) | VARCHAR2(11) NOT NULL | Employee ID |
| 3 | EMPL_RCD |
Number(3,0) | SMALLINT NOT NULL | Empl Rcd Nbr |
| 4 | RT_SOURCE |
Character(3) | VARCHAR2(3) NOT NULL |
Reported Time Source. the originator of Reported Time
AM=Absence Management MD=Mobile Device ONL=Online SCH=Schedule Source SYS=Time and Labor System TCD=Time Collection Device |
| 5 | THE_DATE |
Date(10) | DATE | Date |
| 6 | RTIME_TYPE |
Character(1) | VARCHAR2(1) NOT NULL |
Reported Time Type
E=Elapsed Time P=Punch Time |
| 7 | TRC | Character(5) | VARCHAR2(5) NOT NULL | Time Reporting Code used to report time in Time and Labor |