!!!Alias: [IVPPA] (INF_CV_PAYPCAMOUNTS) The INF_CV_PAYPCAMOUNTS table is used to import historical employee payroll information at a detailed pay component level into the software data structures. !!Table Columns \\ ||Column name||Data Type / Size||Mand.||Notes |[ID]|Number(10)| |Used internally to define a unique identification for the record. This field would not be loaded. |[ENTITY_CODE]|Varchar2(16)|Y|Used for validation of the employment record. Validation: The Entity Code provided must be defined on [P2K_CM_ENTITIES] |[PERSON_CODE]|Varchar2(16)|Y|Used for validation of the employment record. Validation: Must be a valid [PERSON_CODE] already defined on the [P2K_HR_IDENTITIES] table. |[EMPLOYMENT_TYPE]|Varchar2(30)| |Used for validation. Validation: The employee must have an active employment record for this employment type. Must be one of the [X_EMPLOYMENT_TYPE] fixed lexicon values. Derivation: If you do not provide an employment type value, the conversion application will look for any [P2K_HR_EMPLOYMENTS] record that matches the other criteria. Suggestion: If you are loading employees, you can set this field to a fixed value of ‘01’. |[HIRE_DATE]|Date()| |Used for validation of the employment record. Derivation: If you do not provide a hire date, the conversion application will look for any [P2K_HR_EMPLOYMENTS] record that matches the other criteria. Validation: Must be a valid date. |[PAY_NUMBER]|Number(5)|Y| |[PC_CODE]|Number(4)|Y|Validation: Must be a valid pay component already defined on [P2K_PR_PAY_COMPONENTS]. |[AMOUNT]|Number(18)|Y| [{If var='loginstatus' contains 'authenticated' ---- ![Discussion|Edit:Internal.IVPPA] [{InsertPage page='Internal.IVPPA' default='Click to create a new discussion page'}] }]