Master's Project Proposal

Report: File Layouts

Redesign of a DOS xBase system to a Windows NT object-oriented client-server system.


BMG

The BMG is external to the FAD System, but the FAD System feeds the BMG.

Field

Type

Size

Fund_Recipient

Character

6

Type_Financing

Character

1

Appropriation

Character

4

AMS

Character

11

MDEP

Character

4

Change_Number

Numeric

6

Undistributed_Acct

Character

4

Description

Character

40

Fiscal_Year

Character

4

Amount

Numeric

14.2

FAD_Effective_Date

Date

8

FAD_Change_Number

Character

18

FAD_Advice_Number

Character

8

Resource_Type

Character

3

Limitation

Character

4

Funding Change Transaction

This the fundamental data file for the FAD System.

Field

Type

Size

Appropriation

Character

4

Type_Financing

Character

1

Fiscal_Year

Character

4

Description

Character

40

Amount

Numeric

14.2

Status

Character

1

Source_Fund_Recipient

Character

6

Source_AMS

Character

11

Source_MDEP

Character

4

Source_Undistributed_Acct

Character

4

Destination_Fund_Recipient

Character

6

Destination_AMS

Character

11

Destination_MDEP

Character

4

Destination_Undistributed_Acct

Character

4

Limitation

Character

4

Resource_Type

Character

3

Funding Transfer Request

If approved, transfer requests become Funding Change Transactions.

Field

Type

Size

Appropriation

Character

4

Type_Financing

Character

1

Fiscal_Year

Character

4

Description

Character

40

Reason

Character

2048

Amount

Numeric

14.2

Status

Character

1

Source_Fund_Recipient

Character

6

Source_AMS

Character

11

Source_MDEP

Character

4

Source_Undistributed_Acct

Character

4

Destination_Fund_Recipient

Character

6

Destination_AMS

Character

11

Destination_MDEP

Character

4

Destination_Undistributed_Acct

Character

4

Limitation

Character

4

Resource_Type

Character

3

Point_of_Contact

Character

40

Date_Submitted

Date

8

Date_Decided

Date

8

DA FAD

This data is necessary for reconciliation.

Field

Type

Size

Appropriation

Character

4

Type_Financing

Character

1

Fiscal_Year

Character

4

Subprogram

Character

3

Amount

Numeric

14.2