!!!Alias: HTL
(P2K_SH_TIME_LOST_DETAILS)

Unique Keys: None\\
Parent Table: [P2K_SH_HEALTH_ISSUES]\\
\\ 
ERD: [ERD-SH35]

????????????[CLEANUP]
 
!!Table Columns
||Column name||Data Type / Size||Domain||Mand.||Notes
|[ID]|Number(10)|[ID]|Y| 
|[HHI_ID]|Number(10)|[ID]|Y|Result of [P2K_SH_HEALTH_ISSUES]
|[PPL_ID]|Number(10)|[ID]| |Recorded in [P2K_PR_PAY_LINES]
|[AAL_ID]|Number(10)|[ID]| |Recorded in [P2K_AT_LEAVE_LINES]
|[EAS_ID]|Number(10)|[ID]|Y|Related to [P2K_HR_ASSIGNMENTS]
|[TIME_CODE]|Varchar2(16)|[CODE]|Y|
|[START_DATE]|Date()|[DATE]|Y|
|[TIME_VALUE]|Number(9)|[AMT5V4|AMTnn]| |
|[TIME_BASIS]|Varchar2(2)|[X_TIME_BASIS]| |
|[WAGE_RATE]|Number(18)|[AMT12V6|AMTnn]| |
|[RATE_BASIS]|Varchar2(2)|[X_RATE_BASIS]| |
|[REFERENCE_INFO]|Varchar2(2000)|[VARCHAR2000|VARCHARnn]| |
|[CREATE_DATE]|Date()|[DATE]|Y|
|[CREATE_USER]|Varchar2(30)|[VARCHAR30|VARCHARnn]|Y|
|[CHANGE_DATE]|Date()|[DATE]|Y|
|[CHANGE_USER]|Varchar2(30)|[VARCHAR30|VARCHARnn]|Y|

User Fields: Allowed\\
Audit Logging: Allowed\\