Appendix D
The Payroll Accounting Management error table layout is outlined below:
Column Name |
Data Type |
Length |
Primary Key |
Null Allowed |
Agent ID |
Number |
18 |
X |
Not null |
Sequence No |
Number |
10 |
X |
Not null |
GTN Run Number |
Number |
10 |
|
|
Pay Cycle Code |
Varchar2 |
5 |
|
|
Employee ID |
Varchar2 |
10 |
|
|
Appointment ID |
Char |
1 |
|
|
Internal Employee ID |
Char2 |
10 |
|
|
Error Type (exception error/non exception error) |
Char |
1 |
|
|
Accounting Month |
Number |
3 |
|
|
Accounting Year |
Integer |
10 |
|
|
Event Date |
Date |
|
|
|
Event Code |
Varchar2 |
5 |
|
|
Deduction Type Code |
Varchar2 |
5 |
|
|
Deduction Plan Code |
Varchar2 |
5 |
|
|
Fund Code |
Varchar2 |
4 |
|
|
Sub Fund Code |
Varchar2 |
4 |
|
|
Department Code |
Varchar2 |
4 |
|
|
Unit Code |
Varchar2 |
4 |
|
|
Sub Unit Code |
Varchar2 |
4 |
|
|
Activity Code |
Varchar2 |
4 |
|
|
Sub Activity Code |
Varchar2 |
4 |
|
|
Object Code |
Varchar2 |
4 |
|
|
Sub Object Code |
Varchar2 |
4 |
|
|
Department Object Code |
Varchar2 |
4 |
|
|
Reporting Category Code |
Varchar2 |
10 |
|
|
Sub Reporting Category Code |
Varchar2 |
4 |
|
|
Program Code |
Varchar2 |
6 |
|
|
Function Code |
Varchar2 |
4 |
|
|
Sub Function Code |
Varchar2 |
4 |
|
|
Appropriation Code |
Varchar2 |
9 |
|
|
Revenue Source Code |
Varchar2 |
4 |
|
|
Sub Revenue Source Code |
Varchar2 |
4 |
|
|
Department Revenue Source Code |
Varchar2 |
4 |
|
|
Location Code |
Varchar2 |
4 |
|
|
Sub Location Code |
Varchar2 |
4 |
|
|
Task Code |
Varchar2 |
4 |
|
|
Sub Task Code |
Varchar2 |
4 |
|
|
Task Order Code |
Varchar2 |
6 |
|
|
Major Program Code |
Varchar2 |
6 |
|
|
Phase Code |
Varchar2 |
6 |
|
|
Program Period Code |
Varchar2 |
6 |
|
|
Balance Sheet Account Code |
Varchar2 |
4 |
|
|
Sub Balance Sheet Account Code |
Varchar2 |
4 |
|
|
Offset Balance Sheet Account Code |
Varchar2 |
4 |
|
|
Offset Sub Balance Sheet Account Code |
Varchar2 |
4 |
|
|
GTN Type ID |
Varchar2 |
1 |
|
|
Process Date |
Date |
|
|
|
Position Department Code |
Varchar2 |
4 |
|
|
Position Unit Code |
Varchar2 |
4 |
|
|
Position ID |
Varchar2 |
20 |
|
|
Internal Position ID |
Char |
10 |
|
|
Pay Period Start Date |
Date |
|
|
|
Pay Period End Date |
Date |
|
|
|
Event Category Code |
Varchar2 |
5 |
|
|
Contract pay Amount |
Number |
9,2 |
|
|
Deduction Pay Amount |
Number |
9,2 |
|
|
Payroll Detail Transaction Code |
Varchar2 |
8 |
|
|
Payroll Detail Department Code |
Varchar2 |
4 |
|
|
Payroll Detail Transaction ID |
Varchar2 |
20 |
|
|
Payroll Detail Line Number |
Number |
10 |
|
|
Payroll Detail Sub-Line Number |
Varchar2 |
2 |
|
|
Payroll detail Component Sequence Number |
Varchar2 |
2 |
|
|
Payroll Detail Retro Sequence Number |
Varchar2 |
2 |
|
|
Payroll Detail Reverse Replace Sequence Number |
Varchar2 |
2 |
|
|
Home Department Code |
Varchar2 |
4 |
|
|
Home Unit Code |
Varchar2 |
4 |
|
|
Seller Field Errors flag |
Varchar2 |
1 |
|
|
Error Key |
Varchar2 |
120 |
|
|
Error Message |
Varchar2 |
120 |
|
|