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

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

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
12 26-Nov-2021 10:22 2 KB JEscott to previous
11 26-Nov-2021 10:22 1 KB JEscott to previous | to last
10 26-Nov-2021 10:22 1 KB JMyers to previous | to last
9 26-Nov-2021 10:22 1 KB JMyers to previous | to last
8 26-Nov-2021 10:22 1 KB JMyers to previous | to last
7 26-Nov-2021 10:22 2 KB JMyers to previous | to last
6 26-Nov-2021 10:22 2 KB JMyers to previous | to last
5 26-Nov-2021 10:22 2 KB JMyers to previous | to last
4 26-Nov-2021 10:22 1 KB JMyers to previous | to last
3 26-Nov-2021 10:22 1 KB JMyers to previous | to last
2 26-Nov-2021 10:22 1 KB JMyers to previous | to last
1 26-Nov-2021 10:22 280 bytes KateN to last

Page References

Incoming links Outgoing links

Version management

Difference between version and

At line 8 changed one line
Column Name
Column Name|]:
At line 10 changed one line
Table
Table|]:
At line 13 changed 15 lines
Table Alias
This field provides an abbreviated form of the table name.
Length of Code
This field indicates the number of characters in the code sequence.
Zero Filled
Last # Assigned This is the last number automatically assigned. The next sequence number will be one greater than the number shown here. This value must be between the lowest and the highest values above.
Lowest Range
This number specifies the starting point of the automatically sequenced range.
Highest Range This number specifies the ending point of the automatically sequenced range. When you reach the end of this range, the system will not allow you to create the record being sequenced. At that point you must either enter a manual number, or modify the sequence range.
Manual Entry Option A toggle to indicate if manual entry is permitted (instead of only allowing the system to generate the sequence value).
Manual Rule This field identifies how the manual range is to function. Values that may be selected are as follows:
Manuals within the Range -This is required by entities that block off number ranges for sub-entities and need each sub-entity's manual range to be within their own allocated range.
Any Numeric Value Allowed -This is used by entities that set up sequencing to ensure that their codes are numeric, but the need to provide manual number is still present.
Any Value Allowed - This is used by entities that have a requirement to enter manual codes, but there is no requirement to ensure that they are numeric in nature.
Manual Lowest
;[Table Alias |]:This field provides an abbreviated form of the table name.
;[Length of Code |]:This field indicates the number of characters in the code sequence.
;[Zero Filled |]:
;[Last # Assigned|]:This is the last number automatically assigned. The next sequence number will be one greater than the number shown here. This value must be between the lowest and the highest values above.
;[Lowest Range|]:This number specifies the starting point of the automatically sequenced range.
;[Highest Range|]:This number specifies the ending point of the automatically sequenced range. When you reach the end of this range, the system will not allow you to create the record being sequenced. At that point you must either enter a manual number, or modify the sequence range.
;[Manual Entry Option|]:A toggle to indicate if manual entry is permitted (instead of only allowing the system to generate the sequence value).
;[Manual Rule|]:This field identifies how the manual range is to function. Values that may be selected are as follows:
|Manuals within the Range|This is required by entities that block off number ranges for sub-entities and need each sub-entity's manual range to be within their own allocated range.
|Any Numeric Value Allowed|This is used by entities that set up sequencing to ensure that their codes are numeric, but the need to provide manual number is still present.
|Any Value Allowed|This is used by entities that have a requirement to enter manual codes, but there is no requirement to ensure that they are numeric in nature.
;[Manual Lowest|]:
At line 29 changed one line
Manual Highest
;[Manual Highest |]: