Home   Package List   Routine Alphabetical List   Global Alphabetical List   FileMan Files List   FileMan Sub-Files List   Package Component Lists   Package-Namespace Mapping  
Info |  Desc |  Directly Accessed By Routines |  Accessed By FileMan Db Calls |  Pointer To FileMan Files |  Fields |  All
Print Page as PDF
Global: ^BDWXLOG

Package: Data Warehouse Export System

Global: ^BDWXLOG


Information

FileMan FileNo FileMan Filename Package
90213 BDW DATA WAREHOUSE EXPORT LOG Data Warehouse Export System

Description

Directly Accessed By Routines, Total: 17

Package Total Routines
Data Warehouse Export System 17 BDWBHL    BDWBHL1    BDWDDR    BDWDLOG    BDWEPRN    BDWPURG    BDWRDR    BDWRDR2
BDWRDRI2    BDWRDRI3    BDWRED1    BDWREDO    BDWRERR    BDWSR    BDWSR1    BDWSRP
BDWSRP5    

Accessed By FileMan Db Calls, Total: 12

Package Total Routines
Data Warehouse Export System 12 BDWBHL    BDWDDR    BDWDLOG    BDWEPRN    BDWRDR    BDWRDRI    BDWRDRI2    BDWRED1
BDWREDO    BDWRSET    BDWSR    BDWSRP    

Pointer To FileMan Files, Total: 5

Package Total FileMan Files
IHS Patient 2 PATIENT(#9000001)[#90213.06101(.01), #90213.4101(.01)]    VISIT(#9000010)[#90213.05101(.01), #90213.2101(.01)]    
Kernel 1 NEW PERSON(#200)[8801]    
Patient Care Component 1 PCC DATA TRANS ERROR CODES(#9001005.2)[.16]    
Utility Tables 1 LOCATION(#9999999.06)[.09]    

Fields, Total: 38

Field # Name Loc Type Details
.001 NUMBER NUMBER

  • INPUT TRANSFORM:  K:+X'=X!(X>9999)!(X<1)!(X?.E1"."1N.N) X
  • HELP-PROMPT:  GENERATED
    UNEDITABLE
.01 BEGINNING DATE 0;1 DATE
************************REQUIRED FIELD************************

  • INPUT TRANSFORM:  S %DT="EX" D ^%DT S X=Y K:DTX) X
  • LAST EDITED:  JUL 25, 2001
  • HELP-PROMPT:  TYPE A DATE BETWEEN 1/1/1900 AND DT
  • DESCRIPTION:  
    This will be the beginning VISIT date if this export is a 're-export' of old data in a date range.  This will be the beginning posting or modified date if this is a regular export.
  • DELETE TEST:  .01,0)= I 1
  • CROSS-REFERENCE:  90213^B
    1)= S ^BDWXLOG("B",$E(X,1,30),DA)=""
    2)= K ^BDWXLOG("B",$E(X,1,30),DA)
.02 ENDING DATE 0;2 DATE
************************REQUIRED FIELD************************

  • INPUT TRANSFORM:  S %DT="EX" D ^%DT S X=Y K:DTX) X
  • LAST EDITED:  JUL 25, 2001
  • HELP-PROMPT:  TYPE A DATE BETWEEN 1/1/1900 AND DT
  • DESCRIPTION:  
    This will be the ending VISIT date if this export is a 're-export' of old data in a date range.  This will be the ending posting or modified date if this is a regular export.
.03 RUN START DATE/TIME 0;3 DATE
************************REQUIRED FIELD************************

  • INPUT TRANSFORM:  S %DT="ESTXR" D ^%DT S X=Y K:DTX) X
  • LAST EDITED:  AUG 17, 2001
  • HELP-PROMPT:  TYPE A DATE BETWEEN 1986 AND DT
.04 RUN STOP DATE/TIME 0;4 DATE
************************REQUIRED FIELD************************

  • INPUT TRANSFORM:  S %DT="ESTXR" D ^%DT S X=Y K:DTX) X
  • LAST EDITED:  AUG 16, 2001
  • HELP-PROMPT:  TYPE A DATE BETWEEN 1986 AND DT
.05 COUNT OF VISITS SKIPPED (ALL) 0;5 NUMBER

  • INPUT TRANSFORM:  K:+X'=X!(X>9999999)!(X<0)!(X?.E1"."1N.N) X
  • LAST EDITED:  APR 01, 2003
  • HELP-PROMPT:  Type a Number between 0 and 9999999, 0 Decimal Digits
