Session

Entity Definition

Logical Name : Session
Physical Name : CO_SSN

A transient association between an OPERATOR, and a WORKSTATION, that must exist to enable the creation of a RETAIL TRANSACTION or FINANCIAL TRANSACTION that involves the receipt, disbursement, pick up or loan of tender. A SESSION is created when an OPERATOR signs on to a WORKSTATION and is terminated when an OPERATOR signs off of a WORKSTATION. This entity exists to support tender reconciliation and accountability at an OPERATOR level.

Data Definition

Attribute Description Physical Name Domain Data Type Foreign Key Table
SessionID (PK) A unique token ID for a Session instance. ID_SSN Identity integer
WorkstationID (FK) The unique identifier for the WORKSTATION, typically the serial number. ID_WS Identity integer Workstation(AS_WS)
OperatorID (FK) A unique, automatically assigned number used to identify a workstation OPERATOR. ID_OPR Identity integer Operator(PA_OPR)
SessionStartTransactionID (FK) A universally unique identifier (UUID) for the Transaction. This may be assembled from alternate key members. ID_TRN_SSN_SRT IdentityUUID char(32) SignOnTransaction(TR_SGN_ON)
SessionEndTransactionID (FK) A universally unique identifier (UUID) for the Transaction. This may be assembled from alternate key members. ID_TRN_SSN_END IdentityUUID char(32) SignOffTransaction(TR_SGN_OFF)
SessionStartDateTimestamp The time and date at the start of the SESSION. TS_SRT EffectiveDateTime datetime
SessionEndDateTimestamp The time and date recorded at the end of the SESSION. TS_END ExpirationDateTime datetime
GrossPositiveTotalAmount The total monetary positive gross sales amount recorded by SESSION. CP_SLS_GS_PSTV_TOT Money decimal(16,5)
GrossNegativeTotalAmount The total monetary gross negative sales amount recorded by SESSION. CP_SLS_GS_NG_TOT Money decimal(16,5)
TotalTransactionCount The total number of transactions recorded by SESSION. QU_TRN_TOT QuantityTransactionCount decimal(7,0)
LineItemVoidTotalAmount The total monetary amount of line item voids made by SESSION. CP_VD_LN_ITM_TOT Money decimal(16,5)
TotalLineItemVoidCount The total number of line item voids recorded by SESSION. QU_VD_LN_ITM_TOT QuantityTransactionCount decimal(7,0)
PostTransactionVoidTotalAmount The total monetary amount of post transactions actioned by SESSION. CP_VD_PST_TRN_TOT Money decimal(16,5)
TotalPostTransactionVoidCount The total number of post transaction voids recorded by SESSION. QU_VD_PST_TRN_TOT QuantityTransactionCount decimal(7,0)
TransactionVoidTotalAmount The total monetary amount of transaction voids by SESSION. CP_VD_TRN_TOT Money decimal(16,5)
TotalTransactionVoidCount The total number of transaction voids by SESSION. QU_VD_TRN_TOT QuantityTransactionCount decimal(7,0)
TenderLoanTotalAmount The total monetary amount of tender loans by SESSION. CP_LON_TND_TOT Money decimal(16,5)
TotalTenderLoanCount The total number of tender loans by SESSION. QU_LON_TND_TOT QuantityTransactionCount decimal(7,0)
TenderPickupTotalAmount The total monetary amount of tender pickups by SESSION. CP_PKP_TND_TOT Money decimal(16,5)
TotalTenderPickupCount The total number of tender pickups by SESSION. QU_PKP_TND_TOT QuantityTransactionCount decimal(7,0)
ReturnTotalAmount The total monetary amount of returns recorded by SESSION. CP_RTN_TOT Money decimal(16,5)
TotalReturnCount The total number of returns recorded by SESSION. QU_RTN_TOT QuantityTransactionCount decimal(7,0)
RefundTotalAmount The total monetary amount of refunds recorded by SESSION. CP_RFD_TOT Money decimal(16,5)
TotalRefundCount The total number of refunds recorded by SESSION. QU_RFD_TOT QuantityTransactionCount decimal(7,0)
EmployeeDiscountTotalAmount The total monetary amount of employee discounts recorded by SESSION. CP_DS_EM_TOT Money decimal(16,5)
TotalEmployeeDiscountCount The total number of employee line item discounts recorded by SESSION. QU_DSC_EM_TOT QuantityTransactionCount decimal(7,0)
MiscellaneousDiscountTotalAmount The total monetary amount of miscellaneous discounts recorded by SESSION. CP_DS_MSC_TOT Money decimal(16,5)
TotalMiscellaneousDiscountCount The total number of line item miscellaneous discounts recorded by SESSION. QU_DSC_MSC_TOT QuantityTransactionCount decimal(7,0)
StoreCouponTotalAmount The total monetary amount of store coupons recorded by SESSION. CP_CPN_STR_TOT Money decimal(16,5)
TotalStoreCouponCount The total number of store coupons recorded by SESSION. QU_CPN_STR_TOT QuantityTransactionCount decimal(7,0)
RedeemedContainerDepositTotalAmount The total monetary amount of container deposits redeemed by SESSION. CP_DS_RDM_CNR Money decimal(16,5)
TotalRedeemedContainerDepositCount The total number of container deposits redeemed by SESSION. QU_DS_RDM_CNR QuantityTransactionCount decimal(7,0)
MarkdownTotalAmount The total monetary amount of price markdowns made by SESSION. CP_MKD_TOT Money decimal(16,5)
TotalMarkdownCount The total number of price markdowns made by SESSION. QU_MKD_TOT QuantityTransactionCount decimal(7,0)
NetSalesTotalAmount The total monetary amount of net sales recorded by SESSION. CP_SLS_NT_TOT Money decimal(16,5)
MiscellaneousFeeTotalAmount The total monetary amount of miscellaneous fees recorded by SESSION. CP_FE_MSC_TOT Money decimal(16,5)
TotalMiscellaneousFeeCount The total number of miscellaneous fees recorded by SESSION. QU_FE_MSC_TOT QuantityTransactionCount decimal(7,0)
ContainerDepositTotalAmount The total monetary amount of container deposits collected by SESSION. CP_DS_CNR_TOT Money decimal(16,5)
TotalContainerDepositCount The total number of container deposits collected by SESSION. QU_DS_CNR_TOT QuantityTransactionCount decimal(7,0)
PaymentsCollectedTotalAmount The total monetary amount of payments on account collected by SESSION. CP_PYM_CLT_TOT Money decimal(16,5)
TotalPaymentsCollectedCount The number of payments on account collected by SESSION. QU_PYM_CLT_TOT QuantityTransactionCount decimal(7,0)
LayawayPaymentsCollectedTotalAmount The total monetary amount of layaway payments collected by SESSION. CP_PYM_LY_CLT_TOT Money decimal(16,5)
TotalLayawayPaymentsCollectedCount The total number of layaway payments collected by SESSION. QU_PYM_LY_CLT_TOT QuantityTransactionCount decimal(7,0)
PettyCashDisbursementTotalAmount The total monetary amount of petty cash payments disbursed by SESSION. CP_DSB_PTY_CSH_TOT Money decimal(16,5)
TotalPettyCashDisbursementLineItemCount The total number of petty cash line item payments disbursed by SESSION. QU_DSB_PTY_CSH_ITM QuantityTransactionCount decimal(7,0)
GrossSalesExTaxTotalAmount The total monetary amount of gross sales excluding tax recorded by SESSION. CP_SLS_EX_TX_GS Money decimal(16,5)
TaxTotalAmount The total tax amount recorded by SESSION. CP_TX_TOT Money decimal(16,5)
TaxExemptTotalAmount The total tax exempt amount recorded by SESSION. CP_TX_EXM_TOT Money decimal(16,5)
TotalTaxExemptTransactionCount The total number of tax exempt transactions recorded by SESSION. QU_TRN_TX_EXM_TOT QuantityTransactionCount decimal(7,0)
TotalLineItemOverrideCount The total number of line item overrides made by SESSION. QU_OVRD_LN_ITM_TOT QuantityTransactionCount decimal(7,0)
TotalWeighedLineItemCount The total number of weighed line items by SESSION. QU_LN_ITM_WT_TOT QuantityTransactionCount decimal(7,0)
TotalLineItemKeyedCount The total number of ITEMs keyed at the point of sale by SESSION. QU_ITM_LN_KY_TOT QuantityTransactionCount decimal(7,0)
TotalLineItemScannedCount The total number of ITEMs scanned by SESSION. QU_LN_ITM_SC_TOT QuantityTransactionCount decimal(7,0)
TotalLineItemKeyedPercentage The percentage of ITEMs keyed compared to the total sold ITEMs by SESSION. PE_ITM_LN_KY_TOT Percent decimal(7,4)
TotalLineItemScannedPercentage The percentage of ITEMs scanned compared to the total sold ITEMs by SESSION. PE_LN_ITM_SC_TOT Percent decimal(7,4)
TotalLineItemOpenDepartmentCount The number of ITEMs recorded through an open department by SESSION. QU_DPT_OPN_LN_ITM QuantityTransactionCount decimal(7,0)
TotalLineItemOpenDepartmentPercentage The percentage of ITEMs sold through an open department compared to the total sold ITEMs by SESSION. PE_DPT_OPN_LN_ITM Percent decimal(7,4)
TotalNoSaleTransactionCount The total number of no sale transactions recorded by SESSION. QU_TRN_NO_SLS_TOT QuantityTransactionCount decimal(7,0)
TotalRingTime the total time expressed in minutes spent either scanning or keying ITEMs into the WORKSTATION by SESSION. IN_RNG_TOT QuantityShortCountSeconds decimal(5,0)
TotalIdleTime The total time expressed in minutes by SESSION where no sales are being recorded at the WORKSTATION. IN_IDL_TOT QuantityShortCountSeconds decimal(5,0)
TotalLockTime The total time expressed in minutes when the WORKSTATION is locked but the OPERATOR is logged on the WORKSTATION by SESSION. IN_LCK_TOT QuantityShortCountSeconds decimal(5,0)
TotalSaleLineItemCount The total number of sale line items by SESSION. QU_ITM_LN_SLS_TOT QuantityTransactionCount decimal(7,0)

