P 2 K_TS_TIME_ENTRIES
Back to current versionRestore this version

Alias: TTE#

(P2K_TS_TIME_ENTRIES)

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


Time Entries

Table Columns#


Column nameData Type / SizeDomainMand.Notes
IDNumber(10)IDY
TBT_IDNumber(10)ID link to P2K_TS_TIME_BATCHES
EAS_IDNumber(10)ID link to P2K_HR_ASSIGNMENTS
DWR_IDNumber(10)ID link to P2K_CM_WORK_RULES
DTC_IDNumber(10)ID link to P2K_CM_TIME_CODES
TTP_IDNumber(10)ID link to P2K_TS_TEAM_POSTS
TSS_IDNumber(10)ID link to P2K_TS_SHIFTS
TTX_IDNumber(10)ID link to P2K_TS_TIME_EXCEPTIONS
TCE_ID_INNumber(10)ID link to P2K_TS_CLOCK_ENTRIES
TCE_ID_OUTNumber(10)ID link to P2K_TS_CLOCK_ENTRIES
DJB_IDNumber(10)ID link to P2K_CM_JOBS
DCC_IDNumber(10)ID link to P2K_CM_COST_CENTERS
DDP_IDNumber(10)ID link to P2K_CM_DEPARTMENTS
DPS_IDNumber(10)ID link to P2K_CM_POSITIONS
AAL_IDNumber(10)ID link to P2K_AT_LEAVE_LINES
TIME_ENTRY_STATUSVarchar2(2)X_TIME_ENTRY_STATUSY
TIME_ENTRY_TYPEVarchar2(2)X_TIME_ENTRY_TYPEY
START_DATEDate()DATEY
END_DATEDate()DATEY
START_TIMENumber(5)MINUTES
END_TIMENumber(5)MINUTES
WSENumber(9)AMT5V4
TIME_ENTRY_VALUENumber(18)AMT12V6
CLOCK_TIME_TYPEVarchar2(2)X_CLOCK_TIME_TYPE
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
WORK_ORDERVarchar2(50)VARCHAR50
TSH_IDNumber(10)ID link to P2K_TS_SCHEDULED_SHIFTS
TSR_IDNumber(10)ID link to P2K_TS_STATION_REQUIREMENTS
TES_IDNumber(10)ID link to P2K_TS_EVENT_SITES

User Fields: Allowed
Audit Logging: Not 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