Guest checkin fact table

bi_factguestcheckin

factguestcheckinwid

Unique identifier for the row in the org. Primary key

BIGINT

yes

bi_factguestcheckin

factguestcheckinid

Unique identifier for the row in the table.

BIGINT

bi_factguestcheckin

accessusagepk

Unique identifier for the row in the table, internal to zenoti

BIGINT

bi_factguestcheckin

userwid

unique identifier for the guest who checked in

BIGINT

Bi_dimuser

userwid

bi_factguestcheckin

centerwid

unique identifier for the center

BIGINT

bi_dimcenter

centerwid

bi_factguestcheckin

lastarrived

time at which guest has checkedin into the center

TIMESTAMP

bi_factguestcheckin

resourcewid

room to which guest checked-in

BIGINT

bi_factguestcheckin

usermembershipwid

membership of user through which guest checked in. In case it is guest pass, it is the user membership to which guest pass is related to

BIGINT

bi_factguestcheckin

membershipuserwid

unique identifier for the guest who purchased membership

BIGINT

bi_factguestcheckin

membershipcenterwid

unique identifier for the center where membership was purchased

BIGINT

bi_factguestcheckin

etlcreateddate

Date and Time on which row is created

TIMESTAMP

bi_factguestcheckin

etlcreatedby

System user which created the row. Internal to Zenoti

BIGINT

bi_factguestcheckin

void

Indicates if row is void or not. 0-active, 1- void

BOOLEAN

bi_factguestcheckin

etllastupdatedon

Date and Time on which row is updated

TIMESTAMP

bi_factguestcheckin

etllastupdatedby

System user which updated the row. Internal to Zenoti

VARCHAR(50)

bi_factguestcheckin

organizationid

Unique identifier for the organization

VARCHAR(36)

bi_dimcenter

organizationid

bi_factguestcheckin

podname

Identifer for the region customer belongs to. Internal to Zenoti

VARCHAR(200)

bi_factguestcheckiin

groupid

Internal to Zenoti. Used for data processing.

BIGINT