ALTS_EXPORT_HEADER (Attributes)

Column Source Data type Null Description
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.
  • 0 - No
  • 1 - Yes
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.