| export_hdr_id |
|
int |
N |
A unique sequence number serves as the primary key for the row. |
| export_hdr_status |
|
smallint |
N |
Status of the export document. |
| user_id |
alts_timesheet - user_id |
Int |
Y |
The Infor Expense Management userid of the Timesheet owner. |
| export_create_date |
|
datetime |
N |
The date/time that the export of the document was created (the row was inserted into this table). This is not to be confused with the document create time. |
| work_item_id |
alwf_work_item - work_item_id |
Int |
N |
The BOb ID of the work item associated with the document in the alwf_work_item table. |
| document_id |
alwf_work_item - document_id |
VARCHAR (255) |
N |
The Timesheet document ID or tracking number. |
| Title |
alts_timesheet - ts_title |
VARCHAR (255) |
N |
Timesheet document title, usually a range of dates. |
| start_date |
alts_timesheet - period_start |
datetime |
N |
Start of time period this document describes. |
| end_date |
alts_timesheet - period_end |
datetime |
N |
End of time period this document describes. |
| report_period |
alts_timesheet - alts_report_period. |
VARCHAR (255) |
Y |
Timesheet reporting period type; for example, bi-weekly, etc. |
| create_date |
alts_timesheet - date_created |
datetime |
Y |
Date user created the timesheet document. |
| submit_date |
alts_timesheet - date_submitted |
datetime |
Y |
Date user submitted document. |
| approved_date |
alts_timesheet - date_approved |
datetime |
Y |
Date manager approved document. |
| total_hours |
alts_timesheet - total_hours |
NUMERIC (20,10) |
N |
Total hours charged for in this timesheet document. |
| attendance_overtime |
alts_timesheet - ts_attendance_ overtime |
NUMERIC (20,10) |
Y |
Overtime in attendance tab. |
| attendance_double_time |
alts_timesheet -ts_attendance_double_ time |
NUMERIC (20,10) |
Y |
Double time in attendance tab. |
| emp_status |
alco_employment_ status |
VARCHAR (255) |
Y |
Reference through alts_user_attributes. emp_status_id This TS user's employment status: full time, part time |
| emp_labor_status |
alco_labor_status |
VARCHAR (255) |
Y |
Reference through alts_user_attributes. labor_status_id. This TS user's labor status: exempt, non-exempt |
| tax_location |
alco_location Bob element: Location.locationName |
VARCHAR (255) |
Y |
Reference through alts_user_attributes. location_id. This timesheet user's default tax location |
| employee_number |
alco_user - employee_number |
VARCHAR (255) |
Y |
User employee number |
| user_login |
alco_user - user_login |
VARCHAR (255) |
Y |
User login |
| user_full_name |
alco_user - user_full_name |
VARCHAR (255) |
Y |
User full name |
| user_location |
alco_user - user_location |
VARCHAR (255) |
Y |
User location |
| user_telephone |
alco_user - user_telephone |
VARCHAR (255) |
Y |
User telephone |
| user_mailstop |
alco_user - user_mailstop |
VARCHAR (255) |
Y |
User mailstop |
| user_email_address |
alco_user - user_email_address |
VARCHAR (255) |
Y |
User email address |
| user_ssn |
alco_user - user_ssn |
VARCHAR (255) |
Y |
User social security number |
| user_cost_center_ name |
alco_cost_center - cost_center_name |
VARCHAR (255) |
Y |
User default cost center name |
| user_cost_center_ code |
alco_cost_center - cost_center_code |
VARCHAR (255) |
Y |
User default cost center code |
| user_company_name |
alco_company - company_name |
VARCHAR (255) |
Y |
Company name of default cost center of the user |
| user_division_name |
alco_division - division_name |
VARCHAR (255) |
Y |
Division name of default cost center of the user |
| user_department_ name |
alco_department - department_name |
VARCHAR (255) |
Y |
Department name of default cost center of the user. |
| user_company_code |
alco_company - company_code |
VARCHAR (255) |
Y |
Company code of default cost center of the user |
| user_division_code |
alco_division - division_code |
VARCHAR (255) |
Y |
Division code of default cost center of the user |
| user_department_ code |
alco_department - department_code |
VARCHAR (255) |
Y |
Department code of default cost center of the user |
| user_country_ISO |
alco_user - country_id |
VARCHAR (255) |
Y |
Default country of the user. Derived from the table of alco_country, country_code_iso column |
| EXPORT_HDR_STATUS_ TIMESTAMP |
|
datetime |
Y |
The datetime when the status is updated. When this row is initially inserted, this field is same as the export_create_date. The Document Purge process uses this column to determine if the document can be purged. |
| MGR_PREAPPROVED_OT |
|
int |
Y |
Indicates whether the manager has pre-approved the overtime creator reported.
|
| TS_ATTENDANCE_ TRIPLE_TIME |
alts_timesheet -ts_attendance_triple_ time |
NUMERIC (7,2) |
Y |
Triple time in attendance tab. |
| TS_PROJECT_TRIPLE_ TIME |
alts_timesheet - ts_project_triple_time |
NUMERIC (7,2) |
Y |
Triple time in project tab. |
| TS_WORK_SCHEDULE |
alts_work_schedule - work_sched_name |
VARCHAR (255) |
N |
The timesheet work schedule name of the user. Reference from: ALTS_TIMESHEET.WORK_SCHED_ID. For example, Weekly-STD-5/40 |
| TS_PROFILE_NAME |
alts_timesheet_profile - name |
VARCHAR (255) |
N |
The timesheet profile name of the user. Reference from: ALTS_USER_ATTRIBUTES.TS_PROFILE_ID. For example, STD_Exempt |
| user_ekey |
alts_timesheet - user_id |
VARCHAR (255) |
Y |
External key that identifies the user/owner of the timesheet. |
| report_period_ekey |
alts_timesheet_profile - report_period_id |
VARCHAR (255) |
Y |
External key identifying the report period for the user. |
| emp_status_ekey |
alts_user_attributes - emp_status_id |
VARCHAR (255) |
Y |
External key identifying the employment status for the user. |
| emp_labor_status_ ekey |
alts_user_attributes - labor_status_id |
VARCHAR (255) |
Y |
External key identifying the labor status for the user. |
| tax_location_ekey |
alts_user_attributes - location_id |
VARCHAR (255) |
Y |
External key identifying the tax location for the user. |
| ts_work_schedule_ ekey |
alts_timesheet_profile - work_sched_id |
VARCHAR (255) |
Y |
External key identifying the work schedule for the user. |
| ts_profile_ekey |
alts_user_attributes - ts_profile_id |
VARCHAR (255) |
Y |
External key identifying the timesheet profile for the user. |
| OVERTIME_PAYCODE |
Alts_hourly_charge_ type - paycode |
VARCHAR (60) |
Y |
The paycode associated with the overtime type. |
| DOUBLE_TIME_PAYCODE |
Alts_hourly_charge_type - paycode |
VARCHAR (60) |
Y |
The paycode associated with the double time type. |
| TRIPLE_TIME_PAYCODE |
Alts_hourly_charge_ type - paycode |
VARCHAR (60) |
Y |
The paycode associated with the triple time type. |
| project_overtime |
alts_timesheet - ts_project_overtime |
NUMERIC (20,10) |
Y |
Overtime in project tab. |
| project_double_time |
alts_timesheet -ts_project_double_time |
NUMERIC (20,10) |
Y |
Double time in project tab. |
| USER_PAYROLL_ SYSTEM_CODE |
alco_user.payroll_ system_code |
VARCHAR (255) |
Y |
The payroll system code of the user. |
| EMP_JOB_CLASS |
alts_user_attributes - job_class_id |
VARCHAR (255) |
Y |
The job classification of the user. |
| EMP_JOB_CLASS_EKEY |
alts_user_attributes - job_class_id |
|
|
External key of employee's job classification. |
| USER_SEGMENT1_NAME |
alco_cost_center_segment - segment_name |
VARCHAR(255) |
Y |
Segment 1 name of user default cost center |
| USER_SEGMENT1_CODE |
alco_cost_center_segment - segment_code |
VARCHAR(255) |
Y |
Segment 1 code of user default cost center |
| USER_SEGMENT2_NAME |
alco_cost_center_segment - segment_name |
VARCHAR(255) |
Y |
Segment 2 name of user default cost center |
| USER_SEGMENT2_CODE |
alco_cost_center_segment - segment_code |
VARCHAR(255) |
Y |
Segment 2 code of user default cost center |
| USER_SEGMENT3_NAME |
alco_cost_center_segment - segment_name |
VARCHAR(255) |
Y |
Segment 3 name of user default cost center |
| USER_SEGMENT3_CODE |
alco_cost_center_segment - segment_code |
VARCHAR(255) |
Y |
Segment 3 code of user default cost center |
| USER_SEGMENT4_NAME |
alco_cost_center_segment - segment_name |
VARCHAR(255) |
Y |
Segment 4 name of user default cost center |
| USER_SEGMENT4_CODE |
alco_cost_center_segment - segment_code |
VARCHAR(255) |
Y |
Segment 4 code of user default cost center |
| USER_SEGMENT5_NAME |
alco_cost_center_segment - segment_name |
VARCHAR(255) |
Y |
Segment 5 name of user default cost center |
| USER_SEGMENT5_CODE |
alco_cost_center_segment - segment_code |
VARCHAR(255) |
Y |
Segment 5 code of user default cost center |
| USER_SEGMENT6_NAME |
alco_cost_center_segment - segment_name |
VARCHAR(255) |
Y |
Segment 6 name of user default cost center |
| USER_SEGMENT6_CODE |
alco_cost_center_segment - segment_code |
VARCHAR(255) |
Y |
Segment 6 code of user default cost center |
| USER_SEGMENT7_NAME |
alco_cost_center_segment - segment_name |
VARCHAR(255) |
Y |
Segment 7 name of user default cost center |
| USER_SEGMENT7_CODE |
alco_cost_center_segment - segment_code |
VARCHAR(255) |
Y |
Segment 7 code of user default cost center |
| USER_SEGMENT8_NAME |
alco_cost_center_segment - segment_name |
VARCHAR(255) |
Y |
Segment 8 name of user default cost center |
| USER_SEGMENT8_CODE |
alco_cost_center_segment - segment_code |
VARCHAR(255) |
Y |
Segment 8 code of user default cost center |
| USER_SEGMENT9_NAME |
alco_cost_center_segment - segment_name |
VARCHAR(255) |
Y |
Segment 9 name of user default cost center |
| USER_SEGMENT9_CODE |
alco_cost_center_segment - segment_code |
VARCHAR(255) |
Y |
Segment 9 code of user default cost center |
| SEGMENT_COUNT |
alco_cost_center_config - segment_count |
INTEGER |
Y |
The number of segments in this document owner's cost center. |
| USER_REVIEW_SEGMENT_NAME |
alco_cost_center_rev_segment - segment_name |
VARCHAR(255) |
Y |
The review segment name of this document owner's cost center. |
| USER_REVIEW_SEGMENT_CODE |
alco_cost_center_rev_segment - segment_code |
VARCHAR(255) |
Y |
The review segment code of this document owner's cost center. |