!!!Alias: PSL (P2K_PR_SUNDRY_LINES) Unique Keys: \\ Child Table: [P2K_PR_SUNDRY_LINE_DETAILS] \\ Parent Table: \\ ERD: [ERD-PR40] \\ 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|REFERENCE_INFO PSL]|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] |[THIRD_PARTY_TO_DISBURSE]|Varchar2(2)|[TOGGLE]| | |[PAID_TO_ORDER_OF]|Varchar2(30)|[VARCHAR30|VARCHARnn]| | |[PAYMENT_SCHEDULE_TYPE]|Varchar2(2)|[X_PAYMENT_SCHEDULE_TYPE]| | |[PAYMENT_SCHEDULE_ACCRUING]|Varchar2(16)|[VARCHAR16|VARCHARnn]| | |[MEMORANDUM_1]|Varchar2(50)|[VARCHAR50|VARCHARnn]| | |[MEMORANDUM_2]|Varchar2(50)|[VARCHAR50|VARCHARnn]| | |[AGENCY_CASE_IDENTIFICATION]|Varchar2(30)|[VARCHAR30|VARCHARnn]| | |[DSP_ID]|Number(10)|[ID]|Y|link to [P2K_PR_PAY_COMPONENTS] |[DEPENDANT_MEDICAL_COVERAGE]|Varchar2(2)|[TOGGLE]| | |[LIEN_DEDUCTION]|Varchar2(2)|[X_LIEN_DEDUCTION]| | |[EXTERNAL_DOCUMENT_ID]|Varchar2(16)|[VARCHAR16|VARCHARnn]| | |[LIEN_NUMBER]|Number(5)|[NUMBER5|NUMBERn]| | |[EID_ID_PAYEE]|Number(10)|[NUMBER5|NUMBERn]| | |[SUNDRY_STATUS]|Varchar2(2)|[X_SUNDRY_STATUS]| | User Fields: Allowed\\ Audit Logging: Allowed\\ ---- ![Notes|Edit:Internal.P2K_PR_SUNDRY_LINES] [{InsertPage page='Internal.P2K_PR_SUNDRY_LINES' default='Click to create a new notes page'}]