Table Definitions - Setup Or Maintenance

Field in atrieveERP	Report Writer Table	Report Writer Field	Field Information
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

Field in atrieveERP	Report Writer Table	Report Writer Field	Field Information
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

Field in atrieveERP	Report Writer Table	Report Writer Field	Field Information
Unused	LOCATION	*MUSEQ	Size: 4

Field in atrieveERP	Report Writer Table	Report Writer Field	Field Information
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

Field in atrieveERP	Report Writer Table	Report Writer Field	Field Information
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

Field in atrieveERP	Report Writer Table	Report Writer Field	Field Information
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

Field in atrieveERP	Report Writer Table	Report Writer Field	Field Information
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

Field in atrieveERP	Report Writer Table	Report Writer Field	Field Information
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

Field in atrieveERP	Report Writer Table	Report Writer Field	Field Information
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
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
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
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
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

Field in atrieveERP	Report Writer Table	Report Writer Field	Field Information
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

Field in atrieveERP	Report Writer Table	Report Writer Field	Field Information
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

Field in atrieveERP	Report Writer Table	Report Writer Field	Field Information
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

Field in atrieveERP	Report Writer Table	Report Writer Field	Field Information
36=Detailed Description	LMW_LEAVE_CODE	DETAILED_DESCRIPTION	Size: 30

Field in atrieveERP	Report Writer Table	Report Writer Field	Field Information
37=Special Messages to Applicant	LMW_LEAVE_CODE	SPECIAL_MESSAGES	Size: 30

Field in atrieveERP	Report Writer Table	Report Writer Field	Field Information
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

Field in atrieveERP	Report Writer Table	Report Writer Field	Field Information
Internal Field Name	FORM_PRE_DEFINED_SECTION	FIELD_NAME	Detailed Explanation of code. Size: 30

Field in atrieveERP	Report Writer Table	Report Writer Field	Field Information
Areas where this field is used	FORM_USER_DEFINED_FIELD	SECTIONS_THAT_USE_THIS_FIELD	Size: 80

Field in atrieveERP	Report Writer Table	Report Writer Field	Field Information
Internal Field Name	FORM_USER_DEFINED_SECTION	FIELD_NAME	Detailed Explanation of code. Size: 30

Field in atrieveERP	Report Writer Table	Report Writer Field	Field Information
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: ######.####