STANDARD DATA DICTIONARY #414.02 -- DYNAMED IFCAP INTERFACE AUDIT FILE 3/24/25 PAGE 1
STORED IN ^PRCV(414.02, *** NO DATA STORED YET *** SITE: WWW.BMIRWIN.COM UCI: VISTA,VISTA (VERSION 5.1)
DATA NAME GLOBAL DATA
ELEMENT TITLE LOCATION TYPE
-----------------------------------------------------------------------------------------------------------------------------------
This file retains data that is normally deleted from IFCAP files. The data held in this file will be retained for a brief period
of time (TBD) and purged after this retention period.
It holds data that is specifically related to interface of IFCAP package to DynaMed (an outside entity).
DD ACCESS: @
RD ACCESS: @
WR ACCESS: @
DEL ACCESS: @
LAYGO ACCESS: @
AUDIT ACCESS: @
PRIMARY KEY: A (#59)
Uniqueness Index: B (#581)
File, Field: 1) DM DOC ID (414.02,.01)
CROSS
REFERENCED BY: RIL#(C), 2237#(D)
INDEXED BY: DM DOC ID (B)
414.02,.01 DM DOC ID 0;1 FREE TEXT (Required) (Key field)
INPUT TRANSFORM: K:$L(X)>16!($L(X)<9)!'(X'?1P.E) X
LAST EDITED: MAR 04, 2005
HELP-PROMPT: Answer must be 9-16 characters in length.
DESCRIPTION: This is DynaMed's unique number associated with each item that is sent on a request order from
DynaMed.
It is composed of 1 digit for Year concatenated with 3 digit Julian Date and a dash, concatenated
with 4 digit Sequential Number and a dash, concatenated up to 6 characters for the stockroom(ex
YDDD-9999-CCCCCC).
This number is provided by DynaMed, a user's input is not required. DynaMed allows 16 characters
maximum.
TECHNICAL DESCR: This number will be associated with an order request from DynaMed. Each order request will
identify a single item in Item Master File in IFCAP. It is recorded in this file for auditing
purpose and to ensure that requests bearing the same Document ID are only processed once by IFCAP.
A user is not allowed to edit this field.
UNEDITABLE
FIELD INDEX: B (#581) REGULAR IR LOOKUP & SORTING
Unique for: Key A (#59), File #414.02
Short Descr: Uniqueness Index for Key 'A' of File #414.02
Set Logic: S ^PRCV(414.02,"B",X,DA)=""
Kill Logic: K ^PRCV(414.02,"B",X,DA)
Whole Kill: K ^PRCV(414.02,"B")
X(1): DM DOC ID (414.02,.01) (Subscr 1)
414.02,1 ITEM 0;2 POINTER TO ITEM MASTER FILE (#441)
LAST EDITED: FEB 28, 2005
HELP-PROMPT: This field holds Item's internal entry number(IEN).
DESCRIPTION: An item's Internal Entry Number(IEN) is stored in this field. It is updated when RIL record is
built in IFCAP.
TECHNICAL DESCR:
This field should not be edited by a user.
414.02,2 VENDOR 0;3 POINTER TO VENDOR FILE (#440)
LAST EDITED: FEB 28, 2005
HELP-PROMPT: This fields holds Vendor's internal entry number(IEN).
DESCRIPTION: A vendor's Internal Entry Number(IEN) is stored in this field. It is populated when a RIL record is
built in IFCAP for DynaMed.
TECHNICAL DESCR:
This field should not be edited by a user.
414.02,3 ENTERED BY 0;4 POINTER TO NEW PERSON FILE (#200)
LAST EDITED: MAR 01, 2005
HELP-PROMPT: It identifies a person who entered the transaction (ex. RIL, 2237 or PC order transaction).
DESCRIPTION:
The user's DUZ, who entered the transaction is placed in this field.
TECHNICAL DESCR:
This field should not be edited by a user.
414.02,4 RIL# 0;5 FREE TEXT
INPUT TRANSFORM: K:$L(X)>25!($L(X)<12) X
LAST EDITED: MAR 09, 2005
HELP-PROMPT: Answer must be 12-25 characters in length.
DESCRIPTION:
This field holds a reference to RIL File 410.3, field .01 'Entry Number'.
TECHNICAL DESCR:
This data should not be edited.
CROSS-REFERENCE: 414.02^C
1)= S ^PRCV(414.02,"C",$E(X,1,30),DA)=""
2)= K ^PRCV(414.02,"C",$E(X,1,30),DA)
Index a RIL # for lookup.
414.02,5 DATE/TIME CREATED IN IFCAP 0;6 DATE
INPUT TRANSFORM: S %DT="ESTX" D ^%DT S X=Y K:Y<1 X
LAST EDITED: FEB 28, 2005
HELP-PROMPT: This time stamp refers to when a transactions was created in IFCAP.
DESCRIPTION: This field refers to Date and Time stamp when a transaction was created in IFCAP. (ex. A
transaction can be from REPETITIVE ITEM LIST (RIL) File #410.3 or CONTROL POINT ACTIVITY (CPA) File
#410)
TECHNICAL DESCR:
The data should be stored in internal FileMan format. This field should not be edited by a user.
414.02,6 DATE/TIME CREATED IN DYNAMED 0;7 DATE
INPUT TRANSFORM: S %DT="ESTX" D ^%DT S X=Y K:X<1 X
LAST EDITED: FEB 23, 2005
HELP-PROMPT: This time stamp refers to date & time when a Requisition was generated in DynaMed.
DESCRIPTION:
This time stamp refers to date & time when a Requisition was created in DynaMed.
TECHNICAL DESCR:
This field should not be edited by a user.
414.02,7 2237# 0;8 FREE TEXT
INPUT TRANSFORM: K:$L(X)>18!($L(X)<3) X
LAST EDITED: MAR 09, 2005
HELP-PROMPT: Answer must be 3-18 characters in length. This field holds the reference to entry made in CPA File
#410.
DESCRIPTION: This field holds the reference to entry made in CONTROL POINT ACTIVITY File #410, field .01
'Transaction Number'.
TECHNICAL DESCR:
This field should not be edited.
CROSS-REFERENCE: 414.02^D
1)= S ^PRCV(414.02,"D",$E(X,1,30),DA)=""
2)= K ^PRCV(414.02,"D",$E(X,1,30),DA)
Index a 2237 # for a lookup.
414.02,8 DATE/TIME REMOVED FROM IFCAP 0;9 DATE
INPUT TRANSFORM: S %DT="ESTX" D ^%DT S X=Y K:X<1 X
LAST EDITED: FEB 23, 2005
HELP-PROMPT: This refers to when a transaction was deleted from IFCAP.
DESCRIPTION:
This date and time will inform when a transaction (such as RIL or 2237) was deleted from IFCAP.
TECHNICAL DESCR:
This field should not be edited by a user.
414.02,9 WHO DELETED 0;10 POINTER TO NEW PERSON FILE (#200)
LAST EDITED: MAR 01, 2005
HELP-PROMPT: This field identifies the person who deleted a transaction containing this DM DOC ID from a file
(ex. files 410, 410.3).
DESCRIPTION: This field will hold the DUZ of the person who deleted the transaction containing this DM DOC ID
from a file (ex. 410, 410.3 or 442).
TECHNICAL DESCR:
This field should not be edited by a user.
414.02,10 PC ORDER# 0;11 FREE TEXT
INPUT TRANSFORM: K:$L(X)>15!($L(X)<10) X
LAST EDITED: FEB 28, 2005
HELP-PROMPT: Answer must be 10-15 characters in length. It is a Purchase Card Order#.
DESCRIPTION: This field will hold a Purchase Card Order external number that is PROCUREMENT & ACCOUNTIN G
TRANSACTIONS File #442, field's .01 value.
It is only meant for orders related to Purchase Card.
TECHNICAL DESCR:
This field should not be edited by a user.
414.02,11 RECEIVING 1;0 DATE Multiple #414.021 (Add New Entry without Asking)
DESCRIPTION:
This multiple is used to hold details about Receiving.
414.021,.01 DATE/TIME RR DELETED 0;1 DATE (Required)
INPUT TRANSFORM: S %DT="ESTXR" D ^%DT S X=Y K:X<1 X
LAST EDITED: MAR 01, 2005
HELP-PROMPT: A Date/Time when Receiving Report was deleted.
DESCRIPTION: This field refers to the date and time stamp when a certain Receiving Report(or Partial) was
deleted in IFCAP.
TECHNICAL DESCR:
This date should be in FileMan internal format.
CROSS-REFERENCE: 414.021^B
1)= S ^PRCV(414.02,DA(1),1,"B",$E(X,1,30),DA)=""
2)= K ^PRCV(414.02,DA(1),1,"B",$E(X,1,30),DA)
414.021,1 RR DELETED BY 0;2 POINTER TO NEW PERSON FILE (#200)
LAST EDITED: MAY 31, 2005
HELP-PROMPT: This field identifies the person who deleted a Receiving Report.
414.021,2 DATE/TIME RR CREATED 0;3 DATE
INPUT TRANSFORM: S %DT="ESTX" D ^%DT S X=Y K:X<1 X
LAST EDITED: MAR 01, 2005
HELP-PROMPT: A Date/Time when this Receiving Report was created.
DESCRIPTION:
A date and time stamp when this Receiving Report was created in IFCAP.
TECHNICAL DESCR:
It should be in FileMan internal format.
414.021,3 QTY RECEIVED 0;4 NUMBER (Required)
INPUT TRANSFORM: K:+X'=X!(X>999999)!(X<0)!(X?.E1"."3.N) X
LAST EDITED: MAR 01, 2005
HELP-PROMPT: Type a number between 0 and 999999, 2 Decimal Digits
DESCRIPTION:
A quantity received for an item on a purchase order.
TECHNICAL DESCR: In IFCAP a quantity for an item can be entered in decimals. (However, in DynaMed quantities will
not allowed to be in decimals.)
414.021,4 RR ITEM COST 0;5 NUMBER
INPUT TRANSFORM: K:+X'=X!(X>99999999)!(X<0)!(X?.E1"."3.N) X
LAST EDITED: FEB 28, 2005
HELP-PROMPT: Type a number between 0 and 99999999, 2 Decimal Digits
DESCRIPTION:
This is a unit cost of an item.
TECHNICAL DESCR:
It should not be modified by a user.
414.021,5 RR ITEM DISCNT 0;6 NUMBER
INPUT TRANSFORM: K:+X'=X!(X>99999999)!(X<0)!(X?.E1"."4.N) X
LAST EDITED: FEB 23, 2005
HELP-PROMPT: Type a number between 0 and 99999999, 3 Decimal Digits
DESCRIPTION:
This is a discount on an item.
TECHNICAL DESCR:
A user should NOT modify.
414.02,12 DATE NEEDED BY 0;12 DATE
INPUT TRANSFORM: S %DT="ESTX" D ^%DT S X=Y K:X<1 X
LAST EDITED: FEB 25, 2005
HELP-PROMPT: (No range limit on date)
DESCRIPTION:
This field is provided by DynaMed, it is this date that DynaMed anticipates receiving an item.
TECHNICAL DESCR: This date is received from DynaMed on a requisition which is entered in RIL, and then carried on to
2237, Purchase Order as the item is processed through IFCAP.
SOURCE OF DATA: DynaMed --Information Control
UNEDITABLE
414.02,13 ENTERED BY NAME 2;1 FREE TEXT
INPUT TRANSFORM: K:$L(X)>35!($L(X)<1) X
LAST EDITED: APR 13, 2005
HELP-PROMPT: Answer must be 1-35 characters in length.
DESCRIPTION: Enter the name of the user who entered this requisition in DynaMed in the format
Family(Last),Given(First). This name corresponds to the data in the ENTERED BY field #3.
The value must be 1-35 characters in length and should contain only uppercase alpha characters.
FILES POINTED TO FIELDS
ITEM MASTER (#441) ITEM (#1)
NEW PERSON (#200) ENTERED BY (#3)
WHO DELETED (#9)
RECEIVING:RR DELETED BY (#1)
VENDOR (#440) VENDOR (#2)
INPUT TEMPLATE(S):
PRINT TEMPLATE(S):
PRCV DYNAMED RIL'S NEED ACTIONMAY 13, 2005@10:52 USER #0 DYNAMED IFCAP INTERFACE AUDIT SEARCH
SORT TEMPLATE(S):
PRCV DYNAMED RIL'S NEED ACTIONMAY 13, 2005@10:51 USER #0
SORT BY: DATE/TIME CREATED IN DYNAMED// (DATE/TIME CREATED IN DYNAMED not null)
WITHIN DATE/TIME CREATED IN DYNAMED, SORT BY: RIL#// (RIL# not null)
FORM(S)/BLOCK(S):