Entity Inventory Account Dimension

DescriptionAn account that tracks the use and replenishment of items in the course of performing the activities of the organization.

Attributes
Account CdAccount Cd
Account Code DescrAccount Code Descr
Account Code SkAccount Code Sk
Account DescrAccount Descr
Accounting Scenario CdAccounting Scenario Cd
Accounting Scenario Code DescrAccounting Scenario Code Descr
Accounting Scenario Code SkAccounting Scenario Code Sk
Account NmAccount Nm
Account NumAccount Num
Account Status DtAccount Status Dt
Account Status Reason CdAccount Status Reason Cd
Account Status Reason Code DescrAccount Status Reason Code Descr
Account Status Reason Code SkAccount Status Reason Code Sk
Account Status Type CdAccount Status Type Cd
Account Status Type Code DescrAccount Status Type Code Descr
Account Status Type Code SkAccount Status Type Code Sk
Account Type CdAccount Type Cd
Account Type Code DescrAccount Type Code Descr
Account Type Code SkAccount Type Code Sk
AWM Load Info SkAWM Load Info Sk
Balance AmtBalance Amt
Base Amount Unit Of Measure CdBase Amount Unit Of Measure Cd
Base Amount Unit Of Measure Code DescrBase Amount Unit Of Measure Code Descr
Base Amount Unit Of Measure Code SkBase Amount Unit Of Measure Code Sk
Closing DtClosing Dt
Consignment Item IndConsignment Item Ind
Currency CdCurrency Cd
Currency Code DescrCurrency Code Descr
Currency Code SkCurrency Code Sk
Current IndCurrent Ind
Debit Credit CdDebit Credit Cd
Debit Credit Code DescrDebit Credit Code Descr
Debit Credit Code SkDebit Credit Code Sk
Device IdentifierDevice Identifier
Domestic ManufacturerDomestic Manufacturer
Domestic ManufacturingDomestic Manufacturing
DWM Load Info SkDWM Load Info Sk
Effective From DtEffective From Dt
Effective To DtEffective To Dt
Expiration DtExpiration Dt
Inventory Account BkInventory Account Bk
Inventory Account DkInventory Account Dk
Inventory Account SkInventory Account Sk
Inventory Control NumInventory Control Num
Item Importance CdItem Importance Cd
Item Importance Code DescrItem Importance Code Descr
Item Importance Code SkItem Importance Code Sk
Item SizeItem Size
Lot NumberLot Number
Manufacture DtManufacture Dt
Measurement Period Type CdMeasurement Period Type Cd
Measurement Period Type Code DescrMeasurement Period Type Code Descr
Measurement Period Type Code SkMeasurement Period Type Code Sk
Opening DtOpening Dt
Period Balance Type CdPeriod Balance Type Cd
Period Balance Type Code DescrPeriod Balance Type Code Descr
Period Balance Type Code SkPeriod Balance Type Code Sk
Point Balance Type CdPoint Balance Type Cd
Point Balance Type Code DescrPoint Balance Type Code Descr
Point Balance Type Code SkPoint Balance Type Code Sk
Received DtReceived Dt
Serial NumberSerial Number
Source CdSource Cd
Source Code DescrSource Code Descr
Source Code SkSource Code Sk
Tenant SkTenant Sk
Type CdType Cd
Type Code DescrType Code Descr
Type Code SkType Code Sk
Unit Cost AmtUnit Cost Amt
Valid From TsValid From Ts
Valid To TsValid To Ts

Primary Key
Inventory Account Dimension PKInventory Account Dimension PK

Dependencies
 
 

Reverse Dependencies
 

Attribute Details

 Account Cd
DescriptionIndicates the specific type of the account being tracked.
Data TypeStandards - Data Domains.ddm/Data Domains/Tenant Common Code [VARCHAR(80)]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Account Code Descr
DescriptionIndicates the specific type of the account being tracked.
Data TypeStandards - Data Domains.ddm/Data Domains/Description [VARCHAR(250)]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Account Code Sk
DescriptionIndicates the specific type of the account being tracked.
Data TypeStandards - Data Domains.ddm/Data Domains/Surrogate Key [INTEGER]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Account Descr
DescriptionA free form textual description of what is represented by the account.
Data TypeStandards - Data Domains.ddm/Data Domains/Description [VARCHAR(250)]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Accounting Scenario Cd
DescriptionIndicates the nature of the value represented by the account balance.

