Skip to main content

Record type dimension table

bi_dimrecordtype

Field

Description

Field Type

Primary Key

dimrecordtypewid

bigint

etllastupdatedby

ETL system admin user who inserted or updated the corresponding record in this table.

varchar ( 50 )

etllastupdatedon

Latest timestamp at which the corresponding record was either inserted or updated in this table.

timestamp without time zone

recordtypeid

integer

recordtypename

This field indicates whether the transaction was a sale, refund, or redemption.

varchar ( 100 )

void

boolean