DATA BASE ALIGNMENT PROGRAM (DAPs)

1
DATA BASE ALIGNMENT PROGRAM (DAPs)

• UPON COMPLETION OF THIS TOPIC, YOU
• WILL BE ABLE TO
• DESCRIBE DATA BASE ALIGNMENT
• PROGRAM (DAP)

2
DATA BASE ALIGNMENT PROGRAM (DAPs)
DAPs
3
DATA BASE ALIGNMENT PROGRAM (DAPs)
Purpose Designed to resolve various data
base discrepancies. These discrepancies are
normally caused by application software
inaccuracies or data entry errors made by
users.
4
DATA BASE ALIGNMENT PROGRAM (DAPs)
Personnel Requirements Five major personnel
functions are necessary to perform DAPs. They
include computer operations, data
base administration, system administration, and
maintenance / supply functional data base
administration.
5
DATA BASE ALIGNMENT PROGRAM (DAPs)
Precautions It is recommended that DAPs be
executed as detailed or further data base
discrepancies will occur. The majority of
NALCOMIS DAPs access, modify,and/or create and
delete data in the system. It is imperative
that data base or system saves be completed prior
to and after execution of NALCOMIS DAPs.
6
DATA BASE ALIGNMENT PROGRAM (DAPs)
Aids in resolving Inv DB problems 1.
Validates NIIN records against COGs/MCCs 2.
Validates FGCs for multiple Heads of Family
3. Validates DIFM items without a N812 mailbox
4. Validates IOU records 5. Displays
records associated with specific MAF 6.
Modify history data for specific DDSN 7.
Create a N812 mailbox 8. Generates
mini-transledger report 9. Removes contract
data from data base 10. Deletes MAF (MCN)
when necessary 11. Deletes requisition
records when necessary
7
DATA BASE ALIGNMENT PROGRAM (DAPs)
TYPES REPORTS
UPDATES
8
DATA BASE ALIGNMENT PROGRAM (DAPs)
DBAGs (REPORTS)
9
Select
10
Contains all available DAPS to maintain data
base integrity
11
DBAG14
Select
12
DBAGs (REPORTS)
DBAG14 (COG/MCC ERROR REPORT) Allows you to
generate an Error Report of mismatched NIIN's
COG/MCC and Table's COG/MCC. It also generates a
Counter Report to show the number of NIINs for
each COG/MCC on the database. NOTE All COG/MCC
combination must be loaded.
13
DBAG21
14
DBAGs (REPORTS)
DBAG21 (INV DISC REPORT) Allows you to
generate an error report of out of
balance quantities and show the number of
non-DIFM items attached to a MAF. Also displays
Inventory discrepancies. It is used as an aid to
resolving inventory data base problem areas. This
program should be run at least weekly for one
month following the initial site turn-on,
thereafter, monthly-during reconciliation).
15
DBAG32
16
DBAGs (REPORTS)
DBAG32 (INV / ITEM REC) Allows you to review a
list of records for a specific NIIN. to perform
analysis and/or troubleshooting. This DAP is
used in conjunction with DBAG21 (Displays
Inventory Discrepancies) and is a
valuable trouble-shooting tool which is used in
researching problem areas.
17
DBAG85
18
DBAGs (REPORTS)
DBAG85 (MINI TRANSLEDGER) This DAP creates a
Mini-Transledger report based on an input file of
NIINs or group of NIINs. USE This DAP is used
in conjunction with DBAG21 (Displays Inventory
Discrepancies) and is a valuable
trouble-shooting tool which is used in
researching problem areas identified by DBAG21.
19
DBDM37
20
(No Transcript)
21
DBAGs (REPORTS)
DBDM37 (1144 RPT) Allows you to generate the
UADPS 1144 Supply Effectiveness Reports using
selected pool codes type of report and whether
to use existing extract files or create new
ones. Last run date will be displayed when the
user selects the DBDM37 process. Enter
reporting period beginning run date. Enter
reporting period ending run date. Pool Code
Processing Select Include, and enter pool
codes to be processed. Select Exclude, and
enter pool codes to be excluded from the
process. Click All to process all pool codes
on the database.
22
DBAGs (REPORTS)
DBDM37 (1144 RPT) Report Selection Select
Repairables Only to produce reports containing
repairables. Select Repairables Pack-Ups to
produce reports containing repairables and
pack-ups. To use existing extract files, click in
the check box. The default is N. Click OK to
generate the reports. Click Cancel to return to
the main menu.
23
DBAG2L
24
(No Transcript)
25
DBAGs (REPORTS)
DBAG2L (BE4 ICRL OUTPUT) This window allows you
to create a BE4 file and save it to a directory
or diskette. This process will run in the
background and must be transferred using "File
Transfer" to a designated drive and
directory. BE4 PROCESS Click OK to run the BE4
processes in the background. Click Cancel to
return to the main menu. NOTE A message appears
giving you the batch job number and location of
the file. You must use the job number when file
transferring. Screen copy the message and
click OK, acknowledging that the DBAG2L process
has finished. This file may be too large to fit
on one diskette, It is suggested that the file be
transferred to a directory and zipped, then
copied to a diskette.
26
DBAG2H
27
(No Transcript)
28
DBAGs (REPORTS)
DBAG2H (AIRPAC COST ACCT) Allows you to produce
an AIRPAC Financial report file totaling
activity requisitions for repairables and
consumables. This process can create
two different files based on the activity code
criteria. A file can be created for an individual
activity by using an activity code or for all
activities by using three asterisks (). Using
"-DM" as the activity code can create another
file. This will create a file with DDSN and MCN
information only.
29
DBAGs (REPORTS)
DBAG2H (AIRPAC COST ACCT) This process will run
in the background and must be transferred
using "File Transfer" to a designated drive and
directory. 1. Enter the Activity Code (one
Activity code, All, or -DM
(DDSN-MCN). 2. Enter the Beginning Julian Date
(98017). The Julian date must be 001 through
366. The Beginning date must be less than the
ending date. 3. Enter the Ending Julian Date
(98035). 4. Click OK to run the process. 5. Click
Cancel to return to the main menu.
30
DBAGs (REPORTS)
DBAG2H (AIRPAC COST ACCT) NOTE A message will
appear giving you the batch job number and
location of the file. You must use the job number
when file transferring. Screen copy the message
and click OK, acknowledging that the DBAG2H
process has finished and the file must be
file transferred.
31
DBAG57
32
(No Transcript)
33
DBAGs (REPORTS)
DBAG57 (E38 FILE EXTRACT) This window allows you
to extract the necessary data from the NALCOMIS
database for input to FMSO's E38 process. by
producing an E38 file and save it to a directory.
This process runs in the background and must be
transferred using "File Transfer" to a designated
drive and directory. E38 Process Select the
E38 File Extract Process (Reconciliation or
Retrieval). Select Retrieve Nomenclature, if
required. Click OK to run process. Click
Cancel to return to the Main Menu.
34
DBAGs (REPORTS)
DBAG57 (E38 FILE EXTRACT) NOTE A message
appears giving you the batch job number and
location of the file. You must use the job number
when file transferring. Screen copy the message
and click OK, acknowledging that the E38 process
has finished.
35
DATA BASE ALIGNMENT PROGRAM (DAPs)
DBAGs (UPDATES)
36
Select UPDATE
DBAG1R
37
DBAGs (UPDATE)
DBAG1R (SUBCUSTODY UPDATE) Allows update to
the subcustody inventory quantity and recompute
the ACBAL inventory quantity. You can add and
delete item records for a specific subcustody
NIIN. - Enter the NIIN and click OK to
display inventory and subcustody records
for the NIIN entered. Select subcustody
item records to be deleted. Click Delete
to delete selected record. Click Restore
to restore record that was deleted.
Click Add to add a subcustody item record.
Click Update to modify the database for those
add and delete records Click Cancel to
return to the main menu.
38
DBAGs (UPDATE)
DBAG1R (SUBCUSTODY UPDATE) NOTE If
Update is clicked without selecting Add or
Delete, the inventory subcustody and ACBAL
quantities will be recomputed.
39
DBAG17
40
DBAGs (UPDATE)
DBAG17 (ACBAL UPDATE) Allows you to produce a
file containing NIINs that have a discrepant
ACBAL for review and update. CAUTION Before
using this process to update, a NIIN should
be researched to determine whether it should be
updated.
41
DBAGs (UPDATE)
DBAG17 (ACBAL UPDATE) Click any header column
to sort on that column. Click Print to produce
a hardcopy to review and research. Select a
NIIN or a group of NIINs using the shift key and
click Delete to delete the NIINs
from the file that you do not want updated.
Click Restore to undelete the NIINs. NIINs will
be added at the end of the file. Re-sort
on the NIIN to reposition. Click Update to
modify the invdata ACBAL records. All records
left in the file will be updated with the
correct ACBAL field data, except those NIINS
with a negative ACBAL. They MUST BE corrected
using other DAPs or procedures. The correct
ACBAL field is calculated using other invdata
quantities and does not check to see if the
item records exist. If you choose to update the
invdata ACBAL using the corrected ACBAL field
data without research, you could have an
incorrect ACBAL
42
DBAGs (UPDATE)
DBAG17 (ACBAL UPDATE) You can delete those NIINs
that you do not want to update from the file.
Some of the NIINs may show a negative ACBAL.
Those NIINs cannot be updated using this
procedure and must be updated using other DAPs or
procedures. Each NIIN should be researched
before updating. This procedure will not correct
any column on the invdata record except ACBAL,
therefore, each NIIN should be corrected
using the specified DAP if other columns are to
be corrected. Re-running DBAG17 after corrections
are made will eliminate those NIINs from this
file.
43
DBAG42
44
DBAGs (UPDATE)
DBAG42 (EXTERNAL/CONTRACT DELETE) Enables you to
delete external records (dr05) that are not
attached to a requisition (dr09) or an item
record (ds03). The system then deletes
the contract records (dr04) that do not have a
matching external record and are not attached to
a requisition. - Click Yes to send this process
to the scheduler for release. - Click No to send
this process to the batch queue for release. -
Click Cancel to return to the main menu.
45
DBAG75
46
DBAGs (UPDATE)
DBAG75 (DIFM/OW/ER UPDATE) Allows you to
display DIFM item and invdata records for review
and update and to delete an ITEM record when
no mailbox message exists and no MAF exists
or a MAF exists with job status of JC with PC
signature and adjust the DIFM, OWE, and ER
invdata quantities based on the DIFM item
records present for a specific NIIN. Also,
the ACBAL will be recomputed.
47
DBAGs (UPDATE)
DBAG75 (DIFM/OW/ER UPDATE) Enter a NIIN.
Click OK to display invdata and DIFM item
records for the NIIN specified. Click
Delete to delete the selected record from the
window. Click Update to delete the ITEM
record from the database, adjust the DIFM
quantities on the database, and recompute the
ACBAL. Click Update, without selecting an
ITEM record, to modify DIFM, OWE, and ER
invdata quantities and recompute the ACBAL.
Click Close to return to the main menu.
48
DBAG76
49
DBAGs (UPDATE)
DBAG76 (DUE QTY UPDATE) Allows you to enter a
NIIN to review the Due invdata quantity for
update and adjust the Due invdata quantity based
on the Due Item records for a specific NIIN -
Enter a NIIN. Click OK to display
invdata and Due records for the NIIN specified.
Click Update to modify due invdata
quantity on the database. Click Close to
return to the main menu.
50
DBAG79
51
DBAGs (UPDATE)
DBAG79 (IOU UPDATE) Allows you to add, delete
and update IOU records and update SOIOU and ERIOU
invdata quantities and recompute the
ACBAL. Click Add and enter a DDSN to add a new
IOU record. Click Update to add the dr06_iou
record to the database, modify the SOIOU and
ERIOU invdata quantities, and recompute the
ACBAL. A transledger record will be written.
52
DBAGs (UPDATE)
DBAG79 (IOU UPDATE) Select an IOU record and
click Delete to remove an IOU record. The SOIOU
and ERIOU invdata fields will be changed and the
ACBAL recomputed. Click Update to apply changes
to the database. Only the dr06_iou record will be
deleted from the database. Click Update after
the above three processes will modify the
database accordingly. Click Update without any
other selection to total the IOUIND column and
modify the invdata SOIOU and ERIOU fields and
recompute the ACBAL. A transledger record will be
generated.
53
DBAG80
54
DBAGs (UPDATE)
DBAG80 (PKUP OH UPDATE) Allows you to display
the Packup Onhand item and invdata records
for review and update. - Enter a NIIN. - Click
OK to display invdata and Packup Onhand item
records for the specified NIIN. - Click
Cancel to return to the main menu.
55
DBAG81
56
DBAGs (UPDATE)
DBAG81 (RFI UPDATE) Allows you to display the
RFI item and invdata records for review
and update. - Enter a NIIN. - Click OK to
display invdata and RFI item records for the
specified NIIN. - Click Cancel to return to the
main menu.
57
DBAG83
58
DBAGs (UPDATE)
DBAG83 (SUSPENSE UPDATE) Allows you to display
suspense item records and review for deletion.
- Enter a NIIN. - Click OK to display a NIIN and
the suspense records. - Click Cancel to return
to the main menu.
59
DBAG84
60
DBAGs (UPDATE)
DBAG84 (PACKUP DEPLOYED UPDATE) Allows you to
display packup deployed records for review and
update. - Enter a NIIN. - Click OK to display
packup deployed records. - Click Cancel to
return to the main menu.
61
DBAGOP
62
DBAGs (UPDATE)
DBAGOP (REQ KILL) Allows you to enter a DDSN
to be deleted. It also deletes all associated
records. Various message boxes may be displayed
depending on the DDSN you entered NOTE IF A
PRINTOUT IS NEEDED FOR BACKFIT, SELECT CANCEL
AND RUN REQ PRINT BEFORE PROCEEDING
63
DBAGs (UPDATE)
DBAGOP (REQ KILL) This process is used to
delete a selected DDSN and its associated
records. Printed copies of the requisition
should be obtained prior to executing the
process. This process will delete the data from
the database and is not recoverable online and
must be reentered or backfit to the system.
64
DBAGs (UPDATE)
DBAGOP (REQ KILL) The most common reason for
this DBAG is due to Erroneous use of a
contingency code. It is not intended
for deleting stock requisitions as it will not
modify due quantities. Note If an IOU exists,
DBAG79 (IOU Update), must be performed.
65
DBAG88
66
DBAGs (UPDATE)
DBAG88 (MAF KILL) This DAP will delete the MAF
and update the associated record(s). Note This
DAP is only to be executed when the MAF cannot be
processed through normal on-line conversations.
67
SELECT
EXIT
68
ANY QUESTIONS ???
69
REVIEW AND SUMMARY

• DESCRIBED DAPs