Table Definitions - Web

Evaluated Field 01

EVALUATED_FIELD

EVALUATED_FIELD_01

These are your query statements, to put that another way, these are IF statements Size: 10

Evaluated Field 02

EVALUATED_FIELD

EVALUATED_FIELD_02

These are your query statements, to put that another way, these are IF statements Size: 10

Evaluated Field 03

EVALUATED_FIELD

EVALUATED_FIELD_03

These are your query statements, to put that another way, these are IF statements Size: 10

Evaluated Field 04

EVALUATED_FIELD

EVALUATED_FIELD_04

These are your query statements, to put that another way, these are IF statements Size: 10

Evaluated Field 05

EVALUATED_FIELD

EVALUATED_FIELD_05

These are your query statements, to put that another way, these are IF statements Size: 10

Evaluated Field 06

EVALUATED_FIELD

EVALUATED_FIELD_06

These are your query statements, to put that another way, these are IF statements Size: 10

Evaluated Field 07

EVALUATED_FIELD

EVALUATED_FIELD_07

These are your query statements, to put that another way, these are IF statements Size: 10

Evaluated Field 08

EVALUATED_FIELD

EVALUATED_FIELD_08

These are your query statements, to put that another way, these are IF statements Size: 10

Evaluated Field 09

EVALUATED_FIELD

EVALUATED_FIELD_09

These are your query statements, to put that another way, these are IF statements Size: 10

Evaluated Field 10

EVALUATED_FIELD

EVALUATED_FIELD_10

These are your query statements, to put that another way, these are IF statements Size: 10

Formula Field 01

FORMULA_FIELDS

FORMULA_01

This is a place holder - there are no built in formulas. You will build the formulas using provided tools Size: 10 Format: ########.##

Formula Field 02

FORMULA_FIELDS

FORMULA_02

This is a place holder - there are no built in formulas. You will build the formulas using provided tools Size: 10 Format: ########.##

Formula Field 03

FORMULA_FIELDS

FORMULA_03

This is a place holder - there are no built in formulas. You will build the formulas using provided tools Size: 10 Format: ########.##

Formula Field 04

FORMULA_FIELDS

FORMULA_04

This is a place holder - there are no built in formulas. You will build the formulas using provided tools Size: 10 Format: ########.##

Formula Field 05

FORMULA_FIELDS

FORMULA_05

This is a place holder - there are no built in formulas. You will build the formulas using provided tools Size: 10 Format: ########.##

Formula Field 06

FORMULA_FIELDS

FORMULA_06

This is a place holder - there are no built in formulas. You will build the formulas using provided tools Size: 10 Format: ########.##

Formula Field 07

FORMULA_FIELDS

FORMULA_07

This is a place holder - there are no built in formulas. You will build the formulas using provided tools Size: 10 Format: ########.##

Formula Field 08

FORMULA_FIELDS

FORMULA_08

This is a place holder - there are no built in formulas. You will build the formulas using provided tools Size: 10 Format: ########.##

Formula Field 09

FORMULA_FIELDS

FORMULA_09

This is a place holder - there are no built in formulas. You will build the formulas using provided tools Size: 10 Format: ########.##

Formula Field 10

FORMULA_FIELDS

FORMULA_10

This is a place holder - there are no built in formulas. You will build the formulas using provided tools Size: 10 Format: ########.##

Literal Number 01

LITERAL_NUMBER

LITERAL_NUMBER_FIELD_01

used in conjunction with the formulas. For example, to project what a 2% increase in pay will look like, the annual salary x this literal number. Size: 10 Format: ########.##

Literal Number 02

LITERAL_NUMBER

LITERAL_NUMBER_FIELD_02

used in conjunction with the formulas. For example, to project what a 2% increase in pay will look like, the annual salary x this literal number. Size: 10 Format: ########.##

Literal Number 03

LITERAL_NUMBER

LITERAL_NUMBER_FIELD_03

