STANDARD DATA DICTIONARY #417 -- FMS TRANSACTIONS FILE 6/27/25 PAGE 1
STORED IN ^PRCS(417, *** NO DATA STORED YET *** SITE: WWW.BMIRWIN.COM UCI: VISTA,VISTA (VERSION 5.1)
DATA NAME GLOBAL DATA
ELEMENT TITLE LOCATION TYPE
-----------------------------------------------------------------------------------------------------------------------------------
This file holds FMS reconcilliation data for a Fiscal Service. Each entry contains the site, control point fiscal year, quarter,
transaction amount, and any FMS generated data.
CROSS
REFERENCED BY: FMS REFERENCE(B), STATION-FY-QUARTER-CP(C), STATUS(ST)
417,.01 FMS REFERENCE 0;1 FREE TEXT (Required)
FMS REFERENCE#
INPUT TRANSFORM: K:X[""""!($A(X)=45) X I $D(X) K:$L(X)>50!($L(X)<6) X
LAST EDITED: APR 04, 1994
HELP-PROMPT: Answer must be 6-50 characters in length.
DESCRIPTION: This is the FMS reference number. It is created in IFCAP and has the format FMS trans.
number_transmission date.
SOURCE OF DATA: IFCAP
CROSS-REFERENCE: 417^B
1)= S ^PRCS(417,"B",X,DA)=""
2)= K ^PRCS(417,"B",X,DA)
417,1 BEGINNING BUDGET FY 0;2 NUMBER
INPUT TRANSFORM: K:+X'=X!(X>99)!(X<0)!(X?.E1"."1N.N) X
LAST EDITED: FEB 02, 1994
HELP-PROMPT: Type a Number between 0 and 99, 0 Decimal Digits
DESCRIPTION:
This is the beginning budget fiscal year for the transaction.
417,2 ENDING BUDGET FY 0;3 NUMBER
INPUT TRANSFORM: K:+X'=X!(X>99)!(X<0)!(X?.E1"."1N.N) X
LAST EDITED: FEB 02, 1994
HELP-PROMPT: Type a Number between 0 and 99, 0 Decimal Digits
DESCRIPTION:
This is the ending budget fiscal year for the transaction.
417,3 FISCAL YEAR 0;4 FREE TEXT
INPUT TRANSFORM: K:$L(X)>2!($L(X)<2)!'(X?2N) X
LAST EDITED: FEB 23, 1998
HELP-PROMPT: Answer must be 2 characters in length.
DESCRIPTION:
This is the fiscal year for the adjustment.
417,4 FISCAL QUARTER 0;5 NUMBER
INPUT TRANSFORM: K:+X'=X!(X>4)!(X<1)!(X?.E1"."1N.N) X
LAST EDITED: MAR 07, 1994
HELP-PROMPT: Type a Number between 1 and 4, 0 Decimal Digits
DESCRIPTION:
This field holds the quarter for the transaction retirned from FMS.
417,5 FUND 0;6 FREE TEXT
INPUT TRANSFORM: K:$L(X)>6!($L(X)<1) X
LAST EDITED: MAR 07, 1994
HELP-PROMPT: Answer must be 1-6 characters in length.
DESCRIPTION:
This is the fund for the transaction which was returned from FMS.
417,6 ADMINISTRATION/STAFF OFFICE 0;7 FREE TEXT
INPUT TRANSFORM: K:$L(X)>4!($L(X)<1) X
LAST EDITED: MAR 07, 1994
HELP-PROMPT: Answer must be 1-4 characters in length.
DESCRIPTION:
This is the administration/staff office returned on the adjustment.
417,7 STATION 0;8 FREE TEXT
INPUT TRANSFORM: K:$L(X)>7!($L(X)<3) X
LAST EDITED: MAR 07, 1994
HELP-PROMPT: Answer must be 3-7 characters in length.
DESCRIPTION:
This is the station for the transaction returned from FMS.
417,8 PROGRAM 0;9 FREE TEXT
INPUT TRANSFORM: K:$L(X)>6!($L(X)<1) X
LAST EDITED: MAR 09, 1995
HELP-PROMPT: Answer must be 1-6 characters in length.
DESCRIPTION:
This is the program (optional) returned for the transaction.
417,9 FCP/PROJECT 0;10 FREE TEXT
INPUT TRANSFORM: K:$L(X)>9!($L(X)<2) X
LAST EDITED: MAR 07, 1994
HELP-PROMPT: Answer must be 2-9 characters in length.
DESCRIPTION:
This is the FMS FCP/Project reference for the control point.
417,10 COST CENTER 0;11 FREE TEXT
INPUT TRANSFORM: K:$L(X)>7!($L(X)<3) X
LAST EDITED: MAR 07, 1994
HELP-PROMPT: Answer must be 3-7 characters in length.
DESCRIPTION:
This is the cost center returned by FMS.
417,11 SUB COST CENTER 0;12 FREE TEXT
INPUT TRANSFORM: K:$L(X)>2!($L(X)<1) X
LAST EDITED: MAR 07, 1994
HELP-PROMPT: Answer must be 1-2 characters in length.
DESCRIPTION:
This is the sub cost center (optional) associated with the cost center.
417,12 REPORTING CATEGORY 0;13 FREE TEXT
INPUT TRANSFORM: K:$L(X)>2!($L(X)<1) X
LAST EDITED: MAR 07, 1994
HELP-PROMPT: Answer must be 1-2 characters in length.
DESCRIPTION:
This is the FMS reporting category for the transaction.
417,13 JOB NUMBER 0;14 FREE TEXT
INPUT TRANSFORM: K:$L(X)>8!($L(X)<2) X
LAST EDITED: MAR 07, 1994
HELP-PROMPT: Answer must be 2-8 characters in length.
DESCRIPTION:
This is the job number (optional) for the transaction.
417,14 BUDGET OBJECT CODE 0;15 FREE TEXT
INPUT TRANSFORM: K:$L(X)>4!($L(X)<2) X
LAST EDITED: MAR 07, 1994
HELP-PROMPT: Answer must be 2-4 characters in length.
DESCRIPTION:
This is the budget object code for the transaction.
417,15 BUDGET OBJECT CLASS 0;16 FREE TEXT
INPUT TRANSFORM: K:$L(X)>4!($L(X)<2) X
LAST EDITED: MAR 07, 1994
HELP-PROMPT: Answer must be 2-4 characters in length.
DESCRIPTION:
This is the budget object class for the transaction.
417,16 TRANSACTION CODE 0;17 FREE TEXT
INPUT TRANSFORM: K:$L(X)>2!($L(X)<1) X
LAST EDITED: MAR 07, 1994
HELP-PROMPT: Answer must be 1-2 characters in length.
DESCRIPTION:
This is the transaction code for the transaction.
417,17 TRANSACTION NUMBER 0;18 FREE TEXT
INPUT TRANSFORM: K:$L(X)>11!($L(X)<4) X
LAST EDITED: MAR 07, 1994
HELP-PROMPT: Answer must be 4-11 characters in length.
DESCRIPTION: This is the transaction number (purchase order number) returned by FMS. As all FMS generated
transactions do not necessarily pertain to a purchase order, this number is not always returned.
417,18 LINE NUMBER 0;19 FREE TEXT
INPUT TRANSFORM: K:$L(X)>3!($L(X)<1) X
LAST EDITED: MAR 07, 1994
HELP-PROMPT: Answer must be 1-3 characters in length.
DESCRIPTION:
This is the line number for the transaction returned from FMS.
417,19 AMOUNT 0;20 FREE TEXT
INPUT TRANSFORM: K:$L(X)>17!($L(X)<2) X
LAST EDITED: MAR 07, 1994
HELP-PROMPT: Answer must be 2-17 characters in length.
DESCRIPTION:
This is the adjustment amount returned on the transaction.
417,20 STATION-FY-QUARTER-CP 0;21 FREE TEXT
INPUT TRANSFORM: K:$L(X)>20!($L(X)<6) X
LAST EDITED: MAR 29, 1994
HELP-PROMPT: Answer must be 6-20 characters in length.
DESCRIPTION: This field contains the station,fiscal year, quarter,and control point. It is used to set up a
cross reference for creation of FMS 820 reports.
CROSS-REFERENCE: 417^C
1)= S ^PRCS(417,"C",$E(X,1,30),DA)=""
2)= K ^PRCS(417,"C",$E(X,1,30),DA)
This cross reference is used to sort entries by date and control point number, for use in creating
FMS 820 reports.
417,21 TRANSACTION DATE 0;22 DATE
INPUT TRANSFORM: S %DT="E" D ^%DT S X=Y K:Y<1 X
LAST EDITED: AUG 29, 1994
DESCRIPTION:
This is the transaction date returned in the header of the FMS transmission.
417,22 CONVERTED RECORD 1;1 FREE TEXT
INPUT TRANSFORM: K:$L(X)>12!($L(X)<1) X
LAST EDITED: MAR 11, 1996
HELP-PROMPT: Answer must be 1-12 characters in length.
DESCRIPTION:
This field is used to store the 410 entry for the 820 record.
417,51 STATUS 0;23 SET
'P' FOR POSTED;
'D' FOR DUPLICATE;
'N' FOR NONE;
LAST EDITED: MAY 30, 1996
DESCRIPTION:
Shows status of FMS transactions.
CROSS-REFERENCE: 417^ST
1)= S ^PRCS(417,"ST",$E(X,1,30),DA)=""
2)= K ^PRCS(417,"ST",$E(X,1,30),DA)
This is an index by status.
INPUT TEMPLATE(S):
PRINT TEMPLATE(S):
SORT TEMPLATE(S):
FORM(S)/BLOCK(S):