STANDARD DATA DICTIONARY #420.14 -- PRCD FUND FILE 3/24/25 PAGE 1 STORED IN ^PRCD(420.14, (9 ENTRIES) SITE: WWW.BMIRWIN.COM UCI: VISTA,VISTA (VERSION 5.1) DATA NAME GLOBAL DATA ELEMENT TITLE LOCATION TYPE ----------------------------------------------------------------------------------------------------------------------------------- This file contains FUNDS used by the fund control points. POST-SELECTION ACTION : S PRCLKUP="" IDENTIFIED BY: BUDGET FISCAL YEAR BEGIN (#2)[R], BUDGET FISCAL YEAR END (#3)[R] PRIMARY KEY: A (#73) Uniqueness Index: UNQ (#791) File, Field: 1) FUND (420.14,.01) 2) BUDGET FISCAL YEAR BEGIN (420.14,2) 3) BUDGET FISCAL YEAR END (420.14,3) POINTED TO BY: FUND field (#.01) of the PRCD REQUIRED FIELDS File (#420.18) CROSS REFERENCED BY: FUND(B) INDEXED BY: FUND & BUDGET FISCAL YEAR BEGIN & BUDGET FISCAL YEAR END (UNQ) 420.14,.01 FUND 0;1 FREE TEXT (Required) (Key field) INPUT TRANSFORM: K:X[""""!($A(X)=45) X I $D(X) K:$L(X)>6!($L(X)<3)!'(X'?1P.E) X LAST EDITED: SEP 10, 2007 HELP-PROMPT: Answer must be 3-6 characters in length. DESCRIPTION: This is fund in this file. PRE-LOOKUP: S PRCLKUP=1 NOTES: XXXX--CAN'T BE ALTERED EXCEPT BY PROGRAMMER CROSS-REFERENCE: 420.14^B 1)= S ^PRCD(420.14,"B",$E(X,1,30),DA)="" 2)= K ^PRCD(420.14,"B",$E(X,1,30),DA) RECORD INDEXES: UNQ (#791) 420.14,1 DESCRIPTION 0;2 FREE TEXT (Required) INPUT TRANSFORM: K:$L(X)>45!($L(X)<1)!'(X'?1P.E) X LAST EDITED: DEC 08, 1993 HELP-PROMPT: Answer must be 1-45 characters in length. DESCRIPTION: This is a description of the fund. 420.14,2 BUDGET FISCAL YEAR BEGIN 0;3 NUMBER (Required) (Key field) INPUT TRANSFORM: K:+X'=X!(X>9999)!(X<1900)!(X?.E1"."1N.N) X LAST EDITED: SEP 10, 2007 HELP-PROMPT: Type a Number between 1900 and 9999, 0 Decimal Digits DESCRIPTION: This is used to store BUDGET FISCAL YEAR BEGIN data. NOTES: XXXX--CAN'T BE ALTERED EXCEPT BY PROGRAMMER RECORD INDEXES: UNQ (#791) 420.14,3 BUDGET FISCAL YEAR END 0;4 NUMBER (Required) (Key field) INPUT TRANSFORM: K:+X'=X!(X>9999)!(X<1900)!(X?.E1"."1N.N) X LAST EDITED: SEP 10, 2007 HELP-PROMPT: Type a Number between 1900 and 9999, 0 Decimal Digits DESCRIPTION: This is used to store BUDGET FISCAL YEAR END data. NOTES: XXXX--CAN'T BE ALTERED EXCEPT BY PROGRAMMER RECORD INDEXES: UNQ (#791) 420.14,4.5 FUND PROGRAM TRANSFER ALLOWED 0;7 SET (Required) 'Y' FOR YES; 'N' FOR NO; LAST EDITED: DEC 17, 1993 DESCRIPTION: This will allow program/subprogram transfers within a fund if it is 'yes'. TECHNICAL DESCR: This will allow program/subprogram transfers within a fund if it is 'yes'. 420.14,4.7 GROSS/NET 0;5 SET (Required) 'G' FOR GROSS; 'N' FOR NET; LAST EDITED: APR 07, 1994 DESCRIPTION: This is used to store GROSS/NET data. 420.14,5 STATUS 0;6 POINTER TO PRCD SD STATUS FILE (#420.1999) (Required) LAST EDITED: DEC 20, 1993 HELP-PROMPT: Enter a status DESCRIPTION: This is used to store STATUS data. NOTES: XXXX--CAN'T BE ALTERED EXCEPT BY PROGRAMMER FILES POINTED TO FIELDS PRCD SD STATUS (#420.1999) STATUS (#5) File #420.14 Record Indexes: UNQ (#791) RECORD REGULAR IR LOOKUP & SORTING Unique for: Key A (#73), File #420.14 Short Descr: Unique xref by Fund and beginning and ending Fiscal Years. Description: This cross reference provides a unique entry for every FUND and FISCAL YEAR combination. Set Logic: S ^PRCD(420.14,"UNQ",$E(X(1),1,30),$E(X(2),1,4),$E(X(3),1,4),DA)="" Kill Logic: K ^PRCD(420.14,"UNQ",$E(X(1),1,30),$E(X(2),1,4),$E(X(3),1,4),DA) Whole Kill: K ^PRCD(420.14,"UNQ") X(1): FUND (420.14,.01) (Subscr 1) (Len 30) (forwards) X(2): BUDGET FISCAL YEAR BEGIN (420.14,2) (Subscr 2) (Len 4) (forwards) X(3): BUDGET FISCAL YEAR END (420.14,3) (Subscr 3) (Len 4) (forwards) INPUT TEMPLATE(S): PRINT TEMPLATE(S): PRCD FUND AUG 10, 1994@11:22 USER #0 IFCAP Fund List SORT TEMPLATE(S): FORM(S)/BLOCK(S):