## Entity DefinitionLogical Name : Session |
---|

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) |

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 |