.06 COUNT OF TXS (REG+PCC) 0;6 NUMBER
************************REQUIRED FIELD************************

  • INPUT TRANSFORM:  K:+X'=X!(X>9999999)!(X<0)!(X?.E1"."1N.N) X
  • LAST EDITED:  APR 01, 2003
  • HELP-PROMPT:  Type a Number between 0 and 9999999, 0 Decimal Digits
.07 EXPORT TYPE 0;7 SET
************************REQUIRED FIELD************************
  • 'R' FOR REGULAR EXPORT;
  • 'D' FOR VISIT DATE RANGE EXPORT;

  • LAST EDITED:  JUL 25, 2001
    UNEDITABLE
.08 COUNT OF VISITS PROCESSED 0;8 NUMBER
************************REQUIRED FIELD************************

  • INPUT TRANSFORM:  K:+X'=X!(X>9999999)!(X<0)!(X?.E1"."1N.N) X
  • LAST EDITED:  AUG 16, 2001
  • HELP-PROMPT:  Type a Number between 0 and 9999999, 0 Decimal Digits
.09 RUN LOCATION 0;9 POINTER TO LOCATION FILE (#9999999.06)
************************REQUIRED FIELD************************
LOCATION(#9999999.06)

  • LAST EDITED:  JUN 08, 1987
    UNEDITABLE
.11 # REG MESSAGES 0;11 NUMBER

  • INPUT TRANSFORM:  K:+X'=X!(X>9999999)!(X<0)!(X?.E1"."1N.N) X
  • LAST EDITED:  APR 01, 2003
  • HELP-PROMPT:  Type a Number between 0 and 9999999, 0 Decimal Digits
.12 MESSAGE HEADER 0;12 FREE TEXT

  • INPUT TRANSFORM:  K:$L(X)>30!($L(X)<1) X
  • LAST EDITED:  APR 01, 2003
  • HELP-PROMPT:  Answer must be 1-30 characters in length.
.13 RUN TIME 0;13 FREE TEXT

  • INPUT TRANSFORM:  K:$L(X)>20!($L(X)<1) X
  • LAST EDITED:  AUG 16, 2001
  • HELP-PROMPT:  Answer must be 1-20 characters in length.
.14 TRAILER MESSAGE # 0;14 FREE TEXT

  • INPUT TRANSFORM:  K:$L(X)>30!($L(X)<1) X
  • LAST EDITED:  APR 01, 2003
  • HELP-PROMPT:  Answer must be 1-30 characters in length.
.15 TRANSMISSION STATUS 0;15 SET
************************REQUIRED FIELD************************
  • 'C' FOR SUCCESSFULLY COMPLETED;
  • 'Q' FOR QUEUED TO RUN;
  • 'R' FOR RUNNING;
  • 'F' FOR FAILED DUE TO ERROR;

  • LAST EDITED:  APR 01, 2003
.16 PROCESSING ERROR ENCOUNTERED 0;16 POINTER TO PCC DATA TRANS ERROR CODES FILE (#9001005.2) PCC DATA TRANS ERROR CODES(#9001005.2)

  • LAST EDITED:  JUN 06, 1991
.18 NUMBER OF VISITS EXPORTED 0;18 NUMBER

  • INPUT TRANSFORM:  K:+X'=X!(X>999999)!(X<0)!(X?.E1"."1N.N) X
  • LAST EDITED:  JUN 07, 1999
  • HELP-PROMPT:  Type a Number between 0 and 999999, 0 Decimal Digits
.19 NUMBER OF PC EXPORTED 0;19 NUMBER

  • INPUT TRANSFORM:  K:+X'=X!(X>9999999)!(X<0)!(X?.E1"."1N.N) X
  • LAST EDITED:  JUN 11, 2014
  • HELP-PROMPT:  Type a number between 0 and 9999999, 0 decimal digits.
.21 AUDIT FILE 0;21 FREE TEXT

  • INPUT TRANSFORM:  K:$L(X)>40!($L(X)<1) X
  • LAST EDITED:  MAY 18, 2004
  • HELP-PROMPT:  Answer must be 1-40 characters in length.
.22 REDO? 0;22 SET
  • '1' FOR YES;

  • LAST EDITED:  MAY 05, 2005
.23 HEADER RECORD EXPORT TYPE 0;23 FREE TEXT

  • INPUT TRANSFORM:  K:$L(X)>3!($L(X)<3) X
  • LAST EDITED:  MAR 07, 2007
  • HELP-PROMPT:  Answer must be 3 characters in length.
2101 VISITS 21;0 POINTER Multiple #90213.2101 90213.2101

  • DESCRIPTION:  
    This multiple contains the 'visit' DFN for each visit that generated a PCIS transaction during this run.
3101 DEMO PATIENT RECORDS 31;1 NUMBER

  • INPUT TRANSFORM:  K:+X'=X!(X>9999999)!(X<0)!(X?.E1"."1N.N) X
  • LAST EDITED:  APR 01, 2003
  • HELP-PROMPT:  Type a Number between 0 and 9999999, 0 Decimal Digits
3102 ZERO DEPENDENT ENTRIES 31;2 NUMBER

  • INPUT TRANSFORM:  K:+X'=X!(X>9999999)!(X<0)!(X?.E1"."1N.N) X
  • LAST EDITED:  APR 01, 2003
  • HELP-PROMPT:  Type a Number between 0 and 9999999, 0 Decimal Digits
3103 DELETED VISITS NEVER SENT 31;3 NUMBER

  • INPUT TRANSFORM:  K:+X'=X!(X>9999999)!(X<0)!(X?.E1"."1N.N) X
  • LAST EDITED:  APR 01, 2003
  • HELP-PROMPT:  Type a Number between 0 and 9999999, 0 Decimal Digits
3104 NO PATIENT 31;4 NUMBER

  • INPUT TRANSFORM:  K:+X'=X!(X>9999999)!(X<0)!(X?.E1"."1N.N) X
  • LAST EDITED:  APR 01, 2003
  • HELP-PROMPT:  Type a Number between 0 and 9999999, 0 Decimal Digits
3105 NO LOCATION OF ENC 31;5 NUMBER

  • INPUT TRANSFORM:  K:+X'=X!(X>9999999)!(X<0)!(X?.E1"."1N.N) X
  • LAST EDITED:  APR 01, 2003
  • HELP-PROMPT:  Type a Number between 0 and 9999999, 0 Decimal Digits
3106 NO TYPE OF VISIT 31;6 NUMBER

  • INPUT TRANSFORM:  K:+X'=X!(X>9999999)!(X<0)!(X?.E1"."1N.N) X
  • LAST EDITED:  APR 01, 2003
  • HELP-PROMPT:  Type a Number between 0 and 9999999, 0 Decimal Digits
3107 NO SERVICE CATEGORY 31;7 NUMBER

  • INPUT TRANSFORM:  K:+X'=X!(X>999999)!(X<0)!(X?.E1"."1N.N) X
  • LAST EDITED:  APR 01, 2003
  • HELP-PROMPT:  Type a Number between 0 and 999999, 0 Decimal Digits
3108 ADDS 31;8 NUMBER

  • INPUT TRANSFORM:  K:+X'=X!(X>9999999)!(X<0)!(X?.E1"."1N.N) X
  • LAST EDITED:  AUG 18, 2003
  • HELP-PROMPT:  Type a Number between 0 and 9999999, 0 Decimal Digits
3109 MODS 31;9 NUMBER

  • INPUT TRANSFORM:  K:+X'=X!(X>9999999)!(X<0)!(X?.E1"."1N.N) X
  • LAST EDITED:  AUG 18, 2003
  • HELP-PROMPT:  Type a Number between 0 and 9999999, 0 Decimal Digits
3110 DELETES 31;10 NUMBER

  • INPUT TRANSFORM:  K:+X'=X!(X>9999999)!(X<0)!(X?.E1"."1N.N) X
  • LAST EDITED:  AUG 18, 2003
  • HELP-PROMPT:  Type a Number between 0 and 9999999, 0 Decimal Digits
3111 MFI VISITS SKIPPED 31;11 NUMBER

  • INPUT TRANSFORM:  K:+X'=X!(X>999999)!(X<0)!(X?.E1"."1N.N) X
  • LAST EDITED:  NOV 19, 2003
  • HELP-PROMPT:  Type a Number between 0 and 999999, 0 Decimal Digits
4101 PATIENTS EXPORTED 41;0 POINTER Multiple #90213.4101 90213.4101
5101 VISITS WITH ERRORS 51;0 POINTER Multiple #90213.05101 90213.05101

  • LAST EDITED:  APR 01, 2003
6101 PATIENT CENTRIC EXPORTED 61;0 POINTER Multiple #90213.06101 90213.06101
8801 USER 100;1 POINTER TO NEW PERSON FILE (#200) NEW PERSON(#200)

  • LAST EDITED:  JUN 05, 2004
9901 TRAILER REPORT 99;0 WORD-PROCESSING #90213.99
Info |  Desc |  Directly Accessed By Routines |  Accessed By FileMan Db Calls |  Pointer To FileMan Files |  Fields |  All