Alias: TLG#

(P2K_TS_CALL_LOGS)

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


Call Logs

Table Columns#


Column nameData Type / SizeDomainMand.Notes
IDNumber(10)IDY
EEM_IDNumber(10)IDYlink to P2K_HR_EMPLOYMENTS
TTP_IDNumber(10)ID link to P2K_TS_TEAM_POSTS
CALL_STATUSVarchar2(2)X_CALL_STATUSY
CALL_FOR_DATE_FROMDate()DATEY
CALL_FOR_DATE_TODate()DATEY
CALL_FOR_TIME_FROMNumber(5)MINUTES
CALL_FOR_TIME_TONumber(5)MINUTES
CALL_PLACED_BYVarchar2(30)VARCHAR30
CALL_PLACED_DATEDate()DATE
CALL_PLACED_TIMENumber(5)MINUTES
DESCRIPTIONVarchar2(50)DESCRIPTION
CALL_RESULTVarchar2(2)X_CALL_RESULT
CREATE_DATEDate()DATEY
CREATE_USERVarchar2(30)VARCHAR30Y
CHANGE_DATEDate()DATEY
CHANGE_USERVarchar2(30)VARCHAR30Y
CALL_REASONVarchar2(2)X_CALL_REASON
TSH_IDNumber(10)ID link to P2K_TS_SCHEDULED_SHIFTS
TTX_IDNumber(10)ID link to P2K_TS_TIME_EXCEPTIONS
COMMENTSVarchar2(4000)VARCHAR4000Y

User Fields: Allowed
Audit Logging: Allowed


Notes #

Click to create a new notes page