For example:
Actual
Budget
Estimated
Forecast
Data TypeStandards - Data Domains.ddm/Data Domains/Tenant Common Code [VARCHAR(80)]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Accounting Scenario Code Descr
DescriptionIndicates the nature of the value represented by the account balance.

For example:
Actual
Budget
Estimated
Forecast
Data TypeStandards - Data Domains.ddm/Data Domains/Description [VARCHAR(250)]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Accounting Scenario Code Sk
DescriptionIndicates the nature of the value represented by the account balance.

For example:
Actual
Budget
Estimated
Forecast
Data TypeStandards - Data Domains.ddm/Data Domains/Surrogate Key [INTEGER]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Account Nm
DescriptionA word or phrase used to identify (but not uniquely) the account.
Data TypeStandards - Data Domains.ddm/Data Domains/Name Medium [VARCHAR(80)]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Account Num
DescriptionAccount Num is an identifier used by the healthcare organization to identify an individual account.
Data TypeStandards - Data Domains.ddm/Data Domains/Alphanumeric [VARCHAR(80)]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Account Status Dt
DescriptionThe effective date for the account status.

For example:
Account is pending with effect from 01/05/2013
Data TypeStandards - Data Domains.ddm/Data Domains/Date [DATE]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Account Status Reason Cd
DescriptionIndicates why the account status was changed to its current state.
Data TypeStandards - Data Domains.ddm/Data Domains/Tenant Common Code [VARCHAR(80)]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Account Status Reason Code Descr
DescriptionIndicates why the account status was changed to its current state.
Data TypeStandards - Data Domains.ddm/Data Domains/Description [VARCHAR(250)]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Account Status Reason Code Sk
DescriptionIndicates why the account status was changed to its current state.
Data TypeStandards - Data Domains.ddm/Data Domains/Surrogate Key [INTEGER]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Account Status Type Cd
DescriptionIndicates the life cycle state the account is currently in.

For example:
Submitted For Approval
Pending Open
Open
Pending Closed
Closed
Pending Deletion
Data TypeStandards - Data Domains.ddm/Data Domains/Tenant Common Code [VARCHAR(80)]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Account Status Type Code Descr
DescriptionIndicates the life cycle state the account is currently in.

For example:
Submitted For Approval
Pending Open
Open
Pending Closed
Closed
Pending Deletion
Data TypeStandards - Data Domains.ddm/Data Domains/Description [VARCHAR(250)]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Account Status Type Code Sk
DescriptionIndicates the life cycle state the account is currently in.

For example:
Submitted For Approval
Pending Open
Open
Pending Closed
Closed
Pending Deletion
Data TypeStandards - Data Domains.ddm/Data Domains/Surrogate Key [INTEGER]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Account Type Cd
DescriptionIndicates the major classification or grouping to which an account naturally belongs.

For example:
Expense
Revenue
Asset
Statistical
Data TypeStandards - Data Domains.ddm/Data Domains/Tenant Common Code [VARCHAR(80)]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Account Type Code Descr
DescriptionIndicates the major classification or grouping to which an account naturally belongs.

For example:
Expense
Revenue
Asset
Statistical
Data TypeStandards - Data Domains.ddm/Data Domains/Description [VARCHAR(250)]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Account Type Code Sk
DescriptionIndicates the major classification or grouping to which an account naturally belongs.

For example:
Expense
Revenue
Asset
Statistical
Data TypeStandards - Data Domains.ddm/Data Domains/Surrogate Key [INTEGER]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 AWM Load Info Sk
DescriptionThe surrogate key of the load information entry describing the details regarding the loading of the row in the atomic data warehouse.
Data TypeStandards - Data Domains.ddm/Data Domains/Surrogate Key Large [LONG]
Is Part Of PrimaryKeyfalse
Is Requiredtrue
Is Derivedfalse
Is Surrogate Keyfalse



 Balance Amt
