## Entity DefinitionLogical Name : OperatorHistory |
---|

Attribute | Description | Physical Name | Domain | Data Type | Foreign Key Table |
---|---|---|---|---|---|

OperatorID (FK)(PK) | A unique, automatically assigned number used to identify a workstation OPERATOR. | ID_OPR | Identity | integer | Operator(PA_OPR) |

ReportingPeriodID (FK)(PK) | The unique system assigned identifier for a particular ReportingPeriod. | ID_PRD_RP | Identity | integer | ReportingPeriod(CA_PRD_RP) |

TotalTenderLoanCount | The total number of tender loans recorded against the workstation OPERATOR for each REPORTING PERIOD. | QU_LON_TND_TOT | QuantityTransactionCount | decimal(7,0) | |

GrossPositiveTotalAmount | The total monetary amount of positive gross sales recorded by OPERATOR for each REPORTING PERIOD. Positive gross sales exclude returns. | CP_SLS_GS_PSTV_TOT | Money | decimal(16,5) | |

GrossNegativeTotalAmount | The total monetary amount of negative gross sales recorded by OPERATOR for each REPORTING PERIOD. This total only includes returns made to the RETAIL STORE. | CP_SLS_GS_NG_TOT | Money | decimal(16,5) | |

TotalTransactionCount | The total number of transactions recorded by OPERATOR for each REPORTING PERIOD. | QU_TRN_TOT | QuantityTransactionCount | decimal(7,0) | |

LineItemVoidTotalAmount | The total monetary amount of line item voids made by OPERATOR for each REPORTING PERIOD. | CP_VD_LN_ITM_TOT | Money | decimal(16,5) | |

TotalLineItemVoidCount | The total number of line item voids made by OPERATOR for each REPORTING PERIOD. | QU_LTM_VD_TOT | QuantityTransactionCount | decimal(7,0) | |

PostTransactionVoidTotalAmount | The total monetary amount of post transaction voids by OPERATOR for each REPORTING PERIOD. | CP_VD_PST_TRN_TOT | Money | decimal(16,5) | |

TotalPostTransactionVoidCount | The total number of disbursement line items made by OPERATOR for each REPORTING PERIOD. | QU_VD_PST_TRN_TOT | QuantityTransactionCount | decimal(7,0) | |

TransactionVoidTotalAmount | The total number of transaction voids recorded by OPERATOR for each REPORTING PERIOD. | MO_VD_TRN_TOT | Money | decimal(16,5) | |

TotalTransactionVoidCount | The total number of transaction voids recorded by OPERATOR for each REPORTING PERIOD. | QU_VD_TRN_TOT | QuantityTransactionCount | decimal(7,0) | |

TotalTenderPickupCount | The total number of tender pickups recorded against the workstation OPERATOR for each REPORTING PERIOD. | QU_PKP_TND_TOT | QuantityTransactionCount | decimal(7,0) | |

TenderPickupTotalAmount | The total monetary amount of tender pickups by OPERATOR for each REPORTING PERIOD. | CP_PKP_TND_TOT | Money | decimal(16,5) | |

TenderLoanTotalAmount | The total monetary amount of tender loans by OPERATOR for each REPORTING PERIOD. | CP_LON_TND_TOT | Money | decimal(16,5) | |

ReturnTotalAmount | The total monetary amount of returns made by OPERATOR for each REPORTING PERIOD. | CP_RTN_TOT | Money | decimal(16,5) | |

TotalReturnCount | The total number of item returns received by OPERATOR for each REPORTING PERIOD. | QU_RTN_TOT | QuantityTransactionCount | decimal(7,0) | |

RefundTotalAmount | The total monetary amount of refunds made by OPERATOR for each REPORTING PERIOD. | CP_RFD_TOT | Money | decimal(16,5) | |

TotalRefundCount | The total number of item refunds actioned by OPERATOR for each REPORTING PERIOD. | QU_RFD_TOT | QuantityTransactionCount | decimal(7,0) | |

EmployeeDiscountTotalAmount | The total monetary amount of employee discounts actioned by OPERATOR for each REPORTING PERIOD. | CP_DS_EM_TOT | Money | decimal(16,5) | |

TotalEmployeeDiscountCount | The total number of line item employee discounts recorded by OPERATOR for each REPORTING PERIOD. | QU_DSC_EM_TOT | QuantityTransactionCount | decimal(7,0) | |

MiscellaneousDiscountTotalAmount | The total monetary amount of miscellaneous discounts recorded by OPERATOR for each REPORTING PERIOD. | CP_DS_MSC_TOT | Money | decimal(16,5) | |

TotalMiscellaneousDiscountCount | The total number of miscellaneous discounts actioned by OPERATOR for each REPORTING PERIOD. | QU_DS_MSC_TOT | QuantityTransactionCount | decimal(7,0) | |

