P 2 K_TS_CALL_LOGS
Back to current versionRestore this version

Alias: TLG#

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

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

User Fields: Allowed
Audit Logging: Allowed