DescriptionThe current value or amount of the account. Can be derived from all the amounts posted in account entries for the account.
Data TypeStandards - Data Domains.ddm/Data Domains/Currency Amount [DECIMAL(14,2)]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Base Amount Unit Of Measure Cd
DescriptionIndicates the unit of measure for a non-monetary account
Data TypeStandards - Data Domains.ddm/Data Domains/Tenant Common Code [VARCHAR(80)]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Base Amount Unit Of Measure Code Descr
DescriptionIndicates the unit of measure for a non-monetary account
Data TypeStandards - Data Domains.ddm/Data Domains/Description [VARCHAR(250)]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Base Amount Unit Of Measure Code Sk
DescriptionIndicates the unit of measure for a non-monetary account
Data TypeStandards - Data Domains.ddm/Data Domains/Surrogate Key [INTEGER]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Closing Dt
DescriptionThe date upon which the account status is changed to closed.
Data TypeStandards - Data Domains.ddm/Data Domains/Date [DATE]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Consignment Item Ind
DescriptionIndicates whether or not the inventory supply item is purchased on consignment. If the item is purchased on consignment, the healthcare organization does not pay for the inventory supply item until it is used.
Data TypeStandards - Data Domains.ddm/Data Domains/Boolean Indicator [INTEGER]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Currency Cd
DescriptionThe currency used as the basis for all monetary amounts.
Data TypeStandards - Data Domains.ddm/Data Domains/Tenant Common Code [VARCHAR(80)]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Currency Code Descr
DescriptionThe currency used as the basis for all monetary amounts.
Data TypeStandards - Data Domains.ddm/Data Domains/Description [VARCHAR(250)]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Currency Code Sk
DescriptionThe currency used as the basis for all monetary amounts.
Data TypeStandards - Data Domains.ddm/Data Domains/Surrogate Key [INTEGER]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Current Ind
DescriptionSet to 'Y' if this is the most recent row of a group having the same Surrogate Key.
Data TypeStandards - Data Domains.ddm/Data Domains/Boolean Indicator [INTEGER]
Is Part Of PrimaryKeyfalse
Is Requiredtrue
Is Derivedfalse
Is Surrogate Keyfalse



 Debit Credit Cd
DescriptionIndicates whether an account or an entry is a debit or a credit.
Data TypeStandards - Data Domains.ddm/Data Domains/Tenant Common Code [VARCHAR(80)]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Debit Credit Code Descr
DescriptionIndicates whether an account or an entry is a debit or a credit.
Data TypeStandards - Data Domains.ddm/Data Domains/Description [VARCHAR(250)]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Debit Credit Code Sk
DescriptionIndicates whether an account or an entry is a debit or a credit.
Data TypeStandards - Data Domains.ddm/Data Domains/Surrogate Key [INTEGER]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Device Identifier
DescriptionA fixed portion of a UDI that identifies the specific version or model of a device and the labeler of that device. Part of UDI, Unique Device Identifier.
Data TypeStandards - Data Domains.ddm/Data Domains/Alphanumeric [VARCHAR(80)]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Domestic Manufacturer
DescriptionIndicates whether the inventory item manufacturer is headquartered in the country of the modeled organization.
Data TypeStandards - Data Domains.ddm/Data Domains/Boolean Indicator [INTEGER]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Domestic Manufacturing
DescriptionIndicates whether the inventory item was created in the country of the modeled organization.
Data TypeStandards - Data Domains.ddm/Data Domains/Boolean Indicator [INTEGER]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 DWM Load Info Sk
DescriptionThe surrogate key of the load information entry describing the details regarding the loading of the row.
Data TypeStandards - Data Domains.ddm/Data Domains/Surrogate Key Large [LONG]
Is Part Of PrimaryKeyfalse
Is Requiredtrue
Is Derivedfalse
Is Surrogate Keyfalse



 Effective From Dt
DescriptionEstablishes a period where a set of attributes are true according to the business.
Data TypeStandards - Data Domains.ddm/Data Domains/Date [DATE]
Is Part Of PrimaryKeyfalse
Is Requiredtrue
Is Derivedfalse
Is Surrogate Keyfalse



 Effective To Dt
DescriptionEnds a period of effectivity.
Data TypeStandards - Data Domains.ddm/Data Domains/Date [DATE]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Expiration Dt
DescriptionThe expiration date of the item in the inventory.
Data TypeStandards - Data Domains.ddm/Data Domains/Date Time [TIMESTAMP]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Inventory Account Bk
DescriptionConcatenated values of a set of business attributes that uniquely identify the row.
Data TypeStandards - Data Domains.ddm/Data Domains/Business Key [VARCHAR(255)]
Is Part Of PrimaryKeyfalse
Is Requiredtrue
Is Derivedfalse
Is Surrogate Keyfalse



 Inventory Account Dk
DescriptionA numeric surrogate key used to uniquely identify entities in the dimensional model.
Data TypeStandards - Data Domains.ddm/Data Domains/Surrogate Key Large [LONG]
Is Part Of PrimaryKeytrue
Is Requiredtrue
Is Derivedfalse
Is Surrogate Keytrue



 Inventory Account Sk