StoreCouponTotalAmount | The total monetary amount of store coupons accepted by OPERATOR for each REPORTING PERIOD. | CP_CPN_STR_TOT | Money | decimal(16,5) | |

TotalStoreCouponCount | The total number of store coupons accepted by OPERATOR for each REPORTING PERIOD. | QU_CPN_STR_TOT | QuantityTransactionCount | decimal(7,0) | |

RedeemedContainerDepositTotalAmount | The total monetary amount of container deposits redeemed by OPERATOR for each REPORTING PERIOD. | CP_DS_RDM_CNR_TOT | Money | decimal(16,5) | |

TotalRedeemedContainerDepositCount | The total number of disbursement line items made by OPERATOR for each REPORTING PERIOD. | QU_DS_RDM_CNR | QuantityTransactionCount | decimal(7,0) | |

MarkdownTotalAmount | The total monetary amount of price markdowns made by OPERATOR for each REPORTING PERIOD. | CP_MRK_TOT | Money | decimal(16,5) | |

TotalMarkdownCount | The total number of item markdowns actioned by OPERATOR for each REPORTING PERIOD. | QU_MKD_TOT | QuantityTransactionCount | decimal(7,0) | |

NetSalesTotalAmount | The total monetary amount of net sales recorded by OPERATOR for each REPORTING PERIOD. | CP_SLS_NT_TOT | Money | decimal(16,5) | |

MiscellaneousFeeTotalAmount | The total monetary amount of miscellaneous fees recorded by OPERATOR for each REPORTING PERIOD. | CP_FE_MSC_TOT | Money | decimal(16,5) | |

TotalMiscellaneousFeeCount | The total number of miscellaneous fee item sales recorded by OPERATOR for each REPORTING PERIOD. | QU_FE_MSC_TOT | QuantityTransactionCount | decimal(7,0) | |

ContainerDepositTotalAmount | The total monetary amount of container discounts collected by OPERATOR for each REPORTING PERIOD. | CP_DS_CNR_TOT | Money | decimal(16,5) | |

TotalContainerDepositCount | The total number of container deposits collected by OPERATOR for each REPORTING PERIOD. | QU_DS_CNR_TOT | QuantityTransactionCount | decimal(7,0) | |

PaymentsCollectedTotalAmount | The total monetary amount of payments collected by OPERATOR for each REPORTING PERIOD. | CP_PYM_CLT_TOT | Money | decimal(16,5) | |

TotalPaymentsCollectedCount | The total number of payments on account received by OPERATOR for each REPORTING PERIOD. | QU_PYM_CLT_TOT | QuantityTransactionCount | decimal(7,0) | |

LayawayPaymentsCollectedTotalAmount | The total monetary amount of layaway payments collected by OPERATOR for each REPORTING PERIOD. | CP_PYM_LY_CLT_TOT | MoneyShortCost | decimal(16,5) | |

TotalLayawayPaymentsCollectedCount | The total number of layaways payments collected by OPERATOR for each REPORTING PERIOD. | QU_PYM_LY_CLT_TOT | QuantityTransactionCount | decimal(7,0) | |

PettyCashDisbursementTotalAmount | The total monetary amount of petty cash disbursements by OPERATOR for each REPORTING PERIOD. | CP_DSB_PTY_CSH_TOT | Money | decimal(16,5) | |

TotalPettyCashDisbursementLineItemCount | The total number of disbursement line items made by OPERATOR for each REPORTING PERIOD. | QU_DSB_PTY_LN_ITM | QuantityTransactionCount | decimal(7,0) | |

GrossSalesExTaxTotalAmount | The total monetary amount of gross sales excluding tax recorded by OPERATOR for each REPORTING PERIOD. | CP_SLS_GS_EX_TX | Money | decimal(16,5) | |

TaxTotalAmount | The total tax amount recorded by OPERATOR for each REPORTING PERIOD. | CP_TX_TOT | Money | decimal(16,5) | |

TaxExemptTotalAmount | The total tax exempt amount recorded by OPERATOR for each REPORTING PERIOD. | CP_TX_EXM_TOT | Money | decimal(16,5) | |

TotalTaxExemptTransactionCount | The total number of tax exempt transactions recorded by OPERATOR for each REPORTING PERIOD. | QU_TRN_TX_EXM_TOT | QuantityTransactionCount | decimal(7,0) | |

TotalLineItemOverrideCount | The total number of line item overrides made by OPERATOR for each REPORTING PERIOD. | QU_LTM_OVRD_TOT | QuantityTransactionCount | decimal(7,0) | |

TotalWeighedLineItemCount | The total number of weighed line items recorded by OPERATOR for each REPORTING PERIOD. | QU_ITM_LN_WT_TOT | QuantityTransactionCount | decimal(7,0) | |

TotalLineItemKeyedCount | The total number of ITEMs keyed at the point of sale by OPERATOR for each REPORTING PERIOD. | QU_LTM_KY_TOT | QuantityTransactionCount | decimal(7,0) | |

