SAM II Financial Data Warehouse Load Files

Record Layouts

 

Full Table Backups

This section contains record layouts of the SAM II Advantage table backups that are created for the Data Warehouse nightly loads. These files contain all records on the SAM II Advantage table being backed up.

Delta Files

This section contains record layouts of the files created during the Data Warehouse load showing differences between the current file backup and the previous generation. Each record is marked as an add, change or delete.

Advantage Ledger File Layouts

This section contains record layouts for the SAMII Advantage Ledgers.

Data Warehouse Ledger File Layouts

This section contains record layouts for the SAMII Data Warehouse Ledgers.

MWBE/ OEO-Supplier Diversity Program

This section contains record layouts for files used to create the Minority Business and Women Owned Business Enterprise reports for the Office of Equal Opportunity's Diversity Program.