used in conjunction with the formulas. For example, to project what a 2% increase in pay will look like, the annual salary x this literal number. Size: 10 Format: ########.##

Literal Number 04

LITERAL_NUMBER

LITERAL_NUMBER_FIELD_04

used in conjunction with the formulas. For example, to project what a 2% increase in pay will look like, the annual salary x this literal number. Size: 10 Format: ########.##

Literal Number 05

LITERAL_NUMBER

LITERAL_NUMBER_FIELD_05

used in conjunction with the formulas. For example, to project what a 2% increase in pay will look like, the annual salary x this literal number. Size: 10 Format: ########.##

Literal Number 06

LITERAL_NUMBER

LITERAL_NUMBER_FIELD_06

used in conjunction with the formulas. For example, to project what a 2% increase in pay will look like, the annual salary x this literal number. Size: 10 Format: ########.##

Literal Number 07

LITERAL_NUMBER

LITERAL_NUMBER_FIELD_07

used in conjunction with the formulas. For example, to project what a 2% increase in pay will look like, the annual salary x this literal number. Size: 10 Format: ########.##

Literal Number 08

LITERAL_NUMBER

LITERAL_NUMBER_FIELD_08

used in conjunction with the formulas. For example, to project what a 2% increase in pay will look like, the annual salary x this literal number. Size: 10 Format: ########.##

Literal Number 09

LITERAL_NUMBER

LITERAL_NUMBER_FIELD_09

used in conjunction with the formulas. For example, to project what a 2% increase in pay will look like, the annual salary x this literal number. Size: 10 Format: ########.##

Literal Number 10

LITERAL_NUMBER

LITERAL_NUMBER_FIELD_10

used in conjunction with the formulas. For example, to project what a 2% increase in pay will look like, the annual salary x this literal number. Size: 10 Format: ########.##

Literal Text 01

LITERAL_TEXT

LITERAL_TEXT_FIELD_01

Used when something is required to show on every record, but is not necessarily from the system. Can also be used as a spacer. Size: 30

Literal Text 02

LITERAL_TEXT

LITERAL_TEXT_FIELD_02

Used when something is required to show on every record, but is not necessarily from the system. Can also be used as a spacer. Size: 30

Literal Text 03

LITERAL_TEXT

LITERAL_TEXT_FIELD_03

Used when something is required to show on every record, but is not necessarily from the system. Can also be used as a spacer. Size: 30

Literal Text 04

LITERAL_TEXT

LITERAL_TEXT_FIELD_04

Used when something is required to show on every record, but is not necessarily from the system. Can also be used as a spacer. Size: 30

Literal Text 05

LITERAL_TEXT

LITERAL_TEXT_FIELD_05

Used when something is required to show on every record, but is not necessarily from the system. Can also be used as a spacer. Size: 30

Literal Text 06

LITERAL_TEXT

LITERAL_TEXT_FIELD_06

Used when something is required to show on every record, but is not necessarily from the system. Can also be used as a spacer. Size: 30

Literal Text 07

LITERAL_TEXT

LITERAL_TEXT_FIELD_07

Used when something is required to show on every record, but is not necessarily from the system. Can also be used as a spacer. Size: 30

Literal Text 08

LITERAL_TEXT

LITERAL_TEXT_FIELD_08

Used when something is required to show on every record, but is not necessarily from the system. Can also be used as a spacer. Size: 30

Literal Text 09

LITERAL_TEXT

LITERAL_TEXT_FIELD_09

Used when something is required to show on every record, but is not necessarily from the system. Can also be used as a spacer. Size: 30

Literal Text 10

LITERAL_TEXT

LITERAL_TEXT_FIELD_10

Used when something is required to show on every record, but is not necessarily from the system. Can also be used as a spacer. Size: 30

Auth Code

TASK

AUTHORIZER_CODE

Size: 10

Auth Code

TASK

AUTHORIZER_DESCRIPTION

Detailed Explanation of code. Size: 30

Auth Code

