Appendix B
The payroll expense journal table layout is outlined below:
Column Name |
Data Type |
Length |
Primary Key |
Null Allowed |
Row Serial Number |
Number |
18 |
X |
Not null |
GTN Run Number |
Number |
10 |
|
|
Pay Cycle Code |
Varchar2 |
5 |
|
|
Fiscal Month |
Number |
3 |
|
|
Fiscal Year |
Number |
10 |
|
|
Internal Employee ID |
Char |
10 |
|
|
Appointment ID |
Char |
1 |
|
|
Internal Control Number |
Number |
15 |
|
|
Transaction ID |
Char |
1 |
|
|
Internal Position ID |
Char |
10 |
|
|
Event Date |
Date |
|
|
|
Event Type Code |
Varchar2 |
5 |
|
|
Pay Detail Transaction Code |
Varchar2 |
8 |
|
|
Pay Detail Department Code |
Varchar2 |
4 |
|
|
Pay Detail Transaction ID |
Varchar2 |
20 |
|
|
Pay Detail Line Number |
Number |
10 |
|
|
Pay Detail Sub Line Number |
Varchar2 |
2 |
|
|
Pay Detail Component Sequence Number |
Varchar2 |
2 |
|
|
Pay Detail Retro Sequence Number |
Varchar2 |
2 |
|
|
Pay Detail Reverse Replace Sequence Number |
Varchar2 |
2 |
|
|
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 |
|
|
Reversal Date |
Date |
|
|
|
Pay Event Begin Date |
Date |
|
|
|
Employee ID |
Varchar2 |
10 |
|
|
Last Name |
Varchar2 |
20 |
|
|
First Name |
Varchar2 |
15 |
|
|
Middle Name |
Varchar2 |
15 |
|
|
Title Code |
Varchar2 |
6 |
|
|
Sub Title Code |
Varchar2 |
2 |
|
|
Bank Account Code |
Varchar2 |
4 |
|
|
Check Number |
Varchar2 |
15 |
|
|
Position Department Code |
Varchar2 |
4 |
|
|
Position Unit Code |
Varchar2 |
4 |
|
|
Position ID |
Varchar2 |
20 |
|
|
Home Department Code |
Varchar2 |
4 |
|
|
Home Unit Code |
Varchar2 |
4 |
|
|
GTN Type ID |
Char |
1 |
|
|
Process Date |
Date |
|
|
|
Pay Period Start Date |
Date |
|
|
|
Pay Period End Date |
Date |
|
|
|
Check Date |
Date |
|
|
|
Contract Pay Amount |
Number |
9,2 |
|
|
Input Amount |
Number |
9,2 |
|
|
Pay Input Definition ID |
Char |
1 |
|
|
Category Code |
Varchar2 |
5 |
|
|
Financial Event Code |
Varchar2 |
4 |
|
|
COA PERFKEY |
Number |
10 |
|
|
Summary PERFKEY |
Varchar2 |
53 |
|
|
Gross-to-Net Process Number |
Number |
18 |
|
|
PAM Processed ID |
Number |
18 |
|
|