Assignment Tracking
|
Field in atrieveERP |
Report Writer Table |
Report Writer Field |
Field Information |
|---|---|---|---|
|
Records for a single date selection will be reported |
ASSIGNMENTS |
ASOF_DATE_SELECTION |
Size: 11 Format: DD-MMM-YYYY |
|
Records that are greater or equal to the start date value and less than or equal to the end date value will be reported. |
ASSIGNMENTS |
ASOF_DATE_RANGE_SELECTION |
Size: 11 Format: DD-MMM-YYYY |
Assignment Salary Screen
|
Field in atrieveERP |
Report Writer Table |
Report Writer Field |
Field Information |
|---|---|---|---|
|
01=Start Date |
ASSIGNMENTS |
SALARY_START_DATE |
Size: 11 Format: DD-MMM-YYYY |
|
03=Salary Grid |
ASSIGNMENTS |
SALARY_GRID_CODE |
Size: 6 |
|
04=Base Salary |
ASSIGNMENTS |
BASE_SALARY |
Size: 10 Format: ########.## |
|
04=Base Salary |
ASSIGNMENTS |
SALARY_OR_RATE |
Size: 10 Format: ########.## |
|
06=Salary Amounts |
ASSIGNMENTS |
SALARY_AMT_01 |
Size: 10 Format: ########.## |
|
08=Salary Amounts |
ASSIGNMENTS |
SALARY_AMT_02 |
Size: 10 Format: ########.## |
|
10=Salary Amounts |
ASSIGNMENTS |
SALARY_AMT_03 |
Size: 10 Format: ########.## |
|
12=Salary Amounts |
ASSIGNMENTS |
SALARY_AMT_04 |
Size: 10 Format: ########.## |
Assignment Comments
|
Field in atrieveERP |
Report Writer Table |
Report Writer Field |
Field Information |
|---|---|---|---|
|
01=Long Comment |
ASSIGNMENTS |
COMMENT |
Size: 70 |
|
01=Long Comment |
ASSIGNMENTS |
COMMENT_1 |
Size: 300 |
|
02=Comment 2 |
ASSIGNMENTS |
COMMENT_2 |
Size: 67 |
|
03=Comment 3 |
ASSIGNMENTS |
COMMENT 3 |
Size: 67 |
|
04=Comment 4 |
ASSIGNMENTS |
COMMENT_4 |
Size: 66 |
GL and Costing Info
|
Field in atrieveERP |
Report Writer Table |
Report Writer Field |
Field Information |
|---|---|---|---|
|
03=GL Alias (from Finance) |
ASSIGNMENTS |
ALIAS_SEGMENT_01 |
Size: 5 |
|
03=General Ledger |
ASSIGNMENTS |
GL_SEGMENT_01 |
Size: 5 |
|
03=General Ledger Description |
ASSIGNMENTS |
GL_SEGMENT_DESC_01 |
Detailed Explanation of code. Size: 20 |
|
07=General Ledger |
ASSIGNMENTS |
GL_SEGMENT_02 |
Size: 5 |
|
07=General Ledger Description |
ASSIGNMENTS |
GL_SEGMENT_DESC_02 |
Detailed Explanation of code. Size: 20 |
|
11=General Ledger |
ASSIGNMENTS |
GL_SEGMENT_03 |
Size: 5 |
|
11=General Ledger Description |
ASSIGNMENTS |
GL_SEGMENT_DESC_03 |
Detailed Explanation of code. Size: 20 |
|
15=General Ledger |
ASSIGNMENTS |
GL_SEGMENT_04 |
Size: 5 |
|
15=General Ledger Description |
ASSIGNMENTS |
GL_SEGMENT_DESC_04 |
Detailed Explanation of code. Size: 20 |
|
19=General Ledger |
ASSIGNMENTS |
GL_SEGMENT_05 |
Size: 5 |
|
19=General Ledger Description |
ASSIGNMENTS |
GL_SEGMENT_DESC_05 |
Detailed Explanation of code. Size: 20 |
|
23=General Ledger |
ASSIGNMENTS |
GL_SEGMENT_06 |
Size: 5 |
|
23=General Ledger Description |
ASSIGNMENTS |
GL_SEGMENT_DESC_06 |
Detailed Explanation of code. Size: 20 |
|
27=General Ledger |
ASSIGNMENTS |
GL_SEGMENT_07 |
Size: 5 |
|
27=General Ledger Description |
ASSIGNMENTS |
GL_SEGMENT_DESC_07 |
Detailed Explanation of code. Size: 20 |
|
31=General Ledger |
ASSIGNMENTS |
GL_SEGMENT_08 |
Size: 5 |
|
31=General Ledger Description |
ASSIGNMENTS |
GL_SEGMENT_DESC_08 |
Detailed Explanation of code. Size: 20 |
|
35=General Ledger |
ASSIGNMENTS |
GL_SEGMENT_09 |
Size: 5 |
|
35=General Ledger Description |
ASSIGNMENTS |
GL_SEGMENT_DESC_09 |
Detailed Explanation of code. Size: 20 |
|
39=General Ledger |
ASSIGNMENTS |
GL_SEGMENT_10 |
Size: 5 |
|
39=General Ledger Description |
ASSIGNMENTS |
GL_SEGMENT_DESC_10 |
Detailed Explanation of code. Size: 20 |
Location and Subject/Level
|
Field in atrieveERP |
Report Writer Table |
Report Writer Field |
Field Information |
|---|---|---|---|
|
Field in atrieveERP |
Report Writer Table |
Report Writer Field |
Field Information |
|
01=Location |
ASSIGNMENTS |
LOCATION_CODE |
Size: 4 |
|
01=Location |
ASSIGNMENTS |
LOCATION_NAME |
Detailed Explanation of code. Size: 30 |
|
02=End Date |
ASSIGNMENTS |
SALARY_END_DATE |
Size: 11 Format: DD-MMM-YYYY |
|
02=FTE |
ASSIGNMENTS |
LOCATION_FTE |
Size: 10 Format: ######.#### |
|
02=FTE |
ASSIGNMENTS |
LOCATION_HOURS_OR_FTE |
Size: 10 Format: ######.#### |
|
05=Salary Code |
ASSIGNMENTS |
SALARY_CODE_01 |
Size: 10 |
|
05=Salary Code |
ASSIGNMENTS |
SALARY_CODE_01_DESC |
Detailed Explanation of code. Size: 30 |
|
07=Salary Code |
ASSIGNMENTS |
SALARY_CODE_02 |
Size: 10 |
|
07=Salary Code |
ASSIGNMENTS |
SALARY_CODE_02_DESC |
Detailed Explanation of code. Size: 30 |
|
09=Salary Code |
ASSIGNMENTS |
SALARY_CODE_03 |
Size: 10 |
|
09=Salary Code |
ASSIGNMENTS |
SALARY_CODE_03_DESC |
Detailed Explanation of code. Size: 30 |
|
11=Salary Code |
ASSIGNMENTS |
SALARY_CODE_04 |
Size: 10 |
|
11=Salary Code |
ASSIGNMENTS |
SALARY_CODE_04_DESC |
Detailed Explanation of code. Size: 30 |
|
Levels (06,10,14,18,22) |
ASSIGNMENTS |
LAST_5_LEVEL_CODES |
Size: 50 |
|
Levels (06,10,14,18,22) |
ASSIGNMENTS |
LAST_5_LEVEL_DESCS |
Detailed Explanation of code. Size: 50 |
|
Levels (06,10,14,18,22) & FTE (07,11,15,19,23) |
ASSIGNMENTS |
LAST_5_LEVEL_CODES_&_FTE |
Size: 50 |
|
Levels (06,10,14,18,22) & FTE (07,11,15,19,23) |
ASSIGNMENTS |
LAST_5_LEVEL_DESCS_&_FTE |
Detailed Explanation of code. Size: 50 |
|
Levels (06,10,14,18,22,26,30,34,38,42) |
ASSIGNMENTS |
ALL_TEN_LEVEL_CODES |
Size: 50 |
|
Levels (06,10,14,18,22,26,30,34,38,42) |
ASSIGNMENTS |
ALL_TEN_LEVEL_DESCS |
Detailed Explanation of code. Size: 50 |
|
Salary codes to exclude from report |
ASSIGNMENTS |
SALARY_CODES_TO_EXCLUDE |
Size: 10 |
|
Subjects (05,09,13,17,21) |
ASSIGNMENTS |
LAST_5_SUBJECT_CODES |
Size: 50 |
|
Subjects (05,09,13,17,21) |
ASSIGNMENTS |
LAST_5_SUBJECT_DESCS |
Detailed Explanation of code. Size: 50 |
|
Subjects (05,09,13,17,21) & FTE (07,11,15,19) |
ASSIGNMENTS |
LAST_5_SUBJECT_CODES_&_FTE |
Size: 50 |
|
Subjects (05,09,13,17,21) & FTE (07,11,15,19) |
ASSIGNMENTS |
LAST_5_SUBJECT_DESCS_&_FTE |
Detailed Explanation of code. Size: 50 |
|
Subjects (05,09,13,17,21) & FTE (07,11,15,19) |
ASSIGNMENTS |
LAST_5_SUB_LEV_CODES_&_FTE |
Size: 50 |
Assignment - Position, Dates and Type
|
Field in atrieveERP |
Report Writer Table |
Report Writer Field |
Field Information |
|---|---|---|---|
|
02=Position |
ASSIGNMENTS |
POSITION_CODE |
Size: 8 |
|
02=Position |
ASSIGNMENTS |
POSITION_DESCRIPTION |
Detailed Explanation of code. Size: 30 |
|
02=Position |
SCHEDULE |
POSITION_CODE |
Size: 10 |
|
02=Position Description |
SCHEDULE |
POSITION_DESC |
Detailed Explanation of code. Size: 30 |
|
03=Start Date |
ASSIGNMENTS |
START_DATE |
Size: 11 Format: DD-MMM-YYYY |
|
04=End Date |
ASSIGNMENTS |
END_DATE |
Size: 11 Format: DD-MMM-YYYY |
|
05=Assignment Type |
ASSIGNMENTS |
ASSIGNMENT_TYPE |
Size: 5 |
|
05=Assignment Type |
ASSIGNMENTS |
ASSIGNMENT_TYPE_DESC |
Detailed Explanation of code. Size: 30 |
Assignment Hours or FTE, Pay and Reason
|
Field in atrieveERP |
Report Writer Table |
Report Writer Field |
Field Information |
|---|---|---|---|
|
10=Assigned Fte |
ASSIGNMENTS |
HOURS_OR_FTE_AMOUNT |
Size: 7 Format: ######.#### |
|
12=Fte Per Day |
ASSIGNMENTS |
HOURS_OR_FTE_PER_DAY |
Size: 11 Format: ######.#### |
|
13=Reason |
ASSIGNMENTS |
REASON |
Size: 10 |
|
13=Reason |
ASSIGNMENTS |
REASON_DESCRIPTION |
Detailed Explanation of code. Size: 30 |
Assignment – Miscellaneous
|
Field in atrieveERP |
Report Writer Table |
Report Writer Field |
Field Information |
|---|---|---|---|
|
14=Benefits [Y/N] |
ASSIGNMENTS |
BENEFITS_YN |
Internal Lookup: Y=YES, N=NO, =BLANK, Size: 3 |
|
15=Works Pro-D [Y/N] |
ASSIGNMENTS |
PRO_DEVELOPMENT_YN |
Internal Lookup: Y=YES, N=NO, =BLANK, Size: 5 |
|
16=School Term [Y/N] |
ASSIGNMENTS |
SCHOOL_TERM_YN |
Internal Lookup: Y=YES, N=NO, =BLANK, Size: 4 |
|
17=Payroll I.D. |
ASSIGNMENTS |
PAYROLL ID DESCRIPTION |
Detailed Explanation of code. Size: 30 |
|
17=Payroll I.D. |
ASSIGNMENTS |
PAYROLL_ID |
Size: 4 |
|
30=Authorizer Location |
ASSIGNMENTS |
AUTHORIZER_LOCATION |
A series of letters or numbers assigned to represent the authorizing location of the assignment Size: 4 |
|
30=Authorizer Location |
ASSIGNMENTS |
AUTHORIZER_LOCATION_NAME |
A detailed explanation of the authorizing location Size: 30 |
Assignment Posting, Department and Replacing Employee
|
Field in atrieveERP |
Report Writer Table |
Report Writer Field |
Field Information |
|---|---|---|---|
|
06=Posting Number |
ASSIGNMENTS |
POSTING_DESCRIPTION |
Detailed Explanation of code. Size: 30 |
|
06=Posting Number |
ASSIGNMENTS |
POSTING_NO |
Size: 10 |
|
07=Department |
ASSIGNMENTS |
DEPARTMENT CODE |
Size: 9 |
|
07=Department |
ASSIGNMENTS |
DEPARTMENT DESCRIPTION |
Detailed Explanation of code. Size: 30 |
|
08=Emp Replacing |
ASSIGNMENTS |
REPLACING_EMPLOYEE |
Size: 10 |
|
08=Emp Replacing |
ASSIGNMENTS |
REPLACING_EMPLOYEE_NAME |
Size: 30 |
|
09=Number of Days |
ASSIGNMENTS |
NUMBER_OF_DAYS |
Size: 4 Format: ######.#### |
Assignment Schedule
|
Field in atrieveERP |
Report Writer Table |
Report Writer Field |
Field Information |
|---|---|---|---|
|
Schedule Screen |
ASSIGNMENTS |
* SCHEDULE |
Size: 10 |
|
Schedule Screen |
ASSIGNMENTS |
* SCHEDULE DESCRIPTION |
Detailed Explanation of code. Size: 30 |
Assignment Tracking / Schedule Changes
|
Field in atrieveERP |
Report Writer Table |
Report Writer Field |
Field Information |
|---|---|---|---|
|
11=Unit Type |
SCHEDULE |
HOURS_OR_FTE |
Size: 10 Format: ########.## |
|
Date Schedule Assigned |
SCHEDULE |
SCHEDULE_DATE |
Size: 11 Format: DD-MMM-YYYY |
|
Date when schedule was changed |
SCHEDULE |
LAST_UPDATED_DATE |
via Schedule Entry Web Size: 11 Format: DD-MMM-YYYY |
|
Day |
SCHEDULE |
DAY_OF_WEEK |
Indicates which day of the week that assignment takes place Size: 12 |
|
En. Break |
SCHEDULE |
BREAK_END_TIME |
Size: 6 |
|
End Time |
SCHEDULE |
END_TIME |
Size: 6 |
|
Location |
SCHEDULE |
SCHEDULE_LOCATION_CODE |
Size: 10 |
|
Location Name |
SCHEDULE |
LOCATION_NAME |
Detailed Explanation of code. Size: 30 |
|
Name of user who made the last schedule change |
SCHEDULE |
LAST_UPDATED_USER |
via Schedule Entry Web Size: 30 |
|
St. Break |
SCHEDULE |
BREAK_START_TIME |
Size: 6 |
|
Start |
SCHEDULE |
START_TIME |
Size: 6 |
|
Time that the schedule was changed |
SCHEDULE |
LAST_UPDATED_TIMESTAMP |
via Schedule Entry Web Size: 14 Format: DD-MMM-YYYY H |
Assignment Tracking / Skills
|
Field in atrieveERP |
Report Writer Table |
Report Writer Field |
Field Information |
|---|---|---|---|
|
01=Skill |
ASSIGNMENTS |
SKILL_01 |
Size: 10 |
|
02=Skill |
ASSIGNMENTS |
SKILL_02 |
Size: 10 |
|
03=Skill |
ASSIGNMENTS |
SKILL_03 |
Size: 10 |
|
04=Skill |
ASSIGNMENTS |
SKILL_04 |
Size: 10 |
|
05=Skill |
ASSIGNMENTS |
SKILL_05 |
Size: 10 |
|
06=Skill |
ASSIGNMENTS |
SKILL_06 |
Size: 10 |
|
07=Skill |
ASSIGNMENTS |
SKILL_07 |
Size: 10 |
|
08=Skill |
ASSIGNMENTS |
SKILL_08 |
Size: 10 |
|
09=Skill |
ASSIGNMENTS |
SKILL_09 |
Size: 10 |
|
10=Skill |
ASSIGNMENTS |
SKILL_10 |
Size: 10 |
|
Skill Codes (01,02,03,04,05,06,07,08,09,10) |
ASSIGNMENTS |
ALL_TEN_SKILL_CODES |
Size: 40 |
|
Subjects (05,09,13,17,21,25,29,33,37,41) |
ASSIGNMENTS |
ALL_TEN_SUBJECT_CODES |
Size: 50 |
|
Subjects (05,09,13,17,21,25,29,33,37,41) |
ASSIGNMENTS |
ALL_TEN_SUBJECT_DESCS |
Detailed Explanation of code. Size: 50 |
|
Subjects (05->41), FTE (07->43) |
ASSIGNMENTS |
ALL_TEN_SUBJECT_CODES_WITH_FTE |
Size: 50 |
|
Subjects (05->41), FTE (07->43) |
ASSIGNMENTS |
ALL_TEN_SUBJECT_DESCS_WITH_FTE |
Detailed Explanation of code. Size: 50 |
|
Subjects (05->41), Levels (06->42) |
ASSIGNMENTS |
ALL_TEN_SUB_LEV_CODES |
Size: 50 |
|
Subjects (05->41), Levels (06->42) |
ASSIGNMENTS |
ALL_TEN_SUB_LEV_DESCS |
Detailed Explanation of code. Size: 50 |
Assignment Tracking / Timestamp
|
Field in atrieveERP |
Report Writer Table |
Report Writer Field |
Field Information |
|---|---|---|---|
|
Timestamp |
ASSIGNMENTS |
TIMESTAMP |
Size: 20 Format: DD-MMM-YYYY H |