This page (revision-79) was last changed on 20-Sep-2023 14:24 by Lilia Urtan

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

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
79 20-Sep-2023 14:24 81 KB Lilia Urtan to previous
78 05-May-2023 13:45 81 KB Lilia Urtan to previous | to last
77 21-Mar-2023 10:08 80 KB Kevin Higgs to previous | to last
76 26-Nov-2021 10:22 80 KB kparrott to previous | to last
75 26-Nov-2021 10:22 80 KB khiggs to previous | to last
74 26-Nov-2021 10:22 80 KB khiggs to previous | to last
73 26-Nov-2021 10:22 79 KB khiggs to previous | to last
72 26-Nov-2021 10:22 79 KB khiggs to previous | to last
71 26-Nov-2021 10:22 79 KB khiggs to previous | to last
70 26-Nov-2021 10:22 79 KB rmorrell to previous | to last
69 26-Nov-2021 10:22 79 KB rforbes to previous | to last
68 26-Nov-2021 10:22 78 KB jmyers to previous | to last
67 26-Nov-2021 10:22 78 KB jmyers to previous | to last
66 26-Nov-2021 10:22 78 KB jmyers to previous | to last
65 26-Nov-2021 10:22 78 KB jmyers to previous | to last
64 26-Nov-2021 10:22 78 KB jmyers to previous | to last
63 26-Nov-2021 10:22 78 KB jmyers to previous | to last
62 26-Nov-2021 10:22 78 KB jmyers to previous | to last
61 26-Nov-2021 10:22 79 KB jmyers to previous | to last

Page References

Incoming links Outgoing links
UEEF
UEEF

Version management

Difference between version and

At line 644 changed 3 lines
|80|Total Record|Not used
|90|Trailer Record|Generate Trailer records at end of file\\May contain File totals, record counts etc
|91|Qualify Record|Should be used for Record Number 0\\The Qualify records are performed at the beginning of every Detail record to qualify employees\\User can use derivation expression to BYPASS certain criteria
|80 - Total Record|Not used
|90 - Trailer Record|Generate Trailer records at end of file\\May contain File totals, record counts etc
|91 - Qualify Record|Should be used for Record Number 0\\The Qualify records are performed at the beginning of every Detail record to qualify employees\\User can use derivation expression to BYPASS certain criteria
At line 672 changed 3 lines
*applicable to Numeric field only, use for Record Type = Detail Record, Detail Leveln
- indicate if this Record #, Field # amount should be totaled for Header or Trailer record
- e.g. if the field is a ‘FTE’ or ‘Rate of Pay’, then do not totaled
*Applicable to Numeric field only, use for Record Type = Detail Record, Detail Leveln
*Indicate if this Record #, Field # amount should be totaled for Header or Trailer record
**e.g. if the field is a 'FTE' or 'Rate of Pay', then do not totaled
*If field is 'Statistics Amount' or 'User Calc Amount', then you may want to calculate the total for Trailer record
*lexicon X_TOTAL_OPTION\\00 - Not Specified\\01 - Calculate Total
;Derivation Expression:
*Specifies the derivation expression for the Variable name
*This derivation expression will apply to the result of the Variable name before format mask
*The user may use RTRIM(~) to remove trailing blanks before comparing the entire string because the data may contain blanks that are not visible at the end
*Please refer to following Derivation Expression processing
At line 676 removed 4 lines
- if field is ‘Statistics Amount’ or ‘User Calc Amount’, then you may want to calculate the total for Trailer record
- lexicon X_TOTAL_OPTION
00 – Not Specified
01 – Calculate Total
At line 681 removed 2 lines
Derivation Expression - specifies the derivation expression for the Variable name
- this derivation expression will apply to the result of the Variable name before format mask
At line 684 removed one line
- the user may use RTRIM(~) to remove trailing blanks before comparing the entire string because the data may contain blanks that are not visible at the end
At line 686 removed one line
- please refer to following Derivation Expression processing
At line 689 removed 4 lines
This page (revision-79) was last changed on 20-Sep-2023 14:24 by Lilia UrtanTop