!!!Alias: PSL Unique Keys: ___\\ Child Table: ___\\ Parent Table: ___\\ \\ Sundry Lines !!Table Columns \\ ||Column name||Data Type / Size||Domain||Mand.||Notes |[ID]|Number(10)|[ID]|Y| |[PPC_ID]|Number(10)|[ID]|Y|link to [P2K_PR_PAY_COMPONENTS] |[PFQ_ID]|Number(10)|[ID]|Y|link to [P2K_PR_FREQUENCIES] |[EEM_ID]|Number(10)|[ID]|Y|link to [P2K_HR_EMPLOYMENTS] |[PPCR_ID]|Number(10)|[ID]| |link to [P2K_PR_PC_RULES] |[DPS_ID]|Number(10)|[ID]| |link to [P2K_CM_POSITIONS] |[DJB_ID]|Number(10)|[ID]| |link to [P2K_CM_JOBS] |[ALPT_ID]|Number(10)|[ID]| |link to [P2K_AT_LEAVE_POLICY_TYPES] |[BPN_ID]|Number(10)|[ID]| |link to [P2K_BE_PLAN_DEFINITIONS] |[MUC_ID]|Number(10)|[ID]| |link to [P2K_AM_USER_CALCS] |[DTX_ID]|Number(10)|[ID]| |link to [P2K_CM_TAX_JURISDICTIONS] |[EAS_ID]|Number(10)|[ID]|Y|link to [P2K_HR_ASSIGNMENTS] |[SUNDRY_LINE_TYPE]|Varchar2(2)|[X_SUNDRY_LINE_TYPE]|Y| |[START_DATE]|Date()|[DATE]|Y| |[END_DATE]|Date()|[DATE]|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| |[TIMES_REMAINING]|Number(5)|[NUMBER5|NUMBERn]| | |[PAY_POINT_TYPE]|Varchar2(2)|[X_PAY_POINT_TYPE]| | |[PAY_POINT_TASK]|Varchar2(2)|[X_PAY_POINT_TASK]| | |[PAY_POINT_SEQUENCE]|Number(5)|[NUMBER5|NUMBERn]| | |[TIME_ENTERED]|Number(18)|[AMT12V6|AMTnn]| | |[TIME_BASIS]|Varchar2(2)|[X_TIME_BASIS]| | |[WCB_CLASS]|Varchar2(2)|[X_WCB_CLASS]| | |[DISTRIBUTION_MASK]|Varchar2(50)|[DISTRIBUTION]| | |[REFERENCE_INFO]|Varchar2(2000)|[VARCHAR2000|VARCHARnn]| | |[AUDIT_TEXT]|Varchar2(4000)|[VARCHAR4000|VARCHARnn]| | |[WORK_ORDER]|Varchar2(50)|[VARCHAR50|VARCHARnn]| | |[DCC_ID]|Number(10)|[ID]| |link to [P2K_CM_COST_CENTERS] |[INCOME_PRORATION]|Varchar2(1)|[TOGGLE]| | |[DCL_ID]|Number(10)|[ID]| |link to [P2K_CM_CALENDARS] User Fields: Allowed\\ Audit Logging: Allowed\\