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 | ||
| TIME_BASIS | Varchar2(2) | X_TIME_BASIS | ||
| WAGE_RATE | Number(18) | AMT12V6 | ||
| RATE_BASIS | Varchar2(2) | X_RATE_BASIS | ||
| REFERENCE_INFO | Varchar2(2000) | VARCHAR2000 | ||
| CREATE_DATE | Date() | DATE | Y | |
| CREATE_USER | Varchar2(30) | VARCHAR30 | Y | |
| CHANGE_DATE | Date() | DATE | Y | |
| CHANGE_USER | Varchar2(30) | VARCHAR30 | Y |
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