Portfolioarrest

view: portfolioarrest {
  sql_table_name: PORTFOLIOARREST ;;

  dimension: accountingusage {
    type: number
    sql: ${TABLE}.ACCOUNTINGUSAGE ;;
  }

  dimension: amortizedamount {
    type: number
    sql: ${TABLE}.AMORTIZEDAMOUNT ;;
  }

  dimension: aum {
    type: number
    sql: ${TABLE}.AUM ;;
  }

  dimension: aumgross {
    type: number
    sql: ${TABLE}.AUMGROSS ;;
  }

  dimension: aumnet {
    type: number
    sql: ${TABLE}.AUMNET ;;
  }

  dimension: aumnetcorr {
    type: number
    sql: ${TABLE}.AUMNETCORR ;;
  }

  dimension: cashavailable {
    type: number
    sql: ${TABLE}.CASHAVAILABLE ;;
  }

  dimension: cashbooked {
    type: number
    sql: ${TABLE}.CASHBOOKED ;;
  }

  dimension: cashlocked {
    type: number
    sql: ${TABLE}.CASHLOCKED ;;
  }

  dimension: cashpending {
    type: number
    sql: ${TABLE}.CASHPENDING ;;
  }

  dimension: cflm {
    type: number
    sql: ${TABLE}.CFLM ;;
  }

  dimension: cflq {
    type: number
    sql: ${TABLE}.CFLQ ;;
  }

  dimension: cfly {
    type: number
    sql: ${TABLE}.CFLY ;;
  }

  dimension: cfsi {
    type: number
    sql: ${TABLE}.CFSI ;;
  }

  dimension: comments {
    sql: ${TABLE}.COMMENTS ;;
  }

  dimension: createdby {
    type: int
    sql: ${TABLE}.CREATEDBY ;;
  }

  dimension: creditd {
    type: number
    sql: ${TABLE}.CREDITD ;;
  }

  dimension: creditm {
    type: number
    sql: ${TABLE}.CREDITM ;;
  }

  dimension: creditq {
    type: number
    sql: ${TABLE}.CREDITQ ;;
  }

  dimension: creditsi {
    type: number
    sql: ${TABLE}.CREDITSI ;;
  }

  dimension: creditsm {
    type: number
    sql: ${TABLE}.CREDITSM ;;
  }

  dimension: creditw {
    type: number
    sql: ${TABLE}.CREDITW ;;
  }

  dimension: credity {
    type: number
    sql: ${TABLE}.CREDITY ;;
  }

  dimension: currency_ {
    sql: ${TABLE}.CURRENCY_ ;;
  }

  dimension: custom1 {
    type: number
    sql: ${TABLE}.CUSTOM1 ;;
  }

  dimension: custom10 {
    type: number
    sql: ${TABLE}.CUSTOM10 ;;
  }

  dimension: custom2 {
    type: number
    sql: ${TABLE}.CUSTOM2 ;;
  }

  dimension: custom3 {
    type: number
    sql: ${TABLE}.CUSTOM3 ;;
  }

  dimension: custom4 {
    type: number
    sql: ${TABLE}.CUSTOM4 ;;
  }

  dimension: custom5 {
    type: number
    sql: ${TABLE}.CUSTOM5 ;;
  }

  dimension: custom6 {
    type: number
    sql: ${TABLE}.CUSTOM6 ;;
  }

  dimension: custom7 {
    type: number
    sql: ${TABLE}.CUSTOM7 ;;
  }

  dimension: custom8 {
    type: number
    sql: ${TABLE}.CUSTOM8 ;;
  }

  dimension: custom9 {
    type: number
    sql: ${TABLE}.CUSTOM9 ;;
  }

  dimension: dtd {
    type: number
    sql: ${TABLE}.DTD ;;
  }

  dimension: dtdgross {
    type: number
    sql: ${TABLE}.DTDGROSS ;;
  }

  dimension: dtdlev {
    type: number
    sql: ${TABLE}.DTDLEV ;;
  }

  dimension: equalizationfactor {
    type: number
    sql: ${TABLE}.EQUALIZATIONFACTOR ;;
  }

  dimension: feespayment {
    type: number
    sql: ${TABLE}.FEESPAYMENT ;;
  }

  dimension: feesprovision {
    type: number
    sql: ${TABLE}.FEESPROVISION ;;
  }

  dimension: hurdle {
    type: number
    sql: ${TABLE}.HURDLE ;;
  }

  dimension: hwm {
    type: number
    sql: ${TABLE}.HWM ;;
  }

  dimension: initismarkup {
    type: number
    sql: ${TABLE}.INITISMARKUP ;;
  }

  dimension: internalcode {
    sql: ${TABLE}.INTERNALCODE ;;
  }

  dimension: investedamount {
    type: number
    sql: ${TABLE}.INVESTEDAMOUNT ;;
  }

  dimension: investeq {
    type: number
    sql: ${TABLE}.INVESTEQ ;;
  }

  dimension: investorsdividend {
    type: number
    sql: ${TABLE}.INVESTORSDIVIDEND ;;
  }

  dimension: isdirty {
    type: number
    sql: ${TABLE}.ISDIRTY ;;
  }

  dimension: isendofperiod {
    type: number
    sql: ${TABLE}.ISENDOFPERIOD ;;
  }

  dimension: leverageamount {
    type: number
    sql: ${TABLE}.LEVERAGEAMOUNT ;;
  }

  dimension: locked {
    type: number
    sql: ${TABLE}.LOCKED ;;
  }

  dimension: lockedby {
    sql: ${TABLE}.LOCKEDBY ;;
  }

  dimension: mtd {
    type: number
    sql: ${TABLE}.MTD ;;
  }

  dimension: mtdgross {
    type: number
    sql: ${TABLE}.MTDGROSS ;;
  }

  dimension: mtdlev {
    type: number
    sql: ${TABLE}.MTDLEV ;;
  }

  dimension: nvac {
    type: number
    sql: ${TABLE}.NVAC ;;
  }

  dimension: orgarrest {
    type: int
    sql: ${TABLE}.ORGARREST ;;
  }

  dimension: overwrited {
    type: number
    sql: ${TABLE}.OVERWRITED ;;
  }

  dimension: overwritedby {
    sql: ${TABLE}.OVERWRITEDBY ;;
  }

  dimension: parentarrest {
    type: int
    sql: ${TABLE}.PARENTARREST ;;
  }

  dimension: paseedid {
    type: int
    sql: ${TABLE}.PASEEDID ;;
  }

  dimension: period {
    sql: ${TABLE}.PERIOD ;;
  }

  dimension: pined {
    type: number
    sql: ${TABLE}.PINED ;;
  }

  dimension: pnlreald {
    type: number
    sql: ${TABLE}.PNLREALD ;;
  }

  dimension: pnlrealm {
    type: number
    sql: ${TABLE}.PNLREALM ;;
  }

  dimension: pnlrealq {
    type: number
    sql: ${TABLE}.PNLREALQ ;;
  }

  dimension: pnlrealsi {
    type: number
    sql: ${TABLE}.PNLREALSI ;;
  }

  dimension: pnlrealsm {
    type: number
    sql: ${TABLE}.PNLREALSM ;;
  }

  dimension: pnlrealw {
    type: number
    sql: ${TABLE}.PNLREALW ;;
  }

  dimension: pnlrealy {
    type: number
    sql: ${TABLE}.PNLREALY ;;
  }

  dimension: portfolio {
    type: int
    sql: ${TABLE}.PORTFOLIO ;;
  }

  dimension: qtd {
    type: number
    sql: ${TABLE}.QTD ;;
  }

  dimension: qtdgross {
    type: number
    sql: ${TABLE}.QTDGROSS ;;
  }

  dimension: qtdlev {
    type: number
    sql: ${TABLE}.QTDLEV ;;
  }

  dimension: quality {
    sql: ${TABLE}.QUALITY ;;
  }

  dimension: reversalamt {
    type: number
    sql: ${TABLE}.REVERSALAMT ;;
  }

  dimension: rflm {
    type: number
    sql: ${TABLE}.RFLM ;;
  }

  dimension: securitypending {
    type: number
    sql: ${TABLE}.SECURITYPENDING ;;
  }

  dimension: serie {
    type: int
    sql: ${TABLE}.SERIE ;;
  }

  dimension: sflm {
    type: number
    sql: ${TABLE}.SFLM ;;
  }

  dimension: sharenumber {
    type: number
    sql: ${TABLE}.SHARENUMBER ;;
  }

  dimension: shareprice {
    type: number
    sql: ${TABLE}.SHAREPRICE ;;
  }

  dimension: shareror {
    type: number
    sql: ${TABLE}.SHAREROR ;;
  }

  dimension: si {
    type: number
    sql: ${TABLE}.SI ;;
  }

  dimension: sigross {
    type: number
    sql: ${TABLE}.SIGROSS ;;
  }

  dimension: silev {
    type: number
    sql: ${TABLE}.SILEV ;;
  }

  dimension: smtd {
    type: number
    sql: ${TABLE}.SMTD ;;
  }

  dimension: smtdgross {
    type: number
    sql: ${TABLE}.SMTDGROSS ;;
  }

  dimension: smtdlev {
    type: number
    sql: ${TABLE}.SMTDLEV ;;
  }

  dimension: source {
    type: int
    sql: ${TABLE}.SOURCE ;;
  }

  dimension: status {
    sql: ${TABLE}.STATUS ;;
  }

  dimension: tools {
    type: int
    sql: ${TABLE}.TOOLS ;;
  }

  dimension: underrormethod {
    sql: ${TABLE}.UNDERRORMETHOD ;;
  }

  dimension: unrealized {
    type: number
    sql: ${TABLE}.UNREALIZED ;;
  }

  dimension: unrealizedforex {
    type: number
    sql: ${TABLE}.UNREALIZEDFOREX ;;
  }

  dimension: wflm {
    type: number
    sql: ${TABLE}.WFLM ;;
  }

  dimension: wflq {
    type: number
    sql: ${TABLE}.WFLQ ;;
  }

  dimension: wfly {
    type: number
    sql: ${TABLE}.WFLY ;;
  }

  dimension: wfsi {
    type: number
    sql: ${TABLE}.WFSI ;;
  }

  dimension: wtd {
    type: number
    sql: ${TABLE}.WTD ;;
  }

  dimension: wtdgross {
    type: number
    sql: ${TABLE}.WTDGROSS ;;
  }

  dimension: wtdlev {
    type: number
    sql: ${TABLE}.WTDLEV ;;
  }

  dimension: yc {
    type: number
    sql: ${TABLE}.YC ;;
  }

  dimension: ycgross {
    type: number
    sql: ${TABLE}.YCGROSS ;;
  }

  dimension: yclev {
    type: number
    sql: ${TABLE}.YCLEV ;;
  }

  dimension: ytd {
    type: number
    sql: ${TABLE}.YTD ;;
  }

  dimension: ytdgross {
    type: number
    sql: ${TABLE}.YTDGROSS ;;
  }

  dimension: ytdlev {
    type: number
    sql: ${TABLE}.YTDLEV ;;
  }

  dimension_group: calculationdate {
    type: time
    timeframes: [time, date, week, month]
    sql: ${TABLE}.CALCULATIONDATE ;;
  }

  dimension_group: dateref {
    type: time
    timeframes: [time, date, week, month]
    sql: ${TABLE}.DATEREF ;;
  }

  dimension_group: daterefdtd {
    type: time
    timeframes: [time, date, week, month]
    sql: ${TABLE}.DATEREFDTD ;;
  }

  dimension_group: daterefmtd {
    type: time
    timeframes: [time, date, week, month]
    sql: ${TABLE}.DATEREFMTD ;;
  }

  dimension_group: daterefqtd {
    type: time
    timeframes: [time, date, week, month]
    sql: ${TABLE}.DATEREFQTD ;;
  }

  dimension_group: daterefsmtd {
    type: time
    timeframes: [time, date, week, month]
    sql: ${TABLE}.DATEREFSMTD ;;
  }

  dimension_group: daterefwtd {
    type: time
    timeframes: [time, date, week, month]
    sql: ${TABLE}.DATEREFWTD ;;
  }

  dimension_group: daterefytd {
    type: time
    timeframes: [time, date, week, month]
    sql: ${TABLE}.DATEREFYTD ;;
  }

  dimension_group: initdate {
    type: time
    timeframes: [time, date, week, month]
    sql: ${TABLE}.INITDATE ;;
  }

  dimension_group: lockedfrom {
    type: time
    timeframes: [time, date, week, month]
    sql: ${TABLE}.LOCKEDFROM ;;
  }

  dimension_group: overwritedwhen {
    type: time
    timeframes: [time, date, week, month]
    sql: ${TABLE}.OVERWRITEDWHEN ;;
  }

  dimension_group: parent_arrest {
    type: time
    timeframes: [time, date, week, month]
    convert_tz: no
    sql: ${TABLE}.PADATE ;;
  }

  measure: aumnet_balance {
    type: sum
    sql: ${aumnet} ;;
  }

  measure: total_mtd {
    type: sum
    sql: ${mtd} ;;
  }

  measure: running_mtd {
    type: running_total
    sql: ${total_mtd} ;;
  }

  measure: cumulative_mtd {
    type: running_total
    sql: ${total_mtd} ;;
  }

  measure: count {
    type: count
  }
}

