!!!Alias: AALD (P2K_AT_LEAVE_LINE_DETAILS) Unique Keys: \\ Child Table: \\ Parent Table: [P2K_AT_LEAVE_LINES]\\ \\ Leave Line Details !!Table Columns \\ ||Column name||Data Type / Size||Domain||Mand.||Notes |[ID]|Number(10)|[ID]|Y| |[AAL_ID]|Number(10)|[ID]|Y|link to [P2K_AT_LEAVE_LINES] |[ALPC_ID]|Number(10)|[ID]|Y|link to [P2K_AT_LEAVE_POLICY_COMPONENTS] |[ALAD_ID]|Number(10)|[ID]| |link to [P2K_AT_LEAVE_ACCRUAL_DETAILS] |[DTC_ID]|Number(10)|[ID]| |link to [P2K_CM_TIME_CODES] |[CREATE_USER]|Varchar2(30)|[VARCHAR30|VARCHARnn]|Y| |[CHANGE_DATE]|Date()|[DATE]|Y| |[CHANGE_USER]|Varchar2(30)|[VARCHAR30|VARCHARnn]|Y| |[CREATE_DATE]|Date()|[DATE]|Y| |[DESCRIPTION]|Varchar2(50)|[DESCRIPTION]| | |[WAGE_RATE_OVERRIDE]|Number(18)|[AMT12V6|AMTnn]| | |[RATE_BASIS_OVERRIDE]|Varchar2(2)|[X_RATE_BASIS]| | |[AMOUNT]|Number(18)|[AMT12V6|AMTnn]| | |[AMOUNT_OVERRIDE]|Number(18)|[AMT12V6|AMTnn]| | |[TIME_BASIS]|Varchar2(2)|[X_TIME_BASIS]| | |[BANK_EXCEEDED]|Varchar2(1)|[TOGGLE]| | |[AALD_ID]|Number(10)|[ID]| |link to [P2K_AT_LEAVE_LINE_DETAILS] |[ALP_ID]|Number(10)|[ID]| |link to [P2K_AT_LEAVE_POLICIES] |[AAC_ID]|Number(10)|[ID]| |link to [P2K_AT_ATTENDANCE_COMPONENTS] User Fields: Not Allowed\\ Audit Logging: Allowed\\ ---- ![Notes|Edit:Internal.P2K_AT_LEAVE_LINE_DETAILS] [{InsertPage page='Internal.P2K_AT_LEAVE_LINE_DETAILS' default='Click to create a new notes page'}]