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

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

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
20 26-Nov-2021 10:22 6 KB rforbes to previous
19 26-Nov-2021 10:22 5 KB rforbes to previous | to last
18 26-Nov-2021 10:22 5 KB khiggs to previous | to last
17 26-Nov-2021 10:22 5 KB jaiken to previous | to last
16 26-Nov-2021 10:22 5 KB jaiken to previous | to last
15 26-Nov-2021 10:22 5 KB rforbes to previous | to last
14 26-Nov-2021 10:22 5 KB jmyers to previous | to last ERD-HR01 ==> ERD-HR1
13 26-Nov-2021 10:22 5 KB jmyers to previous | to last ERD-HR1 ==> ERD-HR01
12 26-Nov-2021 10:22 5 KB RForbes to previous | to last
11 26-Nov-2021 10:22 5 KB RForbes to previous | to last
10 26-Nov-2021 10:22 5 KB JAiken to previous | to last
9 26-Nov-2021 10:22 5 KB RForbes to previous | to last
8 26-Nov-2021 10:22 5 KB RForbes to previous | to last
7 26-Nov-2021 10:22 5 KB RForbes to previous | to last
6 26-Nov-2021 10:22 5 KB RForbes to previous | to last
5 26-Nov-2021 10:22 5 KB RForbes to previous | to last
4 26-Nov-2021 10:22 5 KB RForbes to previous | to last
3 26-Nov-2021 10:22 5 KB RForbes to previous | to last
2 26-Nov-2021 10:22 5 KB JAiken to previous | to last
1 26-Nov-2021 10:22 5 KB RForbes to last

Page References

Incoming links Outgoing links
USER_FORMULA_COLUMN
USER_FORMULA_COLUMN

Version management

Difference between version and

At line 14 changed one line
In this example it is desired to have a column showing the value of a statistic called STAT-PA-DAYS (seen on [IEST]) for an employee. By reviewing the [ERD|ERD-HR1] for the [P2K_HR_STATISTICS] table we can see that the record is identifiable as an intersection between [EEM_ID] (The ID from [P2K_HR_EMPLOYMENTS]) and [DSC_ID] (The ID from [P2K_CM_STATISTIC_COMPONENTS]). As we know the specific statistic code we will always want, we can determine that the variable element here is the employment record ID.
In this example it is desired to have a column showing the value of a statistic called STAT-PA-DAYS (seen on [IEST]) for an employee. By reviewing the [ERD|ERD-HR01] for the [P2K_HR_STATISTICS] table we can see that the record is identifiable as an intersection between [EEM_ID] (The ID from [P2K_HR_EMPLOYMENTS]) and [DSC_ID] (The ID from [P2K_CM_STATISTIC_COMPONENTS]). As we know the specific statistic code we will always want, we can determine that the variable element here is the employment record ID.
This page (revision-20) was last changed on 26-Nov-2021 10:22 by rforbesTop