- view: portfolioarrest
  sql_table_name: PORTFOLIOARREST
  fields:
  - dimension: accountingusage
    type: number
    sql: ${TABLE}.ACCOUNTINGUSAGE
  - dimension: amortizedamount
    type: number
    sql: ${TABLE}.AMORTIZEDAMOUNT
  - dimension: aum
    type: number
    sql: ${TABLE}.AUM
  - dimension: aumgross
    type: number
    sql: ${TABLE}.AUMGROSS
  - dimension: aumnet
    type: number
    sql: ${TABLE}.AUMNET
  - dimension: aumnetcorr
    type: number
    sql: ${TABLE}.AUMNETCORR
  - dimension: cashavailable
    type: number
    sql: ${TABLE}.CASHAVAILABLE
  - dimension: cashbooked
    type: number
    sql: ${TABLE}.CASHBOOKED
  - dimension: cashlocked
    type: number
    sql: ${TABLE}.CASHLOCKED
  - dimension: cashpending
    type: number
    sql: ${TABLE}.CASHPENDING
  - dimension: cflm
    type: number
    sql: ${TABLE}.CFLM
  - dimension: cflq
    type: number
    sql: ${TABLE}.CFLQ
  - dimension: cfly
    type: number
    sql: ${TABLE}.CFLY
  - dimension: cfsi
    type: number
    sql: ${TABLE}.CFSI
  - dimension: comments
    sql: ${TABLE}.COMMENTS
  - dimension: createdby
    type: int
    sql: ${TABLE}.CREATEDBY
  - dimension: creditd
    type: number
    sql: ${TABLE}.CREDITD
  - dimension: creditm
    type: number
    sql: ${TABLE}.CREDITM
  - dimension: creditq
    type: number
    sql: ${TABLE}.CREDITQ
  - dimension: creditsi
    type: number
    sql: ${TABLE}.CREDITSI
  - dimension: creditsm
    type: number
    sql: ${TABLE}.CREDITSM
  - dimension: creditw
    type: number
    sql: ${TABLE}.CREDITW
  - dimension: credity
    type: number
    sql: ${TABLE}.CREDITY
  - dimension: currency_
    sql: ${TABLE}.CURRENCY_
  - dimension: custom1
    type: number
    sql: ${TABLE}.CUSTOM1
  - dimension: custom10
    type: number
    sql: ${TABLE}.CUSTOM10
  - dimension: custom2
    type: number
    sql: ${TABLE}.CUSTOM2
  - dimension: custom3
    type: number
    sql: ${TABLE}.CUSTOM3
  - dimension: custom4
    type: number
    sql: ${TABLE}.CUSTOM4
  - dimension: custom5
    type: number
    sql: ${TABLE}.CUSTOM5
  - dimension: custom6
    type: number
    sql: ${TABLE}.CUSTOM6
  - dimension: custom7
    type: number
    sql: ${TABLE}.CUSTOM7
  - dimension: custom8
    type: number
    sql: ${TABLE}.CUSTOM8
  - dimension: custom9
    type: number
    sql: ${TABLE}.CUSTOM9
  - dimension: dtd
    type: number
    sql: ${TABLE}.DTD
  - dimension: dtdgross
    type: number
    sql: ${TABLE}.DTDGROSS
  - dimension: dtdlev
    type: number
    sql: ${TABLE}.DTDLEV
  - dimension: equalizationfactor
    type: number
    sql: ${TABLE}.EQUALIZATIONFACTOR
  - dimension: feespayment
    type: number
    sql: ${TABLE}.FEESPAYMENT
  - dimension: feesprovision
    type: number
    sql: ${TABLE}.FEESPROVISION
  - dimension: hurdle
    type: number
    sql: ${TABLE}.HURDLE
  - dimension: hwm
    type: number
    sql: ${TABLE}.HWM
  - dimension: initismarkup
    type: number
    sql: ${TABLE}.INITISMARKUP
  - dimension: internalcode
    sql: ${TABLE}.INTERNALCODE
  - dimension: investedamount
    type: number
    sql: ${TABLE}.INVESTEDAMOUNT
  - dimension: investeq
    type: number
    sql: ${TABLE}.INVESTEQ
  - dimension: investorsdividend
    type: number
    sql: ${TABLE}.INVESTORSDIVIDEND
  - dimension: isdirty
    type: number
    sql: ${TABLE}.ISDIRTY
  - dimension: isendofperiod
    type: number
    sql: ${TABLE}.ISENDOFPERIOD
  - dimension: leverageamount
    type: number
    sql: ${TABLE}.LEVERAGEAMOUNT
  - dimension: locked
    type: number
    sql: ${TABLE}.LOCKED
  - dimension: lockedby
    sql: ${TABLE}.LOCKEDBY
  - dimension: mtd
    type: number
    sql: ${TABLE}.MTD
  - dimension: mtdgross
    type: number
    sql: ${TABLE}.MTDGROSS
  - dimension: mtdlev
    type: number
    sql: ${TABLE}.MTDLEV
  - dimension: nvac
    type: number
    sql: ${TABLE}.NVAC
  - dimension: orgarrest
    type: int
    sql: ${TABLE}.ORGARREST
  - dimension: overwrited
    type: number
    sql: ${TABLE}.OVERWRITED
  - dimension: overwritedby
    sql: ${TABLE}.OVERWRITEDBY
  - dimension: parentarrest
    type: int
    sql: ${TABLE}.PARENTARREST
  - dimension: paseedid
    type: int
    sql: ${TABLE}.PASEEDID
  - dimension: period
    sql: ${TABLE}.PERIOD
  - dimension: pined
    type: number
    sql: ${TABLE}.PINED
  - dimension: pnlreald
    type: number
    sql: ${TABLE}.PNLREALD
  - dimension: pnlrealm
    type: number
    sql: ${TABLE}.PNLREALM
  - dimension: pnlrealq
    type: number
    sql: ${TABLE}.PNLREALQ
  - dimension: pnlrealsi
    type: number
    sql: ${TABLE}.PNLREALSI
  - dimension: pnlrealsm
    type: number
    sql: ${TABLE}.PNLREALSM
  - dimension: pnlrealw
    type: number
    sql: ${TABLE}.PNLREALW
  - dimension: pnlrealy
    type: number
    sql: ${TABLE}.PNLREALY
  - dimension: portfolio
    type: int
    sql: ${TABLE}.PORTFOLIO
  - dimension: qtd
    type: number
    sql: ${TABLE}.QTD
  - dimension: qtdgross
    type: number
    sql: ${TABLE}.QTDGROSS
  - dimension: qtdlev
    type: number
    sql: ${TABLE}.QTDLEV
  - dimension: quality
    sql: ${TABLE}.QUALITY
  - dimension: reversalamt
    type: number
    sql: ${TABLE}.REVERSALAMT
  - dimension: rflm
    type: number
    sql: ${TABLE}.RFLM
  - dimension: securitypending
    type: number
    sql: ${TABLE}.SECURITYPENDING
  - dimension: serie
    type: int
    sql: ${TABLE}.SERIE
  - dimension: sflm
    type: number
    sql: ${TABLE}.SFLM
  - dimension: sharenumber
    type: number
    sql: ${TABLE}.SHARENUMBER
  - dimension: shareprice
    type: number
    sql: ${TABLE}.SHAREPRICE
  - dimension: shareror
    type: number
    sql: ${TABLE}.SHAREROR
  - dimension: si
    type: number
    sql: ${TABLE}.SI
  - dimension: sigross
    type: number
    sql: ${TABLE}.SIGROSS
  - dimension: silev
    type: number
    sql: ${TABLE}.SILEV
  - dimension: smtd
    type: number
    sql: ${TABLE}.SMTD
  - dimension: smtdgross
    type: number
    sql: ${TABLE}.SMTDGROSS
  - dimension: smtdlev
    type: number
    sql: ${TABLE}.SMTDLEV
  - dimension: source
    type: int
    sql: ${TABLE}.SOURCE
  - dimension: status
    sql: ${TABLE}.STATUS
  - dimension: tools
    type: int
    sql: ${TABLE}.TOOLS
  - dimension: underrormethod
    sql: ${TABLE}.UNDERRORMETHOD
  - dimension: unrealized
    type: number
    sql: ${TABLE}.UNREALIZED
  - dimension: unrealizedforex
    type: number
    sql: ${TABLE}.UNREALIZEDFOREX
  - dimension: wflm
    type: number
    sql: ${TABLE}.WFLM
  - dimension: wflq
    type: number
    sql: ${TABLE}.WFLQ
  - dimension: wfly
    type: number
    sql: ${TABLE}.WFLY
  - dimension: wfsi
    type: number
    sql: ${TABLE}.WFSI
  - dimension: wtd
    type: number
    sql: ${TABLE}.WTD
  - dimension: wtdgross
    type: number
    sql: ${TABLE}.WTDGROSS
  - dimension: wtdlev
    type: number
    sql: ${TABLE}.WTDLEV
  - dimension: yc
    type: number
    sql: ${TABLE}.YC
  - dimension: ycgross
    type: number
    sql: ${TABLE}.YCGROSS
  - dimension: yclev
    type: number
    sql: ${TABLE}.YCLEV
  - dimension: ytd
    type: number
    sql: ${TABLE}.YTD
  - dimension: ytdgross
    type: number
    sql: ${TABLE}.YTDGROSS
  - dimension: ytdlev
    type: number
    sql: ${TABLE}.YTDLEV
  - dimension_group: calculationdate
    type: time
    timeframes:
    - time
    - date
    - week
    - month
    sql: ${TABLE}.CALCULATIONDATE
  - dimension_group: dateref
    type: time
    timeframes:
    - time
    - date
    - week
    - month
    sql: ${TABLE}.DATEREF
  - dimension_group: daterefdtd
    type: time
    timeframes:
    - time
    - date
    - week
    - month
    sql: ${TABLE}.DATEREFDTD
  - dimension_group: daterefmtd
    type: time
    timeframes:
    - time
    - date
    - week
    - month
    sql: ${TABLE}.DATEREFMTD
  - dimension_group: daterefqtd
    type: time
    timeframes:
    - time
    - date
    - week
    - month
    sql: ${TABLE}.DATEREFQTD
  - dimension_group: daterefsmtd
    type: time
    timeframes:
    - time
    - date
    - week
    - month
    sql: ${TABLE}.DATEREFSMTD
  - dimension_group: daterefwtd
    type: time
    timeframes:
    - time
    - date
    - week
    - month
    sql: ${TABLE}.DATEREFWTD
  - dimension_group: daterefytd
    type: time
    timeframes:
    - time
    - date
    - week
    - month
    sql: ${TABLE}.DATEREFYTD
  - dimension_group: initdate
    type: time
    timeframes:
    - time
    - date
    - week
    - month
    sql: ${TABLE}.INITDATE
  - dimension_group: lockedfrom
    type: time
    timeframes:
    - time
    - date
    - week
    - month
    sql: ${TABLE}.LOCKEDFROM
  - dimension_group: overwritedwhen
    type: time
    timeframes:
    - time
    - date
    - week
    - month
    sql: ${TABLE}.OVERWRITEDWHEN
  - dimension_group: parent_arrest
    type: time
    timeframes:
    - time
    - date
    - week
    - month
    convert_tz: false
    sql: ${TABLE}.PADATE
  - measure: aumnet_balance
    type: sum
    sql: ${aumnet}
  - measure: total_mtd
    type: sum
    sql: ${mtd}
  - measure: running_mtd
    type: running_total
    sql: ${total_mtd}
  - measure: cumulative_mtd
    type: running_total
    sql: ${total_mtd}
  - measure: count
    type: count