Alias: TCE#

(P2K_TS_CLOCK_ENTRIES)

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

Clock Entries

Table Columns#

Column name	Data Type / Size	Domain	Mand.	Notes
ID	Number(10)	ID	Y
EEM_ID	Number(10)	ID	Y	link to P2K_HR_EMPLOYMENTS
DDP_ID	Number(10)	ID		link to P2K_CM_DEPARTMENTS
TCC_ID	Number(10)	ID		link to P2K_TS_CLOCK_CARDS
TCD_ID	Number(10)	ID		link to P2K_TS_CLOCK_DEVICES
DJB_ID	Number(10)	ID		link to P2K_CM_JOBS
DCC_ID	Number(10)	ID		link to P2K_CM_COST_CENTERS
DTC_ID	Number(10)	ID		link to P2K_CM_TIME_CODES
CLOCK_ENTRY_TYPE	Varchar2(2)	X_CLOCK_ENTRY_TYPE	Y
CLOCK_ENTRY_STATUS	Varchar2(2)	X_CLOCK_ENTRY_STATUS	Y
CLOCK_ENTRY_SOURCE	Varchar2(2)	X_CLOCK_ENTRY_SOURCE	Y
ORIGINAL_CLOCK_DATE	Date()	DATE	Y
ORIGINAL_CLOCK_TIME	Number(5)	MINUTES	Y
CLOCK_ENTRY_TIMESTAMP	Date()	TIMESTAMP
ADJUSTED_CLOCK_DATE	Date()	DATE
ADJUSTED_CLOCK_TIME	Number(5)	MINUTES
CLOCK_ENTRY_VALUE	Number(18)	AMT12V6
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
TTX_ID	Number(10)	ID		link to P2K_TS_TIME_EXCEPTIONS
DPS_ID	Number(10)	ID		link to P2K_CM_POSITIONS
AUTHORIZATION_STATUS	Varchar2(2)	X_AUTHORIZATION_STATUS
CAPTURE_MODE	Varchar2(1)	X_CAPTURE_MODE
UNIVERSAL_TIME	Date()	TIMESTAMP
TRT_ID	Number(10)	ID		link to P2K_TS_TIME_RULE_TYPES
DTC_ID_CHOSEN	NUMBER(10,0)	ID

Derived Fields#

Column Name
DDP_ID_DRV
DRV_APPROVAL_BAR
DRV_EE_PUNCH_STATUS
DRV_PERSON_CODE
DRV_PIN
DRV_SORT_ORDER

User Fields: Allowed
Audit Logging: Allowed

---

Notes #

Click to create a new notes page