TASK_ROUTING_CODE

AUTHORIZER_CODE

Size: 15

Authorizer Description

TASK_ROUTING_CODE

AUTHORIZER_DESC

Size: 30

Authorizing Employee

TEMPORARY_AUTHORIZER

*REGULAR_EMPLOYEE_NO

This field should be used whenever you want to select records by employee. None of the fields with employee name should ever be used to select individual employees. Size: 10

Authorizing Employee

TEMPORARY_AUTHORIZER

TEMP_AUTH_EMPLOYEE_MC_EMPLOYEE

Name of Authorizing employee who is re-assigning task Size: 30

Comment

TEMPORARY_AUTHORIZER

COMMENT

Why task was re-assigned Size: 60

Condition Information

TASK_ROUTING_CODE

CONDITIONAL_INFO

Size: 150

Date/Time Created

TASK

CREATION_TIMESTAMP

Size: 30 Format: DD-MMM-YYYY H

Employee Name

TASK

CREATION_EMPLOYEE_NO

This field should be used whenever you want to select records by employee. None of the fields with employee name should ever be used to select individual employees. Size: 10

Employee Name

TEMPORARY_AUTHORIZER

TEMP_AUTH_EMPLOYEE_NAME

Name of Employee who has been re-assigned the task Size: 30

Employee Number

TEMPORARY_AUTHORIZER

TEMP_AUTH_EMPLOYEE_NO

This field should be used whenever you want to select records by employee. None of the fields with employee name should ever be used to select individual employees. Size: 10

End Date

TEMPORARY_AUTHORIZER

END_DATE

When does temporary authority priviliges end? Size: 11 Format: DD-MMM-YYYY

Form Type

TASK

TASK_FORM_TYPE

Internal Lookup: ALL COMPLETED SECTIONS=ALL COMPLETED SECTIONS, FIRST AND LAST SECTIONS ONLY=FIRST AND LAST SECTIONS ONLY, FIRST SECTION ONLY WITH EXTRA COMMENTS=FIRST SECTION ONLY WITH EXTRA COMMENTS, Size: 10

Other Info

TASK

OTHER_INFO

Size: 100

Returned Indicator

TASK

HAS_BEEN_RETURNED_TO_YN

Internal Lookup: Y=YES, HAS BEEN RETURNED TO, N=NO, HASN'T BEEN RETURNED TO, Size: 10

Routing Code

TASK_ROUTING_CODE

ROUTE_CODE

Size: 10

Routing Description

TASK_ROUTING_CODE

ROUTE_DESCRIPTION

Size: 30

Start Date

TEMPORARY_AUTHORIZER

START_DATE

When does temporary authority priviliges start? Size: 11 Format: DD-MMM-YYYY

Status of Task

TASK_ROUTING_CODE

STATUS

Internal Lookup: A=Active, I=Inactive, Size: 10

Task Comment

TASK

ACTION_COMMENT

Size: 50

Task Completed?

TASK

IS_COMPLETED_YN

Internal Lookup: Y=Yes, N=No, Size: 10

Task Form

TASK

TASK_FORM

Form to call for a task Size: 800

Task Id

TASK

TASK_ID_SHORT

Size: 10

Task Status

TASK

RW_TASK_STATUS

Completed, Pending Size: 12

Task Status

TASK

STATUS_CODE

Completed, Pending Size: 6

Task Status

TASK

STATUS_DESCRIPTION

Completed, Pending Size: 30

Task Type

TASK_ROUTING_CODE

TYPE_CODE

Internal Lookup: 1=Task Only, 2=Email Only, 3=Both Task And Email, 4=Action, Size: 4

Task Type Code

TASK

TASK_TYPE_CODE

Leave Management Web, Staff Requisition, Expense Reimbursement, etc. Size: 10

Task Type Description

TASK

TASK_TYPE_DESCRIPTION

Leave Management Web, Staff Requisition, Expense Reimbursement, etc. Size: 30

