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 |
|
|