Relationships

Parent Entity Verb Phrase Child Entity
SignOffTransaction ends Session
Workstation captures Session
Operator participates in Session
SignOnTransaction starts Session
Session contains Transaction
Session may include SessionTender
Session may include SessionTax

Logical Views containing Session

Logical View
Logical 02200 - Transaction Macro View
Logical 02300 - Retail Transaction - Macro View
Logical 02305 - Retail Transaction - Header View
Logical 02400 - Control Transaction Macro View
Logical 02410 - Control Transaction - Sign On Off View
Logical 02430 - Control Transaction - Period Open Close View
Logical 02440 - Control Transaction - Voids View
Logical 02450 - Control Transaction - Drawer Limit
Logical 02500 - Tender Control Transaction - Macro View
Logical 02510 - Tender Control Transaction - Movement View
Logical 02520 - Tender Control Transaction - Settlement View
Logical 03100 - Reporting - Store Operations - Macro View
Logical 03130 - Reporting - Store Operations - Session View
Logical 03140 - Reporting - Store Operations - Workstation View
Logical 03150 - Reporting - Store Operations - Operator View
Logical 03160 - Reporting - Store Operations - Till View
Logical 05400 - Taxation - Reporting View - Tax Rule Reference
Logical 06400 - Store Equipment View
Logical 11140 - Worker - Retail Transaction View
Logical 11160 - Worker - Reporting View