Entity Definition

Logical Name : TransactionResourceOverride
Physical Name : TR_RS_TRN_OVR

A record of the OperatorID of the supervisor who authorized access to the Transaction based Resource that the Operator of record was denied access to.

Data Definition

Attribute Description Physical Name Domain Data Type Foreign Key Table
TransactionID (FK)(PK) A universally unique identifier (UUID) for the Transaction. This may be assembled from alternate key members. ID_TRN IdentityUUID char(32) Transaction(TR_TRN)
OverrideSequenceNumber (PK) A unique identifier (within the context of the Transaction) for this ResourceOverride. AI_OVRD LineNumber smallint
ResourceID (FK) A unqiue system assigned identifier for the action to which access may be granted to some Operators and Workstations. ID_RS Identity integer Resource(PA_RS)
OperatorID (FK) A unique, automatically assigned number used to identify a workstation OPERATOR. ID_OPR Identity integer Operator(PA_OPR)
ReasonCode (FK) A unique retailer defined reason code for an action that is taken (or not taken) at a Workstation. e.g. Return reason codes - Past Use By Date, Defective Merchandise, etc. POSNoSale reason Codes - Customer Change Query CD_RSN Code varchar(20) Reason(CO_CD_RSN)
Timestamp The date and time that a transaction line item is being overridden. TS_LTM_RTL_TRN_OVR AuditDateTime datetime
EntryMethodCode A code denoting how the overriding OperatorID was entered. e.g. Keyed, Scanned, MCR, SmartCard, etc... LU_MTH_ENR Code2 char(2)
OverrideApprovalCode Approval code entered by the overriding Operator to complete the override authorization. CD_APVL_OVR Code4 char(4)


Parent Entity Verb Phrase Child Entity
Resource access was overridden by TransactionResourceOverride
Reason classifies TransactionResourceOverride
Operator authorizes TransactionResourceOverride
Transaction had access overrides recorded by TransactionResourceOverride

Logical Views containing TransactionResourceOverride

Logical View
Logical 02200 - Transaction Macro View
Logical 06220 - Access Control - Overrides View
Logical 11100 - Worker - Macro View