| GENERAL DESCRIPTION |
DataBase Integration Agreement between IFCAP V4.0
package and FileMan V19.0 for the use of and the KILLing of a local FileMan
variable in an Input Template.
The IFCAP Input Template uses the FileMan local variable D1 in the input
transform for field #40 in File #423, the CALM/LOG CODE SHEET file. The local
variable D1 is used as a counter for the multiple field 423.05, subfield .01.
IFCAP uses the counter within the Input Template to ensure that no more than
10 entries are made into the code sheet for this multiple. Prior to prompting
the user for entries into this field, the FileMan variable D1 is KILLed.
The reason or reasons for KILLing the FileMan local variable D1 and
subsequently using D1 as a counter have been obscured in the history of IFCAP
development.
The variable D1 is the internal record number within the multiple; it is
stored as piece 3 of the file or subfile header. It is not necessarily
accurate as the count of entries within the multiple. For example, the user
may make one or more deletions within the template, reducing the number of
entries. The user could then add more entries to the multiple. This scenario
could possibly increase the internal record number (D1) to a number greater
than 9, when there may actually be fewer than 9 entries. Based on the input
transform, the user would not be able to make the additional entries, although
in reality, more entries should be allowed.
In addition, piece 4 of the file or subfile header contains the number of
records in the file and/or subfile. Once again, this number cannot be
guaranteed as the accurate number of records in the file or subfile.
The use of D1 is an existing convention that has been in place for several
versions of IFCAP. We request the Integration Agreement with FileMan to
continue this use for IFCAP V4.0.
The Input Templates are used in the creation of CALM code sheets. Since FMS
will be replacing CALM, the use of the FileMan local variable will be needed
until all sites have converted from CALM to FMS. The next planned release of
IFCAP V5.0 will replace this function.
INTEGRATION POINT:
1. The IFCAP Input Template PRCFA TT982.00
FIRST EDIT FIELD: .1///CLM//
THEN EDIT FIELD: S Y=4//
THEN EDIT FIELD: STATION NUMBER//
THEN EDIT FIELD: TRANSACTION TYPE//
THEN EDIT FIELD: TRANSACTION DATE//
THEN EDIT FIELD: REFERENCE NUMBER//
THEN EDIT FIELD: YALD CODE//
THEN EDIT FIELD: K D1//
THEN EDIT FIELD: REC STA OR FCP//
THEN EDIT FIELD: REC STA OR FCP//
THEN EDIT FIELD: 1ST QTR AMOUNT//
THEN EDIT FIELD: 2ND QTR AMOUNT//
THEN EDIT FIELD: W !," "//
THEN EDIT FIELD: 3RD QTR AMOUNT//
THEN EDIT FIELD: I X="$" S Y=""//
THEN EDIT FIELD: 4TH QTR AMOUNT//
THEN EDIT FIELD: 998///$//
2. The Input Transform Using the FileMan Variable
STANDARD DATA DICTIONARY #423.05 -- REC STA OR FCP SUB-FILE 05/20/93
PAGE 1 STORED IN ^PRCF(423, (811
ENTRIES) SITE: IFA UCI: DVA,IFA
DATA NAME GLOBAL DATA ELEMENT TITLE
LOCATION TYPE
----------------------------------------------------------------
423.05,.01 REC STA OR FCP 0;1 FREE TEXT (Multiply
asked)
INPUT TRANSFORM: K:$L(X)>3!($L(X)<3)!'(X?3N) X
Q:'$D(X) I $D(D1),D1>9 W " ONLY
10 ENTRIES PER CODE SHEET ARE
PERMITTED",*7 K X
LAST EDITED: MAR 21, 1986
HELP-PROMPT: ANSWER MUST BE 3 CHARACTERS IN
LENGTH
DESCRIPTION: This is the 3 character receiving
station or fund control point.
NOTES: XXXX--CAN'T BE ALTERED EXCEPT BY
PROGRAMMER
3. FileMan Local Variable D1
When working below the main level of the file, DIE maintains the references to
the file hierarchy being handled in the variables DA and Dn (D0, D1, etc) in
which n varies according to the level of the file hierarchy.
DA always contains the item number of the record being handled. Dn indicates
the item numbers in the file hierarchy. D0 contains the main level record
number; D1 contains the first sub-file level sub-record number and D2 contains
the second sub-file level sub-record number.
|