Industry Day - IDT Report

An Industry day will occur on Friday 22 June 2018 at 0900.  Contracting, Comptroller, and Data Processing will be on hand to describe the requirement and answer any questions there are about the requirement.

The Louisiana Army National Guard (LANG) seeks a reporting tool to analyze IDT Attendance information. LANG requires an interactive report that generates information "rolled up" at the statewide level with "drill down" capability down to subordinate unit levels across the state.

The Louisiana Army National Guard conducts inactive duty training (IDT) on a monthly basis. Soldier attendance at IDT training events is entered into the My Unit Pay (MUP) system at the unit level. Various codes are used to record the attendance status of each Soldier in accordance with National Guard Regulation (NGR) 680-1 (P=Present, C=Constructive, U=AWOL, etc.). Once attendance is finalized and certified in MUP, the data is transferred to Defense Joint Military Pay System (DJMS). The state then receives a data file which is stored in an internal database, on servers maintained by our Data Processing Division with the United States Property and Fiscal Office (USPFO).

The various IDT attendance codes determine if a Soldier is paid, or if absent, if the Soldier is allowed to make-up the IDT period. If the Soldier is absent for IDT, but is allowed to make-up the training after the IDT period, the unit codes the Soldier as "K - Split Train". In this case, funds are obligated at the time the "K" is entered to pay the Soldier at a future time when the Soldier completes the IDT performance. The Solider has 90 days to "make-up" the IDT period. If the Soldier fails to perform the duty within 90 days, the funds are de-obligated and the Soldier's status for the IDT period is changed from "K" to "A - Absent".

The required end product is an easy to navigate, interactive report, that allows end users from various levels in the organization to quickly access the report, and drill-down within the report to obtain IDT attendance information for the unit or UIC of interest. The report should be formatted in a manner that allows the user to easily compare their unit IDT attendance information with other units within the same organizational level. The report should not require any keyboard entered information from the user. User should be able to navigate the report by "clicking" on data to "drill down" to more detailed levels of information.

Require completion and delivery of reporting tool no later than thirty days after the award of contract. Report must be completely functional prior to 01 October 2018.