Array Fields
In ProAdmin, an array field is a collection of values (numerical, code, or date) that are correlated with or delimited by a date or a range of dates. Arrays fields are either:
Effective-dated, where a single date indicates the date on and after which the value is in effect, or
Start and stop-dated, where each value has two dates that span the time period over which the value is applicable.
Examples:
Effective-dated array
Hourly Rate of Pay Effective date Value 5/15/2003 10.87 5/17/2004 11.52 5/18/2005 12.03
The rate of pay started on 5/15/2003 at $10.87 per hour. It then changed to $11.52 per hour on 5/17/2004, and then changed to $12.03 per hour on 5/18/2005.
Start and stop-dated array
Annual Compensation Start date Stop date Value 1/1/2003 12/31/2003 21,945.25 1/1/2004 12/31/2004 23,455.52 1/1/2005 12/31/2005 24,624.24
See Temporary Variables, Assignment, and Array Operators to see how array fields behave in expressions.Annual compensation of $21,945.25 was earned during the 2003 calendar year, $23,455.52 during the 2004 calendar year and $24,624.24 during the 2005 calendar year.