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