Wiki: P 2 K_TS_TIME

Alias: TTE#

(P2K_TS_TIME_ENTRIES)

Unique Keys:
Child Table:
Parent Table:
ERD: ERD-TS30

Time Entries

Column name	Data Type / Size	Domain	Mand.	Notes
ID	Number(10)	ID	Y
TBT_ID	Number(10)	ID		link to P2K_TS_TIME_BATCHES
EAS_ID	Number(10)	ID		link to P2K_HR_ASSIGNMENTS
DWR_ID	Number(10)	ID		link to P2K_CM_WORK_RULES
DTC_ID	Number(10)	ID		link to P2K_CM_TIME_CODES
TTP_ID	Number(10)	ID		link to P2K_TS_TEAM_POSTS
TSS_ID	Number(10)	ID		link to P2K_TS_SHIFTS
TTX_ID	Number(10)	ID		link to P2K_TS_TIME_EXCEPTIONS
TCE_ID_IN	Number(10)	ID		link to P2K_TS_CLOCK_ENTRIES
TCE_ID_OUT	Number(10)	ID		link to P2K_TS_CLOCK_ENTRIES
DJB_ID	Number(10)	ID		link to P2K_CM_JOBS
DCC_ID	Number(10)	ID		link to P2K_CM_COST_CENTERS
DDP_ID	Number(10)	ID		link to P2K_CM_DEPARTMENTS
DPS_ID	Number(10)	ID		link to P2K_CM_POSITIONS
AAL_ID	Number(10)	ID		link to P2K_AT_LEAVE_LINES
TIME_ENTRY_STATUS	Varchar2(2)	X_TIME_ENTRY_STATUS	Y
TIME_ENTRY_TYPE	Varchar2(2)	X_TIME_ENTRY_TYPE	Y
START_DATE	Date()	DATE	Y
END_DATE	Date()	DATE	Y
START_TIME	Number(5)	MINUTES
END_TIME	Number(5)	MINUTES
WSE	Number(9)	AMT5V4
TIME_ENTRY_VALUE	Number(18)	AMT12V6
CLOCK_TIME_TYPE	Varchar2(2)	X_CLOCK_TIME_TYPE
REASON_FOR_TIME	Varchar2(2)	X_REASON_FOR_TIME
DISTRIBUTION_MASK	Varchar2(50)	DISTRIBUTION
REFERENCE_INFO	Varchar2(2000)	VARCHAR2000
AUDIT_TEXT	Varchar2(4000)	VARCHAR4000
CREATE_DATE	Date()	DATE	Y
CREATE_USER	Varchar2(30)	VARCHAR30	Y
CHANGE_DATE	Date()	DATE	Y
CHANGE_USER	Varchar2(30)	VARCHAR30	Y
WORK_ORDER	Varchar2(50)	VARCHAR50
TSH_ID	Number(10)	ID		link to P2K_TS_SCHEDULED_SHIFTS
TSR_ID	Number(10)	ID		link to P2K_TS_STATION_REQUIREMENTS
TES_ID	Number(10)	ID		link to P2K_TS_EVENT_SITES
TWS_ID	Number(10)	ID		link to P2K_TS_STATION_REQUIREMENTS

Column Name
DRV_IS_IN
DRV_IS_OUT

User Fields: Allowed
Audit Logging: Not Allowed