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

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

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
9 26-Nov-2021 10:22 1 KB JEscott to previous
8 26-Nov-2021 10:22 1 KB JEscott to previous | to last
7 26-Nov-2021 10:22 954 bytes Administrator to previous | to last
6 26-Nov-2021 10:22 1007 bytes Administrator to previous | to last
5 26-Nov-2021 10:22 999 bytes Administrator to previous | to last
4 26-Nov-2021 10:22 1009 bytes Administrator to previous | to last
3 26-Nov-2021 10:22 976 bytes Administrator to previous | to last
2 26-Nov-2021 10:22 978 bytes Administrator to previous | to last
1 26-Nov-2021 10:22 979 bytes Administrator to last

Page References

Incoming links Outgoing links
P 2 K_SH_HEALTH_COSTS
P2K_SH_HEALTH_COSTS

Version management

Difference between version and

At line 2 changed 3 lines
Unique Keys: \\
Child Table: \\
Parent Table: [P2K_HR_HEALTH_ISSUES]\\
(P2K_SH_HEALTH_COSTS)
Unique Keys: None\\
ERD: [ERD-SH35]
At line 11 changed 2 lines
|[COST_TYPE]|Varchar2(2)|[(Lexicon)]|Y|
|[REFERENCE_ID]|Number(10)|[NUMBER10]|Y|
|[COST_TYPE]|Varchar2(2)|[X_COST_TYPE]|Y|
|[REFERENCE_ID]|Number(10)|[NUMBER10|NUMBERn]|Y|
At line 14 changed one line
|[COST_CATEGORY]|Varchar2(2)|[(Lexicon)]|Y|
|[COST_CATEGORY]|Varchar2(2)|[X_COST_CATEGORY]|Y|
At line 18 changed one line
|[CURRENCY]|Varchar2(2)|[(Lexicon)]| |
|[CURRENCY]|Varchar2(2)|[X_CURRENCY]| |
At line 20 changed 2 lines
|[PAYMENT_STATUS]|Varchar2(2)|[(Lexicon)]| |
|[PAYMENT_METHOD]|Varchar2(2)|[(Lexicon)]| |
|[PAYMENT_STATUS]|Varchar2(2)|[X_PAYMENT_STATUS]| |
|[PAYMENT_METHOD]|Varchar2(2)|[X_PAYMENT_METHOD]| |
At line 29 added 5 lines
!![Derived Fields|DERIVED FIELDS]
||Column Name
|[DRV_MEDICAL_EXAM_DATE]
At line 36 added 5 lines
----
![Notes|Edit:Internal.P2K_SH_HEALTH_COSTS]
[{InsertPage page='Internal.P2K_SH_HEALTH_COSTS' default='Click to create a new notes page'}]
This page (revision-9) was last changed on 26-Nov-2021 10:22 by JEscottTop