DescriptionA numeric surrogate key used to uniquely identify entities in the atomic model.
Data TypeStandards - Data Domains.ddm/Data Domains/Surrogate Key Large [LONG]
Is Part Of PrimaryKeyfalse
Is Requiredtrue
Is Derivedfalse
Is Surrogate Keyfalse



 Inventory Control Num
DescriptionThe text string that uniquely identifies this asset within the inventory control system used by the organization. This is not the same as serial number.
Data TypeStandards - Data Domains.ddm/Data Domains/String [VARCHAR(255)]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Item Importance Cd
DescriptionThis field contains an indicator of the level of importance of an item considered for this inventory location, such as an indicator signifying whether the item is considered critical for this inventory location.
Data TypeStandards - Data Domains.ddm/Data Domains/Tenant Common Code [VARCHAR(80)]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Item Importance Code Descr
DescriptionThis field contains an indicator of the level of importance of an item considered for this inventory location, such as an indicator signifying whether the item is considered critical for this inventory location.
Data TypeStandards - Data Domains.ddm/Data Domains/Description [VARCHAR(250)]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Item Importance Code Sk
DescriptionThis field contains an indicator of the level of importance of an item considered for this inventory location, such as an indicator signifying whether the item is considered critical for this inventory location.
Data TypeStandards - Data Domains.ddm/Data Domains/Surrogate Key [INTEGER]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Item Size
DescriptionThe magnitude or size of the inventory item.

For example:
200 mg.
2 cubic meters
150 kgs
Data TypeStandards - Data Domains.ddm/Data Domains/Number Decimal [DECIMAL(10,4)]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Lot Number
DescriptionThis field contains the lot number of the service item in inventory. Part of UDI, Unique Device Identifier.
Data TypeStandards - Data Domains.ddm/Data Domains/Alphanumeric [VARCHAR(80)]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Manufacture Dt
DescriptionDate service item was produced by the manufacturer. Part of UDI, Unique Device Identifier.
Data TypeStandards - Data Domains.ddm/Data Domains/Date [DATE]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Measurement Period Type Cd
DescriptionIndicates the balance calendar period.

For example:
Day
Week
Month
Quarter
Half
Year
Data TypeStandards - Data Domains.ddm/Data Domains/Tenant Common Code [VARCHAR(80)]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Measurement Period Type Code Descr
DescriptionIndicates the balance calendar period.

For example:
Day
Week
Month
Quarter
Half
Year
Data TypeStandards - Data Domains.ddm/Data Domains/Description [VARCHAR(250)]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Measurement Period Type Code Sk
DescriptionIndicates the balance calendar period.

For example:
Day
Week
Month
Quarter
Half
Year
Data TypeStandards - Data Domains.ddm/Data Domains/Surrogate Key [INTEGER]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Opening Dt
DescriptionThe date upon which the account is opened and is ready for transactions.
Data TypeStandards - Data Domains.ddm/Data Domains/Date [DATE]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Period Balance Type Cd
DescriptionIndicates the method by which the amount reflected by the account balance is calculated.

For example:
Amount
Maximum
Minimum
Mean
Median
Mode
Total
Total Average
Net
Data TypeStandards - Data Domains.ddm/Data Domains/Tenant Common Code [VARCHAR(80)]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Period Balance Type Code Descr
DescriptionIndicates the method by which the amount reflected by the account balance is calculated.

For example:
Amount
Maximum
Minimum
Mean
Median
Mode
Total
Total Average
Net
Data TypeStandards - Data Domains.ddm/Data Domains/Description [VARCHAR(250)]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Period Balance Type Code Sk
DescriptionIndicates the method by which the amount reflected by the account balance is calculated.

For example:
Amount
Maximum
Minimum
Mean
Median
Mode
Total
Total Average
Net
Data TypeStandards - Data Domains.ddm/Data Domains/Surrogate Key [INTEGER]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Point Balance Type Cd
DescriptionIndicates the nature of the point in time within an interval of time at which the account balance was recorded.

For example:
Beginning or Opening Balance
Interim Balance
- Statement Balance
- Capital Balance
- YTD Balance
End or Closing Balance
Data TypeStandards - Data Domains.ddm/Data Domains/Tenant Common Code [VARCHAR(80)]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Point Balance Type Code Descr
DescriptionIndicates the nature of the point in time within an interval of time at which the account balance was recorded.

