Administration Help   I   Financial Help  I   Performance Budgeting Help

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