Guest User

Untitled

a guest
Feb 20th, 2018
90
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 3.36 KB | None | 0 0
  1. TABLE FILE VIEWPATIENTRECORD
  2. SUM
  3. DRGID NOPRINT
  4. ICD9ID NOPRINT
  5. &DIMTYPEDESC1
  6. &DIMTYPEDESC2
  7. CATEGORYDESCRIPTION NOPRINT
  8. NRBD NOPRINT
  9. NRED NOPRINT
  10. LEVELDESC NOPRINT
  11. BLCASES AS 'Vol&SUPBTAG 1&SUPETAG'
  12. CURRCASES AS 'Vol&SUPBTAG 2&SUPETAG'
  13. COMPUTE VOLVAR/D12=CURRCASES-BLCASES; AS 'Vol Var' NOPRINT
  14. COMPUTE BLNRTOT/D12.2CM =BLNETREV; AS 'NR &SUPBTAG 1 &SUPETAG' &HIDEAGG &HIDENR
  15. COMPUTE CYNRTOT/D12.2CM =CURRNETREV; AS 'NR &SUPBTAG 2 &SUPETAG' &HIDEAGG &HIDENR
  16. COMPUTE NRTOTVAR/D12.2CM=CYNRTOT - BLNRTOT; AS 'NR Var' &HIDEAGG &HIDENR
  17. COMPUTE BLVARTOT/D12.2CM =BLVARCOST; AS 'VC &SUPBTAG 1 &SUPETAG' &HIDEAGG &HIDEVC
  18. COMPUTE CYVARTOT/D12.2CM =CURRVARCOST; AS 'VC &SUPBTAG 2 &SUPETAG' &HIDEAGG &HIDEVC
  19. COMPUTE VARTOTVAR/D12.2CM=CYVARTOT - BLVARTOT; AS 'VC Var' &HIDEAGG &HIDEVC
  20. COMPUTE BLCMTOT/D12.2CM =(BLNETREV) - (BLVARCOST); AS 'CM &SUPBTAG 1 &SUPETAG' &HIDEAGG
  21. COMPUTE CYCMTOT/D12.2CM =(CURRNETREV) - (CURRVARCOST); AS 'CM &SUPBTAG 2 &SUPETAG' &HIDEAGG
  22. COMPUTE CMTOTVAR/D12.2CM=CYCMTOT-BLCMTOT; AS 'CM Var' &HIDEAGG
  23. COMPUTE BLNRPERCASE/D12.2CM =BLNETREV / BLCASES; AS 'NR / Case &SUPBTAG 1 &SUPETAG' &HIDEPC &HIDENR
  24. COMPUTE CYNRPERCASE/D12.2CM =CURRNETREV / CURRCASES; AS 'NR / Case &SUPBTAG 2 &SUPETAG' &HIDEPC &HIDENR
  25. COMPUTE NRPERCASEVAR/D12.2CM=CYNRPERCASE - BLNRPERCASE; AS 'NR Var' &HIDEPC &HIDENR
  26. COMPUTE BLVARPERCASE/D12.2CM =BLVARCOST / BLCASES; AS 'VC / Case &SUPBTAG 1 &SUPETAG' &HIDEPC &HIDEVC
  27. COMPUTE CYVARPERCASE/D12.2CM =CURRVARCOST / CURRCASES; AS 'VC / Case &SUPBTAG 2 &SUPETAG' &HIDEPC &HIDEVC
  28. COMPUTE VARPERCASEVAR/D12.2CM=CYVARPERCASE - BLVARPERCASE; AS 'VC Var' &HIDEPC &HIDEVC
  29. COMPUTE BLCMPERCASE/D12.2CM =(BLNETREV/BLCASES) - (BLVARCOST/BLCASES); AS 'CM / Case &SUPBTAG 1 &SUPETAG' &HIDEPC
  30. COMPUTE CYCMPERCASE/D12.2CM =(CURRNETREV/CURRCASES) - (CURRVARCOST/CURRCASES); AS 'CM / Case &SUPBTAG 2 &SUPETAG' &HIDEPC
  31. COMPUTE CMPERCASEVAR/D12.2CM=CYCMPERCASE-BLCMPERCASE; AS 'CM Var' &HIDEPC
  32. COMPUTE CYTOTALCOSTD/D12.2CM=CURRTOTALCOST / CURRCASES; AS 'Total Cost / Case &SUPBTAG 2 &SUPETAG' NOPRINT
  33. COMPUTE CYNETINCOM/D12.2CM=(CYNRPERCASE) - (CURRTOTALCOST/CURRCASES); AS 'Net Income / Case &SUPBTAG 2 &SUPETAG' NOPRINT
  34. COMPUTE ALOS/D12.2=CURRALOS/CURRCASES; NOPRINT
  35. MVGRAPH AS '' &HIDEGO
  36. HMINREST/D12.2CM NOPRINT
  37. D1 NOPRINT
  38. D2 NOPRINT
  39. D3 NOPRINT
  40. LOCDRILLTYPE NOPRINT
  41. DETAILTYPE NOPRINT
  42. SORTTYPE NOPRINT
  43. SORTCOL NOPRINT
  44. LEVELSORT NOPRINT
  45. HYPERLINK NOPRINT
  46. LDLD NOPRINT
  47. CURRVARCOST NOPRINT
  48. REPORTTYPE NOPRINT
  49. NRTYPE NOPRINT
  50. D4 NOPRINT
  51. D5 NOPRINT
  52. BASEDRGDESC NOPRINT
  53. OUTPATIENTCODING NOPRINT
  54. CPTID NOPRINT
  55. LOCATIONNAME NOPRINT
  56. BY SYSTEMNAME NOPRINT
  57. &LOCVAR
  58. BY &SORTTYPE TOTAL &SORTCOL NOPRINT
  59. BY BLBD NOPRINT
  60. BY BLED NOPRINT
  61. BY CYBD NOPRINT
  62. BY CYED NOPRINT
  63. BY WFFMTA NOPRINT
  64. BY RPDRLEVEL NOPRINT
  65. BY &DIMENSION
  66. BY PATIENTTYPEDESC NOPRINT
  67. &SYSHEADERVARA
  68. &SYSHEADERVARB
  69. &LOCHEADERVARA
  70. &LOCHEADERVARB
  71. &SYSTOTALVAR
  72. &LOCTOTALVAR
  73. WHERE ( SYSTEMNAME EQ '&SYSTEMNAME' );
  74. WHERE ( LOCATIONNAME EQ '&LOCATIONNAME' );
  75. WHERE ( DISCHARGEDATE GE BLBD AND DISCHARGEDATE LE BLED OR DISCHARGEDATE GE CYBD AND DISCHARGEDATE LE CYED );
  76. WHERE ( PATIENTTYPEDESC EQ '&PATIENTTYPE' );
  77. WHERE ( CATEGORYDESCRIPTION EQ '&CATEGORYDESCRIPTION' );
  78. WHERE ( BASEDRGDESC EQ '&BASEDRGDESC' );
  79. WHERE ( DRGID EQ '&DRGID' );
  80. WHERE ( ICD9ID EQ '&ICD9ID' );
  81. WHERE ( CPTID EQ '&CPTID' );
Add Comment
Please, Sign In to add comment