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