Training class dimension table
bi_dimtrainingclass
Field | Description | Field Type | Primary Key |
|---|---|---|---|
businessunitdescription | varchar ( 65535 ) | ||
businessunitid | varchar ( 36 ) | ||
businessunitname | varchar ( 800 ) | ||
catalognew | integer | ||
catalogrecommended | integer | ||
categorycode | varchar ( 128 ) | ||
categoryid | varchar ( 36 ) | ||
categoryname | varchar ( 1024 ) | ||
classcatalogprice | varchar ( 128 ) | ||
classdesc | varchar ( 4096 ) | ||
classdisplayname | varchar ( 512 ) | ||
classid | varchar ( 36 ) | ||
classinternalcost | numeric | ||
classlength | integer | ||
classname | varchar ( 1024 ) | ||
classtype | integer | ||
classwid | bigint | ||
code | varchar ( 128 ) | ||
comissioneligible | boolean | ||
commissionfactor | double precision | ||
commissiontype | integer | ||
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 | |
flatcommissionvalue | double precision | ||
organizationid | varchar ( 36 ) | ||
parentcategorycode | varchar ( 128 ) | ||
parentcategoryid | varchar ( 36 ) | ||
parentcategoryname | varchar ( 1024 ) | ||
podname | varchar ( 20 ) | ||
recoverytime | integer | ||
registrationnotes | varchar ( 65535 ) | ||
showincatalog | integer | ||
showprice | boolean | ||
tags | varchar ( 65535 ) | ||
void | boolean | ||
groupid | Internal to Zenoti. Used for data processing. | BIGINT |