Aging Criteria panel
The Date Aging function allows you to create and edit formatted date aging criteria and process this criteria to age dates. The Aging Criteria screen, shown in the following figure, is displayed when you press <Enter> on the Input Dataset Specification after selecting option 1 on the Aging Tools Menu. It enables you to enter criteria to be used during the date aging process.
-------------------------------------------------------------------------------
File-AID/Data Solutions ------- Aging Criteria --------------------------------
COMMAND ===> SCROLL ===> PAGE
RULES ===> ("*" or pattern for member list)
SET 1 OF 1 EMPLOYEE-MASTER-FILE GBL = N SEL = N
---- FIELD LEVEL/NAME ------- -FORMAT- RO -C- -Y- -M- --D-- --DATE PATTERN-- R
******************************* TOP OF DATA ***********************************
5 EMP-NUMBER 5/AN
5 EMP-LAST-NAME 15/AN
5 EMP-FIRST-NAME 10/AN
5 EMP-MID-INIT 1/AN
5 FILLER 2/AN
5 EMP-TITLE 30/AN
5 EMP-PERSONAL-INFO SYNC 23/GRP
10 EMP-NATL-ID-NUMBER 9/NUM
10 FILLER 1/AN
10 EMP-DATE-OF-BIRTH 6/AN + 100 MMDDYY
10 EMP-DOB-REDEF REDEFINES EMP-DATE-OF-BIRTH
10 EMP-DOB-REDEF SYNC 6/GRP
15 EMP-DOB-MM 2/NUM
15 EMP-DOB-DD 2/NUM
Valid RO: +, -, R, FM - For list of patterns,leave PATTERN blank.
Commands: SELect, View
Field descriptions
Rules
Member name containing business date rules.
Set
Identifies the set of criteria displayed.
01 Level Name
Name of the record file structure from layout.
GBL
Specifies whether one or more global fields have been attached to this set of criteria (N or Y).
SEL
Specifies whether selection criteria has been attached to this set of criteria (N or Y).
FIELD LEVEL/NAME
Name of the field from layout.
FORMAT
Length and type of field.
RO
Specify a relational operator. Possible values are:
+ | Add to date (default) |
- | Subtract from date |
R | Replace with the specified new date |
= | Replicates last entered criteria |
FM | Field mask. For more information, see Field Mask. |
-C-
Century. Specify up to three numeric digits.
When processing date formats without a century (2-digit year), you may override the default pivot year value, 60, by entering a value in the -C- (Century) field.
-Y-
Year. Specify up to three numeric digits.
-M-
Month. Specify up to three numeric digits.
-D-
Day. Specify up to five numeric digits.
DATE PATTERN
Specify the date pattern exit to call for this field. The date pattern exit converts this date into a standard date format used in File-AID/Data Solutions processing. If this field is left blank when a relational operator (RO) is specified, Data Solutions displays the Available Date Patterns screen.
R
Apply business rules field. Specify Y (Yes) to use business rules. The default is N (No).
Guidelines for formatted aging criteria
To specify a formatted aging criterion, choose a date field and enter the relational operator, a numeric value in the century, year, month, and/or days field, and the appropriate date pattern. Leave the fields blank for fields not involved in the aging criteria.
Use the INPUT, INSERT, or REPEAT primary command to specify multiple sets of aging criteria. When multiple sets of aging criteria are specified, Data Solutions applies them one at a time in the order they are specified.
In theory, you can create any number of sets of aging criteria. However, the actual number is limited by available storage. Storage is primarily affected by the number of relational operators used.
Available date patterns
The following figure allows you to select the name of the date pattern exit for Data Solutions to use to process the indicated date field. It is displayed when you enter a RO (Relational Operator) and date information without a Date Pattern or use the PATTERN primary command on the Aging Criteria screen.
File-AID/Data Solutions is packaged with more than 50 common date patterns. For any dates that cannot be handled by the supplied date pattern exits, you may add your own date pattern exits. See Creating Your Own Date Pattern Exits for information on adding your own date pattern exit.
Available Date Patterns Screen
Primary commands
The following is a list of primary commands and their abbreviations that are valid on the Aging Criteria screen. For more information, see Primary Commands.
Command | Description |
|---|---|
ALIGN (AL) | Controls display of ALIGNED/UNALIGNED term for PL/I data. |
ARRAY (AR) | Controls display of array declaration information for PL/I data. |
BACK | Positions the display to the previous criteria. Synonym for LEFT. |
CALC | Displays the Date Calculator screen. |
CANCEL (CAN) | Returns to the Input Specification screen without saving current updates. |
CHANGE (CHG or C) | Switch from the Selection Criteria to the Change Criteria panels. This command is only valid on the Record Layout Selection Criteria and Global Selection Criteria panels. |
COMPLEX (CM) | Controls display of COMPLEX terms for PL/I data. |
DELETE (DEL) | Deletes a criteria set (change and associated selection criteria). |
DISPLAY (DIS) | Specifies a display format. |
DOWN | Scrolls down. |
END | Terminates display of the formatted criteria screen and displays the Criteria Menu. |
FILLER (FILL) | Controls display of FILLER fields. |
FORWARD (FWD) | Positions the display to the next criteria. Synonym for RIGHT. |
GLOBAL (GBL) | Displays the GLOBAL Change Criteria panel which shows the defined global fields (variables). Use this panel to create criteria which will test values of global fields. Valid only if a global field has been defined. |
GROUP (G) | Controls the display of occurrences of group-level items. |
INPUT/ INSERT (I) | Inputs/inserts a new criteria set (formatted change and associated selection criteria). |
IMPORT | Imports an existing change criteria set. |
LEFT | Positions the display to the previous criteria. Synonym for BACK. |
LOCATE (L) | Scrolls directly to the specified record layout line. |
LR (Locate Record) | Positions the display to the specified criteria number. |
MESSAGE (MSG) | Controls the message display. |
OCCURS (OCC) | Controls the display of array declaration items. |
OFFSET (OFST) | Displays field offsets. |
PATTERN | Displays the Available Date Patterns screen. |
PICTURE (PIC) | Controls the display of the PICTURE or DISPLAY line for numeric data. |
PROFILE (PROF) | Displays profile information lines. |
RECORD (REC) | Closes the Global Change or Global Selection Criteria panel and returns to the Formatted Selection or Change Criteria panel. Only valid on the Global Selection Criteria or Global Change Criteria panels. |
REDEFINE (RED) | Controls the display of data item redefinitions. |
REFLNG (REF) | Controls the display of BIT/CHAR REFER field length reference lines for PL/I data. |
REPEAT (R) | Causes a criteria set (formatted change and selection) to be repeated. |
RESET (RES) | Causes excluded lines to be redisplayed. |
RETURN | Returns to the Primary Option Menu. |
RIGHT | Positions the display to the next criteria. Synonym for FORWARD. |
SELECT (SEL) | Displays the Formatted Selection Criteria screen. |
SHOW (S) | Displays LEVEL, NUMBER, FORMAT, OFFSET, or PICTURE information for the layout fields. |
SYNC | Controls the display of the SYNC term for fields in a COBOL record layout. |
UP | Scrolls up. |
VIEW (V) | Displays the View Criteria screen which is a keyword summary of the current settings for formatted aging and selection criteria. See View Specification Keywords Screen. |
Shortcut Commands
When entering or modifying change criteria you can change the type of criteria you are about to enter by using any of the following primary commands:
AGING
switches to Date Aging.
DATAENCR
switches to Data Encryption.
DATAGEN
switches to Data Generation.
DATANALY
switches to Data Analysis.
DATAPGEN
switches to Pattern Data Generation
DATAREPL
switches to Data Replace.
DATATRAN
switches to Data Translator.
DATAVALD
switches to Validate Criteria.
DATEANLY
switches to Date Pattern Analysis.
EUROCNV
switches to Euro Conversion.
EUROTRI
switches to Currency Triangulation.
FLDEXITS
switches to Field Exits.
For example: You have selected “7 Encryption” on the criteria menu and you are entering encryption criteria and then you want to switch to data translation.
You could press PF3 to go back to the menu and then select “4 Translator” or you could enter the primary command DATATRAN on the data encryption criteria screen.
If you have already entered criteria for the set that is currently displayed, the primary command process assumes that you want to insert the new type of criteria after the current set.
Selection criteria
The Selection Criteria screen is displayed when you enter the SELECT (SEL) primary command on the Aging Criteria screen. See Selection-criteria for a sample of this screen and field descriptions.
Global criteria
The Global Criteria screen is displayed when you enter the GLOBAL (GBL) primary command in any of the Data Solutions Change or Selection Criteria screens. It lists all global variables defined with option G of the Criteria Menu. See Global Criteria for a sample of this screen and field descriptions.
Field mask
The Field Mask Criteria screen is displayed when you enter the Field Mask (FM) relational operator in the relational operator (RO) column on the Aging Criteria screen. See Field Mask for a sample of this screen and field descriptions.
Related topics