Appendix C
The Payroll Liability 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 |
|
|
|
Deduction Type Code |
Varchar2 |
5 |
|
|
Deduction Plan Code |
Varchar2 |
5 |
|
|
Deduction Detail Transaction Code |
Varchar2 |
8 |
|
|
Deduction Detail Department Code |
Varchar2 |
4 |
|
|
Deduction Detail Transaction ID |
Varchar2 |
20 |
|
|
Deduction Detail Line Number |
Number |
10 |
|
|
Deduction Detail Sub Line Number |
Varchar2 |
2 |
|
|
Deduction Detail Component Sequence number |
Varchar2 |
2 |
|
|
Deduction Detail Retro Sequence Number |
Varchar2 |
2 |
|
|
Deduction 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 |
|
|
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 |
|
|
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 |
|
|
|
Vendor/Customer Code |
Varchar2 |
20 |
|
|
Use EFT flag |
Char |
1 |
|
|
Net Pay Distribution Type ID |
Char |
1 |
|
|
Goal Deduction Amount |
Number |
9,2 |
|
|
Goal Cycle Count |
Number |
5,2 |
|
|
Multiple Installments Count |
Number |
10 |
|
|
Installments Deduction Count |
Number |
7 |
|
|
Goal Type ID |
Char |
1 |
|
|
Deduction Type Short Description |
Varchar2 |
15 |
|
|
Deduction Goal ID |
Char |
1 |
|
|
Deduction Plan Short Description |
Varchar2 |
15 |
|
|
Deduction Amount |
Number |
9,2 |
|
|
Generate Payment Voucher flag |
Char |
1 |
|
|
Event Category Code |
Varchar2 |
5 |
|
|
Financial Event |
Varchar2 |
4 |
|
|
Financial Transaction Code |
Varchar2 |
2 |
|
|
Payment Voucher Type Code |
Char |
1 |
|
|
Seller Fund Code |
Varchar2 |
4 |
|
|
Seller Sub Fund Code |
Varchar2 |
4 |
|
|
Seller Department Code |
Varchar2 |
4 |
|
|
Seller Unit Code |
Varchar2 |
4 |
|
|
Seller Sub Unit Code |
Varchar2 |
4 |
|
|
Seller Activity Code |
Varchar2 |
4 |
|
|
Seller Sub Activity Code |
Varchar2 |
4 |
|
|
Seller Object Code |
Varchar2 |
4 |
|
|
Seller Sub Object Code |
Varchar2 |
4 |
|
|
Seller Department Object Code |
Varchar2 |
4 |
|
|
Seller Reporting Category Code |
Varchar2 |
10 |
|
|
Seller Sub Reporting Category Code |
Varchar2 |
4 |
|
|
Seller Program Code |
Varchar2 |
6 |
|
|
Seller Function Code |
Varchar2 |
4 |
|
|
Seller Sub Function Code |
Varchar2 |
4 |
|
|
Seller Appropriation Code |
Varchar2 |
9 |
|
|
Seller Revenue Source Code |
Varchar2 |
4 |
|
|
Seller Sub Revenue Source Code |
Varchar2 |
4 |
|
|
Seller Department Revenue Source Code |
Varchar2 |
4 |
|
|
Seller Location Code |
Varchar2 |
4 |
|
|
Seller Sub Location Code |
Varchar2 |
4 |
|
|
Seller Task Code |
Varchar2 |
4 |
|
|
Seller Sub Task Code |
Varchar2 |
4 |
|
|
Seller Task Order Code |
Varchar2 |
6 |
|
|
Seller Major Program Code |
Varchar2 |
6 |
|
|
Seller Phase Code |
Varchar2 |
6 |
|
|
Seller Program Period Code |
Varchar2 |
6 |
|
|
Seller Balance Sheet Account Code |
Varchar2 |
4 |
|
|
Seller Sub Balance Sheet Account Code |
Varchar2 |
4 |
|
|
Seller Offset Balance Sheet Account Code |
Varchar2 |
4 |
|
|
Seller Offset Sub Balance Sheet Account Code |
Varchar2 |
4 |
|
|
Offset Receivable Account |
Varchar2 |
4 |
|
|
COA PERFKEY |
Number |
10 |
|
|
Summary PERFKEY |
Varchar2 |
44 |
|
|
VP Summary PERFKEY |
Varchar2 |
211 |
|
|
VP Accounting PERFKEY |
Varchar2 |
34 |
|
|
Gross-to-Net Process Number |
Number |
18 |
|
|
PAM Processed ID |
Number |
18 |
|
|