Appendix E

The Payroll Accounting Management Statistics table layout is outlined below:

Column Name

Data Type

Length

Primary Key

Null Allowed

GTN Run Number

Number

10

X

Not null

Pay Cycle

Varchar2

5

X

Not null

Fiscal Month

Number

3

X

Not null

Fiscal Year

Number

10

X

Not null

Fund Code

Varchar2

4

X

Not null

Sub Fund Code

Varchar2

4

X

Not null

Department Code

Varchar2

4

X

Not null

Unit Code

Varchar2

4

X

Not null

Sub Unit Code

Varchar2

4

X

Not null

Object

Varchar2

4

X

Not null

Total Expenses

Number

13,2

 

 

Total Liabilities

Number

13,2