Table Definitions - Assignment Tracking
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 |