P 2 K_TS_CLOCK_ENTRIES
Back to current versionRestore this version

Alias: TCE#

Unique Keys: _
Child Table: _
Parent Table: _

Clock Entries

Table Columns#


Column nameData Type / SizeDomainMand.Notes
IDNumber(10)IDY
EEM_IDNumber(10)IDYlink to P2K_HR_EMPLOYMENTS
DDP_IDNumber(10)ID link to P2K_CM_DEPARTMENTS
TCC_IDNumber(10)ID link to P2K_TS_CLOCK_CARDS
TCD_IDNumber(10)ID link to P2K_TS_CLOCK_DEVICES
DJB_IDNumber(10)ID link to P2K_CM_JOBS
DCC_IDNumber(10)ID link to P2K_CM_COST_CENTERS
DTC_IDNumber(10)ID link to P2K_CM_TIME_CODES
CLOCK_ENTRY_TYPEVarchar2(2)X_CLOCK_ENTRY_TYPEY
CLOCK_ENTRY_STATUSVarchar2(2)X_CLOCK_ENTRY_STATUSY
CLOCK_ENTRY_SOURCEVarchar2(2)X_CLOCK_ENTRY_SOURCEY
ORIGINAL_CLOCK_DATEDate()DATEY
ORIGINAL_CLOCK_TIMENumber(5)MINUTESY
CLOCK_ENTRY_TIMESTAMPDate()TIMESTAMP
ADJUSTED_CLOCK_DATEDate()DATE
ADJUSTED_CLOCK_TIMENumber(5)MINUTES
CLOCK_ENTRY_VALUENumber(18)AMT12V6
REASON_FOR_TIMEVarchar2(2)X_REASON_FOR_TIME
DISTRIBUTION_MASKVarchar2(50)DISTRIBUTION
REFERENCE_INFOVarchar2(2000)VARCHAR2000
AUDIT_TEXTVarchar2(4000)VARCHAR4000
CREATE_DATEDate()DATEY
CREATE_USERVarchar2(30)VARCHAR30Y
CHANGE_DATEDate()DATEY
CHANGE_USERVarchar2(30)VARCHAR30Y
TTX_IDNumber(10)ID link to P2K_TS_TIME_EXCEPTIONS
DPS_IDNumber(10)ID link to P2K_CM_POSITIONS
AUTHORIZATION_STATUSVarchar2(2)X_AUTHORIZATION_STATUS
CAPTURE_MODEVarchar2(1)X_CAPTURE_MODE
UNIVERSAL_TIMEDate()TIMESTAMP
TRT_IDNumber(10)ID link to P2K_TS_TIME_RULE_TYPES

User Fields: Allowed
Audit Logging: Allowed

Screen captures are meant to be indicative of the concept being presented and may not reflect the current screen design.
If you have any comments or questions please email the Wiki Editor

All content © High Line Corporation