Agent dimension table
Bi_DimAgent
Field | Description | Field Type | Primary Key |
|---|---|---|---|
accrueloyaltypointsonpayment | smallint | ||
address1 | varchar ( 512 ) | ||
address2 | varchar ( 512 ) | ||
agentid | unique identifier for agent | varchar ( 36 ) | |
agentwid | unique identifier for agent. Primary key | bigint | |
city | varchar ( 256 ) | ||
collectadditionaldata | smallint | ||
commissionfactor | double precision | ||
considerinfinancials | smallint | ||
considerinroyalty | smallint | ||
createdby | varchar ( 36 ) | ||
createdon | timestamp without time zone | ||
varchar ( 512 ) | |||
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 | |
name | varchar ( 800 ) | ||
organizationid | unique identifer for the organization | varchar ( 36 ) | |
phone | varchar ( 128 ) | ||
podname | varchar ( 20 ) | ||
showinpos | smallint | ||
stateother | varchar ( 256 ) | ||
void | indicates if the agent is void or not | smallint | |
zipcode | varchar ( 64 ) | ||
groupid | Internal to Zenoti. Used for data processing. | BIGINT |