TotalLineItemScannedCount | The total number of ITEMs scanned by OPERATOR for each REPORTING PERIOD. | QU_LTM_SC_TOT | QuantityTransactionCount | decimal(7,0) | |

TotalLineItemKeyedPercentage | The percentage of ITEMs keyed at the point of sale compared to the total sold ITEMs by the OPERATOR for each REPORTING PERIOD. | PE_LTM_KY_TOT | Percent | decimal(7,4) | |

TotalLineItemScannedPercentage | The percentage of ITEMs scanned compared to the total sold ITEMs by the OPERATOR for each REPORTING PERIOD. | PE_LTM_SC_TOT | Percent | decimal(7,4) | |

TotalLineItemOpenDepartmentCount | The number of ITEMs recorded through an open department by OPERATOR for each REPORTING PERIOD. | QU_LTM_DPT_TOT | QuantityTransactionCount | decimal(7,0) | |

TotalLineItemOpenDepartmentPercentage | The percentage of ITEMs recorded through an open department compared to the total ITEMs by OPERATOR for each REPORTING PERIOD. | PE_LTM_DPT_TOT | Percent | decimal(7,4) | |

NoSaleTransactionCount | The total number of no sale transactions recorded by OPERATOR for each REPORTING PERIOD. | QU_TRN_NO_SLS | QuantityTransactionCount | decimal(7,0) | |

TotalRingTime | The total time expressed in minutes spent scanning or keying ITEMs by OPERATOR for each REPORTING PERIOD. | IN_RNG_TOT | QuantityShortCountSeconds | decimal(5,0) | |

TotalIdleTime | The total time expressed in minutes by operator where no sales are being recorded for each REPORTING PERIOD. | IN_IDL_TOT | QuantityShortCountSeconds | decimal(5,0) | |

LockTime | The time expressed in minutes when the WORKSTATION is locked even though the OPERATOR has signed on for each REPORTING PERIOD. | IN_LCK_OPR | QuantityShortCountSeconds | decimal(5,0) | |

TotalSaleLineItemCount | The total number of line item sales recorded by OPERATOR for each REPORTING PERIOD. | QU_LTM_SLS_TOT | QuantityTransactionCount | decimal(7,0) | |

TotalSignOnCount | The total number of sign-offs made by OPERATOR for each REPORTING PERIOD. | QU_SGN_ON_TOT | QuantityTransactionCount | decimal(7,0) | |

TotalSignOffCount | The total number of sign-on made by OPERATOR for each REPORTING PERIOD. | QU_SGN_OFF_TOT | QuantityTransactionCount | decimal(7,0) | |

TotalTenderOverAmount | The total monetary amount of tender overages recorded against the workstation OPERATOR for each REPORTING PERIOD. | CP_TND_OVR_TOT | Money | decimal(16,5) | |

TotalTenderUnderAmount | The total monetary amount of tender shortages recorded by OPERATOR for each REPORTING PERIOD. | CP_MD_TND_PKP_TOT | Money | decimal(16,5) | |

IntermediateTenderReconciliationCount | The total number of intermediate tender reconciliations for an OPERATOR for each REPORTING PERIOD. | QU_RCN_INTN_TND | QuantityTransactionCount | decimal(7,0) | |

TotalSendCheckAmount | The total monetary amount of send checks recorded by OPERATOR for each REPORTING PERIOD. | CP_CHK_SND_TOT | Money | decimal(16,5) | |

TotalSendCheckCount | The total number of send checks recorded by OPERATOR for each REPORTING PERIOD. | QU_CHK_SND_TOT | QuantityTransactionCount | decimal(7,0) | |

SuspendedTotalAmount | The total number of TRANSACTIONs suspended by OPERATOR for each REPORTING PERIOD. | CP_SLS_SPN_TOT | Money | decimal(16,5) | |

SuspendedTransactionCount | The total monetary amount of TRANSACTIONs suspended by OPERATOR for each REPORTING PERIOD. | QU_TRN_SPN_TOT | QuantityTransactionCount | decimal(7,0) | |

ResumedTotalAmount | The total monetary amount of TRANSACTIONs resumed by OPERATOR for each REPORTING PERIOD. | CP_SLS_RSM_TOT | Money | decimal(16,5) | |

WorkstationResumedTransactionCount | The total number of resumed transactions recorded by OPERATOR for each REPORTING PERIOD. | QU_SLS_RSM_TRN_TOT | QuantityTransactionCount | decimal(7,0) |

Parent Entity | Verb Phrase | Child Entity |
---|---|---|

Operator | is tracked by | OperatorHistory |

ReportingPeriod | delineates | OperatorHistory |

OperatorHistory | may include | OperatorTenderHistory |

OperatorHistory | may include | OperatorTaxHistory |