For example:
Beginning or Opening Balance
Interim Balance
- Statement Balance
- Capital Balance
- YTD Balance
End or Closing Balance
Data TypeStandards - Data Domains.ddm/Data Domains/Description [VARCHAR(250)]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Point Balance Type Code Sk
DescriptionIndicates the nature of the point in time within an interval of time at which the account balance was recorded.

For example:
Beginning or Opening Balance
Interim Balance
- Statement Balance
- Capital Balance
- YTD Balance
End or Closing Balance
Data TypeStandards - Data Domains.ddm/Data Domains/Surrogate Key [INTEGER]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Received Dt
DescriptionThe date upon which the product or inventory item in question was received into inventory. This might be the most recent receipt of volume items such as bed sheets or the actual receipt date of a single high value serial number tracked item such as a piece of medical equipment.
Data TypeStandards - Data Domains.ddm/Data Domains/Date Time [TIMESTAMP]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Serial Number
DescriptionUnique identifier of a specific instance of an item. Part of UDI, Unique Device Identifier.
Data TypeStandards - Data Domains.ddm/Data Domains/Alphanumeric [VARCHAR(80)]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Source Cd
DescriptionThe code that corresponds to the Source Code Sk.
Data TypeStandards - Data Domains.ddm/Data Domains/Tenant Common Code [VARCHAR(80)]
Is Part Of PrimaryKeyfalse
Is Requiredtrue
Is Derivedfalse
Is Surrogate Keyfalse



 Source Code Descr
DescriptionThe description that corresponds to the Source Type Cd.
Data TypeStandards - Data Domains.ddm/Data Domains/Description [VARCHAR(250)]
Is Part Of PrimaryKeyfalse
Is Requiredtrue
Is Derivedfalse
Is Surrogate Keyfalse



 Source Code Sk
DescriptionThe origin of the data identifying the actual load source, vendor, manual key entry, or context of the data in a specific row in the database.
Data TypeStandards - Data Domains.ddm/Data Domains/Surrogate Key [INTEGER]
Is Part Of PrimaryKeyfalse
Is Requiredtrue
Is Derivedfalse
Is Surrogate Keyfalse



 Tenant Sk
DescriptionThe surrogate key of the entry identifying the legal owner of the data.
Data TypeStandards - Data Domains.ddm/Data Domains/Surrogate Key [INTEGER]
Is Part Of PrimaryKeyfalse
Is Requiredtrue
Is Derivedfalse
Is Surrogate Keyfalse



 Type Cd
DescriptionThe code that corresponds to the Type Code Sk.
Data TypeStandards - Data Domains.ddm/Data Domains/Tenant Common Code [VARCHAR(80)]
Is Part Of PrimaryKeyfalse
Is Requiredtrue
Is Derivedfalse
Is Surrogate Keyfalse



 Type Code Descr
DescriptionThe description that corresponds to the Type Cd.
Data TypeStandards - Data Domains.ddm/Data Domains/Description [VARCHAR(250)]
Is Part Of PrimaryKeyfalse
Is Requiredtrue
Is Derivedfalse
Is Surrogate Keyfalse



 Type Code Sk
DescriptionThe code identifying the actual type of the entity as per the type hierarchy defined in the analysis data model.
Data TypeStandards - Data Domains.ddm/Data Domains/Surrogate Key [INTEGER]
Is Part Of PrimaryKeyfalse
Is Requiredtrue
Is Derivedfalse
Is Surrogate Keyfalse



 Unit Cost Amt
DescriptionThe unit cost of a single item of inventory. This will be related to the accounting policy for particular inventory items. High cost drugs for example may be accounted for at an individual dose level while paracetamol may be per 100 pills. Similarly hospital beds may be accounted for at an individual bed level while surgical gloves will be counted per box.
Data TypeStandards - Data Domains.ddm/Data Domains/Currency Amount [DECIMAL(14,2)]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Valid From Ts
DescriptionEstablishes a period where a set of attributes are true in the source system. This would be populated with the transaction timestamp and would be used for the snapshot date.
Data TypeStandards - Data Domains.ddm/Data Domains/Timestamp [TIMESTAMP]
Is Part Of PrimaryKeyfalse
Is Requiredtrue
Is Derivedfalse
Is Surrogate Keyfalse



 Valid To Ts
DescriptionEnds a period of validity.
Data TypeStandards - Data Domains.ddm/Data Domains/Timestamp [TIMESTAMP]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse

Primary Key Details

 Inventory Account Dimension PK
Key AttributeInventory Account Dk