Table Definitions - Setup Or Maintenance

Action done (ie. Add/Change/Delete)

PRM_AUDIT

ACTION

Size: 10

Date / Time of change

PRM_AUDIT

TIMESTAMP

Size: 14 Format: DD-MMM-YYYY H

Entry No.

PRM_AUDIT

ENTRY_NO

Size: 4

Field that was changed

PRM_AUDIT

FIELD_NAME

Size: 30

Internal Key

PRM_AUDIT

AUDIT_KEY

Size: 30

Name of Employee who made the change

PRM_AUDIT

USERNAME_SOURCE

Size: 10

Name of user who changed

PRM_AUDIT

USERNAME

Size: 30

New Value in the field

PRM_AUDIT

NEW_VALUE

Size: 30

Previous value in that field

PRM_AUDIT

OLD_VALUE

Size: 30

Program where the value was changed

PRM_AUDIT

PROGRAM_NAME

Size: 10

Table where field resides

PRM_AUDIT

FILE_NAME

Size: 10

01=Code

DASHBOARD

DASHBOARD_CODE

Size: 20

01=Code

DASHBOARD

DASHBOARD_DESCRIPTION

Size: 30

Height of report band

DASHBOARD

HEIGHT

Size: 6

Internal instructions on generation of data

DASHBOARD

SERVER_CODE

Size: 10

Name assigned to the report generated by the dashboard

DASHBOARD

REPORT_NAME

Size: 50

Name of Option

DASHBOARD

OPTION_HEADER

Size: 30

Order of object

DASHBOARD

ORDER_NO

Size: 4

Order of object

DASHBOARD

SEQUENCE_NO

Size: 4

What to do with results.

DASHBOARD

OPTION_TYPE

Internal Lookup: 1=Report, 2=Link to Report, 3=Uploaded Document, 4=Link to Uploaded Document, 5=Any Internet Address, 6=Link to Any Internet Address, H=Header, Size: 10

Where the data is gathered from (i.e. PRM/BAS/OPS)

DASHBOARD

ENVIRONMENT

Size: 10

Which atrieveERP system is this from

DASHBOARD

PRODUCT

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

Which column to show the information in

DASHBOARD

COLUMN_NO

Size: 6

Unused

LOCATION

*MUSEQ

Size: 4

Comment 1

LOCATION

LOCATION_COMMENT1

Size: 30

Comment 1

LOCATION_DATABASE

LOCATION_COMMENT1

Size: 30

Comment 2

LOCATION

LOCATION_COMMENT2

Size: 30

Comment 2

LOCATION_DATABASE

LOCATION_COMMENT2

Size: 30

Comment 3

LOCATION

LOCATION_COMMENT3

Size: 30

Comment 3

LOCATION_DATABASE

LOCATION_COMMENT3

Size: 30

Comment 4

LOCATION

LOCATION_COMMENT4

Size: 30

Comment 4

LOCATION_DATABASE

LOCATION_COMMENT4

Size: 30

Afternoon - ABS FTE

LOCATION_DATABASE

DETAIL_PM_ABS_FTE

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

Afternoon - Abs FTE

LOCATION

DETAIL_PM_ABSENCE_FTE

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

Afternoon - End

LOCATION

DETAIL_PM_END_TIME

Size: 5

Afternoon - End

LOCATION_DATABASE

DETAIL_PM_END_TIME

Size: 10

Afternoon - Rep FTE

LOCATION

DETAIL_PM_REPLACING_FTE

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

Afternoon - Rep FTE

LOCATION_DATABASE

DETAIL_PM_REP_FTE

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

Afternoon - Start

LOCATION

DETAIL_PM_START_TIME

Size: 5

Afternoon - Start

LOCATION_DATABASE

DETAIL_PM_START_TIME

Size: 10

Full Day - ABS FTE

LOCATION

DETAIL_FULL_ABSENCE_FTE

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

Full Day - ABS FTE

LOCATION_DATABASE

DETAIL_FULL_ABS_FTE

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

Full Day - Rep FTE

LOCATION

DETAIL_FULL_REPLACING_FTE

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

Full Day - Rep FTE

LOCATION_DATABASE

DETAIL_FULL_REP_FTE

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

Morning - Abs FTE

LOCATION

DETAIL_AM_ABSENCE_FTE

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

Morning - Abs FTE

LOCATION_DATABASE

DETAIL_AM_ABS_FTE

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

Morning - End

LOCATION

DETAIL_AM_END_TIME

Size: 5

Morning - End

LOCATION_DATABASE

DETAIL_AM_END_TIME

Size: 10

Morning - Rep FTE

LOCATION

DETAIL_AM_REPLACING_FTE

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

Morning - Rep FTE

LOCATION_DATABASE

DETAIL_AM_REP_FTE

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

Morning - Start

LOCATION

DETAIL_AM_START_TIME

Size: 5

Morning - Start

LOCATION_DATABASE

DETAIL_AM_START_TIME

Size: 10

Schedule - Week Day

LOCATION

DETAIL_WEEK_DAY

Detailed Explanation of code. Size: 10

Schedule - Week Day

LOCATION_DATABASE

DETAIL_DAY_OF_WEEK

Detailed Explanation of code. Size: 10

Schedule - Week Day

LOCATION_DATABASE

DETAIL_DAY_OF_WEEK_NUMBER

Size: 10

01=Location

LOCATION

*LOCATION_NO

Size: 4

01=Location

LOCATION_DATABASE

LOCATION_NO

Size: 10

01=Location

LOCATION_DATABASE

NUMERIC_LOCATION_CODE

Size: 10

02=Name

LOCATION

LOCATION_NAME

Size: 50

02=Name

