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.
|