This page (revision-6) was last changed on 26-Nov-2021 10:22 by jaiken

This page was created on 26-Nov-2021 10:22 by JMyers

Only authorized users are allowed to rename pages.

Only authorized users are allowed to delete pages.

Page revision history

Version Date Modified Size Author Changes ... Change note
6 26-Nov-2021 10:22 1 KB jaiken to previous
5 26-Nov-2021 10:22 1 KB jaiken to previous | to last
4 26-Nov-2021 10:22 1 KB jaiken to previous | to last
3 26-Nov-2021 10:22 1 KB jaiken to previous | to last
2 26-Nov-2021 10:22 860 bytes JMyers to previous | to last
1 26-Nov-2021 10:22 965 bytes JMyers to last

Page References

Incoming links Outgoing links

Version management

Difference between version and

At line 13 removed 2 lines
Note - this report works on a generic basis reporting information on tables that have a direct tie to the key employee tables. The information driving this report is derived based on the Table Details information. It can not report change information from lower level tables (Leave Line Details, etc.) as there is no direct link to the key employee tables.
At line 16 changed 15 lines
||Table Name ||Alias
|P2K_HR_ALIASES |EAL
|P2K_HR_ASSIGNMENTS |EAS
|P2K_HR_ASSIGNMENT_DETAILS |EASD
|P2K_HR_CONTACTS |ECT
|P2K_HR_CONTACT_ROLES |ECR
|P2K_HR_EMPLOYMENTS |EEM
|P2K_HR_IDENTITIES |EID
|P2K_HR_MILITARIES |EMT
|P2K_HR_PERSONALS |EPS
|P2K_HR_PROPERTIES |EPP
|P2K_HR_STATISTICS |EST
|P2K_PR_CDN_PAY_RULES |PPRC
|P2K_SA_EXPERIENCES |SEP
|P2K_SA_REVIEWS |SRV
Table Name Alias Description
P2K_HR_ALIASES EAL Aliases
P2K_HR_ASSIGNMENTS EAS Provides overview of various Assignments.
P2K_HR_ASSIGNMENT_DETAILS EASD Provides all of the details for the Assignment ent
P2K_HR_CONTACTS ECT Stores all the important information regarding any
P2K_HR_CONTACT_ROLES ECR Describes the type of relationship that a contact
P2K_HR_EMPLOYMENTS EEM Descrtibes all identities relationships with the c
P2K_HR_IDENTITIES EID Provides all non-date sensitive information regard
P2K_HR_MILITARIES EMT Provides a military history for any given identity
P2K_HR_PERSONALS EPS Holds all date sensitive information on any given
P2K_HR_PROPERTIES EPP Holds all of the property details for any given id
P2K_HR_STATISTICS EST Statistics
P2K_PR_CDN_PAY_RULES PPRC Cdn Pay Rules
P2K_SA_EXPERIENCES SEP Experiences
P2K_SA_REVIEWS SRV Reviews
At line 32 removed 10 lines
!Table support added for 4.11:
||Table Name ||Alias
|P2K_AT_LEAVE_ACCRUALS |ALA
|P2K_AT_LEAVE_LINES |AAL
|P2K_BE_ELECTIONS |BEL
|P2K_BE_ENROLLMENTS |BEN
|P2K_LR_DISCIPLINARY_ISSUES |LDI
|P2K_PR_PAYMENT_RULES |PPR
|P2K_PR_SUNDRY_LINES |PSL
|P2K_PR_US_TAX_AREAS |PTAU
At line 43 removed one line