!!!Alias: ASL
Unique Keys: ___\\
Child Table: ___\\
Parent Table: ___\\
\\
Service Levels

!!Table Columns
\\
||Column name||Data Type / Size||Domain||Mand.||Notes
|[ID]|Number(10)|[ID]|Y|
|[ALPD_ID]|Number(10)|[ID]|Y|link to [P2K_AT_LEAVE_POLICY_DETAILS]
|[SERVICE_TIME_UPTO]|Number(5)|[NUMBER5|NUMBERn]|Y|
|[CREATE_DATE]|Date()|[DATE]|Y|
|[CREATE_USER]|Varchar2(30)|[VARCHAR30|VARCHARnn]|Y|
|[CHANGE_DATE]|Date()|[DATE]|Y|
|[CHANGE_USER]|Varchar2(30)|[VARCHAR30|VARCHARnn]|Y|
|[ENTITLEMENT]|Number(18)|[AMT12V6|AMTnn]| |
|[ENTITLEMENT_BASIS]|Varchar2(2)|[X_PERIOD_BASIS]| |
|[SERVICE_PRORATE_FACTOR]|Number(5)|[PERCENT]| |
|[ROLLING_CAP]|Number(18)|[AMT12V6|AMTnn]| |
|[YEAR_END_CAP]|Number(18)|[AMT12V6|AMTnn]| |
|[ANNUAL_ENTITLEMENT_CAP]|Number(18)|[AMT12V6|AMTnn]| |
|[REG_EARNINGS_PERCENT]|Number(5)|[PERCENT]| |
|[LEGAL_EARNINGS_PERCENT]|Number(5)|[PERCENT]| |
|[ABS_EARNINGS_PERCENT]|Number(5)|[PERCENT]| |
|[SUPPL_EARNINGS_PERCENT]|Number(5)|[PERCENT]| |
|[SPECIAL_EARNINGS_PERCENT]|Number(5)|[PERCENT]| |
|[TIME_WORKED_PERCENT]|Number(5)|[PERCENT]| |
|[USER1_PERCENT]|Number(5)|[PERCENT]| |
|[USER2_PERCENT]|Number(5)|[PERCENT]| |
|[USER3_PERCENT]|Number(5)|[PERCENT]| |

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