Task Type Description

TASK_ROUTING_CODE

TYPE_DESCRIPTION

Internal Lookup: 1=Task Only, 2=Email Only, 3=Both Task And Email, 4=Action, Size: 30

Task Type Link

TASK

TASK_TYPE_LINK

Pending Task Widget Size: 30

Task sequence

TASK

TASK_SEQ

Size: 10

Wait Type

TASK_ROUTING_CODE

WAIT_TYPE_CODE

Internal Lookup: Y=Wait, 1=Wait All, 2=Wait Any, 3=Wait All Next Line, 4=Wait Any Next Line, N=Do Not Wait, Size: 10

Wait Type Description

TASK_ROUTING_CODE

WAIT_TYPE_DESC

Internal Lookup: Wait=Y, Wait All=1, Wait Any=2, Wait All Next Line=3, Wait Any Lext Line=4, Do Not Wait=N, Size: 30

Action Code

WEB_CONFIRMATION

ACTION_CODE

What was done Size: 20

Confirmation No.

WEB_CONFIRMATION

CONFIRMATION_NO

Size: 12

Detailed description of action to be performed

WEB_CONFIRMATION

DETAIL_INFO

Size: 80

Screen Code

WEB_CONFIRMATION

SCREEN_CODE

Name of form used Size: 20

Sequence

WEB_CONFIRMATION

SEQUENCE

Sequence in which the form was used Size: 10

Timestamp

WEB_CONFIRMATION

TIMESTAMP

Time when confirmation was issued Size: 20 Format: DD-MMM-YYYY H

User Name

WEB_CONFIRMATION

USER_NAME

Size: 20

Action Code

WEB_NAVIGATION

ACTION_CODE

What did the user do Size: 20

Detail Info

WEB_NAVIGATION

DETAIL_INFO

Employee chosen, action done Size: 80

Screen Code

WEB_NAVIGATION

SCREEN_CODE

What form did the user use Size: 20

Sequence No.

WEB_NAVIGATION

SEQUENCE NO

In what sequence was this done? Size: 10

Timestamp

WEB_NAVIGATION

TIMESTAMP

When was this done? Size: 20 Format: DD-MMM-YYYY H

User Name

WEB_NAVIGATION

USER_NAME

Name of User Size: 20

Field in atrieveERP

Report Writer Table

Report Writer Field

Field Information

Column Format

WEB_REPORT_WRITERS

COLUMN_FORMAT

Size: 10

Column Name

WEB_REPORT_WRITERS

COLUMN_NAME

Size: 30

Column Width

WEB_REPORT_WRITERS

COLUMN_WIDTH

Size: 4

Field Lookup

WEB_REPORT_WRITERS

FIELD_LOOKUP

Size: 50

Field Name

WEB_REPORT_WRITERS

FIELD_NAME

Size: 30

Needed Field Name 1

WEB_REPORT_WRITERS

NEEDED_FIELD_NAME_1

Size: 30

Needed Field Name 2

WEB_REPORT_WRITERS

NEEDED_FIELD_NAME_2

Size: 30

Needed Field Name 3

WEB_REPORT_WRITERS

NEEDED_FIELD_NAME_3

Size: 30

Needed Table Name 1

WEB_REPORT_WRITERS

NEEDED_TABLE_NAME_1

Size: 30

Needed Table Name 2

WEB_REPORT_WRITERS

NEEDED_TABLE_NAME_2

Size: 30

Needed Table Name 3

WEB_REPORT_WRITERS

NEEDED_TABLE_NAME_3

Size: 30

Product

WEB_REPORT_WRITERS

PRODUCT

Internal Lookup: PRM=HR REPORT WRITER, BAS=FINANCE REPORT WRITER, OPS=PAYROLL REPORT WRITER, MAR=ACCOUNTS RECEIVABLE REPORT WRITER, CWD=CWD, Size: 3

Selection Type

WEB_REPORT_WRITERS