LOCATION_DATABASE

LOCATION_NAME

Size: 30

03=Status

LOCATION_DATABASE

STATUS

Size: 4

04=Type

LOCATION

LOCATION_TYPE

Size: 4

04=Type

LOCATION

LOCATION_TYPE_DESC

Detailed Explanation of code. Size: 30

04=Type

LOCATION_DATABASE

LOCATION_TYPE_CODE

Size: 4

04=Type

LOCATION_DATABASE

LOCATION_TYPE_DESCRIPTION

Detailed Explanation of code. Size: 30

05=Area

LOCATION

AREA

Size: 4

05=Area

LOCATION

AREA_CODE_DESC

Detailed Explanation of code. Size: 30

05=Area

LOCATION_DATABASE

AREA_CODE

Size: 4

05=Area

LOCATION_DATABASE

AREA_DESCRIPTION

Detailed Explanation of code. Size: 30

06=Telephone

LOCATION

PHONE_NO

Size: 13 Format: (###)###-####

06=Telephone

LOCATION_DATABASE

PHONE_NO

Size: 13 Format: (###)###-####

07=Fax Number

LOCATION

FAX_NUMBER

Size: 13 Format: (###)###-####

07=Fax Number

LOCATION_DATABASE

FAX_NO

Size: 10 Format: (###)###-####

08=Addr1

LOCATION

ADDRESS_01

Size: 30

08=Addr1

LOCATION_DATABASE

ADDRESS_01

Size: 30

09=Addr2

LOCATION

ADDRESS_02

Size: 30

09=Addr2

LOCATION_DATABASE

ADDRESS_02

Size: 30

10=Addr3

LOCATION

ADDRESS_03

Size: 30

10=Addr3

LOCATION_DATABASE

ADDRESS_03

Size: 30

11=Postal Code

LOCATION

POSTAL_CODE

Size: 10

11=Postal Code

LOCATION_DATABASE

POSTAL_CODE

Size: 10

12=Email Ad 1

LOCATION

EMAIL_ADDRESS_1

Size: 30

12=Email Ad 1

LOCATION_DATABASE

EMAIL

Size: 30

13=Email Ad 2

LOCATION

EMAIL_ADDRESS_2

Size: 50

13=Email Ad 2

LOCATION_DATABASE

EMAIL_ADDRESS_2

Size: 30

14=Email Ad 3

LOCATION

EMAIL_ADDRESS_3

Size: 50

14=Email Ad 3

LOCATION_DATABASE

EMAIL_ADDRESS_3

Size: 30

15=AM Start

LOCATION

AM_START_TIME

Size: 5

15=AM Start

LOCATION_DATABASE

AM_START_TIME

Size: 10

16=AM End

LOCATION

AM_END_TIME

Size: 5

16=AM End

LOCATION_DATABASE

AM_END_TIME

Size: 10

17=PM Start

LOCATION

PM_START_TIME

Size: 5

17=PM Start

LOCATION_DATABASE

PM_START_TIME

Size: 10

18=PM End

LOCATION

PM_END_TIME

Size: 5

18=PM End

LOCATION_DATABASE

PM_END_TIME

Size: 10

19=R1 Start

LOCATION

RECESS1_START_TIME

Size: 5

19=R1 Start

LOCATION_DATABASE

RECESS_1_START_TIME

Size: 10

20=R1 End

LOCATION

RECESS1_END_TIME

Size: 5

20=R1 End

LOCATION_DATABASE

RECESS_1_END_TIME

Size: 10

21=R2 Start

LOCATION

RECESS2_START_TIME

Size: 5

21=R2 Start

LOCATION_DATABASE

RECESS_2_START_TIME

Size: 10

22=R2 End

LOCATION

RECESS2_END_TIME

Size: 5

22=R2 End

LOCATION_DATABASE

RECESS_2_END_TIME

Size: 10

23=LU Start

LOCATION

LUNCH_START_TIME

Size: 5

23=LU Start

LOCATION_DATABASE

LUNCH_START_TIME

Size: 10

24=LU End

LOCATION

LUNCH_END_TIME

Size: 5

24=LU End

LOCATION_DATABASE

LUNCH_END_TIME

Size: 10

25=Abs AM FTE

LOCATION

ABS_AM_FTE

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

25=Abs AM FTE

LOCATION_DATABASE

ABS_AM_FTE

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

26=Abs PM FTE

LOCATION

ABS_PM_FTE

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

26=Abs PM FTE

LOCATION_DATABASE

ABS_PM_FTE

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

27=Rep AM FTE

LOCATION

REP_AM_FTE

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

27=Rep AM FTE

LOCATION_DATABASE

REP_AM_FTE

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

28=Rep PM FTE

LOCATION

REP_PM_FTE

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

28=Rep PM FTE

LOCATION_DATABASE

REP_PM_FTE

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

30=Clerk

LOCATION

CLERK

Size: 10

30=Clerk

LOCATION_DATABASE

CLERK

Size: 20

31=Principal

LOCATION

PRINCIPAL_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

31=Principal

LOCATION

PRINCIPAL_NAME

Size: 30

31=Principal

LOCATION_DATABASE

PRINCIPAL_NO

Size: 10

32=Block Control [A/B/C/D/P]

LOCATION_DATABASE

BLOCK_CONTROL_TYPE

Size: 10

33=Type

LOCATION_DATABASE

BLOCK_TYPE_01

Size: 10

34=Block

LOCATION_DATABASE

BLOCK_NO_01

Size: 10

35=Type

LOCATION_DATABASE

BLOCK_TYPE_02

Size: 10

36=Block

LOCATION_DATABASE

BLOCK_02

Size: 10

37=Type

LOCATION_DATABASE

BLOCK_TYPE_03

Size: 10

38=Block

LOCATION_DATABASE

BLOCK_03

Size: 10

39=Type

LOCATION_DATABASE

BLOCK_TYPE_04

Size: 10

40=Block

LOCATION_DATABASE

BLOCK_04

Size: 10

41=Type

LOCATION_DATABASE

BLOCK_TYPE_05

Size: 10

42=Block

LOCATION_DATABASE

BLOCK_05

Size: 10

01=Pay ID

LOCATION_DATABASE

*PAYROLL_ID_01

Size: 4

02=OCC Code

LOCATION_DATABASE

*OCC_CODE_01

Size: 4

03=Cost Center

LOCATION_DATABASE

*COST_CENTER_01

Size: 10

04=GL/SL Account

LOCATION_DATABASE

*GL_ACCT_NO_01

Size: 20

04=GL/SL Account

LOCATION_DATABASE

*SL_ACCT_NO_01

Size: 10

05=Pay ID

LOCATION_DATABASE

*PAYROLL_ID_02

Size: 4

06=OCC Code

LOCATION_DATABASE

*OCC_CODE_02

Size: 4

07=Cost Center

LOCATION_DATABASE

*COST_CENTER_02

Size: 10

08=GL/SL Account

LOCATION_DATABASE

*GL_ACCT_NO_02

Size: 20

08=GL/SL Account

LOCATION_DATABASE

*SL_ACCT_NO_02

Size: 10

09=Pay ID

LOCATION_DATABASE

*PAYROLL_ID_03

Size: 4

10=OCC Code

LOCATION_DATABASE

*OCC_CODE_03

Size: 4

11=Cost Center

LOCATION_DATABASE

*COST_CENTER_03

Size: 10

12=GL/SL Account

LOCATION_DATABASE

*GL_ACCT_NO_03

Size: 20

12=GL/SL Account

LOCATION_DATABASE

*SL_ACCT_NO_03

Size: 10

13=Pay ID

LOCATION_DATABASE

*PAYROLL_ID_04

Size: 4

14=OCC Code

LOCATION_DATABASE

*OCC_CODE_04

Size: 4

15=Cost Center

LOCATION_DATABASE

*COST_CENTER_04

Size: 10

16=GL/SL Account

LOCATION_DATABASE

*GL_ACCT_NO_04

Size: 20

16=GL/SL Account

LOCATION_DATABASE

*SL_ACCT_NO_04

Size: 10

17=Pay ID

LOCATION_DATABASE

*PAYROLL_ID_05

Size: 4

18=OCC Code

LOCATION_DATABASE

*OCC_CODE_05

Size: 4

19=Cost Center

LOCATION_DATABASE

*COST_CENTER_05

Size: 10

20=GL/SL Account

LOCATION_DATABASE

*GL_ACCT_NO_05

Size: 20

20=GL/SL Account

LOCATION_DATABASE

*SL_ACCT_NO_05

Size: 10

21=Pay ID

LOCATION_DATABASE

*PAYROLL_ID_06

Size: 4

22=OCC Code

LOCATION_DATABASE

*OCC_CODE_06

Size: 4

23=Cost Center

LOCATION_DATABASE

*COST_CENTER_06

Size: 10

24=GL/SL Account

LOCATION_DATABASE

*GL_ACCT_NO_06

Size: 20

24=GL/SL Account

LOCATION_DATABASE

*SL_ACCT_NO_06

Size: 10

25=Pay ID

LOCATION_DATABASE

*PAYROLL_ID_07

Size: 4

26=OCC Code

LOCATION_DATABASE

*OCC_CODE_07

Size: 4

27=Cost Center

LOCATION_DATABASE

*COST_CENTER_07

Size: 10

28=GL/SL Account

LOCATION_DATABASE

*GL_ACCT_NO_07

Size: 20

28=GL/SL Account

LOCATION_DATABASE

*SL_ACCT_NO_07

Size: 10

29=Pay ID

LOCATION_DATABASE

*PAYROLL_ID_08

Size: 4

30=OCC Code

LOCATION_DATABASE

*OCC_CODE_08

Size: 4

31=Cost Center

LOCATION_DATABASE

*COST_CENTER_08

Size: 10

32=GL/SL Account

LOCATION_DATABASE

*GL_ACCT_NO_08

Size: 20

32=GL/SL Account

LOCATION_DATABASE

*SL_ACCT_NO_08

Size: 10

33=Pay ID

LOCATION_DATABASE

*PAYROLL_ID_09

Size: 4

34=OCC Code

LOCATION_DATABASE

*OCC_CODE_09

Size: 4

35=Cost Center

LOCATION_DATABASE

*COST_CENTER_09

Size: 10

36=GL/SL Account

LOCATION_DATABASE

*GL_ACCT_NO_09

Size: 20

36=GL/SL Account

LOCATION_DATABASE

*SL_ACCT_NO_09

Size: 10

37=Pay ID

LOCATION_DATABASE

*PAYROLL_ID_10

Size: 4

38=OCC Code

LOCATION_DATABASE

*OCC_CODE_10

Size: 4

39=Cost Center

LOCATION_DATABASE

*COST_CENTER_10

Size: 10

40=GL/SL Account

LOCATION_DATABASE

*GL_ACCT_NO_10

Size: 20

40=GL/SL Account

LOCATION_DATABASE

*SL_ACCT_NO_10

Size: 10

41=Pay ID

LOCATION_DATABASE

*PAYROLL_ID_11

Size: 4

42=OCC Code

LOCATION_DATABASE

*OCC_CODE_11

Size: 4

43=Cost Center

LOCATION_DATABASE

*COST_CENTER_11

Size: 10

44=GL/SL Account

LOCATION_DATABASE

*GL_ACCT_NO_11

Size: 20

44=GL/SL Account

LOCATION_DATABASE

*SL_ACCT_NO_11

Size: 10

45=Pay ID

LOCATION_DATABASE

*PAYROLL_ID_12

Size: 4

46=OCC Code

LOCATION_DATABASE

*OCC_CODE_12

Size: 4

47=Cost Center

LOCATION_DATABASE

*COST_CENTER_12

Size: 10

48=GL/SL Account

LOCATION_DATABASE

*GL_ACCT_NO_12

Size: 20

48=GL/SL Account

LOCATION_DATABASE

*SL_ACCT_NO_12

Size: 10

49=Pay ID

LOCATION_DATABASE

*PAYROLL_ID_13

Size: 4

50=OCC Code

LOCATION_DATABASE

*OCC_CODE_13

Size: 4

51=Cost Center

LOCATION_DATABASE

*COST_CENTER_13

Size: 10

52=GL/SL Account

LOCATION_DATABASE

*GL_ACCT_NO_13

Size: 20

52=GL/SL Account

LOCATION_DATABASE

*SL_ACCT_NO_13

Size: 10

53=Pay ID

LOCATION_DATABASE

*PAYROLL_ID_14

Size: 4

54=OCC Code

LOCATION_DATABASE

*OCC_CODE_14

Size: 4

55=Cost Center

LOCATION_DATABASE

*COST_CENTER_14

Size: 10

56=GL/SL Account

LOCATION_DATABASE

*GL_ACCT_NO_14

Size: 20

56=GL/SL Account

LOCATION_DATABASE

*SL_ACCT_NO_14

Size: 10

57=Pay ID

LOCATION_DATABASE

*PAYROLL_ID_15

Size: 4

58=OCC Code

LOCATION_DATABASE

*OCC_CODE_15

Size: 4

59=Cost Center

LOCATION_DATABASE

*COST_CENTER_15

Size: 10

60=GL/SL Account

LOCATION_DATABASE

*GL_ACCT_NO_15

Size: 20

60=GL/SL Account

LOCATION_DATABASE

*SL_ACCT_NO_15

Size: 10

Unknown

LOCATION_DATABASE

PAYROLL_INFO

Size: 50

01=Position Code

POSITION

NUMERIC_POSITION_CODE

Size: 8

01=Position Code

POSITION_DATABASE

NUMERIC_POSITION_CODE

Size: 8

04=Sup Position Code

POSITION

SUPERVISOR_POSITION

Size: 8

04=Sup Position Code

POSITION_DATABASE

SUPERVISOR_POSITION

Size: 8

04=Sup Position Code

POSITION_DATABASE

SUPERVISOR_POSITION_DESCRIPTIO

Detailed Explanation of code. Size: 30

05=Rep Position Code

POSITION

REPLACEMENT_POSITION

Size: 10

05=Rep Position Code

POSITION_DATABASE

REPLACEMENT_POSITION

Size: 10

05=Rep Position Code

POSITION_DATABASE

REPLACEMENT_POSITION_DESCRIPTI

Detailed Explanation of code. Size: 30

06=Works Pro-D

POSITION

PRO_DEVELOPMENT

Internal Lookup: Y=YES, N=NO, =BLANK, Size: 4

06=Works Pro-D

POSITION_DATABASE

PRO_DEVELOPMENT

Internal Lookup: Y=YES, N=NO, =BLANK, Size: 4

07=Works Sat/Sun [Y/N]

POSITION

WORKS_SATURDAY

Internal Lookup: Y=YES, N=NO, =BLANK, Size: 3

07=Works Sat/Sun [Y/N]

POSITION_DATABASE

WORKS_SATURDAY

Internal Lookup: Y=YES, N=NO, =BLANK, Size: 3

08=Works Teach [Y/N]

POSITION_DATABASE

WORKS_ON_TEACH_DAYS

Internal Lookup: Y=YES, N=NO, =BLANK, Size: 5

10 Hours/FTE [H/F]

POSITION

HOURS_OR_FTE

Internal Lookup: H=HOURS, F=FTE, Size: 3

10 Hours/FTE [H/F]

POSITION_DATABASE

HOURS_OR_FTE

Internal Lookup: H=HOURS, F=FTE, Size: 3

11-Total Hours / FTE

POSITION

TOTAL_TIME

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

11-Total Hours / FTE

POSITION_DATABASE

TOTAL_TIME

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

11=Total Hours/FTE

POSITION

HOURS_BEFORE_OVERTIME

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

11=Total Hours/FTE

POSITION_DATABASE

HOURS_BEFORE_OVERTIME

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

12=Hours Per Day

POSITION

HOURS_PER_DAY

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

12=Hours Per Day

POSITION_DATABASE

HOURS_PER_DAY

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

13=Hours Per Week

POSITION

HOURS_PER_WEEK

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

13=Hours Per Week

POSITION_DATABASE

HOURS_PER_WEEK

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

14=Creation Date

POSITION

CREATION_DATE

Size: 11 Format: DD-MMM-YYYY

14=Creation Date

POSITION_DATABASE

CREATION_DATE

Size: 11 Format: DD-MMM-YYYY

15=Expiry Date

POSITION

EXPIRY_DATE

Size: 11 Format: DD-MMM-YYYY

15=Expiry Date

POSITION_DATABASE

EXPIRY_DATE

Size: 11 Format: DD-MMM-YYYY

17=School Term [Y/N]

POSITION

SCHOOL_TERM

Internal Lookup: Y=YES, N=NO, =BLANK, Size: 3

17=School Term [Y/N]

POSITION_DATABASE

SCHOOL_TERM

Internal Lookup: Y=YES, N=NO, =BLANK, Size: 3

18=Sub/Cas [S/C/N]

POSITION

SUB_OR_CASUAL

Internal Lookup: S=SUBSTITUTE TEACHER, C=CASUAL EMPLOYEE, N=NEITHER, =BLANK, Size: 3

18=Sub/Cas [S/C/N]

POSITION_DATABASE

SUB_OR_CASUAL

Internal Lookup: S=SUBSTITUTE TEACHER, C=CASUAL EMPLOYEE, N=NEITHER, =BLANK, Size: 3

19=Emp Category

POSITION

CATEGORY

Size: 4

19=Emp Category

POSITION_DATABASE

CATEGORY_CODE

Size: 4

19=Emp Category

POSITION_DATABASE

CATEGORY_DESC

Detailed Explanation of code. Size: 30

20=Bargaining Unit

POSITION

BARGAINING_UNIT

Size: 8

20=Bargaining Unit

POSITION_DATABASE

BARGAINING_UNIT

Size: 8

20=Bargaining Unit

POSITION_DATABASE

BARGAINING_UNIT_DESCRIPTION

Detailed Explanation of code. Size: 30

21=Department

POSITION

DEPARTMENT

Size: 4

21=Department

POSITION_DATABASE

DEPARTMENT_CODE

Size: 4

21=Department

POSITION_DATABASE

DEPARTMENT_DESC

Detailed Explanation of code. Size: 30

22=User Def Field 1

POSITION

USER_DEFINED_FIELD_01

Size: 10

22=User Def Field 1

POSITION_DATABASE

USER_DEFINED_FIELD_01

Size: 10

22=User Def Field 1

POSITION_DATABASE

USER_DEFINED_FIELD_01_DESC

Detailed Explanation of code. Size: 30

23=User Def Field 2

POSITION

USER_DEFINED_FIELD_02

Size: 10

23=User Def Field 2

POSITION_DATABASE

USER_DEFINED_FIELD_02

Size: 10

23=User Def Field 2

POSITION_DATABASE

USER_DEFINED_FIELD_02

Detailed Explanation of code. Size: 30

24=User Def Field 3

POSITION

USER_DEFINED_FIELD_03

Size: 10

24=User Def Field 3

POSITION_DATABASE

USER_DEFINED_FIELD_03

Size: 10

24=User Def Field 3

POSITION_DATABASE

USER_DEFINED_FIELD_03_DESC

Detailed Explanation of code. Size: 30

25=User Def Field 4

POSITION

USER_DEFINED_FIELD_04

Size: 10

25=User Def Field 4

POSITION_DATABASE

USER_DEFINED_FIELD_04

Size: 10

25=User Def Field 4

POSITION_DATABASE

USER_DEFINED_FIELD_04_DESC

Detailed Explanation of code. Size: 10

26=Benefits [Y/N]

POSITION

BENEFITS

Internal Lookup: Y=YES, N=NO, =BLANK, Size: 3

26=Benefits [Y/N]

POSITION_DATABASE

BENEFITS

Internal Lookup: Y=YES, N=NO, =BLANK, Size: 3

27=Min Ben Hours

POSITION

MINIMUM_BENEFIT_HOURS

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

27=Min Ben Hours

POSITION_DATABASE

MINIMUM_BENEFIT_HOURS

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

28=Payroll ID

POSITION

PAYROLL_ID

Size: 4

28=Payroll ID

POSITION_DATABASE

PAYROLL_ID

Size: 4

28=Payroll ID

POSITION_DATABASE

PAYROLL_ID_DESC

Detailed Explanation of code. Size: 30

30=UseLocType Superv

POSITION

USE_LOC_TYPE_POSITION_YN

Size: 10

30=UseLocType Superv

POSITION_DATABASE

USE_LOC_TYPE_POSITION_YN

Size: 10

31=Comment

POSITION

MAIN_COMMENT

Size: 80

31=Comment

POSITION_DATABASE

MAIN_COMMENT

Size: 80

32=FTE Code

POSITION

FTE_CODE

Size: 10

32=FTE Code

POSITION_DATABASE

FTE_CODE

Size: 10

33=Lunch Start

POSITION

LUNCH_START_TIME

Size: 5

33=Lunch Start

POSITION_DATABASE

LUNCH_START_TIME

Size: 5

34=Lunch End

POSITION

LUNCH_END_TIME

Size: 10

34=Lunch End

POSITION_DATABASE

LUNCH_END_TIME

Size: 10

35=Calendar

POSITION

CALENDAR_CODE

Size: 10

35=Calendar

POSITION

SCHEDULE_NUMBER

Size: 10

35=Calendar

POSITION_DATABASE

CALENDAR_CODE

Size: 10

35=Calendar

POSITION_DATABASE

SCHEDULE_NUMBER

Size: 10

36=MANTE

POSITION

MANTE_GROUP

Size: 10

36=MANTE

POSITION_DATABASE

MANGE_GROUP_DESCRIPTION

Detailed Explanation of code. Size: 30

36=MANTE

POSITION_DATABASE

MANTE_GROUP_CODE

Size: 10

37=Role

POSITION

ROLE_CODE

Size: 10

37=Role

POSITION_DATABASE

ROLE_CODE

Size: 10

37=Role

POSITION_DATABASE

ROLE_DESCRIPTION

Detailed Explanation of code. Size: 30

38=Authorizer

POSITION

AUTHORIZER

Size: 10

38=Authorizer

POSITION_DATABASE

AUTHORIZER

Size: 10

39=Auth Loc

POSITION

AUTHORIZER_LOCATION

Size: 10

39=Auth Loc

POSITION_DATABASE

AUTHORIZER_LOCATION

Size: 10

01=Position Code

POSITION_DATABASE

POSITION_CODE

Size: 10

01=Start Grid

POSITION

SALARY_GRID_01

Size: 6

01=Start Grid

POSITION_DATABASE

SALARY_GRID_01

Size: 6

02=Desc

POSITION

POSITION_DESCRIPTION

Detailed Explanation of code. Size: 30

02=Desc

POSITION_DATABASE

POSITION_DESCRIPTION

Detailed Explanation of code. Size: 30

02=End Grid

POSITION

SALARY_GRID_02

Size: 6

02=End Grid

POSITION_DATABASE

SALARY_GRID_02

Size: 6

03=Cycle Code

POSITION

CYCLE_CODE

Size: 2

03=Cycle Code

POSITION_DATABASE

CYCLE_CODE

Size: 2

03=Position Type

POSITION

POSITION_TYPE

Size: 4

03=Position Type

POSITION_DATABASE

POSITION_TYPE

Size: 4

03=Position Type

POSITION_DATABASE

POSITION_TYPE_DESCRIPTION

Detailed Explanation of code. Size: 30

04=Pay Type

POSITION

PAY_TYPE

Size: 2

04=Pay Type

POSITION_DATABASE

PAY_TYPE

Size: 2

05=Pay Code

POSITION

PAY_CODE

Size: 2

05=Pay Code

POSITION_DATABASE

PAY_CODE

Size: 2

06=Pay Rate

POSITION

PAY_RATE

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

06=Pay Rate

POSITION_DATABASE

PAY_RATE

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

07=Base Hours

POSITION

BASE_HOURS

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

07=Base Hours

POSITION_DATABASE

BASE_HOURS

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

08=Occupation Code

POSITION

OCCUPATION_CODE

Size: 3

08=Occupation Code

POSITION_DATABASE

OCCUPATION_CODE

Size: 3

09=Employee Type

POSITION

EMPLOYEE_TYPE

Size: 2

09=Employee Type

POSITION_DATABASE

EMPLOYEE_TYPE

Size: 2

10=Shift Code

POSITION

SHIFT_CODE

Size: 2

10=Shift Code

POSITION_DATABASE

SHIFT_CODE

Size: 2

11=Cost Center

POSITION

COST_CENTER

Size: 10

11=Cost Center

POSITION_DATABASE

COST_CENTER

Size: 10

12=GL Account

POSITION

GL_ACCT_NO

Size: 20

12=GL Account

POSITION_DATABASE

GL_ACCT_NO

Size: 20

14=Overtime Pay Code

POSITION

OVERTIME_PAYCODE

Size: 4

14=Overtime Pay Code

POSITION_DATABASE

OVERTIME_PAYCODE

Size: 4

16=Pay Rate

POSITION

HOURLY_RATE

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

16=Pay Rate

POSITION_DATABASE

HOURLY_RATE

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

Field in atrieveERP

Report Writer Table

Report Writer Field

Field Information

01-Comment 1

POSITION

DESCRIPTION_01

Size: 100

01-Comment 1

POSITION_DATABASE

DESCRIPTION_01

Size: 100

02=Comment 2

POSITION

DESCRIPTION_02

Size: 100

02=Comment 2

POSITION_DATABASE

DESCRIPTION_02

Size: 100

Field in atrieveERP

Report Writer Table

Report Writer Field

Field Information

01=Absence Code

ABSENCE_CODE_DATABASE

ABSENCE_CODE

Size: 10

01=Absence Code

ABSENCE_CODE_DATABASE

NUMERIC_ABSENCE_CODE

Size: 4 Format: ###########

02=Description

ABSENCE_CODE_DATABASE

DESCRIPTION

Detailed Explanation of code. Size: 30

03=Key Type [b/c/p]

ABSENCE_CODE_DATABASE

KEY_TYPE_B_C_P

Internal Lookup: B=BARGAINING UNIT, C=CATEGORY, P=POSITION, Size: 2

04=Absence Key

ABSENCE_CODE_DATABASE

ABSENCE_KEY

Size: 10

05=Status

ABSENCE_CODE_DATABASE

STATUS

Internal Lookup: =ACTIVE, S=SOFT DELETED, Size: 2

06=Type [A/S/L/V]

ABSENCE_CODE_DATABASE

TYPE_A_S_L_V

Internal Lookup: A=ABSENCE, S=SHORT TERM LEAVE, L=LONG TERM LEAVE, V=VACATION, Size: 4

07=Cat List

ABSENCE_CODE_DATABASE

CATEGORY_LIST

Size: 15

08=Leave Rule

ABSENCE_CODE_DATABASE

LEAVE_RULE

Size: 10

09=Paid Leave [Y/N]

ABSENCE_CODE_DATABASE

PAID_Y_N

Internal Lookup: Y=PAID, N=UNPAID, Size: 4

10=Source [P/O/N]

ABSENCE_CODE_DATABASE

SOURCE_P_O_N

Internal Lookup: P=PRM ENTITLEMENTS, O=OPS STORAGE BANKS, N=NEITHER, Size: 3

11=Approval [Y/N/X]

ABSENCE_CODE_DATABASE

NEEDS_APPROVAL_Y_N_X

Internal Lookup: Y=YES, LEAVE APPROVAL REQUIRED, N=NO LEAVE APPROVAL REQUIRED, X=YES, LEAVE APPROVAL MUST BE GIVEN, Size: 4

12=Interface [Y/B/D/N]

ABSENCE_CODE_DATABASE

INTERFACE_Y_B_D_N

Internal Lookup: Y=YES, USE TIMESHEET ENTRY INTERFACE, B=YES, USE STORAGE BANK BALANCE CHANGE INTERFACE, D=YES, USE DETAILED STORAGE BANK INTERFACE, N=NO, DO NOT INTERFACE, Size: 4

13=Medical Note [Y/N]

ABSENCE_CODE_DATABASE

MEDICAL_NOTE_Y_N

Internal Lookup: Y=YES, N=NO, Size: 3

15=Dispatch Priority

ABSENCE_CODE_DATABASE

DISPATCH_PRIORITY

Size: 3

16=Absences Per Day

ABSENCE_CODE_DATABASE

ABS_PER_DAY

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

Field in atrieveERP

Report Writer Table

Report Writer Field

Field Information

Will report on assignment(s) with the continuing type based information in the Assignment Type Code Database (Field 5 10,1,3,10)

ASSIGNMENTS

CONT_ASSIGNMENT_YN

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

Will report on assignment(s) with the leave type based information in the Assignment Type Code Database (Field 4 10,1,3,10)

ASSIGNMENTS

LEAVE_YN

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

Field in atrieveERP

Report Writer Table

Report Writer Field

Field Information

Form Info 1

E-FORM FIELDS

*FORM_INFO

Size: 500

Form Info 2

E-FORM FIELDS

*FORM_INFO_2

Size: 500

Form Info 3

E-FORM FIELDS

*FORM_INFO_3

Size: 500

01=ADW Activation Mode

LMW_LEAVE_CODE

ADW_ACTIVATION_MODE

Internal Lookup: 1=Don't Activate For Anyone, 2=Only Activate For Designated Testers, 3=Activate For Everyone, Size: 10

02=Applicant Section

LMW_LEAVE_CODE

APPLICANT_SECTION_ID

Size: 11

02=Application Section

LMW_LEAVE_CODE

APPLICANT_SECTION_NAME

Detailed Explanation of code. Size: 30

03=Cancellation Section

LMW_LEAVE_CODE

CANCELLATION_SECTION_ID

Size: 15

03=Cancellation Section

LMW_LEAVE_CODE

CANCELLATION_SECTION_NAME

Detailed Explanation of code. Size: 30

04=Contract Reference Number

LMW_LEAVE_CODE

CONTRACT_REF_NUMBER

Size: 20

05=Routing Code

LMW_LEAVE_CODE

ROUTING_CODE

Size: 10

05=Routing Desc

LMW_LEAVE_CODE

ROUTING_DESC

Detailed Explanation of code. Size: 30

06=Cacellation Routing Code

LMW_LEAVE_CODE

CANCEL_ROUTE_CODE

Size: 10

06=Cacellation Routing Desc

LMW_LEAVE_CODE

CANCEL_ROUTE_DESC

Detailed Explanation of code. Size: 30

07=ADW Cancel Action Code

LMW_LEAVE_CODE

CANCEL_ACTION_CODE

Size: 10

07=ADW Cancel Action Desc

LMW_LEAVE_CODE

CANCEL_ACTION_DESC

Detailed Explanation of code. Size: 30

08=Required Document Code 1

LMW_LEAVE_CODE

REQUIRED_DOC_CODE_1

Size: 10

08=Required Document Code 1

LMW_LEAVE_CODE

REQUIRED_DOC_DESC_1

Detailed Explanation of code. Size: 30

09=Required Document Code 2

LMW_LEAVE_CODE

REQUIRED_DOC_CODE_2

Size: 10

09=Required Document Code 2

LMW_LEAVE_CODE

REQUIRED_DOC_DESC_2

Detailed Explanation of code. Size: 30

10=Required Document Code 3

LMW_LEAVE_CODE

REQUIRED_DOC_CODE_3

Size: 10

10=Required Document Code 3

LMW_LEAVE_CODE

REQUIRED_DOC_DESC_3

Detailed Explanation of code. Size: 30

11=Required Document Code 4

LMW_LEAVE_CODE

REQUIRED_DOC_CODE_4

Size: 10

11=Required Document Code 4

LMW_LEAVE_CODE

REQUIRED_DOC_DESC_4

Detailed Explanation of code. Size: 30

12=Required Document Code 5

LMW_LEAVE_CODE

REQUIRED_DOC_CODE_5

Size: 10

12=Required Document Code 5

LMW_LEAVE_CODE

REQUIRED_DOC_DESC_5

Detailed Explanation of code. Size: 30

13=Budget Checking Policy

LMW_LEAVE_CODE

BUDGET_CHECKING_POLICY

Internal Lookup: 1=Do Not Check Budget, 2=Check Budget and Warn, 3=Check Budget and Block, Size: 10

13=Budget Checking Policy

LMW_LEAVE_CODE

BUDGET_CHECKING_POLICY_DESC

Internal Lookup: Do Not Check Budget=1, Check Budget and Warn=2, Check Budget and Block=3, Size: 30

14=Bypass Schedules in Adw Absence Entry

LMW_LEAVE_CODE

BYPASS_SCHEDULES

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

15=Create Absences in Adw Absence Entry [Y/N]

LMW_LEAVE_CODE

CREATE_ABSENCES

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

Dispatch Categories

LMW_LEAVE_CODE

ADS_CATEGORIES

Size: 20

Key Info

LMW_LEAVE_CODE

LEAVE_KEY_CODE

Size: 10

Key Info

LMW_LEAVE_CODE

LEAVE_KEY_TYPE

Size: 10

Leave Code

LMW_LEAVE_CODE

*LEAVE_DATA

Size: 50

Leave Code

LMW_LEAVE_CODE

LEAVE_CODE

Size: 10

Leave Code Description

LMW_LEAVE_CODE

LEAVE_CODE_DESC

Detailed Explanation of code. Size: 30

16=Default Leave Cost Rule Code

LMW_LEAVE_CODE

DEFAULT_LEAVE_COST_RULE

Size: 10

16=Default Leave Cost Rule Desc

LMW_LEAVE_CODE

DEFAULT_LEAVE_COST_RULE_DESC

Detailed Explanation of code. Size: 30

17=Leave Cost Rule Code 01

LMW_LEAVE_CODE

COST_RULE_CODE_01

Size: 10

18=Leave Cost Rule Code 02

LMW_LEAVE_CODE

COST_RULE_CODE_02

Size: 10

19=Leave Cost Rule Code 03

LMW_LEAVE_CODE

COST_RULE_CODE_03

Size: 10

20=Leave Cost Rule Code 04

LMW_LEAVE_CODE

COST_RULE_CODE_04

Size: 10

21=Leave Cost Rule Code 21

LMW_LEAVE_CODE

COST_RULE_CODE_05

Size: 10

22=Leave Cost Rule Code 06

LMW_LEAVE_CODE

COST_RULE_CODE_06

Size: 10

23=Leave Cost Rule Code 07

LMW_LEAVE_CODE

COST_RULE_CODE_07

Size: 10

24=Leave Cost Rule Code 08

LMW_LEAVE_CODE

COST_RULE_CODE_08

Size: 10

25=Leave Cost Rule Code 09

LMW_LEAVE_CODE

COST_RULE_CODE_09

Size: 10

26=Leave Cost Rule Code 10

LMW_LEAVE_CODE

COST_RULE_CODE_10

Size: 10

27=Hyperlink Url to Web Site

LMW_LEAVE_CODE

HYPERLINK_TO_WEB_SITE

Size: 30

29=Event Type Code

LMW_LEAVE_CODE

EVENT_TYPE_CODE

Size: 10

29=Event Type Desc

LMW_LEAVE_CODE

EVENT_TYPE_DESC

Detailed Explanation of code. Size: 30

30=Entitlement Policy [1-4]

LMW_LEAVE_CODE

ENTITLEMENT_POLICY

Internal Lookup: 1=PRM Entitlements, 2=OPS Storage Banks, 3=Year Limit, 4=Event Limit, Size: 10

30=Entitlement Policy [1-4]

LMW_LEAVE_CODE

ENTITLEMENT_POLICY_DESC

Internal Lookup: PRM Entitlements=1, OPS Storage Banks=2, Year Limit=3, Event Limit=4, Size: 30

31=Entitlement Unity Type [D/N]

LMW_LEAVE_CODE

ENTITLEMENT_UNIT_TYPE

Internal Lookup: D=Days, H=Hours, Size: 10

32=Entitlement Amount

LMW_LEAVE_CODE

ENTITLEMENT_AMOUNT

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

33=Entitlement Month & Day [MMDD]

LMW_LEAVE_CODE

ENTITLEMENT_MONTH_DAY

Size: 15

34=Entitlement Warn Or Block [W/B]

LMW_LEAVE_CODE

ENTITLEMENT_WARN_OR_BLOCK

Internal Lookup: W=Warn Only, B=Block Applicant From Continuing With Entry, Size: 10

35=Message To Applicant if Entitlement Exceeded

LMW_LEAVE_CODE

ENTITLEMENT_MESSAGE

Size: 30

36=Detailed Description

LMW_LEAVE_CODE

DETAILED_DESCRIPTION

Size: 30

37=Special Messages to Applicant

LMW_LEAVE_CODE

SPECIAL_MESSAGES

Size: 30

Field in atrieveERP

Report Writer Table

Report Writer Field

Field Information

01=Routing Authorizer Code

TASK_AUTHORIZER_CODE

AUTHORIZER_CODE

Size: 20

01=Routing Authorizer Code

TASK_AUTHORIZER_CODE

AUTHORIZER_DESC

Detailed Explanation of code. Size: 30

03=Status [A/I]

TASK_AUTHORIZER_CODE

STATUS

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

04=Type [R/C/A/M]

TASK_AUTHORIZER_CODE

TYPE

Internal Lookup: R=Routing Authorizer, C=Account Coordinator, A=Applicant, M=Manual Intervention, Size: 6

05=GL Criteria Code

TASK_AUTHORIZER_CODE

GL_CRITERIA_CODE

Size: 10

06=Employee Category List

TASK_AUTHORIZER_CODE

EMPLOYEE_CATEGORY_LIST

Size: 50

07=Emp No Calc Method

TASK_AUTHORIZER_CODE

CALCULATION_METHOD

Internal Lookup: 01=Specify Employee No Directly, 02=Supervisor Position(s), 03=Form Specified Account Coordinator, 04=Form Specified Location Supervisor, 05=Assistant Supervisor Position, 06=Specified Position, 07=Location Authorizer, 08=Original C Size: 10

08=Employee

TASK_AUTHORIZER_CODE

CALCULATION_INFO

Size: 50

Internal Field Name

FORM_PRE_DEFINED_SECTION

FIELD_NAME

Detailed Explanation of code. Size: 30

Areas where this field is used

FORM_USER_DEFINED_FIELD

SECTIONS_THAT_USE_THIS_FIELD

Size: 80

Internal Field Name

FORM_USER_DEFINED_SECTION

FIELD_NAME

Detailed Explanation of code. Size: 30

Will report on the Assigned FTE if the profile is configured to display FTE for hourly employees (Assignment Screen Profile10,2,11,2)

ASSIGNMENTS

TEMPORARY_FTE

Size: 7 Format: ######.####