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

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
21 26-Nov-2021 10:22 6 KB rmorrell to previous

Page References

Incoming links Outgoing links

Version management

Difference between version and

At line 2 changed one line
Entities are identified in the [Entity Relationship Diagrams|ERD] as a singular name (i.e. DEPARTMENT). The table name can be derived from the entity name on teh diagram by noting this name, and the module that the ERD reflects (HR, PR, etc.) which is CM (Common Definitions) for DEPARTMENT.
Entities are identified in the [Entity Relationship Diagrams|ERD] as a singular name (i.e. DEPARTMENT). The table name can be derived from the entity name on the diagram by noting this name, and the module that the ERD reflects (HR, PR, etc.) which is CM (Common Definitions) for DEPARTMENT.
At line 9 added one line
View names are similarly constructed to table names but it is differentiated as a view by the inclusion of a letter "V" at the beginning of the third section. For example, P2K_HR_EMPLOYMENTS is a table name, P2K_HR_VEMPLOYMENTS is a view that references this table and P2K_HR_IDENTITIES together.
At line 15 changed 5 lines
* "D" - Date (Calendar) controlled screen eg
* "R" - Report program (does not normally update data)
* "U" - Update program (usually produces a report as well)
* "L" - Load program
* "X" - Extract program
* "D" - Date (Calendar) controlled screen eg [DAAL]
* "R" - Report program (does not normally update data) e.g. [RDEN]
* "U" - Update program (usually produces a report as well) e.g. [UPCALC]
* "L" - Load program e.g. [LMTD]
* "X" - Extract program e.g. [XMFN]
At line 27 added one line
Lexicons that are provided as part of the system start with "X_" and then have the name of the field that they are associated to. There are cases where a lexicon name does not correspond to the field name it is referenced from, but this is usually when there is another field that would utilize the same set of values.