SELECTION_TYPE

Size: 20

Source Code Name 1

WEB_REPORT_WRITERS

SOURCE_CODE_NAME_1

Size: 30

Source Code Name 2

WEB_REPORT_WRITERS

SOURCE_CODE_NAME_2

Size: 30

Source Code Name 3

WEB_REPORT_WRITERS

SOURCE_CODE_NAME_3

Size: 30

Source Field Name 1

WEB_REPORT_WRITERS

SOURCE_FIELD_NAME_1

Size: 30

Source Field Name 2

WEB_REPORT_WRITERS

SOURCE_FIELD_NAME_2

Size: 30

Source Field Name 3

WEB_REPORT_WRITERS

SOURCE_FIELD_NAME_3

Size: 30

Source Table Name

WEB_REPORT_WRITERS

SOURCE_TABLE_NAME

Size: 30

Table Name

WEB_REPORT_WRITERS

TABLE_NAME

Size: 30

Validation Desc Field Name

WEB_REPORT_WRITERS

VALIDATION_DESC_FIELD_NAME

Size: 30

Validation Field Name

WEB_REPORT_WRITERS

VALIDATION_FIELD_NAME

Size: 30

Validation Table Name

WEB_REPORT_WRITERS

VALIDATION_TABLE_NAME

Size: 30

Visual Field Name

WEB_REPORT_WRITERS

VISUAL_FIELD_NAME

Size: 30

Visual Field Order

WEB_REPORT_WRITERS

VISUAL_FIELD_ORDER

Size: 4

Visual Table Name

WEB_REPORT_WRITERS

VISUAL_TABLE_NAME

Size: 30

Visual Table Order

WEB_REPORT_WRITERS

VISUAL_TABLE_ORDER

Size: 4

Date report accessed

WEB_REPORT_WRITER_USAGE

DETAIL_DATE_USED

Size: 11 Format: DD-MMM-YYYY

Employee No who last ran report

WEB_REPORT_WRITER_USAGE

EMPLOYEE_NO_LAST_RUN

This field should be used whenever you want to select records by employee. None of the fields with employee name should ever be used to select individual employees. Size: 10

Last date when report was used

WEB_REPORT_WRITER_USAGE

DATE_LAST_RUN

Size: 11 Format: DD-MMM-YYYY

Name of Employee

WEB_REPORT_WRITER_USAGE

DETAIL_EMPLOYEE_NAME

Detailed Explanation of code. Size: 30

Name of Report

WEB_REPORT_WRITER_USAGE

REPORT_NAME

Size: 50

Number of Employee

WEB_REPORT_WRITER_USAGE

DETAIL_EMPLOYEE_NO

This field should be used whenever you want to select records by employee. None of the fields with employee name should ever be used to select individual employees. Size: 10

Number of times report run

WEB_REPORT_WRITER_USAGE

RUN_COUNT

Size: 10 Format: ###########

Report Writer Used (detail)

WEB_REPORT_WRITER_USAGE

DETAIL_TIMESTAMP_USED

Size: 20 Format: DD-MMM-YYYY H

System

WEB_REPORT_WRITER_USAGE

PRODUCT

Internal Lookup: BAS=BAS, CWD=CWD, MAR=MAR, PRM=PRM, OPS=OPS, Size: 6

Time when last used

WEB_REPORT_WRITER_USAGE

TIMESTAMP_LAST_RUN

Size: 20 Format: DD-MMM-YYYY H

Type of last access

WEB_REPORT_WRITER_USAGE

USAGE_TYPE

Internal Lookup: CREATED=CREATED, EDITED=EDITED, RUN=RUN, RENAMED=RENAMED, COPIED=COPIED, MOVED=MOVED, Size: 10

Username

WEB_REPORT_WRITER_USAGE

DETAIL_USERNAME

Size: 30

Username of employee who last ran the report

WEB_REPORT_WRITER_USAGE

USERNAME_LAST_RUN

Size: 30