Administration Help   I   Financial Help  I   Performance Budgeting Help

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