!!!Alias: ASL
(P2K_AT_SERVICE_LEVELS)

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\\


----
![Notes|Edit:Internal.P2K_AT_SERVICE_LEVELS] 	
[{InsertPage page='Internal.P2K_AT_SERVICE_LEVELS' default='Click to create a new notes page'}]