STANDARD DATA DICTIONARY #414.06 -- IFCAP/ECMS TRANSACTION FILE 3/24/25 PAGE 1 STORED IN ^PRCV(414.06, *** NO DATA STORED YET *** SITE: WWW.BMIRWIN.COM UCI: VISTA,VISTA (VERSION 5.1) DATA NAME GLOBAL DATA ELEMENT TITLE LOCATION TYPE ----------------------------------------------------------------------------------------------------------------------------------- This file is designed to hold the various types of transactions that support communication for the IFCAP and the Electronic Contract Management System (eCMS) interface. Reports from this file will be used by the IFCAP users to follow the interface activity to assure that communication with the eCMS vendor portal is timely and effective, and to provide contact information if needed. CROSS REFERENCED BY: EVENT DATE(AED), SUB-STATION(ASB), STATION(ASN), EVENT TYPE(ATY), IFCAP REFERENCE NUMBER(B) INDEXED BY: ECMS EMAIL (ACONTACT), IFCAP REFERENCE NUMBER (ACP), ECMS EMAIL (AUNQEC), IFCAP REFERENCE NUMBER (AUNQFCP) 414.06,.01 IFCAP REFERENCE NUMBER 0;1 FREE TEXT (Required) INPUT TRANSFORM: K:$L(X)>30!($L(X)<3)!'(X'?1P.E) X LAST EDITED: JUN 20, 2013 HELP-PROMPT: Answer must be 3-30 characters in length. DESCRIPTION: The unique IFCAP reference number for this transaction. For transactions involving purchase requests (2237) this will be the text value of the Control Point Activity Transaction Number needed by the Electronic Contract Management System (eCMS). CROSS-REFERENCE: 414.06^B 1)= S ^PRCV(414.06,"B",$E(X,1,30),DA)="" 2)= K ^PRCV(414.06,"B",$E(X,1,30),DA) FIELD INDEX: ACP (#978) REGULAR IR SORTING ONLY Short Descr: Fund control point Description: Index uses only the fund control point portion of the reference number. Set Logic: S ^PRCV(414.06,"ACP",$E(X,1,30),DA)="" Kill Logic: K ^PRCV(414.06,"ACP",$E(X,1,30),DA) Whole Kill: K ^PRCV(414.06,"ACP") X(1): IFCAP REFERENCE NUMBER (414.06,.01) (Subscr 1) (Len 30) (forwards) Transform (Storage): S X=$P(X,"-",4) FIELD INDEX: AUNQFCP (#1118) REGULAR IR SORTING ONLY Short Descr: List of all unique FCPs. Description: Index uses only the fund control point portion of the reference number. The Set Condition ensures that only one instance of any fund control point is in the index. Set Logic: S ^PRCV(414.06,"AUNQFCP",$E(X,1,30),DA)="" Set Cond: S X=$D(^PRCV(414.06,"AUNQFCP",X))'=10 Kill Logic: K ^PRCV(414.06,"AUNQFCP",$E(X,1,30),DA) Whole Kill: K ^PRCV(414.06,"AUNQFCP") X(1): IFCAP REFERENCE NUMBER (414.06,.01) (Subscr 1) (Len 30) (forwards) Transform (Storage): S X=$P(X,"-",4) 414.06,.02 EXTERNAL REFERENCE NUMBER 0;2 FREE TEXT INPUT TRANSFORM: K:$L(X)>10!($L(X)<1) X LAST EDITED: MAY 11, 2012 HELP-PROMPT: Answer must be 1-10 characters in length. DESCRIPTION: The unique Electronic Contract Management System (eCMS) identifier ActionUID, which is generated by eCMS and returned to IFCAP when the 2237 is imported into eCMS. 414.06,.03 TRANSACTION STATUS 0;4 FREE TEXT INPUT TRANSFORM: K:$L(X)>40!($L(X)<2) X LAST EDITED: MAY 21, 2012 HELP-PROMPT: Answer must be 2-40 characters in length. DESCRIPTION: The text of the most recently filed transaction event type. 414.06,1 REQUEST RECORD 0;3 POINTER TO CONTROL POINT ACTIVITY FILE (#410) (Required) LAST EDITED: MAY 11, 2012 HELP-PROMPT: If this transaction originated from IFCAP user actions, enter the 2237 transaction number associated with that action. DESCRIPTION: The 2237 document associated with this transaction. 414.06,10 EVENT 1;0 DATE Multiple #414.061 (Add New Entry without Asking) DESCRIPTION: This multiple contains the data specific to individual transaction events. 414.061,.01 EVENT DATE 0;1 DATE (Required) INPUT TRANSFORM: S %DT="ESTXR" D ^%DT S X=Y K:Y<1 X LAST EDITED: JUL 26, 2012 HELP-PROMPT: This is the date/time the event occurred. DESCRIPTION: Date of messaging event. CROSS-REFERENCE: 414.061^B 1)= S ^PRCV(414.06,DA(1),1,"B",$E(X,1,30),DA)="" 2)= K ^PRCV(414.06,DA(1),1,"B",$E(X,1,30),DA) CROSS-REFERENCE: 414.06^AED 1)= S ^PRCV(414.06,"AED",$E(X,1,30),DA(1),DA)="" 2)= K ^PRCV(414.06,"AED",$E(X,1,30),DA(1),DA) File wide Event Date for reporting. 414.061,.02 EVENT TYPE 0;2 POINTER TO IFCAP/ECMS EVENT TYPE FILE (#414.07) (Required) LAST EDITED: FEB 20, 2013 HELP-PROMPT: Select the event type. DESCRIPTION: The type of message associated with this transaction event. CROSS-REFERENCE: 414.06^ATY 1)= S ^PRCV(414.06,"ATY",$E(X,1,30),DA(1),DA)="" 2)= K ^PRCV(414.06,"ATY",$E(X,1,30),DA(1),DA) File wide to assist with sorting event types. 414.061,.03 HL7 MESSAGE ID 0;3 FREE TEXT INPUT TRANSFORM: K:$L(X)>30!($L(X)<2) X LAST EDITED: JUN 13, 2012 HELP-PROMPT: Answer must be 2-30 characters in length. DESCRIPTION: The unique ID of the HL7 Application message. 414.061,1 STATION 1;1 FREE TEXT INPUT TRANSFORM: K:$L(X)>6!($L(X)<2) X LAST EDITED: JUN 20, 2012 HELP-PROMPT: Answer must be 2-6 characters in length. DESCRIPTION: The number of the primary station associated with this transaction event. CROSS-REFERENCE: 414.06^ASN 1)= S ^PRCV(414.06,"ASN",$E(X,1,30),DA(1),DA)="" 2)= K ^PRCV(414.06,"ASN",$E(X,1,30),DA(1),DA) File wide on Station for reporting. 414.061,2 SUB-STATION 1;2 FREE TEXT INPUT TRANSFORM: K:$L(X)>6!($L(X)<2) X LAST EDITED: JUL 06, 2012 HELP-PROMPT: Answer must be 2-6 characters in length. DESCRIPTION: The number of the substation facility associated with this transaction event. CROSS-REFERENCE: 414.06^ASB 1)= S ^PRCV(414.06,"ASB",$E(X,1,30),DA(1),DA)="" 2)= K ^PRCV(414.06,"ASB",$E(X,1,30),DA(1),DA) File wide to facilitate use of Substation data 414.061,3 IFCAP USER 1;3 POINTER TO NEW PERSON FILE (#200) LAST EDITED: JUN 13, 2012 HELP-PROMPT: Select the IFCAP user. DESCRIPTION: The IFCAP user associated with the generation of this outbound transaction event. 414.061,5 ECMS PHONE 1;5 FREE TEXT INPUT TRANSFORM: K:$L(X)>30!($L(X)<2) X LAST EDITED: JUN 13, 2012 HELP-PROMPT: Answer must be 2-30 characters in length. DESCRIPTION: The phone number of the eCMS user associated with this transaction event. 414.061,6 ECMS EMAIL 1;6 FREE TEXT INPUT TRANSFORM: K:$L(X)>60!($L(X)<2) X LAST EDITED: APR 09, 2013 HELP-PROMPT: Answer must be 2-60 characters in length. DESCRIPTION: The email address for the eCMS user associated with this transaction event. FIELD INDEX: ACONTACT (#977) REGULAR IR SORTING ONLY WHOLE FILE (#414.06) Short Descr: ECMS CONTACT Description: File wide to assist with the sorting of eCMS Contact information. Set Logic: S ^PRCV(414.06,"ACONTACT",$E(X,1,60),DA(1),DA)="" Kill Logic: K ^PRCV(414.06,"ACONTACT",$E(X,1,60),DA(1),DA) Whole Kill: K ^PRCV(414.06,"ACONTACT") X(1): ECMS EMAIL (414.061,6) (Subscr 1) (Len 60) (forwards) Transform (Storage): S X=$$CONTACT^PRCHJTA(X) FIELD INDEX: AUNQEC (#1117) REGULAR IR SORTING ONLY WHOLE FILE (#414.06) Short Descr: Unique eCMS Contact Description: This index provides a list of unique eCMS email addresses in a format compatible with end user selection. The Set Condition ensures that only one instance of any ECMS EMAIL is in the index. The Storage Transform converts the email address into a format that parses it into a form more suitable for sorting. Set Logic: S ^PRCV(414.06,"AUNQEC",$E(X,1,90),DA(1),DA)="" Set Cond: S X=$D(^PRCV(414.06,"AUNQEC",X))'=10 Kill Logic: K ^PRCV(414.06,"AUNQEC",$E(X,1,90),DA(1),DA) Whole Kill: K ^PRCV(414.06,"AUNQEC") X(1): ECMS EMAIL (414.061,6) (Subscr 1) (Len 90) (forwards) Transform (Storage): S X=$$CONTACT^PRCHJTA(X)_" "_X 414.061,7 RETURN/CANCEL DATE/TIME 1;7 DATE INPUT TRANSFORM: S %DT="ESTXR" D ^%DT S X=Y K:Y<1 X LAST EDITED: JUN 13, 2012 HELP-PROMPT: Enter the date and time the 2237 was returned or canceled from within eCMS. DESCRIPTION: The date and time the 2237 was returned or canceled from within eCMS. 414.061,10 RETURN/CANCEL REASON 2;1 FREE TEXT INPUT TRANSFORM: K:$L(X)>45!($L(X)<2) X LAST EDITED: JUN 13, 2012 HELP-PROMPT: Answer must be 2-45 characters in length. DESCRIPTION: The reason that the 2237 was returned or canceled. 414.061,11 TRANSACTION COMMENTS 2;2 FREE TEXT INPUT TRANSFORM: K:$L(X)>100!($L(X)<2) X LAST EDITED: JUN 13, 2012 HELP-PROMPT: Answer must be 2-100 characters in length. DESCRIPTION: Other comments associated with this transaction event. 414.061,15 ERROR LOG 3;0 Multiple #414.0613 (Add New Entry without Asking) DESCRIPTION: These are various business level errors that are associated with this event. 414.0613,.01 ERROR LOG 0;1 FREE TEXT INPUT TRANSFORM: K:$L(X)>120!($L(X)<2) X LAST EDITED: JUN 13, 2012 HELP-PROMPT: Answer must be 2-120 characters in length. DESCRIPTION: Errors and associated text. CROSS-REFERENCE: 414.0613^B 1)= S ^PRCV(414.06,DA(2),1,DA(1),3,"B",$E(X,1,30),DA)="" 2)= K ^PRCV(414.06,DA(2),1,DA(1),3,"B",$E(X,1,30),DA) FILES POINTED TO FIELDS CONTROL POINT ACTIVITY (#410) REQUEST RECORD (#1) IFCAP/ECMS EVENT TYPE (#414.07) EVENT:EVENT TYPE (#.02) NEW PERSON (#200) EVENT:IFCAP USER (#3) INPUT TEMPLATE(S): PRINT TEMPLATE(S): SORT TEMPLATE(S): FORM(S)/BLOCK(S):